iadc_discovered_materials #1035

id
INTEGER
1035
vessel_id
INTEGER
1 → vessels
vessel_document_id
INTEGER
8 → vessel_documents
category
VARCHAR
BOP Equipment
subcategory
VARCHAR
E.10.1
name
VARCHAR
Surface Accumulator Unit
description
TEXT
Make: Hydril MUX; Qty: 1
attributes
JSON
{"make": "Hydril MUX", "type": "Soluble oil reservoir 220 gal; oil/water mix 1,400 gal; glycol reservoir 550 gal; total useful volume 659 gal (surface and stack); regulators Worchester; 50% additional volume", "quantity": 1, "spec_1": "Located BOP Control Room", "spec_2": "52 bottles installed", "spec_3": "15 gal useful capacity each", "spec_4": "bottle WP 5,000 psi", "make_type_model": "ril MUX", "spare_parts_count": 3, "total_inventory_value": 0, "total_qty_on_hand": 0}
remarks
TEXT
null
verification_status
ENUM
NOT_VERIFIED
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-04-28T15:29:03.687265
updated_at
TIMESTAMP
2026-06-03T05:55:07.329292
promoted_material_id
INTEGER
null
source_pages
JSON
null
source_type
VARCHAR
csv
raw_text
TEXT
null
make
VARCHAR
Hydril MUX
model
VARCHAR
null