TEST
Tables (3)
Employee
- emp_id — BIGSERIAL
- emp_name — VARCHAR(30) — NOT NULL
- dept — VARCHAR(50)
- salary — NUMERIC
- hire_date — DATE
Orders
- order_id — BIGSERIAL
- member_id — VARCHAR(20)
- product_id — BIGINT — Foreign key → Product.product_id
- order_date — DATE
Product
- product_id — BIGSERIAL
- product_name — VARCHAR(100) — NOT NULL
- price — NUMERIC
- stock — INT
- category — VARCHAR(30)