a:2:{i:0;a:2:{s:6:"schema";O:18:"yii\db\TableSchema":7:{s:10:"schemaName";N;s:4:"name";s:12:"appointments";s:8:"fullName";s:12:"appointments";s:10:"primaryKey";a:1:{i:0;s:2:"id";}s:12:"sequenceName";s:0:"";s:11:"foreignKeys";a:3:{s:17:"fk_appt_booked_by";a:2:{i:0;s:5:"users";s:9:"booked_by";s:2:"id";}s:14:"fk_appt_doctor";a:2:{i:0;s:7:"doctors";s:9:"doctor_id";s:2:"id";}s:16:"fk_appt_location";a:2:{i:0;s:9:"locations";s:11:"location_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:0:"";s:18:"disableJsonSupport";b:0;}s:12:"reference_no";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:12:"reference_no";s:9:"allowNull";b:0;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:11:"varchar(12)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:12;s:9:"precision";i:12;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:45:"e.g. FBX-A3X9KW — generated at booking time";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:54:"FK to locations — clinic where appointment is booked";s:18:"disableJsonSupport";b:0;}s:9:"booked_by";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:9:"booked_by";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:47:"FK to users — the call centre exec who booked";s:18:"disableJsonSupport";b:0;}s:12:"patient_name";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:12:"patient_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:13:"patient_phone";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:13:"patient_phone";s:9:"allowNull";b:0;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:11:"varchar(15)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:15;s:9:"precision";i:15;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:15:"patient_address";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:15:"patient_address";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:0:"";s:18:"disableJsonSupport";b:0;}s:12:"patient_city";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:12:"patient_city";s:9:"allowNull";b:0;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:11:"varchar(80)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:80;s:9:"precision";i:80;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:13:"patient_state";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:13:"patient_state";s:9:"allowNull";b:0;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:11:"varchar(80)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:80;s:9:"precision";i:80;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:16:"appointment_date";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:16:"appointment_date";s:9:"allowNull";b:0;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:0:"";s:18:"disableJsonSupport";b:0;}s:16:"appointment_time";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:16:"appointment_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:25:"Slot start, e.g. 09:30:00";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:11:"varchar(20)";s:12:"defaultValue";s:9:"confirmed";s:10:"enumValues";N;s:4:"size";i:20;s:9:"precision";i:20;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:43:"confirmed | cancelled | completed | no_show";s:18:"disableJsonSupport";b:0;}s:14:"booking_source";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:14:"booking_source";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:11:"varchar(30)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:30;s:9:"precision";i:30;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:45:"call_centre | campaign | front_desk | walk_in";s:18:"disableJsonSupport";b:0;}s:11:"call_source";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:11:"call_source";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:11:"varchar(50)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:50;s:9:"precision";i:50;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:13:"campaign_name";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:13:"campaign_name";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:12:"varchar(120)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:120;s:9:"precision";i:120;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:59:"Campaign label — populated when booking_source = campaign";s:18:"disableJsonSupport";b:0;}s:8:"sms_sent";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:8:"sms_sent";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:0;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:"email_sent";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"email_sent";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:0;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:5:"notes";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:5:"notes";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: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.45751400 1781687405";}s:8:"reusable";b:0;s:4:"tags";s:32:"a8eac7bcff307fafdf76c85b14f2e558";}}