b9gGg5rv

1CREATE TABLE IF NOT EXISTS vendors
2(
3    id   BIGSERIAL PRIMARY KEY,
4    name VARCHAR(30) UNIQUE NOT NULL
5);
6
7CREATE TABLE IF NOT EXISTS categories
8(
9    id        BIGSERIAL PRIMARY KEY,
10    vendor_id BIGINT REFERENCES vendors (id) NOT NULL,
11    parent_id BIGINT REFERENCES categories(id) NOT NULL 
12);
13
14CREATE TABLE IF NOT EXISTS products
15(
16    id          BIGSERIAL PRIMARY KEY,
17    name        VARCHAR(30)                       NOT NULL,
18    price       NUMERIC(15, 2)                    NOT NULL,
19    category_id BIGINT REFERENCES categories (id) NOT NULL
20);