Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | public.gen_random_uuid() |
|
|
Primary Key. |
|||||
| needsVisa | bool | 1 | √ | null |
|
|
Boolean indicating whether User requires visa to work in country indicated in CountryCode. |
||||
| CountryCode | varchar | 255 | null |
|
|
Country that User would like to work in. |
|||||
| UserId | uuid | 2147483647 | null |
|
|
Foreign Key to User Table. |
|||||
| createdAt | timestamptz | 35,6 | null |
|
|
Entry creation date |
|||||
| updatedAt | timestamptz | 35,6 | null |
|
|
Datetime of last modification to any attribute |
|||||
| CityId | int4 | 10 | √ | null |
|
|
|||||
| LocationId | uuid | 2147483647 | √ | null |
|
|
Foreign key to Locations table |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| JobLocationPreferences_pkey | Primary key | Asc | id |
| JLP_UserId_CityId_conditional_idx | Must be unique | Asc/Asc | UserId + CityId |
| JLP_UserId_CountryCode_CityId_LocationId_idx | Must be unique | Asc/Asc/Asc/Asc | UserId + CountryCode + CityId + LocationId |
| JobLocationPreferences_UserId_CityId | Must be unique | Asc/Asc | UserId + CityId |
Relationships
Close relationships within degrees of separation
