연습
테이블 (4)
Class (Untitled2)
- ClassID (Key) — INT — 기본 키 — NOT NULL
- class_name (Field) — VARCHAR
- start_time (Field2) — TIME
- end_time (Field3) — TIME
- TrainerID (Key2) — INT — 외래 키 → Trainer.TrainerID — NOT NULL
Enrollment (Untitled4)
- EnrollmentID (Key) — INT — 기본 키 — NOT NULL
- MemberID (Key2) — INT — 외래 키 → Member.MemberID — NOT NULL
- ClassID (Key3) — INT — 외래 키 → Class.ClassID — NOT NULL
Member (Untitled)
- MemberID (Key) — INT — 기본 키 — NOT NULL
- name (Field) — VARCHAR
- address (Field2) — VARCHAR
- phone (Field3) — VARCHAR
Trainer (Untitled3)
- TrainerID (Key) — INT — 기본 키 — NOT NULL
- name (Field) — VARCHAR
- speciality (Field2) — VARCHAR