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