a:2:{i:0;a:2:{s:6:"schema";O:18:"yii\db\TableSchema":7:{s:10:"schemaName";N;s:4:"name";s:12:"shop_earning";s:8:"fullName";s:12:"shop_earning";s:10:"primaryKey";a:1:{i:0;s:2:"id";}s:12:"sequenceName";s:0:"";s:11:"foreignKeys";a:4:{s:23:"fk_shop_earning_booking";a:2:{i:0;s:7:"booking";s:10:"booking_id";s:2:"id";}s:23:"fk_shop_earning_earning";a:2:{i:0;s:8:"earnings";s:10:"earning_id";s:2:"id";}s:23:"fk_shop_earning_payment";a:2:{i:0;s:7:"payment";s:10:"payment_id";s:2:"id";}s:20:"fk_shop_earning_shop";a:2:{i:0;s:4:"shop";s:7:"shop_id";s:2:"id";}}s:7:"columns";a:31:{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:12:"int unsigned";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:1;s:13:"autoIncrement";b:1;s:8:"unsigned";b:1;s:7:"comment";s:0:"";s:18:"disableJsonSupport";b:0;}s:10:"earning_id";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"earning_id";s:9:"allowNull";b:1;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:12:"int unsigned";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:1;s:7:"comment";s:27:"Reference to earnings table";s:18:"disableJsonSupport";b:0;}s:20:"payment_formatted_id";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:20:"payment_formatted_id";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:18:"NP-YMMXXXXX format";s:18:"disableJsonSupport";b:0;}s:20:"booking_formatted_id";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:20:"booking_formatted_id";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:18:"NB-YMMXXXXX format";s:18:"disableJsonSupport";b:0;}s:7:"shop_id";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:7:"shop_id";s:9:"allowNull";b:1;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:3:"int";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:16:"Shop that earned";s:18:"disableJsonSupport";b:0;}s:10:"booking_id";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"booking_id";s:9:"allowNull";b:1;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:12:"int unsigned";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:1;s:7:"comment";s:17:"Booking reference";s:18:"disableJsonSupport";b:0;}s:10:"payment_id";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"payment_id";s:9:"allowNull";b:1;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:12:"int unsigned";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:1;s:7:"comment";s:17:"Payment reference";s:18:"disableJsonSupport";b:0;}s:13:"customer_name";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:13:"customer_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:25:"Customer name for display";s:18:"disableJsonSupport";b:0;}s:12:"booking_date";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:12:"booking_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:21:"Booking creation date";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: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:24:"Appointment/service date";s:18:"disableJsonSupport";b:0;}s:14:"booking_status";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:14:"booking_status";s:9:"allowNull";b:1;s:4:"type";s:7:"tinyint";s:7:"phpType";s:7:"integer";s:6:"dbType";s:7:"tinyint";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:14:"Booking status";s:18:"disableJsonSupport";b:0;}s:10:"promo_code";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"promo_code";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:18:"Applied promo code";s:18:"disableJsonSupport";b:0;}s:16:"promo_percentage";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:16:"promo_percentage";s:9:"allowNull";b:1;s:4:"type";s:7:"decimal";s:7:"phpType";s:6:"string";s:6:"dbType";s:12:"decimal(5,2)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:5;s:9:"precision";i:5;s:5:"scale";i:2;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:21:"Promo code percentage";s:18:"disableJsonSupport";b:0;}s:8:"subtotal";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:8:"subtotal";s:9:"allowNull";b:1;s:4:"type";s:7:"decimal";s:7:"phpType";s:6:"string";s:6:"dbType";s:13:"decimal(10,2)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:10;s:9:"precision";i:10;s:5:"scale";i:2;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:25:"Subtotal before discounts";s:18:"disableJsonSupport";b:0;}s:14:"discount_value";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:14:"discount_value";s:9:"allowNull";b:1;s:4:"type";s:7:"decimal";s:7:"phpType";s:6:"string";s:6:"dbType";s:13:"decimal(10,2)";s:12:"defaultValue";s:4:"0.00";s:10:"enumValues";N;s:4:"size";i:10;s:9:"precision";i:10;s:5:"scale";i:2;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:14:"Discount value";s:18:"disableJsonSupport";b:0;}s:14:"promo_discount";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:14:"promo_discount";s:9:"allowNull";b:1;s:4:"type";s:7:"decimal";s:7:"phpType";s:6:"string";s:6:"dbType";s:13:"decimal(10,2)";s:12:"defaultValue";s:4:"0.00";s:10:"enumValues";N;s:4:"size";i:10;s:9:"precision";i:10;s:5:"scale";i:2;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:20:"Promo discount value";s:18:"disableJsonSupport";b:0;}s:12:"refund_value";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:12:"refund_value";s:9:"allowNull";b:1;s:4:"type";s:7:"decimal";s:7:"phpType";s:6:"string";s:6:"dbType";s:13:"decimal(10,2)";s:12:"defaultValue";s:4:"0.00";s:10:"enumValues";N;s:4:"size";i:10;s:9:"precision";i:10;s:5:"scale";i:2;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:12:"Refund value";s:18:"disableJsonSupport";b:0;}s:22:"final_collected_amount";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:22:"final_collected_amount";s:9:"allowNull";b:1;s:4:"type";s:7:"decimal";s:7:"phpType";s:6:"string";s:6:"dbType";s:13:"decimal(10,2)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:10;s:9:"precision";i:10;s:5:"scale";i:2;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:22:"Final collected amount";s:18:"disableJsonSupport";b:0;}s:8:"shop_vat";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:8:"shop_vat";s:9:"allowNull";b:1;s:4:"type";s:7:"decimal";s:7:"phpType";s:6:"string";s:6:"dbType";s:13:"decimal(10,2)";s:12:"defaultValue";s:4:"0.00";s:10:"enumValues";N;s:4:"size";i:10;s:9:"precision";i:10;s:5:"scale";i:2;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:"net_collected_excl_vat";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:22:"net_collected_excl_vat";s:9:"allowNull";b:1;s:4:"type";s:7:"decimal";s:7:"phpType";s:6:"string";s:6:"dbType";s:13:"decimal(10,2)";s:12:"defaultValue";s:4:"0.00";s:10:"enumValues";N;s:4:"size";i:10;s:9:"precision";i:10;s:5:"scale";i:2;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:28:"navagoo_marketing_percentage";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:28:"navagoo_marketing_percentage";s:9:"allowNull";b:1;s:4:"type";s:7:"decimal";s:7:"phpType";s:6:"string";s:6:"dbType";s:12:"decimal(5,2)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:5;s:9:"precision";i:5;s:5:"scale";i:2;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:28:"Navagoo marketing percentage";s:18:"disableJsonSupport";b:0;}s:22:"navagoo_marketing_fees";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:22:"navagoo_marketing_fees";s:9:"allowNull";b:1;s:4:"type";s:7:"decimal";s:7:"phpType";s:6:"string";s:6:"dbType";s:13:"decimal(10,2)";s:12:"defaultValue";s:4:"0.00";s:10:"enumValues";N;s:4:"size";i:10;s:9:"precision";i:10;s:5:"scale";i:2;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:22:"Navagoo marketing fees";s:18:"disableJsonSupport";b:0;}s:10:"tip_amount";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"tip_amount";s:9:"allowNull";b:1;s:4:"type";s:7:"decimal";s:7:"phpType";s:6:"string";s:6:"dbType";s:13:"decimal(10,2)";s:12:"defaultValue";s:4:"0.00";s:10:"enumValues";N;s:4:"size";i:10;s:9:"precision";i:10;s:5:"scale";i:2;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:10:"Tip amount";s:18:"disableJsonSupport";b:0;}s:22:"net_collectible_amount";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:22:"net_collectible_amount";s:9:"allowNull";b:1;s:4:"type";s:7:"decimal";s:7:"phpType";s:6:"string";s:6:"dbType";s:13:"decimal(10,2)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:10;s:9:"precision";i:10;s:5:"scale";i:2;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:35:"Net collectible amount (calculated)";s:18:"disableJsonSupport";b:0;}s:19:"transfer_request_id";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:19:"transfer_request_id";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:19:"Transfer request ID";s:18:"disableJsonSupport";b:0;}s:13:"withdrawal_id";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:13:"withdrawal_id";s:9:"allowNull";b:1;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:3:"int";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:17:"settlement_status";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:17:"settlement_status";s:9:"allowNull";b:1;s:4:"type";s:7:"tinyint";s:7:"phpType";s:7:"integer";s:6:"dbType";s:7:"tinyint";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:17:"Settlement status";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:3:"int";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:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:3:"int";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_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:3:"int";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_by";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"updated_by";s:9:"allowNull";b:1;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:3:"int";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:12:"cacheVersion";i:1;}i:1;O:25:"yii\caching\TagDependency":3:{s:4:"data";a:1:{s:32:"8acc260eb18a90ef8e1e2ac3ed1a4e99";s:21:"0.45856200 1781042842";}s:8:"reusable";b:0;s:4:"tags";s:32:"8be6b63a26b15c2f12d384a84f8beb8c";}}