INSERT INTO `s_transaction` VALUES (403083,'T26005242','2026-06-23',3,23,NULL,359500,2,1589326.6199999,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.403083.jpg','bensin mobil granmax silver rey (23 juni)',9,9,'2026-06-23 15:15:54','2026-06-23 15:15:55'),(403084,'T26005243','2026-06-23',3,23,NULL,306100,2,1283226.6199999,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.403084.jpg','bensin mobil granmax hitam lama adis (23 juni)',9,9,'2026-06-23 15:16:38','2026-06-23 15:16:39'),(403085,'T26005244','2026-06-23',3,23,NULL,245960,2,1037266.6199999,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.403085.jpg','bensin mobil traga dani (23 juni)',9,9,'2026-06-23 15:17:25','2026-06-23 15:17:26'),(403086,'T26005245','2026-06-23',8,4,NULL,100000,1,23935293.399994,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.403086.jpg','pembayaran tk. lutfi plastik-sawangan (23 juni)',9,9,'2026-06-23 15:46:56','2026-06-23 15:46:57'),(403087,'T26005246','2026-06-24',8,4,NULL,950000,1,24885293.399994,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.403087.jpg','pembayaran tk. kim-cidahu (23 juni)',9,9,'2026-06-24 15:28:36','2026-06-24 15:28:40'),(403088,'T26005247','2026-06-24',8,4,NULL,288000,1,25173293.399994,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.403088.jpg','pembayaran tk. ibing-pamoyanan (24 juni)',9,9,'2026-06-24 15:29:19','2026-06-24 15:29:19'),(403089,'T26005248','2026-06-24',8,4,NULL,800000,1,25973293.399994,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.403089.jpg','pembayaran tk. ganda-batu gede (24 juni)',9,9,'2026-06-24 15:29:50','2026-06-24 15:29:51'),(403090,'T26005249','2026-06-24',8,4,NULL,489000,1,26462293.399994,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.403090.jpg','pembayaran tk. sumber harapan-meruyung limo (24 juni)',9,9,'2026-06-24 15:30:58','2026-06-24 15:30:59'),(403091,'T26005250','2026-06-24',5,4,NULL,99138500,1,100806200,'widia',4,NULL,'penjualan (23 juni)',9,9,'2026-06-24 15:32:36','2026-06-24 15:32:36'),(403092,'T26005251','2026-06-24',5,19,NULL,30000,2,100776200,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.403092.jpg','parkir mobil dani (23 juni)',9,9,'2026-06-24 15:33:30','2026-06-24 15:33:30'),(403093,'T26005252','2026-06-24',5,35,NULL,50000,2,100726200,'widia',5,NULL,'cashbon dani (23 juni)',9,9,'2026-06-24 15:33:52','2026-06-24 15:33:52'),(403094,'T26005253','2026-06-24',5,35,NULL,30000,2,100696200,'widia',5,NULL,'cashbon adis (23 juni)',9,9,'2026-06-24 15:34:40','2026-06-24 15:34:40'),(403095,'T26005254','2026-06-24',5,19,NULL,18000,2,100678200,'widia',4,NULL,'parkir motor rizal (23 juni)',9,9,'2026-06-24 15:34:54','2026-06-24 15:34:54'),(403096,'T26005255','2026-06-24',5,35,NULL,25000,2,100653200,'widia',5,NULL,'cashbon rizal (23 juni)',9,9,'2026-06-24 15:35:09','2026-06-24 15:35:09'),(403097,'T26005256','2026-06-24',5,23,NULL,11000,2,100642200,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.403097.jpg','bensin motor rival (23 juni)',9,9,'2026-06-24 15:35:31','2026-06-24 15:35:32'),(403098,'T26005257','2026-06-24',5,35,NULL,30000,2,100612200,'widia',5,NULL,'cashbon rival (23 juni)',9,9,'2026-06-24 15:35:45','2026-06-24 15:35:45'),(403099,'T26005258','2026-06-24',5,19,NULL,15000,2,100597200,'widia',4,NULL,'parkir motor ridwan (23 juni)',9,9,'2026-06-24 15:35:58','2026-06-24 15:35:59'),(403100,'T26005259','2026-06-24',5,23,NULL,20000,2,100577200,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.403100.jpg','bensin motor ridwan (23 juni)',9,9,'2026-06-24 15:36:18','2026-06-24 15:36:19'),(403101,'T26005260','2026-06-24',5,35,NULL,200000,2,100377200,'widia',5,NULL,'cashbon ardi (23 juni)',9,9,'2026-06-24 15:36:34','2026-06-24 15:36:35'),(403102,'T26005261','2026-06-24',5,35,NULL,5000,2,100372200,'widia',5,NULL,'cashbon rasyid kurang setoran (23 juni)',9,9,'2026-06-24 15:36:53','2026-06-24 15:36:53'),(403103,'T26005262','2026-06-24',5,64,NULL,96654500,2,3717700,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.403103.jpg','setor tunai (24 juni)',9,9,'2026-06-24 15:38:59','2026-06-24 15:39:00'),(403104,'T26005263','2026-06-24',5,19,NULL,10000,2,3707700,'widia',4,NULL,'parkir mobil recehan dani, rey, adis, rasyid (24 juni)',9,9,'2026-06-24 15:39:26','2026-06-24 15:39:26'),(403105,'T26005264','2026-06-24',5,13,NULL,1030000,2,2677700,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.403105.jpg','pembelian plastik 1ball (24 juni)',9,9,'2026-06-24 15:40:05','2026-06-24 15:40:06'),(403106,'T26005265','2026-06-24',63,38,NULL,70000000,2,1252296,'widia',4,NULL,'pindah kas (24 juni)',9,9,'2026-06-24 15:45:46','2026-06-24 15:45:46'),(403107,'T26005266','2026-06-24',63,12,NULL,2500,2,1249796,'widia',4,NULL,'adm bank (24 juni)',9,9,'2026-06-24 15:46:00','2026-06-24 15:46:00'),(403108,'T26005267','2026-06-24',63,39,NULL,96654500,1,97904296,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.403108.jpg','setor tunai (24 juni)',9,9,'2026-06-24 15:46:47','2026-06-24 15:46:47'),(403109,'T26005268','2026-06-24',8,4,NULL,100000,1,26562293.399994,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.403109.jpg','pembayaran tk. habibi-leweung kolot (24 juni)',9,9,'2026-06-24 16:30:52','2026-06-24 16:30:53'),(403110,'T26005269','2026-06-24',8,4,NULL,2108500,1,28670793.399994,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.403110.jpg','pembayaran tk. h daus-pengasinan sawangan (24 juni)',9,9,'2026-06-24 16:32:23','2026-06-24 16:32:24'),(403111,'T26005270','2026-06-25',8,4,NULL,616000,1,29286793.399994,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.403111.jpg','pembayaran tk. asyifa-pancawati (24 juni)',9,9,'2026-06-25 13:41:19','2026-06-25 13:41:20'),(403112,'T26005271','2026-06-25',8,39,NULL,5000000,1,34286793.399994,'widia',4,NULL,'pindah dari kash agroka bumi perkasa (24 juni)',9,9,'2026-06-25 13:41:46','2026-06-25 13:47:05'),(403113,'T26005272','2026-06-25',8,49,NULL,29052039,2,5234754.3999939,'widia',4,NULL,'PO fks pangan nusantara (24 juni)',9,9,'2026-06-25 13:42:26','2026-06-25 13:42:26'),(403114,'T26005273','2026-06-25',8,4,NULL,700000,1,5934754.3999939,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.403114.jpg','pembayaran tk. antaka 4-grogol (24 juni)',9,9,'2026-06-25 13:43:03','2026-06-25 13:43:04'),(403115,'T26005274','2026-06-25',8,4,NULL,174000,1,6108754.3999939,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.403115.jpg','pembayaran tk. dharma-cilebut (25 juni)',9,9,'2026-06-25 13:43:43','2026-06-25 13:43:44'),(403116,'T26005275','2026-06-25',8,4,NULL,406500,1,6515254.3999939,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.403116.jpg','pembayaran tk. hamam-cibanteng proyek (25 juni)',9,9,'2026-06-25 13:44:25','2026-06-25 13:44:25'),(403117,'T26005276','2026-06-25',8,4,NULL,3982500,1,10497754.399994,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.403117.jpg','pembayaran tk. warna tani 5-cikereteg (25 juni)',9,9,'2026-06-25 13:45:02','2026-06-25 13:45:02'),(403118,'T26005277','2026-06-25',8,4,NULL,539500,1,11037254.399994,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.403118.jpg','pembayaran tk. sayur mama chelsea-ciderum (25 juni)',9,9,'2026-06-25 13:46:09','2026-06-25 13:46:09'),(403119,'T26005278','2026-06-25',8,4,NULL,925000,1,11962254.399994,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.403119.jpg','pembayaran tk. cahaya berkah-cilendek (25 juni)',9,9,'2026-06-25 14:17:52','2026-06-25 14:17:52'),(403120,'T26005279','2026-06-25',8,4,NULL,223000,1,12185254.399994,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.403120.jpg','pembayaran tk. ud bungo tanjung-cimande (25 juni)',9,9,'2026-06-25 14:18:26','2026-06-25 14:18:26'),(403121,'T26005280','2026-06-25',5,23,NULL,49000,2,2628700,'widia',4,NULL,'bensin motor pagi rizal, ridwan, rival (24 juni)',9,9,'2026-06-25 14:19:40','2026-06-25 14:19:40'),(403122,'T26005281','2026-06-25',5,4,NULL,70368000,1,72996700,'widia',4,NULL,'penjualan (24 juni)',9,9,'2026-06-25 14:20:50','2026-06-25 14:20:50'),(403123,'T26005282','2026-06-25',5,19,NULL,5000,2,72991700,'widia',4,NULL,'parkir mobil dani (24 juni)',9,9,'2026-06-25 14:21:26','2026-06-25 14:21:26'),(403124,'T26005283','2026-06-25',5,35,NULL,35000,2,72956700,'widia',5,NULL,'cashbon dani (24 juni)',9,9,'2026-06-25 14:22:02','2026-06-25 14:22:02'),(403125,'T26005284','2026-06-25',5,19,NULL,25000,2,72931700,'widia',4,NULL,'parkir mobil adis (24 juni)',9,9,'2026-06-25 14:22:16','2026-06-25 14:22:17'),(403126,'T26005285','2026-06-25',5,67,NULL,10000,2,72921700,'widia',3,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.403126.jpg','tambah angin mobil granmax hitam lama adis (24 juni)',9,9,'2026-06-25 14:22:39','2026-06-25 16:25:48'),(403127,'T26005286','2026-06-25',5,35,NULL,14000,2,72907700,'widia',5,NULL,'cashbon adis (24 juni)',9,9,'2026-06-25 14:22:55','2026-06-25 14:22:55'),(403128,'T26005287','2026-06-25',5,19,NULL,5000,2,72902700,'widia',4,NULL,'parkir mobil rey (24 juni)',9,9,'2026-06-25 14:23:08','2026-06-25 14:23:08'),(403129,'T26005288','2026-06-25',5,35,NULL,30000,2,72872700,'widia',5,NULL,'cashbon rey (24 juni)',9,9,'2026-06-25 14:23:22','2026-06-25 14:23:22'),(403130,'T26005289','2026-06-25',5,23,NULL,100000,2,72772700,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.403130.jpg','bensin mobil granmax hitam baru rasyid (24 juni)',9,9,'2026-06-25 14:24:10','2026-06-25 14:24:11'),(403131,'T26005290','2026-06-25',5,19,NULL,15000,2,72757700,'widia',4,NULL,'parkir mobil rasyid (24 juni)',9,9,'2026-06-25 14:24:25','2026-06-25 14:24:25'),(403132,'T26005291','2026-06-25',5,67,NULL,2000,2,72755700,'widia',3,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.403132.jpg','tambah angin motor rizal (24 juni)',9,9,'2026-06-25 14:24:40','2026-06-25 16:25:36'),(403133,'T26005292','2026-06-25',5,19,NULL,6000,2,72749700,'widia',4,NULL,'parkir motor rizal (24 juni)',9,9,'2026-06-25 14:24:53','2026-06-25 14:24:54'),(403134,'T26005293','2026-06-25',5,23,NULL,15000,2,72734700,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.403134.jpg','bensin motor rizal (24 juni)',9,9,'2026-06-25 14:25:16','2026-06-25 14:25:17'),(403135,'T26005294','2026-06-25',5,35,NULL,25000,2,72709700,'widia',5,NULL,'cashbon rizal (24 juni)',9,9,'2026-06-25 14:25:33','2026-06-25 14:25:33'),(403136,'T26005295','2026-06-25',5,19,NULL,6000,2,72703700,'widia',4,NULL,'parkir motor rival (24 juni)',9,9,'2026-06-25 14:26:14','2026-06-25 14:26:15'),(403137,'T26005296','2026-06-25',5,35,NULL,30000,2,72673700,'widia',5,NULL,'cashbon rival (24 juni)',9,9,'2026-06-25 14:26:34','2026-06-25 14:26:34'),(403138,'T26005297','2026-06-25',5,19,NULL,6000,2,72667700,'widia',4,NULL,'parkir motor ridwan (24 juni)',9,9,'2026-06-25 14:28:13','2026-06-25 14:28:13'),(403139,'T26005298','2026-06-25',5,35,NULL,100000,2,72567700,'widia',5,NULL,'cashbon rey kurang setoran (24 juni)',9,9,'2026-06-25 14:28:48','2026-06-25 14:28:48'),(403140,'T26005299','2026-06-25',5,35,NULL,10000,2,72557700,'widia',5,NULL,'cashbon rizal kurang setoran (24 juni)',9,9,'2026-06-25 14:29:09','2026-06-25 14:29:10'),(403141,'T26005300','2026-06-25',5,35,NULL,20000,2,72537700,'widia',5,NULL,'cashon ridwan kurang setoran (24 juni)',9,9,'2026-06-25 14:29:26','2026-06-25 14:29:26'),(403142,'T26005301','2026-06-25',5,64,NULL,69859000,2,2678700,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.403142.jpg','setor tunai (25 juni)',9,9,'2026-06-25 14:43:30','2026-06-25 14:43:31'),(403143,'T26005302','2026-06-25',5,19,NULL,10000,2,2668700,'widia',4,NULL,'parkir mobil recehan dani, rey, adis, rasyid (25 juni)',9,9,'2026-06-25 14:44:01','2026-06-25 14:44:02'),(403144,'T26005303','2026-06-25',5,23,NULL,21000,2,2647700,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.403144.jpg','bensin motor rival (25 juni)',9,9,'2026-06-25 14:44:35','2026-06-25 14:44:36'),(403145,'T26005304','2026-06-25',5,29,NULL,63000,2,2584700,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.403145.jpg','pembelian aqua galon 3 (25 juni)',9,9,'2026-06-25 14:45:06','2026-06-25 14:45:06'),(403146,'T26005305','2026-06-25',5,27,NULL,19500,2,2565200,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.403146.jpg','pembelian tissue (25 juni)',9,9,'2026-06-25 14:45:40','2026-06-25 14:45:41'),(403147,'T26005306','2026-06-25',8,4,NULL,270000,1,12455254.399994,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.403147.jpg','pembayaran tk. yunus lubis-leuwisadeng (25 juni)',9,9,'2026-06-25 14:54:28','2026-06-25 14:54:29'),(403149,'T26005307','2026-06-25',6,39,NULL,1000000,1,5513050,'fandi',1,NULL,'tarik tunai (22 mei)',4,4,'2026-06-25 15:02:56','2026-06-25 15:02:56'),(403150,'T26005308','2026-06-25',6,39,NULL,2000000,1,7513050,'fandi',1,NULL,'tarik tunai (26 mei)',4,4,'2026-06-25 15:11:26','2026-06-25 15:11:26'),(403151,'T26005309','2026-06-25',6,6,NULL,1250000,2,6263050,'fandi',1,NULL,'pembayaran gaji probation (26 mei)',4,4,'2026-06-25 15:13:03','2026-06-25 15:13:03'),(403152,'T26005310','2026-06-25',63,38,NULL,50000000,2,47904296,'widia',4,NULL,'pindah kas (24 juni)',9,9,'2026-06-25 15:17:03','2026-06-25 15:17:03'),(403153,'T26005311','2026-06-25',63,12,NULL,2500,2,47901796,'widia',4,NULL,'adm bank (24 juni)',9,9,'2026-06-25 15:17:23','2026-06-25 15:17:23'),(403154,'T26005312','2026-06-25',63,38,NULL,5000000,2,42901796,'widia',4,NULL,'pindah kas (24 juni)',9,9,'2026-06-25 15:17:49','2026-06-25 15:17:49'),(403155,'T26005313','2026-06-25',63,12,NULL,2500,2,42899296,'widia',4,NULL,'adm bank (24 juni)',9,9,'2026-06-25 15:18:01','2026-06-25 15:18:01'),(403156,'T26005314','2026-06-25',63,39,NULL,69859000,1,112758296,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.403156.jpg','setor tunai (25 juni)',9,9,'2026-06-25 15:18:33','2026-06-25 15:18:33'),(403157,'T26005315','2026-06-25',6,39,NULL,42200000,1,48463050,'fandi',1,NULL,'pindah kas',4,4,'2026-06-25 15:19:49','2026-06-25 15:19:49'),(403158,'T26005316','2026-06-25',3,23,NULL,293700,2,743566.61999995,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.403158.jpg','bensin mobil granmax hitam baru rasyid (25 juni)',9,9,'2026-06-25 15:21:03','2026-06-25 15:21:03'),(403159,'T26005317','2026-06-25',6,25,NULL,200000,2,48263050,'fandi',1,NULL,'konsumsi tutup buku (30 mei)',4,4,'2026-06-25 15:24:45','2026-06-25 15:24:45'),(403160,'T26005318','2026-06-25',6,25,NULL,750000,2,47513050,'fandi',1,NULL,'pembelian barang, parkir dan kuli bongkar',4,4,'2026-06-25 15:25:44','2026-06-25 15:25:44'),(403161,'T26005319','2026-06-25',6,6,NULL,42200000,2,5313050,'fandi',1,NULL,'payrol akhir bulan ( 30 mei)',4,4,'2026-06-25 15:26:06','2026-06-25 15:26:06'),(403162,'T26005320','2026-06-25',1,12,NULL,17000,2,2442804.1999969,'fandi',1,NULL,'adm bank ( 17 mei)',4,4,'2026-06-25 15:30:17','2026-06-25 15:30:17'),(403163,'T26005321','2026-06-25',8,4,NULL,500000,1,12955254.399994,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.403163.jpg','pembayaran tk. hj ujang-ciderum caringin (25 juni)',9,9,'2026-06-25 15:37:06','2026-06-25 16:26:20'),(403164,'T26005322','2026-06-25',5,7,NULL,250000,2,2315200,'widia',4,NULL,'ojt sales frenki (25 juni)',9,9,'2026-06-25 16:56:17','2026-06-25 16:56:17'),(403165,'T26005323','2026-06-25',8,4,NULL,215000,1,13170254.399994,'widia',1,'https://financeagro.s3.ap-southeast-3.amazonaws.com/transaction/receipt.403165.jpg','pembayaran tk. widya-ciremai ujung (25 juni)',9,9,'2026-06-25 16:57:39','2026-06-25 16:57:39');

--
-- Table structure for table `s_transaction_allocation`
--

CREATE TABLE `s_transaction_allocation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `transaction_id` int(11) NOT NULL DEFAULT 0,
  `allocation_number` varchar(20) NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL DEFAULT '',
  `amount` double NOT NULL DEFAULT 0,
  `description` text DEFAULT NULL,
  `status` tinyint(3) NOT NULL DEFAULT 0 COMMENT '0=draft, 1=aktif',
  `created` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `transaction_id` (`transaction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `s_transaction_allocation`
--


--
-- Table structure for table `s_transaction_link`
--

CREATE TABLE `s_transaction_link` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `transaction_id` int(11) NOT NULL DEFAULT 0,
  `allocation_id` int(11) DEFAULT NULL,
  `link_id` int(11) DEFAULT NULL,
  `link_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `link_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `link_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `link_identity` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_transaction_id` (`transaction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `s_transaction_link`
--


--
-- Table structure for table `s_user_account`
--

CREATE TABLE `s_user_account` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `transaction_account_id` int(11) NOT NULL DEFAULT 0,
  `created` datetime DEFAULT NULL,
  `created_by` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=386 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `s_user_account`
--

INSERT INTO `s_user_account` VALUES (1,1,1,'2020-01-15 19:36:19',1),(2,1,3,'2020-01-15 19:36:19',1),(3,1,4,'2020-01-15 19:36:19',1),(4,1,2,'2020-01-15 19:36:19',1),(5,1,5,'2020-01-15 19:36:19',1),(11,2,1,'2020-01-15 19:47:01',2),(12,2,3,'2020-01-15 19:47:02',2),(13,2,4,'2020-01-15 19:47:02',2),(14,2,2,'2020-01-15 19:47:02',2),(15,2,5,'2020-01-15 19:47:02',2),(17,3,1,'2020-02-03 13:12:42',3),(18,3,3,'2020-02-03 13:12:42',3),(19,3,4,'2020-02-03 13:12:42',3),(20,3,2,'2020-02-03 13:12:42',3),(21,3,5,'2020-02-03 13:12:42',3),(30,6,3,'2022-02-05 02:26:38',4),(31,6,5,'2022-02-05 02:26:38',4),(32,6,7,'2022-02-05 02:26:38',4),(36,4,1,'2022-02-15 11:41:33',4),(37,4,2,'2022-02-15 11:41:33',4),(38,4,3,'2022-02-15 11:41:33',4),(39,4,5,'2022-02-15 11:41:33',4),(40,4,6,'2022-02-15 11:41:33',4),(41,4,7,'2022-02-15 11:41:33',4),(42,4,8,'2022-02-15 11:41:33',4),(43,9,3,'2022-02-15 11:41:45',4),(44,9,5,'2022-02-15 11:41:45',4),(45,9,7,'2022-02-15 11:41:45',4),(46,9,8,'2022-02-15 11:41:45',4),(385,9,63,'2024-07-11 13:51:25',4);


