iadc_discovered_materials #2870

id
INTEGER
2870
vessel_id
INTEGER
4 → vessels
vessel_document_id
INTEGER
20 → vessel_documents
category
VARCHAR
Drill String
subcategory
VARCHAR
D.44
name
VARCHAR
OFFICE SUPPLIES
description
TEXT
Make: 3MOF; Spare Parts: 2
attributes
JSON
{"make_type_model": "SAN", "spare_parts_count": 3, "total_inventory_value": 78.27, "total_qty_on_hand": 23, "stores": "STATIONARY CABINET No. 4", "spare_part_manufacturers": "SAN", "critical_spare_parts": 1}
remarks
TEXT
null
verification_status
ENUM
NOT_VERIFIED
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-06-22T09:49:17.921762
updated_at
TIMESTAMP
2026-06-22T09:49:20.020333
promoted_material_id
INTEGER
null
source_pages
JSON
null
source_type
VARCHAR
csv
raw_text
TEXT
Section: D.44 Equipment: OFFICE SUPPLIES Make/Type/Model: 3MOF Spare Parts: 2 Critical: 0 Total Value: $31.82
make
VARCHAR
3MOF
model
VARCHAR
null