iadc_discovered_materials #2914

id
INTEGER
2914
vessel_id
INTEGER
4 → vessels
vessel_document_id
INTEGER
20 → vessel_documents
category
VARCHAR
Drilling Equipment
subcategory
VARCHAR
B.50.1
name
VARCHAR
ROTARY TABLE
description
TEXT
Make: VAR; Spare Parts: 24
attributes
JSON
{"make_type_model": "VECT", "spare_parts_count": 1, "total_inventory_value": 1461.52, "total_qty_on_hand": 2, "critical_spare_parts": 1, "stores": "RG19-A", "spare_part_manufacturers": "VECT"}
remarks
TEXT
null
verification_status
ENUM
NOT_VERIFIED
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-06-22T09:49:36.820277
updated_at
TIMESTAMP
2026-06-22T09:49:37.370709
promoted_material_id
INTEGER
null
source_pages
JSON
null
source_type
VARCHAR
csv
raw_text
TEXT
Section: B.50.1 Equipment: ROTARY TABLE Make/Type/Model: VAR Spare Parts: 24 Critical: 11 Total Value: $44,533.91
make
VARCHAR
VAR
model
VARCHAR
null