crs_settings

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
obj_id INT 10 0
syllabus VARCHAR 4000 √ null
contact_name VARCHAR 255 √ null
contact_responsibility VARCHAR 255 √ null
contact_phone VARCHAR 255 √ null
contact_email VARCHAR 255 √ null
contact_consultation VARCHAR 4000 √ null
activation_type TINYINT 3 0
activation_start INT 10 √ null
activation_end INT 10 √ null
sub_limitation_type TINYINT 3 0
sub_start INT 10 √ null
sub_end INT 10 √ null
sub_type INT 10 √ null
sub_password VARCHAR 32 √ null
sub_mem_limit TINYINT 3 0
sub_max_members INT 10 √ null
sub_notify INT 10 √ null
view_mode TINYINT 3 0
sortorder INT 10 √ null
archive_start INT 10 √ null
archive_end INT 10 √ null
archive_type INT 10 √ null
abo TINYINT 3 √ 1
waiting_list TINYINT 3 1
important VARCHAR 4000 √ null
show_members TINYINT 3 1
latitude VARCHAR 30 √ null
longitude VARCHAR 30 √ null
location_zoom INT 10 0
enable_course_map TINYINT 3 0
session_limit TINYINT 3 0
session_prev BIGINT 19 -1
session_next BIGINT 19 -1
reg_ac_enabled TINYINT 3 0
reg_ac VARCHAR 32 √ null
status_dt TINYINT 3 √ 2
auto_notification TINYINT 3 1
mail_members_type TINYINT 3 √ 1
crs_start INT 10 √ null
crs_end INT 10 √ null
leave_end INT 10 √ null
auto_wait TINYINT 3 0
min_members SMALLINT 5 √ null
show_members_export INT 10 √ null
timing_mode TINYINT 3 √ 0
period_start DATETIME 19 √ null
period_end DATETIME 19 √ null
period_time_indication INT 10 0
target_group VARCHAR 4000 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc obj_id

Diagram producer might be missing

No diagrams were produced please see application output for any errors