spexportschemaitemmapping

Table info.

Title Sp Export Schema Item Mapping
Description Sp Export Schema Item Mapping

Fields

Name Type Required Index Hidden On form Title Pick list Description
SpExportSchemaItemMappingID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
Remarks varchar(255) Remarks remarks
SpExportSchemaMappingID int(11) MUL
CreatedByAgentID int(11) MUL
ModifiedByAgentID int(11) MUL
ExportSchemaItemID int(11) MUL
SpQueryFieldID int(11) MUL
ExportedFieldName varchar(64) Exported Field Name exportedFieldName

Indexes

Name Fields Unique Nullable
FKCD08A1E92957EC8B ExportSchemaItemID
FKCD08A1E92D3E491C SpQueryFieldID
FKCD08A1E95327F942 ModifiedByAgentID
FKCD08A1E97699B003 CreatedByAgentID
FKCD08A1E9F7C8AAB0 SpExportSchemaMappingID
PRIMARY SpExportSchemaItemMappingID

Many-to-one relationships

Name Field Related table Related field
FKCD08A1E92957EC8B ExportSchemaItemID spexportschemaitem SpExportSchemaItemID
FKCD08A1E92D3E491C SpQueryFieldID spqueryfield SpQueryFieldID
FKCD08A1E95327F942 ModifiedByAgentID agent AgentID
FKCD08A1E97699B003 CreatedByAgentID agent AgentID
FKCD08A1E9F7C8AAB0 SpExportSchemaMappingID spexportschemamapping SpExportSchemaMappingID