iadc_discovered_materials #13920

id
INTEGER
13920
vessel_id
INTEGER
5 → vessels
vessel_document_id
INTEGER
46 → vessel_documents
category
VARCHAR
BOP Equipment
subcategory
VARCHAR
E.2.3.1
name
VARCHAR
Ram Type Preventer
description
TEXT
Make: Hydril; Model: 19/14 and 14/14; Qty: 2
attributes
JSON
{"make": "Hydril", "model": "19/14 and 14/14", "type": "Subsea ram BOP body", "quantity": 2, "spec_1": "Bore 18-3/4\"", "spec_2": "working pressure 10,000 psi", "spec_3": "double", "spec_4": "MPL ram locks", "spec_5": "top connection 18-3/4\" x 10K API studded with studs and nuts, BX164 ring groove", "spec_6": "bottom API flange 18-3/4\" x 10K BX164", "spec_7": "side outlets 3-1/16\" API studded with BX154", "spec_8": "models 19/14 on upper body and 14/14 on lower body"}
remarks
TEXT
null
verification_status
ENUM
NOT_VERIFIED
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-08-21T09:06:52.077504
updated_at
TIMESTAMP
2026-08-21T09:06:52.077509
promoted_material_id
INTEGER
null
source_pages
JSON
[53]
source_type
VARCHAR
csv
raw_text
TEXT
p. 53 / E.2.3 Ram Type Preventers
make
VARCHAR
Hydril
model
VARCHAR
19/14 and 14/14