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 — =