iadc_discovered_materials #2964

id
INTEGER
2964
vessel_id
INTEGER
4 → vessels
vessel_document_id
INTEGER
20 → vessel_documents
category
VARCHAR
Instrumentation
subcategory
VARCHAR
H.53.1
name
VARCHAR
RISER HANDLING BRIDGE CRANE
description
TEXT
Make: PTA; Spare Parts: 13
attributes
JSON
{"make_type_model": "PH", "spare_parts_count": 2, "total_inventory_value": 277.41, "total_qty_on_hand": 4, "critical_spare_parts": 2, "stores": "A141-D, A141-TOP", "spare_part_manufacturers": "PH"}
remarks
TEXT
null
verification_status
ENUM
NOT_VERIFIED
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-06-22T09:49:50.434211
updated_at
TIMESTAMP
2026-06-22T09:49:50.863331
promoted_material_id
INTEGER
null
source_pages
JSON
null
source_type
VARCHAR
csv
raw_text
TEXT
Section: H.53.1 Equipment: RISER HANDLING BRIDGE CRANE Make/Type/Model: PTA Spare Parts: 13 Critical: 2 Total Value: $17,001.00
make
VARCHAR
PTA
model
VARCHAR
null