--
-- Host: localhost    Database: livrocaixa
-- ------------------------------------------------------


--
-- Table structure for table `account_files`
--

CREATE TABLE `account_files` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `original_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `account_files_account_id_foreign` (`account_id`),
  CONSTRAINT `account_files_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=241 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `account_files`
--

INSERT INTO `account_files` VALUES (1,1,'69d3d64efeeec5d61a5a79d2951f42e73a0a1f45.pdf','boleto_maca.pdf','2018-09-19 15:38:16','2018-09-19 15:38:16'),(2,5,'19e68f59318b6a0be768c22519e60bb91cdfb3f1.jpg','ALUGUEL SÃO PAULO - MES 09-18.jpg','2018-09-28 14:52:21','2018-09-28 14:52:21'),(4,6,'31a4978f3eb84a1c1bc3b260cb06c6f17e193dfb.jpg','ALUGUEL RJ- MES 09-18.jpg','2018-09-28 15:16:15','2018-09-28 15:16:15'),(5,10,'600a6b403ea0f6d399a239c442aecba08fc3568c.jpg','IMPOSTO ISSQN LRV.jpg','2018-09-28 18:05:00','2018-09-28 18:05:00'),(6,11,'737d142b61d27b46e0a9ab3a868897cd07ba56fc.jpg','IMPOSTO CONFINS LRV 09-18.jpg','2018-09-28 18:14:52','2018-09-28 18:14:52'),(7,12,'7146a904c84cc3d3b77314b49c4ad54d865fa19c.jpg','IMPOSTO ISSQN LRV.jpg','2018-09-28 18:20:49','2018-09-28 18:20:49'),(8,14,'76720552bc00ae5929e0559c6877d918191ce8e5.jpg','IMPOSTO ISSQN LRV.jpg','2018-09-28 18:35:18','2018-09-28 18:35:18'),(9,15,'aea98f1d844c2b5fff141fce06b054de72c39e52.jpg','IMPOSTO DAM - NOVA MUTUM.jpg','2018-09-28 18:44:01','2018-09-28 18:44:01'),(10,2,'8c65ee63e4af94bafab4c0ab1587823216390a80.jpg','IMPOSTO PIS LRV.jpg','2018-09-28 18:50:04','2018-09-28 18:50:04'),(11,13,'9c9b30d75d1f22c5e955dacf683e2de766519a3b.jpg','IMPOSTO CONFINS LRV 09-18.jpg','2018-09-28 18:51:43','2018-09-28 18:51:43'),(12,7,'fa553cb0389b871a10da38a272ebcbbb39578e16.jpg','BLOETO PARANA 04-10-18 1.219,50.jpg','2018-09-28 19:05:51','2018-09-28 19:05:51'),(13,16,'2cdd80603af2a8f48061278ed3e9c260119cfc0c.jpg','IMPOSTO DARF LRV 1.150,05.jpg','2018-09-28 19:30:34','2018-09-28 19:30:34'),(14,9,'884b3d68a4034fd367128079ec6bd6a5907915e9.jpg','PARANA VENC. 01-10-18 55,00.jpg','2018-09-28 19:31:35','2018-09-28 19:31:35'),(15,17,'7ed4a8dd25d37492b028d80ad60d6b01f3ba5c67.jpg','OXIGENIO MEDICINAL LIFE SP-09-18.jpg','2018-09-28 19:41:03','2018-09-28 19:41:03'),(16,18,'36ce27de533a4fd4a271b8f385ea11c9fb561478.jpg','BOLETO PARANA VENC. 07-10-18 766,90.jpg','2018-09-28 20:54:48','2018-09-28 20:54:48'),(22,14,'99eb0c2284d10521943db75e687841b851b7559d.pdf','Comprovante.pdf','2018-10-01 11:54:44','2018-10-01 11:54:44'),(23,6,'1f37ee3920898541f13fb1ea559dc7fba5b9d8cf.jpg','ALUGUELRJ.jpg','2018-10-01 12:03:36','2018-10-01 12:03:36'),(24,18,'342c4e98d47808fbedc87a271987389f97d0389e.jpg','766,9.jpg','2018-10-01 12:13:32','2018-10-01 12:13:32'),(25,18,'05903c82f6974e3b3fdbfc436be23282402f2d25.pdf','DANFE181222.pdf','2018-10-01 12:13:46','2018-10-01 12:13:46'),(26,5,'ed590e548c234c5fb81433073395ccc894c5e013.jpg','alguel sp cp.jpg','2018-10-01 13:16:47','2018-10-01 13:16:47'),(27,22,'8325d0a0b67a17e7f08c09781a6c02f2013ec5a0.pdf','BOLETO120.pdf','2018-10-01 13:38:26','2018-10-01 13:38:26'),(28,22,'94730bcf42ec6df9ff263e99ae1b2302f29e7281.pdf','DANFE120.pdf','2018-10-01 13:38:42','2018-10-01 13:38:42'),(29,23,'4e6463663532c19c06e185e0498837e210477996.pdf','DANFE751,5-17,00.pdf','2018-10-01 13:47:22','2018-10-01 13:47:22'),(30,23,'3d945fb27dfad59e7d0929adaa92538c2e4839c7.pdf','DANFE761,5-744,5.pdf','2018-10-01 13:47:22','2018-10-01 13:47:22'),(31,24,'20e0192e41c2aaa6ac971f9c22c9f1e51cf1a506.pdf','BOLETO215,2.pdf','2018-10-01 13:57:20','2018-10-01 13:57:20'),(32,25,'a739eae7ef9612dfd991948bf6f94fcd06462ec5.pdf','BOLETO544,7.pdf','2018-10-01 13:57:58','2018-10-01 13:57:58'),(33,25,'eff41fd5a893e99e529639372745f161460a3a55.pdf','DANFE544,7.pdf','2018-10-01 13:57:58','2018-10-01 13:57:58'),(34,13,'d9e77b1056ab214d2b4603b78f3e2c5b62482857.pdf','Bradesco_01102018_121313.pdf','2018-10-01 15:32:32','2018-10-01 15:32:32'),(39,20,'02655550d846b027a953115df26e1d61b815dcfb.pdf','boleto 134.50.pdf','2018-10-03 17:55:34','2018-10-03 17:55:34'),(40,20,'33e2ff584b45a4a13cc72509bcd89c66d6c8aac5.pdf','NF-e 228033.pdf','2018-10-03 17:55:53','2018-10-03 17:55:53'),(41,26,'5a2f8595f0df26adaec7b2a7f076bb96e021c335.jpg','FGTS - 05-10-18.jpg','2018-10-03 18:10:10','2018-10-03 18:10:10'),(42,27,'ecb56359870f575d68b4808a9ffd83d82cb2b499.jpg','HONORARIO - 04-10-18.jpg','2018-10-03 18:17:27','2018-10-03 18:17:27'),(44,31,'4242dcd59df3c92885c3c3d2a6cca97da6965f93.pdf','Boleto1983141   688.30.pdf','2018-10-03 18:40:23','2018-10-03 18:40:23'),(45,32,'1d1ebffcae67c67a2a38260730efbf5fdc26c9e5.pdf','Boleto 761,50.pdf','2018-10-03 18:45:36','2018-10-03 18:45:36'),(46,30,'68ebbe91fed92dbb903a938b1eb152194b1bc143.jpg','IMPOSTO MAIARA - VENC. 21-01-19.jpg','2018-10-03 18:54:34','2018-10-03 18:54:34'),(47,31,'463bd5783ebdd8ee981d50be7d151ed59f61e3ae.pdf','DANFE82377 688,30.pdf','2018-10-03 18:57:23','2018-10-03 18:57:23'),(48,33,'14c51f0ece4376528efc2af4cdc47153c1bbec5d.pdf','CCM_boleto 7.290,80.pdf','2018-10-03 19:03:15','2018-10-03 19:03:15'),(49,34,'33870db8045fd33cfa7dd88138473b61d1a7d75b.jpg','CENTRAL-X.jpg','2018-10-03 19:15:17','2018-10-03 19:15:17'),(50,35,'5c9538a2a655c5eda59c5ed4a18e783073c2cbeb.PDF','Boleto-002239-10-2018 residual .PDF','2018-10-03 21:35:07','2018-10-03 21:35:07'),(51,36,'ccd41606f2c81d0d4d8e361dfe84d0f5369bbc3a.jpg','FGTS- 05-10-18.jpg','2018-10-04 14:29:18','2018-10-04 14:29:18'),(52,38,'7b5c49b8ab25d6e7cbd3c4f1d91a533fefa26500.pdf','FERNANDA MENESES.pdf','2018-10-08 21:15:19','2018-10-08 21:15:19'),(53,38,'31fb409aad29060e01dcb1d1a2f85ca616bb7a79.pdf','FERNANDA MENEZES (1).pdf','2018-10-08 21:19:34','2018-10-08 21:19:34'),(54,39,'c2a54691a086b1d5ca6ad622f7e82ffdabf4d6ae.pdf','52585_201802000000375 FERNANDA MENEZES .pdf','2018-10-08 21:24:32','2018-10-08 21:24:32'),(55,39,'aaf8bf8cea05a86ab1403b3b818ee6fd746f4cec.pdf','4.500,00FERNANDA MENEZES.pdf','2018-10-08 21:24:42','2018-10-08 21:24:42'),(56,41,'ffcae0fd72ab07eb179f82046acd085bb6714eb2.pdf','BOLETO PARANA 207,00.pdf','2018-10-09 11:59:28','2018-10-09 11:59:28'),(57,42,'3076a3274d86dc58f1994e86229a3ac86f740d43.pdf','BOLETO PARANA 1.075,50.pdf','2018-10-09 12:00:55','2018-10-09 12:00:55'),(58,43,'eae64bf2456d5a282c5f268c87a73dca84c22522.pdf','BOLETO PARANA 524,00.pdf','2018-10-09 12:02:41','2018-10-09 12:02:41'),(59,44,'312e6962434cbb062e485ae6ca1b23f3b8825d98.pdf','ELETROPAULO.pdf','2018-10-09 12:05:39','2018-10-09 12:05:39'),(60,45,'8260fb69d6ac682c0a10b5c301af8afe623f6b9c.pdf','BOLETO VIDENCE.pdf','2018-10-09 14:11:09','2018-10-09 14:11:09'),(61,45,'2bb2cc24c6752d36aada1dd9ffba10f43b197b1b.pdf','NOTA VIDENCE .pdf','2018-10-09 14:11:21','2018-10-09 14:11:21'),(62,37,'ba3341480873cde106eb6f181808293972681469.jpg','GUIA DA PREVIDENCIA SOCIAL.jpg','2018-10-09 14:28:48','2018-10-09 14:28:48'),(63,46,'50d8e1b8324e917a831c4fe7f204594e09709acb.jpg','BIO RESIDUO LRV.jpg','2018-10-09 14:55:53','2018-10-09 14:55:53'),(65,48,'34f8b9f8e2dd35820edacfb165b221be992db54d.pdf','energia.pdf','2018-10-09 15:29:39','2018-10-09 15:29:39'),(66,49,'0c2f8904a5c894a41a4fc5b1380d972a61df5f23.jpg','SAAE.jpg','2018-10-09 15:36:06','2018-10-09 15:36:06'),(68,48,'58fed47a1bce4743029616b6730ec03fb5a38c94.png','cplight88,08.png','2018-10-09 16:40:16','2018-10-09 16:40:16'),(69,50,'c5515af8e5b8e90c18010afc2749ae9289890325.jpg','DAM - NOVA MUTUM 31-10-18.jpg','2018-10-09 18:25:14','2018-10-09 18:25:14'),(72,55,'92dd5fdac42761ca13067c8623f7b92344cafad3.pdf','Comprovante (1).pdf','2018-10-09 20:01:31','2018-10-09 20:01:31'),(73,45,'cb14c1b49a60e708ff0550822bc45e273376072a.jpg','comprovante vydence .jpg','2018-10-09 20:08:13','2018-10-09 20:08:13'),(74,41,'bc85900e1402567d0aee1254bd4a29ff41e39cc5.pdf','DANFE82726.pdf','2018-10-09 20:20:24','2018-10-09 20:20:24'),(75,42,'8b55532dab3e414a5a3c689ef10e78e48ccbfeb7.pdf','DANFE82763.pdf','2018-10-09 20:22:38','2018-10-09 20:22:38'),(76,43,'64a32ca323e7b4ef7b5f9c567d05b0fdbd9d85d3.pdf','DANFE82734.pdf','2018-10-09 20:24:03','2018-10-09 20:24:03'),(77,43,'2bbbc97c355b797b4e59990cb5765edc6a9196e1.pdf','DANFE82733.pdf','2018-10-09 20:24:27','2018-10-09 20:24:27'),(78,46,'98f48b5ccfdef508897e0c862298013ef9dc7772.jpg','comprovante bio residuo.jpg','2018-10-09 20:30:16','2018-10-09 20:30:16'),(79,49,'af08ab79b8f2de32ee57b4a190c3c6eea8b7e900.png','comprovante saae.png','2018-10-09 20:31:52','2018-10-09 20:31:52'),(80,47,'c706e8c8a024d25f02ec42904783830b567b2c6a.jpg','MINHA NET 05-10-18.jpg','2018-10-09 20:42:04','2018-10-09 20:42:04'),(81,47,'eaacca5109a0e0c02b73407a94e5a1eba8751dde.pdf','Comprovante MINHANET.pdf','2018-10-09 20:42:40','2018-10-09 20:42:40'),(82,24,'bb8a51b23469f1281808fdcd6f071fd3de96123c.jpg','COMPROVANTE 215,20.jpg','2018-10-09 20:53:16','2018-10-09 20:53:16'),(83,22,'e8b422d49b7f0a42e63f7b33a47dee309da4f4c1.jpg','COMPROVANTE 120,00.jpg','2018-10-09 20:54:10','2018-10-09 20:54:10'),(84,25,'a8c98bb95f6ccfba555a267937fdf2f8b196f8d9.pdf','Comprovante 544,70.pdf','2018-10-09 20:58:23','2018-10-09 20:58:23'),(85,36,'830c1d0bb94b8118bc5b6f5d625a847e4e0d5a77.pdf','Comprovante fgts.pdf','2018-10-09 20:59:35','2018-10-09 20:59:35'),(86,56,'a8a1d2e15fd3d4b746fa9ca2d8edfbd14d563d00.jpg','BOLETO VIVO.jpg','2018-10-09 21:14:22','2018-10-09 21:14:22'),(87,56,'be866222b1f282a65e39582b3de17f938bf44326.png','COMPROVANTE 69,99.png','2018-10-09 21:14:45','2018-10-09 21:14:45'),(88,31,'7c6c29027795d1df51d8ad0f5564b235a09f9674.jpg','COMPROVANTE 688,30.jpg','2018-10-09 21:17:31','2018-10-09 21:17:31'),(89,54,'3ea51e7a75757e29a2a04129875529e337685f6a.pdf','Boleto 1.161,20.pdf','2018-10-09 21:19:39','2018-10-09 21:19:39'),(90,54,'b168dc283f7d49a7dadba07b06640ec7a2393c4f.pdf','DANFE82678.pdf','2018-10-09 21:20:03','2018-10-09 21:20:03'),(91,54,'c062816e1c30a9d6c0c807ea3642e8d5fb05d446.pdf','DANFE82680.pdf','2018-10-09 21:20:26','2018-10-09 21:20:26'),(92,54,'50565ec8789e81650acc263dc74b345f11d68920.pdf','DANFE229444.pdf','2018-10-09 21:20:45','2018-10-09 21:20:45'),(93,57,'6be73b25a8193599b9bb4d198116d9b8bb075ed2.jpg','ENERGIA DAL ALBA 32,91.jpg','2018-10-09 21:24:36','2018-10-09 21:24:36'),(94,57,'b4c02567b7a0190a4f13544def54d609adc37efc.pdf','Comprovante 32,91.pdf','2018-10-09 21:26:07','2018-10-09 21:26:07'),(95,58,'a96d1c66ac2782a673473d9a17f43a3feb5356e3.pdf','Comprovante CASA 111,86.pdf','2018-10-09 21:29:27','2018-10-09 21:29:27'),(96,58,'875e29c251e770adef0b5c916caa72971436c7f1.jpg','ENERGIA EQUADOR 111,86.jpg','2018-10-09 21:29:46','2018-10-09 21:29:46'),(97,33,'06ae99dfb2116353dee641dea8bacbb4177d9861.jpg','CCM 7.290,80.jpg','2018-10-09 21:33:13','2018-10-09 21:33:13'),(98,59,'367f3b7d6bf6ef7af329987a10d7fea25ca0088c.pdf','Otavio Campagnaro Rocha.pdf','2018-10-10 12:17:35','2018-10-10 12:17:35'),(99,35,'dc65ef6f107f3f13e7e02f59dd8cfe277073afb8.png','COMPROVANTE 68,21 BIO RESIDUO.png','2018-10-10 12:23:42','2018-10-10 12:23:42'),(100,27,'9565943fcc1ec0b645d89e487c00f531bb00d537.jpg','COMPROVANTE MULTICON 1.272,00.jpg','2018-10-10 12:39:43','2018-10-10 12:39:43'),(101,26,'9e14fc06d94d2ca081c302c9f244300d32b41ad6.png','COMPROVANTE 477,40.png','2018-10-10 12:41:20','2018-10-10 12:41:20'),(102,20,'aeb9033f7d2d85ca04b6fd71625e5c2cc5b975ac.pdf','Comprovante PARANA 134,50.pdf','2018-10-10 12:46:57','2018-10-10 12:46:57'),(103,60,'d8e368a81f6189d983bd5754840c3c8463b8214f.jpg','BOLETO PRESTAÇÃO CASA.jpg','2018-10-10 12:59:08','2018-10-10 12:59:08'),(104,60,'24e0faeb7f87900507301289c824e91b90a5f434.jpg','COMPROVANTE 3.835,67.jpg','2018-10-10 12:59:23','2018-10-10 12:59:23'),(105,53,'d06bc68e732ee08af908a30c008aa1a42f2e9a4b.jpg','CONFINS - 849,30.jpg','2018-10-10 13:01:48','2018-10-10 13:01:48'),(106,52,'0cb6fc6f6902fb7275ce5e00e721f853333e0c17.jpg','PIS - 184,02.jpg','2018-10-10 13:22:39','2018-10-10 13:22:39'),(107,51,'01ee39048153cc87a435cbb702c8d68407f47f6e.jpg','DAM LRV - 646,89.jpg','2018-10-10 13:24:34','2018-10-10 13:24:34'),(108,9,'9442671280f8240959b966eb3dfee4ff1da26630.pdf','Boleto1973175 55,00.pdf','2018-10-10 13:33:16','2018-10-10 13:33:16'),(109,9,'8e294e612a3eb35b8021728b3c28068856cd925d.pdf','DANFE227861 55,00.pdf','2018-10-10 13:34:47','2018-10-10 13:34:47'),(110,61,'7f1c83e0924975c973c16a903c1f6593326de6df.pdf','Comprovante Tania funcionaria .pdf','2018-10-10 18:06:11','2018-10-10 18:06:11'),(111,62,'7141f119b57dd627c8564ccb7de41ee3d118f24a.jpg','COMPROVANTE 4.850,00.jpg','2018-10-10 18:19:55','2018-10-10 18:19:55'),(112,32,'5151a06092154670774f88091cd06b8ee95b9b3c.pdf','DANFE82267.pdf','2018-10-10 18:53:52','2018-10-10 18:53:52'),(113,24,'7068af9786456854e58c27eca6d7184c096e1a6c.pdf','DANFE228251.pdf','2018-10-10 18:59:54','2018-10-10 18:59:54'),(114,61,'b7461fe46578d3f56222ad008390bd9b9190f5ca.pdf','RECIBO TANIA MARA .pdf','2018-10-10 19:08:13','2018-10-10 19:08:13'),(115,63,'597eb9e75eeccb6f3fe247e9a3b5e5191e6fb24a.pdf','HOLERITE EDI.pdf','2018-10-10 20:31:15','2018-10-10 20:31:15'),(117,64,'a93e011fda4e351294b15c1a066c864da78bad8d.pdf','Boleto OXIGENIO 70,00 .pdf','2018-10-10 20:55:36','2018-10-10 20:55:36'),(118,65,'e609068cc8c9ad20cd33cbdf41eb674cc1441a15.pdf','Otavio Campagnaro Rocha - Reserva de vaga 2019 parcela 1.pdf','2018-10-10 21:17:13','2018-10-10 21:17:13'),(119,66,'34d3c3573b721bb321c394b0836229311bf07dc0.pdf','Otavio Campagnaro Rocha - Reserva de vaga 2019 parcela 2 - 416,67.pdf','2018-10-10 21:19:40','2018-10-10 21:19:40'),(120,67,'0272a7d100a4eb072450a06fecde8fc45af907ec.pdf','Otavio Campagnaro Rocha - Reserva de vaga 2019 parcela 3 -416,67.pdf','2018-10-10 21:21:12','2018-10-10 21:21:12'),(121,68,'8964233b6fa26462a54626cb9c5f77159b7d0d3a.pdf','NOTA - ANA LUCIA BRUNO 4.500,00.pdf','2018-10-10 21:37:26','2018-10-10 21:37:26'),(122,68,'6e0880da15240ee073408686f747d0c463caf547.pdf','NOTA - ANA LUCIA T. A. BRUNO 16.100,00.pdf','2018-10-10 21:37:41','2018-10-10 21:37:41'),(123,69,'6bd512eb6c613dbb607ff770d75ba749d5d486a3.pdf','Boleto 115,00.pdf','2018-10-11 12:18:34','2018-10-11 12:18:34'),(124,69,'777e00879d75646d03c077f59f2667bff02161e0.pdf','DANFE83060 - 115,00.pdf','2018-10-11 12:18:45','2018-10-11 12:18:45'),(125,70,'53801d2a74ccd241461515a7fe4178662e04ea48.pdf','ANADEM - 572,12    20-10-2018.pdf','2018-10-11 12:55:53','2018-10-11 12:55:53'),(126,71,'8a5f89268726eb7a0f828e8b34ade0b027a296d3.pdf','BENEFIC - MEDICOS SEM FRONTEIRAS 45,00.pdf','2018-10-11 13:00:59','2018-10-11 13:00:59'),(127,72,'205aa04098b969a63beaa08000194be3f57d457c.pdf','ANADEM - 572,12    20-10-2018.pdf','2018-10-11 14:07:29','2018-10-11 14:07:29'),(128,73,'e0d20b9def5960ae763a71ee4da24cd47354017f.pdf','NFSe - CYNTIA 4.500,00 (1).pdf','2018-10-11 15:23:20','2018-10-11 15:23:20'),(129,73,'75a9c493678896ba7cbe8ed20fae531e6441795a.pdf','NFSe - CYNTIA 4.500,00.pdf','2018-10-11 15:23:41','2018-10-11 15:23:41'),(130,73,'4e9dbb4a1c3b20c309593ee8659750febe2f276b.pdf','NFSe - CYNTIA 2.300,00.pdf','2018-10-11 15:23:53','2018-10-11 15:23:53'),(136,74,'9a417d11a1cc99703c5360f061c6f9ac5d5df1a6.pdf','52585_201802000000189.pdf','2018-10-11 17:51:21','2018-10-11 17:51:21'),(137,74,'d57b309e509731ceb1ab548f6b56af7fd1e28e9f.pdf','52585_201802000000184.pdf','2018-10-11 17:52:16','2018-10-11 17:52:16'),(138,74,'0ace8be107a6dc101b150703b6978a49cd74e5ae.pdf','52585_201802000000034.pdf','2018-10-11 17:55:03','2018-10-11 17:55:03'),(139,75,'cbdae88f292a9b689307905714bbd68436e3674f.pdf','52585_201802000000305.pdf','2018-10-11 18:12:24','2018-10-11 18:12:24'),(140,75,'82e191b07029a6eb727b63ec0163b44afeb70bf3.pdf','52585_201802000000306.pdf','2018-10-11 18:12:38','2018-10-11 18:12:38'),(141,76,'0ffc1c9e6cb265c1e3fd3427ed43956f13158064.pdf','52585_201802000000036.pdf','2018-10-11 18:24:56','2018-10-11 18:24:56'),(142,76,'095a91d0def4fb52dafdb82127cdc65c5c24b0be.pdf','52585_201802000000163.pdf','2018-10-11 18:25:16','2018-10-11 18:25:16'),(143,76,'5fdbf8cbd15d78ffcc0f958b432682631a52cbba.pdf','52585_201802000000268.pdf','2018-10-11 18:27:12','2018-10-11 18:27:12'),(144,40,'86c6548970dd0edb4b921f669b21c01b90080848.pdf','52585_201802000000009.pdf','2018-10-11 18:53:18','2018-10-11 18:53:18'),(145,77,'c63a08668f9bbf41b9bb1e2bbd6bd232667d1274.pdf','52585_201800000000242.pdf','2018-10-11 18:59:07','2018-10-11 18:59:07'),(146,78,'d45b9e9aab6aa91cd17bb01200f7ec4fcccd109a.pdf','52585_201802000000158.pdf','2018-10-11 19:03:13','2018-10-11 19:03:13'),(147,79,'1365ca3120ecead1d4f9f11f709265ee123838d5.pdf','52585_201802000000156.pdf','2018-10-11 19:07:49','2018-10-11 19:07:49'),(148,80,'3ff30b07fbc9a44bddaae0315d780e889d9dcbdb.pdf','52585_201802000000157.pdf','2018-10-11 19:13:35','2018-10-11 19:13:35'),(149,81,'f152e137a96dc5bcdbeaa24fb9007f0dc8803d28.pdf','52585_201802000000166.pdf','2018-10-11 19:18:25','2018-10-11 19:18:25'),(150,82,'cbb18e7347a22ecd7beac01c68d639f0e186f8b3.pdf','52585_201802000000161.pdf','2018-10-11 19:21:58','2018-10-11 19:21:58'),(151,83,'f493992fb98a5f674fc02fa29be1c8b320fff794.pdf','52585_201802000000162.pdf','2018-10-11 19:25:43','2018-10-11 19:25:43'),(152,84,'fc6cd4c94d25101b1c77dfc87b9162642c2a299d.pdf','52585_201802000000164.pdf','2018-10-11 19:28:44','2018-10-11 19:28:44'),(153,85,'1300807deb06276c74e7d12f0cb75b1acb7a7ba8.pdf','52585_201802000000035.pdf','2018-10-11 19:36:00','2018-10-11 19:36:00'),(154,86,'ebc692df6e189c9b18019cdb186570e350b3b51f.pdf','52585_201802000000165.pdf','2018-10-11 19:38:43','2018-10-11 19:38:43'),(155,87,'304dcf5ce131b8fcec37d713c024ad07a83ac670.pdf','52585_201802000000160.pdf','2018-10-11 19:42:11','2018-10-11 19:42:11'),(156,88,'e5952d87f85c4263af05844ca9cc4c7d5ab9b69b.pdf','FERNANDA CAÇÃO BRISO.pdf','2018-10-11 19:47:01','2018-10-11 19:47:01'),(157,89,'e8a4641e90a9d12c9894ad480e4c6561c1030d75.pdf','Comprovante troca de oleo carro 777,00.pdf','2018-10-11 20:45:15','2018-10-11 20:45:15'),(158,90,'448f3541c23e9c64a7ea2804f6788af97c9dfea7.pdf','Comprovante TIJOLO MAO DE OBRA 81,50.pdf','2018-10-11 20:49:23','2018-10-11 20:49:23'),(159,91,'7f0a0a6df62deac446e36ad08d2a1d69653415c2.jpg','PHOTO-2018-10-15-07-38-22 (1).jpg','2018-10-15 11:53:16','2018-10-15 11:53:16'),(160,92,'96ec0cf5fc8a83900f00fb7698cb2f74c0228fdf.pdf','BOLETO ARQUITETO HOME 336,75.pdf','2018-10-15 18:08:40','2018-10-15 18:08:40'),(161,93,'c748335d2fa46eb5ff26eafa2009b2b6fc18bc05.pdf','Boleto PARANA 930,00.pdf','2018-10-15 18:16:35','2018-10-15 18:16:35'),(162,93,'22741fa627f87b26843cdb6b785e4092de5a23e5.pdf','DANFE182524 811,11.pdf','2018-10-15 18:17:09','2018-10-15 18:17:09'),(163,93,'84ea2432c187add7f5943749b450d056bb51b33a.pdf','DANFE83167 15,69.pdf','2018-10-15 18:17:27','2018-10-15 18:17:27'),(164,93,'292b80ad9b1f46a83a1f81782ecc28d8983a09d6.pdf','DANFE230288 43,85.pdf','2018-10-15 18:17:38','2018-10-15 18:17:38'),(165,95,'fabdacd9c26254ef19e8b41dac994717c81825e3.pdf','Boleto - Honorários Contábeis - 09-2018  450,00.pdf','2018-10-15 18:28:24','2018-10-15 18:28:24'),(166,42,'2cbcdd2178f4cc01ef215dace893a053c05afe69.jpg','parana1075,50.jpg','2018-10-16 11:38:22','2018-10-16 11:38:22'),(167,41,'3a334287cde8889d2a53d2f696573579c997a17e.jpg','parana207.jpg','2018-10-16 11:39:16','2018-10-16 11:39:16'),(168,54,'e1b07ef0f07a8cb7e5916380b6ab12b705f64d5b.jpg','parana1161,20.jpg','2018-10-16 11:40:01','2018-10-16 11:40:01'),(169,43,'6d572590a4db16f3e636733670e74431c612180d.jpg','parana524.jpg','2018-10-16 11:40:41','2018-10-16 11:40:41'),(170,96,'ab5f93c9a9ead94d55e90519d2e005ddcfdb9bfd.png','eletropaulo182,17.png','2018-10-16 11:46:05','2018-10-16 11:46:05'),(171,96,'70c6340d7ad2dfecbe3009d3441154c039cb76c1.pdf','fatura-Setembro_18-0118271261.pdf','2018-10-16 11:46:06','2018-10-16 11:46:06'),(172,37,'591559a6d2b287aed1a52eebe9cd81ab92d06c01.PNG','gps.PNG','2018-10-16 12:09:18','2018-10-16 12:09:18'),(173,64,'fbdd606b8b7902a0f4036d8bcc0cee74701d298a.jpg','oxigeniome.jpg','2018-10-16 12:15:18','2018-10-16 12:15:18'),(174,95,'9902b8f39009428f0f84cbc21a91d6e48fa356ee.jpg','contabilsp.jpg','2018-10-16 12:19:49','2018-10-16 12:19:49'),(175,97,'0bc8ea16b5559ab8e50770d032345a4d4f76127e.pdf','Boleto 220,00.pdf','2018-10-16 14:17:46','2018-10-16 14:17:46'),(176,97,'392771611f18bb316332afcdb1643de5f634f895.pdf','DANFE230478 220,00.pdf','2018-10-16 14:17:57','2018-10-16 14:17:57'),(177,94,'3b9e378daf8f3643f1c7ad4c7d215f7d8e024ddb.pdf','Boleto PARANA 16,00.pdf','2018-10-16 14:18:15','2018-10-16 14:18:15'),(178,94,'1706631639ae8ea465394ea21713200d8766af6d.pdf','DANFE83130.pdf','2018-10-16 14:19:24','2018-10-16 14:19:24'),(179,98,'ac8262afe2a13edfef3b752cb8a89a0d6afcbc92.pdf','Boleto  175,00.pdf','2018-10-17 18:46:02','2018-10-17 18:46:02'),(180,98,'d043fc8f704f433aa06c9c5c0984f14da9fbc742.pdf','DANFE83454   175,00.pdf','2018-10-17 18:46:22','2018-10-17 18:46:22'),(181,99,'5343844195524210b1cdec4b7afd32de793a5d22.pdf','Boleto 64,30.pdf','2018-10-17 18:49:57','2018-10-17 18:49:57'),(182,99,'547f6b0edeff8c9f72747f3c641f63009b54aa8f.pdf','DANFE83495   64,30.pdf','2018-10-17 20:08:29','2018-10-17 20:08:29'),(183,100,'95d6dee97a0b24b7e00b19ddf29774f39118c3c0.pdf','ENERGISA EQUADOR   158,40.pdf','2018-10-17 20:46:12','2018-10-17 20:46:12'),(184,101,'9e2d2b155d92e5153727cc3a1f220dce0fd2cce3.pdf','ENERGISA CATUIPE  19,46.pdf','2018-10-17 20:47:34','2018-10-17 20:47:34'),(185,102,'72af3830d556ed27e490ea75d6f77e2252aba6bf.pdf','ENERGISA ESPUMOSO   32,83.pdf','2018-10-17 20:48:55','2018-10-17 20:48:55'),(186,93,'28e3db86047c65a0efc791f89f0b8ffa0873ece5.pdf','DANFE83496   930,00.pdf','2018-10-17 21:19:44','2018-10-17 21:19:44'),(187,103,'cf8db1ffaa89225761f7bfa84476bb4635d0de3c.pdf','DARF  578,11   31-10-2018.pdf','2018-10-18 12:20:06','2018-10-18 12:20:06'),(188,105,'69bf56b036623e7f0ea801eb0995b782c4e90acf.pdf','DARF 31-08-2018  578,11.pdf','2018-10-18 13:57:55','2018-10-18 13:57:55'),(189,106,'b14dd906a7846e13d5e7572c4e7ce062bd6de8a6.pdf','DARF  31-10-2018  578,11.pdf','2018-10-18 14:00:57','2018-10-18 14:00:57'),(190,107,'b5151144334e91bef188cfb39a6161af10c0401f.pdf','BOLETO 225,00.pdf','2018-10-18 21:05:40','2018-10-18 21:05:40'),(191,107,'9cbecbdcfaab5bebda1f643ec8866c72e7a55fae.pdf','NF-e 230818   225,00.pdf','2018-10-18 21:05:57','2018-10-18 21:05:57'),(192,108,'2c166b7d84a4a7b05c8f6339f1c62396a5f8d04c.PDF','BoletoAdbaze  6.397,00.PDF','2018-10-18 21:09:51','2018-10-18 21:09:51'),(193,109,'8ee3b2dae204b024abdc2e24c20c13963e3a7c08.pdf','BOLETO  892,00.pdf','2018-10-19 14:13:34','2018-10-19 14:13:34'),(194,109,'bca4b4d78f78377020052f9ada4b786c78fb00e4.pdf','DANFE83544    31,26.pdf','2018-10-19 14:13:57','2018-10-19 14:13:57'),(195,109,'4316807b7e8ddfa8398dc837b2215d9202a6f0c5.pdf','DANFE83549   860,74.pdf','2018-10-19 14:14:44','2018-10-19 14:14:44'),(197,110,'f0a0047f843b9ea390141da7f8831d92e27a3141.pdf','MINHANET  147,99.pdf','2018-10-19 14:23:38','2018-10-19 14:23:38'),(198,111,'4786876d849b48dc8c046a6f86ac588721f89be0.pdf','Boleto  119,60.pdf','2018-10-19 20:00:05','2018-10-19 20:00:05'),(199,111,'e08aa1a993088e906bc3eb487759f641bbe599b7.pdf','DANFE83528  119,60.pdf','2018-10-19 20:00:26','2018-10-19 20:00:26'),(200,112,'7c0d0bfc3bd7f70570b133d279cdc3bd03c4b516.pdf','BOLETO  130,00.pdf','2018-10-22 12:05:49','2018-10-22 12:05:49'),(201,112,'7cf2041e9ede517cb780869e26ff6772d9d5167c.pdf','DANFE83665  91,60.pdf','2018-10-22 12:09:38','2018-10-22 12:09:38'),(204,21,'7e3f073f1b9894297ca180dded503b0fcefe43fd.pdf','DAM 21-11-18  143,12.pdf','2018-10-22 12:31:20','2018-10-22 12:31:20'),(205,29,'83119abe225794e102ab3326cc618223ecf8ebe4.pdf','DAM  20-12-18  143,12.pdf','2018-10-22 12:37:45','2018-10-22 12:37:45'),(206,19,'58699e3e271b343ea078216b03a1c19c43da0500.pdf','DAM 22-10-18  143,12.pdf','2018-10-22 12:42:33','2018-10-22 12:42:33'),(207,113,'0dcb132a41bba4d89b0aa12b7c1111910ea7e4bd.pdf','DAM  21-01-19  143,12.pdf','2018-10-22 13:12:22','2018-10-22 13:12:22'),(208,52,'b8cfec5234cbca53ceea5af5c92d96bc431e029b.png','COMP. 184,02.png','2018-10-22 13:15:01','2018-10-22 13:15:01'),(209,100,'424391a0db416a622216852849d2bf4e1cd2fc5a.png','MP. ENERGISA 158,40.png','2018-10-22 13:16:33','2018-10-22 13:16:33'),(210,94,'a1e7fb3bfd1487d6eb16389758dbdc6509d48531.jpg','COMP. 16,00.jpg','2018-10-22 13:19:09','2018-10-22 13:19:09'),(211,93,'b2edc54db6965ff7ef909a072fc16cdbb984f999.jpg','COMP. 930,00.jpg','2018-10-22 13:22:53','2018-10-22 13:22:53'),(212,51,'f0f0d599823e0f30cb58ce5ababf2681275d4568.jpg','COMP. 646,89.jpg','2018-10-22 13:40:47','2018-10-22 13:40:47'),(213,97,'6c09c3ee777051d1f3c3ab7742d3eec392c0d2ff.jpg','COMP. 220,00.jpg','2018-10-22 13:42:17','2018-10-22 13:42:17'),(214,69,'05c0d697d28f3796a452801bd70df438bab57b70.jpg','COMP. 115,00.jpg','2018-10-22 13:46:37','2018-10-22 13:46:37'),(215,92,'c652780e1424acfae62a473d84949018922883be.jpg','COMP. 336,75.jpg','2018-10-22 13:49:25','2018-10-22 13:49:25'),(216,98,'6e00fc0c91fd241feff1efdbc02a41eea9dbe140.jpg','COMP. 175,00.jpg','2018-10-22 13:50:39','2018-10-22 13:50:39'),(217,114,'9c77a4d8d1d042949f15131cf60f4d8f6053766b.pdf','DARF  616,83.pdf','2018-10-22 14:35:20','2018-10-22 14:35:20'),(218,101,'ad489a0c397cfbdc4c4a14dc0dbc1e79848fb558.png','COMP.  19,46.png','2018-10-22 14:36:45','2018-10-22 14:36:45'),(220,116,'e3aec4e6dab825d2f3f858d3466802ac438e186e.PDF','COLEGIO OTAVIO  01-11-18  1.222,00.PDF','2018-10-22 14:45:55','2018-10-22 14:45:55'),(221,118,'270c3c23aa5a40b0b7dfb098463b61b1433e5f60.pdf','DARF  7.210,08.pdf','2018-10-23 19:58:24','2018-10-23 19:58:24'),(222,119,'9779f6072de38c2a3f76a5c41b10a827f2f76267.pdf','DARF  14.028,00.pdf','2018-10-23 20:08:15','2018-10-23 20:08:15'),(224,120,'b21cc099786b3277a095a87b4434dd6143050218.pdf','BOLETO  135,90.pdf','2018-10-23 20:27:06','2018-10-23 20:27:06'),(225,120,'ccc75a2cd6b5fcdff841e737503990fe0b292a72.pdf','DANFE83886   135,90.pdf','2018-10-23 20:27:25','2018-10-23 20:27:25'),(226,121,'9e8dbc9a4a218b136220270ca042f8ff00e8c0c6.pdf','BOLETO 54,50.pdf','2018-10-25 14:51:07','2018-10-25 14:51:07'),(227,121,'b2d154435a5181200ad3eff5d69d5f186d0597c4.pdf','DANFE84029  54,60.pdf','2018-10-25 14:51:28','2018-10-25 14:51:28'),(228,122,'c534618d1fa8f396ab088fc4eeeb1de8b2c45892.pdf','BOLETO  200,00.pdf','2018-10-25 14:53:04','2018-10-25 14:53:04'),(229,122,'f579dbff96cb322c64409822a33c50e64a39bb58.pdf','DANFE231681  200,00.pdf','2018-10-25 14:53:20','2018-10-25 14:53:20'),(230,123,'9d1c3099838a0cbfb5d48602a900d62d1a6fcfa1.pdf','OI FIXO 156,13.pdf','2018-10-25 15:04:12','2018-10-25 15:04:12'),(231,124,'3f788fb63a69dc5b4c5bad267f82202e1599e8f2.pdf','CONTA VIVO.pdf','2018-10-25 15:08:03','2018-10-25 15:08:03'),(232,125,'848ea82883556c1149d4b504b22a124bb6be5610.pdf','BOLETO  607,90.pdf','2018-10-25 18:05:13','2018-10-25 18:05:13'),(233,125,'a58b4bcdc8abf2ab367c464075f84b4a3aabf7be.pdf','DANFE183556  506,58.pdf','2018-10-25 18:05:51','2018-10-25 18:05:51'),(234,125,'45bd5e4f0e9881d251ad0a27f05095639443b9c6.pdf','DANFE84003   101,32.pdf','2018-10-25 18:06:16','2018-10-25 18:06:16'),(235,126,'830c12e358d312e2f99249e1bfc4bcbe4783a759.pdf','BIO RESIDUO LRV  52,63  15-11-18.pdf','2018-10-25 21:32:06','2018-10-25 21:32:06'),(236,127,'7d249d182f6ce90c33d43a8279a24eab27e3db69.pdf','BOLETO  5.034,55.pdf','2018-10-26 12:28:14','2018-10-26 12:28:14'),(237,128,'6315d05002c666c3916d550648999c91f77270c6.pdf','FGTS  280,00.pdf','2018-10-26 14:37:13','2018-10-26 14:37:13'),(239,129,'3f55eafea6ebb1db509da0b86da41da75e352e9b.pdf','TANIA MARA 10-18.pdf','2018-10-26 14:45:03','2018-10-26 14:45:03'),(240,130,'459141eb7e65e431b79ea06b1671952e2b7e7a84.pdf','FGTS  280,00.pdf','2018-10-26 14:47:45','2018-10-26 14:47:45');

--
-- Table structure for table `accounts`
--

CREATE TABLE `accounts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(10) unsigned NOT NULL,
  `company_id` int(10) unsigned NOT NULL,
  `payment_id` int(10) unsigned NOT NULL,
  `type` enum('R','D') COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('AP','AR','P','R') COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` decimal(8,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `flg_invoice` tinyint(1) NOT NULL DEFAULT '0',
  `expiration_date` date NOT NULL,
  PRIMARY KEY (`id`),
  KEY `accounts_category_id_foreign` (`category_id`),
  KEY `accounts_company_id_foreign` (`company_id`),
  KEY `accounts_payment_id_foreign` (`payment_id`),
  CONSTRAINT `accounts_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`),
  CONSTRAINT `accounts_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`),
  CONSTRAINT `accounts_payment_id_foreign` FOREIGN KEY (`payment_id`) REFERENCES `payment_methods` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=131 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `accounts`
--

INSERT INTO `accounts` VALUES (1,1,1,1,'D','AP','SERINGA<, gaze',900.00,'2018-09-19 15:37:22','2018-09-19 15:39:44','2018-09-19 15:39:44',1,'2018-09-27'),(2,5,9,8,'D','P','DARF PIS - Pago pela Caixa',1153.84,'2018-09-26 13:45:00','2018-09-28 18:50:04',NULL,1,'2018-09-25'),(3,3,29,1,'D','AP','LELLO LOCAÇÃO',5034.55,'2018-09-28 14:03:31','2018-09-28 14:06:38','2018-09-28 14:06:38',0,'2018-10-07'),(4,3,29,1,'D','AP','LELLO LOCAÇÃO',5034.55,'2018-09-28 14:14:13','2018-09-28 14:49:49','2018-09-28 14:49:49',0,'2018-10-07'),(5,3,29,1,'D','P','ALUGUEL SÃO PAULO - OUTUBRO 2018',5034.55,'2018-09-28 14:51:18','2018-10-01 13:17:29',NULL,1,'2018-10-07'),(6,3,3,1,'D','P','ALUGUEL RJ OUTUBRO 2018',7605.00,'2018-09-28 14:56:22','2018-10-01 12:03:49',NULL,1,'2018-10-05'),(7,9,12,1,'D','P','BOLETO REFERENTE A NOTA Nº 228065',1219.50,'2018-09-28 15:20:18','2018-09-28 19:05:51',NULL,1,'2018-10-04'),(8,4,7,1,'D','P','PAGO 28/09 UNICRED',247.80,'2018-09-28 17:24:32','2018-09-28 18:27:10','2018-09-28 18:27:10',0,'2018-09-28'),(9,9,12,1,'D','P','BOLETO REFERENTE A NOTA Nº 227861',55.00,'2018-09-28 17:37:18','2018-10-01 11:47:56',NULL,1,'2018-10-01'),(10,20,9,1,'D','AP','REF ISS DE 156 NFSe(s) AGOSTO/2018',5180.89,'2018-09-28 18:03:57','2018-09-28 18:18:43','2018-09-28 18:18:43',1,'2018-10-01'),(11,21,9,1,'D','AP','DARF CONFINS',5466.06,'2018-09-28 18:14:03','2018-09-28 18:26:37','2018-09-28 18:26:37',1,'2018-10-01'),(12,5,9,1,'D','AP','ISSQN LRV AGOSTO/2018',5180.89,'2018-09-28 18:19:54','2018-09-28 18:27:29','2018-09-28 18:27:29',1,'2018-10-01'),(13,22,9,8,'D','P','CONFINS',5466.06,'2018-09-28 18:32:18','2018-10-01 15:33:07',NULL,1,'2018-10-01'),(14,5,9,1,'D','P','ISSQN  AGOSTO/2018',5180.89,'2018-09-28 18:34:28','2018-10-01 11:56:47',NULL,1,'2018-10-01'),(15,4,7,1,'D','P','REFERENTE 08/2018',247.80,'2018-09-28 18:37:16','2018-09-28 18:44:01',NULL,1,'2018-09-28'),(16,22,9,8,'D','P','DARF LRV DO MES 08/2018',1150.05,'2018-09-28 19:29:18','2018-09-28 19:30:34',NULL,1,'2018-09-25'),(17,1,30,1,'D','P','RENOVAÇÃO DE LOCAÇÃO DE 1 CILINDRO DE 20L OXIGENIO',74.12,'2018-09-28 19:40:21','2018-09-28 19:41:03',NULL,1,'2018-09-28'),(18,9,12,1,'D','P','REFERENTE A NOTA Nº 181222',766.90,'2018-09-28 19:45:59','2018-10-01 12:14:36',NULL,1,'2018-10-07'),(19,24,33,1,'D','AP','ISSQN  FIXO ANUAL - REF. A PARCELA 9 DE 12',143.12,'2018-09-28 20:17:38','2018-10-22 14:18:29','2018-10-22 14:18:29',1,'2018-10-22'),(20,9,12,1,'D','P','REFERENTE AO PEDIDO Nº 1746177/1-1',134.50,'2018-09-28 20:56:43','2018-10-04 13:09:05',NULL,1,'2018-10-04'),(21,24,33,1,'D','AP','ISSQN FIXO ANUAL PARCELA 10 DE 12',143.12,'2018-09-29 15:00:39','2018-10-22 12:31:20',NULL,1,'2018-11-21'),(22,9,12,1,'D','P','Selador',120.00,'2018-10-01 13:37:00','2018-10-04 12:29:45',NULL,1,'2018-10-06'),(23,9,12,1,'D','AP','.',761.50,'2018-10-01 13:46:10','2018-10-09 15:36:32','2018-10-09 15:36:32',1,'2018-10-28'),(24,9,12,1,'D','P','.',215.20,'2018-10-01 13:55:03','2018-10-04 12:18:54',NULL,1,'2018-10-05'),(25,9,12,1,'D','P','.',544.70,'2018-10-01 13:56:23','2018-10-04 13:09:38',NULL,1,'2018-10-05'),(26,25,34,1,'D','P','FGTS',477.40,'2018-10-03 18:09:25','2018-10-04 12:24:33',NULL,1,'2018-10-05'),(27,12,14,1,'D','P','1ª parcela da taxa de balanço anual, conforme ocorre em todos os anos. A taxa de balanço é fracionada em 03(três) parcelas mensais, sendo que a 2ª e a 3ª seguirão nos próximos boletos.',1272.00,'2018-10-03 18:16:31','2018-10-04 12:16:23',NULL,1,'2018-10-04'),(28,6,8,8,'D','AP','Demonstrativos de valores devidos',920.00,'2018-10-03 18:21:12','2018-10-03 18:26:04','2018-10-03 18:26:04',0,'2018-10-07'),(29,24,33,1,'D','AP','Parcela 11 de 12',143.12,'2018-10-03 18:29:42','2018-10-22 12:37:45',NULL,1,'2018-12-20'),(30,24,33,1,'D','AP','parcela 12 de 12',143.12,'2018-10-03 18:31:26','2018-10-16 12:21:05','2018-10-16 12:21:05',1,'2019-01-21'),(31,9,12,1,'D','P','Referente ao pedido 1.752.929',688.30,'2018-10-03 18:39:36','2018-10-04 12:32:23',NULL,1,'2018-10-11'),(32,9,12,1,'D','P','Referente Nota Nº: 82267',761.50,'2018-10-03 18:45:08','2018-10-22 12:30:26',NULL,1,'2018-10-28'),(33,3,32,1,'D','P','SP BROKERS',7290.80,'2018-10-03 19:02:51','2018-10-04 12:27:22',NULL,1,'2018-10-05'),(34,26,35,1,'D','P','Referente as parcelas de 12-10-18',119.00,'2018-10-03 19:14:25','2018-10-22 12:05:05',NULL,1,'2018-10-22'),(35,27,36,1,'D','P','referente ao período de coletas de AGOSTO',68.21,'2018-10-03 21:34:40','2018-10-04 12:36:10',NULL,1,'2018-10-15'),(36,25,9,1,'D','P','FGTS',114.56,'2018-10-04 14:28:42','2018-10-09 16:32:22',NULL,1,'2018-10-05'),(37,28,9,8,'D','P','GUIA DA PREVIDENCIA SOCIAL',491.18,'2018-10-04 14:50:01','2018-10-16 12:09:32',NULL,1,'2018-10-19'),(38,14,37,9,'R','P','NOTA FISCAL EMITIDA PARA ALUNA FERNANDA MENEZES',25300.00,'2018-10-08 21:11:08','2018-10-08 21:20:18','2018-10-08 21:20:18',1,'2018-10-05'),(39,14,39,9,'R','P','NOTA FISCAL EMITIDA DA ALUNA FERNANDA MENEZES',25300.00,'2018-10-08 21:21:49','2018-10-08 21:32:04',NULL,1,'2018-10-05'),(40,14,38,9,'R','P','NOTA FISCAL EMITIDA DA ALUNA LOUISE LEAL FERNANDES ABRANTES',4500.00,'2018-10-08 21:27:55','2018-10-11 18:53:18',NULL,1,'2018-06-16'),(41,9,12,1,'D','P','REFERENTE A NOTA Nº 82726',207.00,'2018-10-09 11:58:41','2018-10-16 11:04:13',NULL,1,'2018-10-15'),(42,9,12,1,'D','P','REFERENTE A NOTA Nº 82763',1075.50,'2018-10-09 12:00:24','2018-10-16 11:02:34',NULL,1,'2018-10-15'),(43,9,12,1,'D','P','REFERENTE A NOTA Nº 82733',524.00,'2018-10-09 12:01:54','2018-10-16 11:00:58',NULL,1,'2018-10-15'),(44,2,6,1,'D','P','CONTA REFERENTE AO MES DE OUTUBRO',148.79,'2018-10-09 12:04:32','2018-10-22 12:38:23',NULL,1,'2018-11-05'),(45,1,40,1,'D','P','REFERENTE A MANUTENÇÃO DO APARELHO DE LASER',450.30,'2018-10-09 14:10:37','2018-10-09 16:42:59',NULL,1,'2018-10-15'),(46,27,41,1,'D','P','COLETA LUCAS DO RIO VERDE',52.63,'2018-10-09 14:53:31','2018-10-09 20:28:54',NULL,1,'2018-10-15'),(47,29,42,1,'D','P','INTERNET SP',152.06,'2018-10-09 14:59:43','2018-10-09 20:42:04',NULL,1,'2018-10-05'),(48,2,5,1,'D','P','ENERGIA RJ',88.08,'2018-10-09 15:09:53','2018-10-09 16:40:36',NULL,1,'2018-10-09'),(49,2,43,1,'D','P','AGUA RUA ESPUMOSO',100.25,'2018-10-09 15:34:47','2018-10-09 20:32:10',NULL,1,'2018-10-16'),(50,4,7,1,'D','P','ISSQN  NOVA MUTUM',208.50,'2018-10-09 18:18:40','2018-10-22 12:41:22',NULL,1,'2018-10-31'),(51,5,9,1,'D','P','DAM LRV',646.89,'2018-10-09 18:27:31','2018-10-22 12:46:35',NULL,1,'2018-10-22'),(52,22,9,1,'D','P','PIS',184.02,'2018-10-09 18:36:16','2018-10-22 12:56:01',NULL,1,'2018-10-25'),(53,22,9,1,'D','P','CONFINS',849.30,'2018-10-09 18:43:11','2018-10-22 12:21:50',NULL,1,'2018-10-25'),(54,9,12,1,'D','P','REFERENTE A NOTA Nº 82678',1161.20,'2018-10-09 19:08:50','2018-10-16 10:58:49',NULL,1,'2018-10-14'),(55,30,42,1,'D','P','NET DO RECREIO PENDENTE. paguei esta e outra de 13,00',243.99,'2018-10-09 20:00:21','2018-10-09 20:01:31',NULL,1,'2018-10-09'),(56,31,33,1,'D','P','CONTA VIVO',69.99,'2018-10-09 21:13:36','2018-10-09 21:14:22',NULL,1,'2018-10-10'),(57,2,4,1,'D','P','RUA ANGELO DAL ALBA',32.91,'2018-10-09 21:23:44','2018-10-09 21:24:36',NULL,1,'2018-09-20'),(58,2,4,1,'D','P','RUA EQUADOR',111.86,'2018-10-09 21:28:58','2018-10-09 21:29:27',NULL,1,'2018-09-28'),(59,13,17,1,'D','P','COLEGIO ÍTALO',1222.00,'2018-10-10 12:16:48','2018-10-10 12:17:35',NULL,1,'2018-10-01'),(60,32,44,1,'D','P','PRESTAÇÃO CASA LRV',3835.67,'2018-10-10 12:58:14','2018-10-10 12:59:08',NULL,1,'2018-10-11'),(61,33,8,2,'D','P','TRANSFERENCIA REALIZADA NO NOME DE ROSMARI SALVI',1500.00,'2018-10-10 18:05:38','2018-10-10 18:06:11',NULL,1,'2018-10-04'),(62,12,16,2,'D','P','TRANSFERENCIA REALIZADA EM NOME DE SANDRA DA LUZ',4850.00,'2018-10-10 18:19:19','2018-10-10 18:19:55',NULL,1,'2018-10-03'),(63,33,45,2,'D','P','DESCONTAR 250,00 REFERENTE AO BOLETO DA WIZARD',1450.00,'2018-10-10 19:14:40','2018-10-15 19:39:37',NULL,1,'2018-10-12'),(64,1,30,1,'D','P','RENOVAÇÃO DE LOCAÇÃO DE 01- CILINDRO DE 20L OXIGENIO',70.00,'2018-10-10 20:48:22','2018-10-16 12:14:08',NULL,1,'2018-10-15'),(65,13,17,1,'D','P','RESERVA DE VAGA',416.67,'2018-10-10 21:16:25','2018-10-16 10:43:19',NULL,1,'2018-10-10'),(66,13,17,1,'D','AP','RESERVA DE VAGA 2',416.67,'2018-10-10 21:18:55','2018-10-10 21:19:40',NULL,1,'2018-11-12'),(67,13,17,1,'D','AP','RESERVA DE VAGA 3',416.67,'2018-10-10 21:20:45','2018-10-10 21:21:12',NULL,1,'2018-12-10'),(68,15,46,9,'R','P','CURSO DE CIRURGIA',4500.00,'2018-10-10 21:34:26','2018-10-11 15:30:30','2018-10-11 15:30:30',1,'2018-06-25'),(69,9,12,1,'D','P','referente a nota nº 83060',115.00,'2018-10-11 12:17:42','2018-10-22 13:35:26',NULL,1,'2018-10-20'),(70,35,47,1,'D','AP','ANADEM MES OUTUBRO',572.12,'2018-10-11 12:55:00','2018-10-11 13:56:25','2018-10-11 13:56:25',1,'2018-10-20'),(71,37,47,1,'D','AP','BENEFIC - MEDICOS SEM FRONTEIRAS',45.00,'2018-10-11 13:00:19','2018-10-11 13:25:34','2018-10-11 13:25:34',1,'2018-10-15'),(72,35,49,1,'D','P','ANADEM',572.12,'2018-10-11 14:06:39','2018-10-22 13:38:35',NULL,1,'2018-10-20'),(73,15,50,9,'R','P','NOTAS FISCAIS REFERENTE AO CURSO DE CIRURGIA DERMATOLOGICA',4500.00,'2018-10-11 15:21:22','2018-10-11 15:23:20',NULL,1,'2018-06-16'),(74,15,46,9,'R','P','NOTAS REFERENTE AO CURSO DE CIRURGIA',4500.00,'2018-10-11 15:33:00','2018-10-11 17:51:21',NULL,1,'2018-06-25'),(75,15,51,9,'R','P','NOTA REFERENTE AO CURSO DE CIRURGIA',4500.00,'2018-10-11 18:11:51','2018-10-11 18:12:24',NULL,1,'2018-08-29'),(76,15,52,9,'R','P','NOTAS REFERENTE AO CURSO DE CIRURGIA',2400.00,'2018-10-11 18:24:26','2018-10-11 18:24:56',NULL,1,'2018-06-25'),(77,15,53,9,'R','P','NOTA REFERENTE AO CURSO DE CIRURGIA',4500.00,'2018-10-11 18:58:23','2018-10-11 18:59:07',NULL,1,'2018-06-08'),(78,15,54,9,'R','P','CURSO DE CIRURGIA',2400.00,'2018-10-11 19:02:37','2018-10-11 19:03:13',NULL,1,'2018-08-01'),(79,14,55,9,'R','P','CURSO DE CIRURGIA',1960.00,'2018-10-11 19:07:20','2018-10-11 19:07:49',NULL,1,'2018-07-31'),(80,14,56,9,'R','P','CURSO DE CIRURGIA',2400.00,'2018-10-11 19:13:06','2018-10-11 19:13:35',NULL,1,'2018-07-31'),(81,15,57,9,'R','P','CURSO DE CIRURGIA',4500.00,'2018-10-11 19:16:16','2018-10-11 20:41:11','2018-10-11 20:41:11',1,'2018-08-01'),(82,15,58,9,'R','P','CURSO DE CIRURGIA',2400.00,'2018-10-11 19:20:52','2018-10-11 19:21:58',NULL,1,'2018-08-01'),(83,15,59,9,'R','P','CURSO DE CIRURGIA',2400.00,'2018-10-11 19:25:17','2018-10-11 19:25:43',NULL,1,'2018-08-01'),(84,15,60,9,'R','P','CURSO DE CIRURGIA',2400.00,'2018-10-11 19:28:11','2018-10-11 19:28:44',NULL,1,'2018-08-01'),(85,14,61,9,'R','P','CURSO DE CIRURGIA',2400.00,'2018-10-11 19:34:51','2018-10-11 19:36:00',NULL,1,'2018-06-25'),(86,15,62,9,'R','P','CURSO DE CIRURGIA',2400.00,'2018-10-11 19:38:18','2018-10-11 19:38:43',NULL,1,'2018-08-01'),(87,15,63,9,'R','P','CURSO DE CIRURGIA',4500.00,'2018-10-11 19:41:30','2018-10-11 19:42:11',NULL,1,'2018-08-01'),(88,15,64,9,'R','P','CURSO DE CIRURGIA',12000.00,'2018-10-11 19:46:33','2018-10-11 19:47:01',NULL,1,'2018-08-15'),(89,13,65,2,'D','P','TROCA DE OLEO',777.00,'2018-10-11 20:44:51','2018-10-11 20:45:15',NULL,1,'2018-10-04'),(90,9,66,2,'D','P','COMPROVANTE TIJOLO OBRA',81.50,'2018-10-11 20:48:46','2018-10-11 20:49:23',NULL,1,'2018-10-11'),(91,38,67,6,'D','P','Parcela 2 de acordo judicial do Roosevelt Pai',8000.00,'2018-10-15 11:52:20','2018-10-15 11:53:16',NULL,1,'2018-10-15'),(92,9,68,1,'D','P','REFERENTE AO PEDIDO 1.762.640',336.75,'2018-10-15 18:07:36','2018-10-22 12:53:26',NULL,1,'2018-10-21'),(93,9,12,1,'D','P','REFERENTE A NOTA Nº 182524 - 83167 - 230288',930.00,'2018-10-15 18:13:37','2018-10-22 13:39:47',NULL,1,'2018-10-21'),(94,9,12,1,'D','P','REFERENTE A NOTA Nº 83130',16.00,'2018-10-15 18:18:33','2018-10-22 13:40:07',NULL,1,'2018-10-21'),(95,12,15,1,'D','P','HONORARIOS MES 09/2018',450.00,'2018-10-15 18:27:50','2018-10-16 12:20:40',NULL,1,'2018-10-20'),(96,2,6,1,'D','P','ENERGIA CASA',182.17,'2018-10-16 11:45:25','2018-10-16 11:46:05',NULL,1,'2018-10-15'),(97,9,12,1,'D','P','REFERENTE A NOTA FISCAL 230478',220.00,'2018-10-16 14:17:05','2018-10-22 13:40:33',NULL,1,'2018-10-25'),(98,9,12,1,'D','P','REFERENTE A NOTA Nº 83454',175.00,'2018-10-17 18:45:15','2018-10-22 13:41:09',NULL,1,'2018-10-27'),(99,9,12,1,'D','P','REFERENTE AO PEDIDO Nº 1.766.111',64.30,'2018-10-17 18:47:39','2018-10-22 13:41:57',NULL,1,'2018-10-27'),(100,2,4,1,'D','P','RUA EQUADOR, REFERENTE AO CANCELAMENTO',158.40,'2018-10-17 20:45:43','2018-10-22 13:50:54',NULL,1,'2018-10-28'),(101,2,4,1,'D','P','RUA CATUIPE',19.46,'2018-10-17 20:47:03','2018-10-22 13:53:31',NULL,1,'2018-10-16'),(102,2,4,1,'D','AP','RUA ESPUMOSO',32.83,'2018-10-17 20:48:26','2018-10-17 20:48:55',NULL,1,'2018-11-13'),(103,22,9,8,'D','AP','REFERENTE AO PARCELAMENTO DO MES 08/2018 VALIDO PARA PAGAMENTO ATE O DIA 31/10/2018',578.11,'2018-10-18 12:18:04','2018-10-18 12:24:56','2018-10-18 12:24:56',1,'2018-10-31'),(104,22,9,8,'D','AP','PARCELAMENTO MES 10/2018',578.11,'2018-10-18 12:22:41','2018-10-18 12:25:42','2018-10-18 12:25:42',0,'2018-10-31'),(105,22,9,8,'D','P','REFERENTE AO MES 08/2018 COM PAGAMENTO VALIDO ATE 31/10/2018',578.11,'2018-10-18 13:56:50','2018-10-22 14:30:08',NULL,1,'2018-10-31'),(106,22,9,8,'D','P','VALIDO PARA PAGAMENTO ATE 31/10/2018',578.11,'2018-10-18 14:00:17','2018-10-22 14:34:02',NULL,1,'2018-10-31'),(107,9,12,1,'D','P','REFERENTE A NOTA Nº 230818',225.00,'2018-10-18 21:05:03','2018-10-22 13:42:31',NULL,1,'2018-10-22'),(108,3,3,1,'D','P','ADBAZE ALUGUEL',6397.00,'2018-10-18 21:08:00','2018-10-22 12:24:10',NULL,1,'2018-11-05'),(109,9,12,1,'D','P','REFERENTE AO PEDIDO Nº 1.767.435',892.00,'2018-10-19 14:13:01','2018-10-22 13:43:21',NULL,1,'2018-10-28'),(110,29,42,1,'D','AP','MINHA NET SP',147.99,'2018-10-19 14:17:18','2018-10-19 14:23:38',NULL,1,'2018-11-05'),(111,9,12,1,'D','P','REFERENTE A NOTA Nº 83528',119.60,'2018-10-19 19:59:28','2018-10-22 13:44:08',NULL,1,'2018-10-28'),(112,9,12,1,'D','P','REFERENTE A NOTA Nº 83665',130.00,'2018-10-22 12:04:56','2018-10-22 13:45:35',NULL,1,'2018-10-29'),(113,24,33,1,'D','AP','PARCELA 12 DE 12',143.12,'2018-10-22 12:45:49','2018-10-22 13:12:22',NULL,1,'2019-01-21'),(114,22,10,1,'D','P','CSLL referente ao 2º Trimestre/2018  recalculado para pagamento até 26/10/2018',616.83,'2018-10-22 14:34:38','2018-10-22 14:41:06',NULL,1,'2018-10-26'),(115,22,10,8,'D','P','PAGAMENTO ATÉ DIA 31/10',616.83,'2018-10-22 14:36:44','2018-10-22 14:41:45','2018-10-22 14:41:45',0,'2018-10-22'),(116,13,17,1,'D','AP','REFERENTE A MENSALIDADE',1222.00,'2018-10-22 14:40:49','2018-10-22 14:45:55',NULL,1,'2018-11-01'),(117,29,42,1,'D','AP','FATURA MÊS NOVEMBRO',147.99,'2018-10-22 14:47:35','2018-10-22 14:50:27','2018-10-22 14:50:27',0,'2018-11-05'),(118,22,9,1,'D','AP','CSLL',7210.08,'2018-10-23 19:58:24','2018-10-23 19:58:24',NULL,1,'2018-10-31'),(119,22,9,1,'D','AP','IRPJ',14028.00,'2018-10-23 20:08:15','2018-10-23 20:08:15',NULL,1,'2018-10-31'),(120,9,12,1,'D','AP','BOLETO REFERENTE A NOTA Nº 83886',135.90,'2018-10-23 20:26:02','2018-10-23 20:27:06',NULL,1,'2018-11-02'),(121,9,12,1,'D','AP','REFERENTE A NOTA Nº84029',54.50,'2018-10-25 14:50:20','2018-10-25 14:51:07',NULL,1,'2018-11-03'),(122,9,12,1,'D','AP','REFERENTE A NOTA Nº 231681',200.00,'2018-10-25 14:52:32','2018-10-25 14:53:04',NULL,1,'2018-11-03'),(123,39,69,1,'D','AP','CONTA FOI ENTREGUE DIA 24/10/2018 PELO CORREIO JA COM ATRASO',156.13,'2018-10-25 15:02:53','2018-10-25 15:04:12',NULL,1,'2018-10-14'),(124,31,47,1,'D','AP','INTERNET E TV POR ASSINATURA',190.54,'2018-10-25 15:07:18','2018-10-25 15:08:03',NULL,1,'2018-11-05'),(125,9,12,1,'D','AP','Referente ao pedido nº 1.772.723',607.90,'2018-10-25 18:04:46','2018-10-25 18:05:13',NULL,1,'2018-11-03'),(126,27,41,1,'D','AP','COLETA LRV',52.63,'2018-10-25 21:30:43','2018-10-25 21:32:06',NULL,1,'2018-11-15'),(127,3,29,1,'D','AP','LELLO LOCAÇÃO',5034.55,'2018-10-26 12:27:39','2018-10-26 12:28:14',NULL,1,'2018-11-07'),(128,6,8,1,'D','AP','FGTS',280.00,'2018-10-26 14:36:44','2018-10-26 14:37:27','2018-10-26 14:37:27',1,'2018-11-07'),(129,33,8,2,'D','AP','RECIBO DE SALARIO',1500.00,'2018-10-26 14:43:43','2018-10-26 14:45:03',NULL,1,'2018-11-05'),(130,25,9,1,'D','AP','OUTUBRO/2018',280.00,'2018-10-26 14:47:05','2018-10-26 14:47:45',NULL,1,'2018-11-07');

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `category` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` VALUES (1,'Insumos','2018-09-19 14:24:51','2018-09-19 14:24:51',NULL),(2,'Energia/ Agua','2018-09-19 14:25:05','2018-09-19 14:25:05',NULL),(3,'aluguel','2018-09-19 14:30:47','2018-09-19 14:30:47',NULL),(4,'DAM MUTUM','2018-09-19 15:06:46','2018-09-19 15:07:12',NULL),(5,'DAM LRV','2018-09-19 15:08:26','2018-09-19 15:08:26',NULL),(6,'E-SOCIAL','2018-09-19 15:08:50','2018-09-19 15:08:50',NULL),(7,'IMPOSTO SP','2018-09-19 15:18:59','2018-09-19 15:18:59',NULL),(8,'Preenchimento','2018-09-19 15:35:47','2018-09-19 15:35:47',NULL),(9,'OBRA','2018-09-26 14:09:22','2018-09-26 14:09:22',NULL),(10,'Imposto RJ','2018-09-28 13:35:13','2018-09-28 13:35:13',NULL),(11,'Material construção Clinica LRV','2018-09-28 13:35:34','2018-09-28 13:35:34',NULL),(12,'Honorarios e Servicos','2018-09-28 13:37:00','2018-09-28 13:37:00',NULL),(13,'Despesa pessoal','2018-09-28 13:40:25','2018-09-28 13:40:25',NULL),(14,'Aluno SP','2018-09-28 13:41:57','2018-09-28 13:41:57',NULL),(15,'Aluno Rio','2018-09-28 13:42:09','2018-09-28 13:42:09',NULL),(16,'Aluno Workshop','2018-09-28 13:42:21','2018-09-28 13:42:21',NULL),(17,'CRM','2018-09-28 13:45:23','2018-09-28 13:45:23',NULL),(18,'Cond. Club Moema','2018-09-28 17:27:29','2018-09-28 17:27:29',NULL),(19,'ISSQN LRV','2018-09-28 18:00:33','2018-09-28 18:00:53','2018-09-28 18:00:53'),(20,'IMPOSTO ISSQN LRV','2018-09-28 18:01:07','2018-09-28 18:01:07',NULL),(21,'CONFINS LRV','2018-09-28 18:12:46','2018-09-28 18:12:46',NULL),(22,'DARF','2018-09-28 18:30:55','2018-09-28 18:30:55',NULL),(23,'OXIGENIO SP','2018-09-28 19:34:10','2018-09-28 19:34:10',NULL),(24,'DAM - MAIARA','2018-09-28 20:15:13','2018-09-28 20:15:13',NULL),(25,'FGTS','2018-10-03 18:06:20','2018-10-03 18:06:20',NULL),(26,'Hidoctor','2018-10-03 19:12:22','2018-10-03 19:12:22',NULL),(27,'Coleta','2018-10-03 21:32:58','2018-10-03 21:32:58',NULL),(28,'GPS','2018-10-04 14:30:04','2018-10-04 14:30:04',NULL),(29,'INTERNET SP','2018-10-09 14:58:47','2018-10-09 14:58:47',NULL),(30,'MINHA NET RIO RECREIO','2018-10-09 19:57:56','2018-10-09 19:57:56',NULL),(31,'TELEFONE VIVO','2018-10-09 21:12:48','2018-10-09 21:12:48',NULL),(32,'PRESTAÇÃO CASA','2018-10-10 12:54:20','2018-10-10 12:54:20',NULL),(33,'SALARIO','2018-10-10 18:04:05','2018-10-10 18:04:05',NULL),(34,'ANADEM','2018-10-11 12:50:54','2018-10-11 12:51:52','2018-10-11 12:51:52'),(35,'ANADEM','2018-10-11 12:52:30','2018-10-11 12:52:30',NULL),(36,'BENEFIC - MEDICOS SEM FRONTEIRAS','2018-10-11 12:57:26','2018-10-11 12:59:16','2018-10-11 12:59:16'),(37,'MEDICOS SEM FRONTEIRAS','2018-10-11 12:59:29','2018-10-11 12:59:29',NULL),(38,'Familia Roosevelt','2018-10-15 11:41:22','2018-10-15 11:41:22',NULL),(39,'TELEFONE FIXO','2018-10-25 15:01:21','2018-10-25 15:01:21',NULL);

--
-- Table structure for table `companies`
--

CREATE TABLE `companies` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(10) unsigned NOT NULL,
  `type` enum('C','F') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'C',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `companies_category_id_foreign` (`category_id`),
  CONSTRAINT `companies_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `companies`
--

INSERT INTO `companies` VALUES (1,1,'F','Dihol','2018-09-19 14:25:28','2018-09-19 14:26:16',NULL),(2,1,'F','JNS Millenium RJ','2018-09-19 14:26:06','2018-09-19 14:26:06',NULL),(3,3,'F','aluguel RJ','2018-09-19 14:31:17','2018-09-19 14:31:17',NULL),(4,2,'F','ENERGISA','2018-09-19 15:05:41','2018-09-19 15:05:41',NULL),(5,2,'F','LIGHT ENERGIA RJ','2018-09-19 15:06:00','2018-09-19 15:06:00',NULL),(6,2,'F','ELETROPAULO ENERGIA SP','2018-09-19 15:06:22','2018-09-19 15:06:22',NULL),(7,4,'F','IMPOSTO MUTUM','2018-09-19 15:07:58','2018-09-19 15:07:58',NULL),(8,6,'F','Tania BABA','2018-09-19 15:09:07','2018-09-19 15:09:07',NULL),(9,5,'F','IMPOSTO LRV','2018-09-19 15:18:42','2018-09-19 15:18:42',NULL),(10,7,'F','IMPOSTOS SP','2018-09-19 15:19:15','2018-09-19 15:19:15',NULL),(11,8,'F','GB DISTRIBUID','2018-09-19 15:36:12','2018-09-19 15:36:12',NULL),(12,9,'F','Paraná Mat. de Construção','2018-09-26 14:10:34','2018-09-26 14:10:34',NULL),(13,11,'F','Parana materiais construcao','2018-09-28 13:36:06','2018-09-28 13:36:06',NULL),(14,12,'F','Multicom','2018-09-28 13:37:20','2018-09-28 13:37:20',NULL),(15,12,'F','Contador SP','2018-09-28 13:37:47','2018-09-28 13:37:47',NULL),(16,12,'F','Maninho gesso','2018-09-28 13:38:10','2018-09-28 13:38:10',NULL),(17,13,'F','Escola otavio','2018-09-28 13:40:46','2018-09-28 13:40:46',NULL),(18,13,'F','Mercado','2018-09-28 13:41:02','2018-09-28 13:41:02',NULL),(19,13,'F','Passagem','2018-09-28 13:41:29','2018-09-28 13:41:29',NULL),(20,1,'F','Mercado livre','2018-09-28 13:43:00','2018-09-28 13:43:00',NULL),(21,1,'F','Dysport','2018-09-28 13:43:26','2018-09-28 13:43:26',NULL),(22,1,'F','Magazine medica','2018-09-28 13:43:48','2018-09-28 13:43:48',NULL),(23,1,'F','Rhosse','2018-09-28 13:44:01','2018-09-28 13:44:01',NULL),(24,1,'F','Richter','2018-09-28 13:44:17','2018-09-28 13:44:17',NULL),(25,13,'F','IPVA','2018-09-28 13:44:47','2018-09-28 13:44:47',NULL),(26,17,'F','CREMERJ','2018-09-28 13:45:53','2018-09-28 13:45:53',NULL),(27,17,'F','CREMESP','2018-09-28 13:46:11','2018-09-28 13:46:11',NULL),(28,17,'F','CRM MT','2018-09-28 13:46:30','2018-09-28 13:46:30',NULL),(29,3,'F','ALUGUEL SP','2018-09-28 13:56:05','2018-09-28 13:56:05',NULL),(30,1,'F','Oxigênio Medicinal Life','2018-09-28 17:26:47','2018-09-28 17:26:47',NULL),(31,18,'F','Condomínio CCM','2018-09-28 17:27:51','2018-09-28 17:28:45',NULL),(32,18,'C','Aluguel CCM','2018-09-28 17:28:19','2018-09-28 17:28:19',NULL),(33,24,'F','MAIARA F. CAMPAGNARO','2018-09-28 20:15:48','2018-09-28 20:15:48',NULL),(34,6,'F','RECEITA FEDERAL','2018-10-03 18:08:35','2018-10-03 18:08:35',NULL),(35,26,'F','Centralx','2018-10-03 19:12:52','2018-10-03 19:12:52',NULL),(36,27,'F','RESIDUOALL DE COPACABANA','2018-10-03 21:33:33','2018-10-03 21:33:33',NULL),(37,14,'C','NFSe','2018-10-08 20:38:10','2018-10-08 20:38:10',NULL),(38,14,'C','LOUISE LEAL (ALUNA)','2018-10-08 21:28:55','2018-10-08 21:28:55',NULL),(39,14,'C','FERNANDA MENEZES (aluna)','2018-10-08 21:31:38','2018-10-08 21:31:38',NULL),(40,1,'F','VYDENCE MEDICAL','2018-10-09 14:04:53','2018-10-09 14:04:53',NULL),(41,27,'F','BIO RESIDUO LRV','2018-10-09 14:52:18','2018-10-09 14:52:18',NULL),(42,29,'F','MINHA NET','2018-10-09 14:59:07','2018-10-09 14:59:07',NULL),(43,2,'F','SAAE','2018-10-09 15:33:55','2018-10-09 15:33:55',NULL),(44,32,'F','CAIXA ECONOMICA','2018-10-10 12:54:49','2018-10-10 12:54:49',NULL),(45,33,'F','Edirvania secretaria','2018-10-10 19:12:36','2018-10-10 19:12:36',NULL),(46,15,'C','ANA LUCIA T. DE A. BRUNO','2018-10-10 21:13:46','2018-10-10 21:13:46',NULL),(47,35,'C','Roosevelt das neves rocha filho','2018-10-11 12:52:53','2018-10-11 12:52:53',NULL),(48,35,'C','SEGURO','2018-10-11 14:05:14','2018-10-11 14:05:33','2018-10-11 14:05:33'),(49,35,'F','SEGURO','2018-10-11 14:05:55','2018-10-11 14:05:55',NULL),(50,15,'C','Cyntia Virginia S. Sardenberg','2018-10-11 15:19:56','2018-10-11 15:19:56',NULL),(51,15,'C','Maria Clara Costa e Paula','2018-10-11 18:10:59','2018-10-11 18:10:59',NULL),(52,15,'C','Thais Dias T. G. M. Batista','2018-10-11 18:23:30','2018-10-11 18:23:30',NULL),(53,15,'C','Ticiano Rossi','2018-10-11 18:57:23','2018-10-11 18:57:23',NULL),(54,15,'C','Maria Gertrudes Fernandes P. Neugebauer','2018-10-11 19:01:32','2018-10-11 19:01:32',NULL),(55,14,'C','Maria Silvia Kós Canetti','2018-10-11 19:06:09','2018-10-11 19:06:09',NULL),(56,14,'C','Fernanda Queiroz de Oliveira','2018-10-11 19:08:45','2018-10-11 19:08:45',NULL),(57,15,'C','Samira Oliveira Silveira','2018-10-11 19:15:27','2018-10-11 19:15:27',NULL),(58,15,'C','Fernanda Lorenski','2018-10-11 19:20:01','2018-10-11 19:20:01',NULL),(59,15,'C','Josiane de M. R. Cardoso','2018-10-11 19:24:18','2018-10-11 19:24:18',NULL),(60,15,'C','Klicia Novais','2018-10-11 19:27:29','2018-10-11 19:27:29',NULL),(61,14,'C','Nage Mounzer','2018-10-11 19:34:10','2018-10-11 19:34:10',NULL),(62,15,'C','Liliane Fae da Silva Felippi','2018-10-11 19:37:06','2018-10-11 19:37:06',NULL),(63,15,'C','Livia Tomaz Pereira','2018-10-11 19:39:51','2018-10-11 19:39:51',NULL),(64,15,'C','Fernanda Cação Briso','2018-10-11 19:45:04','2018-10-11 19:45:04',NULL),(65,13,'F','CARRO','2018-10-11 20:43:41','2018-10-11 20:47:53',NULL),(66,9,'F','Vilmar Lorini ME','2018-10-11 20:46:50','2018-10-11 20:46:50',NULL),(67,38,'F','Deposito Judicial','2018-10-15 11:41:59','2018-10-15 11:41:59',NULL),(68,9,'F','ARQUITETO HOME','2018-10-15 18:05:52','2018-10-15 18:05:52',NULL),(69,39,'F','OI FIXO LRV','2018-10-25 15:01:48','2018-10-25 15:01:48',NULL);

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

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

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

INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2018_09_11_005725_create_table_profiles',1),(4,'2018_09_11_005845_add_column_profile_id_users',1),(5,'2018_09_11_103046_create_categories_table',1),(6,'2018_09_12_104154_create_companies_table',1),(7,'2018_09_12_104155_create_accounts_table',1),(8,'2018_09_12_114010_add_column_soft_delete_users',1),(9,'2018_09_12_114445_add_column_soft_delete_companies',1),(10,'2018_09_12_115330_add_column_soft_delete_nota_fiscal_accounts',1),(11,'2018_09_16_201943_add_column_soft_delete_categories',1),(12,'2018_09_16_213928_create_table_accounts_files',1),(13,'2018_09_17_000207_create_payment_methods_table',1),(14,'2018_09_17_002021_add_column_payment_method_account',1);

--
-- Table structure for table `payment_methods`
--

CREATE TABLE `payment_methods` (
  `id` int(10) 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`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_methods`
--

INSERT INTO `payment_methods` VALUES (1,'Boleto unicred',NULL,'2018-09-19 14:32:27','2018-09-19 14:34:52'),(2,'Transferencia Unicred',NULL,'2018-09-19 14:32:38','2018-09-19 14:33:54'),(3,'Deposito',NULL,'2018-09-19 14:32:47','2018-09-19 14:32:47'),(4,'Cartao VISA BRADESCO',NULL,'2018-09-19 14:33:04','2018-09-19 14:33:04'),(5,'Cartao santander credito',NULL,'2018-09-19 14:33:23','2018-09-19 14:33:23'),(6,'TED UNICRED',NULL,'2018-09-19 14:33:35','2018-09-19 14:33:35'),(7,'Transferencia CAIXA ECON.',NULL,'2018-09-19 14:34:08','2018-09-19 14:34:32'),(8,'C/P Caixa Econômica',NULL,'2018-09-19 14:35:06','2018-09-26 14:07:29'),(9,'BOLETO',NULL,'2018-10-08 21:07:25','2018-10-08 21:07:25');

--
-- Table structure for table `profiles`
--

CREATE TABLE `profiles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `profile` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `profiles`
--

INSERT INTO `profiles` VALUES (1,'Administrador'),(2,'Gestor de contas');


