workbenchtemplatemappingitem

Table info.

Title WorkBench Template Mapping Item
Description WorkBench Template Mapping Item

Fields

Name Type Required Index Hidden On form Title Pick list Description
WorkbenchTemplateMappingItemID 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
XCoord smallint(6) X Coordinate xCoord
YCoord smallint(6) Y Coordinate yCoord
Caption varchar(64) Caption caption
CarryForward bit(1) Carry Forward carryForward
DataFieldLength smallint(6) Data Field Length dataFieldLength
FieldName varchar(255) Field Name fieldName
FieldType smallint(6) Field Type fieldType
ImportedColName varchar(255) Imported Column Name importedColName
IsExportableToContent bit(1) Is Exportable To Content isExportableToContent
IsIncludedInTitle bit(1) Is Included In Title isIncludedInTitle
IsRequired bit(1) Is Required isRequired
MetaData varchar(128) Meta Data metaData
DataColumnIndex smallint(6)
TableId int(11)
TableName varchar(64) Table Name tableName
ViewOrder smallint(6) View Order viewOrder
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL
WorkbenchTemplateID int(11) MUL
IsEditable bit(1) Is Editable isEditable

Indexes

Name Fields Unique Nullable
FK7D6D44085327F942 ModifiedByAgentID
FK7D6D44087699B003 CreatedByAgentID
FK7D6D44087F5EBA2A WorkbenchTemplateID
PRIMARY WorkbenchTemplateMappingItemID

One-to-many relationships

Name Field Related table Related field
FK2901E47C688C522E WorkbenchTemplateMappingItemID workbenchdataitem WorkbenchTemplateMappingItemID

Many-to-one relationships

Name Field Related table Related field
FK7D6D44085327F942 ModifiedByAgentID agent AgentID
FK7D6D44087699B003 CreatedByAgentID agent AgentID
FK7D6D44087F5EBA2A WorkbenchTemplateID workbenchtemplate WorkbenchTemplateID