헬스장

테이블 (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