Yurttas/PL/DBL/oracle/F/01/Company-B/Works-def.sql
Jump to navigation
Jump to search
1REM
2REM
3REM Works-def.sql
4REM
5REM
6
7CREATE TABLE Works (employeename VARCHAR2(16) NOT NULL,
8 companyname VARCHAR2(24) NOT NULL,
9 salary INTEGER,
10 PRIMARY KEY (employeename, companyname),
11 FOREIGN KEY (employeename) REFERENCES Employee(employeename),
12 FOREIGN KEY (companyname) REFERENCES Company(companyname));