Archival Schema Database Deck
Welcome to the normalized parts database cockpit. This dashboard connects directly to your PostgreSQL database, linking your refactored schemas dynamically across parts, organizations, costs, decoupled binary files, and BOM tree structures.
Part Name Placeholder
UOM: EAPart description details.
Bulk Edit Parts
You have selected 0 parts to update.
System Dashboard
Real-time metrics, active maintenance status, and user trip logs
๐ Operational Lows & Impact
Last 30 Days๐ Operational Highs & Milestones
Safety & PerformanceFleet Status Distribution
Aggregated Operational Hours across FleetFleet Maintenance & Compliance Backlog
Global Logistics Cargo Pipeline
Downtime Breakdown (Unpaid)
Recent DPR Down EventsHSEQ Critical Incidents Log
Injuries & Asset Damage๐ ๏ธ Fault Resolution Tracker
๐ค Crew Utilisation Extrema
Advanced Operations & Crew Analytics
Cross-comparison of project hazards and crew maintenance behaviorsProject Hazard & Damage Comparison
| Project โ | Systems โ | Downtime โ | Faults โ | Damages โ |
|---|---|---|---|---|
| No project records available | ||||
Crew Maintenance & Fault Metrics
| Crew Member โ | Role โ | Utilisation โ | PMs Completed โ | Faults Raised โ | Incidents โ |
|---|---|---|---|---|---|
| No crew records available | |||||
๐ Operational Lows & Impact
Last 30 Days๐ Operational Highs & Milestones
Safety & PerformanceProject Smart Overview
DPR Status Distribution on ProjectProject Pathway Timeline
Project Logistics Pipeline
Project Downtime Breakdown
DPR Down EventsProject HSEQ Incidents Log
Injuries & Asset Damage๐ ๏ธ Fault Resolution Tracker
๐ค Crew Utilisation Extrema
Project Operations & Crew Analytics
Cross-comparison of system hazards and crew maintenance behaviors on this projectSystem Hazard & Damage Comparison
| System โ | Downtime โ | Faults โ | Damages โ |
|---|---|---|---|
| No system records available | |||
Crew Maintenance & Fault Metrics
| Crew Member โ | Role โ | Utilisation โ | PMs Completed โ | Faults Raised โ | Incidents โ |
|---|---|---|---|---|---|
| No crew records available | |||||
Key Metrics
DPR Smart Overview
DPR Status Distribution for active systemUser Offshore Days Tracker Not Embarked
Projects, Sites and Systems Deck
Active ventures, customer operations, and technical deployment campaigns
System Documents Console
Explore and view technical documents bound to specific system parts in the active tree.
Document Tree
No System Selected
Select a system part node on the left to index its technical records
Certification Compliance Console
Global overview of certificate requirements, validity, and compliance logs.
| Ref Number | Item Name | Certificate Type | Cert Number | Issued Date | Expiry Date | Status | Action |
|---|
Users & Contacts Deck
Manage internal staff system logins, clearance permissions, and external organisation contacts
Contacts List
0 contactsNo Contact Selected
Select a person on the left to manage profiles and credentials
First Last
-
System Login Configuration
This contact does not currently have login credentials configured for this system.
System Access Allocations
Project Access Allocations
Site Access Allocations
Global Access
This user has global fleet-level access. Individual site or project allocations are not required.
Create Contact
Add New Address
๐ก๏ธ Role & Clearance Permissions Matrix
System Roles
Role clearances: Developer
| Securable Feature | Read | Create | Update | Delete | Actions |
|---|
๐ค Edit Profile Settings
โ๏ธ Select Active System Context
You have access to multiple system workspaces. Please choose which active system context you want to switch to:
โฃ๏ธ Danger Zone: Purge Database
You are about to permanently purge all system and active inventory data from the database.
A fresh Base Layout (Base Project, Site, System, and Reserved Locations) will be automatically recreated upon completion. Other data (Part Catalog, Users, Sites, Projects) will be retained.
This is a non-reversible operation. Please confirm your authorization.
Edit Document Metadata
Entity & File Type Management
Entities
Select an Entity
All Available Types
Create New File Type
Organisation Details
Associated Contacts
Add New Contact to Organisation
โ๏ธ Duplicate Part Costs Diagnostic
Identify and clean active parts with duplicate pricing configurations for the same supplier.
| Part Code | Part Name | Supplier | Duplicate Count | Active Price Configurations (Ordered by Preference) |
|---|---|---|---|---|
| Loading duplicate part costs... | ||||
Start Time Time Gap
Changing the start time leaves a gap between the previous event and this one. How would you like to handle this gap?
Start Time Overlap
Changing the start time overlaps with the preceding event. How would you like to handle this conflict?
Shorten Event Timeline
You have shortened this event's end time. How would you like to handle the remaining time gap?
โ ๏ธ Timeline Overlap Conflict
This event's extended end time overlaps subsequent events.
๐๏ธ Delete Event
Are you sure you want to delete this event? Choose how you would like to handle the adjacent timeline events:
Organisation Manager
Manage suppliers, customers, and partners along with their associated contacts
Organisations
0 orgsOrganisation Details
Associated Contacts
Add New Contact to Organisation
No Organisation Selected
Select an organisation from the list to view its details
Planned Maintenance
Track maintenance status, reschedule jobs, and tick off completed tasks
Filters
Planned Maintenance
Set filters to manage tasks
Planned Maintenance Job Manager
Define maintenance job tasks, recurrence patterns, frequencies, and required resources
Part Hierarchy
0 itemsNo Part Selected
Select a part from the hierarchy tree on the left, or use the part directory finder to add/manage PM jobs
Major Assembly Creator
Select a Top Level Part assembly template, inspect its BOM requirements, and instantiate it in the Base System
Top Level Assembly Templates
No Assembly Selected
Select a part template on the left to review its recursive BOM and instantiate it
DWG-D70666-100
ROV ASSEMBLY TXLS 26
Calculated Assembly Requirements
| Part Code | Description | UoM | Qty in BOM | Cost | Build Cost | Spares % | Req (Calc) | Spares Cost |
|---|
System Part Requirements
Manage calculated and entered reorder/required points for parts on the active system: None selected
No System Selected
Please select or allocate an active system first in the Projects Explorer.
System Structure
| Part Code | Type | Description | Qty on System | Total Stock | On Order | Required (Calc) | Required (User) | Reorder (Calc) | Cost | Build Cost | Spares Cost |
|---|
Purchase Requests & Orders
Manage and track parts purchase requests, supplier quotes, purchase orders, and material receipts.
Purchase Requests
Select a requisition from the list to view details.
DPR Event Log
Daily Progress Report timeline events, activity logs, and status distributions
No further updates can be made to the Operational Events, Crew Register, or HSEQ Logs for this date.
This date is before the project start date. Time and resources logged here will not contribute to the project statistics.
Operational Events Log
Filter: Operational ร| From | Title / Description | Status | To | Duration | Actions |
|---|
Operational Timeline Strip
24-Hour VisualizationStatus Distribution
Timeline History (Last 15 Days)
Currently Embarked Crew
| Name | Organisation | Org Role | System Role | Shift Pattern | Embark Date | Days | Actions |
|---|
Embark Crew Member
Selected: None
Quick Add User
Log Safety Activities & Incidents
Events Logged for Today
Log Safety Event
Faults Manager
Track, log, and resolve equipment faults on the active system: None selected
No Active System Selected
To view, report, or manage equipment faults, please select an active system from the Projects Explorer dashboard first.
Faults List
Select an incident or fault from the list to view details, log actions, and manage component faults.
Incident Title
Tracked Component Faults
Fault Title
Part: Description (Code)
Project & Client Details
System & Site Context
Equipment Hierarchy & Location
Parts Swapped Audit Trail
Fault Attachments & Documents
Inventory
Navigate the operations site structure tree, search equipment lists, and adjust warehouse quantities
Operation Site Tree
| Part Code โ | Status โ | Part Description โ | Qty โ | UoM โ | Total Stock (Status) โ | Location โ | ||
|---|---|---|---|---|---|---|---|---|
| Select a location from the structure tree to view inventory items. | ||||||||
System Status & Diagnostics
Monitor database table sizes, runtime memory allocations, active user sessions, and stream live logs
Hose Register Definitions
Assembly hierarchy tree of parts with linked hose register definitions
๐ณ Assembly Hierarchy Tree
Select a part assembly node to view details or manage definitions
Parts with register definitions are highlighted as leaves in the tree.
Hose Register Manager
Explore physical hose register instances and technical documents for the active system context
๐ณ System Part Register Tree
Select a system part node from the tree to see physical hose instances and technical documents
Hose Specifications Deck
View, filter, and configure technical hose specifications and part mappings
Goods Transfers & Manifests
Track and manage all hardware transport manifests, packing activities, and site receipts.
| Reference | From System | To System | Status | Requested On | Requested By | Notes | Action |
|---|
Hired Equipment Contracts
Track hired containers, boxes, delivery lists, and supplier return status.
| Contract Ref | Supplier | Project | System | Delivery Site | Expected Arrival | Expected Return | Status | Actions |
|---|---|---|---|---|---|---|---|---|
| No hire contracts registered yet. | ||||||||
System Management
Manage the physical ROV/System build tree, install tracked components from inventory, and align configurations.
โ๏ธ Operational Status Workflow
โ ๏ธ Build Discrepancy Breakdown (By Major Assembly)
โ๏ธ ROV System Build Tree
๐ฆ Tracked Spares Inventory Tree
Incidents Console
Track operational and internal incidents, and associate them with equipment faults and HSEQ occurrences.
Document Viewer
ROGER THAT!
Secure Authentication Required
Roger That!
Version development
DB Schema v--
๐ Daily Progress Report Preview
1. 24h Operational Events Log
| Time (UTC) | Duration | Sub-Type | Title | Title / Description |
|---|
2. Crew Register
| Name | Organisation | Position | Shift Pattern | Embarked Date | Days |
|---|
| Name | Organisation | Position | Shift Pattern | Disembark Date | Days |
|---|
3. Safety Events Logged Today
| Category | Title / Description |
|---|
4. HSEQ Statistics Summary
Leading Safety Indicators
| Activity | Prev | Today | Total |
|---|
Lagging Safety Indicators
| Activity | Prev | Today | Total |
|---|
Create Hose Specification
End Connection A (Left)
End Connection B (Right)
๐ Supplier Cost Sheets
| Supplier | Supplier Ref # | Supplier Desc | Cost | Action |
|---|
Request Spares from System
| Part Code | Description | Shortage | Supplier Excess | Request Qty | |
|---|---|---|---|---|---|
| Select a supplying system to view matches. | |||||
โ Register Hired Equipment Contract
๐ Contract & Supplier Info
Add New Organisation
๐ Project context & Duration
๐ Initial Delivery Destination
๐ฅ Base Goods Arrival Receipt
| Catalog Part | Supplier SKU | Serial Number | Description * | Qty Recv * | Arrival Status * | Notes / Discrepancy details |
|---|
๐ค Supplier Return Checkout
Audit final quantities and condition codes returned to the supplier box. Submitting will archive active hired parts.
| Item Description | Received Qty | Returned Qty * | Condition * | Notes / Deficit details |
|---|
๐ Hired Contract Details
| Item / Description | Catalog Part | SKU | Serial Number | Expected | Received | Returned | Hired Box |
|---|