materials #1523

id
INTEGER
1523
category_id
INTEGER
10 → material_categories
location_text
VARCHAR
null
part_name
VARCHAR
Living Quarters / Accommodation Block
part_type
VARCHAR
Accommodation
description
TEXT
Qty: 1
image_path
VARCHAR
null
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-04-30T13:40:00.860184
updated_at
TIMESTAMP
2026-05-21T10:13:08.352473
brand
VARCHAR
null
iadc_discovered_material_id
INTEGER
1567 → iadc_discovered_materials
source_vessel_id
INTEGER
3 → vessels
pipeline_status
ENUM
PUBLISHED
ready_for_sale
BOOLEAN
False
is_published
BOOLEAN
True
is_sold
BOOLEAN
False
published_at
TIMESTAMP
2026-04-30T13:40:20.173787
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
K.2.1
iadc_subcategory
VARCHAR
K.2.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": "Accommodation", "quantity": 1, "spec_1": "Total 140 beds", "spec_2": "70 x 2-bed rooms with private toilets", "spec_3": "Galley 21 ft x 21 ft", "spec_4": "Main mess 26.5 x 42 ft seating 68", "spec_5": "Meeting Room 20 x 40 ft", "spec_6": "Recreation Room (TV, DVD, computer)", "spec_7": "Hospital Room 14.5 x 16.5 ft (1 bed, washbasin, medical cabinet, dangerous drugs, toilet/shower)", "spec_8": "Company Rep Office 12 x 15 ft", "spec_9": "Contractor Rep Office 17 x 15 ft", "spec_10": "Radio Room (Pilot House) 11 x 17 ft", "spec_11": "Laundry, Dry food store, Refrigerator, Change rooms, Workout/Weight Room"}
cross_reference_id
VARCHAR
DE-1523
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
null
segment_id
INTEGER
null
availability_override
VARCHAR
null