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)