a:2:{i:0;a:2:{s:6:"schema";O:18:"yii\db\TableSchema":7:{s:10:"schemaName";N;s:4:"name";s:12:"transactions";s:8:"fullName";s:12:"transactions";s:10:"primaryKey";a:1:{i:0;s:2:"id";}s:12:"sequenceName";s:0:"";s:11:"foreignKeys";a:4:{s:10:"booking_id";a:2:{i:0;s:7:"booking";s:10:"booking_id";s:2:"id";}s:19:"transactions_ibfk_1";a:2:{i:0;s:4:"user";s:7:"user_id";s:2:"id";}s:19:"transactions_ibfk_2";a:2:{i:0;s:4:"user";s:8:"agent_id";s:2:"id";}s:19:"transactions_ibfk_3";a:2:{i:0;s:4:"shop";s:7:"shop_id";s:2:"id";}}s:7:"columns";a:14:{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:16:"transaction_type";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:16:"transaction_type";s:9:"allowNull";b:0;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:57:"1=Payment, 2=Refund, 3=Booking, 4=Cancellation, 5=Earning";s:18:"disableJsonSupport";b:0;}s:12:"related_type";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:12:"related_type";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:53:"1=Payment, 2=Booking, 3=ExtendedBooking, 4=Withdrawal";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:10:"ID booking";s:18:"disableJsonSupport";b:0;}s:7:"user_id";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:7:"user_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:34:"User who initiated the transaction";s:18:"disableJsonSupport";b:0;}s:8:"agent_id";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:8:"agent_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:33:"Agent involved in the transaction";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:32:"Shop involved in the transaction";s:18:"disableJsonSupport";b:0;}s:12:"total_amount";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:12:"total_amount";s:9:"allowNull";b:0;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:18:"Transaction amount";s:18:"disableJsonSupport";b:0;}s:10:"sub_amount";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"sub_amount";s:9:"allowNull";b:0;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:24:"Subtotal before discount";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:1;s:4:"type";s:7:"tinyint";s:7:"phpType";s:7:"integer";s:6:"dbType";s:7:"tinyint";s:12:"defaultValue";i:1;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:45:"1=Pending, 2=Completed, 3=Failed, 4=Cancelled";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.03144400 1781034340";}s:8:"reusable";b:0;s:4:"tags";s:32:"8be6b63a26b15c2f12d384a84f8beb8c";}}