iadc_discovered_materials #15943

id
INTEGER
15943
vessel_id
INTEGER
3 → vessels
vessel_document_id
INTEGER
49 → vessel_documents
category
VARCHAR
BOP Equipment
subcategory
VARCHAR
E.2.2.1
name
VARCHAR
Ram Type Preventer
description
TEXT
Make: Shaffer; Model: NXT-M; Qty: 2
attributes
JSON
{"make": "Shaffer", "model": "NXT-M", "type": "Subsea ram BOP body", "quantity": 2, "spec_1": "Bore 18-3/4\"", "spec_2": "working pressure 15,000 psi", "spec_3": "1 double and 1 triple", "spec_4": "MPL ram locks", "spec_5": "top connection 18-3/4\" 15M studded BX-164", "spec_6": "bottom 18-3/4\" 15M flanged BX-164", "spec_7": "side outlets 3-1/16\" 15M stud, BX-154"}
remarks
TEXT
null
verification_status
ENUM
NOT_VERIFIED
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-08-21T11:51:28.175771
updated_at
TIMESTAMP
2026-08-21T11:51:28.175778
promoted_material_id
INTEGER
null
source_pages
JSON
[34]
source_type
VARCHAR
csv
raw_text
TEXT
p. 34 / E.2.2 Ram Type Preventers
make
VARCHAR
Shaffer
model
VARCHAR
NXT-M