iadc_discovered_materials #1126

id
INTEGER
1126
vessel_id
INTEGER
1 → vessels
vessel_document_id
INTEGER
8 → vessel_documents
category
VARCHAR
Drilling Equipment
subcategory
VARCHAR
B.2.1
name
VARCHAR
Main Drawworks
description
TEXT
Make: National Oilwell / Hitech; Model: AHD-1000; Qty: 1
attributes
JSON
{"make": "National Oilwell / Hitech", "model": "AHD-1000", "type": "AC, Lebus grooved drum, Active Heave Compensating, Kinetic Energy Monitoring System, anti-collision interface, integrated auto driller, BOP/subsea tool landing mode, wireline mode, emergency shutdown; c/w 6 x GEB 22 1,150 HP AC motors and National Oilwell / KEMS crown block safety device", "quantity": 1, "spec_1": "Drum diameter 73-1/2 inch", "spec_2": "wire diameter 2 inch", "spec_3": "max line pull 1,500 kips (12 lines)", "spec_4": "2,000 kips hook load (14 lines)", "spec_5": "7,000 HP rated", "make_type_model": "National Oilwell / Hitech", "spare_parts_count": 52, "total_inventory_value": 0, "total_qty_on_hand": 171, "spare_part_manufacturers": "B_S, EMS, HDF, HITE, NAT, NON, NOV, PRK, SMY, VAR"}
remarks
TEXT
null
verification_status
ENUM
NOT_VERIFIED
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-04-28T15:29:05.156670
updated_at
TIMESTAMP
2026-06-03T05:55:11.264037
promoted_material_id
INTEGER
null
source_pages
JSON
null
source_type
VARCHAR
csv
raw_text
TEXT
null
make
VARCHAR
National Oilwell / Hitech
model
VARCHAR
AHD-1000