iadc_discovered_materials #59

id
INTEGER
59
vessel_id
INTEGER
2 → vessels
vessel_document_id
INTEGER
2 → vessel_documents
category
VARCHAR
Consumables
subcategory
VARCHAR
M.1
name
VARCHAR
Sewage Treatment Unit
description
TEXT
Make: Orca IIA MSD (Type 2); Qty: 2
attributes
JSON
{"make": "Orca IIA MSD (Type 2)", "type": "MSD Type 2 sewage treatment", "quantity": 2, "spec_1": "NaOC injection", "spec_2": "Marpol Annex IV compliant"}
remarks
TEXT
null
verification_status
ENUM
NOT_VERIFIED
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-05-09T07:14:51.464420
updated_at
TIMESTAMP
2026-05-09T07:14:51.464423
promoted_material_id
INTEGER
null
source_pages
JSON
[67]
source_type
VARCHAR
csv
raw_text
TEXT
Transocean DD1 IADC Standard Equipment List, Rev: Jan 01, 2018, §M.1, p.67
make
VARCHAR
Orca IIA MSD (Type 2)
model
VARCHAR
null