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