Edit #1979 — iadc_discovered_materials

id

INTEGER · required

Auto-generated

vessel_id

INTEGER · required

vessel_document_id

INTEGER

category

VARCHAR(150)

subcategory

VARCHAR(150)

name

VARCHAR(200) · required

description

TEXT

attributes

JSON

{"make": "Hydril / Vetco / EEC / CIW", "type": "Subsea BOP", "quantity": 1, "spec_1": "Size 18-3/4\" ID", "spec_2": "WP 10,000 psi", "spec_3": "H2S service", "spec_4": "Includes guide frame, pickup attachment, transport base", "spec_5": "Vetco H4 E Studded Top 18-3/4\" 10K Hydraulic Wellhead Connector with primary and secondary unlock", "spec_6": "Alternate connector Vetco 16-3/4\" DxE 10,000 psi API flange-up available", "spec_7": "Vetco H4 ExF 18-3/4\" Mandrel", "spec_8": "Bottom-up stack: Top Blind/Shear, Middle Upper VBR 3-1/2\"x5-1/2\", Middle Lower VBR 4-1/2\"x7\", Lower 5-1/2\" or 5\" pipe (21.38\" middle-lower spacing)", "spec_9": "Hydril Compact ram BOPs (2 Doubles, models 19/14 upper body and 14/14 lower body, MPL ram locks, 18-3/4\" x 10K API studded with BX164 ring groove)", "spec_10": "Pipe rams 5-1/2\" (2 sets) and 5\" (2 sets)", "spec_11": "Blind/Shear rams (2 sets) rated for 5-1/2\" DP 21.9 lb/ft S and 9-5/8\" 53.5 lb/ft P110 casing", "spec_12": "Variable rams 3-1/2\"-5-1/2\" (2 sets) and 4-1/2\"-7\" (2 sets)", "spec_13": "Side outlets 3-1/16\" API studded BX-154", "spec_14": "EEC fail-safe valves 3-1/16\" 10K (5 double block + 1 gas bleed + 2 isolators per side)", "spec_15": "40 subsea accumulators 15 gal each, 5,000 psi bottle, 1,450 psi pre-charge", "spec_16": "2 hydraulic control pods (Hydril, 100% redundancy, color coded, no spare)"}

remarks

TEXT

verification_status

VARCHAR(19) · required

is_active

BOOLEAN · required

created_at

TIMESTAMP · required

updated_at

TIMESTAMP · required

promoted_material_id

INTEGER

source_pages

JSON

source_type

VARCHAR(20)

raw_text

TEXT

make

VARCHAR(200)

model

VARCHAR(200)

Edit row #1979 in iadc_discovered_materials