b75393541c351806d651a4e6237061881a6b89a1
1 CREATE TABLE IF NOT EXISTS products (
2 product serial
PRIMARY KEY,
4 subtitle
TEXT NOT NULL,
8 freepost
BOOLEAN NOT NULL DEFAULT FALSE,
9 CONSTRAINT positive_stock
CHECK (stock
>= 0)
12 CREATE TABLE IF NOT EXISTS discounts (
13 discount
VARCHAR(20) PRIMARY KEY,
16 CONSTRAINT fraction_xor_flat
CHECK ((fraction
IS NULL AND flat
IS NOT NULL) OR (fraction
IS NOT NULL AND flat
IS NULL))
19 CREATE TABLE IF NOT EXISTS orders (
22 products JSON
NOT NULL,
24 discount
VARCHAR(20) REFERENCES discounts
UNIQUE,
29 first_name
VARCHAR(20) NOT NULL,
30 last_name
VARCHAR(20) NOT NULL,
31 email
VARCHAR(80) NOT NULL,
33 postcode
VARCHAR(10) NOT NULL,
34 address1
VARCHAR(32) NOT NULL,
38 safe_place
VARCHAR(32),
39 instructions
VARCHAR(32)
This page took 0.021376 seconds and 3 git commands to generate.