WorkRequests
| 📊 Overview: 18 Fields | 4 Indexes | 1 Many-to-One Relations | 2 One-to-Many Relations |
📝 Description
🗨️ Transaction table managing maintenance and repair requests for equipment and facilities. Tracks request status, priority, and assignments.
- Table ID: 65
- UUID: F442B2C4FB8A82459B54D0CF985365AB
- Primary Key: 🔑
ID - Generated: 🕐 2025-12-04T14:34:27Z
📑 Table of Contents
📋 Fields
| Field | Type | Constraints | Description |
| 🔑 ID | Long Integer | 🔑 PK, ✨ Unique, ⚡ Auto | - |
| CreatedDate | Date | 🚫 Not Null | - |
| CreatedBy | String (255) | 🚫 Not Null | - |
| FaultLocation | String (255) | 🚫 Not Null | - |
| UnitNumber | Integer | 🚫 Not Null | - |
| Priority | String (255) | 🚫 Not Null | - |
| Description | String (255) | 🚫 Not Null | - |
| CorrectiveAction | String (255) | 🚫 Not Null | - |
| TargetDate | Date | 🚫 Not Null | - |
| Cost | Real | 🚫 Not Null | - |
| Completed | Boolean | 🚫 Not Null | - |
| CompletedDate | Date | 🚫 Not Null | - |
| Category | String (255) | 🚫 Not Null | - |
| LastComment | String (255) | 🚫 Not Null | - |
| CompletedBy | String (255) | 🚫 Not Null | - |
| LastCommentTime | String (255) | 🚫 Not Null | - |
| ToolNo | String (255) | 🚫 Not Null | - |
| ToolID | Long Integer | - | - |
🔍 Indexes
| Field | Type | Kind | Unique |
ToolNo | Keywords | regular | - |
Category | Keywords | regular | - |
Completed | Keywords | regular | - |
ID | Keywords | regular | ✨ Yes |
🔗 Many-to-One Relations
| Relation Name | Destination Table | Source → Destination | State | Description |
ToolsEntity | Tools | ToolID → Tool_ID | Active | - |
🔗 One-to-Many Relations
| Relation Name | Source Table | Source → Destination | State | Description |
WorkRequestCommentsSelection | WorkRequestComments | WorkRequestID → ID | Active | - |
ToolMaintenanceLogSelection | ToolMaintenanceLog | WorkRequestID → ID | Active | - |
Generated from catalog.4DCatalog Generated at: 2025-12-04T14:34:27Z