materials #1296

id
INTEGER
1296
category_id
INTEGER
21 → material_categories
location_text
VARCHAR
null
part_name
VARCHAR
Driller Cyber Base Drilling Control System
part_type
VARCHAR
Integrated Drilling Control System with Instrumentation
description
TEXT
Make: NOV Cyberbase; Qty: 1
image_path
VARCHAR
null
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-04-30T11:28:53.494454
updated_at
TIMESTAMP
2026-05-21T10:13:08.352268
brand
VARCHAR
NOV Cyberbase
iadc_discovered_material_id
INTEGER
1340 → iadc_discovered_materials
source_vessel_id
INTEGER
4 → vessels
pipeline_status
ENUM
PUBLISHED
ready_for_sale
BOOLEAN
False
is_published
BOOLEAN
True
is_sold
BOOLEAN
False
published_at
TIMESTAMP
2026-04-30T11:29:56.785628
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
H.1
iadc_subcategory
VARCHAR
H.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": "NOV Cyberbase", "type": "Integrated Drilling Control System with Instrumentation", "quantity": 1, "spec_1": "Integrated drilling control system serving driller position. Includes weight indicator with load pin/deadman load cell (calibrated for 16 fwd / 12 aft lines)", "spec_2": "4 WOM standpipe pressure gauges (0-10000 psi)", "spec_3": "2 WOM choke manifold pressure gauges (0-15000 psi)", "spec_4": "rotary speed tachometer (0-15 rpm)", "spec_5": "rotary torque indicator (45,000 ft-lbs max)", "spec_6": "6 NOV MRU-H motion compensator sensors (3 fwd + 3 aft drawworks) with hook position and lock/unlock indicators", "spec_7": "proximity sensor pump stroke counters per pump", "spec_8": "tong torque indicator (0-35000 lbs line tension)", "spec_9": "pit volume totalizer with floats in active and reserve mud tanks plus loss/gain audio/visual alarm", "spec_10": "mud flow indicator with high/low alarm", "spec_11": "trip tank indicator with chart recorder and alarm", "spec_12": "general alarm system", "spec_13": "automatic driller. Drilling parameter recorder displayed at 4 locations: drill floor, 2x company representative office, OIM office, toolpusher office"}
cross_reference_id
VARCHAR
DE-1296
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