StaffPermissions
| 📊 Overview: 5 Fields | 1 Indexes | 2 Many-to-One Relations |
📝 Description
🗨️ Security junction table assigning permissions to staff members. Links Staff to Permissions defining individual user access rights.
- Table ID: 88
- UUID: EBD332232B7BEB469977E8DB6898D40F
- Primary Key: 🔑
ID - Generated: 🕐 2025-12-04T14:34:50Z
📑 Table of Contents
📋 Fields
| Field | Type | Constraints | Description |
| 🔑 ID | Long Integer | 🔑 PK, ✨ Unique, ⚡ Auto | - |
| StaffID | Long Integer | 🚫 Not Null | - |
| PermissionID | Long Integer | 🚫 Not Null | - |
| HasPermission | Boolean | 🚫 Not Null | - |
| LastModified | String (255) | 🚫 Not Null | - |
🔍 Indexes
| Field | Type | Kind | Unique |
ID | Keywords | regular | ✨ Yes |
🔗 Many-to-One Relations
| Relation Name | Destination Table | Source → Destination | State | Description |
PermissionsEntity | Permissions | PermissionID → ID | Active | - |
StaffEntity | Staff | StaffID → StaffID | Active | - |
Generated from catalog.4DCatalog Generated at: 2025-12-04T14:34:50Z