--
-- Host: localhost    Database: moneyexchange2
-- ------------------------------------------------------


--
-- Table structure for table `bank_account_transaction_types`
--

CREATE TABLE `bank_account_transaction_types` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `return_credit` tinyint(1) NOT NULL DEFAULT '1',
  `order` int DEFAULT NULL,
  `note` text COLLATE utf8mb4_unicode_ci,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `bank_account_transaction_types_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bank_account_transaction_types`
--

INSERT INTO `bank_account_transaction_types` VALUES (1,'ក្រឌីត',1,1,1,NULL,NULL,'2022-08-22 18:06:36','2022-08-22 18:06:55'),(2,'ឌីប៊ីត',1,1,2,NULL,NULL,'2022-08-22 18:07:06','2022-08-22 18:07:06'),(3,'បន្ថែមទឹកលុយ',1,0,3,NULL,NULL,'2022-08-22 18:07:22','2022-08-22 18:07:22'),(4,'កំចី',1,0,4,NULL,NULL,'2022-08-22 18:07:36','2022-08-22 18:07:42'),(5,'Quick Wallet',1,0,5,NULL,NULL,'2022-08-22 18:08:00','2022-08-22 18:09:05');

--
-- Table structure for table `bank_account_transactions`
--

CREATE TABLE `bank_account_transactions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `bank_account_id` bigint unsigned DEFAULT NULL,
  `transaction_type` enum('in','out') COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` double NOT NULL,
  `credit_before_transaction` double NOT NULL,
  `credit_after_transaction` double NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `note` text COLLATE utf8mb4_unicode_ci,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `transaction_id` bigint unsigned DEFAULT NULL,
  `transfer_id` bigint unsigned DEFAULT NULL,
  `bank_account_transaction_type_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=622 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bank_account_transactions`
--

INSERT INTO `bank_account_transactions` VALUES (443,27,'in',1000000,0,1000000,3,NULL,NULL,'2022-08-31 02:52:40','2022-08-31 02:52:40',NULL,NULL,1),(444,3,'out',1000000,0,-1000000,3,'transfer from:443',NULL,'2022-08-31 02:52:40','2022-08-31 02:52:40',NULL,NULL,NULL),(445,26,'in',30000,0,30000,3,NULL,NULL,'2022-08-31 02:52:50','2022-08-31 02:52:50',NULL,NULL,1),(446,2,'out',30000,0,-30000,3,'transfer from:445',NULL,'2022-08-31 02:52:50','2022-08-31 02:52:50',NULL,NULL,NULL),(447,25,'in',1000,0,1000,3,NULL,NULL,'2022-08-31 02:53:02','2022-08-31 02:53:02',NULL,NULL,1),(448,1,'out',1000,0,-1000,3,'transfer from:447',NULL,'2022-08-31 02:53:02','2022-08-31 02:53:02',NULL,NULL,NULL),(449,24,'in',1000000,0,1000000,3,NULL,NULL,'2022-08-31 02:53:15','2022-08-31 02:53:15',NULL,NULL,1),(450,3,'out',1000000,-1000000,-2000000,3,'transfer from:449',NULL,'2022-08-31 02:53:15','2022-08-31 02:53:15',NULL,NULL,NULL),(451,23,'in',30000,0,30000,3,NULL,NULL,'2022-08-31 02:53:25','2022-08-31 02:53:25',NULL,NULL,1),(452,2,'out',30000,-30000,-60000,3,'transfer from:451',NULL,'2022-08-31 02:53:25','2022-08-31 02:53:25',NULL,NULL,NULL),(453,22,'in',1000,0,1000,3,NULL,NULL,'2022-08-31 02:53:35','2022-08-31 02:53:35',NULL,NULL,1),(454,1,'out',1000,-1000,-2000,3,'transfer from:453',NULL,'2022-08-31 02:53:35','2022-08-31 02:53:35',NULL,NULL,NULL),(455,21,'in',1000000,0,1000000,3,NULL,NULL,'2022-08-31 02:53:46','2022-08-31 02:53:46',NULL,NULL,1),(456,3,'out',1000000,-2000000,-3000000,3,'transfer from:455',NULL,'2022-08-31 02:53:46','2022-08-31 02:53:46',NULL,NULL,NULL),(457,20,'in',30000,0,30000,3,NULL,NULL,'2022-08-31 02:53:58','2022-08-31 02:53:58',NULL,NULL,1),(458,2,'out',30000,-60000,-90000,3,'transfer from:457',NULL,'2022-08-31 02:53:58','2022-08-31 02:53:58',NULL,NULL,NULL),(459,19,'in',1000,0,1000,3,NULL,NULL,'2022-08-31 02:54:13','2022-08-31 02:54:13',NULL,NULL,1),(460,1,'out',1000,-2000,-3000,3,'transfer from:459',NULL,'2022-08-31 02:54:13','2022-08-31 02:54:13',NULL,NULL,NULL),(461,15,'in',1000000,0,1000000,3,NULL,NULL,'2022-08-31 02:55:10','2022-08-31 02:55:10',NULL,NULL,1),(462,3,'out',1000000,-3000000,-4000000,3,'transfer from:461',NULL,'2022-08-31 02:55:10','2022-08-31 02:55:10',NULL,NULL,NULL),(463,14,'in',30000,0,30000,3,NULL,NULL,'2022-08-31 02:55:21','2022-08-31 02:55:21',NULL,NULL,1),(464,2,'out',30000,-90000,-120000,3,'transfer from:463',NULL,'2022-08-31 02:55:21','2022-08-31 02:55:21',NULL,NULL,NULL),(465,13,'in',1000,0,1000,3,NULL,NULL,'2022-08-31 02:55:32','2022-08-31 02:55:32',NULL,NULL,1),(466,1,'out',1000,-3000,-4000,3,'transfer from:465',NULL,'2022-08-31 02:55:32','2022-08-31 02:55:32',NULL,NULL,NULL),(467,12,'in',1000000,0,1000000,3,NULL,NULL,'2022-08-31 02:55:47','2022-08-31 02:55:47',NULL,NULL,1),(468,3,'out',1000000,-4000000,-5000000,3,'transfer from:467',NULL,'2022-08-31 02:55:47','2022-08-31 02:55:47',NULL,NULL,NULL),(469,11,'in',30000,0,30000,3,NULL,NULL,'2022-08-31 02:55:58','2022-08-31 02:55:58',NULL,NULL,1),(470,2,'out',30000,-120000,-150000,3,'transfer from:469',NULL,'2022-08-31 02:55:58','2022-08-31 02:55:58',NULL,NULL,NULL),(471,10,'in',1000,0,1000,3,NULL,NULL,'2022-08-31 02:56:08','2022-08-31 02:56:08',NULL,NULL,1),(472,1,'out',1000,-4000,-5000,3,'transfer from:471',NULL,'2022-08-31 02:56:08','2022-08-31 02:56:08',NULL,NULL,NULL),(473,9,'in',1000000,0,1000000,3,NULL,NULL,'2022-08-31 02:56:21','2022-08-31 02:56:21',NULL,NULL,1),(474,3,'out',1000000,-5000000,-6000000,3,'transfer from:473',NULL,'2022-08-31 02:56:21','2022-08-31 02:56:21',NULL,NULL,NULL),(475,8,'in',30000,0,30000,3,NULL,NULL,'2022-08-31 02:56:34','2022-08-31 02:56:34',NULL,NULL,1),(476,2,'out',30000,-150000,-180000,3,'transfer from:475',NULL,'2022-08-31 02:56:34','2022-08-31 02:56:34',NULL,NULL,NULL),(477,7,'in',1000,0,1000,3,NULL,NULL,'2022-08-31 02:56:44','2022-08-31 02:56:44',NULL,NULL,1),(478,1,'out',1000,-5000,-6000,3,'transfer from:477',NULL,'2022-08-31 02:56:44','2022-08-31 02:56:44',NULL,NULL,NULL),(479,6,'in',1000000,0,1000000,3,NULL,NULL,'2022-08-31 02:59:05','2022-08-31 02:59:05',NULL,NULL,1),(480,3,'out',1000000,-6000000,-7000000,3,'transfer from:479',NULL,'2022-08-31 02:59:05','2022-08-31 02:59:05',NULL,NULL,NULL),(481,5,'in',50000,0,50000,3,NULL,NULL,'2022-08-31 02:59:17','2022-08-31 02:59:17',NULL,NULL,1),(482,2,'out',50000,-180000,-230000,3,'transfer from:481',NULL,'2022-08-31 02:59:17','2022-08-31 02:59:17',NULL,NULL,NULL),(483,4,'in',5000,0,5000,3,NULL,NULL,'2022-08-31 02:59:28','2022-08-31 02:59:28',NULL,NULL,1),(484,1,'out',5000,-6000,-11000,3,'transfer from:483',NULL,'2022-08-31 02:59:28','2022-08-31 02:59:28',NULL,NULL,NULL),(485,3,'in',7000000,-7000000,0,3,NULL,NULL,'2022-08-31 03:00:32','2022-08-31 03:00:32',NULL,NULL,2),(486,2,'in',230000,-230000,0,3,NULL,NULL,'2022-08-31 03:00:48','2022-08-31 03:00:48',NULL,NULL,2),(487,8,'in',20000,30000,50000,3,NULL,NULL,'2022-08-31 03:01:05','2022-08-31 03:01:05',NULL,NULL,1),(488,2,'out',20000,0,-20000,3,'transfer from:487',NULL,'2022-08-31 03:01:05','2022-08-31 03:01:05',NULL,NULL,NULL),(489,7,'in',4000,1000,5000,3,NULL,NULL,'2022-08-31 03:01:16','2022-08-31 03:01:16',NULL,NULL,1),(490,1,'out',4000,-11000,-15000,3,'transfer from:489',NULL,'2022-08-31 03:01:16','2022-08-31 03:01:16',NULL,NULL,NULL),(491,2,'in',20000,-20000,0,3,NULL,NULL,'2022-08-31 03:01:29','2022-08-31 03:01:29',NULL,NULL,2),(492,1,'in',15000,-15000,0,3,NULL,NULL,'2022-08-31 03:01:42','2022-08-31 03:01:42',NULL,NULL,2),(493,11,'in',2541,30000,32541,6,'t-169',NULL,'2022-08-31 03:47:33','2022-08-31 03:47:33',169,NULL,NULL),(494,10,'out',70.06,1000,929.94,6,'t-169',NULL,'2022-08-31 03:47:33','2022-08-31 03:47:33',169,NULL,NULL),(495,11,'in',459,32541,33000,6,'t-170',NULL,'2022-08-31 03:48:25','2022-08-31 03:48:25',170,NULL,NULL),(496,12,'out',52004.7,1000000,947995.3,6,'t-170',NULL,'2022-08-31 03:48:25','2022-08-31 03:48:25',170,NULL,NULL),(497,14,'in',1500,30000,31500,7,'t-171',NULL,'2022-08-31 10:31:18','2022-08-31 10:31:18',171,NULL,NULL),(498,15,'out',169950,1000000,830050,7,'t-171',NULL,'2022-08-31 10:31:18','2022-08-31 10:31:18',171,NULL,NULL),(499,1,'in',10000,0,10000,3,NULL,NULL,'2022-08-31 10:44:09','2022-08-31 10:44:09',NULL,NULL,2),(500,2,'in',362800,0,362800,3,'t-172',NULL,'2022-08-31 10:44:53','2022-08-31 10:44:53',172,NULL,NULL),(501,1,'out',10000,10000,0,3,'t-172',NULL,'2022-08-31 10:44:53','2022-08-31 10:44:53',172,NULL,NULL),(502,22,'in',2,1000,1002,10,'t-173',NULL,'2022-09-01 01:25:09','2022-09-01 01:25:09',173,NULL,NULL),(503,23,'out',72.14,30000,29927.86,10,'t-173',NULL,'2022-09-01 01:25:09','2022-09-01 01:25:09',173,NULL,NULL),(504,4,'in',50,5000,5050,4,'t-174',NULL,'2022-09-01 01:35:17','2022-09-01 01:35:17',174,NULL,NULL),(505,6,'out',205250,1000000,794750,4,'t-174',NULL,'2022-09-01 01:35:17','2022-09-01 01:35:17',174,NULL,NULL),(506,5,'in',500,50000,50500,4,'t-175',NULL,'2022-09-01 03:29:20','2022-09-01 03:29:20',175,NULL,NULL),(507,6,'out',56550,794750,738200,4,'t-175',NULL,'2022-09-01 03:29:20','2022-09-01 03:29:20',175,NULL,NULL),(508,19,'in',500,1000,1500,9,'t-176',NULL,'2022-09-01 04:22:14','2022-09-01 04:22:14',176,NULL,NULL),(509,20,'out',18000,30000,12000,9,'t-176',NULL,'2022-09-01 04:22:14','2022-09-01 04:22:14',176,NULL,NULL),(510,23,'in',100,29927.86,30027.86,10,'t-177',NULL,'2022-09-01 04:23:30','2022-09-01 04:23:30',177,NULL,NULL),(511,24,'out',11310,1000000,988690,10,'t-177',NULL,'2022-09-01 04:23:30','2022-09-01 04:23:30',177,NULL,NULL),(512,13,'in',500,1000,1500,7,'t-178',NULL,'2022-09-01 05:02:17','2022-09-01 05:02:17',178,NULL,NULL),(513,14,'out',18000,31500,13500,7,'t-178',NULL,'2022-09-01 05:02:17','2022-09-01 05:02:17',178,NULL,NULL),(514,4,'in',1000,5050,6050,4,'t-179',NULL,'2022-09-01 05:26:03','2022-09-01 05:26:03',179,NULL,NULL),(515,5,'out',36000,50500,14500,4,'t-179',NULL,'2022-09-01 05:26:03','2022-09-01 05:26:03',179,NULL,NULL),(516,8,'in',3000,50000,53000,5,'t-180',NULL,'2022-09-01 06:28:20','2022-09-01 06:28:20',180,NULL,NULL),(517,9,'out',338400,1000000,661600,5,'t-180',NULL,'2022-09-01 06:28:20','2022-09-01 06:28:20',180,NULL,NULL),(518,7,'in',100,5000,5100,5,'t-181',NULL,'2022-09-01 06:51:34','2022-09-01 06:51:34',181,NULL,NULL),(519,9,'out',410500,661600,251100,5,'t-181',NULL,'2022-09-01 06:51:34','2022-09-01 06:51:34',181,NULL,NULL),(520,8,'in',27390,53000,80390,5,'t-182',NULL,'2022-09-01 07:45:42','2022-09-01 07:45:42',182,NULL,NULL),(521,7,'out',750,5100,4350,5,'t-182',NULL,'2022-09-01 07:45:42','2022-09-01 07:45:42',182,NULL,NULL),(522,5,'in',100000,14500,114500,4,'t-183',NULL,'2022-09-01 07:51:37','2022-09-01 07:51:37',183,NULL,NULL),(523,4,'out',2738.23,6050,3311.77,4,'t-183',NULL,'2022-09-01 07:51:37','2022-09-01 07:51:37',183,NULL,NULL),(524,2,'in',802340,362800,1165140,3,'t-184',NULL,'2022-09-01 09:44:39','2022-09-01 09:44:39',184,NULL,NULL),(525,1,'out',22000,0,-22000,3,'t-184',NULL,'2022-09-01 09:44:39','2022-09-01 09:44:39',184,NULL,NULL),(526,2,'in',319147,1165140,1484287,3,'t-185',NULL,'2022-09-01 09:56:13','2022-09-01 09:56:13',185,NULL,NULL),(527,1,'out',8775.01,-22000,-30775.01,3,'t-185',NULL,'2022-09-01 09:56:13','2022-09-01 09:56:13',185,NULL,NULL),(528,8,'in',1880,80390,82270,5,'t-186',NULL,'2022-09-01 10:09:46','2022-09-01 10:09:46',186,NULL,NULL),(529,9,'out',212064,251100,39036,5,'t-186',NULL,'2022-09-01 10:09:46','2022-09-01 10:09:46',186,NULL,NULL),(530,1,'in',3200,-30775.01,-27575.01,3,'t-187',NULL,'2022-09-01 10:16:06','2022-09-01 10:16:06',187,NULL,NULL),(531,3,'out',13136000,0,-13136000,3,'t-187',NULL,'2022-09-01 10:16:06','2022-09-01 10:16:06',187,NULL,NULL),(532,23,'in',1000,30027.86,31027.86,10,'t-188',NULL,'2022-09-01 10:37:58','2022-09-01 10:37:58',188,NULL,NULL),(533,24,'out',112800,988690,875890,10,'t-188',NULL,'2022-09-01 10:37:58','2022-09-01 10:37:58',188,NULL,NULL),(534,14,'in',1000,13500,14500,7,'t-189',NULL,'2022-09-01 10:40:30','2022-09-01 10:40:30',189,NULL,NULL),(535,15,'out',112800,830050,717250,7,'t-189',NULL,'2022-09-01 10:40:30','2022-09-01 10:40:30',189,NULL,NULL),(536,2,'in',1780639,1484287,3264926,3,'t-190',NULL,'2022-09-01 10:45:38','2022-09-01 10:45:38',190,NULL,NULL),(537,1,'out',48959,-27575.01,-76534.01,3,'t-190',NULL,'2022-09-01 10:45:38','2022-09-01 10:45:38',190,NULL,NULL),(538,2,'in',1135553,3264926,4400479,3,'t-191',NULL,'2022-09-01 10:46:35','2022-09-01 10:46:35',191,NULL,NULL),(539,1,'out',31094,-76534.01,-107628.01,3,'t-191',NULL,'2022-09-01 10:46:35','2022-09-01 10:46:35',191,NULL,NULL),(540,22,'in',100,1002,1102,10,'t-192',NULL,'2022-09-02 01:57:27','2022-09-02 01:57:27',192,NULL,NULL),(541,23,'out',3615,31027.86,27412.86,10,'t-192',NULL,'2022-09-02 01:57:27','2022-09-02 01:57:27',192,NULL,NULL),(542,22,'in',170,1102,1272,10,'t-193',NULL,'2022-09-02 02:03:30','2022-09-02 02:03:30',193,NULL,NULL),(543,23,'out',6145.5,27412.86,21267.36,10,'t-193',NULL,'2022-09-02 02:03:30','2022-09-02 02:03:30',193,NULL,NULL),(544,14,'in',18290,14500,32790,7,'t-194',NULL,'2022-09-02 03:18:19','2022-09-02 03:18:19',194,NULL,NULL),(545,13,'out',500,1500,1000,7,'t-194',NULL,'2022-09-02 03:18:19','2022-09-02 03:18:19',194,NULL,NULL),(546,14,'in',1000,32790,33790,7,'t-195',NULL,'2022-09-02 03:58:13','2022-09-02 03:58:13',195,NULL,NULL),(547,15,'out',112800,717250,604450,7,'t-195',NULL,'2022-09-02 03:58:13','2022-09-02 03:58:13',195,NULL,NULL),(548,14,'in',100,33790,33890,7,'t-196',NULL,'2022-09-02 04:27:03','2022-09-02 04:27:03',196,NULL,NULL),(549,15,'out',11280,604450,593170,7,'t-196',NULL,'2022-09-02 04:27:03','2022-09-02 04:27:03',196,NULL,NULL),(550,7,'in',50,4350,4400,5,'t-197',NULL,'2022-09-02 04:27:18','2022-09-02 04:27:18',197,NULL,NULL),(551,8,'out',1807.5,82270,80462.5,5,'t-197',NULL,'2022-09-02 04:27:18','2022-09-02 04:27:18',197,NULL,NULL),(552,23,'in',300,21267.36,21567.36,10,'t-198',NULL,'2022-09-02 04:30:13','2022-09-02 04:30:13',198,NULL,NULL),(553,24,'out',33840,875890,842050,10,'t-198',NULL,'2022-09-02 04:30:13','2022-09-02 04:30:13',198,NULL,NULL),(554,14,'in',100,33890,33990,7,'t-199',NULL,'2022-09-02 05:50:24','2022-09-02 05:50:24',199,NULL,NULL),(555,15,'out',11280,593170,581890,7,'t-199',NULL,'2022-09-02 05:50:24','2022-09-02 05:50:24',199,NULL,NULL),(556,14,'in',1000,33990,34990,7,'t-200',NULL,'2022-09-02 05:58:45','2022-09-02 05:58:45',200,NULL,NULL),(557,15,'out',112800,581890,469090,7,'t-200',NULL,'2022-09-02 05:58:45','2022-09-02 05:58:45',200,NULL,NULL),(558,12,'in',2472000,947995.3,3419995.3,6,'t-201',NULL,'2022-09-02 06:06:26','2022-09-02 06:06:26',201,NULL,NULL),(559,10,'out',600,929.94,329.94,6,'t-201',NULL,'2022-09-02 06:06:26','2022-09-02 06:06:26',201,NULL,NULL),(560,8,'in',1000,80462.5,81462.5,5,'t-202',NULL,'2022-09-02 06:16:51','2022-09-02 06:16:51',202,NULL,NULL),(561,9,'out',112800,39036,-73764,5,'t-202',NULL,'2022-09-02 06:16:51','2022-09-02 06:16:51',202,NULL,NULL),(562,5,'in',5031,114500,119531,4,'t-203',NULL,'2022-09-02 06:36:59','2022-09-02 06:36:59',203,NULL,NULL),(563,6,'out',567496.8,738200,170703.2,4,'t-203',NULL,'2022-09-02 06:36:59','2022-09-02 06:36:59',203,NULL,NULL),(564,10,'in',100,329.94,429.94,6,'t-204',NULL,'2022-09-02 06:46:28','2022-09-02 06:46:28',204,NULL,NULL),(565,11,'out',3615,33000,29385,6,'t-204',NULL,'2022-09-02 06:46:28','2022-09-02 06:46:28',204,NULL,NULL),(566,7,'in',1000,4400,5400,5,'t-205',NULL,'2022-09-02 06:46:36','2022-09-02 06:46:36',205,NULL,NULL),(567,8,'out',36150,81462.5,45312.5,5,'t-205',NULL,'2022-09-02 06:46:36','2022-09-02 06:46:36',205,NULL,NULL),(568,10,'in',100,429.94,529.94,6,'t-206','2022-09-02 07:28:08','2022-09-02 06:46:37','2022-09-02 07:28:08',206,NULL,NULL),(569,12,'out',410500,3419995.3,3009495.3,6,'t-206','2022-09-02 07:28:08','2022-09-02 06:46:37','2022-09-02 07:28:08',206,NULL,NULL),(570,7,'in',100,5400,5500,5,'t-207',NULL,'2022-09-02 06:49:22','2022-09-02 06:49:22',207,NULL,NULL),(571,9,'out',410500,-73764,-484264,5,'t-207',NULL,'2022-09-02 06:49:22','2022-09-02 06:49:22',207,NULL,NULL),(572,13,'in',1000,1000,2000,7,'t-208',NULL,'2022-09-02 07:38:42','2022-09-02 07:38:42',208,NULL,NULL),(573,14,'out',36300,34990,-1310,7,'t-208',NULL,'2022-09-02 07:38:42','2022-09-02 07:38:42',208,NULL,NULL),(574,11,'in',2000,29385,31385,6,'t-209',NULL,'2022-09-02 08:13:34','2022-09-02 08:13:34',209,NULL,NULL),(575,12,'out',225600,3419995.3,3194395.3,6,'t-209',NULL,'2022-09-02 08:13:34','2022-09-02 08:13:34',209,NULL,NULL),(576,11,'in',4000,31385,35385,6,'t-210',NULL,'2022-09-02 08:13:50','2022-09-02 08:13:50',210,NULL,NULL),(577,12,'out',451200,3194395.3,2743195.3,6,'t-210',NULL,'2022-09-02 08:13:50','2022-09-02 08:13:50',210,NULL,NULL),(578,7,'in',200,5500,5700,5,'t-211',NULL,'2022-09-02 08:25:29','2022-09-02 08:25:29',211,NULL,NULL),(579,8,'out',7260,45312.5,38052.5,5,'t-211',NULL,'2022-09-02 08:25:29','2022-09-02 08:25:29',211,NULL,NULL),(580,14,'in',3665,-1310,2355,7,'t-212',NULL,'2022-09-02 09:17:30','2022-09-02 09:17:30',212,NULL,NULL),(581,13,'out',100,2000,1900,7,'t-212',NULL,'2022-09-02 09:17:30','2022-09-02 09:17:30',212,NULL,NULL),(582,23,'in',100,21567.36,21667.36,10,'t-213',NULL,'2022-09-02 09:21:33','2022-09-02 09:21:33',213,NULL,NULL),(583,24,'out',11280,842050,830770,10,'t-213',NULL,'2022-09-02 09:21:33','2022-09-02 09:21:33',213,NULL,NULL),(584,24,'in',8240,830770,839010,10,'t-214',NULL,'2022-09-02 09:31:54','2022-09-02 09:31:54',214,NULL,NULL),(585,22,'out',2,1272,1270,10,'t-214',NULL,'2022-09-02 09:31:54','2022-09-02 09:31:54',214,NULL,NULL),(586,10,'in',100,429.94,529.94,6,'t-215',NULL,'2022-09-02 09:33:39','2022-09-02 09:33:39',215,NULL,NULL),(587,11,'out',3630,35385,31755,6,'t-215',NULL,'2022-09-02 09:33:39','2022-09-02 09:33:39',215,NULL,NULL),(588,11,'in',5000,31755,36755,6,'t-216','2022-09-02 09:35:53','2022-09-02 09:34:28','2022-09-02 09:35:53',216,NULL,NULL),(589,12,'out',564000,2743195.3,2179195.3,6,'t-216','2022-09-02 09:35:53','2022-09-02 09:34:28','2022-09-02 09:35:53',216,NULL,NULL),(590,11,'in',5002,36755,41757,6,'t-217',NULL,'2022-09-02 09:35:46','2022-09-02 09:35:46',217,NULL,NULL),(591,12,'out',564225.6,2179195.3,1614969.7,6,'t-217',NULL,'2022-09-02 09:35:46','2022-09-02 09:35:46',217,NULL,NULL),(592,8,'in',109.95,38052.5,38162.45,5,'t-218',NULL,'2022-09-02 09:45:14','2022-09-02 09:45:14',218,NULL,NULL),(593,7,'out',3,5700,5697,5,'t-218',NULL,'2022-09-02 09:45:14','2022-09-02 09:45:14',218,NULL,NULL),(594,12,'in',5200,2178969.7,2184169.7,6,'t-219',NULL,'2022-09-02 10:01:48','2022-09-02 10:01:48',219,NULL,NULL),(595,11,'out',45.81,36757,36711.19,6,'t-219',NULL,'2022-09-02 10:01:48','2022-09-02 10:01:48',219,NULL,NULL),(596,6,'in',155000,170703.2,325703.2,4,'t-220',NULL,'2022-09-02 10:19:17','2022-09-02 10:19:17',220,NULL,NULL),(597,4,'out',37.62,3311.77,3274.15,4,'t-220',NULL,'2022-09-02 10:19:17','2022-09-02 10:19:17',220,NULL,NULL),(598,4,'in',0.62,3274.15,3274.77,4,'t-221',NULL,'2022-09-02 10:19:29','2022-09-02 10:19:29',221,NULL,NULL),(599,6,'out',2545.1,325703.2,323158.1,4,'t-221',NULL,'2022-09-02 10:19:29','2022-09-02 10:19:29',221,NULL,NULL),(600,14,'in',1100,2355,3455,7,'t-222',NULL,'2022-09-02 10:19:48','2022-09-02 10:19:48',222,NULL,NULL),(601,13,'out',30.01,1900,1869.99,7,'t-222',NULL,'2022-09-02 10:19:48','2022-09-02 10:19:48',222,NULL,NULL),(602,15,'in',11400,469090,480490,7,'t-223',NULL,'2022-09-02 10:31:50','2022-09-02 10:31:50',223,NULL,NULL),(603,14,'out',100.44,3455,3354.56,7,'t-223',NULL,'2022-09-02 10:31:50','2022-09-02 10:31:50',223,NULL,NULL),(604,5,'in',149642,119531,269173,4,'t-224',NULL,'2022-09-02 10:58:07','2022-09-02 10:58:07',224,NULL,NULL),(605,4,'out',4083,3274.77,-808.23,4,'t-224',NULL,'2022-09-02 10:58:07','2022-09-02 10:58:07',224,NULL,NULL),(606,8,'in',11142,38162.45,49304.45,5,'t-225',NULL,'2022-09-02 11:35:51','2022-09-02 11:35:51',225,NULL,NULL),(607,7,'out',304.01,5697,5392.99,5,'t-225',NULL,'2022-09-02 11:35:51','2022-09-02 11:35:51',225,NULL,NULL),(608,8,'in',2000,49304.45,51304.45,5,'t-226',NULL,'2022-09-02 11:36:24','2022-09-02 11:36:24',226,NULL,NULL),(609,9,'out',225600,-484264,-709864,5,'t-226',NULL,'2022-09-02 11:36:24','2022-09-02 11:36:24',226,NULL,NULL),(610,8,'in',20000,51304.45,71304.45,5,'t-227',NULL,'2022-09-02 11:39:08','2022-09-02 11:39:08',227,NULL,NULL),(611,7,'out',545.7,5392.99,4847.29,5,'t-227',NULL,'2022-09-02 11:39:08','2022-09-02 11:39:08',227,NULL,NULL),(612,8,'in',37000,71304.45,108304.45,5,'t-228','2022-09-02 11:55:58','2022-09-02 11:55:07','2022-09-02 11:55:58',228,NULL,NULL),(613,7,'out',1009.55,4847.29,3837.74,5,'t-228','2022-09-02 11:55:58','2022-09-02 11:55:07','2022-09-02 11:55:58',228,NULL,NULL),(614,8,'in',36650,71304.45,107954.45,5,'t-229',NULL,'2022-09-02 11:56:27','2022-09-02 11:56:27',229,NULL,NULL),(615,7,'out',1000,4847.29,3847.29,5,'t-229',NULL,'2022-09-02 11:56:27','2022-09-02 11:56:27',229,NULL,NULL),(616,14,'in',500,3354.56,3854.56,7,'t-230',NULL,'2022-09-03 02:11:00','2022-09-03 02:11:00',230,NULL,NULL),(617,15,'out',56350,480490,424140,7,'t-230',NULL,'2022-09-03 02:11:00','2022-09-03 02:11:00',230,NULL,NULL),(618,24,'in',1140000,839010,1979010,10,'t-231',NULL,'2022-09-03 02:11:13','2022-09-03 02:11:13',231,NULL,NULL),(619,23,'out',10000,21667.36,11667.36,10,'t-231',NULL,'2022-09-03 02:11:13','2022-09-03 02:11:13',231,NULL,NULL),(620,24,'in',20610,1979010,1999620,10,'t-232',NULL,'2022-09-03 02:24:03','2022-09-03 02:24:03',232,NULL,NULL),(621,22,'out',5,1270,1265,10,'t-232',NULL,'2022-09-03 02:24:03','2022-09-03 02:24:03',232,NULL,NULL);

--
-- Table structure for table `bank_accounts`
--

CREATE TABLE `bank_accounts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `bank_id` bigint unsigned DEFAULT NULL,
  `currency_id` bigint unsigned DEFAULT NULL,
  `bank_username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bank_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `credit` double NOT NULL DEFAULT '0',
  `user_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `is_bank` tinyint(1) NOT NULL DEFAULT '1',
  `responsible_by_user_id` bigint unsigned DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bank_accounts`
--

INSERT INTO `bank_accounts` VALUES (1,1,1,'Vault-ដុល្លា','0',-107628.01,3,NULL,'2022-08-16 07:32:35','2022-09-01 10:46:35',0,3,1),(2,1,2,'Vault-បាត','0',4400479,3,NULL,'2022-08-16 07:32:53','2022-09-01 10:46:35',0,3,1),(3,1,3,'Vault-រៀល','0',-13136000,3,NULL,'2022-08-16 07:33:07','2022-09-01 10:16:06',0,3,1),(4,1,1,'Lyanith-ដុល្លា','0',-808.23,3,NULL,'2022-08-16 08:00:15','2022-09-02 10:58:07',0,4,1),(5,1,2,'Lyyanith-បាត','0',269173,3,NULL,'2022-08-16 08:00:44','2022-09-02 10:58:07',0,4,1),(6,1,3,'Lyyanith-រៀល','0',323158.1,3,NULL,'2022-08-16 08:00:56','2022-09-02 10:19:29',0,4,1),(7,1,1,'Sanim-ដុល្លា','0',3847.29,3,NULL,'2022-08-16 08:01:20','2022-09-02 11:56:27',0,5,1),(8,1,2,'Sanim-បាត','0',107954.45,3,NULL,'2022-08-16 08:01:46','2022-09-02 11:56:27',0,5,1),(9,1,3,'Sanim-រៀល','0',-709864,3,NULL,'2022-08-16 08:01:58','2022-09-02 11:36:24',0,5,1),(10,1,1,'Phallyka-ដុល្លា','0',529.94,3,NULL,'2022-08-16 08:02:35','2022-09-02 09:33:39',0,6,1),(11,1,2,'Phallyka-បាត','0',36711.19,3,NULL,'2022-08-16 08:02:46','2022-09-02 10:01:48',0,6,1),(12,1,3,'Phallyka-រៀល','0',2184169.7,3,NULL,'2022-08-16 08:03:02','2022-09-02 10:01:48',0,6,1),(13,1,1,'Somaly-ដុល្លា','0',1869.99,3,NULL,'2022-08-16 08:03:21','2022-09-02 10:19:48',0,7,1),(14,1,2,'Somaly-បាត','0',3854.56,3,NULL,'2022-08-16 08:03:35','2022-09-03 02:11:00',0,7,1),(15,1,3,'Somaly-រៀល','0',424140,3,NULL,'2022-08-16 08:03:53','2022-09-03 02:11:00',0,7,1),(16,1,1,'HemSreyRoth-ដុល្លា','0',0,3,NULL,'2022-08-16 08:04:17','2022-08-29 09:54:34',0,8,1),(17,1,2,'HemSreyRoth-បាត','0',0,3,NULL,'2022-08-16 08:04:32','2022-08-29 09:54:03',0,8,1),(18,1,3,'HemSreyRoth-រៀល','0',0,3,NULL,'2022-08-16 08:04:45','2022-08-29 09:54:34',0,8,1),(19,1,1,'ចរិយា-ដុល្លា','0',1500,3,NULL,'2022-08-16 08:05:05','2022-09-01 04:22:14',0,9,1),(20,1,2,'ចរិយា-បាត','0',12000,3,NULL,'2022-08-16 08:05:22','2022-09-01 04:22:14',0,9,1),(21,1,3,'ចរិយា-រៀល','0',1000000,3,NULL,'2022-08-16 08:05:37','2022-08-31 02:53:46',0,9,1),(22,1,1,'Kunthar-ដុល្លា','0',1265,3,NULL,'2022-08-16 08:06:01','2022-09-03 02:24:03',0,10,1),(23,1,2,'Kunthar-បាត','0',11667.36,3,NULL,'2022-08-16 08:06:13','2022-09-03 02:11:13',0,10,1),(24,1,3,'Kunthar-រៀល','0',1999620,3,NULL,'2022-08-16 08:06:25','2022-09-03 02:24:03',0,10,1),(25,1,1,'Maraka-ដុល្លា','0',1000,3,NULL,'2022-08-16 08:06:43','2022-08-31 02:53:02',0,11,1),(26,1,2,'Maraka-បាត','0',30000,3,NULL,'2022-08-16 08:06:55','2022-08-31 02:52:50',0,11,1),(27,1,3,'Maraka-រៀល','0',1000000,3,NULL,'2022-08-16 08:07:08','2022-08-31 02:52:40',0,11,1);

--
-- Table structure for table `banks`
--

CREATE TABLE `banks` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `show_as_bank` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `banks_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `banks`
--

INSERT INTO `banks` VALUES (1,'លុយសុទ្ធ',NULL,NULL,3,'2022-08-16 07:31:41','2022-08-16 07:31:41',1),(2,'ABA',NULL,NULL,3,'2022-08-16 07:31:47','2022-08-16 07:31:47',1),(3,'WING',NULL,NULL,3,'2022-08-16 07:31:51','2022-08-16 07:31:51',1),(4,'ACELEDA',NULL,NULL,3,'2022-08-16 07:31:55','2022-08-16 07:31:55',1);

--
-- Table structure for table `currencies`
--

CREATE TABLE `currencies` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `is_main_currency` tinyint(1) NOT NULL DEFAULT '0',
  `decimal_precision` smallint NOT NULL DEFAULT '2',
  `flage` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sample_money` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `currencies_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `currencies`
--

INSERT INTO `currencies` VALUES (1,'ដុល្លា',1,NULL,'2022-08-16 07:06:55','2022-08-16 09:05:14',1,2,'images/1660640714.usd-flage.png','images/1660633615.usd.jpg'),(2,'បាត',1,NULL,'2022-08-16 07:07:43','2022-08-16 07:07:43',0,0,'images/1660633663.thai.png','images/1660633663.bath.jpg'),(3,'រៀល',1,NULL,'2022-08-16 07:08:10','2022-08-16 07:08:10',0,0,'images/1660633690.cambodia.png','images/1660633690.riel.jpg');

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (1,'2014_10_11_000001_create_roles_table',1),(2,'2014_10_12_000000_create_users_table',1),(3,'2014_10_12_100000_create_password_resets_table',1),(4,'2019_08_19_000000_create_failed_jobs_table',1),(5,'2019_12_14_000001_create_personal_access_tokens_table',1),(6,'2022_06_20_151035_create_currencies_table',1),(7,'2022_06_20_154842_create_money_exchange_lists_table',1),(8,'2022_06_20_154843_create_money_exchange_rates_table',1),(9,'2022_06_20_154922_create_banks_table',1),(10,'2022_06_20_154933_create_bank_accounts_table',1),(11,'2022_06_20_154934_create_transactions_table',1),(12,'2022_06_20_154952_create_bank_account_transactions_table',1),(13,'2022_06_21_124503_create_settings_table',1),(14,'2022_07_02_141950_add_last_update_rate_date_to_money_exchange_lists_table',1),(15,'2022_07_02_183812_add_received_amount_to_transactions_table',1),(16,'2022_07_08_151818_add_is_bank_to_bank_accounts_table',1),(17,'2022_07_11_140234_add_transaction_id_to_bank_account_transactions_table',1),(18,'2022_07_17_170354_add_is_active_to_bank_accountstable',1),(19,'2022_07_26_155231_add_is_main_currency_to_currencies_table',1),(20,'2022_07_28_132549_add_decimal_precision_to_currencies_table',1),(21,'2022_08_08_115507_create_transfers_table',1),(22,'2022_08_08_174756_add_flage_to_currencies_table',1),(23,'2022_08_11_175214_add_names_to_transfers_table',1),(24,'2022_08_17_122044_add_order_to_money_exchange_lists_table',2),(25,'2022_08_22_172523_add_show_as_bank_to_banks_table',3),(26,'2022_08_22_222643_add_transfer_id_to_bank_account_transactions_table',3),(27,'2022_08_22_225926_create_bank_account_transaction_types_table',3);

--
-- Table structure for table `money_exchange_lists`
--

CREATE TABLE `money_exchange_lists` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `exchange_from_currency_id` bigint unsigned DEFAULT NULL,
  `exchange_to_currency_id` bigint unsigned DEFAULT NULL,
  `calculation` enum('x','/') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'x',
  `current_rate` double(8,2) DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `last_updated_rate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `order` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `exchange_from_currency_id_exchange_to_currency_id` (`exchange_from_currency_id`,`exchange_to_currency_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `money_exchange_lists`
--

INSERT INTO `money_exchange_lists` VALUES (1,1,3,'x',4105.00,1,1,NULL,'2022-08-16 07:11:34','2022-08-30 04:05:20','2022-08-30 04:05:20',6),(2,1,2,'x',36.25,1,1,NULL,'2022-08-16 07:11:49','2022-09-03 02:03:05','2022-09-03 02:03:05',1),(3,2,3,'x',112.70,1,1,NULL,'2022-08-16 07:12:06','2022-09-03 02:03:34','2022-09-03 02:03:34',4),(4,2,1,'/',36.65,1,1,NULL,'2022-08-16 07:12:30','2022-09-02 07:23:53','2022-09-02 07:23:53',2),(5,3,1,'/',4122.00,1,1,NULL,'2022-08-16 07:15:17','2022-09-03 02:03:42','2022-09-03 02:03:42',5),(6,3,2,'/',114.00,1,1,NULL,'2022-08-16 07:15:32','2022-09-03 02:03:21','2022-09-03 02:03:21',3);

--
-- Table structure for table `money_exchange_rates`
--

CREATE TABLE `money_exchange_rates` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `money_exchange_list_id` bigint unsigned DEFAULT NULL,
  `exchange_rate` double(8,2) DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=177 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `money_exchange_rates`
--

INSERT INTO `money_exchange_rates` VALUES (1,6,4105.00,1,NULL,'2022-08-16 07:23:03','2022-08-16 07:23:03'),(2,5,4105.00,1,NULL,'2022-08-16 07:23:22','2022-08-16 07:23:22'),(3,1,4098.00,1,NULL,'2022-08-16 07:23:39','2022-08-16 07:23:39'),(4,6,11605.00,1,NULL,'2022-08-16 07:23:58','2022-08-16 07:23:58'),(5,6,116.50,1,NULL,'2022-08-16 07:24:04','2022-08-16 07:24:04'),(6,4,35.35,1,NULL,'2022-08-16 07:24:25','2022-08-16 07:24:25'),(7,3,116.00,1,NULL,'2022-08-16 07:24:36','2022-08-16 07:24:36'),(8,2,35.25,1,NULL,'2022-08-16 07:24:58','2022-08-16 07:24:58'),(9,6,116.50,12,NULL,'2022-08-17 02:36:26','2022-08-17 02:36:26'),(10,4,35.33,12,NULL,'2022-08-17 02:36:52','2022-08-17 02:36:52'),(11,2,35.22,12,NULL,'2022-08-17 02:37:17','2022-08-17 02:37:17'),(12,2,35.25,12,NULL,'2022-08-18 01:21:24','2022-08-18 01:21:24'),(13,4,35.35,12,NULL,'2022-08-18 01:21:36','2022-08-18 01:21:36'),(14,6,116.50,12,NULL,'2022-08-18 01:22:00','2022-08-18 01:22:00'),(15,5,4106.00,12,NULL,'2022-08-18 01:22:44','2022-08-18 01:22:44'),(16,1,4100.00,12,NULL,'2022-08-18 01:23:03','2022-08-18 01:23:03'),(17,2,35.27,12,NULL,'2022-08-18 02:07:00','2022-08-18 02:07:00'),(18,4,35.37,12,NULL,'2022-08-18 02:07:15','2022-08-18 02:07:15'),(19,2,35.30,2,NULL,'2022-08-18 05:06:20','2022-08-18 05:06:20'),(20,4,35.42,2,NULL,'2022-08-18 05:06:32','2022-08-18 05:06:32'),(21,6,115.70,2,NULL,'2022-08-18 05:06:46','2022-08-18 05:06:46'),(22,6,116.30,2,NULL,'2022-08-18 05:07:01','2022-08-18 05:07:01'),(23,3,115.70,2,NULL,'2022-08-18 05:07:11','2022-08-18 05:07:11'),(24,2,35.35,12,NULL,'2022-08-19 01:52:14','2022-08-19 01:52:14'),(25,4,35.50,12,NULL,'2022-08-19 01:52:27','2022-08-19 01:52:27'),(26,6,116.10,12,NULL,'2022-08-19 01:52:40','2022-08-19 01:52:40'),(27,3,115.60,12,NULL,'2022-08-19 01:52:53','2022-08-19 01:52:53'),(28,5,4106.00,12,NULL,'2022-08-19 01:53:08','2022-08-19 01:53:08'),(29,1,4100.00,12,NULL,'2022-08-19 01:53:19','2022-08-19 01:53:19'),(30,4,35.53,12,NULL,'2022-08-19 02:01:45','2022-08-19 02:01:45'),(31,2,35.40,12,NULL,'2022-08-20 01:10:18','2022-08-20 01:10:18'),(32,4,35.52,12,NULL,'2022-08-20 01:10:29','2022-08-20 01:10:29'),(33,6,116.00,12,NULL,'2022-08-20 01:10:43','2022-08-20 01:10:43'),(34,3,115.50,12,NULL,'2022-08-20 01:10:56','2022-08-20 01:10:56'),(35,5,4106.00,12,NULL,'2022-08-20 01:11:12','2022-08-20 01:11:12'),(36,1,4100.00,12,NULL,'2022-08-20 01:11:25','2022-08-20 01:11:25'),(37,2,35.40,12,NULL,'2022-08-20 04:16:32','2022-08-20 04:16:32'),(38,4,35.52,12,NULL,'2022-08-20 04:16:41','2022-08-20 04:16:41'),(39,6,116.00,12,NULL,'2022-08-20 04:16:51','2022-08-20 04:16:51'),(40,5,4108.00,12,NULL,'2022-08-20 04:17:07','2022-08-20 04:17:07'),(41,1,4100.00,12,NULL,'2022-08-20 04:17:13','2022-08-20 04:17:13'),(42,4,35.59,12,NULL,'2022-08-21 04:29:19','2022-08-21 04:29:19'),(43,2,35.42,12,NULL,'2022-08-21 05:47:59','2022-08-21 05:47:59'),(44,4,35.52,12,NULL,'2022-08-21 05:48:11','2022-08-21 05:48:11'),(45,2,35.43,12,NULL,'2022-08-21 08:32:10','2022-08-21 08:32:10'),(46,4,35.55,12,NULL,'2022-08-21 08:32:20','2022-08-21 08:32:20'),(47,3,115.40,12,NULL,'2022-08-21 08:32:40','2022-08-21 08:32:40'),(48,2,35.50,12,NULL,'2022-08-22 01:13:46','2022-08-22 01:13:46'),(49,4,35.68,12,NULL,'2022-08-22 01:13:56','2022-08-22 01:13:56'),(50,6,115.50,12,NULL,'2022-08-22 01:14:07','2022-08-22 01:14:07'),(51,3,115.00,12,NULL,'2022-08-22 01:14:17','2022-08-22 01:14:17'),(52,5,4108.00,12,NULL,'2022-08-22 01:14:26','2022-08-22 01:14:26'),(53,2,35.50,12,NULL,'2022-08-22 01:54:42','2022-08-22 01:54:42'),(54,4,35.70,12,NULL,'2022-08-22 01:55:07','2022-08-22 01:55:07'),(55,2,35.60,12,NULL,'2022-08-22 04:34:49','2022-08-22 04:34:49'),(56,4,35.75,12,NULL,'2022-08-22 04:35:01','2022-08-22 04:35:01'),(57,6,115.30,12,NULL,'2022-08-22 04:35:24','2022-08-22 04:35:24'),(58,3,114.70,12,NULL,'2022-08-22 04:35:33','2022-08-22 04:35:33'),(59,2,35.60,12,NULL,'2022-08-22 05:58:44','2022-08-22 05:58:44'),(60,4,35.80,12,NULL,'2022-08-22 05:58:54','2022-08-22 05:58:54'),(61,6,115.20,12,NULL,'2022-08-22 05:59:07','2022-08-22 05:59:07'),(62,3,114.50,12,NULL,'2022-08-22 05:59:18','2022-08-22 05:59:18'),(63,2,35.65,12,NULL,'2022-08-22 06:21:45','2022-08-22 06:21:45'),(64,4,35.85,12,NULL,'2022-08-22 06:21:55','2022-08-22 06:21:55'),(65,2,35.70,12,NULL,'2022-08-22 07:52:35','2022-08-22 07:52:35'),(66,4,35.90,12,NULL,'2022-08-22 07:52:46','2022-08-22 07:52:46'),(67,6,115.00,12,NULL,'2022-08-22 07:53:00','2022-08-22 07:53:00'),(68,3,114.30,12,NULL,'2022-08-22 07:53:12','2022-08-22 07:53:12'),(69,2,35.75,12,NULL,'2022-08-22 08:12:20','2022-08-22 08:12:20'),(70,4,35.98,12,NULL,'2022-08-22 08:12:27','2022-08-22 08:12:27'),(71,6,114.80,12,NULL,'2022-08-22 08:12:44','2022-08-22 08:12:44'),(72,3,114.00,12,NULL,'2022-08-22 08:12:57','2022-08-22 08:12:57'),(73,2,35.88,12,NULL,'2022-08-23 01:41:39','2022-08-23 01:41:39'),(74,4,36.05,12,NULL,'2022-08-23 01:41:51','2022-08-23 01:41:51'),(75,3,113.80,12,NULL,'2022-08-23 01:42:16','2022-08-23 01:42:16'),(76,6,114.80,12,NULL,'2022-08-23 01:42:25','2022-08-23 01:42:25'),(77,2,35.85,12,NULL,'2022-08-23 01:44:18','2022-08-23 01:44:18'),(78,2,35.90,12,NULL,'2022-08-23 02:24:16','2022-08-23 02:24:16'),(79,4,36.07,12,NULL,'2022-08-23 02:24:24','2022-08-23 02:24:24'),(80,6,114.50,12,NULL,'2022-08-23 02:24:32','2022-08-23 02:24:32'),(81,3,113.80,12,NULL,'2022-08-23 02:24:37','2022-08-23 02:24:37'),(82,5,4108.00,12,NULL,'2022-08-23 02:24:41','2022-08-23 02:24:41'),(83,2,35.95,12,NULL,'2022-08-23 06:03:07','2022-08-23 06:03:07'),(84,4,36.15,12,NULL,'2022-08-23 06:03:19','2022-08-23 06:03:19'),(85,6,114.20,12,NULL,'2022-08-23 06:03:43','2022-08-23 06:03:43'),(86,3,113.50,12,NULL,'2022-08-23 06:04:06','2022-08-23 06:04:06'),(87,2,35.90,12,NULL,'2022-08-23 08:34:30','2022-08-23 08:34:30'),(88,6,114.50,12,NULL,'2022-08-24 02:16:44','2022-08-24 02:16:44'),(89,4,36.20,12,NULL,'2022-08-24 09:12:47','2022-08-24 09:12:47'),(90,2,35.80,12,NULL,'2022-08-25 01:12:16','2022-08-25 01:12:16'),(91,4,36.10,12,NULL,'2022-08-25 01:12:22','2022-08-25 01:12:22'),(92,3,114.00,12,NULL,'2022-08-25 01:12:40','2022-08-25 01:12:40'),(93,5,4110.00,12,NULL,'2022-08-25 01:12:55','2022-08-25 01:12:55'),(94,1,4102.00,12,NULL,'2022-08-25 01:13:04','2022-08-25 01:13:04'),(95,2,35.72,12,NULL,'2022-08-26 02:30:08','2022-08-26 02:30:08'),(96,4,35.90,12,NULL,'2022-08-26 02:30:23','2022-08-26 02:30:23'),(97,6,115.00,12,NULL,'2022-08-26 02:30:37','2022-08-26 02:30:37'),(98,3,114.40,12,NULL,'2022-08-26 02:30:50','2022-08-26 02:30:50'),(99,5,4110.00,12,NULL,'2022-08-26 02:31:03','2022-08-26 02:31:03'),(100,2,35.75,12,NULL,'2022-08-26 09:02:42','2022-08-26 09:02:42'),(101,4,35.93,12,NULL,'2022-08-26 09:02:50','2022-08-26 09:02:50'),(102,6,114.70,12,NULL,'2022-08-26 09:03:03','2022-08-26 09:03:03'),(103,3,114.30,12,NULL,'2022-08-26 09:03:17','2022-08-26 09:03:17'),(104,2,36.86,12,NULL,'2022-08-27 01:46:51','2022-08-27 01:46:51'),(105,4,36.06,12,NULL,'2022-08-27 01:47:05','2022-08-27 01:47:05'),(106,2,35.86,12,NULL,'2022-08-27 01:58:22','2022-08-27 01:58:22'),(107,2,35.95,12,NULL,'2022-08-29 01:24:06','2022-08-29 01:24:06'),(108,4,36.15,12,NULL,'2022-08-29 01:24:16','2022-08-29 01:24:16'),(109,6,114.30,12,NULL,'2022-08-29 01:24:30','2022-08-29 01:24:30'),(110,3,113.70,12,NULL,'2022-08-29 01:24:41','2022-08-29 01:24:41'),(111,5,4110.00,12,NULL,'2022-08-29 01:24:58','2022-08-29 01:24:58'),(112,1,4102.00,12,NULL,'2022-08-29 01:25:12','2022-08-29 01:25:12'),(113,2,36.00,12,NULL,'2022-08-29 01:26:31','2022-08-29 01:26:31'),(114,4,36.20,12,NULL,'2022-08-29 01:26:45','2022-08-29 01:26:45'),(115,6,114.10,12,NULL,'2022-08-29 01:27:10','2022-08-29 01:27:10'),(116,3,113.50,12,NULL,'2022-08-29 01:27:25','2022-08-29 01:27:25'),(117,2,35.95,12,NULL,'2022-08-29 02:14:27','2022-08-29 02:14:27'),(118,4,36.25,12,NULL,'2022-08-29 02:14:38','2022-08-29 02:14:38'),(119,6,114.00,12,NULL,'2022-08-29 02:14:54','2022-08-29 02:14:54'),(120,3,113.40,12,NULL,'2022-08-29 02:15:16','2022-08-29 02:15:16'),(121,2,36.00,12,NULL,'2022-08-30 04:03:55','2022-08-30 04:03:55'),(122,4,36.16,12,NULL,'2022-08-30 04:04:15','2022-08-30 04:04:15'),(123,3,113.50,12,NULL,'2022-08-30 04:04:35','2022-08-30 04:04:35'),(124,5,4113.00,12,NULL,'2022-08-30 04:05:05','2022-08-30 04:05:05'),(125,1,4105.00,12,NULL,'2022-08-30 04:05:20','2022-08-30 04:05:20'),(126,2,36.08,12,NULL,'2022-08-31 01:31:51','2022-08-31 01:31:51'),(127,4,36.20,12,NULL,'2022-08-31 01:32:01','2022-08-31 01:32:01'),(128,6,114.00,12,NULL,'2022-08-31 01:32:25','2022-08-31 01:32:25'),(129,3,113.40,12,NULL,'2022-08-31 01:32:38','2022-08-31 01:32:38'),(130,5,4113.00,12,NULL,'2022-08-31 01:32:53','2022-08-31 01:32:53'),(131,1,4105.00,12,NULL,'2022-08-31 01:33:11','2022-08-31 01:33:11'),(132,4,36.30,12,NULL,'2022-08-31 01:59:08','2022-08-31 01:59:08'),(133,3,113.30,12,NULL,'2022-08-31 01:59:21','2022-08-31 01:59:21'),(134,4,36.25,3,NULL,'2022-08-31 02:50:19','2022-08-31 02:50:19'),(135,2,36.10,12,NULL,'2022-08-31 03:25:34','2022-08-31 03:25:34'),(136,4,36.27,12,NULL,'2022-08-31 03:25:40','2022-08-31 03:25:40'),(137,2,36.07,12,NULL,'2022-08-31 05:48:04','2022-08-31 05:48:04'),(138,4,36.30,12,NULL,'2022-08-31 05:48:17','2022-08-31 05:48:17'),(139,3,113.30,12,NULL,'2022-08-31 05:48:34','2022-08-31 05:48:34'),(140,4,36.28,3,NULL,'2022-08-31 10:44:22','2022-08-31 10:44:22'),(141,2,36.00,12,NULL,'2022-09-01 01:36:47','2022-09-01 01:36:47'),(142,2,36.37,12,NULL,'2022-09-01 01:36:59','2022-09-01 01:36:59'),(143,4,36.37,12,NULL,'2022-09-01 01:37:18','2022-09-01 01:37:18'),(144,2,36.15,12,NULL,'2022-09-01 01:37:29','2022-09-01 01:37:29'),(145,6,113.70,12,NULL,'2022-09-01 01:37:45','2022-09-01 01:37:45'),(146,3,113.10,12,NULL,'2022-09-01 01:38:02','2022-09-01 01:38:02'),(147,2,36.00,12,NULL,'2022-09-01 02:16:13','2022-09-01 02:16:13'),(148,4,36.35,12,NULL,'2022-09-01 02:16:26','2022-09-01 02:16:26'),(149,4,36.37,12,NULL,'2022-09-01 02:16:52','2022-09-01 02:16:52'),(150,2,36.00,12,NULL,'2022-09-01 04:34:57','2022-09-01 04:34:57'),(151,4,36.44,12,NULL,'2022-09-01 04:35:07','2022-09-01 04:35:07'),(152,6,113.80,12,NULL,'2022-09-01 04:35:20','2022-09-01 04:35:20'),(153,3,112.80,12,NULL,'2022-09-01 04:35:36','2022-09-01 04:35:36'),(154,2,36.10,12,NULL,'2022-09-01 06:44:46','2022-09-01 06:44:46'),(155,4,36.47,12,NULL,'2022-09-01 06:44:57','2022-09-01 06:44:57'),(156,6,113.50,12,NULL,'2022-09-01 06:45:08','2022-09-01 06:45:08'),(157,5,4120.00,12,NULL,'2022-09-01 06:45:29','2022-09-01 06:45:29'),(158,4,36.52,12,NULL,'2022-09-01 07:12:04','2022-09-01 07:12:04'),(159,4,36.47,3,NULL,'2022-09-01 09:44:21','2022-09-01 09:44:21'),(160,4,36.52,3,NULL,'2022-09-01 09:44:54','2022-09-01 09:44:54'),(161,4,36.37,3,NULL,'2022-09-01 09:54:55','2022-09-01 09:54:55'),(162,4,36.52,3,NULL,'2022-09-01 10:26:09','2022-09-01 10:26:09'),(163,4,36.37,3,NULL,'2022-09-01 10:44:58','2022-09-01 10:44:58'),(164,4,36.52,3,NULL,'2022-09-01 10:46:12','2022-09-01 10:46:12'),(165,2,36.15,12,NULL,'2022-09-02 01:40:19','2022-09-02 01:40:19'),(166,4,36.58,12,NULL,'2022-09-02 01:40:30','2022-09-02 01:40:30'),(167,6,113.50,12,NULL,'2022-09-02 01:40:36','2022-09-02 01:40:36'),(168,4,36.60,12,NULL,'2022-09-02 03:26:34','2022-09-02 03:26:34'),(169,4,36.75,12,NULL,'2022-09-02 06:15:14','2022-09-02 06:15:14'),(170,2,36.30,12,NULL,'2022-09-02 07:23:44','2022-09-02 07:23:44'),(171,4,36.65,12,NULL,'2022-09-02 07:23:53','2022-09-02 07:23:53'),(172,2,36.25,12,NULL,'2022-09-03 02:03:05','2022-09-03 02:03:05'),(173,4,36.65,12,NULL,'2022-09-03 02:03:11','2022-09-03 02:03:11'),(174,6,114.00,12,NULL,'2022-09-03 02:03:21','2022-09-03 02:03:21'),(175,3,112.70,12,NULL,'2022-09-03 02:03:34','2022-09-03 02:03:34'),(176,5,4122.00,12,NULL,'2022-09-03 02:03:42','2022-09-03 02:03:42');

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (1,'staff',NULL,'2022-08-16 07:03:36','2022-08-16 07:03:36'),(2,'admin',NULL,'2022-08-16 07:03:36','2022-08-16 07:03:36');

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `settings_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` VALUES (1,'title','Fast Money Exchange',NULL,'2022-08-16 07:03:36','2022-08-16 07:03:36'),(2,'logo','logo.png',NULL,'2022-08-16 07:03:36','2022-08-16 07:03:36'),(3,'shop_name','Fast Money Exchange',NULL,'2022-08-16 07:03:36','2022-08-16 07:03:36'),(4,'phone','097 600 0501 / 097 600 0510',NULL,'2022-08-16 07:03:36','2022-08-16 08:15:54'),(5,'address','ភូមិក្បាលស្ពាន១ សង្កាត់ប៉ោយប៉ែត ក្រុងប៉ោយប៉ែត',NULL,'2022-08-16 07:03:36','2022-08-16 08:16:19');

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `customer_level` smallint NOT NULL DEFAULT '1',
  `transaction_type` enum('cash_exchange','bank_deposit','bank_withdraw','staff_deposit','staff_withdraw') COLLATE utf8mb4_unicode_ci NOT NULL,
  `money_exchange_list_id` bigint unsigned DEFAULT NULL,
  `bank_account_id` bigint unsigned DEFAULT NULL,
  `fee` double NOT NULL DEFAULT '0',
  `amount` double DEFAULT NULL,
  `exchange_rate` double(8,2) DEFAULT NULL,
  `remain` double NOT NULL DEFAULT '0',
  `note` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `received_amount` double NOT NULL DEFAULT '0',
  `amount_after_exchange` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=233 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` VALUES (169,1,'cash_exchange',4,11,0,2541,36.27,459,NULL,6,NULL,'2022-08-31 03:47:33','2022-08-31 03:47:33',3000,70.06),(170,1,'cash_exchange',3,11,0,459,113.30,0,NULL,6,NULL,'2022-08-31 03:48:25','2022-08-31 03:48:25',459,52004.7),(171,1,'cash_exchange',3,14,0,1500,113.30,0,NULL,7,NULL,'2022-08-31 10:31:18','2022-08-31 10:31:18',1500,169950),(172,1,'cash_exchange',4,2,0,362800,36.28,0,NULL,3,NULL,'2022-08-31 10:44:53','2022-08-31 10:44:53',362800,10000),(173,1,'cash_exchange',2,22,0,2,36.07,0,NULL,10,NULL,'2022-09-01 01:25:09','2022-09-01 01:25:09',2,72.14),(174,1,'cash_exchange',1,4,0,50,4105.00,50,NULL,4,NULL,'2022-09-01 01:35:17','2022-09-01 01:35:17',100,205250),(175,1,'cash_exchange',3,5,0,500,113.10,0,NULL,4,NULL,'2022-09-01 03:29:20','2022-09-01 03:29:20',500,56550),(176,1,'cash_exchange',2,19,0,500,36.00,0,NULL,9,NULL,'2022-09-01 04:22:14','2022-09-01 04:22:14',500,18000),(177,1,'cash_exchange',3,23,0,100,113.10,0,NULL,10,NULL,'2022-09-01 04:23:30','2022-09-01 04:23:30',100,11310),(178,1,'cash_exchange',2,13,0,500,36.00,0,NULL,7,NULL,'2022-09-01 05:02:17','2022-09-01 05:02:17',500,18000),(179,1,'cash_exchange',2,4,0,1000,36.00,0,NULL,4,NULL,'2022-09-01 05:26:03','2022-09-01 05:26:03',1000,36000),(180,1,'cash_exchange',3,8,0,3000,112.80,0,NULL,5,NULL,'2022-09-01 06:28:20','2022-09-01 06:28:20',3000,338400),(181,1,'cash_exchange',1,7,0,100,4105.00,0,NULL,5,NULL,'2022-09-01 06:51:34','2022-09-01 06:51:34',100,410500),(182,1,'cash_exchange',4,8,0,27390,36.52,610,NULL,5,NULL,'2022-09-01 07:45:42','2022-09-01 07:45:42',28000,750),(183,1,'cash_exchange',4,5,0,100000,36.52,0,NULL,4,NULL,'2022-09-01 07:51:37','2022-09-01 07:51:37',100000,2738.23),(184,1,'cash_exchange',4,2,0,802340,36.47,0,NULL,3,NULL,'2022-09-01 09:44:39','2022-09-01 09:44:39',802340,22000),(185,1,'cash_exchange',4,2,0,319147,36.37,0,NULL,3,NULL,'2022-09-01 09:56:13','2022-09-01 09:56:13',319147,8775.01),(186,1,'cash_exchange',3,8,0,1880,112.80,0,NULL,5,NULL,'2022-09-01 10:09:46','2022-09-01 10:09:46',1880,212064),(187,1,'cash_exchange',1,1,0,3200,4105.00,0,NULL,3,NULL,'2022-09-01 10:16:06','2022-09-01 10:16:06',3200,13136000),(188,1,'cash_exchange',3,23,0,1000,112.80,0,NULL,10,NULL,'2022-09-01 10:37:58','2022-09-01 10:37:58',1000,112800),(189,1,'cash_exchange',3,14,0,1000,112.80,0,NULL,7,NULL,'2022-09-01 10:40:30','2022-09-01 10:40:30',1000,112800),(190,1,'cash_exchange',4,2,0,1780639,36.37,0,NULL,3,NULL,'2022-09-01 10:45:38','2022-09-01 10:45:38',1780639,48959),(191,1,'cash_exchange',4,2,0,1135553,36.52,0,NULL,3,NULL,'2022-09-01 10:46:35','2022-09-01 10:46:35',1135553,31094),(192,1,'cash_exchange',2,22,0,100,36.15,0,NULL,10,NULL,'2022-09-02 01:57:27','2022-09-02 01:57:27',100,3615),(193,1,'cash_exchange',2,22,0,170,36.15,0,NULL,10,NULL,'2022-09-02 02:03:30','2022-09-02 02:03:30',170,6145.5),(194,1,'cash_exchange',4,14,0,18290,36.58,10,NULL,7,NULL,'2022-09-02 03:18:19','2022-09-02 03:18:19',18300,500),(195,1,'cash_exchange',3,14,0,1000,112.80,0,NULL,7,NULL,'2022-09-02 03:58:13','2022-09-02 03:58:13',1000,112800),(196,1,'cash_exchange',3,14,0,100,112.80,0,NULL,7,NULL,'2022-09-02 04:27:03','2022-09-02 04:27:03',100,11280),(197,1,'cash_exchange',2,7,0,50,36.15,0,NULL,5,NULL,'2022-09-02 04:27:17','2022-09-02 04:27:17',50,1807.5),(198,1,'cash_exchange',3,23,0,300,112.80,0,NULL,10,NULL,'2022-09-02 04:30:13','2022-09-02 04:30:13',300,33840),(199,1,'cash_exchange',3,14,0,100,112.80,0,NULL,7,NULL,'2022-09-02 05:50:24','2022-09-02 05:50:24',100,11280),(200,1,'cash_exchange',3,14,0,1000,112.80,0,NULL,7,NULL,'2022-09-02 05:58:45','2022-09-02 05:58:45',1000,112800),(201,1,'cash_exchange',5,12,0,2472000,4120.00,0,NULL,6,NULL,'2022-09-02 06:06:26','2022-09-02 06:06:26',2472000,600),(202,1,'cash_exchange',3,8,0,1000,112.80,0,NULL,5,NULL,'2022-09-02 06:16:51','2022-09-02 06:16:51',1000,112800),(203,1,'cash_exchange',3,5,0,5031,112.80,0,NULL,4,NULL,'2022-09-02 06:36:59','2022-09-02 06:36:59',5031,567496.8),(204,1,'cash_exchange',2,10,0,100,36.15,0,NULL,6,NULL,'2022-09-02 06:46:28','2022-09-02 06:46:28',100,3615),(205,1,'cash_exchange',2,7,0,1000,36.15,0,NULL,5,NULL,'2022-09-02 06:46:36','2022-09-02 06:46:36',1000,36150),(206,1,'cash_exchange',1,10,0,100,4105.00,0,NULL,6,'2022-09-02 07:28:08','2022-09-02 06:46:37','2022-09-02 07:28:08',100,410500),(207,1,'cash_exchange',1,7,0,100,4105.00,0,NULL,5,NULL,'2022-09-02 06:49:22','2022-09-02 06:49:22',100,410500),(208,1,'cash_exchange',2,13,0,1000,36.30,0,NULL,7,NULL,'2022-09-02 07:38:42','2022-09-02 07:38:42',1000,36300),(209,1,'cash_exchange',3,11,0,2000,112.80,0,NULL,6,NULL,'2022-09-02 08:13:34','2022-09-02 08:13:34',2000,225600),(210,1,'cash_exchange',3,11,0,4000,112.80,0,NULL,6,NULL,'2022-09-02 08:13:50','2022-09-02 08:13:50',4000,451200),(211,1,'cash_exchange',2,7,0,200,36.30,0,NULL,5,NULL,'2022-09-02 08:25:29','2022-09-02 08:25:29',200,7260),(212,1,'cash_exchange',4,14,0,3665,36.65,335,NULL,7,NULL,'2022-09-02 09:17:30','2022-09-02 09:17:30',4000,100),(213,1,'cash_exchange',3,23,0,100,112.80,0,NULL,10,NULL,'2022-09-02 09:21:33','2022-09-02 09:21:33',100,11280),(214,1,'cash_exchange',5,24,0,8240,4120.00,1760,NULL,10,NULL,'2022-09-02 09:31:54','2022-09-02 09:31:54',10000,2),(215,1,'cash_exchange',2,10,0,100,36.30,0,NULL,6,NULL,'2022-09-02 09:33:39','2022-09-02 09:33:39',100,3630),(216,1,'cash_exchange',3,11,0,5000,112.80,0,NULL,6,'2022-09-02 09:35:53','2022-09-02 09:34:28','2022-09-02 09:35:53',5000,564000),(217,1,'cash_exchange',3,11,0,5002,112.80,0,NULL,6,NULL,'2022-09-02 09:35:46','2022-09-02 09:35:46',5002,564225.6),(218,1,'cash_exchange',4,8,0,109.95,36.65,390.05,NULL,5,NULL,'2022-09-02 09:45:14','2022-09-02 09:45:14',500,3),(219,1,'cash_exchange',6,12,0,5200,113.50,0,NULL,6,NULL,'2022-09-02 10:01:48','2022-09-02 10:01:48',5200,45.81),(220,1,'cash_exchange',5,6,0,155000,4120.00,0,NULL,4,NULL,'2022-09-02 10:19:17','2022-09-02 10:19:17',155000,37.62),(221,1,'cash_exchange',1,4,0,0.62,4105.00,0,NULL,4,NULL,'2022-09-02 10:19:29','2022-09-02 10:19:29',0.62,2545.1),(222,1,'cash_exchange',4,14,0,1100,36.65,900,NULL,7,NULL,'2022-09-02 10:19:48','2022-09-02 10:19:48',2000,30.01),(223,1,'cash_exchange',6,15,0,11400,113.50,0,NULL,7,NULL,'2022-09-02 10:31:50','2022-09-02 10:31:50',11400,100.44),(224,1,'cash_exchange',4,5,0,149642,36.65,358,NULL,4,NULL,'2022-09-02 10:58:07','2022-09-02 10:58:07',150000,4083),(225,1,'cash_exchange',4,8,0,11142,36.65,8,NULL,5,NULL,'2022-09-02 11:35:51','2022-09-02 11:35:51',11150,304.01),(226,1,'cash_exchange',3,8,0,2000,112.80,0,NULL,5,NULL,'2022-09-02 11:36:24','2022-09-02 11:36:24',2000,225600),(227,1,'cash_exchange',4,8,0,20000,36.65,0,NULL,5,NULL,'2022-09-02 11:39:08','2022-09-02 11:39:08',20000,545.7),(228,1,'cash_exchange',4,8,0,37000,36.65,0,NULL,5,'2022-09-02 11:55:58','2022-09-02 11:55:07','2022-09-02 11:55:58',37000,1009.55),(229,1,'cash_exchange',4,8,0,36650,36.65,350,NULL,5,NULL,'2022-09-02 11:56:27','2022-09-02 11:56:27',37000,1000),(230,1,'cash_exchange',3,14,0,500,112.70,500,NULL,7,NULL,'2022-09-03 02:11:00','2022-09-03 02:11:00',1000,56350),(231,1,'cash_exchange',6,24,0,1140000,114.00,0,NULL,10,NULL,'2022-09-03 02:11:13','2022-09-03 02:11:13',1140000,10000),(232,1,'cash_exchange',5,24,0,20610,4122.00,29390,NULL,10,NULL,'2022-09-03 02:24:03','2022-09-03 02:24:03',50000,5);

--
-- Table structure for table `transfers`
--

CREATE TABLE `transfers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `bank_id` bigint unsigned DEFAULT NULL,
  `from_bank_account_id` bigint unsigned DEFAULT NULL,
  `to_bank_account_id` bigint unsigned DEFAULT NULL,
  `sender_phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `receiver_phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency_id` bigint unsigned DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `fee` double NOT NULL DEFAULT '0',
  `partner_fee` double NOT NULL DEFAULT '0',
  `user_id` bigint unsigned DEFAULT NULL,
  `transaction_type` enum('transferIn','transferOut','reTransferIn','reTransferOut') COLLATE utf8mb4_unicode_ci NOT NULL,
  `note` text COLLATE utf8mb4_unicode_ci,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `sender_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `receiver_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `transfers`
--



