facilitator_subject_progress

69894 rows


Description

stores facilitator subject progress

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
user_id VARCHAR 100 √ null
centre_id VARCHAR 100 √ null
batch_id VARCHAR 36 √ null
subject_id VARCHAR 100 √ null
completed_count INT 10 √ null
activity_count INT 10 √ null
total_count INT 10 √ null
progress FLOAT 12 √ null
created_at DATETIME 19 √ null
updated_at DATETIME 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_fcp_centre_user_subject Performance Asc/Asc/Asc centre_id + user_id + subject_id

Relationships