|
id
INTEGER
|
478 |
|
category_id
INTEGER
|
4 → product_categories |
|
name
TEXT
|
Elevator Link Set 500 st (3.5" x 9 ft) |
|
slug
TEXT
|
elevator-link-set-500-st-35-x-9-ft-de490 |
|
price
NUMERIC
|
0.00 |
|
sku
TEXT
|
DE-490 |
|
stock
INTEGER
|
1 |
|
image
TEXT
|
null |
|
gallery
JSONB
|
null |
|
specs
JSONB
|
{"source": "DrillEquip", "vessel": "Semi Sub offshore unit DIU", "part_type": "Bail link set", "vessel_company": "", "condition_grade": "", "iadc_section_id": "D.2.13", "is_iadc_sourced": true, "pipeline_status": "PUBLISHED", "iadc_subcategory": "D.2.13", "drillequip_material_id": 490}
|
|
pricing_tiers
JSONB
|
{} |
|
created_at
TIMESTAMP
|
2026-04-27T03:58:50.051661+00:00 |
|
updated_at
TIMESTAMP
|
2026-04-27T03:58:50.051661+00:00 |
|
description
TEXT
|
Make: Blohm & Voss; Qty: 1 |
|
short_description
TEXT
|
null |
|
brand
TEXT
|
Blohm & Voss |
|
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
|
["Drill String", "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-490 |
|
sub_category_id
INTEGER
|
null |
|
segment_id
INTEGER
|
null |