placements

115745 rows


Description

Stores placement details for learners

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
user_id VARCHAR 36 √ null
centre_id VARCHAR 36 √ null
company VARCHAR 127 √ null
branch VARCHAR 127 √ null
designation VARCHAR 127 √ null
sector_id VARCHAR 36 √ null
offerletter_status_id VARCHAR 36 √ null
offerletter_type_id VARCHAR 36 √ null
salary INT 10 √ null
salary_range VARCHAR 127 √ null
joining_date DATE 10 √ null
placement_status_id VARCHAR 36 √ null
created_at DATETIME 19 null
updated_at DATETIME 19 null
placement_type_id VARCHAR 36 null
deleted_at DATETIME 19 √ null
tenant_id VARCHAR 36 √ null
reason VARCHAR 255 √ null
old_data_id INT 10 √ null
placement_course_id VARCHAR 36 √ null
district_id VARCHAR 36 √ null
location_id VARCHAR 36 √ null
duration_of_apprenticeship TINYINT 3 √ null
evidence_type TINYINT 3 √ null
other_evidence VARCHAR 250 √ null
evidence_path TEXT 65535 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
fk_placements_1_idx Performance Asc user_id
fk_placements_2_idx Performance Asc centre_id
offerletter_status_id Performance Asc offerletter_status_id
offerletter_type_id Performance Asc offerletter_type_id
placement_status_id Performance Asc placement_status_id
placement_type_id Performance Asc placement_type_id
sector_id Performance Asc sector_id
user_id Performance Asc/Asc user_id + placement_type_id

Relationships