spprincipal

Table info.

Title Sp Principal
Description Sp Principal

Fields

Name Type Required Index Hidden On form Title Pick list Description
SpPrincipalID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
GroupSubClass varchar(255) Group Sub Class groupSubClass
groupType varchar(32) Group Type groupType
Name varchar(64) Name name
Priority tinyint(4) Priority priority
Remarks text Remarks remarks
CreatedByAgentID int(11) MUL
ModifiedByAgentID int(11) MUL
userGroupScopeID int(11)

Indexes

Name Fields Unique Nullable
FK56DC3A715327F942 ModifiedByAgentID
FK56DC3A717699B003 CreatedByAgentID
PRIMARY SpPrincipalID

One-to-many relationships

Name Field Related table Related field
FK3B38A27199A7381A SpPrincipalID recordset SpPrincipalID
FK96F9D2B299A7381A SpPrincipalID spappresource SpPrincipalID
FK81E18B5E99A7381A SpPrincipalID specifyuser_spprincipal SpPrincipalID
FK9DD8B2FA99A7381A SpPrincipalID spprincipal_sppermission SpPrincipalID
FK41238DBF99A7381A SpPrincipalID workbench SpPrincipalID

Many-to-one relationships

Name Field Related table Related field
FK56DC3A715327F942 ModifiedByAgentID agent AgentID
FK56DC3A717699B003 CreatedByAgentID agent AgentID