아웃렛 관리

테이블 (9)

기존 t_nf_outlet (Untitled)

  • outlet_seq (Key) — 기본 키 — NOT NULL
  • company_seq (Field)
  • hotel_seq (Field2)
  • is_expose (Field3)
  • is_use (Field4)
  • outlet_title (Field5)
  • pms_code (Field6)
  • room_building_seq (Field7)
  • room_floor_seq (Field8)
  • location (Field9)
  • link_target_type (Field10)
  • link_inner_type (Field11)
  • link_inner_category (Field25)
  • link_inner_item (Field26)
  • link_external_path (Field12)
  • order_num (Field13)
  • mod_date (Field14)
  • reg_date (Field15)
  • contact (Field16)
  • intro (Field17)
  • notice (Field18)
  • max_person (Field19)
  • use_auto (Field20)
  • clear_cnt (Field21)
  • normal_cnt (Field22)
  • congetst_cnt (Field23)
  • congest_status (Field24)
  • outlet_status (Field27)

기존 t_nf_outlet_congest (Untitled4)

  • time_seq (Key) — 기본 키 — NOT NULL
  • company_seq (Field)
  • hotel_seq (Field2)
  • stand_seq (Field3)
  • outlet_seq (Field7)
  • congest (Field4)
  • start_time (Field5)
  • end_time (Field6)

기존 t_nf_outlet_position (Untitled7)

  • position_seq (Key) — 기본 키 — NOT NULL
  • company_seq (Field)
  • hotel_seq (Field2)
  • outlet_seq (Field3)
  • type_seq (Field4)
  • position_name (Field5)
  • max_person (Field6)
  • can_use (Field7)
  • status (Field8)
  • price (Field9)
  • pms_code (Field10)

기존 t_nf_outlet_position_type (Untitled6)

  • type_seq (Key) — 기본 키 — NOT NULL
  • company_seq (Field)
  • hotel_seq (Field2)
  • outlet_seq (Field3)
  • type_name (Field4)
  • status (Field5)
  • intro (Field6)

수정 t_nf_outlet (Untitled2)

  • outlet_seq (Key) — 기본 키 — NOT NULL
  • company_seq (Field)
  • hotel_seq (Field2)
  • is_expose (Field3)
  • is_use (Field4)
  • outlet_title (Field5)
  • pms_code (Field6)
  • room_building_seq (Field7)
  • room_floor_seq (Field8)
  • location (Field9)
  • main_file_path (Field10)
  • sub_file_path (Field11)
  • link_target_type (Field12)
  • link_inner_category (Field23)
  • link_inner_type (Field13)
  • link_inner_item (Field22)
  • link_external_path (Field14)
  • order_num (Field24)
  • opening_date (Field15)
  • start_time (Field16)
  • end_time (Field26)
  • breaking_date (Field17)
  • breaking_days (Field30)
  • breaking_start_time (Field28)
  • breaking_end_time (Field27)
  • closed_date (Field18)
  • closed_start_date (Field31)
  • closed_end_date (Field19)
  • outlet_status (Field32)
  • congest_status (Field25)
  • mod_date (Field20)
  • reg_date (Field21)

수정 t_nf_outlet_congest (Untitled5)

  • congest_seq (Key) — 기본 키 — NOT NULL
  • outlet_seq (Field)
  • max_person (Field2)
  • cur_person (Field3)
  • auto_status (Field4)
  • clear_cnt (Field5)
  • normal_cnt (Field6)
  • congest_cnt (Field7)
  • clar_time (Field8)
  • normal_time (Field9)
  • congest_time (Field10)
  • mod_date (Field11)
  • reg_date (Field12)

수정 t_nf_outlet_position (Untitled8)

  • position_seq (Key) — 기본 키 — NOT NULL
  • outlet_seq (Field)
  • type_seq (Field2)
  • max_person (Field3)
  • status (Field4)
  • avail_date (Field5)
  • avail_start_time (Field6)
  • avail_end_time (Field7)
  • price (Field8)
  • pms_code (Field9)
  • mod_date (Field10)
  • reg_date (Field11)

수정 t_nf_outlet_position_type (Untitled9)

  • type_seq (Key) — 기본 키 — NOT NULL
  • type_name (Field)
  • file_path (Field2)
  • intro (Field3)
  • mod_date (Field4)
  • reg_date (Field5)

추가 t_nf_outlet_detail (Untitled3)

  • detail_seq (Key) — 기본 키 — NOT NULL
  • outlet_seq (Field)
  • contact (Field2)
  • intro (Field3)
  • notice (Field4)
  • mod_date (Field5)
  • reg_date (Field6)