spreport

Table info.

Title Sp Report
Description Sp Report

Fields

Name Type Required Index Hidden On form Title Pick list Description
SpReportId int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
Name varchar(64) MUL Name name
Remarks text Remarks remarks
RepeatCount int(11) Repeat Count repeatCount
RepeatField varchar(255) Repeat Field repeatField
SpecifyUserID int(11) MUL
ModifiedByAgentID int(11) MUL
AppResourceID int(11) MUL
CreatedByAgentID int(11) MUL
SpQueryID int(11) MUL
WorkbenchTemplateID int(11) MUL

Indexes

Name Fields Unique Nullable
FK972D69D12774AC79 AppResourceID
FK972D69D14BDD9E10 SpecifyUserID
FK972D69D15327F942 ModifiedByAgentID
FK972D69D17699B003 CreatedByAgentID
FK972D69D17F5EBA2A WorkbenchTemplateID
FK972D69D1B273544E SpQueryID
PRIMARY SpReportId
SpReportNameIDX Name

Many-to-one relationships

Name Field Related table Related field
FK972D69D12774AC79 AppResourceID spappresource SpAppResourceID
FK972D69D14BDD9E10 SpecifyUserID specifyuser SpecifyUserID
FK972D69D15327F942 ModifiedByAgentID agent AgentID
FK972D69D17699B003 CreatedByAgentID agent AgentID
FK972D69D17F5EBA2A WorkbenchTemplateID workbenchtemplate WorkbenchTemplateID
FK972D69D1B273544E SpQueryID spquery SpQueryID