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