헬스장
테이블 (7)
Administer
- Administer_id — text — 기본 키 — NOT NULL
- Administer_name — text
Cost
- Age_group — Text — 기본 키 — NOT NULL
- 1Month — int
- 3Month — int
- 6Month — int
- 1Year — int
Equipment
- Equipment_id — text — 기본 키 — NOT NULL
- Administer_id — text — 외래 키 → Administer.Administer_id — NOT NULL
- Equipment_Check — boolean
Locker
- Locker_id — text — 기본 키 — NOT NULL
- Administer_id — text — 외래 키 → Administer.Administer_id — NOT NULL
- Locker_gender — boolean
Member
- Member_id — text — 기본 키 — NOT NULL
- Trainer_id — text — 외래 키 → Trainer.Trainer_id — NOT NULL
- Administer_id — text — 외래 키 → Administer.Administer_id — NOT NULL
- Age_group — Text — 외래 키 → Cost.Age_group — NOT NULL
- Locker_id — text — 외래 키 → Locker.Locker_id — NOT NULL
- Birthday — text
- Name — text
- Address — text
- Phone — text
- Genter (Gender) — boolean
- TotalCost — int
PT
- Age_group — Text — 외래 키 → Cost.Age_group — NOT NULL
- 10Count — int
- 20Count — int
- 30Count — int
Trainer
- Trainer_id — text — 기본 키 — NOT NULL
- Administer_id — text — 외래 키 → Administer.Administer_id — NOT NULL
- Trainer_name — text