iadc_discovered_materials #18515

id
INTEGER
18515
vessel_id
INTEGER
17 → vessels
vessel_document_id
INTEGER
55 → vessel_documents
category
VARCHAR
Drilling Equipment
subcategory
VARCHAR
B.1
name
VARCHAR
Derrick and Substructure
description
TEXT
Make: Derrick International; Model: D1,400-4D; Qty: 1
attributes
JSON
{"make": "Derrick International", "model": "D1,400-4D", "type": "Derrick, 185 ft", "quantity": 1, "spec_1": "185 ft derrick height", "spec_2": "base 40 ft x 40 ft", "spec_3": "water table 18 ft x 18 ft", "spec_4": "gross nominal capacity 1,400,000 lb", "spec_5": "max 14 lines", "spec_6": "no personnel elevator", "spec_7": "ladders with safety cages", "spec_8": "crown sheave access platform", "spec_9": "counterbalance system for tongs and spinner", "spec_10": "lighting not explosion proof (as printed)"}
remarks
TEXT
null
verification_status
ENUM
NOT_VERIFIED
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-10-05T11:17:51.148845
updated_at
TIMESTAMP
2026-10-05T11:17:51.148851
promoted_material_id
INTEGER
null
source_pages
JSON
[11]
source_type
VARCHAR
csv
raw_text
TEXT
p.11 / B.1 Derrick and Substructure
make
VARCHAR
Derrick International
model
VARCHAR
D1,400-4D