subjects

961 rows


Description

Stores subject details

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
batch_subject.subject_id batch_subject_ibfk_2 R
centre_subject.subject_id centre_subject_ibfk_2 R
name VARCHAR 255 null
description MEDIUMTEXT 16777215 null
deleted_at TIMESTAMP 19 √ null
created_at TIMESTAMP 19 null
updated_at TIMESTAMP 19 null
tag VARCHAR 125 √ null
status BIT 1 1

0:Inactive,1:Active
created_by VARCHAR 36 null
updated_by VARCHAR 36 √ null
deleted_by VARCHAR 36 √ null
tenant_id VARCHAR 36 √ null
order INT 10 √ null
old_data_id INT 10 √ null
image MEDIUMTEXT 16777215 √ null
ple_career_path_id VARCHAR 36 √ null
year_to_map TINYINT 3 √ 0
is_ple TINYINT 3 √ 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
name Performance Asc name
status Performance Asc status
subjects_deleted_at_IDX Performance Asc deleted_at
tenant_id Performance Asc tenant_id
updated_at Performance Asc updated_at

Relationships

Close relationships within degrees of separation