Yurttas/PL/DBL/mssql/F/01/Bank/Borrower-cre.sql

 1/*
 2REM
 3REM
 4REM Borrower-cre.sql
 5REM
 6REM
 7*/
 8
 9CREATE TABLE Borrower(branchname VARCHAR(16) NOT NULL,
10                      loannumber INTEGER NOT NULL,
11                      customername VARCHAR(16) NOT NULL,
12                      amount INTEGER,
13          PRIMARY KEY(loannumber),
14          FOREIGN KEY(branchname) REFERENCES Branch(branchname),
15          FOREIGN KEY(customername) REFERENCES Customer(customername));