spexportschemaitem

Table info.

Title Sp Export Schema Item
Description Sp Export Schema Item

Fields

Name Type Required Index Hidden On form Title Pick list Description
SpExportSchemaItemID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
DataType varchar(32) Data Type dataType
Description varchar(255) Description description
FieldName varchar(64) Field Name fieldName
Formatter varchar(32) Formatter formatter
SpExportSchemaID int(11) MUL
SpLocaleContainerItemID int(11) MUL
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FKBB21AF455327F942 ModifiedByAgentID
FKBB21AF455722A7A2 SpExportSchemaID
FKBB21AF45720CCEF2 SpLocaleContainerItemID
FKBB21AF457699B003 CreatedByAgentID
PRIMARY SpExportSchemaItemID

One-to-many relationships

Name Field Related table Related field
FKCD08A1E92957EC8B SpExportSchemaItemID spexportschemaitemmapping ExportSchemaItemID

Many-to-one relationships

Name Field Related table Related field
FKBB21AF455327F942 ModifiedByAgentID agent AgentID
FKBB21AF455722A7A2 SpExportSchemaID spexportschema SpExportSchemaID
FKBB21AF45720CCEF2 SpLocaleContainerItemID splocalecontaineritem SpLocaleContainerItemID
FKBB21AF457699B003 CreatedByAgentID agent AgentID