Dashboard
/
materials
/
Edit #82030
Edit row #82030 in
materials
id
INTEGER ·
required
Auto-generated
category_id
INTEGER ·
required
location_text
VARCHAR(200)
part_name
VARCHAR(150) ·
required
part_type
VARCHAR(80)
description
TEXT
Qty: 1
image_path
VARCHAR(300)
is_active
BOOLEAN ·
required
True
False
created_at
TIMESTAMP ·
required
updated_at
TIMESTAMP ·
required
brand
VARCHAR(120)
iadc_discovered_material_id
INTEGER
source_vessel_id
INTEGER
pipeline_status
VARCHAR(19) ·
required
ready_for_sale
BOOLEAN ·
required
True
False
is_published
BOOLEAN ·
required
True
False
is_sold
BOOLEAN ·
required
True
False
published_at
TIMESTAMP
sold_at
TIMESTAMP
estimated_value
NUMERIC(12, 2)
asking_price
NUMERIC(12, 2)
sold_price
NUMERIC(12, 2)
currency
VARCHAR(3)
condition_grade
VARCHAR(20)
condition_notes
TEXT
warehouse_id
INTEGER
shelf_id
INTEGER
rack_id
INTEGER
basket_id
INTEGER
quantity
INTEGER ·
required
unit
VARCHAR(30)
is_iadc_sourced
BOOLEAN ·
required
True
False
iadc_section_id
VARCHAR(20)
iadc_subcategory
VARCHAR(100)
storefront_enabled
BOOLEAN
True
False
is_iadc
BOOLEAN
True
False
iadc_category
VARCHAR(200)
make
VARCHAR(200)
model
VARCHAR(200)
publish_flag
VARCHAR(20) ·
required
attributes
JSON
{"type": "Semi-submersible catamaran, two lower hulls braced by four transverse trusses, four rectangular columns - lightship steel", "quantity": 1, "spec_1": "Lightship (estimated) 31,705.22 short tons", "spec_2": "displacement at loadline 54,724 short tons", "spec_3": "overall 379.59 ft x 296.59 ft", "spec_4": "main deck 354.26 ft x 285.14 ft", "spec_5": "4 columns 52.03 ft x 66.01 ft", "spec_6": "pontoons 354.26 ft x 66.12 ft x 28 ft", "spec_7": "moonpool 140 ft x 34 ft", "spec_8": "built 2011 Jurong Shipyard, Singapore", "spec_9": "IMO 8770314", "spec_10": "flag Liberia (Monrovia), call sign D5P17", "spec_11": "owner Valaris", "spec_12": "accommodation 200 POB", "spec_13": "tankage (A.2): fuel 8,890 bbls, drill water 21,630 bbls, potable water 10,898 bbls, active mud 6,370 bbls, reserve mud 9,305 bbls, brine 17,415 ft3, base oil 29,533 ft3, OBM 52,247 ft3, ballast 123,142 ft3, bulk barite/bentonite 13,396 ft3, bulk cement 13,396 ft3"}
cross_reference_id
VARCHAR(50)
source_type
VARCHAR(30)
ai_status
VARCHAR(30)
ai_result_json
JSONB
label_image_path
VARCHAR(300)
bin_id
INTEGER
documents
JSON
parent_material_id
INTEGER
sub_category_id
INTEGER
segment_id
INTEGER
availability_override
VARCHAR(20)
brand_label
VARCHAR(120)
condition
VARCHAR(20)
sale_grade
VARCHAR(30)
sub_segment_id
INTEGER
section_id
INTEGER
instance_label
VARCHAR(50)
needs_review
BOOLEAN ·
required
True
False
review_reason
VARCHAR(200)
spare_part_number
VARCHAR(100)
mfg_part_number
VARCHAR(100)
original_location
VARCHAR(200)
Cancel
Save Changes