|
id
INTEGER
|
936 |
|
category_id
INTEGER
|
2 → product_categories |
|
name
TEXT
|
Top Drive |
|
slug
TEXT
|
top-drive-de1771 |
|
price
NUMERIC
|
0.00 |
|
sku
TEXT
|
DE-1771 |
|
stock
INTEGER
|
1 |
|
image
TEXT
|
https://api.drillequip.co/uploads/materials/1771/images/image_1771_20260504101339565020_b75.png |
|
gallery
JSONB
|
["https://api.drillequip.co/uploads/materials/1771/images/image_1771_20260504101339565020_b75.png", "https://api.drillequip.co/uploads/materials/1771/images/image_1771_20260504101339768520_7dd.png", "https://api.drillequip.co/uploads/materials/1771/images/image_1771_20260504101339852275_5cb.png"] |
|
specs
JSONB
|
{"make": "NOV", "type": "Rotating System", "model": "PS2-1000", "source": "DrillEquip", "spec_1": "Electric", "spec_2": "Rated capacity 1,000 ST static / 750 ST rotating", "spec_3": "Test/working pressure 7,500 psi", "spec_4": "2 x GEB20B3 Vertical AC 600V drive motors, 2,300 hp", "spec_5": "Max continuous torque 110,000 ft-lbs @ 107 rpm", "spec_6": "Two-speed gearbox", "spec_7": "Max rotary speed 255 rpm", "spec_8": "Remote operated kelly cock", "spec_9": "Dual open-loop cooling (API RP-500)", "vessel": "SS OCEAN MONARCH - Semi Submersible Offshore Vessel", "spec_10": "Includes integral NOV hydraulic make-up/breakout system, max breakout torque 110,000 ft-lbs", "quantity": 1, "part_type": "Rotating System", "_model_number": "", "_product_type": "", "vessel_company": "", "condition_grade": "", "iadc_section_id": "B.4.4", "is_iadc_sourced": true, "pipeline_status": "PUBLISHED", "iadc_subcategory": "B.4.4", "drillequip_material_id": 1771}
|
|
pricing_tiers
JSONB
|
{} |
|
created_at
TIMESTAMP
|
2026-05-04T10:07:53.812935+00:00 |
|
updated_at
TIMESTAMP
|
2026-05-04T10:14:12.073757+00:00 |
|
description
TEXT
|
Make: NOV; Model: PS2-1000; Qty: 1 |
|
short_description
TEXT
|
null |
|
brand
TEXT
|
NOV |
|
cost_price
NUMERIC
|
null |
|
compare_at_price
NUMERIC
|
null |
|
low_stock_threshold
INTEGER
|
0 |
|
features
JSONB
|
[] |
|
is_active
BOOLEAN
|
Active |
|
is_featured
BOOLEAN
|
False |
|
meta_title
TEXT
|
null |
|
meta_description
TEXT
|
null |
|
tags
JSONB
|
["Drilling Equipment", "IADC", "DrillEquip", "RFQ"] |
|
video_url
TEXT
|
null |
|
rfq_only
BOOLEAN
|
True |
|
additional_category_id
INTEGER
|
null |
|
stock_total
INTEGER
|
0 |
|
stock_available
INTEGER
|
0 |
|
stock_reserved
INTEGER
|
0 |
|
warehouse_id
INTEGER
|
null |
|
base_currency
TEXT
|
null |
|
cross_reference_id
VARCHAR
|
DE-1771 |
|
sub_category_id
INTEGER
|
null |
|
segment_id
INTEGER
|
null |