Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | VARCHAR | 36 | null |
|
|
|||
| user_id | VARCHAR | 36 | null |
|
|
|||
| centre_type_id | VARCHAR | 36 | null |
|
|
|||
| state_id | VARCHAR | 36 | null |
|
|
|||
| district_id | VARCHAR | 36 | null |
|
|
|||
| centre_id | VARCHAR | 36 | null |
|
|
|||
| team_name | TINYINT | 3 | √ | null |
|
|
||
| date_of_visit | DATE | 10 | √ | null |
|
|
||
| placement_officer_name | VARCHAR | 255 | √ | null |
|
|
||
| po_attend_quest_training | TINYINT | 3 | √ | null |
|
|
||
| how_many_times | TINYINT | 3 | √ | null |
|
|
||
| interested_in_training | TINYINT | 3 | √ | null |
|
|
||
| students_were_placed | TINYINT | 3 | √ | null |
|
|
||
| average_number_companies | TINYINT | 3 | √ | null |
|
|
||
| salary_offered | TINYINT | 3 | √ | null |
|
|
||
| sectors_students_placed | VARCHAR | 255 | √ | null |
|
|
||
| kind_of_jobs | VARCHAR | 255 | √ | null |
|
|
||
| mock_interviews_or_pre_placement | TINYINT | 3 | √ | null |
|
|
||
| institute_maintain_placement_database | TINYINT | 3 | √ | null |
|
|
||
| how_placement_database_maintained | TINYINT | 3 | √ | null |
|
|
||
| kind_of_tools_databases | VARCHAR | 255 | √ | null |
|
|
||
| interested_in_setting | TINYINT | 3 | √ | null |
|
|
||
| how_long_typically_track | TINYINT | 3 | √ | null |
|
|
||
| central_placement_or_alumni_tracking | TINYINT | 3 | √ | null |
|
|
||
| how_this_will_help | VARCHAR | 255 | √ | null |
|
|
||
| some_recurring_reasons_employers | VARCHAR | 255 | √ | null |
|
|
||
| challenges_securing_placements | VARCHAR | 255 | √ | null |
|
|
||
| female_students_specific_challenges | VARCHAR | 255 | √ | null |
|
|
||
| students_confident_appearing_interviews | TINYINT | 3 | √ | null |
|
|
||
| what_major_gaps | VARCHAR | 255 | √ | null |
|
|
||
| students_different_backgrounds | VARCHAR | 255 | √ | null |
|
|
||
| kind_training_support | VARCHAR | 255 | √ | null |
|
|
||
| support_state_department | VARCHAR | 255 | √ | null |
|
|
||
| created_at | TIMESTAMP | 19 | √ | CURRENT_TIMESTAMP |
|
|
||
| updated_at | TIMESTAMP | 19 | √ | null |
|
|
||
| deleted_at | TIMESTAMP | 19 | √ | null |
|
|
||
| tot_form_pdf | VARCHAR | 100 | √ | null |
|
|
||
| final_pdf_document | VARCHAR | 100 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
