헬스장

테이블 (4)

Attendance

  • A_ID — INT — 기본 키
  • M_Number — varchar(11) — 외래 키 → Member.M_Number
  • A_Date — DATETIME

M_Payment

  • P_Number — INT — 기본 키
  • M_Number — varchar(11) — 외래 키 → Member.M_Number
  • Price — INT — NOT NULL
  • P_Method — VARCHAR(50)
  • Field — VARCHAR(50)

Member

  • M_Number — varchar(11) — 기본 키
  • M_Password — varchar(4) — NOT NULL
  • M_Name — VARCHAR(100) — NOT NULL
  • startdate — datetime
  • hiredate — datetime

NonMemberPayments

  • id — INT — 기본 키
  • phone — VARCHAR(20) — NOT NULL
  • price — INT — NOT NULL
  • payment_method — VARCHAR(20) — NOT NULL
  • description — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP