centre_subject_backup_30Oct2026

299442 rows


Description

Subjects mapped to centre

Columns

Column Type Size Nulls Auto Default Children Parents Comments
centre_id VARCHAR 36 null
centres.id centre_subject_backup_30Oct2026_ibfk_1 R
subject_id VARCHAR 36 null
subjects.id centre_subject_backup_30Oct2026_ibfk_2 R
order INT 10 √ 100000
old_data_id INT 10 √ null
lock_status TINYINT 3 √ 1

Indexes

Constraint Name Type Sort Column(s)
fk_centre_subject_1_idx Performance Asc centre_id
idx_centre_subject_centre_subject_order Performance Asc/Asc/Asc centre_id + subject_id + order
idx_cs_centre_subject_lock Performance Asc/Asc/Asc centre_id + subject_id + lock_status
order Performance Asc order
subject_id Performance Asc subject_id

Relationships