iadc_discovered_materials #1216

id
INTEGER
1216
vessel_id
INTEGER
1 → vessels
vessel_document_id
INTEGER
8 → vessel_documents
category
VARCHAR
Mud Equipment
subcategory
VARCHAR
F.1.1
name
VARCHAR
Mud Pump (Triplex)
description
TEXT
Make: National 14-P-220; Qty: 4
attributes
JSON
{"make": "National 14-P-220", "type": "C/w ceramic / Zaconia liners (5-1/2, 6 inch); fluid end National Oilwell; supercharging pump (Mission 8x6x14V, 75 HP); discharge/suction 6/8 inch ID; pulsation dampener (Hydril R-Pasafe); reset relief valve (NOV Titan A.R.R.V.); electronic stroke counter; driven by 2 x GEB-22A2 AC motors @ 1,150 HP each", "quantity": 4, "spec_1": "Maximum WP 7,500 psi", "spec_2": "test pressure 11,250 psi", "spec_3": "flowrate 406 US gal/min @ 94 spm with 5-1/2 inch liner", "make_type_model": "National 14-P-220", "spare_parts_count": 268, "total_inventory_value": 0, "total_qty_on_hand": 2203, "spare_part_manufacturers": "ACU, AMN, AXON, BUX, LCE, LOH, MHWT, MIS, NAT, NOV, OMG, OW, PQO, SRP, SW, VAR"}
remarks
TEXT
null
verification_status
ENUM
NOT_VERIFIED
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-04-28T15:29:06.719996
updated_at
TIMESTAMP
2026-06-03T05:59:16.947619
promoted_material_id
INTEGER
null
source_pages
JSON
null
source_type
VARCHAR
csv
raw_text
TEXT
null
make
VARCHAR
National 14-P-220
model
VARCHAR
null