mqops_student_interaction_tracker

11 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_type_id VARCHAR 36 null
centre_type_other VARCHAR 250 √ null
centre_id VARCHAR 36 null
interacted_with_count INT 10 0
created_at DATETIME 19 √ CURRENT_TIMESTAMP
updated_at DATETIME 19 √ null
deleted_at DATETIME 19 √ null
tenant_id VARCHAR 36 √ null
form_pdf TEXT 65535 √ null

Indexes

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

Relationships

Close relationships within degrees of separation