aa

Tables (50)

comm_d

  • biz_cd — nvarchar(10) — Primary key — NOT NULL — 비즈니스 코드
  • comm_h_cd — nvarchar(20) — Primary key — NOT NULL
  • comm_d_cd — nvarchar(20) — Primary key — NOT NULL
  • comm_d_nm — nvarchar(500) — NOT NULL
  • comm_d_ref — nvarchar(100)
  • comm_d_desc — nvarchar(200)
  • disp_idx — int
  • use_yn — char(1) — NOT NULL
  • i_date — datetime — NOT NULL
  • i_user — nvarchar(20) — NOT NULL
  • u_date — datetime
  • u_user — nvarchar(20)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

comm_h

  • comm_h_cd — nvarchar(20) — Primary key — NOT NULL
  • biz_cd — nvarchar(5) — NOT NULL
  • comm_h_nm — nvarchar(20) — NOT NULL
  • comm_h_desc — nvarchar(2000) — NOT NULL
  • use_yn — char(1) — NOT NULL
  • i_date — datetime — NOT NULL
  • i_user — nvarchar(20) — NOT NULL
  • u_date — datetime
  • u_user — nvarchar(20)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

comm_img

  • img_code — int — Primary key — NOT NULL
  • img_type — varchar(10)
  • img_path — varchar(255)
  • img_width — numeric(18, 0)
  • img_height — numeric(18, 0)
  • use_yn — varchar(1) — NOT NULL
  • i_date — datetime — NOT NULL
  • i_user — varchar(20) — NOT NULL
  • u_date — datetime
  • u_user — varchar(20)
  • img — image
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

diagnose_report_alarm_parameter

  • idx — bigint — Primary key — NOT NULL
  • report_log_id — bigint
  • user_report_log_id — bigint — NOT NULL — 레포트 로그 아이디
  • parts_type — varchar(255)
  • sensor — varchar(50)
  • param_id — varchar(255) — NOT NULL
  • graph_color — varchar(255)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

diagnose_report_alarm_parameter_mst

  • idx — bigint — Primary key — NOT NULL
  • report_log_id — bigint — 레포트 로그 아이디
  • user_report_log_id — bigint — NOT NULL — 알람 파라미터 별 아이디
  • report_to_date — datetime — 진단 시작 일자
  • report_from_date — datetime — 진단 종료 일자
  • report_date_type — varchar(10) — 진단 일자 타입
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

diagnose_report_chart_image

  • idx — bigint — Primary key — NOT NULL
  • report_log_id — bigint
  • user_report_log_id — bigint — NOT NULL
  • category — varchar(50)
  • img_type — varchar(50)
  • display_idx — int
  • img — image
  • i_date — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

diagnose_report_draft

  • draft_code — bigint — Primary key — NOT NULL
  • equipment_code — varchar(255) — NOT NULL
  • report_id — bigint
  • diagnosis_code — int — NOT NULL
  • diagnose_note — nvarchar(max)
  • diagnose_date — datetime
  • u_user — varchar(255)
  • u_user_nm — nvarchar(50)
  • save_yn — char(1)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

diagnose_report_form_chart

  • form_chart_id — bigint — Primary key — NOT NULL
  • report_log_id — bigint
  • user_report_log_id — bigint — NOT NULL
  • group_idx — int
  • zone_idx — int
  • chart_idx — int
  • chart_type — varchar(10)
  • parts_code — varchar(50)
  • data_type — varchar(50)
  • data_tag — varchar(30)
  • fr_dt — datetime
  • to_dt — datetime
  • i_date — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

diagnose_report_form_file

  • form_file_id — bigint — Primary key — NOT NULL
  • report_log_id — bigint
  • user_report_log_id — bigint — NOT NULL
  • file_s_name — nvarchar(300)
  • file_c_name — nvarchar(300)
  • file_ext — varchar(10)
  • file_size — bigint
  • i_date — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

diagnose_report_form_image

  • form_image_id — bigint — Primary key — NOT NULL
  • report_log_id — bigint
  • user_report_log_id — bigint — NOT NULL
  • form_chart_id — bigint
  • category — varchar(50)
  • group_idx — int
  • chart_type — varchar(50)
  • chart_name — varchar(50)
  • chart_idx — int
  • img_type — varchar(50)
  • img — image
  • stamp — nvarchar(200)
  • i_date — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

diagnose_report_form_intro

  • form_intro_id — bigint — Primary key — NOT NULL
  • report_log_id — bigint
  • user_report_log_id — bigint — NOT NULL
  • group_idx — int
  • zone_type — int
  • zone_idx — int
  • zone_name — nvarchar(100)
  • data_type — varchar(30)
  • data_tag — varchar(30)
  • chart_type — varchar(30)
  • parts_code — varchar(30)
  • failure_code — varchar(30)
  • equipment_code — varchar(30)
  • fr_dt — date
  • to_dt — date
  • chk_dt0 — datetime
  • chk_dt1 — datetime
  • chk_dt2 — datetime
  • trend_id0 — int
  • trend_id1 — int
  • trend_id2 — int
  • trend_val0 — nvarchar(100)
  • trend_val1 — nvarchar(100)
  • trend_val2 — nvarchar(100)
  • remark — nvarchar(300)
  • i_date — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

diagnose_report_form_note

  • form_note_id — bigint — Primary key — NOT NULL
  • report_log_id — bigint
  • user_report_log_id — bigint — NOT NULL
  • form_chart_id — bigint
  • stype — varchar(50)
  • label — varchar(50)
  • option — varchar(1000)
  • i_date — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

diagnose_report_form_result

  • form_result_id — bigint — Primary key — NOT NULL
  • report_log_id — bigint
  • parts_code — varchar(255)
  • fail_code — varchar(255)
  • i_user — varchar(20)
  • i_date — datetime
  • u_user — varchar(20)
  • u_date — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

diagnose_report_log

  • report_log_id — bigint — Primary key — NOT NULL
  • report_id — bigint — Primary key — NOT NULL — 레포트 아이디
  • diagnose_date — datetime
  • diagnose_note — nvarchar(max)
  • u_user — varchar(255)
  • action_yn — char(1)
  • diagnose_temp_note — nvarchar(max)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

diagnose_report_log_user

  • user_report_log_id — bigint — Primary key — NOT NULL
  • report_log_id — bigint
  • i_user — varchar(50)
  • i_date — datetime
  • save_yn — char(1)
  • diagnosis_code — int
  • report_id — bigint
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

diagnose_report_mst

  • report_id — bigint — Primary key — NOT NULL — 아이디
  • diagnose_result — nvarchar(20) — 판단 결과
  • plant_code — varchar(20) — 공장 아이디
  • equipment_code — varchar(255) — 설비 코드
  • dt_code — varchar(10) — 진단 유형
  • report_date — datetime — 진단 일시
  • diagnose_outline — nvarchar(30) — 진단 개요
  • alarm_result — nvarchar(20) — 진단 심각도
  • report_type — nvarchar(50) — 등록 일자
  • complete_log_id — bigint
  • diagnosis_code — int
  • manual_yn — char(1)
  • auto_failure_code — varchar(255)
  • title — nvarchar(300)
  • action_log_id — bigint
  • action_yn — char(1)
  • action_title — nvarchar(300)
  • parts_code — varchar(255)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

diagnose_report_operation

  • idx — bigint — NOT NULL
  • report_log_id — bigint
  • user_report_log_id — bigint
  • from_date — datetime
  • to_date — datetime

diagnose_report_raw_data

  • idx — bigint — Primary key — NOT NULL
  • report_log_id — bigint — 레포트 로그 아이디
  • user_report_log_id — bigint
  • parts_type — varchar(255)
  • sensor — varchar(10) — 파라미터
  • chart_type — varchar(255) — NOT NULL
  • chart_csv_path — nvarchar(max)
  • report_date — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

diagnose_report_rule_parameter

  • idx — bigint — Primary key — NOT NULL
  • report_log_id — bigint — 레포트 로그 아이디
  • user_report_log_id — bigint
  • parts_type — varchar(255)
  • param_id — varchar(255)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

diagnose_report_template

  • template_no — int — Primary key — NOT NULL
  • category_code — nvarchar(50) — Primary key — NOT NULL
  • template_name — nvarchar(50)
  • creation_type — nvarchar(10)
  • display_idx — int — NOT NULL
  • category_name — nvarchar(50) — NOT NULL
  • html — nvarchar(max) — NOT NULL
  • dynamic_code — nvarchar(100)
  • description — nvarchar(500)
  • ref_table — nvarchar(300)
  • i_date — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

dt_equipment_alarm_item_list

  • alarm_code — int — Primary key — NOT NULL
  • equipment_code — varchar(255)
  • parameter_code — varchar(30) — NOT NULL
  • alarm_name — varchar(30) — NOT NULL
  • alarm_type — char(2) — NOT NULL
  • alarm_grade — varchar(255) — NOT NULL
  • alarm_term — varchar(255)
  • alarm_formula — nvarchar(255)
  • alarm_use_yn — char(1)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

dt_equipment_item_list

  • equipment_code — varchar(255) — Primary key — NOT NULL
  • dt_item_code — varchar(20) — Primary key — NOT NULL
  • dt_item_d_code — varchar(50) — Primary key — NOT NULL
  • dt_item_d_name — nvarchar(50) — NOT NULL
  • dt_item_d_desc — nvarchar(2000)
  • dt_ver_code — int
  • dt_ver_default — int
  • dt_item_ref — nvarchar(255)
  • disp_idx — int — NOT NULL
  • use_yn — varchar(1) — NOT NULL
  • i_date — datetime — NOT NULL
  • i_user — varchar(20) — NOT NULL
  • u_date — datetime
  • u_user — varchar(20)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

dt_equipment_list

  • equipment_code — nvarchar(255) — Primary key — NOT NULL
  • dt_img — int
  • dt_desc — nvarchar(2000)
  • dt_ver_code — int
  • dt_ver_default — int
  • use_yn — varchar(1) — NOT NULL
  • i_date — datetime — NOT NULL
  • i_user — varchar(20) — NOT NULL
  • u_date — datetime
  • u_user — varchar(20)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

dt_equipment_match

  • equipment_code — varchar(255) — Primary key — NOT NULL
  • dt_item_code — varchar(20) — Primary key — NOT NULL
  • dt_ver_code — int — Primary key — NOT NULL
  • dt_item_d_code — varchar(50) — Primary key — NOT NULL
  • dt_item_d_name — nvarchar(50) — NOT NULL
  • dt_item_d_desc — nvarchar(2000)
  • disp_idx — int — NOT NULL
  • use_yn — varchar(1) — NOT NULL
  • i_date — datetime — NOT NULL
  • i_user — varchar(20) — NOT NULL
  • u_date — datetime
  • u_user — varchar(20)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

dt_equipment_rule_define

  • dt_rule_code — varchar(255) — Primary key — NOT NULL
  • equipment_code — varchar(255) — Primary key — NOT NULL
  • dt_ver_code — int — Primary key — NOT NULL
  • dt_rule_name — varchar(255) — NOT NULL
  • dt_rule_desc — nvarchar(255)
  • dt_rule_path — nvarchar(max)
  • f_percentage — varchar(20)
  • p_omission — varchar(20)
  • p_addition — varchar(20)
  • failure_code — varchar(255)
  • use_yn — varchar(1) — NOT NULL
  • disp_idx — int — NOT NULL
  • i_date — datetime — NOT NULL
  • i_user — varchar(20) — NOT NULL
  • u_date — datetime
  • u_user — varchar(20)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

dt_equipment_sensor_list

  • equipment_code — varchar(10) — Primary key — NOT NULL
  • dt_sensor_code — varchar(10) — Primary key — NOT NULL
  • dt_sensor_name — varchar(255)
  • dt_sensor_x — numeric(18, 0)
  • dt_sensor_y — numeric(18, 0)
  • dt_sensor_type — varchar(10) — NOT NULL
  • dt_sensor_direction — varchar(10) — NOT NULL
  • dt_sensor_img — varchar(255)
  • disp_idx — int — NOT NULL
  • use_yn — varchar(1) — NOT NULL
  • i_date — datetime — NOT NULL
  • i_user — varchar(20) — NOT NULL
  • u_date — datetime
  • u_user — varchar(20)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

dt_item_list

  • dt_item_code — varchar(20) — Primary key — NOT NULL
  • dt_item_d_code — varchar(50) — Primary key — NOT NULL
  • dt_item_d_name — nvarchar(255) — NOT NULL
  • dt_item_d_desc — nvarchar(2000)
  • dt_item_ref — nvarchar(255)
  • dt_ver_code — int
  • dt_ver_default — int
  • disp_idx — int — NOT NULL
  • use_yn — varchar(1) — NOT NULL
  • i_date — datetime — NOT NULL
  • i_user — varchar(20) — NOT NULL
  • u_date — datetime
  • u_user — varchar(20)
  • dt_item_mode — varchar(255)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

dt_item_match

  • dt_code — varchar(10) — Primary key — NOT NULL
  • dt_item_code — varchar(20) — Primary key — NOT NULL
  • dt_ver_code — int — Primary key — NOT NULL
  • dt_item_d_code — varchar(50) — Primary key — NOT NULL
  • dt_item_d_name — nvarchar(50) — NOT NULL
  • dt_item_d_desc — nvarchar(2000)
  • disp_idx — int — NOT NULL
  • use_yn — varchar(1) — NOT NULL
  • i_date — datetime — NOT NULL
  • i_user — varchar(20) — NOT NULL
  • u_date — datetime
  • u_user — varchar(20)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

dt_list

  • dt_code — varchar(10) — Primary key — NOT NULL
  • dt_img — int
  • dt_name — nvarchar(255) — NOT NULL
  • dt_desc — nvarchar(2000)
  • dt_ver_code — int
  • dt_ver_default — int
  • disp_idx — int — NOT NULL
  • use_yn — varchar(1) — NOT NULL
  • i_date — datetime — NOT NULL
  • i_user — varchar(20) — NOT NULL
  • u_date — datetime
  • u_user — varchar(20)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

dt_sensor_list

  • dt_code — varchar(10) — Primary key — NOT NULL
  • dt_sensor_code — varchar(10) — Primary key — NOT NULL
  • dt_sensor_name — varchar(255)
  • dt_sensor_x — numeric(18, 0)
  • dt_sensor_y — numeric(18, 0)
  • dt_sensor_type — varchar(10) — NOT NULL
  • dt_sensor_direction — varchar(10) — NOT NULL
  • dt_sensor_img — varchar(255)
  • disp_idx — int — NOT NULL
  • use_yn — varchar(1) — NOT NULL
  • i_date — datetime — NOT NULL
  • i_user — varchar(20) — NOT NULL
  • u_date — datetime
  • u_user — varchar(20)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

equipment_monitoring_portlet

  • idx — int — NOT NULL
  • equipment_code — nvarchar(30)
  • dt_code — nvarchar(10)
  • position — varchar(255)
  • portlet_title — nvarchar(50)
  • raw_data_type — nvarchar(20)
  • portlet_type — nvarchar(100)
  • portlet_idx — int
  • i_user — nvarchar(20)
  • i_date — datetime
  • from_date — datetime
  • to_date — datetime

log_access

  • acc_seq — int — Primary key — NOT NULL
  • acc_ymd — nvarchar(8) — NOT NULL
  • acc_time — nvarchar(6) — NOT NULL
  • acc_ip — nvarchar(20) — NOT NULL
  • user_no — nvarchar(50)
  • ctrl_nm — nvarchar(200)
  • ctrl_prmt — ntext
  • acc_msg — nvarchar(max)
  • user_nm — nvarchar(20)
  • emp_no — varchar(100)
  • dept_id — varchar(100)
  • dept_name — varchar(255)
  • menu_src — nvarchar(200)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

log_exception

  • ex_seq — int — Primary key — NOT NULL
  • ex_ymd — nvarchar(8) — NOT NULL
  • ex_time — nvarchar(6) — NOT NULL
  • ex_ip — nvarchar(20) — NOT NULL
  • user_id — nvarchar(10)
  • ctrl_nm — nvarchar(200)
  • ex_stacktrace — nvarchar(max)
  • ex_msg — nvarchar(max)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

member

  • user_no — nvarchar(50) — Primary key — NOT NULL
  • comp_cd — nvarchar(10)
  • comp_nm — nvarchar(255)
  • user_id — nvarchar(20) — NOT NULL
  • user_nm — nvarchar(20)
  • user_pw — nvarchar(100)
  • user_auth_cd — nvarchar(10) — NOT NULL
  • last_acc_date — datetime
  • lock_yn — char(1) — NOT NULL
  • lock_cnt — int — NOT NULL
  • user_pw_u_date — datetime
  • use_yn — char(1) — NOT NULL
  • i_date — datetime — NOT NULL
  • i_user — nvarchar(20)
  • u_date — datetime
  • u_user — nvarchar(20)
  • emp_no — varchar(100)
  • dept_id — varchar(100)
  • dept_name — nvarchar(255)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

menu

  • menu_no — nvarchar(10) — Primary key — NOT NULL
  • menu_ref — nvarchar(10) — NOT NULL
  • menu_idx — int — NOT NULL
  • menu_src — nvarchar(200)
  • icon — nvarchar(50)
  • menu_type_cd — char(1) — NOT NULL
  • menu_nm — nvarchar(20) — NOT NULL
  • menu_desc — nvarchar(200)
  • use_yn — char(1) — NOT NULL
  • i_date — datetime — NOT NULL
  • i_user — nvarchar(20) — NOT NULL
  • u_date — datetime
  • u_user — nvarchar(20)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

menu_auth

  • auth_no — nvarchar(10) — Primary key — NOT NULL
  • auth_type — nvarchar(20) — NOT NULL
  • auth_nm — nvarchar(20)
  • auth_desc — nvarchar(200)
  • use_yn — char(1) — NOT NULL
  • i_date — datetime — NOT NULL
  • i_user — nvarchar(20) — NOT NULL
  • u_date — datetime
  • u_user — nvarchar(20)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

menu_auth_match

  • user_no — nvarchar(10) — Primary key — NOT NULL
  • auth_no — nvarchar(10) — NOT NULL
  • use_yn — char(1) — NOT NULL
  • i_date — datetime — NOT NULL
  • i_user — nvarchar(20) — NOT NULL
  • u_date — datetime
  • u_user — nvarchar(20)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

menu_auth_model

  • idx — int — NOT NULL
  • auth_no — nvarchar(10) — NOT NULL
  • menu_no — nvarchar(10) — NOT NULL
  • admin_yn — char(1) — NOT NULL
  • i_date — datetime — NOT NULL
  • i_user — nvarchar(20) — NOT NULL
  • u_date — datetime
  • u_user — nvarchar(20)

tb_alarm_management

  • alarm_code — int — Primary key — NOT NULL — 알람 코드
  • parameter_code — varchar(30) — NOT NULL — 파라미터 코드
  • alarm_name — varchar(30) — NOT NULL — 파라미터 이름
  • alarm_type — char(2) — NOT NULL — 알람 타입
  • alarm_grade — nvarchar(255) — NOT NULL — 알람 등급
  • alarm_term — varchar(255) — AV일 때 기간
  • alarm_formula — varchar(255) — NOT NULL — 수식
  • alarm_use_yn — char(1) — NOT NULL — 사용여부
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

tb_alarm_manual_setting

  • alarm_idx — int — Primary key — NOT NULL
  • equipment_code — varchar(255) — NOT NULL
  • use_yn — char(1) — NOT NULL
  • alarm_start_date — datetime — NOT NULL
  • alarm_end_date — datetime — NOT NULL
  • alarm_set_reason — char(2) — NOT NULL
  • alarm_set_desc — nvarchar(255)
  • i_user — nvarchar(20)
  • i_date — datetime
  • u_user — nvarchar(20)
  • u_date — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

tb_alarm_result

  • alarm_result_code — int — Primary key — NOT NULL — 순차
  • diagnosis_phase — int — NOT NULL — 액션에 의한 단계별 증가 키
  • diagnosis_code — int — NOT NULL — 순차 ID
  • parameter_code — varchar(30) — NOT NULL — 파라미터 코드
  • alarm_code — int — NOT NULL — 순차
  • equipment_code — varchar(255) — NOT NULL — 설비 코드
  • dt_code — varchar(255) — NOT NULL — DT 종류
  • alarm_grade — nvarchar(255) — NOT NULL — 알람 등급 설명
  • alarm_date — datetime — NOT NULL — 발생일자
  • parts_code — varchar(255) — NOT NULL
  • parameter_type — varchar(1) — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

tb_alarm_result_manual_log

  • log_id — int — Primary key — NOT NULL
  • alarm_result_code — int
  • diagnosis_code — int
  • equipment_code — varchar(50)
  • i_user — varchar(10)
  • i_date — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

tb_dcs_info

  • dcs_id — int — Primary key — NOT NULL
  • equipment_code — varchar(255) — NOT NULL
  • dcs_tag — nvarchar(255) — NOT NULL
  • data_type — nvarchar(255)
  • data_value — nvarchar(255)
  • data_date — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

tb_diagnosis_process

  • diagnosis_code — int — Primary key — NOT NULL — 순차 ID
  • diagnosis_status — char(1) — NOT NULL — 파라미터 타
  • diagnosis_phase — int — NOT NULL — 액션에 의한 단계별 증가
  • equipment_code — varchar(255) — NOT NULL — 설비 코드
  • real_result — nvarchar(255) — 실제 진단 결과
  • cause_failure — nvarchar(255) — 고장 원인
  • cause_failure_text — nvarchar(max) — 고장 원인 의견
  • action_result — nvarchar(255) — 조치 결과
  • action_result_text — nvarchar(max) — 조치 결과 의견
  • diagnosis_date — datetime
  • diagnosis_yn — char(1)
  • alarm_grade — nvarchar(255)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

tb_diagnosis_process_log

  • diagnosis_code — int — NOT NULL
  • diagnosis_status — char(1) — NOT NULL
  • diagnosis_phase — int — NOT NULL
  • equipment_code — varchar(255) — NOT NULL
  • real_result — varchar(255)
  • cause_failure — varchar(255)
  • cause_failure_text — nvarchar(max)
  • action_result — varchar(255)
  • action_result_text — nvarchar(max)
  • i_date — datetime
  • i_user — nvarchar(20)

tb_equipment_data

  • data_id — int — Primary key — NOT NULL — 순차 ID
  • parts_code — varchar(255) — NOT NULL — 설비 파츠 태그 ID
  • tag_description — nvarchar(255) — 설비 태그 설명
  • data_type — varchar(255) — NOT NULL — 데이터 타입
  • data_value — nvarchar(255) — 데이터 값
  • data_date — datetime — 데이터 날짜 및 시간
  • tag_name — nchar(10)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

tb_equipment_data_alarmset

  • data_id — int — Primary key — NOT NULL — 순차 ID
  • parts_code — varchar(255) — NOT NULL — 설비 파츠 태그 ID
  • tag_description — nvarchar(255) — 설비 태그 설명
  • data_type — varchar(255) — NOT NULL — 데이터 타입
  • data_value — nvarchar(255) — 데이터 값
  • data_date — datetime — 데이터 날짜 및 시간
  • tag_name — nchar(10)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

tb_equipment_data_manual_log

  • log_id — int — Primary key — NOT NULL
  • data_id — int — NOT NULL
  • i_user — varchar(255) — NOT NULL
  • i_date — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

tb_equipment_data_parameter

  • data_id — int — Primary key — NOT NULL — 순차 ID
  • parts_code — varchar(255) — NOT NULL — 설비 파츠 태그 ID
  • tag_description — nvarchar(255) — 설비 태그 설명
  • data_type — varchar(255) — NOT NULL — 데이터 타입
  • data_value — nvarchar(max) — 데이터 값
  • data_date — datetime — 데이터 날짜 및 시간
  • tag_dir — nchar(10)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

tb_equipment_data_raw

  • data_id — int — Primary key — NOT NULL — 순차 ID
  • parts_code — varchar(255) — NOT NULL — 설비 파츠 태그 ID
  • tag_description — nvarchar(255) — 설비 태그 설명
  • data_type — varchar(255) — NOT NULL — 데이터 타입
  • data_value — nvarchar(255) — 데이터 값
  • data_date — datetime — 데이터 날짜 및 시간
  • tag_dir — nchar(10)
  • plant_name — nvarchar(255)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =