MachineOEE
| 📊 Overview: 13 Fields | 3 Indexes |
📝 Description
🗨️ Analytics table calculating Overall Equipment Effectiveness metrics. Tracks availability, performance, and quality for production equipment.
- Table ID: 89
- UUID: EDFCD4019448A2478EF7BDE89DD8498C
- Primary Key: 🔑
ID - Generated: 🕐 2025-12-04T14:34:51Z
📑 Table of Contents
📋 Fields
| Field | Type | Constraints | Description |
| 🔑 ID | Long Integer | 🔑 PK, ✨ Unique, ⚡ Auto | - |
| ProductionDate | Date | 🚫 Not Null | - |
| WorksOrder | Long Integer | 🚫 Not Null | - |
| Availability | Real | 🚫 Not Null | - |
| Performance | Real | 🚫 Not Null | - |
| Quality | Real | 🚫 Not Null | - |
| OEE | Real | 🚫 Not Null | - |
| GoodTime | Real | 🚫 Not Null | - |
| PlannedTime | Real | 🚫 Not Null | - |
| TargetTime | Real | - | - |
| ActualTime | Real | 🚫 Not Null | - |
| TotalPacked | Integer | - | - |
| TotalMade | Integer | 🚫 Not Null | - |
🔍 Indexes
| Field | Type | Kind | Unique |
WorksOrder | Keywords | regular | - |
ProductionDate | Keywords | regular | - |
ID | Keywords | regular | ✨ Yes |
Generated from catalog.4DCatalog Generated at: 2025-12-04T14:34:51Z