iadc_discovered_materials #15973

id
INTEGER
15973
vessel_id
INTEGER
3 → vessels
vessel_document_id
INTEGER
49 → vessel_documents
category
VARCHAR
BOP Equipment
subcategory
VARCHAR
E.9.6
name
VARCHAR
Air Pressure Vessel
description
TEXT
Qty: 43
attributes
JSON
{"type": "Tensioner/compensator air pressure vessel", "quantity": 43, "spec_1": "Total capacity 312 gal", "spec_2": "rated working pressure 2,400 psi", "spec_3": "pressure relief valve installed"}
remarks
TEXT
null
verification_status
ENUM
NOT_VERIFIED
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-08-21T11:51:30.484885
updated_at
TIMESTAMP
2026-08-21T11:51:30.484892
promoted_material_id
INTEGER
null
source_pages
JSON
[40]
source_type
VARCHAR
csv
raw_text
TEXT
p. 40 / E.9.6 Tensioner/Compensator Air Pressure Vessels
make
VARCHAR
null
model
VARCHAR
null