iadc_discovered_materials #360

id
INTEGER
360
vessel_id
INTEGER
3 → vessels
vessel_document_id
INTEGER
4 → vessel_documents
category
VARCHAR
BOP Equipment
subcategory
VARCHAR
E.6.1
name
VARCHAR
Marine Riser Joint
description
TEXT
Make: Shaffer Class G FT-G-B (X-80); Qty: 28
attributes
JSON
{"make": "Shaffer Class G FT-G-B (X-80)", "type": "Riser System", "quantity": 28, "spec_1": "Rating 3,000,000 lb FT-G-B", "spec_2": "OD 21\" nominal", "spec_3": "ID 19-3/8\"", "spec_4": "Wall 13/16\"", "spec_5": "Average length 75 ft", "spec_6": "Weight 29,425 lbs slick (in air)", "spec_7": "Pipe material 5L X-80 Seamed", "spec_8": "Bolted Flange riser connectors"}
remarks
TEXT
null
verification_status
ENUM
NOT_VERIFIED
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-05-21T04:10:52.121452
updated_at
TIMESTAMP
2026-05-21T04:10:52.121455
promoted_material_id
INTEGER
null
source_pages
JSON
null
source_type
VARCHAR
csv
raw_text
TEXT
null
make
VARCHAR
Shaffer Class G FT-G-B (X-80)
model
VARCHAR
null