KIA
Tables (45)
new_table_ecs_manual_job_history
- job_id — SERIAL — NOT NULL
- plant_code — integer
- process_code — integer
- warehouse_code — integer
- device — character
- order_type — character
- job_number — integer
- w_from — character
- w_to — character
- job_time — timestamp
- manager — character
new_table_mes_schedule_complete
- body_no — character
- car_type — character
- complete_time — timestamp
- id_flag — character
- seq — character
- vin_head — character
- vin — character
- vin_tail — character
- area — character
- seater — character
- engine — character
- body_type — character
- roof — character
- handle — character
- rsv1 — character
- rsv2 — character
- rsv3 — character
- rsv4 — character
- rsv5 — character
- rsv6 — character
- rsv7 — character
- fl — character
- spw — character
- active — character
- rsv8 — character
- rsv9 — character
- rsv10 — character
- rsv11 — character
- rsv12 — character
- rsv13 — character
- rsv14 — character
- rsv15 — character
- rsv16 — character
- rsv17 — character
- rsv18 — character
- rsv19 — character
- rsv20 — character
- rsv21 — character
- rsv22 — character
- rsv23 — character
- rsv24 — character
- rsv25 — character
- rsv26 — character
- rsv27 — character
- rsv28 — character
- t_space — character
- car_type_system — character
new_table_mes_schedule_part_list
- mes_schedule_id — integer — Primary key — NOT NULL
- pallet_code — integer — Primary key — NOT NULL
- plant_code — integer
- process_code — integer
- warehouse_code — integer
- seq — character
- body_no — character
- car_type — character
- release_order — integer
- store_order — integer
- status — character
table_agv_remain_quantity
- pallet_code — integer — Primary key — NOT NULL
- plant_code — integer — Foreign key → table_warehouse.plant_code — NOT NULL
- process_code — integer — Foreign key → table_warehouse.process_code — NOT NULL
- warehouse_code — integer — Foreign key → table_warehouse.warehouse_code — NOT NULL
- quantity — integer
table_breakdown_history
- breakdown_history_id — SERIAL — NOT NULL
- plant_code — integer
- process_code — integer
- warehouse_code — integer
- breakdown_occurred_date — timestamp
- device_name — character
- breakdown_clear_date — timestamp
- alarm_code — integer
- breakdown_reason — character
- manager — character
- breakdown_history_note — character
table_common_code
- code_type — character
- code_num — integer
- detail — character
table_connect_history
- connect_history_id — SERIAL — NOT NULL
- user_id — character — Foreign key → table_user_management.user_id
- plant_code — integer
- process_code — integer
- warehouse_code — integer
- loginout_status — integer
- loginout_date — timestamp
- system_type — character
table_ecs
- interface_id — SERIAL — NOT NULL
- interface_type — character
- plant_code — integer
- process_code — integer
- warehouse_code — integer
- order_no — integer
- rfid — character
- pallet_code — integer
- quantity — integer
- start_row — integer
- start_bay — integer
- start_level — integer
- end_row — integer
- end_bay — integer
- end_level — integer
- loading_number — integer
- unloading_number — integer
- job_number — integer
table_ecs_in_work
- work_id — SERIAL — NOT NULL
- order_id — integer
- plant_code — integer
- process_code — integer
- warehouse_code — integer
- pallet_code — integer
- quantity — integer
- rfid — character
- start_row — integer
- start_bay — integer
- start_level — integer
- end_row — integer
- end_bay — integer
- end_level — integer
- loading_number — integer
- unloading_number — integer
- status — character
- job_number — integer
table_ecs_log
- log_id — SERIAL — NOT NULL
- plant_code — integer
- process_code — integer
- warehouse_code — integer
- device — character
- message — text
- log_time — timestamp
table_ecs_manual_job_history
- job_id — SERIAL — NOT NULL
- plant_code — integer
- process_code — integer
- warehouse_code — integer
- device — character
- order_type — character
- job_number — integer
- w_from — character
- w_to — character
- job_time — timestamp
- manager — character
table_ecs_out_work
- work_id — SERIAL — NOT NULL
- order_id — integer
- plant_code — integer
- process_code — integer
- warehouse_code — integer
- pallet_code — integer
- quantity — integer
- rfid — character
- start_row — integer
- start_bay — integer
- start_level — integer
- end_row — integer
- end_bay — integer
- end_level — integer
- loading_number — integer
- unloading_number — integer
- status — character
- modify_status — integer
- job_number — integer
table_ecs_out_work_ex
- work_id — SERIAL — NOT NULL
- order_id — integer
- plant_code — integer
- process_code — integer
- warehouse_code — integer
- order_type — character
- pallet_code — integer
- quantity — integer
- rfid — character
- start_row — integer
- start_bay — integer
- start_level — integer
- end_row — integer
- end_bay — integer
- end_level — integer
- loading_number — integer
- unloading_number — integer
- status — character
- modify_status — integer
- job_number — integer
table_ecs_sc_schedule
- sc_id — SERIAL — NOT NULL
- plant_code — integer
- process_code — integer
- warehouse_code — integer
- pallet_code — integer — Foreign key → table_sku.pallet_code
- quantity — integer
- rfid — character
- order_cmd — character
- done — character
- order_type — character
- start_row — integer
- start_bay — integer
- start_level — integer
- end_row — integer
- end_bay — integer
- end_level — integer
- loading_number — integer
- unloading_number — integer
- modify_status — integer
- job_number — integer
- pallet_type — integer
table_interface_history
- interface_history_id — SERIAL — NOT NULL
- history_date — timestamp
- interface_type — character
- plant_code — integer
- process_code — integer
- warehouse_code — integer
- interface_from — character
- interface_to — character
- interface_note — text
table_inventory_history
- inventory_history_id — SERIAL — NOT NULL
- plant_code — integer — Foreign key → table_warehouse.plant_code
- process_code — integer — Foreign key → table_warehouse.process_code — NOT NULL
- warehouse_code — integer — Foreign key → table_warehouse.warehouse_code — NOT NULL
- pallet_code — integer — NOT NULL
- inventory_code — integer — Foreign key → table_inventory_information.inventory_code
- rack_type — character
- rfid — character
- pre_rfid — character
- cur_row — integer
- pre_row — integer
- cur_bay — integer
- pre_bay — integer
- cur_level — integer
- pre_level — integer
- modify_date — timestamp
- store_date — timestamp
- inventory_status — integer
- pre_inventory_status — integer
- quantity — integer
- pre_quantity — integer
- manager — character
- inventory_note — character
table_inventory_information
- inventory_code — integer — NOT NULL
- inventory_description — character
table_location
- location_id — SERIAL — NOT NULL
- location_max_id — integer — Foreign key → table_location_max.location_max_id
- plant_code — integer — Foreign key → table_warehouse.plant_code
- process_code — integer — Foreign key → table_warehouse.process_code — NOT NULL
- warehouse_code — integer — Foreign key → table_warehouse.warehouse_code — NOT NULL
- rack_type — character
- pallet_codes — character
- pallet_types — character
- w_row — integer
- w_bay — integer
- w_level — integer
- modify_user_id — character
- prohibit_in_use — integer
- prohibit_out_use — integer
- location_note — character
- site_id — integer
- disable_flag — integer
- pallet_code — integer
- rfid — character
- modify_date — timestamp
- store_date — timestamp
- embodiment_date — timestamp
- inventory_status — integer
- quantity — integer
- manager — character
- modify_status — integer
- location_status — character
- start_seq_no — integer
table_location_max
- location_max_id — SERIAL — NOT NULL
- plant_code — integer — Foreign key → table_warehouse.plant_code
- process_code — integer — Foreign key → table_warehouse.process_code — NOT NULL
- warehouse_code — integer — Foreign key → table_warehouse.warehouse_code — NOT NULL
- rack_type — character
- start_row — integer
- start_bay — integer
- start_level — integer
- end_row — integer
- end_bay — integer
- end_level — integer
table_manual_command_history
- manual_command_id — SERIAL — NOT NULL
- manual_command_date — timestamp
- manual_command_content — character
- manager — character
- plant_code — integer
- process_code — integer
- warehouse_code — integer
- system_type — character
table_menu_code
- menu_code — integer — Primary key — NOT NULL
- menu_desc — character
table_mes_schedule
- mes_schedule_id — SERIAL — NOT NULL
- id_flag — character
- seq — character
- vin_head — character
- vin — character
- vin_tail — character
- car_type — character
- area — character
- seater — character
- car_engine — character
- body_type — character
- roof — character
- handle — character
- rsv1 — character
- rsv2 — character
- rsv3 — character
- rsv4 — character
- rsv5 — character
- rsv6 — character
- rsv7 — character
- fl — character
- spw — character
- active — character
- rsv8 — character
- rsv9 — character
- rsv10 — character
- rsv11 — character
- rsv12 — character
- rsv13 — character
- rsv14 — character
- rsv15 — character
- rsv16 — character
- rsv17 — character
- rsv18 — character
- rsv19 — character
- rsv20 — character
- rsv21 — character
- rsv22 — character
- rsv23 — character
- rsv24 — character
- rsv25 — character
- rsv26 — character
- rsv27 — character
- rsv28 — character
- t_space — character
- car_type_system — character
- body_no — character
table_mes_schedule_active
- mes_schedule_id — SERIAL — NOT NULL
- id_flag — character
- seq — character
- vin_head — character
- vin — character
- vin_tail — character
- car_type — character
- area — character
- seater — character
- car_engine — character
- body_type — character
- roof — character
- handle — character
- rsv1 — character
- rsv2 — character
- rsv3 — character
- rsv4 — character
- rsv5 — character
- rsv6 — character
- rsv7 — character
- fl — character
- spw — character
- active — character
- rsv8 — character
- rsv9 — character
- rsv10 — character
- rsv11 — character
- rsv12 — character
- rsv13 — character
- rsv14 — character
- rsv15 — character
- rsv16 — character
- rsv17 — character
- rsv18 — character
- rsv19 — character
- rsv20 — character
- rsv21 — character
- rsv22 — character
- rsv23 — character
- rsv24 — character
- rsv25 — character
- rsv26 — character
- rsv27 — character
- rsv28 — character
- t_space — character
- car_type_system — character
- body_no — character
table_mes_schedule_complete
- body_no — character
- car_type — character
- complete_time — timestamp
- id_flag — character
- seq — character
- vin_head — character
- vin — character
- vin_tail — character
- area — character
- seater — character
- car_engine — character
- body_type — character
- roof — character
- handle — character
- rsv1 — character
- rsv2 — character
- rsv3 — character
- rsv4 — character
- rsv5 — character
- rsv6 — character
- rsv7 — character
- fl — character
- spw — character
- active — character
- rsv8 — character
- rsv9 — character
- rsv10 — character
- rsv11 — character
- rsv12 — character
- rsv13 — character
- rsv14 — character
- rsv15 — character
- rsv16 — character
- rsv17 — character
- rsv18 — character
- rsv19 — character
- rsv20 — character
- rsv21 — character
- rsv22 — character
- rsv23 — character
- rsv24 — character
- rsv25 — character
- rsv26 — character
- rsv27 — character
- rsv28 — character
- t_space — character
- car_type_system — character
table_mes_schedule_part_list
- mes_schedule_id — integer — Primary key — NOT NULL
- pallet_code — integer — Primary key — NOT NULL
- plant_code — integer — Foreign key → table_warehouse.plant_code
- process_code — integer — Foreign key → table_warehouse.process_code
- warehouse_code — integer — Foreign key → table_warehouse.warehouse_code
- seq — character
- body_no — character
- car_type — character
- release_order — integer
- store_order — integer
- status — character
table_mes_schedule_part_list_complete
- complete_date — timestamp
- plant_code — integer
- process_code — integer
- warehouse_code — integer
- pallet_code — integer
- seq — character
- body_no — character
- car_type — character
table_pallet_type
- pallet_type — integer — Primary key — NOT NULL
- plant_code — integer — Foreign key → table_warehouse.plant_code — NOT NULL
- process_code — integer — Foreign key → table_warehouse.process_code — NOT NULL
- warehouse_code — integer — Foreign key → table_warehouse.warehouse_code — NOT NULL
- pallet_size — integer
table_plant
- plant_code — integer — NOT NULL — 공장
- plant_name — character — 공장
table_process
- process_code — integer — Primary key — NOT NULL
- plant_code — integer — Foreign key → table_plant.plant_code — NOT NULL
- process_name — character
table_release_history
- release_history_id — SERIAL — NOT NULL
- plant_code — integer — Foreign key → table_warehouse.plant_code
- process_code — integer — Foreign key → table_warehouse.process_code — NOT NULL
- warehouse_code — integer — Foreign key → table_warehouse.warehouse_code — NOT NULL
- pallet_code — integer — NOT NULL
- release_code — integer — Foreign key → table_release_information.release_code — NOT NULL
- rfid — character
- w_row — integer
- w_bay — integer
- w_level — integer
- modify_date — timestamp
- release_date — timestamp
- release_count — integer
- manager — character
- release_history_note — character
- job_number — integer
table_release_information
- release_code — integer — NOT NULL
- release_description — character
table_release_rule
- release_rule_id — SERIAL — NOT NULL
- plant_code — integer — Foreign key → table_process.plant_code
- process_code — integer — Foreign key → table_process.process_code
- release_rule_sort — character
- manager — character
- created_time — timestamp
table_release_rule_detail
- release_rule_detail_id — SERIAL — NOT NULL
- plant_code — integer — Foreign key → table_process.plant_code
- process_code — integer — Foreign key → table_process.process_code
- detail — character
- rule_enable — integer
- rule_sortno — integer
- rule_sortmethod — character
table_release_schedule
- release_schedule_id — SERIAL — NOT NULL
- plant_code — integer — Foreign key → table_warehouse.plant_code
- process_code — integer — Foreign key → table_warehouse.process_code — NOT NULL
- warehouse_code — integer — Foreign key → table_warehouse.warehouse_code — NOT NULL
- pallet_code — integer — Foreign key → table_sku.pallet_code — NOT NULL
- order_no — integer
- rfid — character
- manager — character
- order_status — integer
- start_row — integer
- start_bay — integer
- start_level — integer
- end_row — integer
- end_bay — integer
- end_level — integer
- loading_number — integer
- unloading_number — integer
table_release_schedule_manual
- release_schedule_id — SERIAL — NOT NULL
- plant_code — integer — Foreign key → table_warehouse.plant_code
- process_code — integer — Foreign key → table_warehouse.process_code — NOT NULL
- warehouse_code — integer — Foreign key → table_warehouse.warehouse_code — NOT NULL
- pallet_code — integer — Foreign key → table_sku.pallet_code — NOT NULL
- order_no — integer
- rfid — character
- manager — character
- order_status — integer
- start_row — integer
- start_bay — integer
- start_level — integer
- end_row — integer
- end_bay — integer
- end_level — integer
- loading_number — integer
- unloading_number — integer
table_sku
- pallet_code — integer — NOT NULL
- plant_code — integer — Foreign key → table_warehouse.plant_code — NOT NULL
- process_code — integer — Foreign key → table_warehouse.process_code — NOT NULL
- warehouse_code — integer — Foreign key → table_warehouse.warehouse_code — NOT NULL
- part_name — character
- storage_days — integer
- max_storage_count — integer
- mes_waiting_number — integer
- restore_quantity — integer
- car_type — character
- seater — character
- engine — character
- body_type — character
- roof — character
- handle — character
- rsv1 — character
- rsv2 — character
- rsv3 — character
- rsv4 — character
- rsv5 — character
- rsv6 — character
- rsv7 — character
- fl — character
- sbw — character
- active — character
- rsv8 — character
- rsv9 — character
- rsv10 — character
- rsv11 — character
- rsv12 — character
- rsv13 — character
- rsv14 — character
- rsv15 — character
- rsv16 — character
- rsv17 — character
- rsv18 — character
- rsv19 — character
- rsv20 — character
- rsv21 — character
- rsv22 — character
- rsv23 — character
- rsv24 — character
- rsv25 — character
- rsv26 — character
- rsv27 — character
- rsv28 — character
- t_space — character
- loading_start_no — character
- loading_end_no — character
- unloading_start_no — character
- unloading_end_no — character
- pallet_type — integer
table_store_history
- store_history_id — SERIAL — NOT NULL
- plant_code — integer — Foreign key → table_warehouse.plant_code
- process_code — integer — Foreign key → table_warehouse.process_code — NOT NULL
- warehouse_code — integer — Foreign key → table_warehouse.warehouse_code — NOT NULL
- store_code — integer — NOT NULL
- pallet_code — integer — NOT NULL
- rfid — character
- w_row — integer
- w_bay — integer
- w_level — integer
- store_date — timestamp
- quantity — integer
- manager — character
- store_history_note — character
- job_number — integer
table_store_information
- store_code — integer — NOT NULL
- store_description — character
table_store_schedule
- store_id — SERIAL — NOT NULL
- plant_code — integer — Foreign key → table_warehouse.plant_code — NOT NULL
- process_code — integer — Foreign key → table_warehouse.process_code — NOT NULL
- warehouse_code — integer — Foreign key → table_warehouse.warehouse_code — NOT NULL
- pallet_code — integer — Foreign key → table_sku.pallet_code
- order_no — integer
- rfid — character
- manager — character
- order_status — integer
- start_row — integer
- start_bay — integer
- start_level — integer
- end_row — integer
- end_bay — integer
- end_level — integer
- loading_number — integer
- unloading_number — integer
table_store_schedule_manual
- store_id — SERIAL — NOT NULL
- plant_code — integer — Foreign key → table_warehouse.plant_code — NOT NULL
- process_code — integer — Foreign key → table_warehouse.process_code — NOT NULL
- warehouse_code — integer — Foreign key → table_warehouse.warehouse_code — NOT NULL
- pallet_code — integer — Foreign key → table_sku.pallet_code
- order_no — integer
- rfid — character
- manager — character
- order_status — integer
- start_row — integer
- start_bay — integer
- start_level — integer
- end_row — integer
- end_bay — integer
- end_level — integer
- loading_number — integer
- unloading_number — integer
table_user_management
- user_id — character — NOT NULL
- menu_code — integer — Foreign key → table_menu_code.menu_code
- plant_code — integer
- process_code — integer
- warehouse_code — integer
- user_pass — character
- logout_time — timestamp
- user_level — integer
- login_status — integer
- current_page — character
- system_type — character
table_warehouse
- warehouse_code — integer — Primary key — NOT NULL
- plant_code — integer — Foreign key → table_process.plant_code — NOT NULL
- process_code — integer — Foreign key → table_process.process_code — NOT NULL
- warehouse_name — character
- warehouse_type — character
table_wms
- interface_id — integer — NOT NULL
- interface_type — character
- plant_code — integer
- process_code — integer
- warehouse_code — integer
- order_no — integer
- rfid — character
- pallet_code — integer
- quantity — integer
table_wms_interface_processing
- interface_id — integer — NOT NULL
- interface_type — character
table_wms_log
- log_id — SERIAL — NOT NULL
- log_time — timestamp
- plant_code — integer
- process_code — integer
- warehouse_code — integer
- log_message — text