Staff
| 📊 Overview: 20 Fields | 1 Indexes | 10 One-to-Many Relations |
📝 Description
🗨️ Master data table for employees and system users. Stores staff details, roles, permissions, and login credentials. Links to production activities, approvals, and audit trails.
ℹ️ Table Information
- Table ID: 42
- UUID: 34740841F2B0904CA92D155632F47E87
- Primary Key: 🔑
StaffID - Generated: 🕐 2025-12-04T14:34:06Z
📑 Table of Contents
- 📋 Fields (20)
- 🔍 Indexes (1)
- 🔗 One-to-Many Relations (10)
- 🔗 Related Items
📋 Fields
| Field | Type | Constraints | Description |
|---|---|---|---|
String (255) | 🚫 Not Null | - | |
| FirstName | String (255) | 🚫 Not Null | - |
| LastName | String (255) | 🚫 Not Null | - |
| PrintAs | String (255) | 🚫 Not Null | - |
| FobID | String (255) | 🚫 Not Null | - |
| AccountAD | String (255) | 🚫 Not Null | - |
| SelfApprovalLimit | Real | 🚫 Not Null | - |
| WorkRequestEmail | String (255) | - | - |
| Account4D | String (255) | 🚫 Not Null | - |
| SharedAccount | Boolean | 🚫 Not Null | - |
| Code | String (255) | 🚫 Not Null | - |
| 🔑 StaffID | Long Integer | 🔑 PK, ✨ Unique, ⚡ Auto, 🚫 Not Null | - |
| Stock | Boolean | 🚫 Not Null | - |
| UserID | String (255) | 🚫 Not Null | - |
| Archive | Boolean | 🚫 Not Null | - |
| PO_Approval | Boolean | 🚫 Not Null | - |
| Mobile | String (255) | 🚫 Not Null | - |
| PasswordHash | String (255) | 🚫 Not Null | - |
| PersonalEmail | String (255) | 🚫 Not Null | - |
| MobileKeyfob | String (255) | - | - |
🔍 Indexes
| Field | Type | Kind | Unique |
|---|---|---|---|
StaffID | Keywords | regular | ✨ Yes |
🔗 One-to-Many Relations
| Relation Name | Source Table | Source → Destination | State | Description |
|---|---|---|---|---|
StaffPermissionsSelection | StaffPermissions | StaffID → StaffID | Active | - |
DB_VariablesSelection | Settings | StaffID → StaffID | Active | - |
WorkRequestCommentsSelection | WorkRequestComments | StaffID → StaffID | Active | - |
RealTimeSensorExceptionsSelection | RealTimeSensorExceptions | StaffID → StaffID | Active | - |
ToolTemperatureTargetSelection | ToolTemperatureTarget | StaffID → StaffID | Active | - |
PrintJobSelection | PrintJob | StaffID → StaffID | Active | - |
ShiftSummarySelection | ShiftSummary | StaffID → StaffID | Active | - |
StatusUpdatedBoxLabelsSelection | BoxLabels | StatusUpdatedStaffID → StaffID | Active | - |
ToolNoticeSelection | ToolNotice | StaffID → StaffID | Active | - |
DeactivatedToolNoticeSelection | ToolNotice | DeactivatedStaffID → StaffID | Active | - |
🔗 Related Items
📦 Classes
- Staff - ORDA DataClass class for Staff table
- StaffEntity - ORDA Entity class for Staff table
📄 Forms
- AddWorkRequest - Data source for AddWorkRequest form
- ConfirmOrderDates - Data source for ConfirmOrderDates form
- LabelPrinting - Data source for LabelPrinting form
- Manufacture - Data source for Manufacture form
- MaterialCalendar - Data source for MaterialCalendar form
- MaterialCheck - Data source for MaterialCheck form
- NewScrapEntry - Data source for NewScrapEntry form
- PermissionManager - Data source for PermissionManager form
- PurchaseOrders - Data source for PurchaseOrders form
- ShiftSummaries - Data source for ShiftSummaries form
- Staff - Data source for Staff form
- StaffLogin - Data source for StaffLogin form
- StaffMessaging - Data source for StaffMessaging form
- ToolMaintenanceLog - Data source for ToolMaintenanceLog form
- ToolManager - Data source for ToolManager form
Generated from catalog.4DCatalog Generated at: 2025-12-04T14:34:06Z