a:2:{i:0;a:2:{s:6:"schema";O:18:"yii\db\TableSchema":7:{s:10:"schemaName";N;s:4:"name";s:14:"campaign_leads";s:8:"fullName";s:14:"campaign_leads";s:10:"primaryKey";a:1:{i:0;s:2:"id";}s:12:"sequenceName";s:0:"";s:11:"foreignKeys";a:1:{s:26:"fk_campaign_leads_campaign";a:2:{i:0;s:9:"campaigns";s:11:"campaign_id";s:2:"id";}}s:7:"columns";a:56:{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:11:"campaign_id";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:11:"campaign_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:9:"sheet_row";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:9:"sheet_row";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:61:"Row number in Google Sheet; used for dedup + incremental sync";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: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:6:"mobile";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:6:"mobile";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";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:0:"";s:18:"disableJsonSupport";b:0;}s:5:"email";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:5:"email";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:4:"city";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:4:"city";s:9:"allowNull";b:1;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:3:"age";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:3:"age";s:9:"allowNull";b:1;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:0:"";s:18:"disableJsonSupport";b:0;}s:6:"gender";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:6:"gender";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:11:"varchar(10)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:10;s:9:"precision";i:10;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:"package_interest";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:16:"package_interest";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:9:"lead_date";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:9:"lead_date";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:38:"Date lead submitted on the ad platform";s:18:"disableJsonSupport";b:0;}s:8:"raw_data";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:8:"raw_data";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:34:"Full JSON row from sheet for audit";s:18:"disableJsonSupport";b:0;}s:11:"call_status";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:11:"call_status";s:9:"allowNull";b:0;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:11:"varchar(30)";s:12:"defaultValue";s:7:"pending";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:55:"pending|called|converted|not_interested|callback|failed";s:18:"disableJsonSupport";b:0;}s:13:"funnel_status";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:13:"funnel_status";s:9:"allowNull";b:0;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:46:"enum('pending','valid','verified','forwarded')";s:12:"defaultValue";s:7:"pending";s:10:"enumValues";a:4:{i:0;s:7:"pending";i:1;s:5:"valid";i:2;s:8:"verified";i:3;s:9:"forwarded";}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:71:"Burger Singh 3-stage funnel, independent of call_status retry machinery";s:18:"disableJsonSupport";b:0;}s:12:"sales_status";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:12:"sales_status";s:9:"allowNull";b:0;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:113:"enum('new','contacted','follow_up_needed','interview_scheduled','not_reachable','on_hold','converted','rejected')";s:12:"defaultValue";s:3:"new";s:10:"enumValues";a:8:{i:0;s:3:"new";i:1;s:9:"contacted";i:2;s:16:"follow_up_needed";i:3;s:19:"interview_scheduled";i:4;s:13:"not_reachable";i:5;s:7:"on_hold";i:6;s:9:"converted";i:7;s:8:"rejected";}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:92:"Sales team pipeline status — independent of AI funnel_status, only relevant once forwarded";s:18:"disableJsonSupport";b:0;}s:17:"final_call_status";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:17:"final_call_status";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:119:"qualified|not_interested|budget_issue|doesnt_meet_criteria|callback_requested|wrong_number|unreachable|language_barrier";s:18:"disableJsonSupport";b:0;}s:13:"call_attempts";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:13:"call_attempts";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:0;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:14:"last_called_at";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:14:"last_called_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:9:"ai_intent";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:9:"ai_intent";s:9:"allowNull";b:1;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:10:"ai_summary";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"ai_summary";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: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: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:12:"is_forwarded";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:12:"is_forwarded";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 = exec has forwarded this lead to hospital";s:18:"disableJsonSupport";b:0;}s:12:"forwarded_at";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:12:"forwarded_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 when lead was forwarded";s:18:"disableJsonSupport";b:0;}s:12:"forwarded_by";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:12:"forwarded_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:35:"FK to users.id — who forwarded it";s:18:"disableJsonSupport";b:0;}s:17:"call_initiated_at";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:17:"call_initiated_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:44:"Unix timestamp when Bolna call was triggered";s:18:"disableJsonSupport";b:0;}s:21:"bolna_call_request_id";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:21:"bolna_call_request_id";s:9:"allowNull";b:1;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:58:"Bolna call ID returned on initiation, for webhook matching";s:18:"disableJsonSupport";b:0;}s:12:"next_call_at";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:12:"next_call_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:55:"Unix timestamp when next retry call should be triggered";s:18:"disableJsonSupport";b:0;}s:11:"max_retries";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:11:"max_retries";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:7;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:41:"Maximum call attempts allowed (default 7)";s:18:"disableJsonSupport";b:0;}s:12:"connected_at";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:12:"connected_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:45:"Unix timestamp of first successful connection";s:18:"disableJsonSupport";b:0;}s:21:"callback_scheduled_at";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:21:"callback_scheduled_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:57:"Specific callback time requested by lead (Unix timestamp)";s:18:"disableJsonSupport";b:0;}s:18:"franchise_interest";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:18:"franchise_interest";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:11:"varchar(10)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:10;s:9:"precision";i:10;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:6:"yes|no";s:18:"disableJsonSupport";b:0;}s:25:"store_management_personal";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:25:"store_management_personal";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:11:"varchar(10)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:10;s:9:"precision";i:10;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:14:"yes|no|unclear";s:18:"disableJsonSupport";b:0;}s:18:"current_occupation";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:18:"current_occupation";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:20:"business|job|unclear";s:18:"disableJsonSupport";b:0;}s:26:"prior_franchise_experience";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:26:"prior_franchise_experience";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:11:"varchar(10)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:10;s:9:"precision";i:10;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:14:"yes|no|unclear";s:18:"disableJsonSupport";b:0;}s:16:"partnership_type";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:16:"partnership_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:24:"solo|partnership|unclear";s:18:"disableJsonSupport";b:0;}s:13:"partner_count";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:13:"partner_count";s:9:"allowNull";b:1;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:0:"";s:18:"disableJsonSupport";b:0;}s:19:"owner_monthly_hours";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:19:"owner_monthly_hours";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:23:"shop_location_finalized";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:23:"shop_location_finalized";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:11:"varchar(10)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:10;s:9:"precision";i:10;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:6:"yes|no";s:18:"disableJsonSupport";b:0;}s:18:"property_ownership";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:18:"property_ownership";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:11:"varchar(10)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:10;s:9:"precision";i:10;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:16:"own|rent|unclear";s:18:"disableJsonSupport";b:0;}s:12:"ground_floor";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:12:"ground_floor";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:11:"varchar(10)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:10;s:9:"precision";i:10;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:14:"yes|no|unclear";s:18:"disableJsonSupport";b:0;}s:14:"shop_size_sqft";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:14:"shop_size_sqft";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:"pincode";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:7:"pincode";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:11:"varchar(10)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:10;s:9:"precision";i:10;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:"investment_ready";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:16:"investment_ready";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:11:"varchar(10)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:10;s:9:"precision";i:10;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:16:"yes|no|uncertain";s:18:"disableJsonSupport";b:0;}s:15:"interview_ready";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:15:"interview_ready";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:11:"varchar(10)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:10;s:9:"precision";i:10;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:6:"yes|no";s:18:"disableJsonSupport";b:0;}s:14:"interview_date";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:14:"interview_date";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:61:"raw string as captured — Hindi relative dates, can run long";s:18:"disableJsonSupport";b:0;}s:14:"interview_time";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:14:"interview_time";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:14:"internal_flags";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:14:"internal_flags";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:51:"JSON array of internal-only flags from agent prompt";s:18:"disableJsonSupport";b:0;}s:21:"forward_email_sent_at";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:21:"forward_email_sent_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:58:"Unix timestamp — null until CampaignForwardService sends";s:18:"disableJsonSupport";b:0;}s:17:"callback_attempts";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:17:"callback_attempts";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:0;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:49:"Auto-redial attempts for callback_requested leads";s:18:"disableJsonSupport";b:0;}s:21:"max_callback_attempts";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:21:"max_callback_attempts";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:3;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:65:"Give up after this many missed callback redials, revert to manual";s:18:"disableJsonSupport";b:0;}s:11:"sales_notes";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:11:"sales_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:16:"sales_updated_by";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:16:"sales_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:46:"FK to sales_agents.id — last agent to update";s:18:"disableJsonSupport";b:0;}s:16:"sales_updated_at";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:16:"sales_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:22:"interview_scheduled_at";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:22:"interview_scheduled_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:76:"Resolved IST timestamp from interview_date+interview_time, for calendar view";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:"13170ba96ea0588161e803488cef76ae";s:21:"0.85998000 1787140801";}s:8:"reusable";b:0;s:4:"tags";s:32:"1a820a95bf358be09cfc09a3ec7e2bbf";}}