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