iadc_discovered_materials #3006

id
INTEGER
3006
vessel_id
INTEGER
4 → vessels
vessel_document_id
INTEGER
20 → vessel_documents
category
VARCHAR
Marine Equipment
subcategory
VARCHAR
K.93
name
VARCHAR
THRUSTER RETRACTION SYSTEM
description
TEXT
Make: KAME; Spare Parts: 4
attributes
JSON
{"make_type_model": "KAME", "spare_parts_count": 4, "total_inventory_value": 0.12, "total_qty_on_hand": 12, "stores": "OUT-LOWER SACK STORE", "spare_part_manufacturers": "KAME"}
remarks
TEXT
null
verification_status
ENUM
NOT_VERIFIED
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-06-22T09:49:59.352889
updated_at
TIMESTAMP
2026-07-01T09:08:12.931056
promoted_material_id
INTEGER
27533 → materials
source_pages
JSON
null
source_type
VARCHAR
csv
raw_text
TEXT
Section: K.93 Equipment: THRUSTER RETRACTION SYSTEM Make/Type/Model: KAME Spare Parts: 4 Critical: 0 Total Value: $0.12
make
VARCHAR
KAME
model
VARCHAR
null