Difference between revisions of "Yurttas/PL/DBL/mysql/F/01/00/bank/BankTwo/Depositor-cre.sql"
Jump to navigation
Jump to search
(Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div">→REM REM REM Depositor-cre.sql REM REM: \. set-db.sql CREATE TABLE Depositor(branchname VARCHAR(16) NOT NULL, ...") |
(No difference)
|
Latest revision as of 16:08, 3 November 2013
1/*
2REM
3REM
4REM Depositor-cre.sql
5REM
6REM
7*/
8
9\. set-db.sql
10
11CREATE TABLE Depositor(branchname VARCHAR(16) NOT NULL,
12 accountnumber INTEGER NOT NULL,
13 customername VARCHAR(16) NOT NULL,
14 balance INTEGER,
15 PRIMARY KEY(accountnumber),
16 FOREIGN KEY(branchname) REFERENCES Branch(branchname),
17 FOREIGN KEY(customername) REFERENCES Customer(customername));