CREATE TABLE IF NOT EXISTS vendors
(
    id   BIGSERIAL PRIMARY KEY,
    name VARCHAR(30) UNIQUE NOT NULL
);

CREATE TABLE IF NOT EXISTS categories
(
    id        BIGSERIAL PRIMARY KEY,
    vendor_id BIGINT REFERENCES vendors (id) NOT NULL,
    parent_id BIGINT
);