Structure of database tables
The P&ID database includes the following fixed database tables, with some fixed database fields.
ARMATURES
The main table of ARMATURES. It can have as many sub-tables as needed.
Special columns in ARMATURES table are "Spec" and "InsulationSpec". If these are added and the pipeline has more than one specification as optional, the options can be selected for the part itself in the database editor.
Insulation specification can be set as required for the pipeline, and then all armatures inherit the specification automatically. If insulation is optional, it can be set for each pipe run and valve separately.
DUCTS
The main table of DUCTS.
|
Status |
Indicates whether the record is currently being edited. |
|
PdObjectId |
Unique object ID (OID). |
|
PosId |
PosId given by the user. It must be unique or empty. |
|
Revision |
Internal revision ID. |
|
TypeTbl |
The name of the subtype (sub-table). |
|
Ductline |
The name of the ductline. |
|
PdDuctlineOid |
The OID of the ductline. |
|
MenuItmData |
The prefix for the position ID and the lookup key for the COMPLOOKUP table. |
|
Description |
The description of the ductline. Can be empty. This field is used in the integration to Plant Modeller and must exist. |
|
DmPartCode |
The OID of the COS object used in Plant Modeller. |
|
PosIdNull |
If PosId is a null string, this is not zero. The unique PosId is a combination of PosId, Status, and PosIdNull fields. |
EQUIPMENTS
The main table of EQUIPMENTS. It can have as many sub-tables as needed.
|
PosId |
PosId given by the user. It must be unique or empty. |
|
Status |
Indicates whether the record is currently being edited. |
|
Revision |
Internal revision ID. |
|
TypeTbl |
The name of the subtype (sub-table, like VESSELS). |
|
System |
The name of the assigned system. |
|
MenuItmData |
The prefix for the position ID and the lookup key for the COMPLOOKUP table. |
|
Description |
The description of the equipment. Can be empty. This field is used in the integration to Plant Modeller and must exist. |
|
model_status |
|
|
model_not_set |
If anything else than 0, the object is not in the model. |
|
DmPartCode |
The OID of the COS object used in Plant Modeller. |
|
PdObjectId |
Unique object ID (OID). |
|
PosIdNull |
If PosId is a null string, this is not zero. The unique PosId is a combination of PosId, Status, and PosIdNull fields. |
INSTRUMENTS
The main table of INSTRUMENTS. It can have as many sub-tables as needed.
|
PosId |
PosId given by the user. It must be unique among all instrument position IDs or empty. |
|
Status |
Indicates whether the record is currently being edited. |
|
Revision |
Internal revision ID. |
|
TypeTbl |
The name of the subtype (sub-table, like VESSELS). |
|
Tag |
The name of the instrument tag to which the instrument belongs. |
|
MenuItmData |
Combination of attributes defined for the Diagram Object Template and the lookup key for the COMPLOOKUP table. |
|
Location |
The location of the instrument: local, control room, or local control panel. |
|
MeasuredVar |
The measured variable. Usually filled in via the Diagram Object Template. |
|
Modifier |
Initial value usually filled in via the Diagram Object Template. |
|
Function |
Initial value usually filled in via the Diagram Object Template. |
|
Superscript |
|
|
Subscript |
|
|
Description |
|
|
DmPartCode |
|
|
PdObjectId |
Unique object ID (OID). |
|
PosIdNull |
If PosId is a null string, this is not zero. The unique PosId is a combination of PosId, Status, and PosIdNull fields. |
EditObjsOfGd
Stores the information which objects are checked out in which diagram.
|
Diagram |
The OID of the diagram. |
|
PdObjectId |
The OID of the object (system, pipeline, tag, equipment, armature, instrument). |
|
NrOfObjects |
The number of linked objects in the diagram. |
|
EditedInThisDiagram |
If this is a positive value, the object is edited in this checked out diagram. |
PI_CATALOG
PI_CATALOG table stores the information of the diagram document itself and the title box of the document.
Note: Project administrator can edit the PI_CATALOG table in Database Table Manager—see Database Table Manager.
|
Name |
The unique name for a diagram. Same as the base name of the files storing the graphical diagram. |
|
Status |
Indicates whether the record is currently being edited. |
|
Type |
Type of the diagram. |
|
InUseBy |
Identifies who has checked out the document. |
|
Revision |
Internal revision ID of the diagram. Counts how many times the diagram has been checked in. |
|
PdObjectId |
Unique object ID (OID) of the diagram. |
|
PdTransactionNr |
Internal counter that is incremented every time the diagram is saved. Used to control that the binary diagram and the database are synchronized. |
Note: The PI_CATALOG table used to be called P&I_CATALOG. You do not have to change the name of the old table—the system handles it automatically.
PIPELINES
Stores the data of the pipelines. The data of the pipelines is stored both in the database and in the COS objects.
|
PosId |
A unique ID given by the user. |
|
Deleted |
Flag indicating that this pipeline is to be deleted if no object is referring to it. |
|
PipelineId |
The same as PosId. |
|
Status |
Indicates whether the record is currently being edited. |
|
Revision |
Internal revision ID. |
|
System |
The name of the system of the pipeline. |
|
PdObjectId |
Unique object ID (OID). |
|
PosIdNull |
If PosId is a null string, this is not zero. The unique PosId is a combination of PosId, Status, and PosIdNull fields. If negative and PosId is not a null string, there is a conflict between PosIds and a new PosId must be provided. |
|
Spec1-Spec5 |
The piping specifications 1–5. |
|
AttrUseInDiagram |
If this is 1, the pipeline can be used in P&ID. |
|
AttrUseInModeller |
If this is 1, the pipeline can be used in Plant Modeller. |
|
AttrAddedInDiagram |
If this is a positive value, the pipeline has been created or modified in P&ID but has not yet been updated to COS. |
ReviseObjsOfDg
Stores information about which objects are checked in and in which diagram.
|
Diagram |
OID of the diagram. |
|
PdObjectId |
OID of the object (system, pipeline, tag, equipment, armature, instrument). |
|
NrOfObjects |
The number of linked objects in the diagram. |
|
OwnThisObject |
|
SYSTEMS
Stores the data of the systems. The data of the systems is stored both in the database and in the COS objects, just like the pipelines.
|
PosId |
A unique string ID given by the user. |
|
Deleted |
Flag indicating that this system is to be deleted if no object is referring to it. |
|
Status |
Indicates whether the record is currently being edited. |
|
Revision |
Internal revision ID. |
|
SystemId |
The same as PosId. |
|
Pmsysno |
The ID number Plant Modeller uses to identify its system. |
|
Color |
The color index number. |
|
Width |
Line width for symbols. This is given as the pen ID which maps to the line thickness on plots. See Lineweights. |
|
Width_of_line |
Line width for thin connection lines. If this value is 0, the same line width as for symbols is used. |
|
Width_of_thickline |
Line width for thick connection lines. If this value is 0, the same line width as for symbols is used. |
|
Layer |
The layer index for the graphics in this system. |
|
LayerName |
The name of the layer for document export. See Drawing export configuration |
|
PdObjectId |
Unique object ID (oid). |
|
PosIdNull |
If PosId is a null string, this is not zero. The unique PosId is a combination of PosId, Status and PosIdNull fields. If negative and PosId is not a null string, there is a conflict between PosIds and a new PosId must be provided. |
|
AttrUseInDiagram |
If this is 1, the system can be used in P&ID. |
|
AttrUseInModeller |
If this is 1, the system can be used in Plant Modeller. |
|
AttrAddedInDiagram |
If this is a positive value, the system has been created or modified in P&ID but has not yet been updated to COS. |
TAGS
Stores the data of the instrument tags.
|
PosId |
The unique ID given by the user. |
|
Deleted |
Flag indicating that this tag is to be deleted if no object is referring to it. |
|
TagId |
The same as Posid. |
|
Status |
Indicates whether the record is currently being edited. |
|
Revision |
Internal revision ID. |
|
System |
The name of the system of the instrument tag. |
|
PdObjectId |
Unique object ID (OID). |
|
PosIdNull |
If PosId is a null string, this is not zero. The unique PosId is a combination of PosId, Status, and PosIdNull fields. If negative and PosId is not a null string, there is a conflict between PosIds and a new PosId must be provided. |