localitynamealias

Table info.

Title Locality Name Alias
Description Locality Name Alias

Fields

Name Type Required Index Hidden On form Title Pick list Description
LocalityNameAliasID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
Name varchar(255) MUL Name The alias for the locality name.
Source varchar(64) Source The source of the alias.
LocalityID int(11) MUL
CreatedByAgentID int(11) MUL
ModifiedByAgentID int(11) MUL
DisciplineID int(11) MUL

Indexes

Name Fields Unique Nullable
FK29EB5CA24CE675DE DisciplineID
FK29EB5CA25327F942 ModifiedByAgentID
FK29EB5CA27699B003 CreatedByAgentID
FK29EB5CA2A666A5C4 LocalityID
LocalityNameAliasIDX Name
PRIMARY LocalityNameAliasID

Many-to-one relationships

Name Field Related table Related field
FK29EB5CA24CE675DE DisciplineID discipline UserGroupScopeId
FK29EB5CA25327F942 ModifiedByAgentID agent AgentID
FK29EB5CA27699B003 CreatedByAgentID agent AgentID
FK29EB5CA2A666A5C4 LocalityID locality LocalityID