workbenchtemplate

Table info.

Title WorkBench Template
Description WorkBench Template

Fields

Name Type Required Index Hidden On form Title Pick list Description
WorkbenchTemplateID int(11) PRI
TimestampCreated datetime Timestamp Created The timestamp the record was created.
TimestampModified datetime Timestamp Modified The timestamp the record was last modified.
Version int(11) Version version
Name varchar(64) Name name
Remarks text Remarks Additional Comments
SrcFilePath varchar(255) Source File Path srcFilePath
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL
SpecifyUserID int(11) MUL

Indexes

Name Fields Unique Nullable
FK6F902B394BDD9E10 SpecifyUserID
FK6F902B395327F942 ModifiedByAgentID
FK6F902B397699B003 CreatedByAgentID
PRIMARY WorkbenchTemplateID

One-to-many relationships

Name Field Related table Related field
FK972D69D17F5EBA2A WorkbenchTemplateID spreport WorkbenchTemplateID
FK41238DBF7F5EBA2A WorkbenchTemplateID workbench WorkbenchTemplateID
FK7D6D44087F5EBA2A WorkbenchTemplateID workbenchtemplatemappingitem WorkbenchTemplateID

Many-to-one relationships

Name Field Related table Related field
FK6F902B394BDD9E10 SpecifyUserID specifyuser SpecifyUserID
FK6F902B395327F942 ModifiedByAgentID agent AgentID
FK6F902B397699B003 CreatedByAgentID agent AgentID