상품구매
테이블 (3)
member
- seq — BIGINT
- user_id — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- user_type — ENUM('BUYER', 'SELLER') — NOT NULL
- created_at — DATETIME
product
- seq — BIGINT
- name — VARCHAR(100) — NOT NULL
- quantity — INT — NOT NULL
- is_sold — BOOLEAN — NOT NULL
- seller_seq — BIGINT — NOT NULL
- created_at — DATETIME
product_purchase
- seq — BIGINT
- buyer_seq — BIGINT — NOT NULL
- product_seq — BIGINT — NOT NULL
- purchase_quantity — INT — NOT NULL
- purchased_at — DATETIME