ple_job_cards

8009 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
ple_content_ple_job_card.job_card_id job_card_id_content_id_foreign R
ple_job_card_career_path.job_card_id job_card_job_type_job_card_id_foreign R
ple_job_card_user.job_card_id job_card_user_job_card_id_foreign R
trade_id CHAR 36 null
trades.id job_cards_trade_id_foreign R
language_id VARCHAR 36 √ null
languages.id job_cards_language_id_foreign R
name VARCHAR 125 null
sort_order INT 10 null
image VARCHAR 125 √ null
salary VARCHAR 500 √ null
about TEXT 65535 √ null
main_skills_needed TEXT 65535 √ null
what_will_you_need TEXT 65535 √ null
qualification TEXT 65535 √ null
status BIT 1 1
created_by CHAR 36 null
users.id job_cards_created_by_foreign R
tenant_id CHAR 36 null
tenants.id job_cards_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_cards_created_by_foreign Performance Asc created_by
job_cards_language_id_foreign Performance Asc language_id
job_cards_tenant_id_foreign Performance Asc tenant_id
job_cards_trade_id_foreign Performance Asc trade_id

Relationships

Close relationships within degrees of separation