a:2:{i:0;a:2:{s:6:"schema";O:18:"yii\db\TableSchema":7:{s:10:"schemaName";N;s:4:"name";s:9:"campaigns";s:8:"fullName";s:9:"campaigns";s:10:"primaryKey";a:1:{i:0;s:2:"id";}s:12:"sequenceName";s:0:"";s:11:"foreignKeys";a:1:{s:18:"fk_campaigns_agent";a:2:{i:0;s:21:"campaign_bolna_agents";s:14:"bolna_agent_id";s:2:"id";}}s:7:"columns";a:23:{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: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(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:8:"platform";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:8:"platform";s:9:"allowNull";b:0;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:58:"meta|facebook|instagram|google_search|gdn|youtube|linkedin";s:18:"disableJsonSupport";b:0;}s:10:"start_date";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"start_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:8:"end_date";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:8:"end_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:15:"google_sheet_id";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:15:"google_sheet_id";s:9:"allowNull";b:0;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:12:"varchar(500)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:500;s:9:"precision";i:500;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:43:"Full Google Sheets URL or just the sheet ID";s:18:"disableJsonSupport";b:0;}s:9:"sheet_tab";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:9:"sheet_tab";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:26:"Tab name; null = first tab";s:18:"disableJsonSupport";b:0;}s:14:"bolna_agent_id";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:14:"bolna_agent_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:30:"FK to campaign_bolna_agents.id";s:18:"disableJsonSupport";b:0;}s:12:"booking_type";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:12:"booking_type";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:11:"varchar(20)";s:12:"defaultValue";N;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:23:"NULL | doctor | package";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:1;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:16:"int(11) unsigned";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:1;s:7:"comment";s:44:"FK → doctors.id when booking_type = doctor";s:18:"disableJsonSupport";b:0;}s:19:"alternate_doctor_id";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:19:"alternate_doctor_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:60:"FK → doctors.id — fallback if primary doctor unavailable";s:18:"disableJsonSupport";b:0;}s:10:"package_id";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"package_id";s:9:"allowNull";b:1;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:16:"int(11) unsigned";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:1;s:7:"comment";s:53:"FK → health_packages.id when booking_type = package";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:5:"draft";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:29:"draft|active|paused|completed";s:18:"disableJsonSupport";b:0;}s:11:"description";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:11:"description";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:18:"sheet_mapping_done";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:18:"sheet_mapping_done";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:44:"1 = column mapping configured, ready to sync";s:18:"disableJsonSupport";b:0;}s:20:"sheet_last_synced_at";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:20:"sheet_last_synced_at";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:38:"Unix timestamp of last successful pull";s:18:"disableJsonSupport";b:0;}s:21:"sheet_last_row_synced";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:21:"sheet_last_row_synced";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:64:"Last data row synced (row 1 = header); enables incremental pulls";s:18:"disableJsonSupport";b:0;}s:16:"sheet_sync_error";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:16:"sheet_sync_error";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:33:"Last sync error for display in UI";s:18:"disableJsonSupport";b:0;}s:17:"sheet_total_leads";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:17:"sheet_total_leads";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:32:"Total rows in sheet at last sync";s:18:"disableJsonSupport";b:0;}s:10:"created_by";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"created_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:"created_at";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"created_at";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:"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: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:"deleted_at";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"deleted_at";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:"eecbe9629df2940d8191e411484bb2d7";s:21:"0.40536400 1784031559";}s:8:"reusable";b:0;s:4:"tags";s:32:"a8eac7bcff307fafdf76c85b14f2e558";}}