헬스장

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