DROP TABLE SUPPLIERS cascade; | |
DROP TABLE PARTS cascade; | |
CREATE TABLE PARTS ( | |
PARTID INT PRIMARY KEY, | |
NAME VARCHAR(15), | |
COLOR VARCHAR(20), | |
WEIGHT INT, | |
PRICE FLOAT | |
); | |
CREATE TABLE SUPPLIERS ( | |
PARTID INT NOT NULL REFERENCES PARTS(PARTID), | |
SUPPLIERID INT, | |
NAME VARCHAR(15), | |
STATUS INT, | |
CITY VARCHAR(50), | |
CONSTRAINT PK_SUPPLIERS primary key(SUPPLIERID, PARTID) | |
); | |
COMMIT; | |
quit; |