hhplus_2week

Tables (5)

tb_special_class

  • id — bigint — Primary key — NOT NULL
  • name — varchar(255)
  • teacher — varchar(255)

tb_special_class_inventory

  • id — bigint — Primary key — NOT NULL
  • current_headcount — bigint
  • class_id — bigint — Foreign key → tb_special_class.id — NOT NULL
  • item_id — bigint — Foreign key → tb_special_class_item.id — NOT NULL

tb_special_class_item

  • id — bigint — Primary key — NOT NULL
  • class_id — bigint — Foreign key → tb_special_class.id — NOT NULL
  • open_date — timestamp(6)
  • total_headcount — bigint

tb_special_enrolment

  • id — bigint — Primary key — NOT NULL
  • class_item_id — bigint — Foreign key → tb_special_class_item.id — NOT NULL
  • user_id — bigint — Foreign key → tb_user.id — NOT NULL
  • enrol_time — bigint

tb_user

  • id — bigint — Primary key — NOT NULL
  • mobile — varchar(255)
  • name — varchar(255)