asd

Tables (4)

ADMIN (관리자)

  • 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

CUSTOMER (고객)

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

ORDERS (주문)

  • id — BIGINT
  • order_number — VARCHAR(50)
  • quantity — BIGINT
  • total_price — BIGINT
  • status — VARCHAR(20)
  • cancel_reason — VARCHAR(255)
  • customer_id — BIGINT — Foreign key → CUSTOMER.id
  • product_id — BIGINT — Foreign key → PRODUCT.id
  • admin_id — BIGINT — Foreign key → ADMIN.id
  • created_at — DATETIME
  • modified_at — DATETIME
  • order_price — BIGINT

PRODUCT (상품)

  • id — BIGINT
  • name — VARCHAR(100)
  • category — VARCHAR(50)
  • price — BIGINT
  • stock — BIGINT
  • status — VARCHAR(20)
  • admin_id — BIGINT — Foreign key → ADMIN.id
  • created_at — DATETIME
  • modified_at — DATETIME