materials #81898

id INTEGER	81898
category_id INTEGER	16 → material_categories
location_text VARCHAR	null
part_name VARCHAR	Fixed Fire Extinguishing System
part_type VARCHAR	Water mist system
description TEXT	Qty: 1
image_path VARCHAR	null
is_active BOOLEAN	Active
created_at TIMESTAMP	2026-10-16T07:59:49.200898
updated_at TIMESTAMP	2026-10-16T08:02:39.927831
brand VARCHAR	null
iadc_discovered_material_id INTEGER	20463 → iadc_discovered_materials
source_vessel_id INTEGER	19 → vessels
pipeline_status ENUM	DRAFT
ready_for_sale BOOLEAN	False
is_published BOOLEAN	False
is_sold BOOLEAN	False
published_at TIMESTAMP	null
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	L.3.7
iadc_subcategory VARCHAR	L.3.7
storefront_enabled BOOLEAN	False
is_iadc BOOLEAN	False
iadc_category VARCHAR	null
make VARCHAR	null
model VARCHAR	null
publish_flag VARCHAR	SKIP
attributes JSON	{"type": "Water mist system", "quantity": 1, "spec_1": "Protects engine room, paint locker, emergency generator, ECR, switchboard and switchgear rooms, transformer rooms, accommodation, deep fat fryer, CCR, shaker house, incinerator room, drilling transformer room, cementing room, mud pit room, AHU and chiller room", "spec_2": "alarms", "spec_3": "automatic ventilation shutdown", "spec_4": "remote release at CCR and water mist compartment panel"}
cross_reference_id VARCHAR	null
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	62 → material_sub_categories
segment_id INTEGER	303 → material_segments
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