아웃렛 관리
테이블 (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)