fitness
Tables (4)
class
- class_id — BIGINT — Primary key
- trainer_id (trainer_id2) — BIGINT — Foreign key → trainer.trainer_id
- title — VARCHAR(100) — NOT NULL
- schedule_time — DATETIME — NOT NULL
enrollment
- enrollment_id — BIGINT — Primary key
- member_id (member_id2) — BIGINT — Foreign key → member.member_id
- class_id — BIGINT — Foreign key → class.class_id
- trainer_id (trainer_id2) — BIGINT — Foreign key → class.trainer_id
member
- member_id — BIGINT — Primary key
- name — VARCHAR(50) — NOT NULL
- phone — VARCHAR(20)
trainer
- trainer_id — BIGINT — Primary key
- name — VARCHAR(50) — NOT NULL
- specialty — VARCHAR(50)