iadc_discovered_materials #2086

id
INTEGER
2086
vessel_id
INTEGER
5 → vessels
vessel_document_id
INTEGER
12 → vessel_documents
category
VARCHAR
Drill String
subcategory
VARCHAR
D.2.7
name
VARCHAR
Drill Collar Safety Clamp
description
TEXT
Make: B+V Type C; Qty: 4
attributes
JSON
{"make": "B+V Type C", "type": "Handling Tool", "quantity": 4, "spec_1": "Range coverage: 6-1/2\" to 7-5/8\" (2 units), 7-1/2\" to 8-5/8\" (1 unit), 9-1/2\" to 10-5/8\" (1 unit)"}
remarks
TEXT
null
verification_status
ENUM
NOT_VERIFIED
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-04-30T14:20:49.866175
updated_at
TIMESTAMP
2026-04-30T14:20:49.866178
promoted_material_id
INTEGER
null
source_pages
JSON
null
source_type
VARCHAR
csv
raw_text
TEXT
null
make
VARCHAR
B+V Type C
model
VARCHAR
null