UDE_ERD_UDVS_EN
테이블 (14)
Allowable error attribute of verification (PLG_UDVS_VF_ALLOWABLE_ERROR)
- Unique ID of allowable error attribute (ALLOWABLE_ERROR_ATTR_ID) — VARCHAR2(50 CHAR) — 기본 키
- Unique ID of verification rule item (RULE_ITEM_ID) — VARCHAR2(50 CHAR) — 외래 키 → Verification rule items.Unique ID of rule item
- Default value of allowable error (ALLOWABLE_ERROR_BASE) — VARCHAR2(50 CHAR)
- Result of allowable error (ALLOWABLE_ERROR_RESULT) — VARCHAR2(50 CHAR)
- Registration date (REG_DATE) — DATE
- Allowable error handling (ALLOWABLE_ERROR_JUDGEMENT) — VARCHAR2(50 CHAR)
Design information (PLG_UDMS_DESIGN_INFO)
- Unique ID of design (DESIGN_ID) — VARCHAR2(50 CHAR) — 기본 키
- Unique ID of project (PROJECT_ID) — VARCHAR2(50 CHAR)
- Unique ID of board (BOARD_ID) — VARCHAR2(50 CHAR)
- Unique ID of BOM (BOM_ID) — VARCHAR2(50 CHAR)
- Registration date (DATE_REGISTED) — DATE
- Plant code (PLANT_CODE) — VARCHAR2(50 CHAR)
ECAD link information of verification result (PLG_UDMS_VF_RULE_RESULT_ECAD_LINK)
- Unique ID of result (RESULT_ID) — VARCHAR2(50 CHAR) — 외래 키 → Verification result.Unique ID of result
- ECAD link information (ECAD_LINK_INFO) — VARCHAR2(100 CHAR)
Linked rule item of verification (PLG_UDVS_VF_LINKED_RULE_ITEM)
- Unique ID of veirification rule item (RULE_ITEM_ID) — VARCHAR2(50 CHAR) — 외래 키 → Verification rule items.Unique ID of rule item
- Registration date (REG_DATE) — DATE
Linked rule item result of verification (PLG_UDVS_VF_LINKED_RULE_ITEM_RESULT)
- Unique ID of verificatin rule item (RULE_ITEM_ID) — VARCHAR2(50 CHAR) — 외래 키 → Verification rule item results.Unique ID of verification rule item
- Unique ID of verification rule item attribute (RESULT_ATTR_ID) — VARCHAR2(50 CHAR) — 외래 키 → Verification rule item results.Unique ID of verification rule item attribute
- Is visible or not (VISIBLE_FLAG) — VARCHAR2(1 CHAR)
- Order of column (COLUMN_ORDER) — NUMBER(10,0)
Rule link of verification (PLG_UDMS_VF_RULE_LINK)
- Rule link ID (LINK_ID) — VARCHAR2(50 CHAR) — 기본 키
- Unique ID of design (DESIGN_ID) — VARCHAR2(50 CHAR) — 외래 키 → Design information.Unique ID of design
- Process item code (PROCESS_ITEM_CODE) — VARCHAR2(100 CHAR)
- SRC file ID (SRC_FILE_ID) — VARCHAR2(50 CHAR)
- Result file ID (RESULT_FILE_ID) — VARCHAR2(50 CHAR)
- Result EXCEL file ID (RESULT_EXCEL_FILE_ID) — VARCHAR2(50 CHAR)
- Verification result (VERIFICATION_RESULT) — VARCHAR2(10 CHAR)
- Registration date (REG_DATE) — DATE
- UPF zip file name (UPF_ZIP_FILE_NAME) — VARCHAR2(50 CHAR)
- PollEx verification result (POLLEX_VF_RESULT) — VARCHAR2(10 CHAR)
Thermal frequency management of conductable material (PLG_UDVS_ELECTRIC_MATERIAL_FREQ)
- Unique ID of frequency (FREQUENCY_ID) — VARCHAR2(50 CHAR) — 기본 키
- Unique ID of material (MATERIAL_ID) — VARCHAR2(50 CHAR) — 외래 키 → Thermal management of conductable material.Unique ID of material
- Frequency (FREQUENCY) — VARCHAR2(50 CHAR)
- Dielectric constant (DIELECTRIC_CONSTANT) — VARCHAR2(50 CHAR)
- Tangent loss (LOSS_TANGENT) — VARCHAR2(50 CHAR)
- Electric resistance (ELECTRIC_RESISTIVITY) — VARCHAR2(50 CHAR)
- Magnetic conductivity (RELATIVE_MAG_PERM) — VARCHAR2(50 CHAR)
Thermal management of conductable material (PLG_UDVS_ELECTRIC_MATERIAL)
- Unique ID of material (MATERIAL_ID) — VARCHAR2(50 CHAR) — 기본 키
- Material name (MATERIAL_NAME) — VARCHAR2(50 CHAR)
- Material type (MATERIAL_TYPE) — VARCHAR2(50 CHAR)
- Thermal x-coordinate (THERMAL_CON_X) — VARCHAR2(50 CHAR)
- Thermal y-coordinate (THERMAL_CON_Y) — VARCHAR2(50 CHAR)
- Thermal z-coordinate (THERMAL_CON_Z) — VARCHAR2(50 CHAR)
- Hidden or not (DELETE_FLAG) — VARCHAR2(1 CHAR)
- Locked or not (LOCK_FLAG) — VARCHAR2(1 CHAR)
Verification result (PLG_UDMS_VF_RULE_RESULT)
- Unique ID of result (RESULT_ID) — VARCHAR2(50 CHAR) — 기본 키
- Rule link ID (RULE_LINK_ID) — VARCHAR2(50 CHAR) — 외래 키 → Rule link of verification.Rule link ID
- Unique ID of verification rule item (RULE_ITEM_ID) — VARCHAR2(50 CHAR) — 외래 키 → Verification rule items.Unique ID of rule item
- Unique ID of design (DESIGN_ID) — VARCHAR2(50 CHAR) — 외래 키 → Design information.Unique ID of design
- Standard (STANDARD) — VARCHAR2(50 CHAR)
- Result name1 (RESULT_NAME1) — VARCHAR2(150 CHAR)
- Result value1 (RESULT_VALUE1) — VARCHAR2(4000 CHAR)
- Result name2 (RESULT_NAME2) — VARCHAR2(150 CHAR)
- Result value2 (RESULT_VALUE2) — VARCHAR2(4000 CHAR)
- Result name3 (RESULT_NAME3) — VARCHAR2(150 CHAR)
- Result value3 (RESULT_VALUE3) — VARCHAR2(4000 CHAR)
- Result name4 (RESULT_NAME4) — VARCHAR2(150 CHAR)
- Result value4 (RESULT_VALUE4) — VARCHAR2(4000 CHAR)
- Result name5 (RESULT_NAME5) — VARCHAR2(150 CHAR)
- Result value5 (RESULT_VALUE5) — VARCHAR2(4000 CHAR)
- Result name6 (RESULT_NAME6) — VARCHAR2(150 CHAR)
- Result value6 (RESULT_VALUE6) — VARCHAR2(4000 CHAR)
- Result name7 (RESULT_NAME7) — VARCHAR2(150 CHAR)
- Result value7 (RESULT_VALUE7) — VARCHAR2(4000 CHAR)
- Result name8 (RESULT_NAME8) — VARCHAR2(150 CHAR)
- Result value8 (RESULT_VALUE8) — VARCHAR2(4000 CHAR)
- Result name9 (RESULT_NAME9) — VARCHAR2(150 CHAR)
- Result value9 (RESULT_VALUE9) — VARCHAR2(4000 CHAR)
- Result name10 (RESULT_NAME10) — VARCHAR2(150 CHAR)
- Result value10 (RESULT_VALUE10) — VARCHAR2(4000 CHAR)
- Result name11 (RESULT_NAME11) — VARCHAR2(150 CHAR)
- Result value11 (RESULT_VALUE11) — VARCHAR2(4000 CHAR)
- Result name12 (RESULT_NAME12) — VARCHAR2(150 CHAR)
- Result value12 (RESULT_VALUE12) — VARCHAR2(4000 CHAR)
- Result name13 (RESULT_NAME13) — VARCHAR2(150 CHAR)
- Result value13 (RESULT_VALUE13) — VARCHAR2(4000 CHAR)
- Result name14 (RESULT_NAME14) — VARCHAR2(150 CHAR)
- Result value14 (RESULT_VALUE14) — VARCHAR2(4000 CHAR)
- Result name15 (RESULT_NAME15) — VARCHAR2(150 CHAR)
- Result value15 (RESULT_VALUE15) — VARCHAR2(4000 CHAR)
- Order of result (RESULT_ORDER) — NUMBER(10,0)
- Result value16 (RESULT_VALUE16) — VARCHAR2(4000 CHAR)
- Result value17 (RESULT_VALUE17) — VARCHAR2(4000 CHAR)
- Result value18 (RESULT_VALUE18) — VARCHAR2(4000 CHAR)
- Result value19 (RESULT_VALUE19) — VARCHAR2(4000 CHAR)
- Result value20 (RESULT_VALUE20) — VARCHAR2(4000 CHAR)
- Result value21 (RESULT_VALUE21) — VARCHAR2(4000 CHAR)
- Result value22 (RESULT_VALUE22) — VARCHAR2(4000 CHAR)
- Result value23 (RESULT_VALUE23) — VARCHAR2(4000 CHAR)
- Result value24 (RESULT_VALUE24) — VARCHAR2(4000 CHAR)
- Result value25 (RESULT_VALUE25) — VARCHAR2(4000 CHAR)
- Result value26 (RESULT_VALUE26) — VARCHAR2(4000 CHAR)
- Result value27 (RESULT_VALUE27) — VARCHAR2(4000 CHAR)
- Result value28 (RESULT_VALUE28) — VARCHAR2(4000 CHAR)
- Result value29 (RESULT_VALUE29) — VARCHAR2(4000 CHAR)
- Result value30 (RESULT_VALUE30) — VARCHAR2(4000 CHAR)
- Result value31 (RESULT_VALUE31) — VARCHAR2(4000 CHAR)
- Result value32 (RESULT_VALUE32) — VARCHAR2(4000 CHAR)
- Result value33 (RESULT_VALUE33) — VARCHAR2(4000 CHAR)
- Result value34 (RESULT_VALUE34) — VARCHAR2(4000 CHAR)
- Result value35 (RESULT_VALUE35) — VARCHAR2(4000 CHAR)
- Result value36 (RESULT_VALUE36) — VARCHAR2(4000 CHAR)
- Result value37 (RESULT_VALUE37) — VARCHAR2(4000 CHAR)
- Result value38 (RESULT_VALUE38) — VARCHAR2(4000 CHAR)
- Result value39 (RESULT_VALUE39) — VARCHAR2(4000 CHAR)
- … +107
Verification rule file information (PLG_UDVS_RULE_FILE)
- Unique ID of verification rule file (RULE_FILE_ID) — VARCHAR2(50 CHAR) — 기본 키
- Unique ID of class (CLASS_ID) — VARCHAR2(50 CHAR)
- Rule file description (RULE_FILE_DESCRIPTION) — VARCHAR2(500 CHAR)
- Registration date (REG_DATE) — DATE
- Division of verification rule file (RULE_FILE_GUBUN) — VARCHAR2(100 CHAR)
- Plant code (PLANT_CODE) — VARCHAR2(50 CHAR)
- Verification rule file type (RULE_FILE_TYPE) — VARCHAR2(100 CHAR)
- Database file path (DB_FILE_PATH) — VARCHAR2(4000 CHAR)
- PollEx verification solver type (POLLEX_VF_SOLVER_TYPE) — VARCHAR2(100 CHAR)
- Verification rule file title (RULE_FILE_TITLE) — VARCHAR2(100 CHAR)
- Verification rule file group ID (RULE_FILE_GROUP_ID) — VARCHAR2(50 CHAR)
Verification rule item group (PLG_UDVS_VF_RULE_ITEM_GROUP)
- Unique ID of verificaation rule item group (RULE_ITEM_GROUP_ID) — VARCHAR2(50 CHAR) — 기본 키
- Verification rule item group name (RULE_ITEM_GROUP_NAME) — VARCHAR2(100 CHAR)
- Rule division ID (Deprecated) (RULE_GUBUN_ID) — VARCHAR2(50 CHAR)
- Rule type ID (Deprecated) (RULE_TYPE_ID) — VARCHAR2(50 CHAR)
- Description (DESCRIPTION) — VARCHAR2(200 CHAR)
- Hidden or not (DELETE_FLAG) — VARCHAR2(1 CHAR)
- Order of veirification rule item group (RULE_ITEM_GROUP_ORDER) — NUMBER(10,0)
Verification rule item results (PLG_UDVS_VF_RULE_ITEM_RESULTS)
- Unique ID of verification rule item attribute (RESULT_ATTR_ID) — VARCHAR2(50 CHAR) — 기본 키
- Unique ID of verification rule item (RULE_ITEM_ID) — VARCHAR2(50 CHAR) — 외래 키 → Verification rule items.Unique ID of rule item
- Verification rule item attribute name (RESULT_ATTR_NAME) — VARCHAR2(200 CHAR)
- Parsed column name of verification result (COLUMN_NAME) — VARCHAR2(200 CHAR)
- Is visible or not (VISIBLE_FLAG) — VARCHAR2(1 CHAR)
- Is base or not (BASE_FLAG) — VARCHAR2(1 CHAR)
- Has result or not (RESULT_FLAG) — VARCHAR2(1 CHAR)
- Order of column (COLUMN_ORDER) — NUMBER(10,0)
- Registration date (REG_DATE) — DATE
- Verification rule item attribute type (RESULT_ATTR_TYPE) — VARCHAR2(50 CHAR)
Verification rule items (PLG_UDVS_VF_RULE_ITEMS)
- Unique ID of rule item (RULE_ITEM_ID) — VARCHAR2(50 CHAR) — 기본 키
- Unique item of verification rule item group (RULE_ITEM_GROUP_ID) — VARCHAR2(50 CHAR) — 외래 키 → Verification rule item group.Unique ID of verificaation rule item group
- Verification rule item name (RULE_ITEM_NAME) — VARCHAR2(100 CHAR)
- Description (DESCRIPTION) — VARCHAR2(200 CHAR)
- Hidden or not (DELETE_FLAG) — VARCHAR2(1 CHAR)
- Order of verification rule item (RULE_ITEM_ORDER) — NUMBER(10,0)
- Is simple information or not (JUST_INFORMATION) — VARCHAR2(1 CHAR)
가성 에러 정보 (PLG_UDMS_VF_ALLOWABLE_ERROR)
- Unique ID of allowable error (ALLOWABLE_ERROR_ID) — VARCHAR2(50 CHAR) — 기본 키
- Unique ID of design (DESIGN_ID) — VARCHAR2(50 CHAR) — 외래 키 → Design information.Unique ID of design
- Unique ID of verification rule item (RULE_ITEM_ID) — VARCHAR2(50 CHAR) — 외래 키 → Verification rule items.Unique ID of rule item
- Rule link ID (RULE_LINK_ID) — VARCHAR2(50 CHAR) — 외래 키 → Rule link of verification.Rule link ID
- Design ID2 (DESIGN_ID2) — VARCHAR2(50 CHAR) — 외래 키 → Rule link of verification.Unique ID of design
- Result name1 (RESULT_NAME1) — VARCHAR2(150 CHAR)
- Result name2 (RESULT_NAME2) — VARCHAR2(150 CHAR)
- Result name3 (RESULT_NAME3) — VARCHAR2(150 CHAR)
- Result name4 (RESULT_NAME4) — VARCHAR2(150 CHAR)
- Result name5 (RESULT_NAME5) — VARCHAR2(150 CHAR)
- Result name6 (RESULT_NAME6) — VARCHAR2(150 CHAR)
- Result name7 (RESULT_NAME7) — VARCHAR2(150 CHAR)
- Result name8 (RESULT_NAME8) — VARCHAR2(150 CHAR)
- Result name9 (RESULT_NAME9) — VARCHAR2(150 CHAR)
- Result name11 (RESULT_NAME11) — VARCHAR2(150 CHAR)
- Result name10 (RESULT_NAME10) — VARCHAR2(150 CHAR)
- Result name12 (RESULT_NAME12) — VARCHAR2(150 CHAR)
- Result name13 (RESULT_NAME13) — VARCHAR2(150 CHAR)
- Result name14 (RESULT_NAME14) — VARCHAR2(150 CHAR)
- Result name15 (RESULT_NAME15) — VARCHAR2(150 CHAR)
- Result name16 (RESULT_NAME16) — VARCHAR2(150 CHAR)
- Result name17 (RESULT_NAME17) — VARCHAR2(150 CHAR)
- Result name18 (RESULT_NAME18) — VARCHAR2(150 CHAR)
- Result name19 (RESULT_NAME19) — VARCHAR2(150 CHAR)
- Result name20 (RESULT_NAME20) — VARCHAR2(150 CHAR)
- Result name21 (RESULT_NAME21) — VARCHAR2(150 CHAR)
- Result name22 (RESULT_NAME22) — VARCHAR2(150 CHAR)
- Result name23 (RESULT_NAME23) — VARCHAR2(150 CHAR)
- Result name24 (RESULT_NAME24) — VARCHAR2(150 CHAR)
- Result name25 (RESULT_NAME25) — VARCHAR2(150 CHAR)
- Result name26 (RESULT_NAME26) — VARCHAR2(150 CHAR)
- Result name27 (RESULT_NAME27) — VARCHAR2(150 CHAR)
- Result name28 (RESULT_NAME28) — VARCHAR2(150 CHAR)
- Result name29 (RESULT_NAME29) — VARCHAR2(150 CHAR)
- Result name30 (RESULT_NAME30) — VARCHAR2(150 CHAR)
- Result name31 (RESULT_NAME31) — VARCHAR2(150 CHAR)
- Result name32 (RESULT_NAME32) — VARCHAR2(150 CHAR)
- Result name33 (RESULT_NAME33) — VARCHAR2(150 CHAR)
- Result name34 (RESULT_NAME34) — VARCHAR2(150 CHAR)
- Result name35 (RESULT_NAME35) — VARCHAR2(150 CHAR)
- Result name36 (RESULT_NAME36) — VARCHAR2(150 CHAR)
- Result name37 (RESULT_NAME37) — VARCHAR2(150 CHAR)
- Result name38 (RESULT_NAME38) — VARCHAR2(150 CHAR)
- Result name39 (RESULT_NAME39) — VARCHAR2(150 CHAR)
- Result name40 (RESULT_NAME40) — VARCHAR2(150 CHAR)
- Result name41 (RESULT_NAME41) — VARCHAR2(150 CHAR)
- Result name42 (RESULT_NAME42) — VARCHAR2(150 CHAR)
- Result name43 (RESULT_NAME43) — VARCHAR2(150 CHAR)
- Result name44 (RESULT_NAME44) — VARCHAR2(150 CHAR)
- Result name45 (RESULT_NAME45) — VARCHAR2(150 CHAR)
- Result name46 (RESULT_NAME46) — VARCHAR2(150 CHAR)
- Result name47 (RESULT_NAME47) — VARCHAR2(150 CHAR)
- Result name48 (RESULT_NAME48) — VARCHAR2(150 CHAR)
- Result name49 (RESULT_NAME49) — VARCHAR2(150 CHAR)
- Result name50 (RESULT_NAME50) — VARCHAR2(150 CHAR)
- Result name51 (RESULT_NAME51) — VARCHAR2(150 CHAR)
- Result name52 (RESULT_NAME52) — VARCHAR2(150 CHAR)
- Result name53 (RESULT_NAME53) — VARCHAR2(150 CHAR)
- Result name54 (RESULT_NAME54) — VARCHAR2(150 CHAR)
- Result name55 (RESULT_NAME55) — VARCHAR2(150 CHAR)
- … +107