iadc_discovered_materials #2832

id
INTEGER
2832
vessel_id
INTEGER
4 → vessels
vessel_document_id
INTEGER
20 → vessel_documents
category
VARCHAR
Cementing Equipment
subcategory
VARCHAR
G.7
name
VARCHAR
UPPER KELLY COCK
description
TEXT
Make: HYD; Spare Parts: 4
attributes
JSON
{"make_type_model": "HYD", "spare_parts_count": 4, "total_inventory_value": 41872.01, "total_qty_on_hand": 13, "critical_spare_parts": 2, "stores": "A151, A151-A, D440, RG82", "spare_part_manufacturers": "HYD"}
remarks
TEXT
null
verification_status
ENUM
NOT_VERIFIED
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-06-22T09:49:04.497253
updated_at
TIMESTAMP
2026-06-22T09:49:04.497256
promoted_material_id
INTEGER
null
source_pages
JSON
null
source_type
VARCHAR
csv
raw_text
TEXT
Section: G.7 Equipment: UPPER KELLY COCK Make/Type/Model: HYD Spare Parts: 4 Critical: 2 Total Value: $41,872.01
make
VARCHAR
HYD
model
VARCHAR
null