dbg_hw
Tables (6)
customer (Untitled4)
- 고객id (customer_id) — NUBMER — Primary key — NOT NULL
- 고객이름 (customer_name) — varchar(10)
- 고객주소 (customer_address) — varchar(100)
- 고객 전화번호 (customer_number) — varchar(20)
hotel (Untitled)
- 호텔id (hotel_id) — NUMBER — Primary key — NOT NULL
- 호텔 이름 (hotel_name) — varchar(100)
- 호텔 주소 (hotel_address) — varchar(100)
- 도시 (city) — varchar(20)
reservation (Untitled5)
- 예약id (reservation_id) — number — Primary key — NOT NULL
- 투숙객수 (customer_count) — number
- 예약일 (reservation_date) — DATE
- 퇴실일 (customer_out) — DATE
- 도착일 (customer_in) — DATE
- 고객id (customer_id) — NUBMER — Foreign key → customer.고객id — NOT NULL
- 호텔id (hotel_id) — NUMBER — Foreign key → hotel.호텔id — NOT NULL
room (Untitled2)
- 방 id (room_id) — NUMBER — Primary key — NOT NULL
- 방종류id (room_type_id) — number — Foreign key → room_type.방종류id — NOT NULL
- 호텔id (hotel_id) — NUMBER — Foreign key → hotel.호텔id — NOT NULL
room_type (Untitled3)
- 방종류id (room_type_id) — number — Primary key — NOT NULL
- 방종류이름 (room_type_name) — varchar(50)
- 종류별 방개수 (room_type_count) — number
- 종류별 방가격 (room_type_price) — DECIMAL(10,2)
- 호텔id (hotel_id) — NUMBER — Foreign key → hotel.호텔id — NOT NULL
stay (Untitled6)
- 투숙id (stay_id) — number — Primary key — NOT NULL
- 도착일 (real_in) — DATE
- 퇴실일 (real_out) — DATE
- 선불금 (prepayment) — DECIMAL(10,2)
- 지불방법 (payment_method) — varchar(20)
- 예약id (reservation_id) — number — Foreign key → reservation.예약id — NOT NULL