Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(60)   The unique name of this smart query
 DESCRIPTION nvarchar(1000)   Default = '' Description of this smart query
 TVFNAME nvarchar(128)   The name of the table-valued function used to return the smart query results
 TVFPARAMETERLIST nvarchar(1000) List of the parameters the table-valued function accepts (in order)
 RECORDTYPEID uniqueidentifier   FK to RECORDTYPE
 FILTERFORMDEFINITION xml   Contains the filter form definition xml
 OUTPUTDEFINITION xml   Contains the output definition xml
 STATICPARAMETERDEFINITION xml Contains the static parameter definition xml
 PRIMARYKEYFIELD nvarchar(128)
 SMARTQUERYSPEC xml   Contains the spec xml used to create this smart query
 SECURITYUIFOLDER nvarchar(255)   Default = ''
 HASAPPUSERIDPARAM bit   Default = 0 1 if the function contains a @CURRENTAPPUSERID parameter, 0 if not
 DATEADDED datetime   Default = getdate() Indicates the date this record was added
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed
 TS timestamp   Timestamp
 TSLONG bigint (Computed) convert(bigint, TS) Numeric representation of the timestamp
 SPECUINAME nvarchar(60)   Default = '' Presentation name of the smart query used to override the smart query name for display in the application.
 UINAME nvarchar(60) (Computed)   case when len(SPECUINAME) = 0 then NAME else SPECUINAME end Name of the smart query for display in the application.
 MARTKEY nvarchar(255)
 TVFSCHEMA nvarchar(255)

Foreign Key Field Type Null Notes Description
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT

Index Name Field(s) Unique Primary Clustered
 IX_SMARTQUERYCATALOG_DATEADDED DATEADDED    
 PK_SMARTQUERYCATALOG ID  

Trigger Name Description
 TR_SMARTQUERYCATALOG_AUDIT_DELETE
 TR_SMARTQUERYCATALOG_AUDIT_UPDATE

Referenced by Field
 SMARTQUERYINSTANCE SMARTQUERYCATALOGID
 SYSTEMROLEPERM_SMARTQUERY SMARTQUERYCATALOGID

Entity-Relationship diagram of this table