/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

0 vote108 views1 answer
Migration graphql
SQL
5 votes98 views1 answer
Invalid column name sql
SQL
0 vote117 views1 answer
Sql delete caracter list
SQL
0 vote100 views1 answer
Sql case when exists in another table
SQL
-1 vote59 views1 answer
MySQL said: Documentation #1010 - Error dropping database errno: 39 "Directory not empty")
SQL
0 vote119 views1 answer
Command to give readonly access to a postgres sql user
SQL
6 votes100 views5 answers
Mysql get last insert id
SQL
0 vote115 views1 answer
Add sqlcmd to path linux
SQL
0 vote94 views1 answer
R2dbc-postgresqldriver dependency
SQL
0 vote104 views1 answer
Find usage of table in sql server
SQL