/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   );