materials #17911

id INTEGER	17911
category_id INTEGER	35 → material_categories
location_text VARCHAR	null
part_name VARCHAR	TRANSFORMER, CONTROL 50 VA 24 VAC SECONDARY 240/480 VAC PRIMARY W/ SECONDARY FUSE CLIPS TEMP CLASS 105 DEG C
part_type VARCHAR	null
description TEXT	TRANSFORMER, CONTROL 50 VA 24 VAC SECONDARY 240/480 VAC PRIM
image_path VARCHAR	null
is_active BOOLEAN	Active
created_at TIMESTAMP	2026-06-22T09:48:23.842716
updated_at TIMESTAMP	2026-07-28T10:39:30.849191
brand VARCHAR	MRN
iadc_discovered_material_id INTEGER	null
source_vessel_id INTEGER	4 → vessels
pipeline_status ENUM	PUBLISHED
ready_for_sale BOOLEAN	True
is_published BOOLEAN	True
is_sold BOOLEAN	False
published_at TIMESTAMP	2026-06-22T10:24:42.571978
sold_at TIMESTAMP	null
estimated_value NUMERIC	null
asking_price NUMERIC	42.50
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	False
iadc_section_id VARCHAR	J.3
iadc_subcategory VARCHAR	null
storefront_enabled BOOLEAN	False
is_iadc BOOLEAN	False
iadc_category VARCHAR	null
make VARCHAR	null
model VARCHAR	null
publish_flag VARCHAR	PUBLISH
attributes JSON	{"part_number": "B050PU7JK", "mfg_part_number": "B050PU7JK", "bin_location": "C323-B", "qty_on_hand": 1, "unit_price": 42.5, "uom": "EA", "critical": false, "store": "C323-B", "min_qty": 0, "max_qty": 0}
cross_reference_id VARCHAR	DE-17911
source_type VARCHAR	spare
ai_status VARCHAR	null
ai_result_json JSONB	null
label_image_path VARCHAR	identification/78/images/nameplate_78_20260728103917167686_c07.jpg
bin_id INTEGER	null
documents JSON	null
parent_material_id INTEGER	17910 → materials
sub_category_id INTEGER	null
segment_id INTEGER	null
availability_override VARCHAR	null
brand_label VARCHAR	MRN
condition VARCHAR	New
sale_grade VARCHAR	Excellent