GroupUser
The GroupUser table associates Users with Groups. Each record defines an association between one Group and one User. Users may only be associated with Groups that belong to their Firm.
- Section: Actors
Metadata
- Base Table Class: Static
- Default Size: Group * Constants::MaxActorsPerGroup = 2500000
Fields
| Name | Type | Size (bytes) | Description |
|---|---|---|---|
| Id | Integer (signed) | 8 | The unique identifier of this GroupUser. |
| Status | Set of Status | 4 | |
| Group | Foreign key to Group | 8 | |
| User | Foreign key to User | 8 | |
| UpdateNumber | Integer (unsigned) | 8 | A number that records every change that happens to a record. It is primarily used to avoid write after read problems when an intermediate write has changed the originally read record. |
| OwnerUser | Foreign key to User | 8 | The Id of the User that owns this GroupUser. |
| OwnerGroup | Foreign key to Group | 8 | The Id of the Group that owns this GroupUser. |
| OwnerFirm | Foreign key to Firm | 8 | The Id of the Firm that owns this GroupUser. |
| CreateUser | Foreign key to User | 8 | The Id of the User that created this GroupUser. |
| CreateTimestamp | Integer (unsigned) | 8 | The time at which this GroupUser was created. |
| UpdateUser | Foreign key to User | 8 | The Id of the User that last updated this GroupUser. |
| UpdateTimestamp | Integer (unsigned) | 8 | The time at which this GroupUser was last updated. |