hotel

Tables (4)

date (날짜/요일)

  • date_id (날찌id) — mi,ber(10) — Primary key — NOT NULL
  • date (날짜) — date
  • day (요일.) — date
  • reservation_name (예약자이름) — varchar(200)
  • reservation_id (예약자 id) — number(10) — Foreign key → reservation.reservation_id — NOT NULL

reservation (예약자)

  • reservation_id (예약자 id) — number(10) — Primary key — NOT NULL
  • resevation_name (예약자 이름) — varchar(200)
  • resevation_number (전화번호) — number(8)
  • reservation_email (이메일) — varchar(2000)
  • point (포인트) — varchar(2000)
  • deposit (예약금) — varchar(2000)
  • room_reservation_id (방id) — number(10) — Foreign key → room_reservation.room_reservation_id — NOT NULL

room_check (룸체크인)

  • room_check_id (룸id) — number(10) — Primary key — NOT NULL
  • check_in (체크인) — date
  • chech_out (체크아웃) — date
  • date_id (날찌id) — mi,ber(10) — Foreign key → date.date_id — NOT NULL
  • room_reservation_id (방id) — number(10) — Foreign key → room_reservation.room_reservation_id — NOT NULL

room_reservation (룸예약)

  • room_reservation_id (방id) — number(10) — Primary key — NOT NULL
  • title_number (방이름) — varchar(200)
  • tilte_size (방크기) — varchar(2000)
  • person_numver (인원수) — number(10)
  • room_price (가격) — varchar(2000)
  • dwscription (상세설명) — date