🛢️ Oil & Gas · Database ERD
Oil and Gas Asset and Equipment Schema
A database schema for an asset register: facilities, functional locations, equipment, maintenance plans, work orders and inspection readings.
Drawing diagram…
What this diagram shows
- Equipment is installed at functional locations in a facility
- Maintenance plans generate work orders on schedule
- Inspection readings track thickness, vibration and condition
Prompt used
ERD for oil and gas asset management: Facility (platform, refinery, pipeline station) contains FunctionalLocations (tag numbers), Equipment is installed at a FunctionalLocation and has an EquipmentClass and criticality, MaintenancePlan per equipment generates WorkOrders, and InspectionReading stores measurements such as wall thickness or vibration against equipment.
Mermaid code
erDiagram
FACILITY ||--o{ FUNCTIONAL_LOCATION : contains
FUNCTIONAL_LOCATION ||--o| EQUIPMENT : "installed at"
EQUIPMENT_CLASS ||--o{ EQUIPMENT : classifies
EQUIPMENT ||--o{ MAINTENANCE_PLAN : "maintained by"
MAINTENANCE_PLAN ||--o{ WORK_ORDER : generates
EQUIPMENT ||--o{ INSPECTION_READING : "measured by"
FACILITY {
int id PK
string name
string type
}
FUNCTIONAL_LOCATION {
int id PK
int facility_id FK
string tag_no
}
EQUIPMENT {
int id PK
int location_id FK
int class_id FK
string serial_no
string criticality
}
WORK_ORDER {
int id PK
int plan_id FK
string type
date due_date
string status
}
INSPECTION_READING {
int id PK
int equipment_id FK
string measure
decimal value
date taken_on
}Related templates
SCADA Pipeline Monitoring Network
The operational network behind a pipeline SCADA system: field RTUs at pump and valve stations, the control centre, and a firewalled link to the business network.
Permit-to-Work Lifecycle
The safety permit that controls hazardous work at a refinery or rig: request, risk assessment, isolation, gas testing, work and handback.
Upstream Digital Oilfield Architecture
A digital oilfield platform: wellsite sensors and SCADA, a production data historian, and engineering applications for surveillance and optimisation.
Well Data Ingestion Pipeline
How drilling and production data from wells is collected, quality-checked, stored and shared with engineering teams.
Refinery Process Flow
A simplified crude oil refinery: desalting, distillation, conversion units and blending into finished fuels.
Compressor Predictive Maintenance
How a gas compressor station predicts failures: vibration and process data, an ML model, and maintenance work orders before a trip happens.