DownReasons
| 📊 Overview: 5 Fields | 3 Indexes | 2 One-to-Many Relations |
📝 Description
🗨️ Lookup table defining machine downtime reason codes. Used to categorize and analyze production stoppages (breakdown, changeover, maintenance, etc.).
ℹ️ Table Information
- Table ID: 64
- UUID: 223300B659C4B94286C058AC2F0A57CC
- Primary Key: 🔑
ID - Generated: 🕐 2025-12-04T14:34:26Z
📑 Table of Contents
- 📋 Fields (5)
- 🔍 Indexes (3)
- 🔗 One-to-Many Relations (2)
- 🔗 Related Items
- Forms (3)
📋 Fields
| Field | Type | Constraints | Description |
|---|---|---|---|
| 🔑 ID | Long Integer | 🔑 PK, ✨ Unique, ⚡ Auto | - |
| Category | String (255) | 🚫 Not Null | - |
| Reason | String (255) | 🚫 Not Null | - |
| Exclude | Boolean | 🚫 Not Null | - |
| Archive | Boolean | 🚫 Not Null | - |
🔍 Indexes
| Field | Type | Kind | Unique |
|---|---|---|---|
ID | Keywords | regular | ✨ Yes |
Archive | Keywords | regular | - |
Exclude | Keywords | regular | - |
🔗 One-to-Many Relations
| Relation Name | Source Table | Source → Destination | State | Description |
|---|---|---|---|---|
RealTimeSelection | RealTime | DownReason → ID | Active | - |
RealTimeMachinesSelection | RealTimeMachines | DownReason → ID | Active | - |
🔗 Related Items
📄 Forms
- CurrentDownTime - Data source for CurrentDownTime form
- DownTime - Data source for DownTime form
- RTSUM - Data source for RTSUM form
Generated from catalog.4DCatalog Generated at: 2025-12-04T14:34:26Z