SeoCustomSlugPageJobCategories


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
job_category_id int4 10 √ null
JobCategories.id SeoCustomSlugPageJobCategories_job_category_id_fkey R
seo_custom_slug_page_id uuid 2147483647 null
SeoCustomSlugPages.id SeoCustomSlugPageJobCategories_seo_custom_slug_page_id_fkey C
created_at timestamptz 35,6 now()
updated_at timestamptz 35,6 now()
hierarchical_job_category_id uuid 2147483647 √ null
HierarchicalJobCategories.id SeoCustomSlugPageJobCategorie_hierarchical_job_category_id_fkey N

Foreign Key to Hierarchical Job Category Table

Indexes

Constraint Name Type Sort Column(s)
SeoCustomSlugPageJobCategories_pkey Primary key Asc id
growth_SeoCustomSlugPageJobCategories_job_category_id_idx Performance Asc job_category_id
growth_SeoCustomSlugPageJobCategories_seo_custom_slug_page_id_i Performance Asc seo_custom_slug_page_id

Check Constraints

Constraint Name Constraint
SeoCustomSlugPageJobCategories_jobCategoryId_hierarchicalJobCat (((job_category_id IS NOT NULL) OR (hierarchical_job_category_id IS NOT NULL)))

Relationships

Close relationships within degrees of separation