iadc_discovered_materials #2867

id
INTEGER
2867
vessel_id
INTEGER
4 → vessels
vessel_document_id
INTEGER
20 → vessel_documents
category
VARCHAR
Drill String
subcategory
VARCHAR
D.36.2
name
VARCHAR
HIGH PRESSURE VALVES
description
TEXT
Make: CRV; Spare Parts: 2
attributes
JSON
{"make_type_model": "SLK", "spare_parts_count": 1, "total_inventory_value": 203.85, "total_qty_on_hand": 3, "stores": "H812-B", "spare_part_manufacturers": "SLK"}
remarks
TEXT
null
verification_status
ENUM
NOT_VERIFIED
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-06-22T09:49:17.445167
updated_at
TIMESTAMP
2026-06-22T09:49:17.705217
promoted_material_id
INTEGER
null
source_pages
JSON
null
source_type
VARCHAR
csv
raw_text
TEXT
Section: D.36.2 Equipment: HIGH PRESSURE VALVES Make/Type/Model: CRV Spare Parts: 2 Critical: 0 Total Value: $0.00
make
VARCHAR
CRV
model
VARCHAR
null