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