ple_job_card_career_path

8341 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
job_card_id CHAR 36 null
ple_job_cards.id job_card_job_type_job_card_id_foreign R
job_type_id CHAR 36 null
ple_career_paths.id job_card_job_type_job_type_id_foreign R
created_by CHAR 36 null
users.id job_card_job_type_created_by_foreign R
tenant_id CHAR 36 null
tenants.id job_card_job_type_tenant_id_foreign R
created_at TIMESTAMP 19 √ null
updated_at TIMESTAMP 19 √ null
deleted_at TIMESTAMP 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
job_card_job_type_created_by_foreign Performance Asc created_by
job_card_job_type_job_card_id_foreign Performance Asc job_card_id
job_card_job_type_job_type_id_foreign Performance Asc job_type_id
job_card_job_type_tenant_id_foreign Performance Asc tenant_id

Relationships

Close relationships within degrees of separation