iadc_discovered_materials #212

id
INTEGER
212
vessel_id
INTEGER
2 → vessels
vessel_document_id
INTEGER
2 → vessel_documents
category
VARCHAR
Miscellaneous Equipment
subcategory
VARCHAR
L.3.6
name
VARCHAR
Helideck Foam Monitor System
description
TEXT
Make: Semco; Qty: 3
attributes
JSON
{"make": "Semco", "type": "Fixed foam extinguishing system", "quantity": 3, "spec_1": "265 gallon", "spec_2": "3% AFFF", "spec_3": "900 US gpm rate", "spec_4": "10 min minimum per IMO MODU 1989"}
remarks
TEXT
null
verification_status
ENUM
NOT_VERIFIED
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-05-09T07:14:53.701811
updated_at
TIMESTAMP
2026-05-09T07:14:53.701814
promoted_material_id
INTEGER
null
source_pages
JSON
[63]
source_type
VARCHAR
csv
raw_text
TEXT
Transocean DD1 IADC Standard Equipment List, Rev: Jan 01, 2018, §L.3.6, p.63
make
VARCHAR
Semco
model
VARCHAR
null