Group

A Group is an entity that belongs to a Firm and to which Users in the Firm may be associated (via the GroupUser table). A Group may be assigned a set of Permissions which will be inherited by all Users that are members of the Group. See the document Permissions and Access control for more details.

Section: Actors

Metadata

Base Table Class: Static
Default Size: Firm * Constants::MaxGroupsPerFirm = 2500

Fields

Name	Type	Size (bytes)	Description
Id	Integer (signed)	8	The unique identifier of this Group. Not editable Read-only
Status	Set of Status	4
Firm	Foreign key to Firm	8	The Firm to which the Group belongs. Only Users from that Firm may be associated with the Group. Required Not editable
Name	String	48	The long text identifier of this Group. Required
ShortName	String	24	The short text identifier of this Group. Required
PermissionGroup	Foreign key to PermissionGroup	8	(Optional) permission group that defines a base collection of permissions applied to this Group.
IndexInFirm	Integer (unsigned)	2	Not editable Read-only
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. Not editable
OwnerUser	Foreign key to User	8	The Id of the User that owns this Group.
OwnerGroup	Foreign key to Group	8	The Id of the Group that owns this Group.
OwnerFirm	Foreign key to Firm	8	The Id of the Firm that owns this Group.
CreateUser	Foreign key to User	8	The Id of the User that created this Group. Not editable Read-only
CreateTimestamp	Integer (unsigned)	8	The time at which this Group was created. Not editable Read-only
UpdateUser	Foreign key to User	8	The Id of the User that last updated this Group. Not editable Read-only
UpdateTimestamp	Integer (unsigned)	8	The time at which this Group was last updated. Not editable Read-only

Foreign Keys

The following diagram shows the tables that have a foreign key link to the Group table. All Table nodes can be clicked to take you to that table's definition page.

graph LR;
	GroupUser-->|Group|Group
	click GroupUser "/marketgrid/developer/model/tables/GroupUser"
	Permission-->|Group|Group
	click Permission "/marketgrid/developer/model/tables/Permission"
	RFQRecipient-->|Group|Group
	click RFQRecipient "/marketgrid/developer/model/tables/RFQRecipient"