aY8GqBNq

1DROP TABLE IF EXISTS CUSTOMER CASCADE ;
2DROP TABLE IF EXISTS PRODUCT CASCADE ;
3DROP TABLE IF EXISTS ORDER_N CASCADE ;
4
5
6CREATE TABLE IF NOT EXISTS customer (
7cid serial,
8cname varchar(42),
9country varchar(80),
10PRIMARY KEY (cid));
11
12CREATE TABLE IF NOT EXISTS product (
13pid serial,
14pname varchar(42),
15pdesc varchar(80),
16PRIMARY KEY (pid)
17);
18			 
19CREATE TABLE IF NOT EXISTS order_n (
20cid serial REFERENCES customer(cid) ON UPDATE CASCADE ON DELETE CASCADE ,
21pid serial REFERENCES product(pid) ON UPDATE CASCADE ON DELETE CASCADE ,
22qty int,
23PRIMARY KEY (pid, cid)
24);