iadc_discovered_materials #1711

id
INTEGER
1711
vessel_id
INTEGER
6 → vessels
vessel_document_id
INTEGER
11 → vessel_documents
category
VARCHAR
BOP Equipment
subcategory
VARCHAR
E.9.1
name
VARCHAR
Riser Tensioner (Primary)
description
TEXT
Make: NOV Shaffer; Qty: 6
attributes
JSON
{"make": "NOV Shaffer", "type": "Riser Tensioning", "quantity": 6, "spec_1": "Capacity 600,000 lbs each", "spec_2": "Maximum stroke 50 ft", "spec_3": "Line travel 50 ft", "spec_4": "Independent air compressors and air drying unit"}
remarks
TEXT
null
verification_status
ENUM
NOT_VERIFIED
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-04-30T14:00:51.059924
updated_at
TIMESTAMP
2026-04-30T14:00:51.059927
promoted_material_id
INTEGER
null
source_pages
JSON
null
source_type
VARCHAR
csv
raw_text
TEXT
null
make
VARCHAR
NOV Shaffer
model
VARCHAR
null