Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| LocationLevel3Id | uuid | 2147483647 | null |
|
|
|||
| JobCategoryLevel3Id | uuid | 2147483647 | null |
|
|
|||
| properties | jsonb | 2147483647 | null |
|
|
|||
| createdAt | timestamptz | 35,6 | now() |
|
|
|||
| updatedAt | timestamptz | 35,6 | now() |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| jobsalarysuggestions_jobcategorylevel3id_idx | Performance | Asc | JobCategoryLevel3Id |
| jobsalarysuggestions_locationlevel3id_idx | Performance | Asc | LocationLevel3Id |
| jobsalarysuggestions_properties_idx | Performance | Asc | properties |
| jobsalarysuggestions_unique_location_category | Must be unique | Asc/Asc | LocationLevel3Id + JobCategoryLevel3Id |
| jobsalarysuggestions_updatedat_idx | Performance | Asc | updatedAt |
Relationships
Close relationships within degrees of separation
