Yurttas/PL/DBL/mysql/F/01/00/Company-A/WorksOn-cre.sql
Revision as of 16:16, 3 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div">→REM REM REM WorksOn-cre.sql REM REM: \. set-db.sql CREATE TABLE WorksOn(essn CHAR(9) NOT NULL, ...")
1/*
2REM
3REM
4REM WorksOn-cre.sql
5REM
6REM
7*/
8
9\. set-db.sql
10
11CREATE TABLE WorksOn(essn CHAR(9) NOT NULL,
12 pno INTEGER NOT NULL,
13 hours FLOAT NOT NULL,
14 PRIMARY KEY(essn, pno),
15 FOREIGN KEY(essn) REFERENCES Employee(ssn),
16 FOREIGN KEY(pno) REFERENCES Project(pnumber));