GRMS
Tables (29)
TB_RMS_ABNORMAL_OCCUR_ALARM ((RMS 이상 발생 알람 설정))
- FACTORY (Key) — VARCHAR2(50) — Primary key — NOT NULL
- AREA_ID (Field) — VARCHAR2(50) — Primary key
- LINE_ID (Field2) — VARCHAR2(50) — Primary key
- PROC_ID (Field3) — VARCHAR2(50) — Primary key
- EQP_ID (Field4) — VARCHAR2(50) — Primary key
- USER_ID (Field5) — VARCHAR2(50) — Primary key
- CODE_ID (Field6) — VARCHAR2(64) — Primary key
TB_RMS_APPR_USER_MST ((승인자 정보 MASTER 설정))
- APPROVAL_TYPE (Key) — VARCHAR2(50) — Primary key — NOT NULL
- APPROVAL_STEP (Key2) — NUMBER — Primary key — NOT NULL
- USER_ID (Field) — VARCHAR2(64) — Primary key
TB_RMS_AP_WEB_CONNECTION_ADDR ((EIF->RMS 접속 정보 관리))
- EQP_ID (Key) — VARCHAR2(50) — Foreign key → TB_RMS_EQP_MASTER.EQP_ID — NOT NULL
TB_RMS_EQP ((GRMS 사용 설비 등록))
- PROC_ID (Key) — VARCHAR2(50) — Primary key — NOT NULL
- EQP_ID (Key3) — VARCHAR2(50) — Foreign key → TB_RMS_EQP_MASTER.EQP_ID — NOT NULL
TB_RMS_EQP_GROUP_PARA ((설비군별 파라메터 정보))
- EQP_GROUP_ID (Key2) — NVARCHAR2(50) — Primary key — NOT NULL
- PARAMETER_ID (Key3) — VARCHAR2(200) — Primary key — NOT NULL
- PROC_ID (Key) — VARCHAR2(50) — Foreign key → TB_RMS_EQP.PROC_ID — NOT NULL
TB_RMS_EQP_GROUP_PARA_H ((설비군별 파라메터 정보 등록 히스토리))
- ACTION (Key4) — VARCHAR2(50) — Primary key — NOT NULL
- COLUMN_ID (Key5) — VARCHAR2(100) — Primary key — NOT NULL
- CREATED_DTTM (Key6) — TIMESTAMP(6) — Primary key — NOT NULL
- EQP_GROUP_ID (Key2) — NVARCHAR2(50) — Foreign key → TB_RMS_EQP_GROUP_PARA.EQP_GROUP_ID — NOT NULL
- PARAMETER_ID (Key3) — VARCHAR2(200) — Foreign key → TB_RMS_EQP_GROUP_PARA.PARAMETER_ID — NOT NULL
- PROC_ID (Key) — VARCHAR2(50) — Foreign key → TB_RMS_EQP_GROUP_PARA.PROC_ID — NOT NULL
TB_RMS_EQP_H ((GRMS 사용 설비 등록 히스토리))
- ACTION (Key) — VARCHAR2(50) — Primary key — NOT NULL
- COLUMN_ID (Key4) — VARCHAR2(100) — Primary key — NOT NULL
- CREATED_DTTM (Key5) — TIMESTAMP(6) — Primary key — NOT NULL
- PROC_ID (Key2) — VARCHAR2(50) — Foreign key → TB_RMS_EQP.PROC_ID — NOT NULL
- EQP_ID (Key3) — VARCHAR2(50) — Foreign key → TB_RMS_EQP.EQP_ID — NOT NULL
TB_RMS_EQP_MASTER ((설비 MASTER 정보 등록))
- EQP_ID (Key) — VARCHAR2(50) — Primary key — NOT NULL
- Field
TB_RMS_EQP_MASTER_H ((설비 MASTER 정보 등록 히스토리))
- ACTION (Key) — VARCHAR2(50) — Primary key — NOT NULL
- COLUMN_ID (Key3) — VARCHAR2(100) — Primary key — NOT NULL
- CREATED_DTTM (Key4) — TIMESTAMP(6) — Primary key — NOT NULL
- EQP_ID (Key2) — VARCHAR2(50) — Foreign key → TB_RMS_EQP_MASTER.EQP_ID — NOT NULL
TB_RMS_EQP_PARA ((설비별 파라메터 정보))
- PARAMETER_ID (Key) — VARCHAR2(200) — Primary key — NOT NULL
- EQP_ID (Key3) — VARCHAR2(50) — Foreign key → TB_RMS_EQP.EQP_ID — NOT NULL
TB_RMS_EQP_PARA_HISTORY ((설비별 파라메터 정보 등록 히스토리))
- ACTION (Key2) — VARCHAR2(50) — Primary key — NOT NULL
- CREATED_DTTM (Key4) — TIMESTAMP(6) — Primary key — NOT NULL
- PARAMETER_ID (Key) — VARCHAR2(200) — Foreign key → TB_RMS_EQP_PARA.PARAMETER_ID — NOT NULL
- EQP_ID (Key3) — VARCHAR2(50) — Foreign key → TB_RMS_EQP_PARA.EQP_ID — NOT NULL
TB_RMS_EQP_RCP ((레시피 ID 등록))
- RECIPE_ID (Key) — VARCHAR2(500) — Primary key — NOT NULL
- PROC_ID (Key2) — VARCHAR2(50) — Foreign key → TB_RMS_EQP.PROC_ID — NOT NULL
- EQP_ID (Key3) — VARCHAR2(50) — Foreign key → TB_RMS_EQP.EQP_ID — NOT NULL
TB_RMS_EQP_RCP_AUTOMAPPING_H ((레시피ID 별 모델 자동 매핑 이력))
- PROD_CATEGORY (Key4) — VARCHAR2(50) — Primary key — NOT NULL
- CORELESS (Key5) — VARCHAR2(10) — Primary key — NOT NULL
- DESCRIPTION_YN (Key6) — CHAR(1) — Primary key — NOT NULL
- MODEL_ID (Key) — VARCHAR2(50) — Foreign key → TB_RMS_EQP_RCP_MODEL.MODEL_ID — NOT NULL
- PROC_SEQ (Key3) — NUMBER — Foreign key → TB_RMS_EQP_RCP_MODEL.PROC_SEQ — NOT NULL
- RECIPE_ID (Key2) — VARCHAR2(500) — Foreign key → TB_RMS_EQP_RCP_MODEL.RECIPE_ID — NOT NULL
- PROC_ID (Key22) — VARCHAR2(50) — Foreign key → TB_RMS_EQP_RCP_MODEL.PROC_ID — NOT NULL
- EQP_ID (Key32) — VARCHAR2(50) — Foreign key → TB_RMS_EQP_RCP_MODEL.EQP_ID — NOT NULL
TB_RMS_EQP_RCP_H ((레시피 ID 등록 히스토리))
- ACTION (Key4) — VARCHAR2(50) — Primary key — NOT NULL
- COLUMN_ID (Key5) — VARCHAR2(100) — Primary key — NOT NULL
- CREATED_DTTM (Key6) — TIMESTAMP(6) — Primary key — NOT NULL
- RECIPE_ID (Key) — VARCHAR2(500) — Foreign key → TB_RMS_EQP_RCP.RECIPE_ID — NOT NULL
- PROC_ID (Key2) — VARCHAR2(50) — Foreign key → TB_RMS_EQP_RCP.PROC_ID — NOT NULL
- EQP_ID (Key3) — VARCHAR2(50) — Foreign key → TB_RMS_EQP_RCP.EQP_ID — NOT NULL
TB_RMS_EQP_RCP_MODEL ((레시피ID 별 모델 매핑 등록))
- MODEL_ID (Key) — VARCHAR2(50) — Primary key — NOT NULL
- PROC_SEQ (Key3) — NUMBER — Primary key — NOT NULL
- RECIPE_ID (Key2) — VARCHAR2(500) — Foreign key → TB_RMS_EQP_RCP.RECIPE_ID — NOT NULL
- PROC_ID (Key22) — VARCHAR2(50) — Foreign key → TB_RMS_EQP_RCP.PROC_ID — NOT NULL
- EQP_ID (Key32) — VARCHAR2(50) — Foreign key → TB_RMS_EQP_RCP.EQP_ID — NOT NULL
TB_RMS_EQP_RCP_MODEL_H ((레시피ID 별 모델 매핑 등록 히스토리))
- ACTION (Key4) — VARCHAR2(50) — Primary key — NOT NULL
- COLUMN_ID (Key5) — VARCHAR2(100) — Primary key — NOT NULL
- Key6 — TIMESTAMP(6) — Primary key — NOT NULL
- MODEL_ID (Key) — VARCHAR2(50) — Foreign key → TB_RMS_EQP_RCP_MODEL.MODEL_ID — NOT NULL
- PROC_SEQ (Key3) — NUMBER — Foreign key → TB_RMS_EQP_RCP_MODEL.PROC_SEQ — NOT NULL
- RECIPE_ID (Key2) — VARCHAR2(500) — Foreign key → TB_RMS_EQP_RCP_MODEL.RECIPE_ID — NOT NULL
- PROC_ID (Key22) — VARCHAR2(50) — Foreign key → TB_RMS_EQP_RCP_MODEL.PROC_ID — NOT NULL
- EQP_ID (Key32) — VARCHAR2(50) — Foreign key → TB_RMS_EQP_RCP_MODEL.EQP_ID — NOT NULL
TB_RMS_EQP_RCP_PARA ((레시피 ID 별 BODY 등록))
- STEP_NUMBER (Key3) — VARCHAR2(50) — Primary key — NOT NULL
- RECIPE_ID (Key2) — VARCHAR2(500) — Foreign key → TB_RMS_EQP_RCP.RECIPE_ID — NOT NULL
- PROC_ID (Key22) — VARCHAR2(50) — Foreign key → TB_RMS_EQP_RCP.PROC_ID — NOT NULL
- EQP_ID (Key32) — VARCHAR2(50) — Foreign key → TB_RMS_EQP_RCP.EQP_ID — NOT NULL
- PARAMETER_ID (Key) — VARCHAR2(200) — Foreign key → TB_RMS_EQP_PARA.PARAMETER_ID — NOT NULL
- EQP_ID (Key33) — VARCHAR2(50) — Foreign key → TB_RMS_EQP_PARA.EQP_ID — NOT NULL
TB_RMS_EQP_RCP_PARA_APPROVAL ((고객사 모델별 PARA 정보 결재등록 MASTER))
- APPROVAL_TYPE (Key) — VARCHAR2(50) — Primary key — NOT NULL
- APPROVAL_ID (Field) — NUMBER — Primary key
TB_RMS_EQP_RCP_PARA_APPR_INFO ((고객사 모델별 PARA 정보 결재등록 MASTER 상세))
- PROC_ID (Key2) — VARCHAR2(50) — Primary key — NOT NULL
- EQP_ID (Key3) — VARCHAR2(50) — Primary key — NOT NULL
- RECIPE_ID (Key4) — VARCHAR2(500) — Primary key — NOT NULL
- PARAMETER_ID (Key5) — VARCHAR2(200) — Primary key — NOT NULL
- STEP_NUMBER (Key6) — VARCHAR2(50) — Primary key — NOT NULL
- CUST_MODEL_ID (Key7) — VARCHAR2(100) — Primary key — NOT NULL
- MODEL_ID (Key8) — VARCHAR2(50) — Primary key — NOT NULL
- PROC_SEQ (Key9) — NUMBER — Primary key — NOT NULL
- APPROVAL_TYPE (Key) — VARCHAR2(50) — Foreign key → TB_RMS_EQP_RCP_PARA_APPROVAL.APPROVAL_TYPE — NOT NULL
- APPROVAL_ID (Field) — NUMBER — Foreign key → TB_RMS_EQP_RCP_PARA_APPROVAL.APPROVAL_ID
TB_RMS_EQP_RCP_PARA_APPR_USER ((고객사 모델별 PARA 정보 결재등록 별 결재자))
- APPROVAL_TYPE (Key) — VARCHAR2(50) — Foreign key → TB_RMS_EQP_RCP_PARA_APPROVAL.APPROVAL_TYPE — NOT NULL
- APPROVAL_ID (Field) — NUMBER — Foreign key → TB_RMS_EQP_RCP_PARA_APPROVAL.APPROVAL_ID
- APPROVAL_STEP (Key22) — NUMBER — Foreign key → TB_RMS_APPR_USER_MST.APPROVAL_STEP — NOT NULL
- USER_ID (Field2) — VARCHAR2(64) — Foreign key → TB_RMS_APPR_USER_MST.USER_ID
TB_RMS_EQP_RCP_PARA_H ((레시피 ID 별 BODY 등록 히스토리))
- ACTION (Key4) — VARCHAR2(50) — Primary key — NOT NULL
- COLUMN_ID (Key5) — VARCHAR2(100) — Primary key — NOT NULL
- Key6 — TIMESTAMP(6) — Primary key — NOT NULL
- STEP_NUMBER (Key3) — VARCHAR2(50) — Foreign key → TB_RMS_EQP_RCP_PARA.STEP_NUMBER — NOT NULL
- RECIPE_ID (Key2) — VARCHAR2(500) — Foreign key → TB_RMS_EQP_RCP_PARA.RECIPE_ID — NOT NULL
- PROC_ID (Key22) — VARCHAR2(50) — Foreign key → TB_RMS_EQP_RCP_PARA.PROC_ID — NOT NULL
- EQP_ID (Key32) — VARCHAR2(50) — Foreign key → TB_RMS_EQP_RCP_PARA.EQP_ID — NOT NULL
- PARAMETER_ID (Key) — VARCHAR2(200) — Foreign key → TB_RMS_EQP_RCP_PARA.PARAMETER_ID — NOT NULL
- EQP_ID (Key33) — VARCHAR2(50) — Foreign key → TB_RMS_EQP_RCP_PARA.EQP_ID — NOT NULL
TB_RMS_MODEL_CHG_RCP_REQ_LOG ((EIF MODEL 변경 레시피 다운로드 요청 통신 로그 정보(AP)))
- CREATED_DTTM (Key) — TIMESTAMP(6) — Primary key — NOT NULL
- EQP_ID (Field) — VARCHAR2(50) — Primary key
TB_RMS_RCP_DOWN_LOG ((RMS->설비 레시피 다운로드 명령 통신 로그 정보(AP)))
- CREATED_DTTM (Key) — TIMESTAMP(6) — Primary key — NOT NULL
- EQP_ID (Key2) — VARCHAR2(50) — Primary key — NOT NULL
TB_RMS_RCP_LIST_LOG ((RMS->설비 레시피 조회 명령 통신 로그 정보(AP)))
- CREATED_DTTM (Key) — TIMESTAMP(6) — Primary key — NOT NULL
- EQP_ID (Key2) — VARCHAR2(50) — Primary key — NOT NULL
TB_RMS_RCP_PARA_CHG_RPT_LOG ((설비->RMS 레시피 파라메터 변경 보고 통신 로그 정보(AP)))
- CREATED_DTTM (Key) — TIMESTAMP(6) — Primary key — NOT NULL
- EQP_ID (Key2) — VARCHAR2(50) — Primary key — NOT NULL
TB_RMS_RCP_PARA_DOWN_REQ_LOG ((RMS->설비 레시피 파라메터 다운로드 명령 통신 로그 정보(AP)))
- CREATED_DTTM (Key) — TIMESTAMP(6) — Primary key — NOT NULL
- EQP_ID (Key2) — VARCHAR2(50) — Primary key — NOT NULL
TB_RMS_RCP_PARA_LOG ((RMS->설비 레시피 파라메터 조회 통신 로그 정보(AP)))
- CREATED_DTTM (Key) — TIMESTAMP(6) — Primary key — NOT NULL
- EQP_ID (Key2) — VARCHAR2(50) — Primary key — NOT NULL
TB_RMS_SESSION ((EIF->RMS 접속 SESSION 관리))
- SERVER_ID (Key) — VARCHAR2(50) — Primary key — NOT NULL
- SERVER_IP (Field) — VARCHAR2(50) — Primary key
- SERVER_PORT (Field2) — VARCHAR2(50) — Primary key
- EIF_ID (Field3) — VARCHAR2(50) — Primary key
- EIF_IP (Field4)
TB_RMS_VALIDATION_H ((RMS 벨리데이션 체크 결과 이력 정보(AP)))
- PROC_ID (Key) — VARCHAR2(50) — Primary key — NOT NULL
- EQP_ID (Key2) — VARCHAR2(50) — Primary key — NOT NULL
- CREATED_DTTM (Key3) — TIMESTAMP(6) — Primary key — NOT NULL