iadc_discovered_materials #13997

id
INTEGER
13997
vessel_id
INTEGER
5 → vessels
vessel_document_id
INTEGER
46 → vessel_documents
category
VARCHAR
Drill String
subcategory
VARCHAR
D.1.3.2
name
VARCHAR
Drill Pipe
description
TEXT
Qty: 1
attributes
JSON
{"type": "5\" S-135 drill pipe", "quantity": 1, "spec_1": "Total length 3,281 ft", "spec_2": "OD 5\"", "spec_3": "grade S-135", "spec_4": "range 2", "spec_5": "weight 19.5 lbs/ft", "spec_6": "internally plastic coated", "spec_7": "tool joint OD/ID 6.625\"/3.250\"", "spec_8": "pin length 10\"", "spec_9": "tapered shoulder 18 deg/35 deg", "spec_10": "connection 4-1/2\" IF", "spec_11": "hardfacing Armacor M 3\"", "spec_12": "API Premium"}
remarks
TEXT
null
verification_status
ENUM
NOT_VERIFIED
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-08-21T09:06:56.774266
updated_at
TIMESTAMP
2026-08-21T09:06:56.774272
promoted_material_id
INTEGER
null
source_pages
JSON
[26]
source_type
VARCHAR
csv
raw_text
TEXT
p. 26 / D.1.3 Drill Pipe
make
VARCHAR
null
model
VARCHAR
null