/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

5 votes307 views1 answer
Postgres upsert
SQL
0 vote363 views1 answer
Mysql grant grant option
SQL
1 vote357 views1 answer
Influxdb export to csv
SQL
0 vote337 views1 answer
Default password for mysql_secure_installation in mac
SQL
0 vote340 views1 answer
Oracle synonym procedure dblink
SQL
1 vote361 views1 answer
Sql order by where condition
SQL
1 vote365 views2 answers
Logical operators in sql
SQL
2 votes348 views1 answer
Oracle apex list connected users
SQL
0 vote346 views1 answer
Rename view mysql
SQL
1 vote348 views1 answer
Float precision in psql
SQL