groupperson

Table info.

Title Group Person
Description Group Person

Fields

Name Type Required Index Hidden On form Title Pick list Description
GroupPersonID int(11) PRI
TimestampCreated datetime Timestamp Created The timestamp the record was created.
TimestampModified datetime Timestamp Modified The timestamp the record was last modified.
Version int(11) Version version
OrderNumber smallint(6) MUL Order Number Members position in group; i.e. 1st, 2nd, 3rd.
Remarks text Remarks Additional Comments.
GroupID int(11) MUL
DivisionID int(11) MUL
MemberID int(11) MUL
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FK5DEB769450D2EC77 MemberID
FK5DEB76945327F942 ModifiedByAgentID
FK5DEB76947699B003 CreatedByAgentID
FK5DEB76948905F31C GroupID
FK5DEB769497C961D8 DivisionID
OrderNumber OrderNumber, GroupID
PRIMARY GroupPersonID

Many-to-one relationships

Name Field Related table Related field
FK5DEB769450D2EC77 MemberID agent AgentID
FK5DEB76945327F942 ModifiedByAgentID agent AgentID
FK5DEB76947699B003 CreatedByAgentID agent AgentID
FK5DEB76948905F31C GroupID agent AgentID
FK5DEB769497C961D8 DivisionID division UserGroupScopeId