/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 vote153 views1 answer
Mariadb maximum left join
SQL
0 vote144 views1 answer
PG::ForeignKeyViolation: ERROR: update or delete on table violates foreign key constraint
SQL
0 vote214 views1 answer
Oracle plsql sleep
SQL
0 vote282 views1 answer
Oracle convert int to date
SQL
0 vote151 views2 answers
Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load
SQL
6 votes160 views3 answers
Mysql first day of year
SQL
3 votes183 views1 answer
Set default today mysql
SQL
2 votes202 views1 answer
Orcale index size
SQL
1 vote217 views1 answer
Find size of all DB's postgres
SQL
0 vote9.3K views1 answer
Postgresql delete type
SQL