iadc_discovered_materials #20216

id
INTEGER
20216
vessel_id
INTEGER
19 → vessels
vessel_document_id
INTEGER
57 → vessel_documents
category
VARCHAR
BOP Equipment
subcategory
VARCHAR
E.8.1
name
VARCHAR
Diverter Flowline with Valve
description
TEXT
Qty: 1
attributes
JSON
{"type": "18 inch flowline with air-operated knife valve", "quantity": 1, "spec_1": "18 inch", "spec_2": "500 psi", "spec_3": "knife valve", "spec_4": "air control", "spec_5": "remote from rig floor", "spec_6": "runs aft"}
remarks
TEXT
null
verification_status
ENUM
NOT_VERIFIED
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-10-16T07:59:34.778490
updated_at
TIMESTAMP
2026-10-16T07:59:34.778494
promoted_material_id
INTEGER
null
source_pages
JSON
null
source_type
VARCHAR
csv
raw_text
TEXT
Sheet 'IADC SFEL' row 3750 / E.8.1 Diverter Flowlines
make
VARCHAR
null
model
VARCHAR
null