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