iadc_discovered_materials #400

id
INTEGER
400
vessel_id
INTEGER
3 → vessels
vessel_document_id
INTEGER
4 → vessel_documents
category
VARCHAR
Drill String
subcategory
VARCHAR
D.1.3
name
VARCHAR
Drill Pipe 6-5/8" 0.813 Wall
description
TEXT
Make: Grade; Model: VM-140; Qty: 8379
attributes
JSON
{"make": "Grade", "model": "VM-140", "type": "Tubular - 6-5/8\"", "quantity": 8379, "spec_1": "OD 6-5/8\"", "spec_2": "Wall 0.813\"", "spec_3": "Total length 8,379 ft", "spec_4": "Range 2", "spec_5": "Adjusted weight 60.69 lb/ft", "spec_6": "Internally plastic coated", "spec_7": "Tool joint OD/ID 8-3/4\"/3-1/2\"", "spec_8": "Pin length 10\"", "spec_9": "Box length 13\"", "spec_10": "Tapered shoulder", "spec_11": "Connection 6-5/8\" FH", "spec_12": "Pin Chrome hardfacing", "spec_13": "API Premium", "spec_14": "Thread protectors"}
remarks
TEXT
null
verification_status
ENUM
NOT_VERIFIED
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-05-21T04:10:52.772594
updated_at
TIMESTAMP
2026-05-21T04:10:52.772597
promoted_material_id
INTEGER
null
source_pages
JSON
null
source_type
VARCHAR
csv
raw_text
TEXT
null
make
VARCHAR
Grade
model
VARCHAR
VM-140