a:2:{i:0;a:2:{s:6:"schema";O:18:"yii\db\TableSchema":7:{s:10:"schemaName";N;s:4:"name";s:19:"doctor_availability";s:8:"fullName";s:19:"doctor_availability";s:10:"primaryKey";a:1:{i:0;s:2:"id";}s:12:"sequenceName";s:0:"";s:11:"foreignKeys";a:2:{s:15:"fk_avail_doctor";a:2:{i:0;s:7:"doctors";s:9:"doctor_id";s:2:"id";}s:17:"fk_avail_location";a:2:{i:0;s:9:"locations";s:11:"location_id";s:2:"id";}}s:7:"columns";a:10:{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:9:"doctor_id";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:9:"doctor_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:11:"location_id";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:11:"location_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:29:"NULL = location not specified";s:18:"disableJsonSupport";b:0;}s:11:"day_of_week";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:11:"day_of_week";s:9:"allowNull";b:0;s:4:"type";s:8:"smallint";s:7:"phpType";s:7:"integer";s:6:"dbType";s:11:"smallint(6)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:6;s:9:"precision";i:6;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:33:"0=Sunday, 1=Monday … 6=Saturday";s:18:"disableJsonSupport";b:0;}s:10:"start_time";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"start_time";s:9:"allowNull";b:0;s:4:"type";s:4:"time";s:7:"phpType";s:6:"string";s:6:"dbType";s:4:"time";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:13:"e.g. 09:00:00";s:18:"disableJsonSupport";b:0;}s:8:"end_time";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:8:"end_time";s:9:"allowNull";b:0;s:4:"type";s:4:"time";s:7:"phpType";s:6:"string";s:6:"dbType";s:4:"time";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:13:"e.g. 17:00:00";s:18:"disableJsonSupport";b:0;}s:21:"slot_duration_minutes";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:21:"slot_duration_minutes";s:9:"allowNull";b:0;s:4:"type";s:8:"smallint";s:7:"phpType";s:7:"integer";s:6:"dbType";s:11:"smallint(6)";s:12:"defaultValue";i:30;s:10:"enumValues";N;s:4:"size";i:6;s:9:"precision";i:6;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:"is_active";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:9:"is_active";s:9:"allowNull";b:0;s:4:"type";s:7:"tinyint";s:7:"phpType";s:7:"integer";s:6:"dbType";s:10:"tinyint(1)";s:12:"defaultValue";i:1;s:10:"enumValues";N;s:4:"size";i:1;s:9:"precision";i:1;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:"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: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:"updated_at";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"updated_at";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:12:"cacheVersion";i:1;}i:1;O:25:"yii\caching\TagDependency":3:{s:4:"data";a:1:{s:32:"eecbe9629df2940d8191e411484bb2d7";s:21:"0.08311700 1781956939";}s:8:"reusable";b:0;s:4:"tags";s:32:"a8eac7bcff307fafdf76c85b14f2e558";}}