materials #1440

id
INTEGER
1440
category_id
INTEGER
20 → material_categories
location_text
VARCHAR
null
part_name
VARCHAR
Drill Pipe Landing String
part_type
VARCHAR
Tubular - 5.875"
description
TEXT
Make: Grade S-135; Qty: 1500
image_path
VARCHAR
null
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-04-30T13:39:59.240086
updated_at
TIMESTAMP
2026-05-21T10:13:08.352398
brand
VARCHAR
Grade S-135
iadc_discovered_material_id
INTEGER
1484 → iadc_discovered_materials
source_vessel_id
INTEGER
3 → vessels
pipeline_status
ENUM
PUBLISHED
ready_for_sale
BOOLEAN
False
is_published
BOOLEAN
True
is_sold
BOOLEAN
False
published_at
TIMESTAMP
2026-04-30T13:40:20.173379
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.1.3
iadc_subcategory
VARCHAR
D.1.3
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": "Grade S-135", "type": "Tubular - 5.875\"", "quantity": 1500, "spec_1": "OD 5.875\"", "spec_2": "Wall 0.625\"", "spec_3": "Total length 1,500 ft", "spec_4": "Range 3", "spec_5": "Adjusted weight 40.72 lb/ft", "spec_6": "Internally plastic coated", "spec_7": "Tool joint OD/ID 7.25\"/3.75\"", "spec_8": "Pin length 12\"", "spec_9": "Box length 14\"", "spec_10": "Tapered shoulder", "spec_11": "Connection UGPDS55", "spec_12": "Hardfacing TCS-Ti", "spec_13": "API Premium", "spec_14": "Thread protectors included"}
cross_reference_id
VARCHAR
DE-1440
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