materials #970

id INTEGER	970
category_id INTEGER	18 → material_categories
location_text VARCHAR	null
part_name VARCHAR	Marine Riser Joint (Buoyant)
part_type VARCHAR	Pipe material X-80; minimum yield 80,061 psi; Clip type connectors
description TEXT	Make: Kvaerner Clip; Qty: 10
image_path VARCHAR	null
is_active BOOLEAN	Active
created_at TIMESTAMP	2026-04-28T15:29:02.820851
updated_at TIMESTAMP	2026-06-03T09:07:40.583017
brand VARCHAR	Kvaerner Clip
iadc_discovered_material_id INTEGER	1014 → iadc_discovered_materials
source_vessel_id INTEGER	1 → vessels
pipeline_status ENUM	PUBLISHED
ready_for_sale BOOLEAN	False
is_published BOOLEAN	True
is_sold BOOLEAN	False
published_at TIMESTAMP	2026-06-03T09:07:35.322044
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	E.6.1
iadc_subcategory VARCHAR	E.6.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	{"make": "Kvaerner Clip", "type": "Pipe material X-80; minimum yield 80,061 psi; Clip type connectors", "quantity": 10, "spec_1": "OD 21 inch", "spec_2": "ID 19.374 inch", "spec_3": "wall thickness 0.813 inch", "spec_4": "length 75 ft", "spec_5": "weight 50,418 lbs buoyant"}
cross_reference_id VARCHAR	DE-970
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