iadc_discovered_materials #2758

id
INTEGER
2758
vessel_id
INTEGER
4 → vessels
vessel_document_id
INTEGER
20 → vessel_documents
category
VARCHAR
BOP Equipment
subcategory
VARCHAR
E.14
name
VARCHAR
CLOTHES DRYER
description
TEXT
Make: JETV; Spare Parts: 3
attributes
JSON
{"make_type_model": "IPSO", "spare_parts_count": 1, "total_inventory_value": 134.17, "total_qty_on_hand": 1, "stores": "F603", "spare_part_manufacturers": "IPSO"}
remarks
TEXT
null
verification_status
ENUM
NOT_VERIFIED
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-06-22T09:48:45.313897
updated_at
TIMESTAMP
2026-07-10T07:00:34.329086
promoted_material_id
INTEGER
27578 → materials
source_pages
JSON
null
source_type
VARCHAR
csv
raw_text
TEXT
Section: E.14 Equipment: CLOTHES DRYER Make/Type/Model: JETV Spare Parts: 3 Critical: 0 Total Value: $246.00
make
VARCHAR
JETV
model
VARCHAR
null