달력

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