iadc_discovered_materials #1327

id
INTEGER
1327
vessel_id
INTEGER
4 → vessels
vessel_document_id
INTEGER
9 → vessel_documents
category
VARCHAR
Drilling Equipment
subcategory
VARCHAR
B.1.1
name
VARCHAR
Derrick (Dual Activity)
description
TEXT
Make: NOV; Qty: 1
attributes
JSON
{"make": "NOV", "type": "Drilling Mast with Crown Access and Lighting", "quantity": 1, "spec_1": "Dual Activity design", "spec_2": "253 ft TOS to gin pole", "spec_3": "220 ft TOS to derrick top", "spec_4": "80x80 ft base", "spec_5": "2,500,000 lb gross capacity each side (Fwd and Aft)", "spec_6": "rated 60 knots wind with full setback / 100 knots no setback", "spec_7": "max 12 lines (14 with crown reeving)", "spec_8": "ladders with safety cages", "spec_9": "crown sheave platform", "spec_10": "explosion proof lighting"}
remarks
TEXT
null
verification_status
ENUM
NOT_VERIFIED
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-04-30T11:28:53.271679
updated_at
TIMESTAMP
2026-04-30T11:28:53.271682
promoted_material_id
INTEGER
null
source_pages
JSON
null
source_type
VARCHAR
csv
raw_text
TEXT
null
make
VARCHAR
NOV
model
VARCHAR
null