TITLE
Tables (101)
COM_FILE_TMP
CO_AREA_GRP_L
- CO_AREA_NO — INT — Foreign key → CO_AREA_M.CO_AREA_NO — NOT NULL — Area No
CO_AREA_GRP_M
- CO_AREA_GRP_NO — INT — NOT NULL — Area Group No
CO_AREA_M
- CO_AREA_NO — INT — NOT NULL — Area No
CO_AUTH_M
- CO_AUTH_NO — INT — NOT NULL — 권한 No
CO_AUTH_MENU_FN_L
- CO_AUTH_MENU_FN_L_NO — INT — NOT NULL — 권한별 Menu 기능 Link No
- CO_AUTH_NO — INT — Foreign key → CO_AUTH_M.CO_AUTH_NO — NOT NULL — 권한 No
CO_CD_DETAIL_CHILD_O
- MST_CD — VARCHAR(50) — Foreign key → CO_CD_DETAIL_M.MST_CD — NOT NULL — Parent Master Code
- DETAIL_CD — VARCHAR(50) — Foreign key → CO_CD_DETAIL_M.DETAIL_CD — NOT NULL — Parent Detail Code
- CHILD_MST_CD — VARCHAR(50) — NOT NULL — Detail Code에 대한 Child Master Code
- CHILD_DETAIL_CD — VARCHAR(50) — NOT NULL — Detail Code에 대한 Child Detail Code
CO_CD_DETAIL_M
- MST_CD — VARCHAR(50) — Foreign key → CO_CD_M.MST_CD — NOT NULL — Master Code
- DETAIL_CD — VARCHAR(50) — NOT NULL — Detail Code
CO_CD_DFLT_D
- CO_CD_DFLT_D_NO — INT — NOT NULL — No
- MST_CD — VARCHAR(50) — NOT NULL — Parent Master Code
- DETAIL_CD — VARCHAR(50) — Parent Detail Code
- CHILD_MST_CD — VARCHAR(50) — Detail Code에 대한 Child Master Code
- CHILD_DETAIL_CD — VARCHAR(50) — Detail Code에 대한 Child Detail Code
CO_CD_M
- CTG_NM — VARCHAR(100) — NOT NULL — Master Code's Category
- MST_CD — VARCHAR(50) — NOT NULL — Master Code
CO_DASHBRD_GADGET_L
- CO_DASHBRD_GADGET_L_NO — INT — NOT NULL — Dashboard내 Gadget Link No
- CO_DASHBRD_NO — INT — Foreign key → CO_DASHBRD_M.CO_DASHBRD_NO — NOT NULL — Dashboard No
- CO_GADGET_NO — INT — Foreign key → CO_GADGET_M.CO_GADGET_NO — NOT NULL — Dashboard에 같은 Gadget Multi
- SHARED_USER_NO — INT — 공유받은 사용자
- PARENT_NO — INT — 공유받은 사용자용
CO_DASHBRD_M
- CO_DASHBRD_NO — INT — NOT NULL — Dashboard No
CO_DASHBRD_ROLE_L
- CO_DASHBRD_ROLE_L_NO — INT — NOT NULL — Dashboard별 Role Link No
- CO_DASHBRD_NO — INT — Foreign key → CO_DASHBRD_M.CO_DASHBRD_NO — NOT NULL — Dashboard No
- CO_ROLE_NO — INT — Foreign key → CO_ROLE_M.CO_ROLE_NO — NOT NULL — Role No
CO_GADGET_M
- CO_GADGET_NO — INT — NOT NULL — Gadget No
CO_GADGET_MENU_L
- CO_GADGET_MENU_L_NO — INT — NOT NULL — Gadget과 메뉴 연결 번호
- CO_GADGET_NO — INT — Foreign key → CO_GADGET_M.CO_GADGET_NO — NOT NULL — Gadget No
- CO_MENU_ID — VARCHAR(100) — Foreign key → CO_MENU_M.CO_MENU_ID — NOT NULL — Menu ID
CO_LOC_M
- CO_LOC_NO — INT — NOT NULL — Location No
- CO_AREA_GRP_NO — INT — Foreign key → CO_AREA_GRP_M.CO_AREA_GRP_NO — Leaf일때만
CO_MAIL_AUTO_SEND_M
- REG_USER_NO — INT — Primary key — NOT NULL — 등록자
- REG_DT — DATETIME — Primary key — NOT NULL — 등록일시
- CO_TOOL_NO — INT — Foreign key → CO_TOOL_M.CO_TOOL_NO — NOT NULL — 자동 메일 전송과 관련된 설비
CO_MENU_FN_URL_M
- CO_MENU_FN_URL_NO — INT — NOT NULL — Menu 기능 URL No
- CO_MENU_ID — VARCHAR(100) — Foreign key → CO_MENU_M.CO_MENU_ID — NOT NULL — Menu ID
CO_MENU_M
- CO_MENU_ID — VARCHAR(100) — NOT NULL — DCP.PLAN,
CO_OPER_M
- CO_OPER_NO — INT — NOT NULL — Operation No
CO_PROD_HIERARCHY_L
- CO_PROD_HIERARCHY_L_NO — INT — NOT NULL — Product 종속관계 Link
- CO_PROD_NO — INT — Foreign key → CO_PROD_M.CO_PROD_NO — NOT NULL — Parent
- CO_PROD_NO2 — INT — Foreign key → CO_PROD_M.CO_PROD_NO — NOT NULL — Child
CO_PROD_M
- CO_PROD_NO — INT — NOT NULL — Product No
CO_PROD_OPER_L
- CO_PROD_OPER_L_NO — INT — NOT NULL — Product와 Operation Link No
- CO_PROD_NO — INT — Foreign key → CO_PROD_M.CO_PROD_NO — NOT NULL — Product No
- CO_OPER_NO — INT — Foreign key → CO_OPER_M.CO_OPER_NO — NOT NULL — Operation No
CO_PROD_PLAN_M
- CO_PROD_PLAN_NO — INT — NOT NULL — Product 생산계획 No
- CO_PROD_NO — INT — Foreign key → CO_PROD_M.CO_PROD_NO — NOT NULL — Product No
CO_QUICK_SEARCH_M
- CO_QUICK_SEARCH_NO — INT — NOT NULL — Quick Search No
- USER_NO — INT — NOT NULL — User No
- CO_MENU_ID — VARCHAR(100) — Foreign key → CO_MENU_M.CO_MENU_ID — NOT NULL — Menu ID
CO_ROLE_AUTH_LOC_AREA_L
- CO_ROLE_AUTH_LOC_AREA_L_NO — INT — NOT NULL — Role별 권한, Loc, Area Link No
- CO_ROLE_NO — INT — Foreign key → CO_ROLE_M.CO_ROLE_NO — NOT NULL — Role No
- CO_AUTH_NO — INT — Foreign key → CO_AUTH_M.CO_AUTH_NO — NOT NULL — 권한 No
- CO_LOC_NO — INT — Foreign key → CO_LOC_M.CO_LOC_NO — NULL이면 전체
- CO_AREA_NO — INT — Foreign key → CO_AREA_M.CO_AREA_NO — Loc 하위의 Area, NULL이면 전체
CO_ROLE_M
- CO_ROLE_NO — INT — NOT NULL — Role No
- PARENT_NO — INT — 최상위는 NULL
CO_SDWT_M
- CO_SDWT_NO — INT — NOT NULL — SDWT No
- CO_SHIFT_NO — INT — Foreign key → CO_SHIFT_M.CO_SHIFT_NO — NOT NULL — Shift No
CO_SHARED_USER_DASHBRD_L
- CO_SHARED_USER_DASHBRD_L_NO — INT — NOT NULL — 공유받은사용자의 Dashboard 설정 Link No
- CO_DASHBRD_NO — INT — Foreign key → CO_DASHBRD_M.CO_DASHBRD_NO — NOT NULL — Dashboard No
- SHARED_USER_NO — INT — NOT NULL — 공유받은 사용자
CO_SHIFT_DETAIL_M
- CO_SHIFT_DETAIL_NO — INT — NOT NULL — Shift Detail No
- CO_SHIFT_NO — INT — Foreign key → CO_SHIFT_M.CO_SHIFT_NO — NOT NULL — Shift No
CO_SHIFT_M
- CO_SHIFT_NO — INT — NOT NULL — Shift No
CO_SPC_RULE_M
- REG_USER_NO — INT — Primary key — NOT NULL — 등록자
- REG_DT — DATETIME — Primary key — NOT NULL — 등록일시
- CO_SPC_RULE_NO — INT — NOT NULL — Spc Rule No
CO_STATUS_BRD_M
- CO_STATUS_BRD_NO — INT — NOT NULL — 현황판 No
CO_TOOL_H
- CO_TOOL_H_NO — INT — NOT NULL — Tool History No
- CO_TOOL_NO — INT — NOT NULL — Tool No
- CO_TOOL_MODEL_NO — INT — NOT NULL — Tool Model No
- CO_TOOL_MODEL_VER_NO — INT — NOT NULL — Tool Model Version No
- FD_TTSM_NO — INT — Tool Type Spec Model No
- CO_SDWT_NO — INT — SDWT No
CO_TOOL_M
- CO_TOOL_NO — INT — NOT NULL — Tool No
- CO_TOOL_MODEL_NO — INT — Foreign key → CO_TOOL_MODEL_M.CO_TOOL_MODEL_NO — NOT NULL — Tool Model No
- CO_TOOL_MODEL_VER_NO — INT — NOT NULL — Tool Model Version No
- FD_TTSM_NO — INT — Foreign key → FD_TTSM_M.FD_TTSM_NO — Tool Type Spec Model No
- CO_SDWT_NO — INT — Foreign key → CO_SDWT_M.CO_SDWT_NO — SDWT No
CO_TOOL_MODEL_M
- CO_TOOL_MODEL_NO — INT — NOT NULL — Tool Model No
- CO_LOC_NO — INT — Foreign key → CO_LOC_M.CO_LOC_NO — NOT NULL — Query용
- CO_AREA_NO — INT — Foreign key → CO_AREA_M.CO_AREA_NO — NOT NULL — Loc의 Area Group내
CO_TOOL_PROP_H
- CO_TOOL_PROP_H_NO — INT — NOT NULL — Tool Property History No
- CO_TOOL_PROP_O_NO — INT — NOT NULL — Tool Property No
- CO_TOOL_NO — INT — NOT NULL — Tool No
CO_TOOL_PROP_O
- CO_TOOL_PROP_O_NO — INT — NOT NULL — Tool Property No
- CO_TOOL_NO — INT — Foreign key → CO_TOOL_M.CO_TOOL_NO — NOT NULL — Tool No
CO_TOOL_STATUS_H
- CO_TOOL_STATUS_H_NO — INT — NOT NULL — CO_TOOL_STATUS_H_NO
- CO_TOOL_MODEL_NO — INT — NOT NULL — Tool Model No
- MAIN_TOOL_NO — INT — NOT NULL — MAIN Tool에만 연결
CO_USER_ROLE_L
- CO_USER_ROLE_L_NO — INT — NOT NULL — 사용자별 Role Link No
- USER_NO — INT — NOT NULL — User No
- CO_ROLE_NO — INT — Foreign key → CO_ROLE_M.CO_ROLE_NO — NOT NULL — Role No
CO_USER_SDWT_L
- CO_USER_SDWT_L_NO — INT — NOT NULL — 사용자와 SDWT 링크 No
- USER_NO — INT — NOT NULL — User No
- CO_SDWT_NO — INT — Foreign key → CO_SDWT_M.CO_SDWT_NO — NOT NULL — User의 권한그룹의 Area와 동일한 SDWT
- CO_SHIFT_DETAIL_NO — INT — Foreign key → CO_SHIFT_DETAIL_M.CO_SHIFT_DETAIL_NO — 근무시간
CO_VL_FN_ARG_O
- CO_VL_FN_ARG_O_NO — INT — NOT NULL — DCP VL용 Function Argument No
- CO_VL_FN_NO — INT — Foreign key → CO_VL_FN_M.CO_VL_FN_NO — NOT NULL — DCP VL용 Function No
CO_VL_FN_M
- CO_VL_FN_NO — INT — NOT NULL — DCP VL용 Function No
DP_ALARM_D
- DP_ALARM_D_NO — INT — NOT NULL — DP_ALARM_NO
- DP_DCP_NO — INT — Foreign key → DP_DCP_M.DP_DCP_NO — NOT NULL — DCP No
DP_ALARM_M
- DP_ALARM_NO — INT — NOT NULL — DCP Alarm No
- DP_DCP_NO — INT — Foreign key → DP_DCP_M.DP_DCP_NO — NOT NULL — DCP No
DP_DCP_M
- DP_DCP_NO — INT — NOT NULL — DCP No
- MAIN_TOOL_NO — INT — Foreign key → CO_TOOL_M.CO_TOOL_NO — NOT NULL — Main Tool
DP_EVENT_D
- DP_EVENT_D_NO — INT — NOT NULL — FD Event 이력 데이터 No
- DP_DCP_NO — INT — Foreign key → DP_DCP_M.DP_DCP_NO — NOT NULL — DCP No
DP_EVENT_M
- DP_EVENT_NO — INT — NOT NULL — DCP Event No
- DP_DCP_NO — INT — Foreign key → DP_DCP_M.DP_DCP_NO — NOT NULL — Main Tool
- DP_TRACE_GRP_COND_NO — INT — DCP Trace Group Condition No
DP_EVENT_REPORT_L
- DP_EVENT_REPORT_L_NO — INT — NOT NULL — Event Report Link No
- DP_EVENT_NO — INT — Foreign key → DP_EVENT_M.DP_EVENT_NO — NOT NULL — DCP Event No
- DP_EVENT_REPORT_NO — INT — Foreign key → DP_EVENT_REPORT_M.DP_EVENT_REPORT_NO — NOT NULL — Event Report No
DP_EVENT_REPORT_M
- DP_EVENT_REPORT_NO — INT — NOT NULL — Event Report No
- DP_DCP_NO — INT — Foreign key → DP_DCP_M.DP_DCP_NO — NOT NULL — DCP No
DP_EVENT_REPORT_PARAM_L
- DP_EVENT_REPORT_PARAM_L_NO — INT — NOT NULL — DCP Event와 DCP Parameter Link No
- DP_EVENT_REPORT_NO — INT — Foreign key → DP_EVENT_REPORT_M.DP_EVENT_REPORT_NO — NOT NULL — Event Report No
- DP_PARAM_NO — INT — NOT NULL — DCP Parameter No
DP_TRACE_GRP_COND_M
- DP_TRACE_GRP_COND_NO — INT — NOT NULL — DCP Trace Group Condition No
- DP_DCP_NO — INT — Foreign key → DP_DCP_M.DP_DCP_NO — NOT NULL — DCP No
DP_TRACE_M
- DP_TRACE_NO — INT — NOT NULL — DCP Trace No
- DP_DCP_NO — INT — Foreign key → DP_DCP_M.DP_DCP_NO — NOT NULL — DCP No
DP_TRACE_PARAM_L
- DP_TRACE_PARAM_L_NO — INT — NOT NULL — DCP Trace와 DCP Parameter Link No
- DP_TRACE_NO — INT — Foreign key → DP_TRACE_M.DP_TRACE_NO — NOT NULL — DCP Trace No
- DP_PARAM_NO — INT — NOT NULL — DCP Parameter No
DP_TRACE_SUM_PARAM_M
- DP_TRACE_SUM_PARAM_NO — INT — NOT NULL — DCP Trace Summary Parameter No
- DP_DCP_NO — INT — Foreign key → DP_DCP_M.DP_DCP_NO — NOT NULL — DCP No
DP_TRACE_SUM_PLAN_M
- DP_TRACE_SUM_PLAN_M_NO — INT — NOT NULL — DCP Trace Summary Plan No
- DP_TRACE_SUM_PARAM_NO — INT — Foreign key → DP_TRACE_SUM_PARAM_M.DP_TRACE_SUM_PARAM_NO — NOT NULL — DCP Trace Summary Parameter No
DP_VL_ARG_O
- DP_VL_ARG_O_NO — INT — NOT NULL — DCP VL Argument No
- DP_DCP_NO — INT — Foreign key → DP_DCP_M.DP_DCP_NO — NOT NULL — DCP No
- PARAM_ID — VARCHAR(100) — Virtual Logic을 사용하는 Main Param ID
- EVENT_ID — VARCHAR(100) — Virtual Logic을 사용하는 Main Event ID
- PARENT_VL_ARG_NO — INT — Event VP의 Arg인 경우의 Parent Event의 No
DP_VL_FN_L
- DP_VL_FN_L_NO — INT — NOT NULL — VL에서 사용하는 Function Link
- DP_PARAM_NO — INT — VL Parameter, 세 FK중 하나만 세팅
- DP_EVENT_NO — INT — Foreign key → DP_EVENT_M.DP_EVENT_NO — VL Event, 세 FK중 하나만 세팅
- DP_TRACE_SUM_PARAM_NO — INT — Foreign key → DP_TRACE_SUM_PARAM_M.DP_TRACE_SUM_PARAM_NO — Tr Sum Param, 세 FK중 하나만 세팅
- CO_VL_FN_NO — INT — Foreign key → CO_VL_FN_M.CO_VL_FN_NO — DCP VL용 Function No
FD_LOT_TRACKING_D
- FD_LOT_TRACKING_D_NO — INT — Primary key — NOT NULL — FD_LOT_TRACKING_D_NO
- YEAR — INT — Primary key — NOT NULL — Partition 용, MSG_DT의 년도
- MONTH — INT — Primary key — NOT NULL — Partition 용, MSG_DT의 월
- CO_TOOL_MODEL_VER_NO — INT — NOT NULL — Tool Model Version No
FD_PARAM_HEALTH_M
- IS_ACTIVE — TINYINT — Primary key — NOT NULL — T, F
- REG_USER_NO — INT — Primary key — NOT NULL — 등록자
- REG_DT — DATETIME — Primary key — NOT NULL — 등록일시
- FD_PARAM_HEALTH_NO — INT — NOT NULL — Fault Param Health No
- CO_TOOL_MODEL_NO — INT — Foreign key → CO_TOOL_MODEL_M.CO_TOOL_MODEL_NO — NOT NULL — Tool Model No
- CO_TOOL_NO — INT — Foreign key → CO_TOOL_M.CO_TOOL_NO — NOT NULL — Tool No
FD_SIMUL_SPEC_APPLY_H
- FD_SIMUL_SPEC_APPLY_H_NO — INT — NOT NULL — Simulation Spec Apply Condition No
- FD_SIMUL_SPEC_NO — INT — Foreign key → FD_SIMUL_SPEC_M.FD_SIMUL_SPEC_NO — NOT NULL — Simulation Spec No
- FD_TTSM_NO — INT — Foreign key → FD_TTSM_M.FD_TTSM_NO — NOT NULL — 적용한 TSG
- CO_TOOL_NO — INT — Foreign key → CO_TOOL_M.CO_TOOL_NO — NOT NULL — 적용한 Tool
- FD_TTSM_TMPL_NO — INT — Foreign key → FD_TTSM_TMPL_M.FD_TTSM_TMPL_NO — NOT NULL — Tool Spec Model Template의 Default에 적용시
- FD_TOOL_SPEC_MODEL_NO — INT — Foreign key → FD_TOOL_SPEC_MODEL_M.FD_TOOL_SPEC_MODEL_NO — Tool Spec Model에 적용시
- FD_TOOL_SPEC_NO — INT — Tool Spec에 적용시
FD_SIMUL_SPEC_M
- FD_SIMUL_SPEC_NO — INT — NOT NULL — Simulation Spec No
- FD_SIMUL_NO — INT — NOT NULL — Simulation No
FD_TOOL_FAULT_D
- FD_TOOL_FAULT_D_NO — INT — Primary key — NOT NULL — FD_TOOL_FAULT_D_NO
- YEAR — INT — Primary key — NOT NULL — Partition 용, FAULT_DT의 년도
- MONTH — INT — Primary key — NOT NULL — Partition 용, FAULT_DT의 월
- DP_PARAM_NO — INT — NOT NULL — Fault 발생 Parameter NO
FD_TOOL_SPEC_MODEL_COND_M
- FD_TOOL_SPEC_MODEL_COND_NO — INT — NOT NULL — Tool Spec Model Cond No
- FD_TTSM_TMPL_NO — INT — Foreign key → FD_TTSM_TMPL_M.FD_TTSM_TMPL_NO — Tool Type Spec Model Template No
FD_TOOL_SPEC_MODEL_M
- FD_TOOL_SPEC_MODEL_NO — INT — NOT NULL — Tool Spec Model No
- FD_TTSM_TMPL_NO — INT — Foreign key → FD_TTSM_TMPL_M.FD_TTSM_TMPL_NO — NOT NULL — Tool Type Spec Model Template No
- FD_TTSM_TMPL_AUTO_CALC_O_NO — INT — Foreign key → FD_TTSM_TMPL_AUTO_CALC_O.FD_TTSM_TMPL_AUTO_CALC_O_NO — NOT NULL — Tool Type Spec Model Template Auto Calculation Option No
- FD_TOOL_SPEC_MODEL_COND_NO — INT — Foreign key → FD_TOOL_SPEC_MODEL_COND_M.FD_TOOL_SPEC_MODEL_COND_NO — Tool Spec Model Cond No
- DP_PARAM_NO — INT — NOT NULL — DCP Parameter No
FD_TOOL_SPEC_VALUE_H
- FD_TOOL_SPEC_VALUE_H_NO — INT — NOT NULL — Tool Spec Value No
FD_TRACE_RAW_DATA_T
- DP_DCP_NO — INT — NOT NULL — DCP No
FD_TTSM_M
- FD_TTSM_NO — INT — NOT NULL — Tool Type Spec Model No
FD_TTSM_TMPL_AUTO_CALC_O
- FD_TTSM_TMPL_AUTO_CALC_O_NO — INT — NOT NULL — Tool Type Spec Model Template Auto Calculation Option No
- FD_TTSM_TMPL_NO — INT — Foreign key → FD_TTSM_TMPL_M.FD_TTSM_TMPL_NO — NOT NULL — Tool Type Spec Model Template No
FD_TTSM_TMPL_DFLT_O
- FD_TTSM_TMPL_DFLT_O_NO — INT — NOT NULL — Tool Type Spec Model Template의 Default No
- FD_TTSM_TMPL_NO — INT — Foreign key → FD_TTSM_TMPL_M.FD_TTSM_TMPL_NO — NOT NULL — Tool Type Spec Model Template No
FD_TTSM_TMPL_M
- FD_TTSM_TMPL_NO — INT — NOT NULL — Tool Type Spec Model Template No
- FD_TTSM_NO — INT — Foreign key → FD_TTSM_M.FD_TTSM_NO — NOT NULL — Tool Type Spec Model No
FW_AGENT_M
- FW_AGENT_NO — INT — NOT NULL — Agent Sequence
FW_CMD_M
- FW_CMD_NO — INT — NOT NULL — Master Command No
- FW_CONFIG_GROUP_NO — INT — Foreign key → FW_CONFIG_GROUP_M.FW_CONFIG_GROUP_NO — Config Group NO2
FW_CONFIG_GROUP_M
- FW_CONFIG_GROUP_NO — INT — NOT NULL — Config Group NO
FW_CONFIG_ITEM_M
- FW_CONFIG_ITEM_NO — INT — NOT NULL — Config Item No
- FW_CONFIG_GROUP_NO — INT — Foreign key → FW_CONFIG_GROUP_M.FW_CONFIG_GROUP_NO — Config Group NO
FW_CONFIG_ITEM_PROP_O
- FW_CONFIG_ITEM_PROP_O_NO — INT — NOT NULL — Config Item Property NO
- FW_CONFIG_ITEM_NO — INT — Foreign key → FW_CONFIG_ITEM_M.FW_CONFIG_ITEM_NO — Config Item No
FW_CUSTOM_FILE_L
- FW_CUSTOM_FILE_L_NO — INT — NOT NULL — Custom File Sequence
- FW_FILE_NO — INT — Foreign key → FW_FILE_M.FW_FILE_NO — File Sequence2
- FW_FW_NO — INT — Foreign key — FW Group No
FW_DEPLOY_T
- FW_DEPLOY_T_NO — INT — NOT NULL — Deploy 임시 번호
- FW_FW_NO — INT — Foreign key — Framework Sequence
FW_FILE_M
- FW_FILE_NO — INT — NOT NULL — File Sequence
FW_FW_CONFIG_ITEM_L
- FW_FW_CONFIG_ITEM_L_NO — INT — NOT NULL — Configuration Map Sequence
- FW_CONFIG_ITEM_NO — INT — Foreign key → FW_CONFIG_ITEM_M.FW_CONFIG_ITEM_NO — Config Item No
- FW_FW_NO — INT — Foreign key — Framework Sequence
and 21 more tables