centre_subject

239387 rows


Description

Subjects mapped to centre

Columns

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

Indexes

Constraint Name Type Sort Column(s)
idx_centre_subject_order Performance Asc order
idx_centre_subject_subject Performance Asc subject_id
uq_centre_subject Must be unique Asc/Asc centre_id + subject_id

Relationships