ㅇㅇ
Tables (4)
order_items
- order_item_id — SERIAL
- order_id — INT — NOT NULL
- product_id — INT — NOT NULL
- quantity — INT — NOT NULL
- unit_price — DECIMAL(10, 2) — NOT NULL
orders
- order_id — SERIAL
- user_id — INT — NOT NULL
- order_date — TIMESTAMP
products
- product_id — SERIAL
- product_name — VARCHAR(100) — NOT NULL
- price — DECIMAL(10, 2) — NOT NULL
- stock — INT — NOT NULL
- seller_id — INT — NOT NULL
- created_at — TIMESTAMP
users
- user_id — SERIAL
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(100) — NOT NULL
- is_seller — BOOLEAN
- created_at — TIMESTAMP