ple_user_onboardings

160038 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
trade_id CHAR 36 null
trades.id ple_user_onboardings_trade_id_foreign R
user_id CHAR 36 null
users.id ple_user_onboardings_user_id_foreign R
registration TINYINT 3 0

0 - NotDone | 1 - Complete | 2 - In Progress

avatar TINYINT 3 0

0 - NotDone | 1 - Complete | 2 - In Progress

job_card TINYINT 3 0

0 - NotDone | 1 - Complete | 2 - In Progress

career_path TINYINT 3 0

0 - NotDone | 1 - Complete | 2 - In Progress

career_path_change TINYINT 3 0

0 - NotDone | 1 - Complete | 2 - In Progress

onboarding TINYINT 3 0

0 - Not Complete | 1 - Complete

baseline TINYINT 3 0

0 - Not Complete | 1 - Complete | 2 - In Progress

endline TINYINT 3 0

0 - Not Complete | 1 - Complete | 2 - In Progress

skill TINYINT 3 0

0 - Not Complete | 1 - Complete | 2 - In Progress

points INT 10 0
created_by CHAR 36 null
users.id ple_user_onboardings_created_by_foreign R
tenant_id CHAR 36 null
tenants.id ple_user_onboardings_tenant_id_foreign R
created_at TIMESTAMP 19 null
updated_at TIMESTAMP 19 null
deleted_at TIMESTAMP 19 null
how_quest_helps TINYINT 3 0

0 - Not Complete | 1 - Complete | 2 - In Progress

rewards_and_recognition TINYINT 3 0

0 - Not Complete | 1 - Complete | 2 - In Progress

employment_videos TINYINT 3 0

0 - Not Complete | 1 - Complete | 2 - In Progress

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
ple_user_onboardings_created_at_IDX Performance Asc created_at
ple_user_onboardings_created_by_foreign Performance Asc created_by
ple_user_onboardings_tenant_id_foreign Performance Asc tenant_id
ple_user_onboardings_trade_id_foreign Performance Asc trade_id
ple_user_onboardings_user_id_foreign Performance Asc user_id

Relationships