Locations


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
CandidateLocationPreferences.locationId CandidateLocationPreferences_locationId_fkey N
Candidates.locationId Candidates_locationId_fkey N
InferredCandidates.locationId InferredCandidates_locationId_fkey N
RelocationCities.locationId RelocationCities_locationId_fkey C
SeoCustomSlugPageCities.location_id SeoCustomSlugPageCities_location_id_fkey N
SeoLocationMetadatas.location_id SeoLocationMetadatas_location_id_fkey N
SeoLocationTextualContents.location_id SeoLocationTextualContents_location_id_fkey N
Companies.LocationId Companies_LocationId_fkey N
CompanyAddresses.locationId CompanyAddresses_locationId_fkey R
CompanyFeaturesMaximum.locationId CompanyFeaturesMaximum_locationId_fkey C
JobDrafts.DistrictId JobDrafts_DistrictId_fkey N
JobFeaturesMaximum.locationId JobFeaturesMaximum_locationId_fkey C
JobLocationPreferences.LocationId JobLocationPreferences_LocationId_fkey N
Jobs.DistrictId Jobs_DistrictId_fkey N
Location_MPTT.id Location_MPTT_id_fkey C
LocationAlternateNames.locationId LocationAlternateNames_locationId_fkey C
LocationHierarchicalMappings.locationId LocationHierarchicalMappings_locationId_fkey R
LocationLegacyMappings.locationId LocationLegacyMappings_locationId_fkey R
LocationWageGuidance.LocationId LocationWageGuidance_LocationId_fkey C
Organizations.LocationId Organizations_LocationId_fkey R
PointOfInterests.locationId PointOfInterests_locationId_fkey R
PotentialLeads.locationId PotentialLeads_locationId_fkey R
SourcedJobs.LocationId SourcedJobs_LocationId_fkey R
Users.LocationId Users_LocationId_fkey N
Users_cdc_test.LocationId Users_cdc_test_LocationId_fkey N
JobOrderCities.locationId JobOrderCities_locationId_fkey N
code varchar 255 √ null
translationKey varchar 255 √ null
defaultName varchar 255 null

Displayed name for the location as shown to clients. The value is rendered exactly as stored in the database (no formatting or capitalization changes applied). For example, if the stored value is “SINGAPORE”, clients will see “SINGAPORE”.
coordinate geography 2147483647 null
administrativeLevelId uuid 2147483647 null
LocationAdministrativeLevels.id Locations_administrativeLevelId_fkey R
originId varchar 255 √ null
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
slug varchar 255 √ NULL::character varying

Slug for the location
boundingBox _float8 17,17 √ null

Bounding Box for location. Contains a list of numbers in the following format: {westward lng}, {southern lat}, {eastward lng}, {northern lat}

Indexes

Constraint Name Type Sort Column(s)
Locations_pkey Primary key Asc id
Locations_code_key Must be unique Asc code
public_Locations_slug_idx Performance Asc slug

Relationships

Close relationships within degrees of separation