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