UDE_ERD_UDMS_EN

Tables (60)

Attributes of sample PCB order (PLG_UDMS_PCB_ORDER_ATTR)

  • Unique ID of task (TASK_ID) — VARCHAR2(50) — Foreign key → Common task information.Unique ID of task
  • Unique ID of design (DESIGN_ID) — VARCHAR2(50) — Foreign key → Design information.Unique ID of design
  • Unique ID of PCB Spec (PCB_SPEC_ID) — VARCHAR2(50) — Foreign key → PCB Spec information.PCB spec task ID
  • Cost (COST) — VARCHAR2(50)
  • Manufacturer (MANUFACTURER) — VARCHAR2(50)
  • Time limit (NEEDED_DATE) — DATE
  • SMT date (SMT_DATE) — DATE
  • Production number (PRODUCTION_NUMBER) — VARCHAR2(50)
  • Assembly number (ASSEMBLE_NUMBER) — VARCHAR2(50)
  • Revision (REVISION) — NUMBER(10,0)
  • Registration date (DATE_REGISTED) — DATE
  • Used approval process or not (APPROVAL_USE) — VARCHAR2(1)
  • Board information ID (BOARD_INFO_ID) — VARCHAR2(50)
  • Horizontal size of PCB (PCB_HORIZENTAL_SIZE) — VARCHAR2(50)
  • Vertical size of PCB (PCB_VERTICAL_SIZE) — VARCHAR2(50)
  • PCB Material (PCB_SURFACE_MATERIAL) — VARCHAR2(50)
  • PCB thickness (PCB_THICKNESS) — VARCHAR2(50)
  • PCB thickness (OZ) (PCB_THICKNESS_OZ) — VARCHAR2(50)
  • PCB layer (PCB_LAYER) — VARCHAR2(50)
  • Last checking task ID (LAST_PERMISSION_TASK_ID) — VARCHAR2(50)
  • comment (COMMENT) — VARCHAR2(4000)

Autorun process information (PLG_UDMS_CHECK_AUTORUN_PROCESS)

  • Unique ID of design (DESIGN_ID) — VARCHAR2(50) — Foreign key → Design information.Unique ID of design
  • Unique design of autorun process (CHECK_AUTORUN_PROCESS_ID) — VARCHAR2(50)
  • Autorun process code (CHECKED_AUTORUN_PROCESS) — VARCHAR2(3000)
  • Registration date (DATE_REGISTED) — DATE

Class plant (PLG_CMM_CLASS_PLANT)

  • Unique ID of class (CLASS_ID) — VARCHAR2(50) — Foreign key → Common class management.Unique ID of class
  • Plant code (PLANT_CODE) — VARCHAR2(50)
  • 생성 날짜 (DATE_REGISTED) — DATE

Common approval information (PLG_CMM_TASK_APPROVAL)

  • Unique ID of task approval (TASK_APPROVAL_ID) — VARCHAR2(50) — Primary key
  • Unique ID of task (TASK_ID) — VARCHAR2(50) — Foreign key → Common task information.Unique ID of task
  • Unique ID of process attribute (PROCESS_ATTR_ID) — VARCHAR2(50) — Foreign key → Common process attribute information.Unique ID of process attribute
  • Approver ID (APPROVAL_USER_ID) — VARCHAR2(50)
  • Order of approval (APPROVAL_ORDER) — NUMBER(10,0)
  • Is on approval or not (TARGET_FLAG) — VARCHAR2(50)
  • Finished or not (FINISH_FLAG) — VARCHAR2(50)
  • Approval comment (APPROVAL_COMMENT) — VARCHAR2(4000)
  • Approval date (APPROVAL_DATE) — DATE
  • Registration date (REG_DATE) — DATE
  • Division of approval (APPROVAL_GUBUN) — VARCHAR2(50)
  • Approval status (APPROVAL_STATUS) — VARCHAR2(30)
  • Surrogated or not (SURROGATE) — VARCHAR2(1)

Common class management (PLG_CMM_CLASS)

  • Unique ID of class (CLASS_ID) — VARCHAR2(50) — Primary key
  • Parent class ID (PARENT_CLASS_ID) — VARCHAR2(50)
  • Registration date (REG_DATE) — DATE
  • class display order (CLASS_ORDER) — NUMBER(10,0)
  • class name (Korean) (CLASS_NAME_K) — VARCHAR2(100)
  • class name (English) (CLASS_NAME_E) — VARCHAR2(100)
  • class name (Japanese) (CLASS_NAME_J) — VARCHAR2(100)
  • class name (Chinese) (CLASS_NAME_Z) — VARCHAR2(100)
  • Class code (CLASS_CODE) — VARCHAR2(100)
  • Hidden or not (DELETE_FLAG) — VARCHAR2(1)
  • Is temporary code or not (only for UPMS) (TEMP_CODE_FLAG) — VARCHAR2(1)
  • Is other class or not (only for UPMS) (CLASS_OPTION_ETC) — VARCHAR2(50)
  • Part value pattern (only for UPMS) (VALUE_COMBINE_PATTERN) — VARCHAR2(100)
  • Part spec pattern (only for UPMS) (PART_SPEC_COMBINE_PATTERN) — VARCHAR2(100)
  • From migration or not (MIGRATION_FLAG) — VARCHAR2(1)
  • Class code of legacy system (only for UPMS) (LEGACY_CLASS_CODE) — VARCHAR2(50)

Common interface information (PLG_CMM_IF_INFO)

  • Unique ID of interface (IF_KEY) — VARCHAR2(50) — Primary key
  • Interface type (IF_TYPE) — VARCHAR2(50)
  • Interface start time (START_DATE) — DATE
  • Interface end time (END_DATE) — DATE
  • Interface User ID which executes (USER_ID) — VARCHAR2(50)
  • Completed or not (COMPLETE_FLAG) — VARCHAR2(12)
  • Complete type (COMPLETE_TYPE) — VARCHAR2(4)
  • Complete message (COMPLETE_MSG) — VARCHAR2(100)
  • Business department code (PLANT_CODE) — VARCHAR2(50)
  • Interface XML (INTERFACE_XML) — VARCHAR2(4000)
  • Progression status (PROGRESS_STATUS) — VARCHAR2(10)
  • Item count (ITEM_COUNT) — VARCHAR2(5)
  • Total count (TOTAL_COUNT) — VARCHAR2(5)
  • Server path of interface action (SERVER_PATH) — VARCHAR2(1000)

Common process attribute information (PLG_CMM_PROCESS_ATTR)

  • Unique ID of process attribute (PROCESS_ATTR_ID) — VARCHAR2(50) — Primary key
  • Unique ID of process (PROCESS_ID) — VARCHAR2(50) — Foreign key → Common process information.Unique ID of process
  • Order of process (PROCESS_NO) — VARCHAR2(10)
  • Division of process (APPROVAL_GUBUN) — VARCHAR2(50)
  • Authority code of approval (APPROVER_PERMISSION) — VARCHAR2(100)
  • Process number of reject (REJECT_PROCESS_NO) — VARCHAR2(10)
  • Multi approvers or not (MULTI_APPROVER_FLAG) — VARCHAR2(1)
  • Default approver ID (DEFAULT_APPROVER_ID) — VARCHAR2(100)
  • URL link (URL_LINK) — VARCHAR2(100)
  • Registration date (REG_DATE) — DATE
  • Process revision (PROCESS_REVISION) — NUMBER(10,0)
  • Process name (Korean) (DISPLAY_NAME_K) — VARCHAR2(100)
  • Process name (English) (DISPLAY_NAME_E) — VARCHAR2(100)
  • Process name (Japanese) (DISPLAY_NAME_J) — VARCHAR2(100)
  • Process name (Chinese) (DISPLAY_NAME_Z) — VARCHAR2(100)
  • Process action code (PROCESS_ACTION) — VARCHAR2(50)
  • User-edit process number (Deprecated) (SEL_MEMBER_NO) — VARCHAR2(10)
  • Authority of approval view constraint (Deprecated) (VIEW_CONSTRAINTS) — VARCHAR2(400)
  • Arbitary decision or not (ARBITARY_DECISION_FLAG) — VARCHAR2(1)

Common process information (PLG_CMM_PROCESS)

  • Unique ID of process (PROCESS_ID) — VARCHAR2(50) — Primary key
  • Parent process ID (PARENT_PROCESS_ID) — VARCHAR2(50)
  • Registration date (REG_DATE) — DATE
  • Order of process (PROCESS_ORDER) — NUMBER(10,0)
  • Process name (Korean) (PROCESS_NAME_K) — VARCHAR2(100)
  • Process name (English) (PROCESS_NAME_E) — VARCHAR2(100)
  • Process name (Japanese) (PROCESS_NAME_J) — VARCHAR2(100)
  • Process name (Chinese) (PROCESS_NAME_Z) — VARCHAR2(100)
  • Process code (PROCESS_CODE) — VARCHAR2(100)
  • Hidden or not (DELETE_FLAG) — VARCHAR2(1)
  • Process revision (PROCESS_REVISION) — NUMBER(10,0)
  • Locked or not (LOCK_FLAG) — VARCHAR2(1)
  • 프로세스 xml 다이어 그램 (PROCESS_DIAGRAM) — CLOB

Common task information (PLG_CMM_TASK)

  • Unique ID of task (TASK_ID) — VARCHAR2(50) — Foreign key → UDMS project information.Unique ID of project
  • Task number (TASK_NO) — NUMBER(10,0)
  • Task module (TASK_MODULE) — VARCHAR2(20)
  • Requester ID (REQUESTER_ID) — VARCHAR2(50)
  • Task status (TASK_STATUS) — VARCHAR2(50)
  • Finish time limit (NEEDED_BY) — DATE
  • Registration date (DATE_REGISTED) — DATE
  • Process code (PROCESS_CODE) — VARCHAR2(100)
  • Plant code (PLANT_CODE) — VARCHAR2(50)
  • File code (FILE_CODE) — VARCHAR2(50)
  • Finish date (FINISH_DATE) — DATE

Confirmed Stackup information (PLG_UDMS_STACKUP_CONFIRMED_INFO)

  • Unique ID of stackup (STACKUP_ID) — VARCHAR2(50) — Primary key
  • Unique ID of design (DESIGN_ID) — VARCHAR2(50) — Foreign key → Design information.Unique ID of design
  • PCB layer (PCB_LAYER) — VARCHAR2(50)
  • Stackup layer type (STACKUP_LAYER_TYPE) — VARCHAR2(50)
  • Artwork layer number (ARTWORK_LAYER_NO) — VARCHAR2(50)
  • Artwork layer name (ARTWORK_LAYER_NAME) — VARCHAR2(50)
  • Physical layer number (PHYSICAL_LAYER_NO) — VARCHAR2(50)
  • Conductor material (CONDUCTING_MATERIAL) — VARCHAR2(50)
  • Dielectric material (DIELECTRIC_MATERIAL) — VARCHAR2(50)
  • Thickness (THICKNESS) — VARCHAR2(50)
  • Width difference (TRACE_WIDTH_DIFFERENCE) — VARCHAR2(1)
  • Wider trace side (WIDER_TRACE_SIDE) — VARCHAR2(1)
  • Order of stackup (STACKUP_ORDER) — NUMBER(18,0)
  • Apply or not (FINISH_APPLY) — DEFAULT

Design attributes (PLG_UDMS_DESIGN_ATTR)

  • Unique ID of design (DESIGN_ID) — VARCHAR2(50) — Foreign key → Design information.Unique ID of design
  • Board revision (BOARD_REVISION) — VARCHAR2(20)
  • PBA number (PBA_NO) — VARCHAR2(50)
  • PCB number (PCB_NO) — VARCHAR2(50)
  • Registration date (DATE_REGISTED) — DATE
  • Edited BOM or not (BOM_EDIT_FLAG) — VARCHAR2(3)
  • Is EMS or not (EMS_FLAG) — VARCHAR2(2)
  • Unit number (UNIT_NO) — VARCHAR2(50)
  • Revised or not (REVISE_FLAG) — VARCHAR2(3)
  • Previous design ID (PREV_DESIGN_ID) — VARCHAR2(50)
  • code of reason for revision (REVISE_REASON_CODE) — VARCHAR2(50)
  • Comment of reason for revision (REVISE_REASON) — VARCHAR2(4000)
  • Enabled revision or not (REVISE_ENABLE_FLAG) — VARCHAR2(1)
  • View revision (VIEW_REVISION) — VARCHAR2(50)
  • From migration or not (MIGRATION_FLAG) — VARCHAR2(1)
  • Sended to legacy system or not (LEGACY_SEND_FLAG) — VARCHAR2(1)
  • Updated the last UPF or not (LAST_UPF_UPDATE_FLAG) — VARCHAR2(1)

Design information (PLG_UDMS_DESIGN_INFO)

  • Unique ID of design (DESIGN_ID) — VARCHAR2(50) — Primary key
  • Unique ID of board (BOARD_ID) — VARCHAR2(50) — Primary key
  • Unique ID of project (PROJECT_ID) — VARCHAR2(50) — Foreign key → UDMS project information.Unique ID of project
  • Unique ID of BOM (BOM_ID) — VARCHAR2(50)
  • Registration date (DATE_REGISTED) — DATE
  • Plant code (PLANT_CODE) — VARCHAR2(50)

Design inspection request information (PLG_UDMS_PERMISSION_ATTR)

  • Unique ID of design (DESIGN_ID) — VARCHAR2(50) — Foreign key → PCB Spec information.Unique ID of design
  • Unique ID of task (TASK_ID) — VARCHAR2(50) — Foreign key → Common task information.Unique ID of task
  • Unique ID of PCB spec (PCB_SPEC_ID) — VARCHAR2(50) — Foreign key → PCB Spec information.PCB spec task ID
  • Link ID (LINK_ID) — VARCHAR2(50)
  • Approval requester ID (REQUESTER_ID) — VARCHAR2(50)
  • Board code (BOARD_CODE) — VARCHAR2(50)
  • Registration date (DATE_REGISTED) — DATE
  • Project board option ID (PROJECT_BOARD_OPTION_ID) — VARCHAR2(50)
  • Is on inspection or not (NOW_TASK_FLAG) — VARCHAR2(1)

Design migration information (PLG_UDMS_DESIGN_MIGRATION_INFO)

  • Unique ID of migration (MIGRATION_ID) — VARCHAR2(50) — Foreign key → Information of design project migration.Unique ID of migration
  • Migration title (MIG_TITLE) — VARCHAR2(200)
  • Design root path (DESIGN_ROOT_PATH) — VARCHAR2(200)
  • PL UserId (USER_ID) — VARCHAR2(50)
  • Registration date (DATE_REGISTED) — DATE
  • Migration start date (MIG_START_DATE) — DATE
  • Migration end date (MIG_END_DATE) — DATE
  • Migration status (MIG_STATUS) — VARCHAR2(20)
  • Plant code (PLANT_CODE) — VARCHAR2(50)
  • Language code (LOCALE) — VARCHAR2(8)

Design option information (PLG_UDMS_DESIGN_OPTION)

  • Unique ID of design (DESIGN_ID) — VARCHAR2(50) — Foreign key → Design information.Unique ID of design
  • Unique ID of board (BOARD_ID) — VARCHAR2(50) — Foreign key → Design information.Unique ID of board
  • Option code (OPTION_CODE) — VARCHAR2(50)
  • Option value (OPTION_VALUE) — VARCHAR2(50)

Design option item (PLG_UDMS_DESIGN_OPT_ITEM)

  • Manager ID of design board option (DESIGN_BOARD_OPTION_ITEM_ID) — VARCHAR2(50) — Primary key
  • Unique ID of design (DESIGN_ID) — VARCHAR2(50) — Foreign key → Design information.Unique ID of design
  • Design board option item code (BOARD_OPTION_ITEM_CODE) — VARCHAR2(100)
  • Registration date (DATE_REGISTED) — DATE
  • Hidden or not (DELETE_FLAG) — VARCHAR2(1)
  • Is check in/out locked or not (CHECK_IN_OUT_LOCK) — VARCHAR2(1)
  • ID of project board option item (PROJECT_BOARD_OPTION_ITEM_ID) — VARCHAR2(50)
  • Is changed or not (CHANGE_FLAG) — VARCHAR2(1)

Design project board set up option (PLG_UDMS_SETUP_BRD_OPT)

  • Unique ID of board option (BOARD_OPTION_ID) — VARCHAR2(50) — Primary key
  • Process item ID (PROCESS_ITEM_ID) — VARCHAR2(50) — Foreign key → Process class management of design project.Process class item ID
  • Unique ID of board (BOARD_ID) — VARCHAR2(50) — Foreign key → Design information.Unique ID of board
  • Development type ID (CLASS_ID) — VARCHAR2(50)
  • Board code (BOARD_CODE) — VARCHAR2(100)
  • Registration date (DATE_REGISTED) — DATE
  • Is on inspection or not (PERMISSION_FLAG) — VARCHAR2(1)
  • Order of board option (BOARD_OPTION_ORDER) — NUMBER(10,0)
  • Plant code (PLANT_CODE) — VARCHAR2(50)

Design project process item attribute management (PLG_UDMS_MNG_PS_ITEM_ATTR)

  • Process class ID (PROCESS_CLASS_ID) — VARCHAR2(50) — Foreign key → Design project process item management.Unique ID of process class Item
  • Process item attribute ID (PROCESS_ITEM_ID) — VARCHAR2(50) — Foreign key → Design project process item management.Process item ID
  • Attribute name (ATTR_NAME) — VARCHAR2(100)
  • Attribute value (ATTR_VALUE) — VARCHAR2(100)

Design project process item management (PLG_UDMS_MNG_PS_ITEM)

  • Unique ID of process class Item (PROCESS_CLASS_ITEM_ID) — VARCHAR2(50) — Primary key
  • Process item ID (PROCESS_ITEM_ID) — VARCHAR2(50) — Foreign key → Process class management of design project.Process class item ID
  • Process item code (BOARD_ITEM_CODE) — VARCHAR2(100)
  • Attach mode (ATTACH_MODE) — VARCHAR2(50)
  • Needed or not (REQUIRED) — VARCHAR2(1)
  • Registration date (DATE_REGISTED) — DATE
  • Is EMS process or not (EMS_FLAG) — VARCHAR2(1)

Design stackup information (PLG_UDMS_STACKUP_DEPENDENT_DESIGN)

  • Unique ID of stackup (STACKUP_ID) — VARCHAR2(50) — Primary key
  • Unique ID of design (DESIGN_ID) — VARCHAR2(50) — Foreign key → Design information.Unique ID of design
  • Design type (DESIGN_TYPE) — VARCHAR2(50)
  • File ID (FILE_ID) — VARCHAR2(50)
  • Stackup layer type (STACKUP_LAYER_TYPE) — VARCHAR2(50)
  • Artwork layer number (ARTWORK_LAYER_NO) — VARCHAR2(50)
  • Artwork layer name (ARTWORK_LAYER_NAME) — VARCHAR2(50)
  • physical layer number (PHYSICAL_LAYER_NO) — VARCHAR2(50)
  • Conductable material (CONDUCTING_MATERIAL) — VARCHAR2(50)
  • Dielectric material (DIELECTRIC_MATERIAL) — VARCHAR2(50)
  • Thickness (THICKNESS) — VARCHAR2(50)
  • Width difference (TRACE_WIDTH_DIFFERENCE) — VARCHAR2(1)
  • Wider trace side (WIDER_TRACE_SIDE) — VARCHAR2(1)
  • Order of stack up (STACKUP_ORDER) — NUMBER(18,0)

EMS maker information (PLG_UDMS_EMS_MAKER_INFO)

  • Unique ID of EMS maker (EMS_MAKER_ID) — VARCHAR2(50) — Primary key
  • EMS maker name (EMS_MAKER_NAME) — VARCHAR2(100)
  • EMS maker manager name (EMS_MAKER_MANAGER_NAME) — VARCHAR2(50)
  • EMS maker phone number (EMS_MAKER_TEL) — VARCHAR2(50)
  • Hidden or not (DELETE_FLAG) — VARCHAR2(1)
  • Registration date (REG_DATE) — DATE

External program excution information of design process (PLG_UDMS_MNG_PS_ITEM_PROG)

  • Process class item ID (PROCESS_CLASS_ITEM_ID) — VARCHAR2(50) — Foreign key → Design project process item management.Unique ID of process class Item
  • Process item ID (PROCESS_ITEM_ID) — VARCHAR2(50) — Foreign key → Design project process item management.Process item ID
  • External program excution ID (OUTER_PROGRAM_ID) — VARCHAR2(50 CHAR) — Foreign key → External program management.External program ID
  • External program excution type (EXTERNAL_PROG_TYPE) — VARCHAR2(50)
  • Registration date (DATE_REGISTED) — DATE

External program management (PLG_CMM_OUTER_PRG_MNG)

  • External program ID (OUTER_PROGRAM_ID) — VARCHAR2(50 CHAR) — Primary key
  • External program type (OUTER_PROGRAM_TYPE) — VARCHAR2(50 CHAR)
  • External program name (Korean) (OUTER_PROGRAM_NAME_K) — VARCHAR2(100 CHAR)
  • External program name (English) (OUTER_PROGRAM_NAME_E) — VARCHAR2(100 CHAR)
  • External program name (japanese) (OUTER_PROGRAM_NAME_J) — VARCHAR2(100 CHAR)
  • External program name (Chinese) (OUTER_PROGRAM_NAME_Z) — VARCHAR2(100 CHAR)
  • External program command (OUTER_PROGRAM_COMMAND) — VARCHAR2(300 CHAR)
  • External program description (OUTER_PROGRAM_DESCRIPTION) — VARCHAR2(4000 CHAR)
  • Display order of external program (OUTER_PROGRAM_ORDER) — NUMBER(10,0)
  • Hidden or not (DELETE_FLAG) — VARCHAR2(1 CHAR)
  • Registration date (REG_DATE) — DATE
  • External program code (OUTER_PROGRAM_CODE) — VARCHAR2(50 CHAR)
  • Locked or not (LOCK_FLAG) — VARCHAR2(1 CHAR)

File attachment information (PLG_CMM_TASK_FILE_ATTACH)

  • Unique ID of file (FILE_ID) — VARCHAR2(50) — Primary key
  • Attached file group ID (FILE_GROUP_ID) — VARCHAR2(50) — Primary key
  • Unique ID of task (TASK_ID) — VARCHAR2(50) — Foreign key → Common task information.Unique ID of task
  • File path (PATH) — VARCHAR2(200)
  • File name (FILE_NAME) — VARCHAR2(200)
  • Uploader (UPLOADER) — VARCHAR2(50)
  • Registration date (DATE_REGISTED) — DATE
  • File code (FILE_CODE) — VARCHAR2(100)
  • Hidden or not (DELETE_FLAG) — VARCHAR2(1)

File task link (PLG_UDMS_FILE_TASK_LINK)

  • Unique ID of file (FILE_ID) — VARCHAR2(50) — Foreign key → File attachment information.Unique ID of file
  • Unique ID of design (DESIGN_ID) — VARCHAR2(50) — Foreign key → Design information.Unique ID of design
  • Unique ID of task (TASK_ID) — VARCHAR2(50) — Foreign key → File attachment information.Unique ID of task
  • Registration date (DATE_REGISTED) — DATE
  • Attach version (ATTACH_VERSION) — NUMBER(10,0)

File view information (PLG_CMM_TASK_FILE_TASK_VIEW)

  • Unique ID of file (FILE_ID) — VARCHAR2(50) — Foreign key → File attachment information.Unique ID of file
  • Unique ID of task (TASK_ID) — VARCHAR2(50) — Foreign key → File attachment information.Unique ID of task
  • Registration date (REG_DATE) — DATE

History of common task approval (PLG_CMM_TASK_APPROVAL_HISTORY)

  • Unique ID of task approval (TASK_APPROVAL_ID) — VARCHAR2(50) — Foreign key → Common approval information.Unique ID of task approval
  • Unique ID of process attrivute (PROCESS_ATTR_ID) — VARCHAR2(50) — Foreign key → Common approval information.Unique ID of process attribute
  • Unique ID of task (TASK_ID) — VARCHAR2(50) — Foreign key → Common approval information.Unique ID of task
  • Approver ID (APPROVAL_USER_ID) — VARCHAR2(50)
  • Order of approval (APPROVAL_ORDER) — NUMBER(10,0)
  • Is on approval or not (TARGET_FLAG) — VARCHAR2(50)
  • Finished or not (FINISH_FLAG) — VARCHAR2(50)
  • Approval comment (APPROVAL_COMMENT) — VARCHAR2(4000)
  • Approval date (APPROVAL_DATE) — DATE
  • Registration date (REG_DATE) — DATE
  • Division of approval (APPROVAL_GUBUN) — VARCHAR2(50)
  • Approval status (APPROVAL_STATUS) — VARCHAR2(20)
  • Surrogated (SURROGATE) — VARCHAR2(1)

History of design project rollback (PLG_UDMS_REVERT_HISTORY)

  • Unique ID of design (DESIGN_ID) — VARCHAR2(50) — Foreign key → Information of design project check In/out attribute.Unique ID of design
  • Check in/out mode (CHECK_OUT_MODE) — VARCHAR2(50)
  • Check in/out date (CHECK_OUT_DATE) — DATE
  • Date of rollback (REVERT_DATE) — DATE
  • User ID which reverted (REVERT_USER_ID) — VARCHAR2(50)

History of file download (PLG_CMM_TASK_FILE_DOWNLOAD)

  • Unique ID of file (FILE_ID) — VARCHAR2(50) — Foreign key → File attachment information.Unique ID of file
  • Unique ID of project (PROJECT_ID) — VARCHAR2(50) — Foreign key → File attachment information.Unique ID of task
  • User ID which downloaded (USER_ID) — VARCHAR2(50)
  • User IP which downloaded (USER_IP) — VARCHAR2(20)
  • Registration date (DATE_REGISTED) — DATE

History of file link (PLG_CMM_FILE_LINK_HISTORY)

  • Unique ID of link (LINK_ID) — VARCHAR2(50) — Primary key
  • Unique ID of file (FILE_ID2) — VARCHAR2(50) — Foreign key → File task link.Unique ID of file
  • Unique ID of task (TASK_ID) — VARCHAR2(50) — Foreign key → File task link.Unique ID of task
  • File code (FILE_CODE) — VARCHAR2(50)
  • SRC file ID (SRC_FILE_ID) — VARCHAR2(50)
  • SRC file code (SRC_FILE_CODE) — VARCHAR2(50)
  • Check out date (CHECK_OUT_DATE) — DATE
  • Check in date (CHECK_IN_DATE) — DATE
  • Spec information (SPEC1) — VARCHAR2(1000)
  • User ID (USER_ID) — VARCHAR2(50)

Information of board option item (PLG_UDMS_SETUP_BRD_OPT_ITEM)

  • Unique ID of board option (BOARD_OPTION_ID) — VARCHAR2(50) — Foreign key → Design project board set up option.Unique ID of board option
  • Process item ID (PROCESS_ITEM_ID) — VARCHAR2(50) — Foreign key → Design project board set up option.Process item ID
  • Board option item ID (BOARD_OPTION_ITEM_ID) — VARCHAR2(50)
  • Board option item code (BOARD_OPTION_ITEM_CODE) — VARCHAR2(100)
  • Registration date (DATE_REGISTED) — DATE
  • Is revised or not (REVISE_FLAG) — VARCHAR2(1)

Information of comment about attached file (PLG_CMM_TASK_FILE_COMMENT)

  • Unique ID of comment (COMMENT_ID) — VARCHAR2(50) — Primary key
  • Attached file group ID (FILE_GROUP_ID) — VARCHAR2(50) — Foreign key → File attachment information.Attached file group ID
  • Comment writer ID (COMMENT_USER_ID) — VARCHAR2(50)
  • Attached comment (ATTACH_COMMENT) — VARCHAR2(4000)
  • Registration date (DATE_REGISTED) — DATE
  • File revision (FILE_REVISION) — VARCHAR2(8)
  • File version (FILE_VERSION) — NUMBER(10,0)
  • Confirmed or not (CONFIRMATION_FLAG) — VARCHAR2(1)
  • Comment status (STATUS_COMMENT) — VARCHAR2(50)
  • File view revision (FILE_VIEW_REVISION) — VARCHAR2(20)
  • File view version (FILE_VIEW_VERSION) — VARCHAR2(20)

Information of design project check In/out attribute (PLG_UDMS_DESIGN_CHECK_ATTR)

  • Unique ID of design (DESIGN_ID) — VARCHAR2(50) — Foreign key → Design information.Unique ID of design
  • Circuit check in/out mode (CIRCUIT_CHECK_IN_OUT_FLAG) — VARCHAR2(8)
  • Circuit design path (CIRCUIT_DESIGN_PATH) — VARCHAR2(1000)
  • User ID of circuit check in/out (CIRCUIT_CHECK_OUT_USER_ID) — VARCHAR2(50)
  • Circuit check in/out date (CIRCUIT_CHECK_OUT_DATE) — DATE
  • PCB check in/out mode (PCB_CHECK_IN_OUT_FLAG) — VARCHAR2(8)
  • PCB design path (PCB_DESIGN_PATH) — VARCHAR2(1000)
  • PCB check in/out user ID (PCB_CHECK_OUT_USER_ID) — VARCHAR2(50)
  • PCB check in/out date (PCB_CHECK_OUT_DATE) — DATE
  • BOM check in/out mode (BOM_CHECK_IN_OUT_FLAG) — VARCHAR2(8)
  • Is variant design or not (VARIANT_IN_DESIGN_FLAG) — VARCHAR2(1)
  • Circuit ECAD tool code (CIRCUIT_CAD_TOOL_CODE) — VARCHAR2(50)
  • PCB ECAD tool code (PCB_CAD_TOOL_CODE) — VARCHAR2(50)
  • Reverted circuit or not (CIRCUIT_REVERT_FLAG) — VARCHAR2(1)
  • Reverted PCB or not (PCB_REVERT_FLAG) — VARCHAR2(1)
  • Circuit ECAD tool version code (CIRCUIT_CAD_TOOL_VERSION_CODE) — VARCHAR2(50)
  • PCB ECAD tool version code (PCB_CAD_TOOL_VERSION_CODE) — VARCHAR2(50)
  • Confirmed BOM or not (BOM_FINISH_FLAG) — VARCHAR2(1)

Information of design project migration (PLG_UDMS_DESIGN_MIGRATION_PRJ)

  • Unique ID of migration (MIGRATION_ID) — VARCHAR2(50) — Primary key
  • Unique ID of project (PROJECT_ID) — VARCHAR2(50) — Foreign key → UDMS project information.Unique ID of project
  • Project name (PROJECT_NAME) — VARCHAR2(50)
  • project group name (PRODUCT_GROUP_NAME) — VARCHAR2(200)
  • Product name (PRODUCT_NAME) — VARCHAR2(200)
  • Progress step name (PROGRESS_STEP_NAME) — VARCHAR2(200)
  • Model name (PCB_MODEL_NAME) — VARCHAR2(200)
  • Board Type (BOARD_TYPE) — VARCHAR2(200)
  • Project start date (START_DATE) — DATE
  • Project end date (END_DATE) — DATE
  • Migration status (MIG_STATUS) — VARCHAR2(20)
  • Order of Migration (MIG_ORDER) — NUMBER(10,0)
  • Completed or not (COMPLETE_FLAG) — VARCHAR2(4)

Information of external program excution of design project (PLG_UDMS_PROJECT_BRD_OPT_PROG)

  • Unique ID of board option (BOARD_OPTION_ID) — VARCHAR2(50) — Foreign key → Project board option information.Unique ID of Porject board option
  • External program ID (OUTER_PROGRAM_ID) — VARCHAR2(50 CHAR) — Foreign key → External program management.External program ID
  • External program type (EXTERNAL_PROG_TYPE) — VARCHAR2(50)
  • Registration date (DATE_REGISTED) — DATE

Information of process class attribute (PLG_UDMS_MNG_PS_CLASS_ATTR)

  • Unique ID of process class (PROCESS_CLASS_ID) — VARCHAR2(50) — Foreign key → Process class management of design project.Process class item ID
  • Attribute name (ATTR_NAME) — VARCHAR2(50)
  • Attribute value (ATTR_VALUE) — VARCHAR2(50)

Information of project board option item (프로젝트 보드 프로세스 항목 정보)

  • Unique ID of project board option item (BOARD_OPTION_ITEM_ID) — VARCHAR2(50) — Primary key
  • Unique ID of project board option (BOARD_OPTION_ID) — VARCHAR2(50) — Foreign key → Project board option information.Unique ID of Porject board option
  • Process class item ID (PROCESS_CLASS_ITEM_ID) — VARCHAR2(50) — Foreign key → Process class management of design project.Process class item ID
  • Project board option item code (BOARD_OPTION_ITEM_CODE) — VARCHAR2(100)
  • Registration code (DATE_REGISTED) — DATE
  • Is revised or not (REVISE_FLAG) — VARCHAR2(1)
  • Hidden or not (DELETE_FLAG) — VARCHAR2(1)
  • Attach mode (ATTACH_MODE) — VARCHAR2(50)

Information of remark issue (PLG_UDMS_REDMARK_ISSUE)

  • Unique ID of remark (REDMARK_ID) — VARCHAR2(50) — Primary key
  • Unique ID of design (DESIGN_ID) — VARCHAR2(50) — Foreign key → Remark information.Unique ID of design
  • Remark class (REDMARK_CLASS) — VARCHAR2(50)
  • Remark step (REDMARK_STEP) — VARCHAR2(50)
  • Remark layer (REDMARK_LAYER) — VARCHAR2(50)
  • Remark title (REDMARK_TITLE) — VARCHAR2(100)
  • Remark content (REDMARK_CONTENT) — VARCHAR2(300)
  • Remark writer (REDMARK_WRITER) — VARCHAR2(50)
  • Date of remark written (REDMARK_WRITE_DATE) — VARCHAR2(200)
  • The first confirmer of remark (REDMARK_FIRST_CONFIRMER) — VARCHAR2(50)
  • The first date of checking remark (REDMARK_FIRST_CONFIRM_DATE) — VARCHAR2(200)
  • The seoncd confirmer of remark (REDMARK_SECOND_CONFIRMER) — VARCHAR2(50)
  • The second date of checking remark (REDMARK_SECOND_CONFIRM_DATE) — VARCHAR2(200)
  • Image path of remark (REDMARK_IMAGE_PATH) — VARCHAR2(100)
  • Image path of remark area (REDMARK_AREA_IMAGE_PATH) — VARCHAR2(100)
  • Registration date (REG_DATE) — DATE

Information of revert permission (PLG_UDMS_REVERT_PERMISSION_TASK)

  • Unique ID of board option (BOARD_OPTION_ID) — VARCHAR2(50) — Foreign key → Project board manager.Unique ID of project board option
  • Unique ID of design (DESIGN_ID) — VARCHAR2(50) — Foreign key → Design information.Unique ID of design
  • Task ID (TASK_ID) — VARCHAR2(50)

Information of setting up legacy (PLG_UDMS_SETUP_LEGACY_INFO)

  • Unique Id of process (PROCESS_ID) — VARCHAR2(50) — Primary key
  • Unique ID of class (CLASS_ID) — VARCHAR2(50) — Foreign key → Process class management of design project.Process class item ID
  • Process group ID (PROCESS_GROUP_ID) — VARCHAR2(50)
  • Interfaced PLM or not (LEGACY_IF_PLM) — VARCHAR2(1)
  • Interfaced EO or not (LEGACY_IF_EO) — VARCHAR2(1)
  • Registration date (DATE_REGISTED) — DATE

Interface attribute information (PLG_CMM_IF_ATTR)

  • Unique ID of interface (IF_KEY) — VARCHAR2(50) — Foreign key → Common interface information.Unique ID of interface
  • Attribute name (ATTR_NAME) — VARCHAR2(100)
  • Attribute value (ATTR_VALUE) — VARCHAR2(200)

Manager hisory of design option (PLG_UDMS_DESIGN_OPT_MEMBER_HISTORY)

  • Unique ID of history (HISTORY_ID) — VARCHAR2(50) — Primary key
  • Unique ID of design (DESIGN_ID) — VARCHAR2(50) — Foreign key → Design information.Unique ID of design
  • Process class code (PROCESS_CLASS_CODE) — VARCHAR2(70)
  • Process item code (PROCESS_ITEM_CODE) — VARCHAR2(70)
  • Division of manager (MANAGER_GUBUN) — VARCHAR2(50)
  • Manager ID (USER_ID) — VARCHAR2(50)
  • Registration date (DATE_REGISTED) — DATE
  • Order of process item (PROCESS_ITEM_ORDER) — VARCHAR2(70)

Manager information of design board option (PLG_UDMS_DESIGN_OPT_MEMBER)

  • Manager ID of design board option (DESIGN_BOARD_OPTION_MEMBER_ID) — VARCHAR2(50) — Primary key
  • Unique ID of design board option item (DESIGN_BOARD_OPTION_ITEM_ID) — VARCHAR2(50) — Foreign key → Design option item.Manager ID of design board option
  • Unique ID of design (DESIGN_ID) — VARCHAR2(50) — Foreign key → Design option item.Unique ID of design
  • Division of manager (MANAGER_GUBUN) — VARCHAR2(50)
  • User ID (USER_ID) — VARCHAR2(50)
  • Registration date (DATE_REGISTED) — DATE

Manager set up information of design project (PLG_UDMS_SETUP_MANAGER)

  • Unique ID of board option (BOARD_OPTION_ID) — VARCHAR2(50) — Foreign key → Design project board set up option.Unique ID of board option
  • DIvision of manager (MANAGER_GUBUN) — VARCHAR2(50)
  • User ID (USER_ID) — VARCHAR2(50)
  • Registration date (DATE_REGISTED) — DATE

PCB Spec information (PLG_UDMS_PCB_SPEC)

  • PCB spec task ID (TASK_ID) — VARCHAR2(50) — Primary key
  • Unique ID of design (DESIGN_ID) — VARCHAR2(50) — Foreign key → Design information.Unique ID of design
  • Division of task (TASK_GUBUN) — VARCHAR2(50)
  • Revision (REVISION) — VARCHAR2(20)
  • Used unit or not (UNIT_FLAG) — VARCHAR2(1)
  • PCB surface material (PCB_SURFACE_MATERIAL) — VARCHAR2(50)
  • PCB thermal transition (PCB_TG) — VARCHAR2(50)
  • PCB thickness (PCB_THICKNESS) — VARCHAR2(50)
  • PCB thickness (OZ) (PCB_THICKNESS_OZ) — VARCHAR2(50)
  • PCB layer (PCB_LAYER) — VARCHAR2(50)
  • PCB plating material (PCB_PLATING) — VARCHAR2(50)
  • Special spec of PCB (PCB_SPECIAL_SPEC) — VARCHAR2(50)
  • PCB size (PCB_SIZE) — VARCHAR2(50)
  • PCB array count (PCB_ARRAY_COUNT) — VARCHAR2(20)
  • PCB array size (PCB_ARRAY_SIZE) — VARCHAR2(50)
  • Circuit manager ID (CIRCUIT_MANAGER_ID) — VARCHAR2(50)
  • PCB manager ID (PCB_MANAGER_ID) — VARCHAR2(50)
  • Business department code (PLANT_CODE) — VARCHAR2(50)
  • Link ID (LINK_ID) — VARCHAR2(50)
  • Is present spec or not (NOW_TASK_FLAG) — VARCHAR2(1)
  • Registration date (DATE_REGISTED) — DATE
  • Horizontal size of PCB (PCB_HORIZENTAL_SIZE) — VARCHAR2(50)
  • Vertical size of PCB (PCB_VERTICAL_SIZE) — VARCHAR2(50)

Process class management of design project (PLG_UDMS_MNG_PS_CLASS)

  • Process class item ID (PROCESS_ITEM_ID) — VARCHAR2(50) — Primary key
  • Unique ID of project (PROJECT_ID) — VARCHAR2(50) — Foreign key → UDMS project information.Unique ID of project
  • Process item name (Korean) (PROCESS_ITEM_NAME_K) — VARCHAR2(100)
  • Process item name (English) (PROCESS_ITEM_NAME_E) — VARCHAR2(100)
  • Process item name (Japanese (PROCESS_ITEM_NAME_J) — VARCHAR2(100)
  • Process item name (Chinese) (PROCESS_ITEM_NAME_Z) — VARCHAR2(100)
  • Board class code (BOARD_CLASS_CODE) — VARCHAR2(100)
  • Process class revision (REVISION) — NUMBER(10,0)
  • Registration date (DATE_REGISTED) — DATE
  • Process group ID (PROCESS_GROUP_ID) — VARCHAR2(50)
  • Order of process item (PROCESS_ITEM_ORDER) — NUMBER(10,0)
  • Is EMS process or not (EMS_FLAG) — VARCHAR2(1)
  • Plant code (PLANT_CODE) — VARCHAR2(50)
  • Hidden or not (DELETE_FLAG) — VARCHAR2(1)
  • Locked or not (LOCK_FLAG) — VARCHAR2(1)

Process inspection condition management (PLG_UDMS_MNG_PS_INSPECTION_CONDITION)

  • Process item attribute ID (PROCESS_ITEM_ID) — VARCHAR2(50) — Foreign key → Design project process item management.Process item ID
  • Process class ID (PROCESS_CLASS_ID) — VARCHAR2(50)
  • Inspection condition (INSPECTION_CONDITION) — VARCHAR2(50)
  • Process code (PROCESS_CODE) — VARCHAR2(50)

Process mail attribute (PLG_CMM_PROCESS_ATTR_MAIL)

  • Unique ID of process attribute (PROCESS_ATTR_ID) — VARCHAR2(50) — Foreign key → Common process attribute information.Unique ID of process attribute
  • Mail title (MAIL_TITLE) — VARCHAR2(100)
  • Mail content (MAIL_CONTENTS) — VARCHAR2(4000)
  • Registration date (REG_DATE) — DATE
  • Process revision (PROCESS_REVISION) — VARCHAR2(2)

Project board manager (PLG_UDMS_PROJECT_BRD_MANAGER)

  • Unique ID of project board option (BOARD_OPTION_ID) — VARCHAR2(50) — Foreign key → Project board option information.Unique ID of Porject board option
  • Division of manager (MANAGER_GUBUN) — VARCHAR2(50)
  • User ID (USER_ID) — VARCHAR2(50)
  • Registration date (DATE_REGISTED) — DATE

Project board option information (PLG_UDMS_PROJECT_BRD_OPT)

  • Unique ID of Porject board option (BOARD_OPTION_ID) — VARCHAR2(50) — Primary key
  • Unique ID of board (BOARD_ID) — VARCHAR2(50) — Foreign key → Design information.Unique ID of board
  • Unique ID of project (PROJECT_ID) — VARCHAR2(50) — Foreign key → Design information.Unique ID of project
  • Board code (BOARD_CODE) — VARCHAR2(100)
  • Registration date (DATE_REGISTED) — DATE
  • Schedule start date (SCHEDULE_START_DATE) — DATE
  • Schedule end date (SCHEDULE_END_DATE) — DATE
  • Is on inspection or not (PERMISSION_FLAG) — VARCHAR2(1)
  • Process item ID (PROCESS_ITEM_ID) — VARCHAR2(50)
  • Order of board option (BOARD_OPTION_ORDER) — NUMBER(10,0)

Project reference information (PLG_UDMS_PROJECT_REF_LINK_INFO)

  • Unique ID of project (PROJECT_ID) — VARCHAR2(50) — Foreign key → UDMS project information.Unique ID of project
  • Link type (LINK_TYPE) — VARCHAR2(100)
  • Unique ID of SRC file (SRC_ID) — VARCHAR2(50)
  • Unique ID of designated file (TARGET_ID) — VARCHAR2(50)
  • Registration date (DATE_REGISTED) — DATE

Remark attribute information (PLG_UDMS_REDMARK_ATTR)

  • Project name (PROJECT_NAME) — VARCHAR2(50)
  • Use or not (USE_FLAG) — VARCHAR2(1)
  • Remark writer name (USER_NAME) — VARCHAR2(100)

Remark comment information (PLG_UDMS_REDMARK_ISSUE_REPLY)

  • Unique ID of red remark (REDMARK_ID) — VARCHAR2(50) — Primary key
  • Unique ID of parent remark (PARENT_REDMARK_ID) — VARCHAR2(50) — Foreign key → Information of remark issue.Unique ID of remark
  • Remark title (REDMARK_TITLE) — VARCHAR2(100)
  • Remark content (REDMARK_CONTENT) — VARCHAR2(300)
  • Remark writer (REDMARK_WRITER) — VARCHAR2(50)
  • Date of remark written (REDMARK_WRITE_DATE) — DATE
  • Remark confirmer (REDMARK_CONFIRMER) — VARCHAR2(50)
  • Remark confirm date (REDMARK_CONFIRM_DATE) — DATE
  • Image file path of remark (REDMARK_IMAGE_PATH) — VARCHAR2(100)
  • Image file path of remark area (REDMARK_AREA_IMAGE_PATH) — VARCHAR2(100)

Remark information (PLG_UDMS_REMARK)

  • Unique ID of design board option item (DESIGN_BOARD_OPTION_ITEM_ID) — VARCHAR2(50) — Foreign key → Design option item.Manager ID of design board option
  • Unique ID of design (DESIGN_ID) — VARCHAR2(50) — Foreign key → Design option item.Unique ID of design
  • Design board item code (BOARD_OPTION_ITEM_CODE) — VARCHAR2(50)
  • Remark content (REMARK) — VARCHAR2(200)
  • Hidden or not (DELETE_FLAG) — VARCHAR2(1)
  • Registration date (DATE_REGISTED) — DATE

Stack up template information (PLG_UDMS_STACKUP_TEMPLATE)

  • Unique ID of template (TEMPLATE_ID) — VARCHAR2(50) — Primary key
  • Parent template code (TEMPLATE_PARENT_CODE) — VARCHAR2(50)
  • Template name (TEMPLATE_NAME) — VARCHAR2(100)
  • Template creator ID (REGISTER_ID) — VARCHAR2(50)
  • Plant code (PLANT_CODE) — VARCHAR2(50)
  • Hidden or not (DELETE_FLAG) — VARCHAR2(1)
  • Registration date (REG_DATE) — DATE

Stack up template keyword information (PLG_UDMS_STACKUP_TEMPLATE_KEYWORD)

  • Unique ID of template (TEMPLATE_ID) — VARCHAR2(50) — Foreign key → Stack up template information.Unique ID of template
  • Search keyword (SEARCH_KEYWORD) — VARCHAR2(50)

Stack up template layer information (PLG_UDMS_STACKUP_TEMPLATE_LAYERS)

  • Unique ID of stack up (STACKUP_ID) — VARCHAR2(50) — Primary key
  • Unique ID of template (TEMPLATE_ID) — VARCHAR2(50) — Foreign key → Stack up template information.Unique ID of template
  • Stackup layer type (STACKUP_LAYER_TYPE) — VARCHAR2(50)
  • Artwork layer number (ARTWORK_LAYER_NO) — VARCHAR2(50)
  • Artwork layer name (ARTWORK_LAYER_NAME) — VARCHAR2(100)
  • Physical layer number (PHYSICAL_LAYER_NO) — VARCHAR2(50)
  • Conductable material (CONDUCTING_MATERIAL) — VARCHAR2(50)
  • Dielectric material (DIELECTRIC_MATERIAL) — VARCHAR2(50)
  • Thickness (THICKNESS) — VARCHAR2(50)
  • Width difference (TRACE_WIDTH_DIFFERENCE) — VARCHAR2(1)
  • Wider trace side (WIDER_TRACE_SIDE) — VARCHAR2(1)
  • Order of stack up (STACKUP_ORDER) — NUMBER(18,0)

UDMS project information (PLG_UDMS_PROJECT)

  • Unique ID of project (PROJECT_ID) — VARCHAR2(50) — Primary key
  • Product group ID (PRODUCT_GROUP_ID) — VARCHAR2(50) — Primary key
  • Product ID (PRODUCT_ID) — VARCHAR2(50) — Foreign key → Common class management.Unique ID of class
  • Project number (PROJECT_NO) — VARCHAR2(50)
  • Temporary project number (TEMP_PROJECT_NO) — VARCHAR2(50)
  • Project name (PROJECT_NAME) — VARCHAR2(100)
  • Date of project start plan (PLAN_START_DATE) — DATE
  • Date of project end plan (PLAN_END_DATE) — DATE
  • Progress step code (PROGRESS_STEP_CODE) — VARCHAR2(100)
  • Develop type code (DEV_TYPE_CODE) — VARCHAR2(100)
  • Organization to order (ORDER_ORG) — VARCHAR2(100)
  • Organization to produce (PRODUCE_ORG) — VARCHAR2(100)
  • PL user ID (PROJECT_LEADER_ID) — VARCHAR2(50)
  • PL user name (PROJECT_LEADER_NAME) — VARCHAR2(50)
  • Registration date (DATE_REGISTED) — DATE
  • Plant code (PLANT_CODE) — VARCHAR2(50)
  • Attached file code (FILE_CODE) — VARCHAR2(50)
  • Project status (STATUS) — VARCHAR2(50)
  • Project group (PROJECT_GROUP) — VARCHAR2(50)
  • Is board linked or not (NOW_BOARD_LINK_FLAG) — VARCHAR2(1)
  • PCB model name (PCB_MODEL_NAME) — VARCHAR2(100)
  • Is EMS or not (EMS_FLAG) — VARCHAR2(1)
  • Is temporary or not (TEMP_FLAG) — VARCHAR2(1)
  • Division of project (PROJECT_GUBUN) — VARCHAR2(100)
  • Board type (BOARD_TYPE) — VARCHAR2(100)
  • Reference project ID (REF_PROJECT_ID) — VARCHAR2(50)
  • Is template loaded or not (TEMPLEATE_LOAD) — VARCHAR2(1)
  • Is variant seperated or not (VARIANT_SEPERATE) — VARCHAR2(1)
  • Is seperated project or not (IS_FIRST) — VARCHAR2(1)
  • Design project set ID (SET_ID) — VARCHAR2(50)
  • Product ID (PRODUCT_ID2) — VARCHAR2(50)
  • Linked design ID (LINK_DESIGN_ID) — VARCHAR2(50)
  • Is PLM sended or not (LEGACY_IF_PLM) — VARCHAR2(1)
  • is EO sended or not (LEGACY_IF_EO) — VARCHAR2(1)
  • From migration or not (MIGRATION_FLAG) — VARCHAR2(1)
  • Variant Spec template ID (VARIANT_SPEC_TEMPLATE) — VARCHAR2(50)
  • Is stackup set or not (STACKUP_SETTING_FLAG) — VARCHAR2(1)
  • EMS maker ID (EMS_MAKER_ID) — VARCHAR2(50) — Foreign key → EMS maker information.Unique ID of EMS maker

Verification server information (PLG_CMM_VERIFICATION_SERVER)

  • Unique ID of verification server (SERVER_ID) — VARCHAR2(50) — Primary key
  • Server alias (SERVER_ALIAS) — VARCHAR2(100)
  • Server path of PollEx service (SERVER_DAEMON_PATH) — VARCHAR2(2000)
  • Business department code (PLANT_CODE) — VARCHAR2(50)
  • Hidden or not (DELETE_FLAG) — VARCHAR2(50)
  • Registration date (REG_DATE) — DATE

business department information of process (PLG_CMM_PROCESS_PLANT)

  • Unique ID of process (PROCESS_ID) — VARCHAR2(50) — Foreign key → Common process information.Unique ID of process
  • Business department code (PLANT_CODE) — VARCHAR2(50)
  • Registration date (DATE_REGISTED) — DATE