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