Cities


Description

Cities Information

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('"Cities_id_seq"'::regclass)
CandidateLocationPreferences.cityId CandidateLocationPreferences_cityId_fkey N
Candidates.cityId Candidates_cityId_fkey N
InferredCandidates.cityId InferredCandidates_cityId_fkey N
RelocationCities.cityId RelocationCities_cityId_fkey C
SeoCustomSlugPageCities.city_id SeoCustomSlugPageCities_city_id_fkey R
SeoLocationMetadatas.city_id SeoLocationMetadatas_city_id_fkey R
SeoLocationTextualContents.city_id SeoLocationTextualContents_city_id_fkey R
CitySubDivisions.CityId CitySubDivisions_CityId_fkey C
Companies.CityId Companies_CityId_fkey N
JobDrafts.CityId JobDrafts_CityId_fkey N
JobLocationPreferences.CityId JobLocationPreferences_CityId_fkey R
Jobs.CityId Jobs_CityId_fkey N
LocationHierarchicalMappings.cityId LocationHierarchicalMappings_cityId_fkey R
LocationLegacyMappings.cityId LocationLegacyMappings_cityId_fkey R
MTSeatActivations.cityId mtseatactivations_cityid_foreign N
Organizations.CityId Organizations_CityId_fkey R
TalentHuntEnquiries.CompanyCityId TalentHuntEnquiries_CompanyCityId_fkey R
Users.CityId Users_CityId_fkey N
Users_cdc_test.CityId Users_cdc_test_CityId_fkey N
JobOrderCities.cityId JobOrderCities_cityId_fkey R

Primary Key.
name varchar 255 √ null

Name of City.
CountryCode varchar 255 √ null
Countries.code Cities_CountryCode_fkey C

Country Code of the country that this city reside in. Foreign Key References Countries.
createdAt timestamptz 35,6 null

Entry creation date
updatedAt timestamptz 35,6 null

Datetime of last modification to any attribute

Indexes

Constraint Name Type Sort Column(s)
Cities_pkey Primary key Asc id
Cities_CountryCode_idx Performance Asc CountryCode
Cities_name_f_unaccent_idx Performance
Cities_name_idx Performance Asc name

Relationships

Close relationships within degrees of separation