mqops_principal_interaction_tracker

13 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
user_id VARCHAR 36 null
team_name_id TINYINT 3 null
activity_log_purge_progress.id Implied Constraint R
team_name_other VARCHAR 250 √ null
visit_date DATETIME 19 null
state_id VARCHAR 36 null
district_id VARCHAR 36 null
centre_id VARCHAR 36 null
principal_name VARCHAR 45 null
attend_plp TINYINT 3 null
used_questapp TINYINT 3 null
performance_metric TINYINT 3 null
time_alloted_track TINYINT 3 null
learner_attendance TINYINT 3 null
feedback_with_learner TINYINT 3 null
feedback_with_faculty TINYINT 3 null
system_to_collect_feedback TINYINT 3 null
safe_space TINYINT 3 null
have_active VARCHAR 15 null
created_at DATETIME 19 CURRENT_TIMESTAMP
updated_at DATETIME 19 √ null
deleted_at DATETIME 19 √ null
tenant_id VARCHAR 36 √ null
centre_type_id VARCHAR 36 √ null
has_implement_change_project TINYINT 3 √ null
help_in_implementation VARCHAR 30 √ null
other_help_in_implementation TEXT 65535 √ null
reason_not_implemented VARCHAR 30 √ null
other_reason_not_implemented TEXT 65535 √ null
any_green_activity TINYINT 3 √ null
green_activity_carried_out VARCHAR 30 √ null
other_green_activity_carried_out TEXT 65535 √ null
curriculam_implemented VARCHAR 30 √ null
support_for_green_curriculam TINYINT 3 √ null
other_support_for_green_curriculam TEXT 65535 √ null
challenging_area VARCHAR 30 √ null
other_challenging_area TEXT 65535 √ null
need_support TEXT 65535 √ null
form_pdf TEXT 65535 √ null
final_pdf_path TEXT 65535 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

Relationships