iadc_discovered_materials #17706

id
INTEGER
17706
vessel_id
INTEGER
16 → vessels
vessel_document_id
INTEGER
54 → vessel_documents
category
VARCHAR
Drill String
subcategory
VARCHAR
D.3.1
name
VARCHAR
Overshot
description
TEXT
Make: Cooper; Qty: 1
attributes
JSON
{"make": "Cooper", "type": "Series 150 complete overshot, 11.25 inch OD", "quantity": 1, "spec_1": "Catch size 9.5 inch to 5 inch", "spec_2": "extension sub 36 inch", "spec_3": "spiral & basket grapples", "spec_4": "pack-offs 9.5 inch type A and 5 - 8.25 inch basket type", "spec_5": "top sub 6-5/8 Reg box"}
remarks
TEXT
null
verification_status
ENUM
NOT_VERIFIED
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-10-05T11:08:06.495359
updated_at
TIMESTAMP
2026-10-05T11:08:06.495366
promoted_material_id
INTEGER
null
source_pages
JSON
[34]
source_type
VARCHAR
csv
raw_text
TEXT
p.34 / D.3.1 Overshots
make
VARCHAR
Cooper
model
VARCHAR
null