test
Tables (96)
account
- account_id — VARCHAR(50) — Primary key — NOT NULL
- allow_factory — VARCHAR(5)
- department — VARCHAR(50)
- password — VARCHAR(200)
- role — VARCHAR(50)
- user_name — VARCHAR(100)
- main_page_url — VARCHAR(50)
- approval_status — VARCHAR(10)
- api_token — VARCHAR(20)
- phone_number — VARCHAR(50)
- email — VARCHAR(100)
account_bcrypt
- account_id — VARCHAR(50) — Primary key — NOT NULL
- allow_factory — VARCHAR(255)
- department — VARCHAR(255)
- password — VARCHAR(255)
- role — VARCHAR(255)
- user_name — VARCHAR(255)
- main_page_url — VARCHAR(50)
- approval_status — VARCHAR(10)
- api_token — VARCHAR(255)
- phone_number — VARCHAR(50)
- email — VARCHAR(100)
account_log_info
- log_info_seq — INT — Primary key — NOT NULL — 접속정보 순번
- account_id — VARCHAR(50) — Foreign key → account.account_id — NOT NULL — 사용자 아이디
- log_in_date — DATETIME — 최초 접속 시간
- last_access_date — DATETIME — 마지막 접속 시간
- total_access_time — DOUBLE — 총 접속 시간(분)
- session_id — VARCHAR(50)
- ip_addr — VARCHAR(20)
- INDEX — `loginfoIDX`
alarm_dictionary
- alarm_id — INT — Primary key — NOT NULL
- factory_id — INT — Foreign key → factory.factory_id
- alarm_type_id — INT — Foreign key → alarm_type.alarm_type_id — 1:machine alarm, 2:operate msg
- alarm_group_id — INT — Foreign key → alarm_group.alarm_group_id — 추후 그룹핑 할 경우 사용 할 컬럼
- alarm_msg_kr — VARCHAR(255)
- alarm_msg_en — VARCHAR(255)
- use_yn — VARCHAR(1)
- reg_date — DATETIME
- INDEX — `alarmIDX`
- INDEX — `findIDX`
- INDEX — `fk_alarm_dictionary_alarm_type1_idx`
- INDEX — `fk_alarm_dictionary_alarm_group1_idx`
alarm_event_status
- alarm_status_id — INT — Primary key — NOT NULL
- factory_id — INT — Foreign key → factory.factory_id
- machine_id — INT — Foreign key → machine.machine_id
- alarm_id — INT — Foreign key → alarm_info.alarm_id
- alarm_type_id — INT — Foreign key → alarm_type.alarm_type_id
- machine_alarm_type — INT
- machine_alarm_no — INT
- machine_alarm_axis — INT
- alarm_msg — VARCHAR(255)
- holding_time — INT
- u_flag — INT
- reg_date — DATETIME
- update_date — DATETIME
- INDEX — `alarmIDX`
- INDEX — `ingIDX`
- INDEX — `delIDX`
- INDEX — `fk_alarm_event_status_alarm_info1_idx`
- INDEX — `fk_alarm_event_status_alarm_type1_idx`
alarm_group
- alarm_group_id — INT — Primary key — NOT NULL
- factory_id — INT — Foreign key → factory.factory_id
- alarm_type_id — INT — Foreign key → alarm_type.alarm_type_id — 1:machine alarm, 2:operate msg
- group_name — VARCHAR(255)
- use_yn — VARCHAR(1)
- reg_date — DATETIME
- INDEX — `findIDX`
- INDEX — `fk_alarm_group_alarm_type1_idx`
alarm_info
- alarm_id — INT — Primary key — NOT NULL
- alarm_type — INT
- alarm_no — INT
- alarm_msg_kr — VARCHAR(200)
- alarm_msg_en — VARCHAR(200)
- etc1 — VARCHAR(200)
- etc2 — VARCHAR(200)
- reg_date — DATETIME
- INDEX — `alarmIDX`
alarm_recipient
- alarm_recipient_seq — INT — Primary key — NOT NULL
- factory_id — INT — Foreign key → factory.factory_id — NOT NULL
- machine_id — INT — Foreign key → machine.machine_id — NOT NULL
- account_id — VARCHAR(255) — Foreign key → account.account_id
- katalk_yn — VARCHAR(1)
- email_yn — VARCHAR(1)
- use_yn — VARCHAR(1)
- reg_date — DATETIME
- update_date — DATETIME
- INDEX — `findIDX`
- INDEX — `machineIDX`
- INDEX — `fk_alarm_recipient_account1_idx`
alarm_send_history
- alarm_send_seq — INT — Primary key — NOT NULL
- factory_id — INT — Foreign key → factory.factory_id
- machine_id — INT — Foreign key → machine.machine_id — NOT NULL
- alarm_trigger_code — VARCHAR(50) — NOT NULL
- trigger_cnt — INT
- start_date — DATETIME
- end_date — DATETIME
- send_result — INT — 0: 성공 1: 실패 2: 대기 3: 수신자없음
- write_user — VARCHAR(50)
- write_date — DATETIME
- update_date — DATETIME
- INDEX — `alarmCntIDX`
- INDEX — `alarmSendIDX`
- INDEX — `fk_alarm_send_history_machine1_idx`
alarm_send_recipient_history
- alarm_send_recipient_seq — INT — Primary key — NOT NULL
- alarm_send_seq — INT — Foreign key → alarm_send_history.alarm_send_seq — NOT NULL
- account_id — VARCHAR(50) — Foreign key → account.account_id
- email — VARCHAR(100)
- phone_number — VARCHAR(50)
- send_result — INT — 0: 성공 1: 실패
- send_type — INT — 1: email 2: katalk
- write_date — DATETIME
- INDEX — `alarmCntIDX`
- INDEX — `fk_alarm_send_recipient_history_account1_idx`
alarm_status
- alarm_status_id — INT — Primary key — NOT NULL
- machine_id — INT
- reg_date — DATETIME
- update_date — DATETIME
- alarm_id — INT
- alarm_type — INT
- alarm_no — INT
- alarm_axis — INT
- alarm_msg — VARCHAR(200)
- holding_time — INT
- etc1 — VARCHAR(200)
- etc2 — VARCHAR(200)
- u_flag — INT
- INDEX — `alarmIDX`
- INDEX — `ingIDX`
- INDEX — `delIDX`
alarm_support_history
- alarm_support_seq — INT — Primary key — NOT NULL
- factory_id — INT — Foreign key → factory.factory_id
- machine_id — INT — Foreign key → machine.machine_id — NOT NULL
- alarm_trigger_code — VARCHAR(50)
- start_date — DATETIME
- end_date — DATETIME
- send_result — INT — 0: 성공 1: 실패 2: 대기 3: 수신자없음
- write_user — VARCHAR(50)
- write_date — DATETIME
- update_date — DATETIME
- chk_yn — VARCHAR(1) — NOT NULL — y:완료, n:미완료
- update_user — VARCHAR(45)
- INDEX — `fk_alarm_support_history_factory1_idx`
- INDEX — `fk_alarm_support_history_machine1_idx`
alarm_support_recipient
- alarm_support_recipient_seq — INT — Primary key — NOT NULL
- factory_id — INT — Foreign key → factory.factory_id — NOT NULL
- machine_id — INT — Foreign key → machine.machine_id — NOT NULL
- account_id — VARCHAR(255) — Foreign key → account.account_id
- katalk_yn — VARCHAR(1)
- email_yn — VARCHAR(1)
- use_yn — VARCHAR(1)
- reg_date — DATETIME
- update_date — DATETIME
- INDEX — `findIDX`
- INDEX — `machineIDX`
- INDEX — `fk_alarm_support_recipient_account1_idx`
alarm_support_recipient_history
- alarm_support_recipient_seq — INT — Primary key — NOT NULL
- alarm_support_seq — INT — Foreign key → alarm_support_history.alarm_support_seq — NOT NULL
- account_id — VARCHAR(50) — Foreign key → account.account_id
- email — VARCHAR(100)
- phone_number — VARCHAR(50)
- send_result — INT — 0: 성공 1: 실패
- send_type — INT — 1: email 2: katalk
- write_date — DATETIME
- INDEX — `fk_alarm_support_recipient_history_account1_idx`
- INDEX — `fk_alarm_support_recipient_history_alarm_support_history1_idx`
alarm_trigger
- alarm_trigger_seq — INT — Primary key — NOT NULL
- alarm_trigger_type — VARCHAR(50)
- param_number — INT
- trigger_contents — VARCHAR(200)
- reg_date — DATETIME
- etc1 — VARCHAR(100)
- etc2 — VARCHAR(100)
- alarm_trigger_code — VARCHAR(50)
- FULLTEXT — INDEX
alarm_trigger_config
- alarm_trigger_config_seq — INT — Primary key — NOT NULL
- alarm_trigger_code — VARCHAR(20) — NOT NULL
- factory_id — INT — Foreign key → factory.factory_id — NOT NULL
- param — VARCHAR(200)
- use_yn — VARCHAR(1)
- reg_date — DATETIME
- update_date — DATETIME
- mail_template_id — VARCHAR(6)
- katalk_template_id — VARCHAR(6)
- INDEX — `findIDX`
alarm_type
- alarm_type_id — INT — Primary key — NOT NULL
- factory_id — INT — Foreign key → factory.factory_id
- alarm_type — VARCHAR(100)
- use_yn — VARCHAR(1)
- view_name — VARCHAR(100)
- INDEX — `typeIDX`
- INDEX — `fk_alarm_type_factory1_idx`
area
- area_id — INT — Primary key — NOT NULL
- area_name — VARCHAR(50)
- factory_id — INT — Foreign key → factory.factory_id
- INDEX — `factory_id`
- INDEX — `areaIDX`
auto_inspection_config
- inspection_config_id — INT — Primary key — NOT NULL
- inspection_group_id — INT
- item_cnt — INT
- item_total_cnt — INT
- sample_merge_cnt — INT — NOT NULL
- sample_merge_max_cnt — INT
- channel_name — VARCHAR(10)
- section_id — VARCHAR(50)
- machine_id — INT — NOT NULL
- high_sensitivity — INT
- low_sensitivity — INT
- except_high_threshold — INT
- except_low_threshold — INT
- auto_simul_enable — VARCHAR(6)
- long_idle_enable — INT
- auto_init_enable — INT
- merge_tool_change_enable — INT
- INDEX — `machineidIDX`
auto_inspection_creat
- inspection_num — INT — Primary key — NOT NULL
- inspection_name — VARCHAR(45)
- machine_name — VARCHAR(32)
- machine_id — INT — Foreign key → machine.machine_id
- reg_date — DATETIME — NOT NULL
- section_piece_id — INT — Foreign key
- section_number — INT
- ch_name — VARCHAR(16)
- path — INT — NOT NULL
- section_id — VARCHAR(100) — NOT NULL
- inspection_group_id — INT — Foreign key → inspection_policy_group.inspection_group_id
- inspection_policy_id — INT — Foreign key → inspection_policy.inspection_policy_id — NOT NULL
- factory_id — INT — Foreign key → factory.factory_id — NOT NULL
- product_id — INT — Foreign key → product.product_id — NOT NULL
- machining_section_id — INT — Foreign key → machining_section.machining_section_id
- x1 — INT
- x2 — INT
- error_num — INT
- admin_check — INT
- reason — VARCHAR(45)
- default_thress_low — INT
- default_thress_high — INT
- inspection_lv — INT
- INDEX — `spIDX`
- INDEX — `fk_auto_inspection_creat_factory1_idx`
- INDEX — `fk_auto_inspection_creat_product1_idx`
- INDEX — `fk_auto_inspection_creat_inspection_policy_group1_idx`
- INDEX — `fk_auto_inspection_creat_inspection_policy1_idx`
- INDEX — `fk_auto_inspection_creat_machining_section1_idx`
auto_inspection_history
- history_num — INT — Primary key — NOT NULL
- inspection_name — VARCHAR(45)
- machine_name — VARCHAR(32)
- machine_id — INT — Foreign key → machine.machine_id
- reg_date — DATETIME — NOT NULL
- section_piece_id — INT — Foreign key
- section_number — INT
- ch_name — VARCHAR(16)
- path — INT — NOT NULL
- section_id — VARCHAR(100)
- inspection_group_id — INT — Foreign key → inspection_policy_group.inspection_group_id
- inspection_policy_id — INT — Foreign key → inspection_policy.inspection_policy_id — NOT NULL
- factory_id — INT — Foreign key → factory.factory_id — NOT NULL
- product_id — INT — Foreign key → product.product_id — NOT NULL
- machining_section_id — INT — Foreign key → machining_section.machining_section_id
- x1 — INT
- x2 — INT
- error — VARCHAR(45)
- error_num — INT
- reason — VARCHAR(45)
- admin_check — INT
- INDEX — `policyIDX`
- INDEX — `groupIDX`
- INDEX — `fk_auto_inspection_history_product1_idx`
- INDEX — `fk_auto_inspection_history_inspection_policy_group1_idx`
- INDEX — `fk_auto_inspection_history_inspection_policy1_idx`
- INDEX — `fk_auto_inspection_history_machining_section1_idx`
auto_inspection_status
- auto_inspection_status_id — INT — Primary key — NOT NULL
- inspection_policy_id — INT — Foreign key → inspection_policy.inspection_policy_id
- inspection_group_id — INT — Foreign key → inspection_policy_group.inspection_group_id
- last_update_config — INT
- update_status — INT
- data_update_date — DATETIME
- per_status — INT
- high_sensitive — INT
- low_sensitive — INT
- data_update_config — INT
- INDEX — `policyIDX`
- INDEX — `fk_auto_inspection_status_inspection_policy_group1_idx`
bad_type
- bad_type_seq — INT — Primary key — NOT NULL
- factory_id — INT — NOT NULL
- bad_type_id — INT — NOT NULL
- bad_type_name — VARCHAR(50) — NOT NULL
- contents — VARCHAR(100)
- use_yn — VARCHAR(1)
- write_date — DATETIME
- write_user — VARCHAR(50)
- update_date — DATETIME
- update_user — VARCHAR(50)
- INDEX — `typeIDX`
code_detail
- code_detail_seq — INT — Primary key — NOT NULL — 상세코드 번호
- code_detail_id — VARCHAR(10) — NOT NULL — 상세코드
- code_group_seq — INT — NOT NULL — 그룹코드 번호
- code_detail_name — VARCHAR(200) — NOT NULL — 상세코드 명
- code_detail_des — VARCHAR(200) — 상세코드 설명
- default_val — VARCHAR(10) — 기준값
- use_yn — VARCHAR(1) — NOT NULL — 사용여부
- write_user — VARCHAR(50) — NOT NULL — 등록자
- write_date — DATETIME — NOT NULL — 등록일자
- update_user — VARCHAR(50) — 수정자
- update_date — DATETIME — 수정일자
- qr_file_path — VARCHAR(100)
- qr_original_file_name — VARCHAR(50)
- qr_stored_file_name — VARCHAR(50)
- INDEX — `cdIDX`
- INDEX — `defaultIDX`
code_group
- code_group_seq — INT — Primary key — NOT NULL — 그룹코드 번호
- code_group_id — VARCHAR(8) — NOT NULL — 그룹코드
- factory_id — INT — NOT NULL — 공장 번호
- code_group_name — VARCHAR(200) — NOT NULL — 그룹코드 명
- code_group_des — VARCHAR(200) — 그룹코드 설명
- write_user — VARCHAR(50) — NOT NULL — 등록자
- write_date — DATETIME — NOT NULL — 등록일자
- update_user — VARCHAR(50) — 수정자
- update_date — DATETIME — 수정일자
- INDEX — `cgIDX`
contract
- contract_id — INT — Primary key — NOT NULL
- contract_content — TINYBLOB
- contract_fees — BIGINT
- contract_type — VARCHAR(255)
- manager — VARCHAR(255)
- reg_date — DATETIME
- factory_id — INT — Foreign key → factory.factory_id
- INDEX — `FKr53o4j34dg9jnqivl9ektfxhi`
contract_file
- file_id — INT — Primary key — NOT NULL
- contract_id — INT — NOT NULL
- file — MEDIUMBLOB
- reg_date — DATETIME
- file_name — VARCHAR(50)
- file_size — INT
- content_type — VARCHAR(255)
daily_bad_issue
- bad_issue_seq — INT — Primary key — NOT NULL
- factory_id — INT — NOT NULL
- machine_id — INT — NOT NULL
- machine_statistic_id — INT — NOT NULL
- product_id — INT — NOT NULL
- bad_type_seq — INT — NOT NULL
- bad_qty — INT — NOT NULL
- write_date — DATETIME
- INDEX — `searchIDX`
- INDEX — `statisticIDX`
daily_machine_worker
- machine_id — INT — Primary key — NOT NULL — 설비 아이디
- worker_seq — INT — NOT NULL — 작업자 아이디
- write_date — DATETIME — 기록일자
daily_work_order
- work_order_seq — INT — Primary key — NOT NULL
- factory_id — INT — NOT NULL
- machine_id — INT — NOT NULL
- wrk_date — VARCHAR(10) — NOT NULL
- day_type — VARCHAR(5) — day: 주간 / night: 야간
- process_status — VARCHAR(8) — NOT NULL — stStart, stEnd, stStop
- model_seq — INT
- product_id — INT
- tot_wrk_qty — INT — 총 생산수량
- etc_1 — VARCHAR(100)
- etc_2 — VARCHAR(100)
- write_date — DATETIME
- INDEX — `findIDX`
- INDEX — `periodIDX` — NOT NULL — '신규 작업지시서 '; CREATE TABLE IF NOT EXISTS `qg2indong`.`daily_work_order_bad_issue` ( `work_order_bad_issue_seq` INT NOT N…
- work_order_seq — INT — NOT NULL
- work_order_production_seq — INT — NOT NULL
- code_group_seq — INT — NOT NULL
- code_detail_seq — INT — NOT NULL
- bad_quantity — INT — NOT NULL
- write_date — DATETIME
- INDEX — `searchIDX`
daily_work_order_op_issue
- work_order_op_issue_seq — INT — Primary key — NOT NULL
- work_order_production_seq — INT — Primary key — NOT NULL
- work_order_seq — INT — NOT NULL
- code_group_seq — INT — NOT NULL
- code_detail_seq — INT — NOT NULL
- non_op_time — INT
- write_date — DATETIME
- INDEX — `wrkIDX`
- INDEX — `codeIDX` — NOT NULL — '신규 비가동 내역 '; CREATE TABLE IF NOT EXISTS `qg2indong`.`daily_work_order_production` ( `work_order_production_seq` INT NO…
- work_order_seq — INT — NOT NULL — 작업지시 번호
- factory_id — INT — NOT NULL — 공장 번호
- start_date — DATETIME
- end_date — DATETIME
- process_status — VARCHAR(8)
- worker_seq — INT — 작업자 아이디
- wrk_qty — INT — 생산 수량
- etc_1 — VARCHAR(100)
- etc_2 — VARCHAR(100)
- write_date — DATETIME — 등록 일자
- start_machine_cnt — INT
- end_machine_cnt — INT
- INDEX — `findIDX`
- INDEX — `wrkIDX`
damage_detection_history
- detection_id — INT — Primary key — NOT NULL
- machine_id — INT — Foreign key → machine.machine_id
- product_id — INT — Foreign key → product.product_id
- section_id — VARCHAR(45)
- section_piece_id — INT — Foreign key
- inspection_detail_id — VARCHAR(45)
- reg_date — DATETIME
- write_user — VARCHAR(50)
- channel_name — VARCHAR(25)
- section_number — INT
- item_id — INT — Foreign key → item.item_id
- detection_date — DATETIME
- INDEX — `fk_damage_detection_history_machine1_idx`
- INDEX — `fk_damage_detection_history_product1_idx`
- INDEX — `fk_damage_detection_history_section_piece1_idx`
- INDEX — `fk_damage_detection_history_item1_idx`
damage_item
- damage_item_id — INT — Primary key — NOT NULL
- item_id — INT — Foreign key → item.item_id
- damage_type_id — INT — Foreign key → damage_type.damage_type_id
- contents — VARCHAR(200)
- etc_1 — VARCHAR(45)
- etc_2 — VARCHAR(45)
- etc_3 — VARCHAR(45)
- write_date — DATETIME
- write_user — VARCHAR(50)
- update_date — DATETIME
- update_user — VARCHAR(50)
- INDEX — `itemidIDX`
- INDEX — `damagetypeIDX`
damage_type
- damage_type_id — INT — Primary key — NOT NULL
- damage_type — VARCHAR(100)
- contents — VARCHAR(100)
- use_yn — VARCHAR(2)
- write_date — DATETIME
- write_user — VARCHAR(50)
- update_date — DATETIME
- update_user — VARCHAR(50)
downtime_schedule
- dt_seq — INT — Primary key — NOT NULL
- factory_id — INT — Foreign key → factory.factory_id
- schedule_name — VARCHAR(25)
- start_time — VARCHAR(10)
- end_time — VARCHAR(10)
- auto_use_yn — VARCHAR(1)
- schedule_use_yn — VARCHAR(1)
- day_or_night — VARCHAR(5)
- etc1 — VARCHAR(50)
- etc2 — VARCHAR(50)
- reg_date — DATETIME
- INDEX — `factoryIDX`
drawing_management
- drawing_seq — INT — Primary key — NOT NULL — 도면 번호
- factory_id — INT — NOT NULL — 공장 번호
- drawing_id — VARCHAR(50) — NOT NULL — 도면 코드
- write_user — VARCHAR(50) — 등록자
- write_date — DATETIME — 등록일자
- update_user — VARCHAR(50) — 수정자
- update_date — DATETIME — 수정일자
- INDEX — `drawingIdIDX`
drawing_rev
- drawing_rev_seq — INT — Primary key — NOT NULL — 도면 리비전 번호
- drawing_seq — INT — NOT NULL — 도면 번호
- drawing_rev — INT — NOT NULL — 리비전
- file_path — VARCHAR(200) — 파일경로
- original_file_name — VARCHAR(50) — 원본 파일명
- stored_file_name — VARCHAR(50) — 저장 파일명
- write_user — VARCHAR(50) — 등록자
- write_date — DATETIME — 등록일자
- update_user — VARCHAR(50) — 수정자
- update_date — DATETIME — 수정일자
- INDEX — `drawingIdIDX`
external_api_history
- api_history_seq — INT — Primary key — NOT NULL
- factory_id — INT — Foreign key → factory.factory_id — NOT NULL
- machine_id — INT — Foreign key → machine.machine_id
- api_url — VARCHAR(100) — NOT NULL
- req_date — DATETIME — NOT NULL
- res_date — DATETIME
- res_result — INT — 0: 성공 1: 실패
- account_id — VARCHAR(50) — Foreign key → account.account_id
- reason — VARCHAR(100)
- req_ip — VARCHAR(50)
- data_size — INT
- INDEX — `apiHistoryIDX`
- INDEX — `apiDateIDX`
- INDEX — `fk_external_api_history_machine1_idx`
- INDEX — `fk_external_api_history_account1_idx`
factory
- factory_id — INT — Primary key — NOT NULL
- address — VARCHAR(255)
- company — VARCHAR(255)
- contract_quantity — INT
- engineer_name — VARCHAR(255)
- factory_manager — VARCHAR(255)
- factory_name — VARCHAR(255)
- install_type — VARCHAR(255)
- reg_date — DATETIME
- alarm_send_use_yn — VARCHAR(1)
- secret_key — VARCHAR(16)
inspection_policy
- inspection_policy_id — INT — Primary key — NOT NULL
- stop_type — VARCHAR(20)
- respite_cnt — INT
- high_threshold — FLOAT
- low_threshold — FLOAT
- active_yn — VARCHAR(2)
- reg_date — DATETIME
- inspection_group_id — INT — Foreign key → inspection_policy_group.inspection_group_id
- lv_type — INT
- INDEX — `inspectiongroupIDX`
inspection_policy_group
- inspection_group_id — INT — Primary key — NOT NULL
- section_piece_id — INT — Foreign key
- product_id — INT — Foreign key → product.product_id
- machining_section_id — INT — Foreign key → machining_section.machining_section_id
- inspection_name — VARCHAR(100)
- inspection_type — VARCHAR(25)
- section_number — INT
- tool_name — VARCHAR(25)
- reg_date — DATETIME
- start_tick — INT
- end_tick — INT
- start_date — DATETIME
- end_date — DATETIME
- inspection_src — TEXT
- write_user — VARCHAR(50)
- update_user — VARCHAR(50)
- update_date — DATETIME
- inspection_config_id — INT
- INDEX — `sectionpieceIDX`
- INDEX — `machiningsectionIDX`
- INDEX — `productIDX`
inspection_timer
- inspection_timer_id — INT — Primary key — NOT NULL
- item_stop_time — INT
- item_run_cnt — INT
- inspection_timer_on_date — DATETIME
- use_yn — VARCHAR(1)
- machine_id — INT — Foreign key → machine.machine_id
- write_date — DATETIME
- write_user — VARCHAR(50)
- update_date — DATETIME
- update_user — VARCHAR(50)
- bf_machine_id — INT
- INDEX — `inspectionTimerIDX`
item
- item_id — INT — Primary key — NOT NULL
- cycle_time — FLOAT
- item_type — VARCHAR(25)
- machine_cnt — INT
- machining_section_id — INT — Foreign key → machining_section.machining_section_id
- reg_date — DATETIME
- tool_use_info — TEXT
- product_id — INT — Foreign key → product.product_id
- inspection_result — TEXT
- cycle_type — VARCHAR(20)
- today_cnt — INT
- item_tag — TEXT
- barcode_id — VARCHAR(20)
- pallets_no — INT
- INDEX — `reg_date`
- INDEX — `FKd1g72rrhgq1sf7m4uwfvuhlhe`
- INDEX — `item_type`
- INDEX — `productIDX`
- FULLTEXT — INDEX
- INDEX — `fk_item_machining_section1_idx`
item_ct
- item_ct_seq — INT — Primary key — NOT NULL
- factory_id — INT — Foreign key → factory.factory_id
- qg_client_id — INT — Foreign key
- machine_id — INT — Foreign key → machine.machine_id
- product_id — INT — Foreign key → product.product_id
- pallets_no — INT
- item_id — INT — Foreign key → item.item_id
- cycle_time — DOUBLE
- item_type_id — INT — Foreign key → item_type.item_type_id
- etc1 — VARCHAR(25)
- etc2 — VARCHAR(25)
- reg_date — DATETIME
- INDEX — `factoryIDX`
- INDEX — `MPIDX`
- INDEX — `machinecntIDX`
- INDEX — `fk_item_ct_item1_idx`
- INDEX — `fk_item_ct_product1_idx`
- INDEX — `fk_item_ct_qg_client1_idx`
- INDEX — `fk_item_ct_item_type1_idx`
item_qrcode
- qrcode_seq — INT — Primary key — NOT NULL
- qrcode_id — VARCHAR(20)
- item_id — INT — Foreign key → item.item_id
- factory_id — INT — Foreign key → factory.factory_id
- machine_id — INT — Foreign key → machine.machine_id
- product_id — INT — Foreign key → product.product_id
- reg_date — DATETIME
- FULLTEXT — INDEX
- INDEX — `fk_item_qrcode_item1_idx`
- INDEX — `fk_item_qrcode_factory1_idx`
- INDEX — `fk_item_qrcode_machine1_idx`
- INDEX — `fk_item_qrcode_product1_idx`
item_tool_ct
- item_ct_tool_seq — INT — Primary key — NOT NULL
- item_ct_seq — INT — Foreign key → item_ct.item_ct_seq — NOT NULL
- channel_name — VARCHAR(25)
- path — INT — NOT NULL
- section_number — INT — NOT NULL
- tool_name — VARCHAR(25)
- section_data_size — INT
- factory_id — INT — Foreign key → factory.factory_id
- qg_client_id — INT — Foreign key
- machine_id — INT — Foreign key → machine.machine_id
- product_id — INT — Foreign key → product.product_id
- pallets_no — INT
- item_id — INT — Foreign key → item.item_id
- item_type_id — INT — Foreign key → item_type.item_type_id
- section_type — VARCHAR(25)
- etc1 — VARCHAR(25)
- etc2 — VARCHAR(25)
- reg_date — DATETIME
- INDEX — `itcIDX`
- INDEX — `icIDX`
- INDEX — `msIDX`
- INDEX — `fk_item_tool_ct_factory1_idx`
- INDEX — `fk_item_tool_ct_qg_client1_idx`
- INDEX — `fk_item_tool_ct_item1_idx`
- INDEX — `fk_item_tool_ct_item_type1_idx`
item_type
- item_type_seq — INT — Primary key — NOT NULL
- item_type_id — INT — NOT NULL
- item_type — VARCHAR(25)
- etc1 — VARCHAR(25)
- etc2 — VARCHAR(25)
- INDEX — `idIDX`
- FULLTEXT — INDEX
log_api_key
- api_id — VARCHAR(20) — Primary key — NOT NULL
- api_key — VARCHAR(50)
- etc1 — VARCHAR(20)
- etc2 — VARCHAR(20)
machine
- machine_id — INT — Primary key — NOT NULL
- qg_client_id — INT — Foreign key
- current_product_id — INT
- cnc_vendor — VARCHAR(25)
- cnc_serial — VARCHAR(50)
- cnc_type — VARCHAR(25)
- cnc_version — VARCHAR(25)
- machine_name — VARCHAR(50)
- machine_status_type — VARCHAR(50)
- machine_type — VARCHAR(25)
- real_time_efficiency — FLOAT
- reg_date — DATETIME
- warn_status — VARCHAR(25)
- feeder_type — VARCHAR(20)
- use_machine_count — VARCHAR(2)
- view_yn — VARCHAR(2)
- area_id — INT — Foreign key → area.area_id
- warn_msg — VARCHAR(200)
- sort_seq — INT
- inspection_use — VARCHAR(2)
- stop_use — VARCHAR(2)
- operate_message — VARCHAR(200)
- feed_rate — INT
- spindle_speed — INT
- machine_alarm — VARCHAR(200)
- last_product_date — DATETIME
- total_production_rate — FLOAT
- goal_cnt — INT
- status_delay — INT
- product_change_stop_use — VARCHAR(2)
- product_change_inspection_use — VARCHAR(2)
- warn_item_id — INT
- warn_section_piece_id — INT
- last_status_date — DATETIME
- today_cnt — INT
- pallets_cnt — INT
- process_id — INT — Foreign key → process.process_id
- real_time_cycle_time — FLOAT
- ncprogram_change_stop_use — VARCHAR(2)
- ncprogram_change_inspection_use — VARCHAR(2)
- rapid_override — INT
- total_target_yn — VARCHAR(1)
- machine_cnt — INT
- today_machine_cnt — INT
- temp — INT
- last_machining_status_id — INT
- last_machine_status_id — INT
- basic_section_alarm — INT
- pallets_production_target — VARCHAR(10)
- virtual_yn — VARCHAR(1)
- INDEX — `qg_client_id`
- INDEX — `current_product_id`
- INDEX — `areaIDX`
- INDEX — `sortIDX`
- INDEX — `fk_machine_process1_idx`
- INDEX — `fk_machine_area1_idx`
machine_alarm_status
- machine_alarm_status_id — INT — Primary key — NOT NULL
- machine_id — INT — Foreign key → machine.machine_id
- reg_date — DATETIME
- update_date — DATETIME
- holding_time — INT
- status_type — VARCHAR(25)
- etc1 — VARCHAR(200)
- etc2 — VARCHAR(200)
- alarm_type_id — INT
- INDEX — `alarmIDX`
- INDEX — `typeIDX`
machine_event
- machine_event_id — INT — Primary key — NOT NULL
- machine_id — INT — Foreign key → machine.machine_id
- machine_event_type — VARCHAR(50)
- reg_date — DATETIME
- event_msg — MEDIUMTEXT
- tool_name — VARCHAR(50)
- current_product_id — INT
- write_user — VARCHAR(50)
- INDEX — `reg_date`
- INDEX — `machine_id`
- INDEX — `typedateIDX`
- FULLTEXT — INDEX
machine_maintenance_history
- maintenance_history_seq — INT — Primary key — NOT NULL — 등록순번
- factory_id — INT — NOT NULL — 공장번호
- machine_id — INT — NOT NULL — 설비번호
- maintenance_type_id — INT — NOT NULL — 유지 보수 유형
- maintenance_detail — VARCHAR(200) — 유지 보수 내용
- use_parts — VARCHAR(100) — 사용 부품
- maintenance_time — INT — 유지 보수 시간
- maintenance_amount — INT — 유지 보수 금액
- etc1 — VARCHAR(200) — 비고1
- worker_seq — INT — 작업자 아이디
- reg_date — DATETIME — 기록일자
- write_date — DATETIME — 등록일자
- write_user — VARCHAR(50) — 등록자
- update_user — VARCHAR(50) — 수정자
- update_date — DATETIME — 수정일자
- INDEX — `machineidIDX`
- INDEX — `dateIDX`
machine_offset
- machine_offset_id — INT — Primary key — NOT NULL
- machine_id — INT
- offset_no — INT
- offset_location_type — VARCHAR(20)
- offset_value_type — VARCHAR(20)
- offset_value — INT
- reg_date — DATETIME
- INDEX — `machine_id`
machine_spec
- machine_id — INT — Primary key — NOT NULL — 설비번호
- factory_id — INT — NOT NULL — 공장번호
- model_id — VARCHAR(50) — 기종
- manufacture_company_id — INT — 제조업체
- serial_number — VARCHAR(50) — 제조번호
- manufacture_date — DATETIME — 제조일자
- disposal_date — DATETIME — 폐기일자
- purchase_amount — VARCHAR(50) — 구입금액
- machine_type_id — INT — 설비구분
- etc1 — VARCHAR(200) — 비고1
- etc2 — VARCHAR(200) — 비고2
- write_date — DATETIME — NOT NULL — 등록일자
- write_user — VARCHAR(50) — NOT NULL — 등록자
- update_date — DATETIME — 수정일자
- update_user — VARCHAR(50) — 수정자
- INDEX — `machinespecIDX`
machine_statistic
- machine_statistic_id — INT — Primary key — NOT NULL
- machine_id — INT — Foreign key → machine.machine_id
- schedule_policy_id — INT — Foreign key
- start_date — DATETIME
- end_date — DATETIME
- statistic_content — TEXT
- statistic_date — VARCHAR(25)
- last_total_cnt — INT
- run_time — FLOAT
- hold_time — FLOAT
- stop_time — FLOAT
- dis_time — FLOAT
- mt_time — FLOAT
- cl_time — FLOAT
- gc_time — FLOAT
- tc_time — FLOAT
- failure_time — FLOAT
- tool_change_list — VARCHAR(25)
- day_type — INT
- INDEX — `daytypeIDX`
- INDEX — `spIDX`
- INDEX — `machineIDX`
machine_status
- machine_status_id — INT — Primary key — NOT NULL
- machine_id — VARCHAR(25) — Foreign key → machine.machine_id
- reg_date — DATETIME
- update_date — DATETIME
- machine_status_type — VARCHAR(25)
- delay_state — VARCHAR(15)
- delay_reg_date — DATETIME
- INDEX — `machine_id`
machine_temperature
- temp_id — INT — Primary key — NOT NULL
- machine_id — INT — Foreign key → machine.machine_id — NOT NULL
- temp — INT — NOT NULL
- reg_date — DATETIME — NOT NULL
- INDEX — `MTsearchIDX`
machine_tool
- machine_tool_id — INT — Primary key — NOT NULL
- machine_id — INT — Foreign key → machine.machine_id
- tool_name — VARCHAR(25)
- reg_date — DATETIME
- preset_cnt — INT
- use_cnt — INT
- machine_offset_id — INT
- tool_wearing_max — FLOAT
- tool_wearing_now — FLOAT
- tool_spec — VARCHAR(50)
- tool_exp — VARCHAR(100)
- path — INT
- use_yn — VARCHAR(2) — NOT NULL
- changed_date — DATETIME
- tool_price — INT
- view_name — VARCHAR(50)
- sort_seq — INT
- bf_machine_tool_id — INT
- bf_machine_id — INT
- INDEX — `machine_id`
machine_tool_history
- machine_tool_history_id — INT — Primary key — NOT NULL
- machine_tool_id — INT
- machine_id — INT
- tool_name — VARCHAR(20)
- use_cnt — INT
- preset_cnt — INT
- tool_wearing_max — FLOAT
- tool_wearing_now — FLOAT
- tool_spec — VARCHAR(50)
- tool_exp — VARCHAR(100)
- reg_date — DATETIME
- changed_date — DATETIME
- machine_offset_id — INT
- tool_wearing — FLOAT
- current_product_id — INT
- current_view_name — VARCHAR(50)
- changed_time — INT
- INDEX — `productIDX`
- INDEX — `machineIDX`
- INDEX — `dateIDX`
- FULLTEXT — INDEX
machines_work_order
- mwo_seq — INT — Primary key — NOT NULL
- factory_id — INT — NOT NULL
- machine_id — INT — NOT NULL
- work_order_seq — INT
- wrk_qty — INT
- process_status — VARCHAR(8)
- start_date — DATETIME
- active_yn — VARCHAR(1)
- write_date — DATETIME
- wrk_date — VARCHAR(10)
- day_type — VARCHAR(5)
machining_section
- machining_section_id — INT — Primary key — NOT NULL
- active_yn — VARCHAR(2) — NOT NULL
- reg_date — DATETIME
- product_id — INT — Foreign key → product.product_id
- reason — VARCHAR(255)
- basic_raw_data — LONGTEXT
- item_id — INT — Foreign key → item.item_id
- smart_active_yn — VARCHAR(2)
- smart_start_date — DATETIME
- smart_end_date — DATETIME
- smart_sum_cnt — INT
- update_date — DATETIME
- pallets_no — INT
- machining_section_config_id — INT
- INDEX — `FK6pct72u3ca1pw5k51vsbfajdq`
- INDEX — `palletsnoIDX`
- INDEX — `fk_machining_section_item1_idx`
machining_section_config
- machining_section_config_id — INT — Primary key — NOT NULL
- machining_section_id — INT — Foreign key → machining_section.machining_section_id — NOT NULL
- machine_product_cycle_type — INT
- machine_section_cycle_type — INT
- machine_start_code — INT
- machine_end_code — INT
- machine_sync_tick — INT
- machine_end_hold_time — INT
- reg_date — DATETIME
- write_user — VARCHAR(50)
- update_user — VARCHAR(50)
- update_date — DATETIME
- INDEX — `machining_section_id_idx`
machining_section_history
- machining_section_history_id — INT — Primary key — NOT NULL
- machining_section_id — INT — Foreign key → machining_section.machining_section_id — NOT NULL
- active_yn — VARCHAR(2)
- reg_date — DATETIME
- product_id — INT — Foreign key → product.product_id
- reason — VARCHAR(255)
- basic_raw_data — LONGTEXT
- item_id — INT — Foreign key → item.item_id
- smart_active_yn — VARCHAR(2)
- smart_start_date — DATETIME
- smart_end_date — DATETIME
- smart_sum_cnt — INT
- update_date — DATETIME
- INDEX — `idx_msh`
- INDEX — `fk_machining_section_history_machining_section1_idx`
- INDEX — `fk_machining_section_history_item1_idx`
machining_status
- machining_status_id — INT — Primary key — NOT NULL
- machine_id — INT — Foreign key → machine.machine_id
- reg_date — DATETIME
- update_date — DATETIME
- machining_status_type — VARCHAR(25)
- alarm_message — VARCHAR(100)
- INDEX — `machiningIDX`
mapping_model_product
- model_product_seq — INT — Primary key — NOT NULL
- factory_id — INT — NOT NULL
- model_seq — INT — NOT NULL
- product_id — INT
- etc_1 — VARCHAR(200)
- use_yn — VARCHAR(1)
- write_date — DATETIME
- write_user — VARCHAR(50)
- INDEX — `modelIDX`
mapping_model_tool
- model_tool_seq — INT — Primary key — NOT NULL
- factory_id — INT — NOT NULL
- model_seq — INT — NOT NULL
- tool_management_seq — INT
- tool_no — INT
- tool_port — VARCHAR(5)
- etc_1 — VARCHAR(200)
- use_yn — VARCHAR(1)
- write_date — DATETIME
- write_user — VARCHAR(50)
- INDEX — `modelIDX`
- INDEX — `toolIDX`
- INDEX — `historyIDX`
model
- model_id — INT — Primary key — NOT NULL
- section_piece_id — INT — Foreign key — NOT NULL
- machining_section_id — INT — Foreign key → machining_section.machining_section_id
- model_inspection_id — INT — Foreign key → model_inspection.model_inspection_id
- model_name — VARCHAR(500)
- model_path — VARCHAR(500)
- start_tick — INT
- end_tick — INT
- reg_date — DATETIME
- active — VARCHAR(2)
- score — VARCHAR(500)
- type — VARCHAR(20)
- threshold — INT
- item_id_list — TEXT
- INDEX — `spIdAndType`
- INDEX — `fk_model_machining_section1_idx`
- INDEX — `fk_model_model_inspection1_idx`
model_inspection
- model_inspection_id — INT — Primary key — NOT NULL
- model_type — VARCHAR(40)
- inspection_name — VARCHAR(45)
- n_estimators — INT
- n_neighbors — INT
- algorithm — VARCHAR(10)
- novelty — VARCHAR(10)
- fit_intercept — VARCHAR(10)
- copy_X — VARCHAR(10)
- n_jobs — INT
- contamination — DOUBLE
- reg_date — DATETIME
model_item
- model_item_id — BIGINT — Primary key — NOT NULL
- machine_id — INT — Foreign key → machine.machine_id
- product_id — INT — Foreign key → product.product_id
- item_id — INT — Foreign key → item.item_id
- client_item_id — BIGINT
- model_item_score — INT
- anomaly_score — DECIMAL(10,0)
- ai_threshold — DECIMAL(10,0)
- status — VARCHAR(10)
- reg_date — DATETIME
- INDEX — `fk_model_item_machine1_idx`
- INDEX — `fk_model_item_product1_idx`
- INDEX — `fk_model_item_item1_idx`
model_item_score
- model_score_seq — INT — Primary key — NOT NULL
- machine_id — INT — Foreign key → machine.machine_id
- product_id — INT — Foreign key → product.product_id
- client_item_id — BIGINT
- inspection_group_id — INT — Foreign key → inspection_policy_group.inspection_group_id
- inspection_policy_id — INT — Foreign key → inspection_policy.inspection_policy_id
- model_item_score — INT
- anomaly_score — DECIMAL(10,5)
- ai_threshold — DECIMAL(10,5)
- status — VARCHAR(10)
- reg_date — DATETIME
- model_name — VARCHAR(45)
- INDEX — `idx01`
- INDEX — `fk_model_item_score_product1_idx`
- INDEX — `fk_model_item_score_inspection_policy_group1_idx`
- INDEX — `fk_model_item_score_inspection_policy1_idx`
model_management
- model_seq — INT — Primary key — NOT NULL — 모델 순번
- model_name — VARCHAR(100) — NOT NULL — 모델명
- vendor_name — VARCHAR(50)
- cycle_time — DOUBLE
- factory_id — INT — Foreign key → factory.factory_id — NOT NULL — 공장 번호
- file_path — VARCHAR(100)
- original_file_name — VARCHAR(100)
- stored_file_name — VARCHAR(50)
- use_yn — VARCHAR(1) — 사용여부
- write_user — VARCHAR(50) — 등록자
- write_date — DATETIME — 기록일자
- update_user — VARCHAR(50) — 수정자
- update_date — DATETIME — 수정일자
- INDEX — `modelnameIDX`
monitoring_issue
- issue_id — INT — Primary key — NOT NULL
- machine_id — INT
- good_cnt — INT
- info_cnt — INT
- warn_cnt — INT
- error_cnt — INT
- stop_cnt — INT
- badsync_cnt — INT
- gcode_change_cnt — INT
- product_change_cnt — INT
- contents — MEDIUMTEXT
- start_date — DATETIME
- end_date — DATETIME
- write_user — VARCHAR(50)
- write_date — DATETIME
- update_user — VARCHAR(50)
- update_date — DATETIME
- issue_status — VARCHAR(20)
monitoring_user_issue
- user_issue_id — INT — Primary key — NOT NULL
- issue_id — INT
- account_id — VARCHAR(50)
- write_date — DATETIME
- write_user — VARCHAR(50)
- update_date — DATETIME
- update_user — VARCHAR(50)
plc_log
- plc_log_seq — INT — Primary key — NOT NULL
- qg_client_id — INT — NOT NULL
- machine_id — INT
- machine_type — VARCHAR(50)
- client_req_type — VARCHAR(50)
- req_body — TEXT
- etc_1 — VARCHAR(100)
- result — INT
- reg_date — DATETIME
- write_date — DATETIME — 작성일
- update_date — DATETIME — 수정일
- INDEX — `insert_IDX`
- INDEX — `searchIDX`
- INDEX — `processIDX`
plc_structure
- plc_col_id — VARCHAR(50) — Primary key — NOT NULL — 공통코드
- p_plc_col_id — VARCHAR(50) — 상위공통코드
- plc_col — VARCHAR(50) — 수정자
- plc_col_nm — VARCHAR(100) — 공통코드명
- plc_col_des — VARCHAR(200) — 공통코드설명
- sort_seq — INT
- use_yn — CHAR(1) — 사용여부
- write_date — DATETIME — 작성일
- write_user — VARCHAR(50) — 작성자
- update_date — DATETIME — 수정일
- INDEX — `c_cd_IX_01`
process
- process_id — INT — Primary key — NOT NULL
- process_name — VARCHAR(255)
- area_id — INT — Foreign key → area.area_id
- use_yn — VARCHAR(1)
- INDEX — `area_id`
product
- product_id — INT — Primary key — NOT NULL
- machine_id — INT — Foreign key → machine.machine_id
- cycle_time — FLOAT
- product_name — VARCHAR(300)
- product_oid — VARCHAR(50)
- static_cycle_time — FLOAT
- dynamic_cycle_time — FLOAT
- today_cnt — INT
- reg_date — DATETIME
- last_production_date — DATETIME
- last_production_cnt — INT
- barfeeder_seq — INT
- barfeeder_max_seq — INT
- reset_time — DATETIME
- inspection_hash — VARCHAR(45)
- active_yn — VARCHAR(1) — NOT NULL
- is_N1111_detect — INT
- is_N9999_detect — INT
- multiple_count — INT
- INDEX — `machine_id`
product_gcode
- product_gcode_id — INT — Primary key — NOT NULL
- machine_id — INT — Foreign key → machine.machine_id
- product_id — INT — Foreign key → product.product_id
- gcode_type — VARCHAR(20)
- changed_date — DATETIME
- path — VARCHAR(25)
- ex_product_gcode_id — INT
- gcode_content — TEXT
- oid — VARCHAR(50)
- hash — VARCHAR(100)
- reg_date — DATETIME
- INDEX — `machine_id`
- INDEX — `productIDX`
product_order
- product_order_seq — INT — Primary key — NOT NULL — 제품 발주 번호
- product_order_no — VARCHAR(50) — 발행 번호
- factory_id — INT — NOT NULL — 공장 번호
- reg_year — INT — NOT NULL
- reg_month — INT — NOT NULL — 발주 월
- goal_quantity — INT — NOT NULL — 발주 수량
- product_quantity — INT — 생산 수량
- model_seq — INT — NOT NULL — 모델 순번
- use_yn — VARCHAR(1) — 사용여부
- etc_1 — VARCHAR(200) — 기타1
- etc_2 — VARCHAR(200) — 기타2
- write_user — VARCHAR(50) — NOT NULL — 등록자
- write_date — DATETIME — NOT NULL — 등록일자
- update_user — VARCHAR(50) — 수정자
- update_date — DATETIME — 수정일자
- INDEX — `dateIDX`
- INDEX — `productorderIDX`
product_tool
- product_tool_seq — INT — Primary key — NOT NULL
- tool_management_seq — INT
- tool_name — VARCHAR(10)
- product_id — INT — Foreign key → product.product_id — NOT NULL
- machine_id — INT — Foreign key → machine.machine_id — NOT NULL
- use_cnt — INT
- preset_cnt — INT
- use_yn — VARCHAR(1)
- changed_date — DATETIME
- reg_date — DATETIME
- sort_seq — INT
- view_name — VARCHAR(50)
- INDEX — `itemRegIDX`
- INDEX — `toolIDX`
- INDEX — `fk_product_tool_product1_idx`
and 16 more tables