/home/mario/oci/jnb/dataaccess/source/resources/postgresql/business_schema.sql
|
1 create table customer
2 (
3 id serial,
4 name varchar(64) not null,
5 CONSTRAINT customer_pk PRIMARY KEY (id)
6 );
7
8 create table orders
9 (
10 id serial,
11 customer integer not null,
12 CONSTRAINT order_pk PRIMARY KEY (id),
13 CONSTRAINT order_customer_fk FOREIGN KEY (customer) REFERENCES customer(id)
14 );
15
16 create table products
17 (
18 id serial,
19 name varchar(100) not null,
20 cost decimal(6,2),
21 CONSTRAINT products_pk PRIMARY KEY (id)
22 );
23
24 create table orderitems
25 (
26 id serial,
27 orders integer not null,
28 product integer not null,
29 quantity integer not null,
30 CONSTRAINT orderitems_pk PRIMARY KEY (id),
31 CONSTRAINT orderitems_orders_fk FOREIGN KEY (orders) REFERENCES orders(id),
32 CONSTRAINT orderitems_product_fk FOREIGN KEY (product) REFERENCES products(id)
33 );