centre_subject_view

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 √ null
name VARCHAR 255 √ null
description MEDIUMTEXT 16777215 √ null
image MEDIUMTEXT 16777215 √ null
tag VARCHAR 125 √ null
order INT 10 √ 100000
year_to_map TINYINT 3 √ 0
status BIT 1 √ 1

0:Inactive,1:Active

tenant_id VARCHAR 36 √ null
updated_by VARCHAR 36 √ null
deleted_by VARCHAR 36 √ null
created_by VARCHAR 36 √ null
created_at TIMESTAMP 19 √ null
updated_at TIMESTAMP 19 √ null
deleted_at TIMESTAMP 19 √ null
is_ple TINYINT 3 √ 0
is_dummy TINYINT 3 √ 0
centre_id VARCHAR 36 null
centre_lock_status TINYINT 3 √ 1
sub_order INT 10 √ null
course_count BIGINT 19 √ null

Relationships

View Definition


Possibly Referenced Tables/Views