spquery

Table info.

Title Sp Query
Description Sp Query

Fields

Name Type Required Index Hidden On form Title Pick list Description
SpQueryID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
ContextName varchar(64) Context Name contextName
ContextTableId smallint(6) Context Table Id contextTableId
CountOnly bit(1) Count Only countOnly
IsFavorite bit(1) Is Favorite isFavorite
Name varchar(64) MUL Name name
Ordinal smallint(6) Ordinal ordinal
Remarks text Remarks remarks
SearchSynonymy bit(1) Search Synonymy searchSynonymy
SelectDistinct bit(1) Select Distinct selectDistinct
SqlStr text Sql Str sqlStr
SpecifyUserID int(11) MUL
CreatedByAgentID int(11) MUL
ModifiedByAgentID int(11) MUL
Smushed bit(1) Smushed smushed
FormatAuditRecIds bit(1) Format Audit Rec Ids Format Audit Rec Ids

Indexes

Name Fields Unique Nullable
FK88FA7C8B4BDD9E10 SpecifyUserID
FK88FA7C8B5327F942 ModifiedByAgentID
FK88FA7C8B7699B003 CreatedByAgentID
PRIMARY SpQueryID
SpQueryNameIDX Name

One-to-many relationships

Name Field Related table Related field
FK8F33434FB273544E SpQueryID spqueryfield SpQueryID
FK972D69D1B273544E SpQueryID spreport SpQueryID

Many-to-one relationships

Name Field Related table Related field
FK88FA7C8B4BDD9E10 SpecifyUserID specifyuser SpecifyUserID
FK88FA7C8B5327F942 ModifiedByAgentID agent AgentID
FK88FA7C8B7699B003 CreatedByAgentID agent AgentID