iadc_discovered_materials #1434

id
INTEGER
1434
vessel_id
INTEGER
4 → vessels
vessel_document_id
INTEGER
9 → vessel_documents
category
VARCHAR
Unit Specifications
subcategory
VARCHAR
A.9.2
name
VARCHAR
Pedestal Crane (AHC Subsea)
description
TEXT
Make: NOV; Model: OC 4475KSCE; Qty: 1
attributes
JSON
{"make": "NOV", "model": "OC 4475KSCE", "type": "Active Heave Compensated Knuckleboom Subsea Crane", "quantity": 1, "spec_1": "DNV certified", "spec_2": "Electro AHC CRZ Hydraulic", "spec_3": "Port Aft location", "spec_4": "30 mt @ 164 ft max radius", "spec_5": "20 mt whip @ 145 ft", "spec_6": "auto brake", "spec_7": "safety latch hooks", "spec_8": "crown saver", "spec_9": "boom illumination"}
remarks
TEXT
null
verification_status
ENUM
NOT_VERIFIED
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-04-30T11:28:55.032373
updated_at
TIMESTAMP
2026-04-30T11:28:55.032377
promoted_material_id
INTEGER
null
source_pages
JSON
null
source_type
VARCHAR
csv
raw_text
TEXT
null
make
VARCHAR
NOV
model
VARCHAR
OC 4475KSCE