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