LegacyJobCategoryMappings


Columns

Column Type Size Nulls Auto Default Children Parents Comments
HierarchicalJobCategoryId uuid 2147483647 null
HierarchicalJobCategories.id LegacyJobCategoryMappings_HierarchicalJobCategoryId_fkey R
LegacyJobCategoryId int4 10 √ null
JobCategories.id LegacyJobCategoryMappings_LegacyJobCategoryId_fkey R
LegacyJobTitleId int4 10 √ null
JobTitles.id LegacyJobCategoryMappings_LegacyJobTitleId_fkey R
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
id uuid 2147483647 gen_random_uuid()

Indexes

Constraint Name Type Sort Column(s)
LegacyJobCategoryMappings_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation