Structure of database tables (1)

The P&ID database contains the following fixed database tables, with some fixed database fields.

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 graphics diagram.
Status	The editing status of the record: whether it is currently being edited by someone or not.
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.
PipelineId	The same as PosId.
Status	The editing status of the record: whether it is currently being edited by someone or not.
Revision	Internal revision id.
System	The name of the system of the pipeline.
Deleted	Flag indicating that this pipeline is to be deleted if no object referring to it.
model_status	Linking the data to model.
model_not_set	If 1, not used in model. If 0 and model_status not 0, then used in model.
PdObjectId	Unique object id (oid).
PosIdNull	If PosId is null string, this is not zero. The unique PosId is a combination of PosId, Status and PosIdNull fields. If negative and the PosId is not null string there is a conflict between PosIds and you have to give a new PosId.
Spec1	The first piping specification.
Spec2	The second piping specification.
Spec3	The third piping specification.
AttrUseInDiagram	If 1, pipeline can be used in P&ID.
AttrUseInModeller	If 1, pipeline can be used in Plant Modeller.
AttrAddedInDiagram	If positive value, pipeline has been created or modified in P&ID, but not yet updated to COS.

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.
Status	The editing status of the record: whether it is currently being edited by someone or not.
Revision	Internal revision ID.
SystemId	The same as PosId.
Deleted	Flag indicating that this system is to be deleted if no object referring to it.
Pmsysno	The ID number Plant Modeller uses to identify its system.
Color	The color index number.
Layer	The layer index for the graphics in this system.
LayerName	The name of the layer for exporting document. See Drawing Export Configuration
Width	Line width for symbols. Actually pen id which maps to the line thickness on plots. See Line Widths
Width_of_line	Line width for the thin connection lines. If this value is 0 then the same line width is used than for symbols.
Width_of_thickline	Line width for the thick connection lines. If this value is 0 then the same line width is used than for symbols.
model_status	Linking the data to model.
model_not_set	If 1, not used in model. If 0 and model_status not 0, then used in model.
PdObjectId	Unique object id (oid).
PosIdNull	If PosId is null string, this is not zero. The unique PosId is a combination of PosId, Status and PosIdNull fields. If negative and the PosId is not null string there is a conflict between PosIds and you have to give a new PosId.
AttrUseInDiagram	If 1, system can be used in P&ID.
AttrUseInModeller	If 1, system can be used in Plant Modeller.
AttrAddedInDiagram	If positive value, system has been created or modified in P&ID, but not yet updated to COS.

TAGS

Stores the data of the instrument tags.

PosId	The unique ID given by the user.
TagId	The same as Posid.
Status	The editing status of the record: whether it is currently being edited by someone or not.
Revision	Internal revision ID.
System	The name of the system of the instrument tag.
Deleted	Flag indicating that this tag is to be deleted if no object referring to it.
model_status
model_not_set
PdObjectId	Unique object ID (OID).
PosIdNull	If PosId is null string, this is not zero. The unique PosId is a combination of PosId, Status and PosIdNull fields. If negative and the PosId is not null string there is a conflict between PosIds and you have to give a new PosId.