Yurttas/PL/DBL/mysql-f-2010/01/BankTwo/Borrower-cre.sql
Revision as of 01:55, 4 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div">→REM REM REM Borrower-cre.sql REM REM: \. set-db.sql CREATE TABLE Borrower(branchname VARCHAR(16) NOT NULL, ...")
1/*
2REM
3REM
4REM Borrower-cre.sql
5REM
6REM
7*/
8
9\. set-db.sql
10
11CREATE TABLE Borrower(branchname VARCHAR(16) NOT NULL,
12 loannumber INTEGER NOT NULL,
13 customername VARCHAR(16) NOT NULL,
14 amount INTEGER,
15 PRIMARY KEY(loannumber),
16 FOREIGN KEY(branchname) REFERENCES Branch(branchname),
17 FOREIGN KEY(customername) REFERENCES Customer(customername));