SeoJobCategoryMetadatas


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
job_category_id int4 10 √ null
JobCategories.id SeoJobCategoryMetadatas_job_category_id_fkey R
seo_page_metadata_id uuid 2147483647 null
SeoPageMetadatas.id SeoJobCategoryMetadatas_seo_page_metadata_id_fkey R
created_at timestamptz 35,6 now()
updated_at timestamptz 35,6 now()
hierarchical_job_category_id uuid 2147483647 √ null
HierarchicalJobCategories.id SeoJobCategoryMetadatas_hierarchical_job_category_id_fkey N

Foreign Key to Hierarchical Job Category Table

Indexes

Constraint Name Type Sort Column(s)
SeoJobCategoryMetadatas_pkey Primary key Asc id
growth_SeoJobCategoryMetadatas_job_category_id_idx Performance Asc job_category_id
growth_SeoJobCategoryMetadatas_seo_page_metadata_id_idx Performance Asc seo_page_metadata_id
SeoJobCategoryMetadatas_seo_page_metadata_id_key Must be unique Asc seo_page_metadata_id

Relationships

Close relationships within degrees of separation