/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

8 votes386 views1 answer
My sql version
SQL
1 vote343 views1 answer
Not exists mysql
SQL
0 vote352 views1 answer
Mysql workbench primary key
SQL
0 vote405 views1 answer
How to set up an anonymous function to variable in swift
SQL
-1 vote344 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
5 votes352 views1 answer
Mysql get last day of month
SQL
1 vote344 views1 answer
Oracle stop job
SQL
0 vote357 views1 answer
Mysql coonect sample code
SQL
0 vote352 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
2 votes344 views6 answers
In in sql
SQL