P&ID
Tables (6)
P&ID (T_Config)
- Division (Key) — varchar — Primary key — NOT NULL
- Name (Field) — varchar — Primary key
- Value (Field2) — varchar
- SEQ (Field3) — varchar
P&ID (T_Document_Info)
- DOC_CODE (Key) — varchar — Primary key — NOT NULL
- EQ_ID (Field) — varchar — Primary key
- DOC_TYPE (Field2) — varchar
- DOC_SEQ (Field3) — varchar
- DOC_STATUS (Field4) — int
- EDITED_DATE (Field5) — DATE
P&ID (T_EQUIPMET_INFO)
- EQ_ID (Field) — varchar — Primary key
- SPECIFICATION_PATHNAME (Key) — varchar — NOT NULL
- COLLECT_RESULT (Field2) — varchar
- TEMPLATE_REQUEST (Field3) — varchar
- CREATE_PNID_RESULT (Field4) — varchar
- TEMPLATE_REQUEST_DATE (Field5) — varchar
- CREATE_PNID_DATE (Field6) — DATE
P&ID (T_HOOKUP_INFO)
- AREA1 (Key) — VARCHAR — Primary key — NOT NULL
- AREA2 (Field) — VARCHAR — Primary key
- EQ_ID (Field2) — VARCHAR — Primary key
- COLLECT_DATE (Field3) — VARCHAR — Primary key
P&ID (T_ITEM_INFO)
- EQ_ID (Key) — VARCHAR — Primary key — NOT NULL
- ITEM_NO (Field) — VARCHAR — Primary key
- FAB (Field2) — VARCHAR
- DIVISION (Field3) — VARCHAR
- MODULE (Field4) — VARCHAR
- UTILITY (Field5) — VARCHAR
- ITEM_SIZE (Field6) — VARCHAR
- MATERIAL (Field7) — VARCHAR
- CONNECTION_TYPE (Field8) — VARCHAR
- GIB_ENDCAP (Field9) — VARCHAR
- GIB_V (Field10) — VARCHAR
- GIB_R (Field11) — VARCHAR
- GIB_F (Field12) — VARCHAR
- RATE_FLOW_MIN (Field13) — VARCHAR
- RATE_FLOW_MAX (Field14) — VARCHAR
- PRESSURE_MIN (Field15) — VARCHAR
- PRESSURE_MAX (Field16) — VARCHAR
- EQ_CONNECT_POINT (Field17) — VARCHAR
- EXHAUST_DRAIN_TRAP (Field18) — VARCHAR
- FURCATION (Field19) — VARCHAR
- ITEM_TYPE (Field20) — VARCHAR
- TAG (Field21) — VARCHAR
- CREATE_DATE (Field22) — DATE
- LINE_NO (Field23) — VARCHAR
- DOC_CODE (Field24) — VARCHAR
- HANDLE (Field25) — VARCHAR
- DOC_SEQ (Field26) — VARCHAR
P&ID (T_OPC_INFO)
- DOC_CODE (Key) — varchar — Primary key — NOT NULL
- EQ_ID (Field) — varchar — Primary key
- DOC_TYPE (Field2) — varchar
- DOC_SEQ (Field3) — varchar
- DOC_STATUS (Field4) — int
- EDITED_DATE (Field5) — DATE