iadc_discovered_materials #2819

id
INTEGER
2819
vessel_id
INTEGER
4 → vessels
vessel_document_id
INTEGER
20 → vessel_documents
category
VARCHAR
BOP Equipment
subcategory
VARCHAR
E.84
name
VARCHAR
TONGS, CHAIN
description
TEXT
Make: GRH; Spare Parts: 3
attributes
JSON
{"make_type_model": "GRH", "spare_parts_count": 3, "total_inventory_value": 400.85, "total_qty_on_hand": 4, "stores": "A181, A181-A", "spare_part_manufacturers": "GRH"}
remarks
TEXT
null
verification_status
ENUM
NOT_VERIFIED
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-06-22T09:48:59.222226
updated_at
TIMESTAMP
2026-06-22T09:48:59.222230
promoted_material_id
INTEGER
null
source_pages
JSON
null
source_type
VARCHAR
csv
raw_text
TEXT
Section: E.84 Equipment: TONGS, CHAIN Make/Type/Model: GRH Spare Parts: 3 Critical: 0 Total Value: $400.85
make
VARCHAR
GRH
model
VARCHAR
null