spqueryfield

Table info.

Title Sp Query Field
Description Sp Query Field

Fields

Name Type Required Index Hidden On form Title Pick list Description
SpQueryFieldID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
AlwaysFilter bit(1) Always Filter alwaysFilter
ColumnAlias varchar(64) Column Alias columnAlias
ContextTableIdent int(11) Context Table Ident contextTableIdent
EndValue varchar(1000) End Value endValue
FieldName varchar(32) Field Name fieldName
FormatName varchar(64) Format Name formatName
IsDisplay bit(1) Is Display isDisplay
IsNot bit(1) Is Not isNot
IsPrompt bit(1) Is Prompt isPrompt
IsRelFld bit(1) Is Rel Fld isRelFld
OperEnd tinyint(4) Oper End operEnd
OperStart tinyint(4) Oper Start operStart
Position smallint(6) Position position
SortType tinyint(4) Sort Type sortType
StartValue varchar(1000) Start Value startValue
StringId text String Id stringId
TableList text Table List tableList
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL
SpQueryID int(11) MUL
AllowNulls bit(1) Allow Nulls allowNulls

Indexes

Name Fields Unique Nullable
FK8F33434F5327F942 ModifiedByAgentID
FK8F33434F7699B003 CreatedByAgentID
FK8F33434FB273544E SpQueryID
PRIMARY SpQueryFieldID

One-to-many relationships

Name Field Related table Related field
FKCD08A1E92D3E491C SpQueryFieldID spexportschemaitemmapping SpQueryFieldID

Many-to-one relationships

Name Field Related table Related field
FK8F33434F5327F942 ModifiedByAgentID agent AgentID
FK8F33434F7699B003 CreatedByAgentID agent AgentID
FK8F33434FB273544E SpQueryID spquery SpQueryID