Difference between revisions of "Yurttas/PL/DBL/mysql/F/01/00/Company-A/WorksOn-cre.sql"
Jump to navigation
Jump to search
(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, ...") |
(No difference)
|
Latest revision as of 16:16, 3 November 2013
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));