iadc_discovered_materials #14863

id
INTEGER
14863
vessel_id
INTEGER
1 → vessels
vessel_document_id
INTEGER
47 → vessel_documents
category
VARCHAR
BOP Equipment
subcategory
VARCHAR
E.11.2
name
VARCHAR
Hotline hose
description
TEXT
Make: Not stated; Qty: 1
attributes
JSON
{"make": "Not stated", "type": "Moon pool", "quantity": 1, "spec_1": "Length 10,500 ft", "spec_2": "OD 1.5 in", "spec_3": "control line ID 1 in"}
remarks
TEXT
null
verification_status
ENUM
NOT_VERIFIED
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-08-21T09:42:57.814022
updated_at
TIMESTAMP
2026-08-21T09:42:57.814028
promoted_material_id
INTEGER
null
source_pages
JSON
[39, 40]
source_type
VARCHAR
csv
raw_text
TEXT
p. 39-40 - E.11.2 Hotline Hose
make
VARCHAR
Not stated
model
VARCHAR
null