splocalecontainer

Table info.

Title Locale Container
Description Locale Container

Fields

Name Type Required Index Hidden On form Title Pick list Description
SpLocaleContainerID 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
Aggregator varchar(64) Aggregator aggregator
DefaultUI varchar(64) Default U I defaultUI
SchemaType tinyint(4) Schema Type The type of schema it belongs to: the core schema or the workbench schema
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL
DisciplineID int(11) MUL

Indexes

Name Fields Unique Nullable
FK3CC8F6A4CE675DE DisciplineID
FK3CC8F6A5327F942 ModifiedByAgentID
FK3CC8F6A7699B003 CreatedByAgentID
PRIMARY SpLocaleContainerID
SpLocaleContainerNameIDX Name

One-to-many relationships

Name Field Related table Related field
FK22F4457DC279ADEC SpLocaleContainerID splocalecontaineritem SpLocaleContainerID
FK4F03EF67AD36C73D SpLocaleContainerID splocaleitemstr SpLocaleContainerDescID
FK4F03EF67BE0C2CB7 SpLocaleContainerID splocaleitemstr SpLocaleContainerNameID

Many-to-one relationships

Name Field Related table Related field
FK3CC8F6A4CE675DE DisciplineID discipline UserGroupScopeId
FK3CC8F6A5327F942 ModifiedByAgentID agent AgentID
FK3CC8F6A7699B003 CreatedByAgentID agent AgentID