· 5 years ago · Apr 06, 2020, 01:52 PM
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
12);