ㅗㅑ

Tables (9)

class_reservations

  • id — BIGINT
  • class_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • qty — TINYINT
  • payment_status — ENUM('PENDING','PAID','REFUNDED')
  • status — ENUM('RESERVED','CANCELLED')

classes

  • id — BIGINT
  • instructor_id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • price — DECIMAL(12,2) — NOT NULL
  • start_dt — DATETIME — NOT NULL
  • end_dt — DATETIME — NOT NULL
  • capacity — INT — NOT NULL
  • status — ENUM('SCHEDULED','CANCELLED','COMPLETED')
  • created_at — TIMESTAMP
  • INDEX — idx_instructor_time

mentoring_sessions

  • id — BIGINT
  • mentor_id — BIGINT — NOT NULL
  • mentee_id — BIGINT — NOT NULL
  • scheduled_at — DATETIME — NOT NULL
  • status — ENUM('REQUESTED','ACCEPTED','COMPLETED','CANCELLED')
  • rating — TINYINT
  • created_at — TIMESTAMP
  • INDEX — idx_mentor_status

product_images

  • id — BIGINT
  • product_id — BIGINT — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • sort_order — TINYINT
  • created_at — TIMESTAMP
  • INDEX — idx_product_order

product_options

  • product_id — BIGINT — Primary key — NOT NULL
  • opt_key — VARCHAR(50) — Primary key — NOT NULL
  • opt_val — VARCHAR(50) — Primary key — NOT NULL
  • extra_price — DECIMAL(12,2)
  • stock — INT

products

  • id — BIGINT
  • seller_id — BIGINT — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • category — ENUM('HANDCRAFT','DECOR','ACCESSORY','KITCHEN','STATIONERY')
  • price — DECIMAL(12,2) — NOT NULL
  • stock — INT
  • status — ENUM('DRAFT','ACTIVE','INACTIVE')
  • created_at — TIMESTAMP
  • INDEX — idx_seller_status

roles

  • id — TINYINT
  • name — VARCHAR(30)

user_roles

  • user_id — BIGINT — Primary key — NOT NULL
  • role_id — TINYINT — Primary key — NOT NULL

users

  • id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARBINARY(255)
  • name — VARCHAR(100) — NOT NULL
  • status — ENUM('ACTIVE','BANNED')
  • created_at — TIMESTAMP