예약관리
테이블 (11)
branch_by_season_surcharge
- branch_season_unit_price_code (Key) — VARCHAR(20) — 기본 키 — NOT NULL
- registrant_id — VARCHAR(20)
- season_surcharge_list_code — VARCHAR(20)
- branch_code — VARCHAR(20)
- lowseason_peakseason — VARCHAR(20)
- week_room_price — DATE
- additional_amount — VARCHAR(20)
- register_date — DATE
- member_id (Key2) — varchar(50) — 외래 키 → member.member_id — NOT NULL
- season_surcharge_list_code (Key3) — VARCHAR(30) — 외래 키 → season_surcharge_list.season_surcharge_list_code — NOT NULL
- branch_code (Key4) — VARCHAR(20) — 외래 키 → branch_management.branch_code — NOT NULL
branch_management
- branch_code (Key) — VARCHAR(20) — 기본 키 — NOT NULL
- member_id — VARCHAR(20)
- branch_name — VARCHAR(20)
- branch_addr — VARCHAR(20)
- branch_phone — VARCHAR(20)
- branch_representative — VARCHAR(20)
- branch_start_date — DATE
- branch_end_date — DATE
- Penalty_payment_standards (Field) — VARCHAR(20)
- branch_image — VARCHAR(20)
- member_id (Key2) — varchar(50) — 외래 키 → member.member_id — NOT NULL
member
- member_id (Key) — varchar(50) — 기본 키 — NOT NULL
- mem_level_code — varchar(50)
- mem_position — varchar(50)
- member_pw — varchar(50)
- member_email — varchar(50)
- member_name — varchar(50)
- member_birth — DATE
- member_gender — varchar(50)
- member_phone — varchar(50)
- member_addr — varchar(50)
- member_regdate — DATE
- final_mileage — INT
- accumulated_payment_amount — INT
- memberState — varchar(50)
room_img_file
- room_img_code (Key) — VARCHAR(20) — 기본 키 — NOT NULL
- registrant_id — VARCHAR(20)
- room_code — VARCHAR(20)
- room_file_size — VARCHAR(20)
- room_file_att — VARCHAR(20)
- room_registration_date — DATE
- member_id (Key2) — varchar(50) — 외래 키 → member.member_id — NOT NULL
- room_code (Key3) — VARCHAR(20) — 외래 키 → room_information.room_code — NOT NULL
room_information
- room_code (Key) — VARCHAR(20) — 기본 키 — NOT NULL
- branch_code — VARCHAR(20)
- registrant_id — VARCHAR(20)
- branch_name — VARCHAR(20)
- room_name — VARCHAR(20)
- room_size — VARCHAR(20)
- room_basic_personnel — VARCHAR(20)
- room_max_personnel — VARCHAR(20)
- available_dog_types — VARCHAR(20)
- room_basic_price — INT
- room_registration_date — DATE
- member_id (Key2) — varchar(50) — 외래 키 → member.member_id — NOT NULL
- branch_code (Key3) — VARCHAR(20) — 외래 키 → branch_management.branch_code — NOT NULL
room_option_list
- room_option_number (Key) — VARCHAR(20) — 기본 키 — NOT NULL
- room_option_registration_id — VARCHAR(20)
- room_option_cate — VARCHAR(20)
- room_option_name — VARCHAR(20)
- room_option_price — INT
- room_option_registration_date — DATE
room_option_selection
- option_choice_code (Key) — VARCHAR(20) — 기본 키 — NOT NULL
- reservation_code — VARCHAR(20)
- member_id — VARCHAR(20)
- branch_code — VARCHAR(20)
- room_option_number — VARCHAR(20)
- room_option_name — VARCHAR(20)
- selected_option_amount — INT(20)
- room_option_selection_quantity — INT(20)
- room_option_subtotal_amount — INT(20)
- option_purchase_date — DATE
- member_id (Key2) — varchar(50) — 외래 키 → member.member_id — NOT NULL
- reservation_code (Key3) — VARCHAR(20) — 외래 키 → room_reservation.reservation_code — NOT NULL
- branch_code (Key4) — VARCHAR(20) — 외래 키 → branch_management.branch_code — NOT NULL
- room_option_number (Key5) — VARCHAR(20) — 외래 키 → room_option_list.room_option_number — NOT NULL
room_reservation
- reservation_code (Key) — VARCHAR(20) — 기본 키 — NOT NULL
- stay_period_code — VARCHAR(20)
- member_id — VARCHAR(20)
- room_code — VARCHAR(20)
- branch_season_unit price_code (branch_season_unit) — VARCHAR(20)
- day_of_stay — DATE
- room_basic_price — INT(20)
- additional_amount — INT(20)
- season_surcharge_select_quantity (Field) — INT(20)
- room_subtotal_amount — INT(20)
- member_id (Key2) — varchar(50) — 외래 키 → member.member_id — NOT NULL
- room_code (Key3) — VARCHAR(20) — 외래 키 → room_information.room_code — NOT NULL
- stay_period_code (Key4) — VARCHAR(20) — 외래 키 → set_stay_period.stay_period_code — NOT NULL
- branch_season_unit_price_code (Key5) — VARCHAR(20) — 외래 키 → branch_by_season_surcharge.branch_season_unit_price_code — NOT NULL
room_reservation_selection_list
- room_reservation_selection_code (Key) — VARCHAR(20) — 기본 키 — NOT NULL
- stay_period_code — VARCHAR(20)
- total_room_amount — INT(20)
- branch_code — VARCHAR(20)
- total_room_option_amount — INT(20)
- total_final_payment_amount — INT(20)
- branch_code (Key2) — VARCHAR(20) — 외래 키 → branch_management.branch_code — NOT NULL
- reservation_code (Key3) — VARCHAR(20) — 외래 키 → room_reservation.reservation_code — NOT NULL
- stay_period_code (Key4) — VARCHAR(20) — 외래 키 → set_stay_period.stay_period_code — NOT NULL
season_surcharge_list
- season_surcharge_list_code (Key) — VARCHAR(30) — 기본 키 — NOT NULL
- registrant_id — VARCHAR(20)
- lowseason_peakseason — VARCHAR(20)
- day_of_the_week (week_room_price) — DATE
- system_register_date — VARCHAR(20)
- member_id (Key2) — varchar(50) — 외래 키 → member.member_id — NOT NULL
set_stay_period
- stay_period_code (Key) — VARCHAR(20) — 기본 키 — NOT NULL
- member_id — VARCHAR(20)
- branch_code — VARCHAR(20)
- check_in — DATE
- check_out — DATE
- number_of_stays — VARCHAR(20)
- reserv_registration_date — DATE
- member_id (Key2) — varchar(50) — 외래 키 → member.member_id — NOT NULL
- branch_code (Key3) — VARCHAR(20) — 외래 키 → branch_management.branch_code — NOT NULL