equipment
Core TableEquipment & Assets
Asset registry of equipment including classifications, criticality, warranties and lifecycle data.
Primary Key
equipment_code
Record Type
Operational
Log Tables
equipment_log, equipment_survey_log
Summary Views
monthly_equipment_summary
Last Updated
May 20, 2026
AI Usefulness
4.8
/ 5.0
High value for AI analytics, prediction and automation.
All (7)Key (1)Calculated (2)
| Field Code | Caption | Data Type | Length | PK | Calculated | Description |
|---|---|---|---|---|---|---|
| equipment_code | Equipment Code | Varchar | 50 | — | Unique code for each equipment. | |
| equipment_name | Equipment Name | Varchar | 255 | — | — | Name of the equipment. |
| equipment_type_code | Equipment Type Code | Varchar | 50 | — | — | Reference to equipment_type table. |
| equipment_category_code | Equipment Category Code | Varchar | 50 | — | — | Reference to equipment_category table. |
| manufacturer | Manufacturer | Varchar | 255 | — | — | Manufacturer of the equipment. |
| install_date | Install Date | Date | — | — | — | Date equipment was installed. |
| status_code | Status Code | Varchar | 50 | — | — | Current operational status. |
Showing 7 of 7 (52 total in schema)
Relationships (Links to)
- building N:1Equipment located in a building.
- space N:1Equipment located in a space.
- equipment_type N:1Equipment classification.
- manufacturer N:1Manufacturer reference.
Operational Meaning
Single source of truth for every asset. Drives PM scheduling, failure analysis, warranty tracking and capital planning.
AI Opportunities
- Predictive maintenance & failure forecasting
- Lifecycle and replacement optimization
- Energy consumption modeling
- Criticality-based prioritization
Suggested Queries
- "List equipment with more than 3 corrective maintenance tasks in the last 90 days."
- "Which equipment is within 6 months of warranty expiry?"
- "Rank equipment by MTBF over the last year."