خطأ Ora-02270

متابعين

بتاريخ: 24 أبريل 201510 سنة



CREATE TABLE saleman(

sssn INTEGER PRIMARY KEY,

Sex CHAR,

DOB DATE,

EmploymentDate DATE,

PhoneNumber INTEGER,

Certfication VARCHAR(20) NOT NULL,

Salary INTEGER NOT NULL

);





CREATE TABLE warehouse(

warehouse_name VARCHAR(20) ,

location VARCHAR(20) NOT NULL,

storage_type VARCHAR(20) NOT NULL,

wmssn INTEGER NOT NULL,

supname VARCHAR2(20),

quantity INTEGER,

PRIMARY KEY(warehouse_name,location),

FOREIGN KEY (wmssn) references manager (mssn),

FOREIGN KEY (supname) references suplayer (supname)

);



CREATE TABLE Product (

product_id INTEGER NOT NULL,

product_name VARCHAR2(20),

arrive_date DATE ,

exp_date DATE ,

warehousename VARCHAR2(20) NOT NULL,

psssn INTEGER NOT NULL,

PRIMARY KEY(product_id),

FOREIGN KEY(psssn) REFERENCES saleman(sssn),

FOREIGN KEY(warehousename) REFERENCES warehouse(warehouse_name));