Yurttas/PL/DBL/mysql-f-2010/01/Company-A/Dependent-cre.sql
Revision as of 01:58, 4 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div">→REM REM REM Dependent-cre.sql REM REM: \. set-db.sql CREATE TABLE Dependent(essn CHAR(9) NOT NULL, ...")
1/*
2REM
3REM
4REM Dependent-cre.sql
5REM
6REM
7*/
8
9\. set-db.sql
10
11CREATE TABLE Dependent(essn CHAR(9) NOT NULL,
12 dependentname VARCHAR(16) NOT NULL,
13 sex CHAR,
14 bdate CHAR(9),
15 relationship VARCHAR(8),
16 PRIMARY KEY(essn, dependentname),
17 FOREIGN KEY(essn) REFERENCES Employee(ssn));