iadc_discovered_materials #15970

id
INTEGER
15970
vessel_id
INTEGER
3 → vessels
vessel_document_id
INTEGER
49 → vessel_documents
category
VARCHAR
BOP Equipment
subcategory
VARCHAR
E.8.1
name
VARCHAR
Diverter Flowline
description
TEXT
Qty: 1
attributes
JSON
{"type": "Diverter overboard/shaker line", "quantity": 1, "spec_1": "OD 16\"", "spec_2": "running from diverter to shaker house", "spec_3": "16\" knife gate valves rated 500 psi", "spec_4": "hydraulic control valve", "spec_5": "remote controlled from drillers panel and toolpushers panel"}
remarks
TEXT
null
verification_status
ENUM
NOT_VERIFIED
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-08-21T11:51:30.277777
updated_at
TIMESTAMP
2026-08-21T11:51:30.277783
promoted_material_id
INTEGER
null
source_pages
JSON
[39]
source_type
VARCHAR
csv
raw_text
TEXT
p. 39 / E.8.1 Diverter Flowlines
make
VARCHAR
null
model
VARCHAR
null