iadc_discovered_materials #14006

id
INTEGER
14006
vessel_id
INTEGER
5 → vessels
vessel_document_id
INTEGER
46 → vessel_documents
category
VARCHAR
Drill String
subcategory
VARCHAR
D.1.7.2
name
VARCHAR
Drill Collar
description
TEXT
Qty: 24
attributes
JSON
{"type": "8\" spiral drill collar", "quantity": 24, "spec_1": "OD body 8\"", "spec_2": "ID body 2-13/16\"", "spec_3": "nominal joint length 31 ft", "spec_4": "spiral", "spec_5": "recess for zip elevator and slips", "spec_6": "stress relief pin groove", "spec_7": "boreback box", "spec_8": "connection 6-5/8\" REG"}
remarks
TEXT
null
verification_status
ENUM
NOT_VERIFIED
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-08-21T09:06:57.205026
updated_at
TIMESTAMP
2026-08-21T09:06:57.205031
promoted_material_id
INTEGER
null
source_pages
JSON
[28]
source_type
VARCHAR
csv
raw_text
TEXT
p. 28 / D.1.7 Drill Collars
make
VARCHAR
null
model
VARCHAR
null