]>
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 CONSTRAINT positive_stock
CHECK (stock
>= 0)
11 CREATE TABLE IF NOT EXISTS discounts (
12 discount
VARCHAR(20) PRIMARY KEY,
15 CONSTRAINT fraction_xor_flat
CHECK ((fraction
IS NULL AND flat
IS NOT NULL) OR (fraction
IS NOT NULL AND flat
IS NULL))
18 CREATE TABLE IF NOT EXISTS orders (
20 products JSON
NOT NULL,
22 discount
VARCHAR(20) REFERENCES discounts
UNIQUE,
27 first_name
VARCHAR(20) NOT NULL,
28 last_name
VARCHAR(20) NOT NULL,
29 email
VARCHAR(80) NOT NULL,
31 postcode
VARCHAR(10) NOT NULL,
32 address1
VARCHAR(32) NOT NULL,
36 safe_place
VARCHAR(32),
37 instructions
VARCHAR(32)
This page took 0.037928 seconds and 4 git commands to generate.