ICS ERD ( 천안 SDC 현장 )

테이블 (29)

FV_CODE ( 데이터 없음 ) (FV_CODE)

  • Key (CODE_CATEGORY) — VARCHAR2 (30) — 기본 키 — NOT NULL
  • Key2 (CODE_GROUP) — VARCHAR2 (30) — 기본 키 — NOT NULL
  • Key3 (CODE) — VARCHAR2 (30) — 기본 키 — NOT NULL
  • Field (CODE_NAME) — VARCHAR2 (30)
  • Field2 (CODE_DESC) — VARCHAR2 (2000)

FV_ITEM_LOCATION (데이터 없음) (Untitled2)

  • Key (ITEM_ID) — VARCHAR2 (40) — 기본 키 — NOT NULL
  • Field (LINE_ID) — VARCHAR2 (20)
  • Field (ROOM_ID) — VARCHAR2 (20)
  • Field (ITEM_TYPE) — VARCHAR2 (20)
  • Field2 (ITEM_GROUP) — VARCHAR2 (20)
  • Field3 (ITEM_NAME) — VARCHAR2 (30)
  • Field4 (ITEM_STATUS) — VARCHAR2 (20)
  • Field5 (ITEM_X) — NUMBER
  • Field6 (ITEM_Y) — NUMBER
  • Field8 (ITEM_WIDTH) — NUMBER
  • Field7 (ITEM_HEIGHT) — NUMBER
  • Field9 (ITEM_COLUMN) — NUMBER
  • Field (ITEM_ROW) — NUMBER
  • Field2 (ITEM_COLOR) — VARCHAR2 (20)
  • Field3 (ITEM_BORDER_COLOR) — VARCHAR2 (20)
  • Field4 (ITEM_TAG) — VARCHAR2 (50)
  • Field5 (ITEM_DESC) — VARCHAR2 (2000)
  • Field6 (IMAGE_PATH) — VARCHAR2 (255)

FV_MODEL_EQUIP (데이터 없음) (Untitled)

  • Key (EQUIP_ID) — VARCHAR2 (20) — 기본 키 — NOT NULL
  • Field (EQUIP_NAME) — VARCHAR2 (50)
  • Field2 (MODEL_FILE) — VARCHAR2 (200)
  • Field3 (MODEL_VER) — VARCHAR2 (50)
  • Field4 (EQUIP_DESC) — VARCHAR2 (2000)
  • Field5 (RELEASE_TIME) — DATE

FV_MODEL_FILE (데이터 없음) (Untitled3)

  • Key (MODEL_FILE) — VARCHAR2 (40) — 기본 키 — NOT NULL
  • Field (MODEL_VER) — VARCHAR2 (50)
  • Field2 (REPISITORY_ID) — VARCHAR2 (20)
  • Field3 (FILE_PATH) — VARCHAR2 (200)
  • Field4 (CREATE_TIME) — DATE
  • Field5 (UPDATE_TIME) — DATE

FV_MODEL_FILE_H (데이터 없음) (Untitled4)

  • Key (MODEL_VER) — VARCHAR2 (50) — 기본 키 — NOT NULL
  • Key (MODEL_FILE) — VARCHAR2 (40) — 외래 키 → FV_MODEL_FILE (데이터 없음).Key — NOT NULL
  • Field (REPOSITORY_ID) — VARCHAR2 (20)
  • Field2 (FILE_PATH) — VARCHAR2 (200)
  • Field3 (UPDATE_TIME) — DATE

ICS_STATE_SERVER (데이터 없음) (Untitled5)

  • Key (SERVER_ID) — VARCHAR2 (20) — 기본 키 — NOT NULL
  • Field (HDD_USAGE) — NUMBER
  • Field2 (DISK_FAIL_COUNT) — NUMBER (3)
  • Field3 (CHECK_TIME) — DATE

SI_MODULE (데이터 없음) (Untitled15)

  • Key (MODULE_ID) — VARCHAR2 (50) — 기본 키 — NOT NULL
  • Field (EQUIP_ID) — VARCHAR2 (20)
  • Field2 (MODULE_TYPE) — VARCHAR2 (20)
  • Field3 (MODULE_DESC) — VARCHAR2 (2000)
  • Field4 (ADMIN_USER) — VARCHAR2 (20)
  • Field5 (CREATE_TIME) — DATE
  • Field6 (UPDATE_TIME) — DATE

SI_STEP (데이터 없음) (Untitled17)

  • Key (STEP_ID) — VARCHAR2 (20) — 기본 키 — NOT NULL
  • Field (STEP_NAME) — VARCHAR2 (50)
  • Field2 (STEP_DESC) — VARCHAR2 (2000)
  • Field3 (ADMIN_USER) — VARCHAR2 (20)
  • Field4 (CREATE_TIME) — DATE
  • Field5 (UPDATE_TIME) — DATE

SU_EQUIP (데이터 없음) (Untitled12)

  • Key (EQUIP_ID) — VARCHAR2 (20) — 기본 키 — NOT NULL
  • Field (EQUIP_TYPE) — VARCHAR2 (50)
  • Field2 (EQUIP_NAME) — VARCHAR2 (50)
  • Field3 (EQUIP_DESC) — VARCHAR2 (2000)
  • Field4 (ADMIN_USER) — VARCHAR2 (20)
  • Field5 (CREATE_TIME) — DATE
  • Field6 (UPDATE_TIME) — DATE

Untitled10 (SE_USER)

  • Key (USER_ID) — VARCHAR2 (20) — 기본 키 — NOT NULL
  • Field (USER_NAME) — VARCHAR2 (20)
  • Field2 (USER_PASSWORD) — VARCHAR2 (50)
  • Field3 (SHIFT_GROUP) — VARCHAR2 (20)
  • Field4 (DEPT) — VARCHAR2 (20)
  • Field5 (CHIEF_USER) — VARCHAR2 (20)
  • Field6 (PHONE_NO) — VARCHAR2 (20)
  • Field7 (EMAIL) — VARCHAR2 (200)
  • Field8 (USER_DESC) — VARCHAR2 (2000)
  • Field9 (USER_OPTION) — CLOB
  • Field10 (ADMIN_USER) — VARCHAR2 (20)
  • Field11 (CREATE_TIME) — DATE
  • Field12 (UPDATE_TIME) — DATE

Untitled11 (SI_DEFECT_CLASS)

  • Key (EQUIP_TYPE) — VARCHAR2 (50) — 기본 키 — NOT NULL
  • Key2 (CLASS_NO) — NUMBER (5) — 기본 키 — NOT NULL
  • Field (CLASS_NAME) — VARCHAR2 (50)
  • Field2 (CLASS_CAT) — VARCHAR2 (20)
  • Field3 (CLASS_DESC) — VARCHAR2 (2000)
  • Field4 (ADMIN_USER) — VARCHAR2 (20)
  • Field5 (CREATE_TIME) — DATE
  • Field6 (UPDATE_TIME) — DATE

Untitled13 (SU_JUDGE_CLASS)

  • Key2 (EQUIP_TYPE) — VARCHAR2 (50) — 기본 키 — NOT NULL
  • Key (JUDGE_NO) — NUMBER — 기본 키 — NOT NULL
  • Field (JUDGE_NAME) — VARCHAR2 (50)
  • Field2 (JUDGE_CAT) — VARCHAR2 (20)
  • Field3 (JUDGE_DESC) — VARCHAR2 (2000)
  • Field4 (USAGE_CODE) — VARCHAR2 (20)
  • Field5 (ADMIN_USER) — VARCHAR2 (20)
  • Field6 (CREATE_TIME) — DATE
  • Field7 (UPDATE_TIME) — DATE

Untitled14 (SI_JUDGE_REASON)

  • Key (EQUIP_TYPE) — VARCHAR2 (50) — 기본 키 — NOT NULL
  • Key2 (JUDGE_NO) — NUMBER — 기본 키 — NOT NULL
  • Key3 (REASON_CODE) — VARCHAR2 (20) — 기본 키 — NOT NULL
  • Key4 (REASON_SUBCODE) — VARCHAR2 (20) — 기본 키 — NOT NULL
  • Field (REASON_DESC) — VARCHAR2 (2000)
  • Field2 (REASON_GROUP) — VARCHAR2 (50)
  • Field3 (USEAGE_CODE) — VARCHAR2 (50)
  • Field4 (ADMIN_USER) — VARCHAR2 (20)
  • Field5 (CREATE_TIME) — DATE
  • Field6 (UPDATE_TIME) — DATE

Untitled16 (SI_MODULR_IF)

  • Key (MODULE_ID) — VARCHAR2 (50) — 기본 키 — NOT NULL
  • Field (EQUIP_ID) — VARCHAR2 (20)
  • Field2 (MODULE_TYPE) — VARCHAR2 (20)
  • Field3 (IP) — VARCHAR2 (20)
  • Field4 (PORT) — VARCHAR2 (20)
  • Field5 (ACCESS_TYPE) — VARCHAR2 (20)
  • Field6 (MODULE_IF_DESC) — VARCHAR2 (2000)
  • Field7 (ADMIN_USER) — VARCHAR2 (20)
  • Field8 (CREATE_TIME) — DATE
  • Field9 (UPDATE_TIME) — DATE

Untitled5 (ICS_JUDGE_PANEL)

  • Key (JUDGE_DEPT) — VARCHAR2 (20) — 기본 키 — NOT NULL
  • Key (SCAN_INDEX) — NUMBER — 외래 키 → Untitled5.Key — NOT NULL
  • Field (OPERATOR) — VARCHAR2 (20)
  • Field2 (JUDGE_TIME) — DATE
  • Field3 (JUDGE_NO) — NUMBER (5)
  • Field4 (REASON_CODE) — VARCHAR2 (20)
  • Field5 (REASON_SUBCODE) — VARCHAR2 (20)
  • Field6 (JUDGE_E) — VARCHAR2 (20)
  • Field7 (REASON_CODE_E) — VARCHAR2 (20)
  • Field8 (TKOUT_FLAG) — VARCHAR2 (20)
  • Field9 (JUDGE_TIME_E) — DATE
  • Field10 (ICS_LEVEL) — VARCHAR2 (20)
  • Field11 (ICS_TIMEOUT) — VARCHAR2 (20)
  • Field12 (ICS_COMMENT) — VARCHAR2 (20)
  • Field13 (USER_COMMENT) — VARCHAR2 (2000)

Untitled5 (ICS_SCAN_PANEL)

  • Key (SCAN_INDEX) — NUMBER — 기본 키 — NOT NULL
  • Field (PANEL_ID) — VARCHAR2 (50)
  • Field2 (MOUDLE_ID) — VARCHAR2 (50)
  • Field3 (STEP_ID) — VARCHAR2 (20)
  • Field4 (PROCESS_ID) — VARCHAR2 (20)
  • Field5 (PRODUCT_ID) — VARCHAR2 (50)
  • Field6 (PRODUCT_TYPE) — VARCHAR2 (20)
  • Field7 (RECIPE_ID) — VARCHAR2 (40)
  • Field8 (START_TIME) — DATE
  • Field9 (END_TIME) — DATE
  • Field10 (L_TIME) — DATE
  • Field11 (U_TIME) — DATE
  • Field12 (P_GRADE1) — VARCHAR2 (20)
  • Field13 (P_GRADE2) — VARCHAR2 (20)
  • Field14 (P_CODE) — VARCHAR2 (20)
  • Field15 (REPOSITORY_ID) — VARCHAR2 (20)
  • Field16 (MIDDLE_PATH) — VARCHAR2 (256)
  • Field17 (RAW_FILE) — VARCHAR2 (200)
  • Field18 (LOAD_TIME) — DATE
  • Field19 (UPDATE_TIME) — DATE
  • Field20 (PKEY) — NUMBER
  • Field21 (EQUIP_TYPE) — VARCHAR2 (50)
  • Field22 (UNIT_ID) — VARCHAR2 (20)
  • Field23 (CAM_POS) — VARCHAR2 (20)
  • Field (PANEL_SIZE_X) — NUMBER
  • Field2 (PANEL_SIZE_Y) — NUMBER
  • Field3 (RDP_TYPE) — VARCHAR2 (20)
  • Field (SCAN_TYPE) — VARCHAR2 (20)

Untitled5 (ICS_DEFECT)

  • Key (SCAN_INDEX) — NUMBER — 외래 키 → Untitled5.Key — NOT NULL
  • Field (PKEY) — NUMBER (2)
  • Field2 (DEFECT_NO) — NUMBER (4)
  • Field (COORD_X) — NUMBER
  • Field2 (COORD_Y) — NUMBER
  • Field3 (CLASS_NO) — NUMBER (5)
  • Field4 (D_CODE) — VARCHAR2 (20)
  • Field5 (IMAGE_NAME) — VARCHAR2 (200)
  • Field6 (IMAGE_RESL) — NUMBER
  • Field7 (SIZE_S) — NUMBER
  • Field8 (SIZE_W) — NUMBER
  • Field9 (SIZE_L) — NUMBER
  • Field10 (SIZE_H) — NUMBER
  • Field11 (D_GRADE1) — VARCHAR2 (20)
  • Field12 (D_GRADE2) — VARCHAR2 (20)
  • Field (STACK_COUNT) — NUMBER
  • Field2 (STACK_STEP) — VARCHAR2 (20)
  • Field3 (D_LABEL) — VARCHAR2 (200)

Untitled5 (ICS_EQ_COMM_H)

  • Key (SCAN_INDEX) — NUMBER — 외래 키 → Untitled5.Key — NOT NULL
  • Field (MOUDLE_ID) — VARCHAR2 (50)
  • Field2 (SEND_STATE) — VARCHAR2 (20)
  • Field3 (SEND_TIME) — DATE
  • Field4 (MESSAGE) — VARCHAR2 (2000)

Untitled5 (ICS_MEASURE)

  • Key (SCAN_INDEX) — NUMBER — 외래 키 → Untitled5.Key — NOT NULL
  • Field (PKEY) — NUMBER (2)
  • Field2 (POINT_ID) — VARCHAR2 (50)
  • Field3 (POINT_NO) — NUMBER (4)
  • Field4 (CELL_ID) — VARCHAR2 (50)
  • Field5 (LOC_X1) — NUMBER
  • Field6 (LOC_Y1) — NUMBER
  • Field7 (LOC_X2) — NUMBER
  • Field8 (LOC_Y2) — NUMBER
  • Field9 (GATELINE1) — NUMBER
  • Field10 (DATALINE1) — NUMBER
  • Field11 (GATELINE2) — NUMBER
  • Field12 (DATALINE2) — NUMBER
  • Field13 (IMAGE_NAME) — VARCHAR2 (200)
  • Field14 (IMAGE_RESL) — NUMBER
  • Field15 (N_MEASURE01) — NUMBER
  • Field16 (N_MEASURE02) — NUMBER
  • Field17 (N_MEASURE03) — NUMBER
  • Field18 (N_MEASURE04) — NUMBER
  • Field19 (N_MEASURE05) — NUMBER
  • Field20 (M_LABEL) — VARCHAR2 (200)

Untitled5 (ICS_JUDGE_REQ)

  • Key (JUDGE_DEFT) — VARCHAR2 (20) — 기본 키 — NOT NULL
  • Key (SCAN_INDEX) — NUMBER — 외래 키 → Untitled5.Key — NOT NULL
  • Field (REQ_TIME) — DATE
  • Field2 (START_TIME) — DATE
  • Field3 (PRIORITY_SCORE) — NUMBER
  • Field4 (MODULE_ID) — VARCHAR2 (50)
  • Field5 (PANEL_ID) — VARCHAR2 (50)
  • Field6 (REQUESTER) — VARCHAR2 (20)
  • Field7 (STATE) — VARCHAR2 (20)
  • Field8 (OPERATOR) — VARCHAR2 (20)
  • Key (ICS_ID) — VARCHAR2 (20) — 외래 키 → Untitled7.Key — NOT NULL

Untitled5 (ICS_JUDGE_H)

  • Key (JUDGE_DEPT) — VARCHAR2 (20) — 기본 키 — NOT NULL
  • Key2 (JUDGE_TIME) — DATE — 기본 키 — NOT NULL
  • Key (SCAN_INDEX) — NUMBER — 외래 키 → Untitled5.Key — NOT NULL
  • Field (REQ_TIME) — DATE
  • Field2 (START_TIME) — DATE
  • Field3 (ICS__ID) — VARCHAR2 (20)
  • Field4 (JUDGE_NO) — NUMBER (5)
  • Field5 (REASON_CODE) — VARCHAR2 (20)
  • Field6 (REASON_SUBCODE) — VARCHAR2 (20)
  • Field7 (OPERATOR) — VARCHAR2 (20)
  • Field8 (REQUESTER) — VARCHAR2 (20)
  • Field9 (STATE) — VARCHAR2 (20)
  • Field10 (USER_COMMENT) — VARCHAR2 (2000)

Untitled6 (SE_APP_ENV)

  • Key (SYSTEM_ID) — VARCHAR2 (20) — 기본 키 — NOT NULL
  • Key2 (APP_ID) — VARCHAR2 (50) — 기본 키 — NOT NULL
  • Field (APP_VER) — VARCHAR2 (50)
  • Field2 (FORMAT_VER) — VARCHAR2 (20)
  • Field3 (APP_DESC) — VARCHAR2 (2000)
  • Field4 (APP_CONFIG) — CLOB
  • Field5 (ADMIN_USER) — VARCHAR2 (20)
  • Field6 (CREATE_TIME) — DATE
  • Field7 (UPDATE_TIME) — DATE

Untitled6 (ICS_MURA)

  • Key (SCAN_INDEX) — NUMBER — 외래 키 → Untitled5.Key — NOT NULL
  • Field (PKEY) — NUMBER (2)
  • Field2 (MURA_ID) — VARCHAR2 (50)
  • Field3 (MURA_NO) — NUMBER (4)
  • Field4 (COORD_X) — NUMBER
  • Field5 (COORD_Y) — NUMBER
  • Field6 (GATE_NO) — NUMBER
  • Field7 (DATA_NO) — NUMBER
  • Field8 (SIZE_L) — NUMBER
  • Field9 (SIZE_H) — NUMBER

Untitled6 (ICS_MON_ITEM)

  • Key (ITEM_ID) — VARCHAR2 (20) — 기본 키 — NOT NULL
  • Field (ITEM_GROUP) — VARCHAR2 (20)
  • Field2 (VALUE) — VARCHAR2 (50)

Untitled7 (SE_ICS_COMMON_CONFIG)

  • Key (ICS_PART) — VARCHAR2 (20) — 기본 키 — NOT NULL
  • Field (ICS_CONFIG) — CLOB
  • Field2 (ADMIN_USER) — VARCHAR2 (20)
  • Field3 (CREATE_TIME) — DATE
  • Field4 (UPDATE_TIME) — DATE

Untitled7 (ICS_STATE_MOUDLE)

  • Key (MODULE_ID) — VARCHAR2 (50) — 기본 키 — NOT NULL
  • Field (MODULE_STATE) — VARCHAR2 (20)
  • Field2 (CHECK_TIME) — DATE
  • Field3 (LAST_PANEL_ID) — VARCHAR2 (50)
  • Field4 (LAST_PANEL_JUDGE) — VARCHAR2 (20)
  • Field5 (SEND_RESULT) — VARCHAR2 (20)
  • Field6 (SEND_TIME) — DATE

Untitled7 (ICS_STATE_ICS)

  • Key (ICS_ID) — VARCHAR2 (20) — 기본 키 — NOT NULL
  • Field (ICS_STATE) — VARCHAR2 (20)
  • Field2 (PRE_CELL_ID) — VARCHAR2 (50)
  • Field3 (PRE_CELL_JUDGE) — VARCHAR2 (20)
  • Field4 (CUR_CELL_ID) — VARCHAR2 (50)
  • Field5 (CHECK_TIME) — DATE
  • Field6 (OPERRATOR) — VARCHAR2 (20)
  • Field7 (MACHINE) — VARCHAR2 (20)
  • Field8 (ICS_GROUP) — VARCHAR2 (20)
  • Field9 (ICS_DESC) — VARCHAR2 (2000)
  • Field10 (ADMIN_USER) — VARCHAR2 (20)
  • Field11 (CREATE_TIME) — DATE
  • Field12 (UPDATE_TIME) — DATE

Untitled8 (SE_REPOSITORY)

  • Key (REPOSITORY_ID) — VARCHAR2 (20) — 기본 키 — NOT NULL
  • Field (SYSTEM_ID) — VARCHAR2 (20)
  • Field2 (DATA_TYPE) — VARCHAR2 (20)
  • Field3 (ACCESS_TYPE) — VARCHAR2 (20)
  • Field4 (ID) — VARCHAR2 (20)
  • Field5 (PASSWORD) — VARCHAR2 (20)
  • Field6 (PORT) — NUMBER
  • Field7 (HOME_PATH) — VARCHAR2 (200)
  • Field8 (DISK_PARTITION) — VARCHAR2 (20)
  • Field9 (DISK_TOTAL) — NUMBER
  • Field10 (DISK_USED) — NUMBER
  • Field11 (CHECK_TIME) — DATE
  • Field12 (LOCAL_PATH) — VARCHAR2 (200)
  • Field13 (REPOSITORY_DESC) — VARCHAR2 (2000)
  • Field14 (ADMIN_USER) — VARCHAR2 (20)
  • Field15 (CREATE_TIME) — DATE
  • Field16 (UPDATE_TIME) — DATE

Untitled9 (SE_SYSTEM)

  • Key (SYSTEM_ID) — VARCHAR2 (20) — 기본 키 — NOT NULL
  • Field (SYSTEM_NAME) — VARCHAR2 (50)
  • Field2 (PARENT_SYSTEM_ID) — VARCHAR2 (20)
  • Field3 (RELATED_EQUIP) — VARCHAR2 (20)
  • Field4 (SYSTEM_TYPE) — VARCHAR2 (20)
  • Field5 (ACCESS_TYPE) — VARCHAR2 (20)
  • Field6 (IP) — VARCHAR2 (20)
  • Field7 (ID) — VARCHAR2 (20)
  • Field8 (PASSWORD) — VARCHAR2 (50)
  • Field9 (SYSTEM_DESC) — VARCHAR2 (2000)
  • Field10 (ADMIN_USER) — VARCHAR2 (20)
  • Field11 (CREATE_TIME) — DATE
  • Field12 (UPDATE_TIME) — DATE