Project
Tables (8)
BUYER
- buyer_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- address — TEXT — NOT NULL
- phone — VARCHAR(20)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
- is_deleted — BOOLEAN — NOT NULL
CATEGORY
- category_id — INT — Primary key — NOT NULL
- parent_id — INT — Foreign key → CATEGORY.category_id
- name — VARCHAR(50) — NOT NULL
- sort_order — INT — NOT NULL
ORDER
- order_id — BIGINT — Primary key — NOT NULL
- buyer_id — BIGINT — Foreign key → BUYER.buyer_id — NOT NULL
- total_amount — INT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
ORDER_ITEM
- order_item_id — BIGINT — Primary key — NOT NULL
- order_id — BIGINT — Foreign key → ORDER.order_id — NOT NULL
- product_id — BIGINT — Foreign key → PRODUCT.product_id — NOT NULL
- seller_id — BIGINT — Foreign key → SELLER.seller_id — NOT NULL
- quantity — INT — NOT NULL
- price — INT — NOT NULL
- shipping_fee — INT — NOT NULL
POST
- post_id — BIGINT — Primary key — NOT NULL
- buyer_id — BIGINT — Foreign key → BUYER.buyer_id
- post_type — VARCHAR(20) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- is_hidden — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
PRODUCT
- product_id — BIGINT — Primary key — NOT NULL
- seller_id — BIGINT — Foreign key → SELLER.seller_id — NOT NULL
- category_id — INT — Foreign key → CATEGORY.category_id — NOT NULL
- name — VARCHAR(200) — NOT NULL
- price — INT — NOT NULL
- stock — INT — NOT NULL
- defect_level — VARCHAR(10) — NOT NULL
- expiry_date — DATE
- discounted_price — INT
- sales_count — INT — NOT NULL
- is_hidden — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- is_deleted — BOOLEAN — NOT NULL
REVIEW
- review_id — BIGINT — Primary key — NOT NULL
- order_item_id — BIGINT — Foreign key → ORDER_ITEM.order_item_id — NOT NULL
- buyer_id — BIGINT — Foreign key → BUYER.buyer_id — NOT NULL
- product_id — BIGINT — Foreign key → PRODUCT.product_id — NOT NULL
- rating — TINYINT — NOT NULL
- content — TEXT
- photo_url — TEXT
- helpful_count — INT — NOT NULL
- ai_summary — TEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
SELLER
- seller_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- shop_name — VARCHAR(100) — NOT NULL
- biz_no — VARCHAR(20)
- farm_address — VARCHAR(255) — NOT NULL
- account_no — VARCHAR(50) — NOT NULL
- farm_description — TEXT
- farm_photo_url — TEXT
- total_sales_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- is_deleted — BOOLEAN — NOT NULL