splocalecontaineritem

Table info.

Title Locale Container Item
Description Locale Container Item

Fields

Name Type Required Index Hidden On form Title Pick list Description
SpLocaleContainerItemID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
Format varchar(64) Format format
IsHidden bit(1) Is Hidden isHidden
IsSystem bit(1) Is System isSystem
IsUIFormatter bit(1) Is U I Formatter isUIFormatter
Name varchar(64) MUL Name name
PickListName varchar(64) Pick List Name pickListName
Type varchar(32) Type type
IsRequired bit(1) Is Required isRequired
WebLinkName varchar(32) Web Link Name webLinkName
ModifiedByAgentID int(11) MUL
SpLocaleContainerID int(11) MUL
CreatedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FK22F4457D5327F942 ModifiedByAgentID
FK22F4457D7699B003 CreatedByAgentID
FK22F4457DC279ADEC SpLocaleContainerID
PRIMARY SpLocaleContainerItemID
SpLocaleContainerItemNameIDX Name

One-to-many relationships

Name Field Related table Related field
FKBB21AF45720CCEF2 SpLocaleContainerItemID spexportschemaitem SpLocaleContainerItemID
FK4F03EF67E9D506C3 SpLocaleContainerItemID splocaleitemstr SpLocaleContainerItemDescID
FK4F03EF67FAAA6C3D SpLocaleContainerItemID splocaleitemstr SpLocaleContainerItemNameID

Many-to-one relationships

Name Field Related table Related field
FK22F4457D5327F942 ModifiedByAgentID agent AgentID
FK22F4457D7699B003 CreatedByAgentID agent AgentID
FK22F4457DC279ADEC SpLocaleContainerID splocalecontainer SpLocaleContainerID