{"mysqld_version_id":80037,"dd_version":80023,"sdi_version":80019,"dd_object_type":"Table","dd_object":{"name":"infosystem_v7_answer_stats","mysql_version_id":80037,"created":20240621101916,"last_altered":20240621101916,"hidden":1,"options":"avg_row_length=0;key_block_size=0;keys_disabled=0;pack_record=1;row_type=2;stats_auto_recalc=0;stats_sample_pages=0;","columns":[{"name":"semester","type":3,"is_nullable":false,"is_zerofill":false,"is_unsigned":false,"is_auto_increment":false,"is_virtual":false,"hidden":1,"ordinal_position":1,"char_length":6,"numeric_precision":5,"numeric_scale":0,"numeric_scale_null":false,"datetime_precision":0,"datetime_precision_null":1,"has_no_default":false,"default_value_null":false,"srs_id_null":true,"srs_id":0,"default_value":"AAA=","default_value_utf8_null":false,"default_value_utf8":"0","default_option":"","update_option":"","comment":"","generation_expression":"","generation_expression_utf8":"","options":"interval_count=0;","se_private_data":"","engine_attribute":"","secondary_engine_attribute":"","column_key":4,"column_type_utf8":"smallint","elements":[],"collation_id":8,"is_explicit_collation":false},{"name":"id_unit","type":3,"is_nullable":false,"is_zerofill":false,"is_unsigned":false,"is_auto_increment":false,"is_virtual":false,"hidden":1,"ordinal_position":2,"char_length":6,"numeric_precision":5,"numeric_scale":0,"numeric_scale_null":false,"datetime_precision":0,"datetime_precision_null":1,"has_no_default":false,"default_value_null":false,"srs_id_null":true,"srs_id":0,"default_value":"AAA=","default_value_utf8_null":false,"default_value_utf8":"0","default_option":"","update_option":"","comment":"","generation_expression":"","generation_expression_utf8":"","options":"interval_count=0;","se_private_data":"","engine_attribute":"","secondary_engine_attribute":"","column_key":4,"column_type_utf8":"smallint","elements":[],"collation_id":8,"is_explicit_collation":false},{"name":"id_questionnaire","type":10,"is_nullable":true,"is_zerofill":false,"is_unsigned":true,"is_auto_increment":false,"is_virtual":false,"hidden":1,"ordinal_position":3,"char_length":8,"numeric_precision":7,"numeric_scale":0,"numeric_scale_null":false,"datetime_precision":0,"datetime_precision_null":1,"has_no_default":false,"default_value_null":true,"srs_id_null":true,"srs_id":0,"default_value":"","default_value_utf8_null":true,"default_value_utf8":"","default_option":"","update_option":"","comment":"","generation_expression":"","generation_expression_utf8":"","options":"interval_count=0;","se_private_data":"","engine_attribute":"","secondary_engine_attribute":"","column_key":4,"column_type_utf8":"mediumint unsigned","elements":[],"collation_id":8,"is_explicit_collation":false},{"name":"id_class","type":24,"is_nullable":true,"is_zerofill":false,"is_unsigned":false,"is_auto_increment":false,"is_virtual":false,"hidden":1,"ordinal_position":4,"char_length":255,"numeric_precision":0,"numeric_scale":0,"numeric_scale_null":true,"datetime_precision":0,"datetime_precision_null":1,"has_no_default":false,"default_value_null":true,"srs_id_null":true,"srs_id":0,"default_value":"","default_value_utf8_null":true,"default_value_utf8":"","default_option":"","update_option":"","comment":"","generation_expression":"","generation_expression_utf8":"","options":"interval_count=0;","se_private_data":"","engine_attribute":"","secondary_engine_attribute":"","column_key":4,"column_type_utf8":"tinytext","elements":[],"collation_id":33,"is_explicit_collation":false},{"name":"id_user","type":10,"is_nullable":true,"is_zerofill":false,"is_unsigned":true,"is_auto_increment":false,"is_virtual":false,"hidden":1,"ordinal_position":5,"char_length":8,"numeric_precision":7,"numeric_scale":0,"numeric_scale_null":false,"datetime_precision":0,"datetime_precision_null":1,"has_no_default":false,"default_value_null":true,"srs_id_null":true,"srs_id":0,"default_value":"","default_value_utf8_null":true,"default_value_utf8":"","default_option":"","update_option":"","comment":"","generation_expression":"","generation_expression_utf8":"","options":"interval_count=0;","se_private_data":"","engine_attribute":"","secondary_engine_attribute":"","column_key":4,"column_type_utf8":"mediumint unsigned","elements":[],"collation_id":8,"is_explicit_collation":false},{"name":"questionnaire_code","type":24,"is_nullable":false,"is_zerofill":false,"is_unsigned":false,"is_auto_increment":false,"is_virtual":false,"hidden":1,"ordinal_position":6,"char_length":255,"numeric_precision":0,"numeric_scale":0,"numeric_scale_null":true,"datetime_precision":0,"datetime_precision_null":1,"has_no_default":true,"default_value_null":false,"srs_id_null":true,"srs_id":0,"default_value":"AAAAAAAAAAAA","default_value_utf8_null":true,"default_value_utf8":"","default_option":"","update_option":"","comment":"","generation_expression":"","generation_expression_utf8":"","options":"interval_count=0;","se_private_data":"","engine_attribute":"","secondary_engine_attribute":"","column_key":4,"column_type_utf8":"tinytext","elements":[],"collation_id":33,"is_explicit_collation":false},{"name":"no_questionnaires","type":3,"is_nullable":true,"is_zerofill":false,"is_unsigned":false,"is_auto_increment":false,"is_virtual":false,"hidden":1,"ordinal_position":7,"char_length":6,"numeric_precision":5,"numeric_scale":0,"numeric_scale_null":false,"datetime_precision":0,"datetime_precision_null":1,"has_no_default":false,"default_value_null":true,"srs_id_null":true,"srs_id":0,"default_value":"","default_value_utf8_null":true,"default_value_utf8":"","default_option":"","update_option":"","comment":"","generation_expression":"","generation_expression_utf8":"","options":"interval_count=0;","se_private_data":"","engine_attribute":"","secondary_engine_attribute":"","column_key":4,"column_type_utf8":"smallint","elements":[],"collation_id":8,"is_explicit_collation":false},{"name":"no_eval_reason","type":27,"is_nullable":true,"is_zerofill":false,"is_unsigned":false,"is_auto_increment":false,"is_virtual":false,"hidden":1,"ordinal_position":8,"char_length":65535,"numeric_precision":0,"numeric_scale":0,"numeric_scale_null":true,"datetime_precision":0,"datetime_precision_null":1,"has_no_default":false,"default_value_null":true,"srs_id_null":true,"srs_id":0,"default_value":"","default_value_utf8_null":true,"default_value_utf8":"","default_option":"","update_option":"","comment":"","generation_expression":"","generation_expression_utf8":"","options":"interval_count=0;","se_private_data":"","engine_attribute":"","secondary_engine_attribute":"","column_key":1,"column_type_utf8":"text","elements":[],"collation_id":33,"is_explicit_collation":false},{"name":"id_course_assignment","type":4,"is_nullable":false,"is_zerofill":false,"is_unsigned":false,"is_auto_increment":false,"is_virtual":false,"hidden":1,"ordinal_position":9,"char_length":10,"numeric_precision":10,"numeric_scale":0,"numeric_scale_null":false,"datetime_precision":0,"datetime_precision_null":1,"has_no_default":true,"default_value_null":false,"srs_id_null":true,"srs_id":0,"default_value":"AAAAAA==","default_value_utf8_null":true,"default_value_utf8":"","default_option":"","update_option":"","comment":"","generation_expression":"","generation_expression_utf8":"","options":"interval_count=0;","se_private_data":"","engine_attribute":"","secondary_engine_attribute":"","column_key":4,"column_type_utf8":"int","elements":[],"collation_id":8,"is_explicit_collation":false}],"schema_ref":"modip_app","se_private_id":18446744073709551615,"engine":"MyISAM","last_checked_for_upgrade_version_id":80037,"comment":"","se_private_data":"","engine_attribute":"","secondary_engine_attribute":"","row_format":2,"partition_type":0,"partition_expression":"","partition_expression_utf8":"","default_partitioning":0,"subpartition_type":0,"subpartition_expression":"","subpartition_expression_utf8":"","default_subpartitioning":0,"indexes":[{"name":"semester","hidden":false,"is_generated":false,"ordinal_position":1,"comment":"","options":"flags=0;","se_private_data":"","type":3,"algorithm":2,"is_algorithm_explicit":false,"is_visible":true,"engine":"MyISAM","engine_attribute":"","secondary_engine_attribute":"","elements":[{"ordinal_position":1,"length":2,"order":2,"hidden":false,"column_opx":0},{"ordinal_position":2,"length":2,"order":2,"hidden":false,"column_opx":1},{"ordinal_position":3,"length":3,"order":2,"hidden":false,"column_opx":2},{"ordinal_position":4,"length":3,"order":2,"hidden":false,"column_opx":4}]},{"name":"id_unit","hidden":false,"is_generated":false,"ordinal_position":2,"comment":"","options":"flags=0;","se_private_data":"","type":3,"algorithm":2,"is_algorithm_explicit":false,"is_visible":true,"engine":"MyISAM","engine_attribute":"","secondary_engine_attribute":"","elements":[{"ordinal_position":1,"length":2,"order":2,"hidden":false,"column_opx":1}]},{"name":"id_questionnaire","hidden":false,"is_generated":false,"ordinal_position":3,"comment":"","options":"flags=0;","se_private_data":"","type":3,"algorithm":2,"is_algorithm_explicit":false,"is_visible":true,"engine":"MyISAM","engine_attribute":"","secondary_engine_attribute":"","elements":[{"ordinal_position":1,"length":3,"order":2,"hidden":false,"column_opx":2}]},{"name":"id_user","hidden":false,"is_generated":false,"ordinal_position":4,"comment":"","options":"flags=0;","se_private_data":"","type":3,"algorithm":2,"is_algorithm_explicit":false,"is_visible":true,"engine":"MyISAM","engine_attribute":"","secondary_engine_attribute":"","elements":[{"ordinal_position":1,"length":3,"order":2,"hidden":false,"column_opx":4}]},{"name":"no_questionnaires","hidden":false,"is_generated":false,"ordinal_position":5,"comment":"","options":"flags=0;","se_private_data":"","type":3,"algorithm":2,"is_algorithm_explicit":false,"is_visible":true,"engine":"MyISAM","engine_attribute":"","secondary_engine_attribute":"","elements":[{"ordinal_position":1,"length":2,"order":2,"hidden":false,"column_opx":6}]},{"name":"id_course_assignment","hidden":false,"is_generated":false,"ordinal_position":6,"comment":"","options":"flags=0;","se_private_data":"","type":3,"algorithm":2,"is_algorithm_explicit":false,"is_visible":true,"engine":"MyISAM","engine_attribute":"","secondary_engine_attribute":"","elements":[{"ordinal_position":1,"length":4,"order":2,"hidden":false,"column_opx":8}]},{"name":"id_class","hidden":false,"is_generated":false,"ordinal_position":7,"comment":"","options":"flags=0;","se_private_data":"","type":4,"algorithm":5,"is_algorithm_explicit":false,"is_visible":true,"engine":"MyISAM","engine_attribute":"","secondary_engine_attribute":"","elements":[{"ordinal_position":1,"length":1,"order":1,"hidden":false,"column_opx":3}]},{"name":"questionnaire_code","hidden":false,"is_generated":false,"ordinal_position":8,"comment":"","options":"flags=0;","se_private_data":"","type":4,"algorithm":5,"is_algorithm_explicit":false,"is_visible":true,"engine":"MyISAM","engine_attribute":"","secondary_engine_attribute":"","elements":[{"ordinal_position":1,"length":1,"order":1,"hidden":false,"column_opx":5}]}],"foreign_keys":[],"check_constraints":[],"partitions":[],"collation_id":33}}