6 lines
245 B
SQL
6 lines
245 B
SQL
CREATE TABLE IF NOT EXISTS stocks (
|
|
product_id UUID PRIMARY KEY REFERENCES products(id) ON DELETE CASCADE,
|
|
qty NUMERIC(12, 3) NOT NULL DEFAULT 0 CHECK (qty >= 0),
|
|
reserved_qty NUMERIC(12, 3) NOT NULL DEFAULT 0 CHECK (reserved_qty >= 0)
|
|
);
|