MachineMaintenanceLog
| 📊 Overview: 7 Fields | 1 Indexes | 1 Many-to-One Relations |
📝 Description
🗨️ Transaction table recording completed maintenance activities on production equipment. Links to MachineMaintenanceActions with dates, staff, and results.
ℹ️ Table Information
- Table ID: 112
- UUID: FE5239933752004A898745F680742B25
- Primary Key: 🔑
ID - Generated: 🕐 2025-12-04T14:35:12Z
📑 Table of Contents
- 📋 Fields (7)
- 🔍 Indexes (1)
- 🔗 Many-to-One Relations (1)
- 🔗 Related Items
📋 Fields
| Field | Type | Constraints | Description |
|---|---|---|---|
| 🔑 ID | Long Integer | 🔑 PK, ✨ Unique, ⚡ Auto | - |
| Machine | Long Integer | - | - |
| MachineMaintenanceActionID | Long Integer | - | - |
| MaintenanceDate | Date | - | - |
| MaintenanceTime | Time | - | - |
| CompletedBy | String (255) | - | - |
| Comments | String (255) | - | - |
🔍 Indexes
| Field | Type | Kind | Unique |
|---|---|---|---|
ID | Keywords | regular | ✨ Yes |
🔗 Many-to-One Relations
| Relation Name | Destination Table | Source → Destination | State | Description |
|---|---|---|---|---|
MachineMaintenanceActionsEntity | MachineMaintenanceActions | MachineMaintenanceActionID → ID | Active | - |
🔗 Related Items
📦 Classes
- MachineMaintenanceLogEntity - ORDA Entity class for MachineMaintenanceLog table
📄 Forms
- MachineMaintenance - Data source for MachineMaintenance form
Generated from catalog.4DCatalog Generated at: 2025-12-04T14:35:12Z