price INT NOT NULL,
stock INT NOT NULL,
freepost BOOLEAN NOT NULL DEFAULT FALSE,
+ model TEXT,
+ brand TEXT,
CONSTRAINT positive_stock CHECK (stock >= 0)
);
CREATE TABLE IF NOT EXISTS orders (
id TEXT PRIMARY KEY,
+ date BIGINT NOT NULL,
products JSON NOT NULL,
total INT NOT NULL,
discount VARCHAR(20) REFERENCES discounts UNIQUE,