iadc_discovered_materials #403

id
INTEGER
403
vessel_id
INTEGER
3 → vessels
vessel_document_id
INTEGER
4 → vessel_documents
category
VARCHAR
Drill String
subcategory
VARCHAR
D.1.6
name
VARCHAR
Heavy Weight Drill Pipe (HWDP)
description
TEXT
Make: Generic / N/A; Qty: 30
attributes
JSON
{"make": "Generic / N/A", "type": "Tubular - 5\"", "quantity": 30, "spec_1": "OD 5\"", "spec_2": "Weight 50.08 lb/ft", "spec_3": "Range 2", "spec_4": "Tool joint OD/ID 6-5/8\"/3\"", "spec_5": "Pin Chrome hardfacing", "spec_6": "Internally plastic coated", "spec_7": "Connection TM2-50", "spec_8": "Thread protectors"}
remarks
TEXT
null
verification_status
ENUM
NOT_VERIFIED
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-05-21T04:10:52.822994
updated_at
TIMESTAMP
2026-05-21T04:10:52.822997
promoted_material_id
INTEGER
null
source_pages
JSON
null
source_type
VARCHAR
csv
raw_text
TEXT
null
make
VARCHAR
Generic / N/A
model
VARCHAR
null