ple_career_paths

22 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
ple_career_path_texts.career_path_id career_path_id_foreign R
ple_career_path_user.job_type_id job_type_user_job_type_id_foreign R
ple_job_card_career_path.job_type_id job_card_job_type_job_type_id_foreign R
name VARCHAR 125 null
trade_id CHAR 36 √ null
trades.id job_types_trade_id_foreign R
image VARCHAR 125 √ null
sort_order INT 10 null
color VARCHAR 10 √ null
created_by CHAR 36 null
users.id job_types_created_by_foreign R
tenant_id CHAR 36 null
tenants.id job_types_tenant_id_foreign R
created_at TIMESTAMP 19 √ null
updated_at TIMESTAMP 19 √ null
deleted_at TIMESTAMP 19 √ null
parent_id VARCHAR 36 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
job_types_created_by_foreign Performance Asc created_by
job_types_tenant_id_foreign Performance Asc tenant_id
job_types_trade_id_foreign Performance Asc trade_id

Relationships

Close relationships within degrees of separation