LocationHierarchicalMappings


Description

contains mapping from legacy location to new location

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
locationId uuid 2147483647 null
Locations.id LocationHierarchicalMappings_locationId_fkey R
countryCode varchar 255 √ null
Countries.code LocationHierarchicalMappings_countryCode_fkey R
cityId int4 10 √ null
Cities.id LocationHierarchicalMappings_cityId_fkey R
citySubDivisionId int4 10 √ null
CitySubDivisions.id LocationHierarchicalMappings_citySubDivisionId_fkey R

Indexes

Constraint Name Type Sort Column(s)
LocationHierarchicalMappings_pkey Primary key Asc id
LocationHierarchicalMappings_cityId_key Must be unique Asc cityId
LocationHierarchicalMappings_citySubDivisionId_key Must be unique Asc citySubDivisionId
LocationHierarchicalMappings_countryCode_key Must be unique Asc countryCode

Relationships

Close relationships within degrees of separation