iadc_discovered_materials #13118

id
INTEGER
13118
vessel_id
INTEGER
6 → vessels
vessel_document_id
INTEGER
45 → vessel_documents
category
VARCHAR
BOP Equipment
subcategory
VARCHAR
E.5.2
name
VARCHAR
Annular type preventer
description
TEXT
Make: NOV; Model: Shaffer - Dual Wedge Cover; Qty: 2
attributes
JSON
{"make": "NOV", "model": "Shaffer - Dual Wedge Cover", "type": "Secondary LMRP, dual annular", "quantity": 2, "spec_1": "Size 18-3/4 in", "spec_2": "working pressure 5,000 psi"}
remarks
TEXT
null
verification_status
ENUM
NOT_VERIFIED
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-08-21T08:24:04.523978
updated_at
TIMESTAMP
2026-08-21T08:24:04.523984
promoted_material_id
INTEGER
null
source_pages
JSON
[59]
source_type
VARCHAR
csv
raw_text
TEXT
p. 59 - E.5.2 Annular Type Preventer (LMRP)
make
VARCHAR
NOV
model
VARCHAR
Shaffer - Dual Wedge Cover