spappresource

Table info.

Title App Resource
Description App Resource

Fields

Name Type Required Index Hidden On form Title Pick list Description
SpAppResourceID int(11) PRI
TimestampCreated datetime Timestamp Created The timestamp the record was created.
TimestampModified datetime
Version int(11) Version version
AllPermissionLevel int(11) All Permission Level allPermissionLevel
Description varchar(255) Description description
GroupPermissionLevel int(11) Group Permission Level groupPermissionLevel
Level smallint(6) Level level
MetaData varchar(255) Meta Data metaData
MimeType varchar(255) MUL Mime Type mimeType
Name varchar(64) MUL Name name
OwnerPermissionLevel int(11) Owner Permission Level ownerPermissionLevel
CreatedByAgentID int(11) MUL
SpecifyUserID int(11) MUL
ModifiedByAgentID int(11) MUL
SpPrincipalID int(11) MUL
SpAppResourceDirID int(11) MUL

Indexes

Name Fields Unique Nullable
FK96F9D2B21A0B1F14 SpAppResourceDirID
FK96F9D2B24BDD9E10 SpecifyUserID
FK96F9D2B25327F942 ModifiedByAgentID
FK96F9D2B27699B003 CreatedByAgentID
FK96F9D2B299A7381A SpPrincipalID
PRIMARY SpAppResourceID
SpAppResMimeTypeIDX MimeType
SpAppResNameIDX Name

One-to-many relationships

Name Field Related table Related field
FKBBC195C560D9D3C SpAppResourceID spappresourcedata SpAppResourceID
FK972D69D12774AC79 SpAppResourceID spreport AppResourceID

Many-to-one relationships

Name Field Related table Related field
FK96F9D2B21A0B1F14 SpAppResourceDirID spappresourcedir SpAppResourceDirID
FK96F9D2B24BDD9E10 SpecifyUserID specifyuser SpecifyUserID
FK96F9D2B25327F942 ModifiedByAgentID agent AgentID
FK96F9D2B27699B003 CreatedByAgentID agent AgentID
FK96F9D2B299A7381A SpPrincipalID spprincipal SpPrincipalID