ex

Tables (7)

CATEGORY

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100)

COMMENT

  • id — BIGINT — Primary key — NOT NULL
  • review_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • content — TEXT
  • created_at — DATETIME

ORDER

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • order_number — VARCHAR(100)
  • order_date — DATETIME
  • status — VARCHAR(50)
  • total_amount — DECIMAL(10,2)

ORDER_ITEM

  • id — BIGINT — Primary key — NOT NULL
  • order_id — BIGINT — NOT NULL
  • product_id — BIGINT — NOT NULL
  • quantity — INT
  • price_at_purchase — DECIMAL(10,2)

PRODUCT

  • id — BIGINT — Primary key — NOT NULL
  • category_id — BIGINT — Foreign key → CATEGORY.id — NOT NULL
  • name — VARCHAR(255)
  • price — DECIMAL(10,2)
  • description — TEXT
  • stock_quantity — INT
  • rating_avg — FLOAT

REVIEW

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • product_id — BIGINT — NOT NULL
  • rating — INT
  • content — TEXT
  • created_at — DATETIME

USER

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100)
  • email — VARCHAR(255)
  • password — VARCHAR(255)
  • profile_image — VARCHAR(500)