헬스장
테이블 (5)
P_CUSTOMER (CUSTOMER)
- Member ID (member_ID) — int(5) — 기본 키 — NOT NULL
- Name — varchar(20)
- Gender — enum("남자","여자")
- Age — int(5)
- Weight — int(5)
- Height — int(5)
- Trainer_name (Trainer_Name) — varchar(20) — 외래 키 → P_TRAINER.Trainer_name — NOT NULL
- Program Count (PT_Count) — int(5)
- Phone — varchar(20)
- Program — enum(등.가슴.하체)
P_ENROLL
- EnrollDate — date — 기본 키 — NOT NULL
- Membership — varchar(20) — 외래 키 → P_MEMBERSHIP.Membership — NOT NULL
- Member ID (member_ID) — int(11) — 외래 키 → P_CUSTOMER.Member ID — NOT NULL
- Trainer_name (Trainer_Name) — varchar(20) — 외래 키 → P_TRAINER.Trainer_name — NOT NULL
P_MEMBERSHIP
- Membership — varchar(20) — 기본 키 — NOT NULL
- Price (Field2) — varchar(20)
- Days — int(5)
P_RECORD (Untitled)
- Record_Date (Key) — 기본 키 — NOT NULL
- Member ID (member_ID) — int(5) — 외래 키 → P_CUSTOMER.Member ID — NOT NULL
- Name (Field)
- Last_Phone (Field2)
- Trainer_enum (Field4)
- Sets (Field5)
P_TRAINER
- Trainer_name (Trainer_Name) — varchar(20) — 기본 키 — NOT NULL
- Career year (Career_start) — varchar(20)
- Trainer Phone (Trainer_Phone) — varchar(20)