예약관리

테이블 (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