a:2:{i:0;a:2:{s:6:"schema";O:18:"yii\db\TableSchema":7:{s:10:"schemaName";N;s:4:"name";s:10:"tbl_course";s:8:"fullName";s:10:"tbl_course";s:10:"primaryKey";a:1:{i:0;s:2:"id";}s:12:"sequenceName";s:0:"";s:11:"foreignKeys";a:4:{s:36:"fk_tbl_course_tbl_academic_year1_idx";a:2:{i:0;s:17:"tbl_academic_year";s:7:"year_id";s:2:"id";}s:33:"fk_tbl_course_tbl_department1_idx";a:2:{i:0;s:14:"tbl_department";s:13:"department_id";s:2:"id";}s:29:"fk_tbl_course_tbl_scheme1_idx";a:2:{i:0;s:10:"tbl_scheme";s:9:"scheme_id";s:2:"id";}s:34:"fk_tbl_course_tbl_study_level1_idx";a:2:{i:0;s:15:"tbl_study_level";s:14:"study_level_id";s:2:"id";}}s:7:"columns";a:21:{s:2:"id";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:2:"id";s:9:"allowNull";b:0;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:7:"int(11)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:11;s:9:"precision";i:11;s:5:"scale";N;s:12:"isPrimaryKey";b:1;s:13:"autoIncrement";b:1;s:8:"unsigned";b:0;s:7:"comment";s:8:"Table ID";s:18:"disableJsonSupport";b:0;}s:4:"name";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:4:"name";s:9:"allowNull";b:0;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:12:"varchar(100)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:100;s:9:"precision";i:100;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:0:"";s:18:"disableJsonSupport";b:0;}s:11:"course_code";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:11:"course_code";s:9:"allowNull";b:0;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:11:"varchar(45)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:45;s:9:"precision";i:45;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:11:"Course code";s:18:"disableJsonSupport";b:0;}s:10:"is_changed";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"is_changed";s:9:"allowNull";b:0;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:13:"enum('1','2')";s:12:"defaultValue";s:1:"2";s:10:"enumValues";a:2:{i:0;s:1:"1";i:1;s:1:"2";}s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:11:"1:Yes, 2:No";s:18:"disableJsonSupport";b:0;}s:13:"course_weight";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:13:"course_weight";s:9:"allowNull";b:1;s:4:"type";s:5:"float";s:7:"phpType";s:6:"double";s:6:"dbType";s:5:"float";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:29:"Weight of the course(credits)";s:18:"disableJsonSupport";b:0;}s:11:"weight_type";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:11:"weight_type";s:9:"allowNull";b:1;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:7:"int(11)";s:12:"defaultValue";i:1;s:10:"enumValues";N;s:4:"size";i:11;s:9:"precision";i:11;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:20:"1: Credits, 2: Units";s:18:"disableJsonSupport";b:0;}s:14:"score_category";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:14:"score_category";s:9:"allowNull";b:1;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:7:"int(11)";s:12:"defaultValue";i:1;s:10:"enumValues";N;s:4:"size";i:11;s:9:"precision";i:11;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:23:"1:UE and CA, 2:UE, 3:CA";s:18:"disableJsonSupport";b:0;}s:10:"score_type";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"score_type";s:9:"allowNull";b:1;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:7:"int(11)";s:12:"defaultValue";i:1;s:10:"enumValues";N;s:4:"size";i:11;s:9:"precision";i:11;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:29:"Score type
1: Marks
2: Grade
";s:18:"disableJsonSupport";b:0;}s:14:"study_level_id";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:14:"study_level_id";s:9:"allowNull";b:0;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:7:"int(11)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:11;s:9:"precision";i:11;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:14:"study level id";s:18:"disableJsonSupport";b:0;}s:17:"has_supplementary";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:17:"has_supplementary";s:9:"allowNull";b:1;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:7:"int(11)";s:12:"defaultValue";i:1;s:10:"enumValues";N;s:4:"size";i:11;s:9:"precision";i:11;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:12:"1: Yes
2: No";s:18:"disableJsonSupport";b:0;}s:15:"ue_score_weight";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:15:"ue_score_weight";s:9:"allowNull";b:1;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:7:"int(11)";s:12:"defaultValue";i:60;s:10:"enumValues";N;s:4:"size";i:11;s:9:"precision";i:11;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:44:"UE weight in % eg. 60%
CA weight in % eg 40%";s:18:"disableJsonSupport";b:0;}s:15:"ca_score_weight";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:15:"ca_score_weight";s:9:"allowNull";b:1;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:7:"int(11)";s:12:"defaultValue";i:40;s:10:"enumValues";N;s:4:"size";i:11;s:9:"precision";i:11;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:0:"";s:18:"disableJsonSupport";b:0;}s:10:"pass_grade";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"pass_grade";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:10:"varchar(5)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:5;s:9:"precision";i:5;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:0:"";s:18:"disableJsonSupport";b:0;}s:6:"min_ca";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:6:"min_ca";s:9:"allowNull";b:0;s:4:"type";s:5:"float";s:7:"phpType";s:6:"double";s:6:"dbType";s:5:"float";s:12:"defaultValue";d:16;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:0:"";s:18:"disableJsonSupport";b:0;}s:6:"is_poc";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:6:"is_poc";s:9:"allowNull";b:1;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:7:"int(11)";s:12:"defaultValue";i:0;s:10:"enumValues";N;s:4:"size";i:11;s:9:"precision";i:11;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:0:"";s:18:"disableJsonSupport";b:0;}s:7:"year_id";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:7:"year_id";s:9:"allowNull";b:1;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:7:"int(11)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:11;s:9:"precision";i:11;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:37:"Academic year id of registered course";s:18:"disableJsonSupport";b:0;}s:9:"scheme_id";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:9:"scheme_id";s:9:"allowNull";b:1;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:7:"int(11)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:11;s:9:"precision";i:11;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:9:"Scheme Id";s:18:"disableJsonSupport";b:0;}s:13:"department_id";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:13:"department_id";s:9:"allowNull";b:1;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:7:"int(11)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:11;s:9:"precision";i:11;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:32:"Department that offer the course";s:18:"disableJsonSupport";b:0;}s:6:"status";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:6:"status";s:9:"allowNull";b:0;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:13:"enum('1','2')";s:12:"defaultValue";s:1:"1";s:10:"enumValues";a:2:{i:0;s:1:"1";i:1;s:1:"2";}s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:22:"1 - Active, 2 Inactive";s:18:"disableJsonSupport";b:0;}s:10:"created_at";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"created_at";s:9:"allowNull";b:0;s:4:"type";s:8:"datetime";s:7:"phpType";s:6:"string";s:6:"dbType";s:8:"datetime";s:12:"defaultValue";O:17:"yii\db\Expression":2:{s:10:"expression";s:17:"CURRENT_TIMESTAMP";s:6:"params";a:0:{}}s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:0:"";s:18:"disableJsonSupport";b:0;}s:10:"updated_at";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"updated_at";s:9:"allowNull";b:1;s:4:"type";s:8:"datetime";s:7:"phpType";s:6:"string";s:6:"dbType";s:8:"datetime";s:12:"defaultValue";O:17:"yii\db\Expression":2:{s:10:"expression";s:17:"CURRENT_TIMESTAMP";s:6:"params";a:0:{}}s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:0:"";s:18:"disableJsonSupport";b:0;}}}s:12:"cacheVersion";i:1;}i:1;O:25:"yii\caching\TagDependency":3:{s:4:"data";a:1:{s:32:"c13bddfe8939367e0c41d304534323a4";s:21:"0.86168900 1789734290";}s:8:"reusable";b:0;s:4:"tags";s:32:"448596f6b8386d6eafaeca295e344bd2";}}