LocationLegacyMappings


Description

contains mapping from new location to legacy location

Columns

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

Indexes

Constraint Name Type Sort Column(s)
LocationLegacyMappings_pkey Primary key Asc id
LocationLegacyMappings_locationId_key Must be unique Asc locationId

Relationships

Close relationships within degrees of separation