workbench

Table info.

Title WorkBench
Description WorkBench

Fields

Name Type Required Index Hidden On form Title Pick list Description
WorkbenchID 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
AllPermissionLevel int(11) All Permission Level allPermissionLevel
TableID int(11)
ExportInstitutionName varchar(128) Export Institution Name exportInstitutionName
FormId int(11) Form Id formId
GroupPermissionLevel int(11) Group Permission Level groupPermissionLevel
LockedByUserName varchar(64) Locked By User Name lockedByUserName
Name varchar(64) MUL Name name
OwnerPermissionLevel int(11) Owner Permission Level ownerPermissionLevel
Remarks text Remarks Additional Comments
SrcFilePath varchar(255) Source File Path srcFilePath
SpPrincipalID int(11) MUL
CreatedByAgentID int(11) MUL
WorkbenchTemplateID int(11) MUL
ModifiedByAgentID int(11) MUL
SpecifyUserID int(11) MUL
ExportedFromTableName varchar(128) Exported From Table Name exportedFromTableName

Indexes

Name Fields Unique Nullable
FK41238DBF4BDD9E10 SpecifyUserID
FK41238DBF5327F942 ModifiedByAgentID
FK41238DBF7699B003 CreatedByAgentID
FK41238DBF7F5EBA2A WorkbenchTemplateID
FK41238DBF99A7381A SpPrincipalID
PRIMARY WorkbenchID
WorkbenchNameIDX Name

One-to-many relationships

Name Field Related table Related field
FK486DDFBBBBCF9E96 WorkbenchID workbenchrow WorkbenchID

Many-to-one relationships

Name Field Related table Related field
FK41238DBF4BDD9E10 SpecifyUserID specifyuser SpecifyUserID
FK41238DBF5327F942 ModifiedByAgentID agent AgentID
FK41238DBF7699B003 CreatedByAgentID agent AgentID
FK41238DBF7F5EBA2A WorkbenchTemplateID workbenchtemplate WorkbenchTemplateID
FK41238DBF99A7381A SpPrincipalID spprincipal SpPrincipalID