a:2:{i:0;a:2:{s:6:"schema";O:18:"yii\db\TableSchema":7:{s:10:"schemaName";N;s:4:"name";s:24:"tbl_student_registration";s:8:"fullName";s:24:"tbl_student_registration";s:10:"primaryKey";a:1:{i:0;s:2:"id";}s:12:"sequenceName";s:0:"";s:11:"foreignKeys";a:5:{s:41:"fk_tbl_student_enrollment_tbl_status1_idx";a:2:{i:0;s:10:"tbl_status";s:9:"status_id";s:2:"id";}s:44:"fk_tbl_student_registration_tbl_semeter1_idx";a:2:{i:0;s:12:"tbl_semester";s:11:"semester_id";s:7:"auto_id";}s:44:"fk_tbl_student_registration_tbl_student1_idx";a:2:{i:0;s:11:"tbl_student";s:10:"student_id";s:2:"id";}s:41:"fk_tbl_student_registration_tbl_user1_idx";a:2:{i:0;s:8:"tbl_user";s:7:"user_id";s:2:"id";}s:28:"programme_curriculum_id1_idx";a:2:{i:0;s:24:"tbl_programme_curriculum";s:23:"programme_curriculum_id";s:2:"id";}}s:7:"columns";a:25:{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:0:"";s:18:"disableJsonSupport";b:0;}s:10:"student_id";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"student_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:0:"";s:18:"disableJsonSupport";b:0;}s:11:"semester_id";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:11:"semester_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:0:"";s:18:"disableJsonSupport";b:0;}s:23:"programme_curriculum_id";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:23:"programme_curriculum_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:0:"";s:18:"disableJsonSupport";b:0;}s:7:"room_id";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:7:"room_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:0:"";s:18:"disableJsonSupport";b:0;}s:9:"status_id";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:9:"status_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:0:"";s:18:"disableJsonSupport";b:0;}s:7:"user_id";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:7:"user_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:16:"fk from tbl user";s:18:"disableJsonSupport";b:0;}s:14:"nhif_exemption";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:14:"nhif_exemption";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";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:22:"0:No exemption, 1: Yes";s:18:"disableJsonSupport";b:0;}s:15:"nhif_updated_by";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:15:"nhif_updated_by";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:0:"";s:18:"disableJsonSupport";b:0;}s:10:"off_campus";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"off_campus";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";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:27:"0: In Campus, 1: Off campus";s:18:"disableJsonSupport";b:0;}s:3:"sps";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:3:"sps";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:57:"Student Payment Status 1:Not Paid, 2:Partial, 3:Full Paid";s:18:"disableJsonSupport";b:0;}s:3:"dvs";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:3:"dvs";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";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:75:"Document Verification  1:Not registered, 2:Partial registered, 3:Registered";s:18:"disableJsonSupport";b:0;}s:13:"registered_on";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:13:"registered_on";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";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:27:"Registered date if dvs is 3";s:18:"disableJsonSupport";b:0;}s:11:"sps_comment";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:11:"sps_comment";s:9:"allowNull";b:1;s:4:"type";s:4:"text";s:7:"phpType";s:6:"string";s:6:"dbType";s:4:"text";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:12:"SPS comments";s:18:"disableJsonSupport";b:0;}s:15:"sps_attachement";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:15:"sps_attachement";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:12:"varchar(255)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:255;s:9:"precision";i:255;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:16:"SPS attachements";s:18:"disableJsonSupport";b:0;}s:14:"sps_expiration";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:14:"sps_expiration";s:9:"allowNull";b:1;s:4:"type";s:4:"date";s:7:"phpType";s:6:"string";s:6:"dbType";s:4:"date";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:27:"For partial SPS must expire";s:18:"disableJsonSupport";b:0;}s:13:"year_of_study";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:13:"year_of_study";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";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,2,3,4,5,6,7,8,9,10";s:18:"disableJsonSupport";b:0;}s:6:"madeni";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:6:"madeni";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";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:20:"0:hadaiwi,1:anadaiwa";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:11:"dvs_updated";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:11:"dvs_updated";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";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: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:11:"conditional";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:11:"conditional";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:41:"0: Has no Conditional, 1: Has Conditional";s:18:"disableJsonSupport";b:0;}s:16:"conditional_date";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:16:"conditional_date";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";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:"Conditional registration date";s:18:"disableJsonSupport";b:0;}s:8:"is_waive";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:8:"is_waive";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:10:"madeni_old";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"madeni_old";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: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";}}