chacha

Tables (8)

BOOKING

  • booking_code — CHAR(12) — Primary key — NOT NULL
  • member_id — VARCHAR2(20) — Foreign key → MEMBER.member_id
  • room_type_code — CHAR(7) — Foreign key → ROOM_TYPE.room_type_code — NOT NULL
  • guest_name — VARCHAR2(30) — NOT NULL
  • guest_phone — VARCHAR2(50) — NOT NULL
  • check_in_date — DATE — NOT NULL
  • check_out_date — DATE — NOT NULL
  • total_price — NUMBER — NOT NULL
  • booking_status — CHAR(1) — NOT NULL
  • request_memo — VARCHAR2(600)
  • booking_date — DATE

FACILITY

  • facility_code — CHAR(7) — Primary key — NOT NULL
  • hotel_code — CHAR(7) — Foreign key → HOTEL.hotel_code — NOT NULL
  • facility_name — VARCHAR2(50) — NOT NULL
  • operating_hours — VARCHAR2(100)
  • description — CLOB

HOTEL

  • hotel_code — CHAR(7) — Primary key — NOT NULL
  • hotel_name — VARCHAR2(50) — NOT NULL
  • region — VARCHAR2(30) — NOT NULL
  • address — VARCHAR2(200) — NOT NULL
  • phone — VARCHAR2(50) — NOT NULL
  • rating — CHAR(1)
  • description — CLOB
  • reg_date — DATE

MEMBER

  • member_id — VARCHAR2(20) — Primary key — NOT NULL
  • company_code — CHAR(7) — Foreign key → PARTNER_COMPANY.company_code
  • password — VARCHAR2(500) — NOT NULL
  • name — VARCHAR2(30) — NOT NULL
  • birth_date — VARCHAR2(10) — NOT NULL
  • phone — VARCHAR2(50) — NOT NULL
  • email — VARCHAR2(100) — NOT NULL
  • member_type — CHAR(1) — NOT NULL
  • status — CHAR(1)
  • join_date — DATE

PARTNER_COMPANY

  • company_code — CHAR(7) — Primary key — NOT NULL
  • company_name — VARCHAR2(50) — NOT NULL
  • biz_register_no — VARCHAR2(50) — NOT NULL
  • manager_name — VARCHAR2(30) — NOT NULL
  • manager_phone — VARCHAR2(50) — NOT NULL
  • status — CHAR(1)
  • reg_date — DATE

PAYMENT

  • payment_code — CHAR(12) — Primary key — NOT NULL
  • booking_code — CHAR(12) — Foreign key → BOOKING.booking_code — NOT NULL
  • payment_method — VARCHAR2(30) — NOT NULL
  • payment_price — NUMBER — NOT NULL
  • payment_status — CHAR(1) — NOT NULL
  • payment_date — DATE

ROOM_INVENTORY

  • inventory_id — NUMBER — Primary key — NOT NULL
  • room_type_code — CHAR(7) — Foreign key → ROOM_TYPE.room_type_code — NOT NULL
  • inventory_date — DATE — NOT NULL
  • total_rooms — NUMBER — NOT NULL
  • booked_rooms — NUMBER
  • base_price — NUMBER — NOT NULL
  • member_price — NUMBER — NOT NULL

ROOM_TYPE

  • room_type_code — CHAR(7) — Primary key — NOT NULL
  • hotel_code — CHAR(7) — Foreign key → HOTEL.hotel_code — NOT NULL
  • room_type_name — VARCHAR2(50) — NOT NULL
  • base_occupancy — NUMBER — NOT NULL
  • max_occupancy — NUMBER — NOT NULL
  • amenities — VARCHAR2(1500)
  • description — CLOB