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