PID-Meta
Tables (6)
Connections
- ConnectionID — INT
- FromEntityID — INT
- FromEntityType — VARCHAR(50)
- ToEntityID — INT
- ToEntityType — VARCHAR(50)
Equipment
- EquipmentID — INT
- ProjectID — INT
- TagNumber — VARCHAR(50)
- EquipmentType — VARCHAR(50)
- Name — VARCHAR(255)
- Duty — DECIMAL(10, 2)
- DesignPressure — VARCHAR(50)
- DesignTemperature — VARCHAR(50)
- Material — VARCHAR(50)
- Insulation — VARCHAR(50)
- TEMAType — VARCHAR(10)
- TrimShell — VARCHAR(50)
- TrimTube — VARCHAR(50)
- LocationX — FLOAT
- LocationY — FLOAT
Instrumentation
- InstrumentID — INT
- ProjectID — INT
- TagNumber — VARCHAR(50)
- Type — VARCHAR(50)
- Function — VARCHAR(50)
- Range — VARCHAR(50)
- Location — VARCHAR(50)
- Material — VARCHAR(50)
- LocationX — FLOAT
- LocationY — FLOAT
Piping
- PipingID — INT
- ProjectID — INT
- LineNumber — VARCHAR(50)
- FromPoint — VARCHAR(255)
- ToPoint — VARCHAR(255)
- Diameter — VARCHAR(50)
- Material — VARCHAR(50)
- Insulation — VARCHAR(50)
- PressureRating — VARCHAR(50)
- TemperatureRating — VARCHAR(50)
- LocationX — FLOAT
- LocationY — FLOAT
Projects
- ProjectID — INT
- ProjectName — VARCHAR(255)
- ProjectCode — VARCHAR(50)
- Description — TEXT
- VersionNumber — INT
- CreatedDate — DATETIME
- LastUpdatedDate — DATETIME
- ParentVersionID — INT
ReferenceDrawings
- ReferenceID — INT
- ProjectID — INT
- ReferenceName — VARCHAR(255)
- Description — TEXT