iadc_discovered_materials #13397

id
INTEGER
13397
vessel_id
INTEGER
6 → vessels
vessel_document_id
INTEGER
45 → vessel_documents
category
VARCHAR
Section S
subcategory
VARCHAR
S.5
name
VARCHAR
Engine Room Auxiliaries
description
TEXT
Qty: 1
attributes
JSON
{"type": "e.g. fuel/lube oil purifiers-centrifuges, oily water separator, hot water heaters/calorifiers, refrigeration compressors, marine engineering auxiliary systems", "quantity": 1}
remarks
TEXT
null
verification_status
ENUM
NOT_VERIFIED
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-08-21T08:24:19.875826
updated_at
TIMESTAMP
2026-08-21T08:24:19.875832
promoted_material_id
INTEGER
null
source_pages
JSON
null
source_type
VARCHAR
csv
raw_text
TEXT
Supplementary parent — not in original IADC document
make
VARCHAR
null
model
VARCHAR
null