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