iadc_discovered_materials #15000

id
INTEGER
15000
vessel_id
INTEGER
1 → vessels
vessel_document_id
INTEGER
47 → vessel_documents
category
VARCHAR
Drilling Equipment
subcategory
VARCHAR
B.4.4.b
name
VARCHAR
Top drive
description
TEXT
Make: NOV; Model: HPS-500 E; Qty: 1
attributes
JSON
{"make": "NOV", "model": "HPS-500 E", "type": "Auxiliary, electric AC - HYDRALIFT", "quantity": 1, "spec_1": "Rated 500 st", "spec_2": "7,500 psi", "spec_3": "GEB AC motor 1,150 hp", "spec_4": "max continuous torque 62,500 ft-lbs", "spec_5": "max 260 rpm", "spec_6": "remote operated kelly cock"}
remarks
TEXT
null
verification_status
ENUM
NOT_VERIFIED
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-08-21T09:43:06.966282
updated_at
TIMESTAMP
2026-08-21T09:43:06.966288
promoted_material_id
INTEGER
null
source_pages
JSON
[19, 20]
source_type
VARCHAR
csv
raw_text
TEXT
p. 19-20 - B.4.4 Top Drive (Auxiliary)
make
VARCHAR
NOV
model
VARCHAR
HPS-500 E