Yurttas/PL/DBL/mssql/F/01/SPJ/C-all.sql

 1/*
 2REM
 3REM C-all.sql
 4REM
 5REM Create yurttas-SPJ tables.
 6REM
 7*/
 8
 9/*
10REM
11REM
12REM Suppliers-cre.sql
13REM
14REM
15*/
16
17CREATE TABLE Suppliers(sn VARCHAR(4) NOT NULL,
18                       sname VARCHAR(16),
19                       status INTEGER,
20                       city VARCHAR(16),
21           PRIMARY KEY(sn));
22
23
24/*
25REM
26REM
27REM Parts-cre.sql
28REM
29REM
30*/
31
32CREATE TABLE Parts(pn VARCHAR(4) NOT NULL,
33                   pname VARCHAR(12),
34                   color VARCHAR(8),
35                   weight INTEGER,
36                   city VARCHAR(16),
37       PRIMARY KEY(pn));
38
39
40/*
41REM
42REM
43REM Projects-cre.sql
44REM
45REM
46*/
47
48CREATE TABLE Projects(jn VARCHAR(4) NOT NULL,
49                      jname VARCHAR(16),
50                      city VARCHAR(16),
51          PRIMARY KEY(jn));
52
53
54/*
55REM
56REM
57REM Shipments-cre.sql
58REM
59REM
60*/
61
62CREATE TABLE Shipments(sn VARCHAR(4) NOT NULL,
63                       pn VARCHAR(4) NOT NULL,
64                       jn VARCHAR(4) NOT NULL,
65                       quantity INTEGER,
66           PRIMARY KEY(sn,pn,jn));