달력
테이블 (4)
달력
- id — int — 기본 키 — NOT NULL
- 예약시간설정 ID (id2) — int — 외래 키 → 예약가능시간설정.id — NOT NULL
- Reservation_Date (Reservation Date) — datetime
- Ceo_Name — varchar
- Group — varchar
- Reservation_gubun (Reservation_Gubun) — varchar
- Elementary_Man — int
- Elementary_Woman — int
- Medium_Man — int
- Medium_Woman — int
- The_Man — int
- The_Woman — int
- Versus_Man — int
- Versus_Woman — int
- Adult_Man — int
- Address — varchar
- Phone — varchar
- Etc — text
- Registration_Date — datetime
- Reservation_Status — varchar
- user_id — varchar
- password — varchar
예약가능시간설정
- id — int — 기본 키 — NOT NULL
- Time — time
- Months — varchar
- Applied_Day — varchar
- Number — int
일정추가
- id — int — 기본 키 — NOT NULL
- Calendar_Name — varchar
- Start_Date — date
- End_Date — date
휴무설정
- id — int — 기본 키 — NOT NULL
- Field — varchar