Countries


Description

Country Information

Columns

Column Type Size Nulls Auto Default Children Parents Comments
code varchar 255 null
CreditPackages.countryCode CreditPackages_countryCode_fkey R
CreditPurchaseOrders.countryCode CreditPurchaseOrders_countryCode_fkey R
Products.countryCode Products_countryCode_fkey R
CandidateLocationPreferences.countryCode CandidateLocationPreferences_countryCode_fkey N
Candidates.countryCode Candidates_countryCode_fkey N
InferredCandidates.countryCode InferredCandidates_countryCode_fkey N
RelocationCities.countryCode RelocationCities_countryCode_fkey C
LanguageToCountryMaps.country_code LanguageToCountryMaps_country_code_fkey R
SeoCustomSlugPages.country_code SeoCustomSlugPages_country_id_fkey R
Campaigns.CountryCode Campaigns_CountryCode_fkey R
Cities.CountryCode Cities_CountryCode_fkey C
Companies.CountryCode Companies_CountryCode_fkey N
CompaniesPageConfigs.CountryCode CompaniesPageConfigs_CountryCode_fkey R
CompanyFeaturesMaximum.CountryCode CompanyFeaturesMaximum_CountryCode_fkey C
JobDrafts.CountryCode JobDrafts_CountryCode_fkey N
JobFeaturesMaximum.CountryCode JobFeaturesMaximum_CountryCode_fkey C
JobLocationPreferences.CountryCode JobLocationPreferences_CountryCode_fkey C
Jobs.CountryCode Jobs_CountryCode_fkey N
LocationHierarchicalMappings.countryCode LocationHierarchicalMappings_countryCode_fkey R
LocationLegacyMappings.countryCode LocationLegacyMappings_countryCode_fkey R
MobileAppVersions.countryCode MobileAppVersions_countryCode_fkey R
MTSeatActivations.countryCode mtseatactivations_countrycode_foreign N
Organizations.CountryCode Organizations_CountryCode_fkey R
PotentialLeads.countryCode PotentialLeads_countryCode_fkey R
PushNotifications.countryCode PushNotifications_countryCode_fkey R
SalaryEstimates.CountryCode SalaryEstimates_CountryCode_fkey C
Schools.CountryCode Schools_CountryCode_fkey N
SeoFreeQueries.countryCode SeoFreeQueries_countryCode_fkey R
SourcedCompanies.CountryCode SourcedCompanies_CountryCode_fkey R
SpecialLocations.CountryCode SpecialLocations_CountryCode_fkey N
SuggestedJobValuesByCategory.countryCode SuggestedJobValuesByCategory_countryCode_fkey C
SuggestedSalaries.countryCode SuggestedSalaries_countryCode_fkey C
Users.CountryCode Users_CountryCode_fkey N
Users.Nationality Users_Nationality_fkey R
Users_cdc_test.CountryCode Users_cdc_test_CountryCode_fkey N
Users_cdc_test.Nationality Users_cdc_test_Nationality_fkey R
VerificationWhitelistedEmailDomains.countryCode VerificationWhitelistedEmailDomains_countryCode_fkey C

Country Code. follows ISO 3166
name varchar 255 √ null

Country Name.
createdAt timestamptz 35,6 null

Entry creation date
updatedAt timestamptz 35,6 null

Datetime of last modification to any attribute
demonym varchar 255 √ null

A word that identifies residents or natives of a particular place.
currency jsonb 2147483647 √ null

Currencies used in the Country.
languages jsonb 2147483647 √ null

Languages used in the country.
callingCode jsonb 2147483647 √ null
isWhitelisted bool 1 false

Indexes

Constraint Name Type Sort Column(s)
Countries_pkey Primary key Asc code
Countries_name_idx Performance Asc name

Relationships

Close relationships within degrees of separation