backoffice

테이블 (4)

고객

  • id — BIGINT
  • name — VARCHAR(50)
  • email — VARCHAR(100)
  • phone_number — VARCHAR(20)
  • status — VARCHAR(20)
  • created_at — DATETIME
  • modified_at — DATETIME

관리자

  • id — BIGINT
  • name — VARCHAR(50)
  • email — VARCHAR(100)
  • password — VARCHAR(255)
  • phone_number — VARCHAR(20)
  • role — VARCHAR(20)
  • status — VARCHAR(20)
  • approved_at — DATETIME
  • rejected_at — DATETIME
  • rejection_reason — VARCHAR(255)
  • created_at — DATETIME
  • modified_at — DATETIME

상품

  • id — BIGINT
  • name — VARCHAR(100)
  • category — VARCHAR(50)
  • price — BIGINT
  • stock — BIGINT
  • status — VARCHAR(20)
  • admin_id — BIGINT
  • created_at — DATETIME
  • modified_at — DATETIME

주문

  • id — BIGINT
  • order_number — VARCHAR(50)
  • quantity — BIGINT
  • total_price — BIGINT
  • status — VARCHAR(20)
  • cancel_reason — VARCHAR(255)
  • customer_id — BIGINT
  • product_id — BIGINT
  • admin_id — BIGINT
  • created_at — DATETIME
  • modified_at — DATETIME
  • order_price — BIGINT