|
id
INTEGER
|
78092 |
|
category_id
INTEGER
|
25 → material_categories |
|
location_text
VARCHAR
|
null |
|
part_name
VARCHAR
|
Hull / Unit (Drillship) |
|
part_type
VARCHAR
|
Drilling vessel - lightship steel |
|
description
TEXT
|
Qty: 1 |
|
image_path
VARCHAR
|
null |
|
is_active
BOOLEAN
|
Active |
|
created_at
TIMESTAMP
|
2026-10-05T11:18:07.447026 |
|
updated_at
TIMESTAMP
|
2026-10-05T11:30:40.318684 |
|
brand
VARCHAR
|
null |
|
iadc_discovered_material_id
INTEGER
|
18763 → iadc_discovered_materials |
|
source_vessel_id
INTEGER
|
17 → vessels |
|
pipeline_status
ENUM
|
PUBLISHED |
|
ready_for_sale
BOOLEAN
|
False |
|
is_published
BOOLEAN
|
True |
|
is_sold
BOOLEAN
|
False |
|
published_at
TIMESTAMP
|
2026-10-05T11:30:38.614534 |
|
sold_at
TIMESTAMP
|
null |
|
estimated_value
NUMERIC
|
null |
|
asking_price
NUMERIC
|
null |
|
sold_price
NUMERIC
|
null |
|
currency
VARCHAR
|
USD |
|
condition_grade
VARCHAR
|
null |
|
condition_notes
TEXT
|
null |
|
warehouse_id
INTEGER
|
null |
|
shelf_id
INTEGER
|
null |
|
rack_id
INTEGER
|
null |
|
basket_id
INTEGER
|
null |
|
quantity
INTEGER
|
1 |
|
unit
VARCHAR
|
null |
|
is_iadc_sourced
BOOLEAN
|
True |
|
iadc_section_id
VARCHAR
|
A.1 |
|
iadc_subcategory
VARCHAR
|
A.1 |
|
storefront_enabled
BOOLEAN
|
False |
|
is_iadc
BOOLEAN
|
False |
|
iadc_category
VARCHAR
|
null |
|
make
VARCHAR
|
null |
|
model
VARCHAR
|
null |
|
publish_flag
VARCHAR
|
PUBLISH |
|
attributes
JSON
|
{"type": "Drilling vessel - lightship steel", "quantity": 1, "spec_1": "Deadweight (light ship) 8,160 tons as printed", "spec_2": "GT 11,104", "spec_3": "NT 3,331", "spec_4": "LOA 136.7973 m", "spec_5": "breadth 24.4998 m", "spec_6": "depth 11.1984 m", "spec_7": "loadline draft 6.72 m", "spec_8": "built 1985 Hitachi Zosen, Osaka, Hull No. K1052", "spec_9": "IMO 8401183", "spec_10": "ABS +A1 Drilling Unit, +AMS", "spec_11": "flag Indian, port of registry Mumbai, call sign ATEI", "spec_12": "accommodation 110", "spec_13": "tankage (A.2): fuel oil 2,122.80 m3, lube oil 106.04 m3, drill water 1,617.58 m3, potable water 787.67 m3, ballast 4,547.16 m3, active mud 274 m3, reserve mud 265 m3, baryte 225 m3, cement 225 m3"}
|
|
cross_reference_id
VARCHAR
|
DE-78092 |
|
source_type
VARCHAR
|
iadc_csv |
|
ai_status
VARCHAR
|
null |
|
ai_result_json
JSONB
|
null |
|
label_image_path
VARCHAR
|
null |
|
bin_id
INTEGER
|
null |
|
documents
JSON
|
null |
|
parent_material_id
INTEGER
|
null |
|
sub_category_id
INTEGER
|
1 → material_sub_categories |
|
segment_id
INTEGER
|
null |
|
availability_override
VARCHAR
|
null |
|
brand_label
VARCHAR
|
null |
|
condition
VARCHAR
|
null |
|
sale_grade
VARCHAR
|
null |
|
sub_segment_id
INTEGER
|
null |
|
section_id
INTEGER
|
null |
|
instance_label
VARCHAR
|
null |
|
needs_review
BOOLEAN
|
False |
|
review_reason
VARCHAR
|
null |
|
spare_part_number
VARCHAR
|
null |
|
mfg_part_number
VARCHAR
|
null |
|
original_location
VARCHAR
|
null |