/SQL/Postgresql create table many-to-many

Postgresql create table many-to-many

CREATE TABLE product (
  product_id serial PRIMARY KEY  -- implicit primary key constraint
, product    text NOT NULL
, price      numeric NOT NULL DEFAULT 0
);

CREATE TABLE bill (
  bill_id  serial PRIMARY KEY
, bill     text NOT NULL
, billdate date NOT NULL DEFAULT CURRENT_DATE
);

CREATE TABLE bill_product (
  bill_id    int REFERENCES bill (bill_id) ON UPDATE CASCADE ON DELETE CASCADE
, product_id int REFERENCES product (product_id) ON UPDATE CASCADE
, amount     numeric NOT NULL DEFAULT 1
, CONSTRAINT bill_product_pkey PRIMARY KEY (bill_id, product_id)  -- explicit pk
);

Source: stackoverflow.com

Similar codes

24 votes247 views5 answers
Import dump mysql
SQL
0 vote243 views1 answer
Flexible search query delete table
SQL
5 votes237 views1 answer
Mysql created at yesterdau
SQL
0 vote251 views1 answer
Sqlalchemy orm duplicate
SQL
10 votes189 views2 answers
Django mysql
SQL
15 votes251 views4 answers
Mysql where value is null
SQL
1 vote221 views1 answer
GROUP BY clause; this is incompati
SQL
0 vote238 views1 answer
Except in sql
SQL
0 vote231 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
2 votes241 views3 answers
Mysql list tables by size
SQL