spappresourcedir

Table info.

Title App Resource Default
Description App Resource Default

Fields

Name Type Required Index Hidden On form Title Pick list Description
SpAppResourceDirID 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
DisciplineType varchar(64) MUL Discipline Type disciplineType
IsPersonal bit(1) Is Personal isPersonal
UserType varchar(64) User Group userType
DisciplineID int(11) MUL
CreatedByAgentID int(11) MUL
ModifiedByAgentID int(11) MUL
CollectionID int(11) MUL
SpecifyUserID int(11) MUL

Indexes

Name Fields Unique Nullable
FK3A2F5C9B4BDD9E10 SpecifyUserID
FK3A2F5C9B4CE675DE DisciplineID
FK3A2F5C9B5327F942 ModifiedByAgentID
FK3A2F5C9B7699B003 CreatedByAgentID
FK3A2F5C9B8C2288BA CollectionID
PRIMARY SpAppResourceDirID
SpAppResourceDirDispTypeIDX DisciplineType

One-to-many relationships

Name Field Related table Related field
FK96F9D2B21A0B1F14 SpAppResourceDirID spappresource SpAppResourceDirID
FK5FA666571A0B1F14 SpAppResourceDirID spviewsetobj SpAppResourceDirID

Many-to-one relationships

Name Field Related table Related field
FK3A2F5C9B4BDD9E10 SpecifyUserID specifyuser SpecifyUserID
FK3A2F5C9B4CE675DE DisciplineID discipline UserGroupScopeId
FK3A2F5C9B5327F942 ModifiedByAgentID agent AgentID
FK3A2F5C9B7699B003 CreatedByAgentID agent AgentID
FK3A2F5C9B8C2288BA CollectionID collection UserGroupScopeId