/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 vote334 views1 answer
Create function in microsoft sql server
SQL
1 vote342 views2 answers
Postgresql truncate cascade restart identity
SQL
0 vote310 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
0 vote314 views1 answer
Oracle drop default value
SQL
29 votes328 views5 answers
Mysql show table structure
SQL
-1 vote313 views1 answer
MySQL said: Documentation #1010 - Error dropping database errno: 39 "Directory not empty")
SQL
0 vote343 views1 answer
Postgresql linux password
SQL
0 vote308 views1 answer
Minecraft duping allowed servers
SQL
0 vote310 views1 answer
Get time component of datetime sql
SQL
-1 vote300 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL