]>
iEval git - app-web-oof.git/blob - db.sql
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 (
21 products JSON
NOT NULL,
23 discount
VARCHAR(20) REFERENCES discounts
UNIQUE,
28 first_name
VARCHAR(20) NOT NULL,
29 last_name
VARCHAR(20) NOT NULL,
30 email
VARCHAR(80) NOT NULL,
32 postcode
VARCHAR(10) NOT NULL,
33 address1
VARCHAR(32) NOT NULL,
37 safe_place
VARCHAR(32),
38 instructions
VARCHAR(32)
This page took 0.040876 seconds and 4 git commands to generate.