centre_subject

320687 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_ibfk_1 R
subject_id VARCHAR 36 null
subjects.id centre_subject_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
order Performance Asc order
subject_id Performance Asc subject_id

Relationships

Close relationships within degrees of separation