splocaleitemstr

Table info.

Title Locale Item String
Description Locale Item String

Fields

Name Type Required Index Hidden On form Title Pick list Description
SpLocaleItemStrID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
Country varchar(2) MUL Country country
Language varchar(2) MUL Language language
Text varchar(255) Text text
Variant varchar(2) Variant variant
ModifiedByAgentID int(11) MUL
SpLocaleContainerDescID int(11) MUL
SpLocaleContainerItemNameID int(11) MUL
CreatedByAgentID int(11) MUL
SpLocaleContainerNameID int(11) MUL
SpLocaleContainerItemDescID int(11) MUL

Indexes

Name Fields Unique Nullable
FK4F03EF675327F942 ModifiedByAgentID
FK4F03EF677699B003 CreatedByAgentID
FK4F03EF67AD36C73D SpLocaleContainerDescID
FK4F03EF67BE0C2CB7 SpLocaleContainerNameID
FK4F03EF67E9D506C3 SpLocaleContainerItemDescID
FK4F03EF67FAAA6C3D SpLocaleContainerItemNameID
PRIMARY SpLocaleItemStrID
SpLocaleCountyIDX Country
SpLocaleLanguageIDX Language

Many-to-one relationships

Name Field Related table Related field
FK4F03EF675327F942 ModifiedByAgentID agent AgentID
FK4F03EF677699B003 CreatedByAgentID agent AgentID
FK4F03EF67AD36C73D SpLocaleContainerDescID splocalecontainer SpLocaleContainerID
FK4F03EF67BE0C2CB7 SpLocaleContainerNameID splocalecontainer SpLocaleContainerID
FK4F03EF67E9D506C3 SpLocaleContainerItemDescID splocalecontaineritem SpLocaleContainerItemID
FK4F03EF67FAAA6C3D SpLocaleContainerItemNameID splocalecontaineritem SpLocaleContainerItemID