materials #1112

id INTEGER	1112
category_id INTEGER	5 → material_categories
location_text VARCHAR	null
part_name VARCHAR	Fixed Watermist Fire Extinguishing System
part_type VARCHAR	Both audio and visual alarms; automatic shutting of mechanical ventilation in pr
description TEXT	Make: Semco Watermist; Qty: 1
image_path VARCHAR	null
is_active BOOLEAN	Active
created_at TIMESTAMP	2026-05-21T04:50:00.806065
updated_at TIMESTAMP	2026-05-21T04:50:31.880941
brand VARCHAR	Semco Watermist
iadc_discovered_material_id INTEGER	1088 → iadc_discovered_materials
source_vessel_id INTEGER	5 → vessels
pipeline_status ENUM	PUBLISHED
ready_for_sale BOOLEAN	False
is_published BOOLEAN	True
is_sold BOOLEAN	False
published_at TIMESTAMP	2026-05-21T04:50:27.022991
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
publish_flag VARCHAR	PUBLISH
attributes JSON	{"make": "Semco Watermist", "type": "Both audio and visual alarms; automatic shutting of mechanical ventilation in protected spaces; remote manual release outside engine rooms and switchgear room. Protected spaces: engine rooms, paint locker, emergency generator, SCR room, thruster rooms, HV switchgear, shaker house, mud pits, bridge, ECR, accommodations, purifier rooms, vent termination rooms", "quantity": 1, "spec_1": "Working pressure 2,900 psi"}
documents JSON	null
label_image_path VARCHAR	null
ai_status VARCHAR	null
source_type VARCHAR	iadc_csv
bin_id INTEGER	null
cross_reference_id VARCHAR	DE-1112
ai_result_json JSONB	null
parent_material_id INTEGER	null
sub_category_id INTEGER	62 → material_sub_categories
segment_id INTEGER	303 → material_segments