Create 2 PostgreSQL tables with numeric precision with foreign key linking ```psql CREATE TABLE pricelist ( id integer CONSTRAINT fk_pl PRIMARY key GENERATED BY DEFAULT AS IDENTITY, name varchar(50) NOT null default '' ); ``` ## Table price what is linked to pricelist via the column pricelist->id keys ```psl CREATE TABLE price ( id integer CONSTRAINT fk_p PRIMARY key GENERATED BY DEFAULT AS IDENTITY, pricelist integer REFERENCES pricelist (id), from_qty integer NOT null default 0, price_usd NUMERIC(10,2) NOT null default 0, price_usd_excl_surg NUMERIC(10,2) NOT null default 0 ); ```

https://www.postgresql.org/docs/current/datatype-numeric.html

CREATE TABLE price ( id integer CONSTRAINT fk_p PRIMARY key GENERATED BY DEFAULT AS IDENTITY, style_id integer REFERENCES style (id), pricelist_id integer REFERENCES pricelist (id), from_qty integer NOT null default 0, price_usd NUMERIC(10,2) NOT null default 0, price_usd_excl_surg NUMERIC(10,2) NOT null default 0 ); 26.12.24 CREATE TABLE style ( id integer CONSTRAINT fk_s PRIMARY key GENERATED BY DEFAULT AS IDENTITY, style varchar(100) not null unique default '' ); 26.12.24

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024