iadc_discovered_materials #2849

id
INTEGER
2849
vessel_id
INTEGER
4 → vessels
vessel_document_id
INTEGER
20 → vessel_documents
category
VARCHAR
Drill String
subcategory
VARCHAR
D.10
name
VARCHAR
FILTER ELEMENTS (OIL, FUEL, ETC.)
description
TEXT
Make: PRK; Spare Parts: 2
attributes
JSON
{"make_type_model": "CCJ", "spare_parts_count": 1, "total_inventory_value": 80.75, "total_qty_on_hand": 1, "stores": "C324-B", "spare_part_manufacturers": "CCJ"}
remarks
TEXT
null
verification_status
ENUM
NOT_VERIFIED
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-06-22T09:49:08.157429
updated_at
TIMESTAMP
2026-06-22T09:49:08.360502
promoted_material_id
INTEGER
null
source_pages
JSON
null
source_type
VARCHAR
csv
raw_text
TEXT
Section: D.10 Equipment: FILTER ELEMENTS (OIL, FUEL, ETC.) Make/Type/Model: PRK Spare Parts: 2 Critical: 0 Total Value: $214.02
make
VARCHAR
PRK
model
VARCHAR
null