Lecture/데이터베이스/2006/Schema 생성

CREATE TABLE customer
	(customer_name CHAR(20),
	 customer_street CHAR(30),
	 customer_city CHAR(30),
	 PRIMARY KEY (customer_name));
 
CREATE TABLE branch
	(branch_name	CHAR(15),
	 branch_city	CHAR(30),
	 assets		NUMERIC(16,2),
	 PRIMARY KEY (branch_name));
 
CREATE TABLE depositor
	(customer_name	CHAR(20),
	 account_number	CHAR(10),
	 PRIMARY KEY (customer_name, account_number));
 
CREATE TABLE loan
	(loan_number	CHAR(10),
	 branch_name	CHAR(15),
	 amount		NUMERIC(12,2),
	 PRIMARY KEY (loan_number));
 
CREATE TABLE borrower
	(customer_name	CHAR(20),
	 loan_number	CHAR(10),
	 PRIMARY KEY (customer_name, loan_number));