materials #77030

id INTEGER	77030
category_id INTEGER	29 → material_categories
location_text VARCHAR	null
part_name VARCHAR	Casing / Tubing Tong
part_type VARCHAR	Casing module, part of ST-160
description TEXT	Model: CM-22; Qty: 1
image_path VARCHAR	null
is_active BOOLEAN	Active
created_at TIMESTAMP	2026-10-05T11:08:06.402061
updated_at TIMESTAMP	2026-10-05T11:12:05.557994
brand VARCHAR	null
iadc_discovered_material_id INTEGER	17705 → iadc_discovered_materials
source_vessel_id INTEGER	16 → vessels
pipeline_status ENUM	PUBLISHED
ready_for_sale BOOLEAN	False
is_published BOOLEAN	True
is_sold BOOLEAN	False
published_at TIMESTAMP	2026-10-05T11:12:03.452567
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	D.2.15
iadc_subcategory VARCHAR	D.2.15
storefront_enabled BOOLEAN	False
is_iadc BOOLEAN	False
iadc_category VARCHAR	null
make VARCHAR	null
model VARCHAR	null
publish_flag VARCHAR	PUBLISH
attributes JSON	{"model": "CM-22", "type": "Casing module, part of ST-160", "quantity": 1, "spec_1": "Connection OD range 7 - 22 inch", "spec_2": "2 rpm @ 147,500 lbf-ft, 7 rpm @ 88,500 lbf-ft, 15 rpm @ 12,000 lbf-ft", "spec_3": "max torque 14-22 inch 147,500 / 10-14 inch 88,500 / 7-10 inch 44,200 lbf-ft"}
cross_reference_id VARCHAR	DE-77030
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	19 → material_sub_categories
segment_id INTEGER	717 → 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