UserGroup
M:n relation between User and Group tables.
erDiagram
Group ||--o{ UserGroup : "GroupID"
User ||--o{ UserGroup : "UserID"
Fields
| Field |
Type |
Description |
| Created |
datetime |
Date/Time this relation was created in the database |
| GroupID |
numeric |
Internal ID that references the Group entity (Foreign Key) |
| ID |
numeric |
Internal ID for the UserGroup entity (Primary Key) |
| LastScan |
datetime |
Date/Time this relation was last scanned |
| UserID |
numeric |
Internal ID that references the User entity (Foreign Key) |
References
| Column Name |
Referenced Table |
Description |
| GroupID |
Group |
Group of users or machines |
| UserID |
User |
Basic user Information |