iadc_discovered_materials #1030

id
INTEGER
1030
vessel_id
INTEGER
1 → vessels
vessel_document_id
INTEGER
8 → vessel_documents
category
VARCHAR
BOP Equipment
subcategory
VARCHAR
E.8.1
name
VARCHAR
Diverter Flowline c/w Piper Ball Valve
description
TEXT
Make: Piper; Qty: 2
attributes
JSON
{"make": "Piper", "type": "Hydraulic control valve, remote controlled from Drillers Cabin", "quantity": 2, "spec_1": "OD 16 inch (13.56 inch bore)", "spec_2": "valve WP 1,480 psi", "spec_3": "running port/starboard"}
remarks
TEXT
null
verification_status
ENUM
NOT_VERIFIED
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-04-28T15:29:03.553799
updated_at
TIMESTAMP
2026-04-28T15:29:03.553802
promoted_material_id
INTEGER
null
source_pages
JSON
null
source_type
VARCHAR
csv
raw_text
TEXT
null
make
VARCHAR
Piper
model
VARCHAR
null