iadc_discovered_materials #20266

id
INTEGER
20266
vessel_id
INTEGER
19 → vessels
vessel_document_id
INTEGER
57 → vessel_documents
category
VARCHAR
Consumables
subcategory
VARCHAR
M.4
name
VARCHAR
Oily Water Separator
description
TEXT
Make: Coffin; Model: Ultra-Sep US-5000; Qty: 2
attributes
JSON
{"make": "Coffin", "model": "Ultra-Sep US-5000", "type": "15 ppm oily water separator", "quantity": 2, "spec_1": "22 gpm each", "spec_2": "MARPOL / IOPP"}
remarks
TEXT
null
verification_status
ENUM
NOT_VERIFIED
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-10-16T07:59:37.643789
updated_at
TIMESTAMP
2026-10-16T07:59:37.643794
promoted_material_id
INTEGER
null
source_pages
JSON
null
source_type
VARCHAR
csv
raw_text
TEXT
Sheet 'IADC SFEL' row 6263 / M.4 OILY WATER SEPARATOR
make
VARCHAR
Coffin
model
VARCHAR
Ultra-Sep US-5000