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