--
-- Host: dev_rotary.mysql.dbaas.com.br    Database: dev_rotary
-- ------------------------------------------------------

/*!50717 SELECT COUNT(*) INTO @rocksdb_has_p_s_session_variables FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'performance_schema' AND TABLE_NAME = 'session_variables' */;
/*!50717 PREPARE s FROM @rocksdb_get_is_supported */;
/*!50717 EXECUTE s */;
/*!50717 DEALLOCATE PREPARE s */;
/*!50717 PREPARE s FROM @rocksdb_enable_bulk_load */;
/*!50717 EXECUTE s */;
/*!50717 DEALLOCATE PREPARE s */;

--
-- Current Database: `dev_rotary`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `dev_rotary` /*!40100 DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci */;

USE `dev_rotary`;

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

CREATE TABLE `categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `categories` VALUES (1,'eventos','Eventos','2022-08-05 17:25:21','2022-08-05 17:25:21'),(2,'projetos','Projetos','2022-08-05 17:25:21','2022-08-05 17:25:21'),(3,'noticias','Notícias','2022-08-19 16:02:26','2022-08-19 16:02:42');

--
-- Table structure for table `dependents`
--

CREATE TABLE `dependents` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `client_id` bigint(20) unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sex_id` bigint(20) unsigned NOT NULL,
  `birth_date` date NOT NULL,
  `peso` int(11) NOT NULL,
  `altura` int(11) NOT NULL,
  `relacao` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `dependents`
--

INSERT INTO `dependents` VALUES (1,1,'Jean Carlo de Carvalhjo',1,'1989-07-04',95,180,'filho','2022-07-22 05:35:44','2022-07-22 05:35:44'),(2,9,'Test 4',1,'1989-07-04',96,180,'filho','2022-07-22 17:37:31','2022-07-22 17:37:31'),(3,10,'Jose Maria',1,'2022-05-05',90,170,'Primo','2022-07-25 13:21:58','2022-07-25 13:21:58'),(4,1,'Dryelly Moraes de Almeida de Carvalho',2,'1991-12-09',75,173,'Tia','2022-07-25 14:11:35','2022-07-25 14:11:35'),(5,12,'Test',1,'2017-01-23',20,110,'filho','2022-07-27 02:20:13','2022-07-27 02:20:13'),(6,12,'Jean Carlo de Carvalho',1,'1989-07-04',95,180,'proprio','2022-07-27 02:20:45','2022-07-27 02:20:45'),(7,14,'Fulano de tal',1,'1979-09-02',70,2,'Amigo','2022-08-02 01:56:40','2022-08-02 01:56:40'),(8,15,'Joaquim',1,'2017-01-23',20,115,'filho','2022-08-06 00:16:06','2022-08-06 00:16:06'),(9,16,'José Teste',1,'2001-01-01',90,170,'Primo','2022-08-22 21:43:21','2022-08-22 21:43:21'),(10,15,'Jean Carlo de Carvalho',1,'1989-04-07',90,180,'eu','2022-08-23 00:55:19','2022-08-23 00:55:19');

--
-- Table structure for table `equipment`
--

CREATE TABLE `equipment` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `provider_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `provider_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `provider_cnpj` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dt_acquisition` timestamp NULL DEFAULT NULL,
  `vl_acquisition` double(8,2) DEFAULT NULL,
  `type_of_equipment_id` bigint(20) unsigned NOT NULL,
  `status_equipment_id` bigint(20) unsigned NOT NULL,
  `origin_equipment_id` bigint(20) unsigned DEFAULT NULL,
  `status_initial_equipment_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `equipment`
--

INSERT INTO `equipment` VALUES (12,'Cadeira de Rodas','04-0001',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,'2022-07-22 02:35:27','2022-08-23 00:18:37'),(14,'Cadeira de Banho','05-0001',NULL,NULL,NULL,NULL,NULL,5,1,NULL,NULL,'2022-07-27 01:38:48','2022-08-31 04:28:25'),(16,'Cadeira de Rodas','04-0002',NULL,NULL,NULL,NULL,NULL,1,2,NULL,NULL,'2022-08-06 00:20:04','2022-08-31 02:57:55'),(17,'Cama Hospitalar','06-0001',NULL,NULL,NULL,NULL,NULL,2,1,NULL,NULL,'2022-08-06 00:20:34','2022-08-23 00:20:06'),(18,'Andador','01-0001',NULL,NULL,NULL,NULL,NULL,3,1,NULL,NULL,'2022-08-06 00:23:39','2022-08-23 00:14:42'),(19,'BOTA ORTOPEDICA','03-0001',NULL,NULL,NULL,NULL,NULL,15,2,NULL,NULL,'2022-08-06 00:39:26','2022-08-30 02:56:08'),(20,'Cadeira de Rodas','04-0003',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,'2022-08-22 21:29:48','2022-08-23 00:19:16'),(21,'Bota Ortopédica Teste','03-0002','Josué','50 Rua 1150','03875334191',NULL,NULL,15,1,NULL,NULL,'2022-08-22 22:07:08','2022-08-23 00:35:56'),(22,'Cama Hospitalar','06-0004',NULL,NULL,NULL,NULL,NULL,2,1,NULL,NULL,'2022-08-22 22:59:14','2022-08-23 00:25:28'),(23,'Cama Hospitalar Teste 123','06-0005',NULL,NULL,NULL,NULL,NULL,2,1,NULL,NULL,'2022-08-22 23:13:51','2022-08-23 01:08:01'),(24,'Cama Hospitalar','06-0003',NULL,NULL,NULL,NULL,NULL,2,1,NULL,NULL,'2022-08-22 23:15:50','2022-08-23 00:20:44'),(25,'Cama Hospilarar','06-0002',NULL,NULL,NULL,NULL,NULL,2,1,NULL,NULL,'2022-08-23 00:03:20','2022-08-23 00:26:29'),(26,'Colchão Ortopédico','07-0001',NULL,NULL,NULL,NULL,NULL,16,1,NULL,NULL,'2022-08-24 14:07:59','2022-08-24 14:07:59'),(27,'Muletas Axilares','08-0001',NULL,NULL,NULL,NULL,NULL,18,1,NULL,NULL,'2022-08-24 14:08:38','2022-08-24 14:08:38'),(28,'Muletas Canadenses','09-0001',NULL,NULL,NULL,NULL,NULL,14,2,NULL,NULL,'2022-08-24 14:09:17','2022-08-29 15:00:16'),(29,'Bengala','02-0001',NULL,NULL,NULL,NULL,NULL,17,2,NULL,NULL,'2022-08-24 14:19:39','2022-08-31 13:28:51');

--
-- Table structure for table `equipment_file`
--

CREATE TABLE `equipment_file` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `equipment_id` bigint(20) unsigned NOT NULL,
  `file_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `equipment_file`
--


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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) 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 `files`
--

CREATE TABLE `files` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `path` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `files`
--

INSERT INTO `files` VALUES (1,'public/contents/H22XEdTKIp5Z7KkEYtu756fkGUJbqGf4Mdp7Gx9d.jpg','2022-07-06 22:02:56','2022-07-06 22:02:56'),(2,'public/contents/KyE6IWMfQcVRneRoYn6XuUyQSHjt5ra5mT0P5gBF.jpg','2022-07-06 22:03:27','2022-07-06 22:03:27'),(3,'public/contents/zLLlPjRY1u358LuuLmjmcp4b1C1oYBWKpzZkzdDc.jpg','2022-07-06 22:08:37','2022-07-06 22:08:37'),(4,'public/contents/oLMt9GyVmc3EEhDcQt1dhnFro0LFhwpoUk3EFFMq.jpg','2022-07-06 22:08:56','2022-07-06 22:08:56'),(5,'contents/1657135062ffe2ee6da3c08b99cb352c857157db8a.jpg','2022-07-06 22:17:42','2022-07-06 22:17:42'),(6,'contents/1657135153f42f168a1c85dff6b1389d3df7e31e15.jpg','2022-07-06 22:19:13','2022-07-06 22:19:13'),(7,'contents/16571352499044c3810669c82cba09bd627ebc1d55.jpg','2022-07-06 22:20:49','2022-07-06 22:20:49'),(8,'contents/1657135267cd57a5dcc4e167129469befed5f4f1c3.jpg','2022-07-06 22:21:07','2022-07-06 22:21:07'),(9,'contents/1657135300cd57a5dcc4e167129469befed5f4f1c3.jpg','2022-07-06 22:21:40','2022-07-06 22:21:40'),(10,'contents/1657135423cd57a5dcc4e167129469befed5f4f1c3.jpg','2022-07-06 22:23:43','2022-07-06 22:23:43'),(11,'contents/1657136550ffe2ee6da3c08b99cb352c857157db8a.jpg','2022-07-06 22:42:30','2022-07-06 22:42:30'),(12,'contents/1657136560f42f168a1c85dff6b1389d3df7e31e15.jpg','2022-07-06 22:42:40','2022-07-06 22:42:40'),(13,'contents/16571368259044c3810669c82cba09bd627ebc1d55.jpg','2022-07-06 22:47:05','2022-07-06 22:47:05'),(14,'contents/1657162404f42f168a1c85dff6b1389d3df7e31e15.jpg','2022-07-07 05:53:24','2022-07-07 05:53:24'),(15,'contents/1657235670ffe2ee6da3c08b99cb352c857157db8a.jpg','2022-07-08 02:14:30','2022-07-08 02:14:30'),(16,'contents/1657235679f42f168a1c85dff6b1389d3df7e31e15.jpg','2022-07-08 02:14:39','2022-07-08 02:14:39'),(17,'contents/16572356889044c3810669c82cba09bd627ebc1d55.jpg','2022-07-08 02:14:48','2022-07-08 02:14:48'),(18,'contents/1657235697ebc29180184e1eaafd0296ef84aa6f2f.jpg','2022-07-08 02:14:57','2022-07-08 02:14:57'),(19,'contents/1657235717cd57a5dcc4e167129469befed5f4f1c3.jpg','2022-07-08 02:15:17','2022-07-08 02:15:17'),(20,'contents/1658276258f42f168a1c85dff6b1389d3df7e31e15.jpg','2022-07-20 03:17:39','2022-07-20 03:17:39'),(21,'contents/16582768139044c3810669c82cba09bd627ebc1d55.jpg','2022-07-20 03:26:53','2022-07-20 03:26:53'),(22,'contents/16582768999044c3810669c82cba09bd627ebc1d55.jpg','2022-07-20 03:28:19','2022-07-20 03:28:19'),(23,'contents/1658402807logo_ca-removebg-preview.png','2022-07-21 14:26:47','2022-07-21 14:26:47'),(24,'contents/1658402989Logo_v.3.png','2022-07-21 14:29:49','2022-07-21 14:29:49'),(25,'contents/1658485704DSC_2746.JPG','2022-07-22 13:28:24','2022-07-22 13:28:24'),(26,'contents/1658489918cadeira_rodas.jpg','2022-07-22 14:38:38','2022-07-22 14:38:38'),(27,'contents/1658489928cama_hospitalar.jpeg','2022-07-22 14:38:48','2022-07-22 14:38:48'),(28,'contents/1658489943andador.jpg','2022-07-22 14:39:03','2022-07-22 14:39:03'),(29,'contents/1658489963cadeira_banho.jpeg','2022-07-22 14:39:23','2022-07-22 14:39:23'),(30,'contents/1658489974muletas.jpg','2022-07-22 14:39:34','2022-07-22 14:39:34'),(31,'contents/1658489983cadeira_rodas_infantil.jpg','2022-07-22 14:39:43','2022-07-22 14:39:43'),(32,'contents/1658501320cadeira_rodas.jpg','2022-07-22 17:48:40','2022-07-22 17:48:40'),(33,'contents/1658501334cama_hospitalar.jpeg','2022-07-22 17:48:54','2022-07-22 17:48:54'),(34,'contents/1658501344andador.jpg','2022-07-22 17:49:04','2022-07-22 17:49:04'),(35,'contents/1658501353cadeira_banho.jpeg','2022-07-22 17:49:13','2022-07-22 17:49:13'),(36,'contents/1658501364muletas.jpg','2022-07-22 17:49:24','2022-07-22 17:49:24'),(37,'contents/1658501385cadeira_rodas_infantil.jpg','2022-07-22 17:49:45','2022-07-22 17:49:45'),(38,'contents/1658501426andador.jpg','2022-07-22 17:50:26','2022-07-22 17:50:26'),(39,'contents/1658744059Imagem Bengala.jpg','2022-07-25 13:14:19','2022-07-25 13:14:19'),(40,'contents/16588766749044c3810669c82cba09bd627ebc1d55.jpg','2022-07-27 02:04:34','2022-07-27 02:04:34'),(41,'contents/1659558002muletas axilares.jpg','2022-08-03 23:20:02','2022-08-03 23:20:02'),(42,'contents/1659724744muleta_canadense.jpg','2022-08-05 21:39:04','2022-08-05 21:39:04'),(43,'contents/1659724755bota_ortopedica.jpg','2022-08-05 21:39:15','2022-08-05 21:39:15'),(44,'contents/1659724766bengala.jpg','2022-08-05 21:39:26','2022-08-05 21:39:26'),(45,'contents/1659724779muleta_axilar.jpg','2022-08-05 21:39:39','2022-08-05 21:39:39'),(46,'contents/1659724873colchao_ortopedico.jpg','2022-08-05 21:41:13','2022-08-05 21:41:13'),(47,'contents/1660884587cd57a5dcc4e167129469befed5f4f1c3.jpg','2022-08-19 07:49:47','2022-08-19 07:49:47'),(48,'contents/16609152909044c3810669c82cba09bd627ebc1d55.jpg','2022-08-19 16:21:30','2022-08-19 16:21:30'),(49,'contents/1660915478logo-sm.png','2022-08-19 16:24:38','2022-08-19 16:24:38'),(50,'contents/1660918344bota_ortopedica.jpg','2022-08-19 17:12:24','2022-08-19 17:12:24'),(51,'contents/1660918353cd57a5dcc4e167129469befed5f4f1c3.jpg','2022-08-19 17:12:33','2022-08-19 17:12:33'),(52,'contents/1660919320moto-01.jpeg','2022-08-19 17:28:40','2022-08-19 17:28:40'),(53,'contents/1660920014moto-01.jpeg','2022-08-19 17:40:14','2022-08-19 17:40:14'),(54,'contents/1660920047moto-01.jpeg','2022-08-19 17:40:47','2022-08-19 17:40:47'),(55,'contents/1660920071moto-01.jpeg','2022-08-19 17:41:11','2022-08-19 17:41:11'),(56,'contents/1660920162moto-01.jpeg','2022-08-19 17:42:42','2022-08-19 17:42:42'),(57,'contents/1660920619moto-01.jpeg','2022-08-19 17:50:19','2022-08-19 17:50:19'),(58,'contents/1660920648moto-01.jpeg','2022-08-19 17:50:48','2022-08-19 17:50:48'),(59,'contents/1660921821moto-01.jpeg','2022-08-19 18:10:21','2022-08-19 18:10:21'),(60,'contents/1661211453292292089_5219086831478582_7942497984571982337_n.jpg','2022-08-23 02:37:33','2022-08-23 02:37:33'),(61,'contents/1661213169hand-drawn-flat-design-stack-books-illustration_23-2149320038.webp','2022-08-23 03:06:09','2022-08-23 03:06:09'),(62,'contents/1661215189DSC_2776.JPG','2022-08-23 03:39:49','2022-08-23 03:39:49'),(63,'contents/1661215888DSC_2776 (1).jpg','2022-08-23 03:51:28','2022-08-23 03:51:28'),(64,'contents/1661215912DSC_2776 (1).jpg','2022-08-23 03:51:52','2022-08-23 03:51:52'),(65,'contents/1661216151DSC_2776 (1).jpg','2022-08-23 03:55:51','2022-08-23 03:55:51'),(66,'contents/1661510357cover-photo-2x.png','2022-08-26 13:39:17','2022-08-26 13:39:17');

--
-- Table structure for table `images`
--

CREATE TABLE `images` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `path` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `images`
--


--
-- Table structure for table `interests`
--

CREATE TABLE `interests` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `client_id` bigint(20) unsigned NOT NULL,
  `type_of_equipment_id` bigint(20) unsigned NOT NULL,
  `dependent_id` bigint(20) unsigned DEFAULT NULL,
  `transaction_id` bigint(20) unsigned DEFAULT NULL,
  `dt_devolucao` date DEFAULT NULL,
  `motivo` text COLLATE utf8mb4_unicode_ci,
  `cep` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state_id` bigint(20) unsigned DEFAULT NULL,
  `city` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `street` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `complement` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `interests`
--

INSERT INTO `interests` VALUES (1,'0b6fe2a6-98a6-475e-8665-cb1de43b2a15',1,1,1,NULL,'2022-07-30','Teste','81110-120',15,'Curitiba','Rua Delegado Naby Paraná','209','sobrado 6','2022-07-22 05:30:23','2022-07-22 05:50:39'),(2,'77fc02f6-97ef-464a-a3a2-b0bd6b3985a5',1,1,1,1,'2022-12-31','Test test','81110-120',15,'Curitiba','Rua Delegado Naby Paraná','209','sobrado 6','2022-07-22 05:52:25','2022-07-22 05:54:30'),(3,'24586280-e39c-4b7d-88e2-25691ce409c6',9,5,2,2,'2022-08-04','Test','81110-120',15,'Curitiba','Rua Delegado Naby Paraná','209','sobrado 6','2022-07-22 17:37:10','2022-07-22 17:38:06'),(4,'f6e7065e-7d65-4a01-ae73-c47a6adc2432',9,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-22 17:55:29','2022-07-22 17:55:29'),(5,'5d033d26-f414-4ec9-a36d-a9022f12a0a4',10,11,NULL,NULL,'2022-10-20','Está com a perda machucada','80240-000',15,'Curitiba','Av. Nereu Ramos','560','Sala 1602','2022-07-25 13:21:22','2022-07-25 13:23:11'),(6,'1b9a9052-d711-4c0b-b5f5-39397d84089f',1,1,4,NULL,'2022-07-31','Test','81110-120',15,'Curitiba','Rua Delegado Naby Paraná','208','sobrado 6','2022-07-25 14:04:06','2022-07-25 14:11:41'),(7,'996bd7a3-8e11-40f5-a3bc-39acfd2b7cd7',1,11,1,3,'2022-08-20','Test','81110-120',15,'Curitiba','Rua Delegado Naby Paraná','209','sobrado 6','2022-07-25 14:15:07','2022-07-25 14:17:05'),(8,'0ab99c71-9ea4-4e97-a1aa-ffcad4470ad9',10,11,3,4,'2022-10-20','Teste','88220-000',23,'Itapema','Av. Nereu Ramos','560','560','2022-07-25 15:44:52','2022-07-25 15:46:27'),(9,'dcfd8eab-b9ac-488f-974f-9d68ffdac1ea',10,6,3,NULL,'2022-10-20','teste envio de e-mail','80240-000',15,'Curitiba','Av. Nereu Ramos','560','Sala 1602','2022-07-26 17:44:32','2022-07-26 17:45:13'),(10,'5f08ca65-154c-49a4-805b-6e039439aed4',10,6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-26 17:48:09','2022-07-26 17:48:09'),(11,'e8f50878-ff13-455e-818b-74ff8ba99a86',10,6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-26 17:48:27','2022-07-26 17:48:27'),(12,'50872ee8-1a5d-48f0-b100-78a3c1324adc',1,1,1,5,'1989-07-04','Test','81110-120',15,'Curitiba','Rua Delegado Naby Parana','209','sobrado 6','2022-07-27 01:50:17','2022-07-27 01:51:28'),(13,'0001e074-53b8-4e0c-8e01-1f48d986d00a',1,12,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-27 02:15:20','2022-07-27 02:15:20'),(14,'ea1f3108-10ad-43df-9af5-7d3f42d21dfa',12,12,6,6,'2022-12-31','Teste','81110-120',15,'Curitiba','Rua Delegado Naby Paraná','209','sobrado 6','2022-07-27 02:18:35','2022-07-27 02:25:23'),(15,'44d340dc-f4c2-44d3-86e1-846280ea4dcd',12,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-27 02:37:21','2022-07-27 02:37:21'),(16,'c63fd707-aa41-424b-b4c2-a5f9a2dffcc1',13,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-07-27 03:51:09','2022-07-27 03:51:09'),(17,'2a8aae9c-8062-4b80-9942-f1ae1d75fe3c',14,2,7,NULL,'2022-10-01','Cirurgia pé direito','88220-000',23,'Itapema','Rua 261','61','Apto 701','2022-08-02 01:54:53','2022-08-02 02:02:13'),(18,'68c147fe-b083-4172-a158-6395c2089f8a',14,6,7,7,'2022-10-01','Ac moto. Cirurgia pe','88220-000',23,'Itapema','Rua 261','61','Apto 701','2022-08-02 02:03:02','2022-08-02 02:06:09'),(19,'2125fd0c-e47f-4f76-91d1-8e58cad6e925',12,2,5,NULL,'1989-07-04','Test','81110-120',15,'Curitiba','Rua Delegado Naby Parana','541','sobrado 6','2022-08-05 21:15:23','2022-08-05 21:26:59'),(20,'622c3ccf-1c8d-434b-ad56-263edb5fd25b',10,17,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-05 21:24:05','2022-08-05 21:24:05'),(21,'baf847d8-3f1e-4fd2-8e74-34e8ca86525b',12,1,5,8,'2022-08-05','TEst','81130-230',15,'Curitiba','Delegado Naby Parana','209','sobrado 6','2022-08-05 22:39:18','2022-08-05 22:39:40'),(22,'280917bc-4122-446b-b1bb-0eb37b1be0ea',15,1,8,9,'2022-08-10','Test','81110-120',15,'Curitiba','Rua Delegado Naby Paraná','209','sobrado 6','2022-08-06 00:15:23','2022-08-06 00:17:51'),(23,'19a18beb-f09d-4c35-856e-4e9feb7a0870',15,2,8,10,'8022-01-10','Test','81120-220',15,'Curitiba','Rua Delegado Naby Paraná','209','sobrado 6','2022-08-06 00:18:03','2022-08-06 00:18:42'),(24,'47cef3d3-26ef-435e-887f-1ff2d7625029',15,15,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-06 00:33:03','2022-08-06 00:33:03'),(25,'d48df939-feeb-4595-b1bd-2627064d4e92',14,15,7,11,'2022-10-05','CIRURGIA','88220-000',23,'ITAPEMA','CENTRO','100','APTO 100','2022-08-06 00:33:07','2022-08-06 00:34:52'),(26,'5cacc7f5-d570-4d91-9577-eb05c16551de',15,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-19 06:36:57','2022-08-19 06:36:57'),(27,'58969332-f139-4b16-a20e-e84b8ddefa23',15,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-19 18:13:50','2022-08-19 18:13:50'),(28,'2c5a7bd5-abe8-421b-b65f-1d7a2dd0c32a',15,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-22 20:55:07','2022-08-22 20:55:07'),(29,'5ed68a77-7c62-46f1-a957-f6d5d9f7fa7a',15,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-22 20:55:17','2022-08-22 20:55:17'),(30,'f8635642-8a99-463c-8967-42269b90cb09',15,2,8,12,'8022-01-30','Test','81130-230',15,'Curitiba','Rua Delegado Naby Parana','209','sobrado 6','2022-08-22 21:01:59','2022-08-22 21:02:32'),(31,'c9305f63-00ae-4bbd-86b8-b0f30bb6044e',15,1,8,13,'2022-01-30','Teste','81110-120',15,'Curitiba','Rua Delegado Naby Parana','209','sobrado 6','2022-08-22 21:28:25','2022-08-22 21:29:11'),(32,'aaa0dbd0-edc4-486c-ba0f-43ec2fd7adbc',15,2,8,NULL,'2022-08-30','Test','81130-230',15,'Curitiba','Rua Delegado Naby Parana','209','sobrado 6','2022-08-22 21:30:36','2022-08-22 21:31:10'),(33,'7abed739-fea4-4f4f-b82c-dddca86f863b',16,15,9,14,'2022-08-22','Teste','80240-000',15,'Curitiba','Rua 1150','50','Sala 1602','2022-08-22 21:41:59','2022-08-22 21:47:33'),(34,'412ef706-3f81-4629-92ea-9de6ed52d598',16,1,9,15,'2022-08-22','xxxxxxxxxxxxxxxxxxxxxxxxxxx','80240-000',15,'Curitiba','Rua 1150','50','Sala 1602','2022-08-22 22:21:34','2022-08-22 22:22:12'),(35,'410badb2-49d6-4d6c-a45d-1c68a55a4590',16,1,9,16,'2022-09-22','Teste 3','80240-000',15,'Curitiba','Travessa Lange','277','Sala 1602','2022-08-22 22:22:55','2022-08-22 22:24:34'),(36,'efe0fdb9-7385-4ad3-a772-cbbd69cca303',16,2,9,17,'0822-01-31','Testessss','80240-000',15,'Curitiba','Travessa Lange','277','Sala 1602','2022-08-22 23:03:06','2022-08-22 23:04:08'),(37,'ad5fa852-46a4-407e-b5a3-7d5152101eb6',15,2,8,18,'2022-01-30','Test','81110-120',15,'Curitiba','Rua Delegado Naby Parana','209','sobrado 6','2022-08-22 23:14:40','2022-08-22 23:15:15'),(38,'693cf7b2-ee08-46e7-b984-54fef48b5b21',16,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-22 23:17:55','2022-08-22 23:17:55'),(39,'73835fe0-d07a-4f46-b0e6-db847091450e',16,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-22 23:42:41','2022-08-22 23:42:41'),(40,'8a0e1bf6-19e1-4926-99a0-10bc7fb55dda',16,2,9,19,'2022-08-22','Teste','80240-170',15,'Curitiba','Travessa Lange','277','apt. 602','2022-08-22 23:44:24','2022-08-22 23:45:06'),(41,'84261f8f-127b-40ac-b817-a5b3c62562f5',15,2,8,20,'2022-08-30','Test','81110-120',15,'Curitiba','Rua Delegado Naby Paraná','209','sobrado 6','2022-08-23 00:01:54','2022-08-23 00:02:37'),(42,'7f3241e1-ec45-4431-92b9-6d5c0020b443',15,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-23 00:18:10','2022-08-23 00:18:10'),(43,'fdb1826c-3ecd-4d39-abe3-931cb0671362',15,2,8,21,'2022-08-30','Test','81110-120',15,'Curitiba','Rua Delegado Naby Parana','209','sobrado 6','2022-08-23 00:21:10','2022-08-23 00:22:20'),(44,'891a7c76-533c-493b-a39d-cf40d6c670ad',15,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-23 00:42:58','2022-08-23 00:42:58'),(45,'8aaab811-80a1-4848-92b8-ed1159185cb7',15,1,10,22,'2022-08-30','Test','81110-120',15,'Curitiba','Rua Delegado Naby Paraná','209','sobrado 6','2022-08-24 03:45:13','2022-08-24 03:46:47'),(46,'5d321118-036c-436d-a8a0-be3d706e780b',16,17,9,23,'2022-08-24','Dificuldade para andar','80240-000',15,'Curitiba','Av. Nereu Ramos','560','Sala 1602','2022-08-24 14:11:41','2022-08-24 14:12:40'),(47,'1cbdd3fe-57c6-4afd-8688-a406e718c1cd',14,17,7,24,'2022-09-30','TORÇAO TORNOZELO','88220-000',23,'ITAPEMA','RUIA 261','61','APTO 701','2022-08-26 23:41:47','2022-08-26 23:43:03'),(48,'cf51865e-a136-481e-95d7-bdbcf4447dfe',16,14,9,25,'9822-01-30','Teste','80240-000',15,'Curitiba','Travessa Lange','277','Sala 1602','2022-08-29 14:56:29','2022-08-29 14:57:52'),(49,'c3d2a64b-7a29-4506-a16c-d0453de655c3',16,15,9,26,'2022-08-29','ccccc','80240-000',15,'Curitiba','Travessa Lange','277','Sala 1602','2022-08-30 02:51:17','2022-08-30 02:53:15'),(50,'e01ce5a0-ab77-4942-a104-f148592c17c6',15,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-31 01:59:41','2022-08-31 01:59:41'),(51,'50f29113-236e-41ec-82f2-bb96512718de',16,17,9,27,'2022-09-30','teste 31/08','80240-000',15,'Curitiba','Travessa Lange','277','Sala 1602','2022-08-31 13:22:15','2022-08-31 13:23:42'),(52,'bffbddda-7a02-409d-b288-da09acabf16d',16,17,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-08-31 13:30:12','2022-08-31 13:30:12');

--
-- Table structure for table `menus`
--

CREATE TABLE `menus` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `link` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `menu_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menus`
--

INSERT INTO `menus` VALUES (1,'O que é o Rotary','/o-que-e-o-rotary',NULL,'2022-06-17 22:58:44','2022-06-17 22:58:44'),(2,'Nosso Clube','/nosso-clube',NULL,'2022-06-17 22:58:55','2022-06-17 22:58:55'),(3,'Notícias','/c/noticias',NULL,'2022-08-11 03:03:13','2022-08-22 20:25:35'),(4,'Projetos','/c/projetos',2,'2022-06-17 22:59:12','2022-06-17 22:59:12'),(5,'Banco ortopédico','/banco-ortopedico',NULL,'2022-06-17 22:59:22','2022-06-17 22:59:22'),(7,'Reuniões do Clube','/reunioes-do-clube',2,'2022-06-17 22:59:44','2022-06-17 22:59:44'),(16,'Interact','/interact',NULL,'2022-06-27 20:21:40','2022-06-27 20:21:40'),(17,'Rotaract','/rotaract',NULL,'2022-06-27 20:21:56','2022-06-27 20:21:56'),(18,'Parceiros','/parceiros',NULL,'2022-06-27 20:22:09','2022-06-27 20:22:09'),(19,'Contato','/contato',NULL,'2022-06-27 20:22:19','2022-07-20 03:08:30'),(24,'Empresas Cidadãs','/empresas-cidadas',18,'2022-08-05 17:37:29','2022-08-22 15:30:22'),(28,'Histórico','/historico',2,'2022-08-22 15:00:17','2022-08-22 15:00:17'),(29,'Presidentes','/presidentes',2,'2022-08-22 15:00:36','2022-08-22 15:00:36'),(30,'Eventos','/c/eventos',3,'2022-08-23 03:10:55','2022-08-23 03:10:55');

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

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=73 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,'2019_08_19_000000_create_failed_jobs_table',1),(4,'2019_12_14_000001_create_personal_access_tokens_table',1),(5,'2022_04_17_015903_create_permission_tables',1),(6,'2022_04_22_003208_create_pages_table',1),(7,'2022_04_22_011323_create_menus_table',1),(8,'2022_05_09_000000_create_images_table',1),(10,'2022_05_09_004007_create_status_publish_equipment_table',1),(11,'2022_05_09_004008_create_status_equipment_table',1),(13,'2022_06_07_231203_create_settings_table',1),(18,'2022_06_17_164954_create_requests_table',1),(19,'2022_06_17_165151_create_request_items_table',1),(21,'2022_06_18_185812_create_equipment_file_table',3),(23,'2022_06_21_031154_create_origin_equipment_table',5),(26,'2022_07_01_190644_interest_equipment',8),(28,'2022_06_17_225520_create_files_table',10),(34,'2022_05_09_004007_create_status_publish_table',13),(35,'2022_05_09_000319_create_type_of_equipment_table',14),(36,'2022_05_09_004007_create_status_publishes_table',15),(38,'2022_05_09_004009_create_equipment_table',16),(45,'2022_07_07_002418_create_states_table',19),(47,'2022_06_17_164001_create_sexes_table',20),(49,'2022_06_17_164638_create_clients_table',21),(55,'2022_06_17_164850_create_request_statuses_table',24),(56,'2022_06_17_164000_create_status_maritals_table',25),(59,'2022_06_21_032426_create_status_initial_equipment_table',28),(61,'2022_06_17_164850_create_transaction_statuses_table',30),(65,'2022_07_01_190041_create_interests_table',31),(66,'2022_07_08_003739_create_dependents_table',32),(67,'2022_06_17_164954_create_transactions_table',33),(68,'2022_07_31_003739_create_categories_table',34),(72,'2022_08_19_035308_create_posts_table',35);

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_permissions`
--


--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--


--
-- Table structure for table `origin_equipment`
--

CREATE TABLE `origin_equipment` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `origin_equipment`
--

INSERT INTO `origin_equipment` VALUES (1,'Doação',NULL,NULL),(2,'Compra',NULL,NULL);

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `html` text COLLATE utf8mb4_unicode_ci,
  `status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_home` int(11) DEFAULT NULL,
  `status_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` VALUES (1,'o-que-e-o-rotary','O que é o Rotary','<p>O Rotary International é uma associação de clubes de serviços cujo objetivo declarado é unir voluntários, a fim de prestar serviços humanitários e promover valores éticos e a paz a nível internacional. São mais de 35 mil Clubes de Rotary no mundo, com cerca de 1,3 milhões de associados.</p><p>Os lemas oficiais do&nbsp;Rotary, <i><strong>Dar de Si Antes de Pensar em Si</strong></i> e <i><strong>Mais Se Beneficia Quem Melhor Serve</strong></i>, datam dos primórdios da organização da sua fundação.</p><p><span style=\"color:hsl(0,0%,0%);\">A Missão do&nbsp;<strong>Rotary&nbsp;Internationa</strong>l é servir ao próximo, difundir a integridade e promover a boa vontade, paz e compreensão mundial por meio da consolidação de boas relações entre líderes profissionais, empresariais e comunitários.</span></p><p>&nbsp;</p><figure class=\"media\"><oembed url=\"https://www.youtube.com/watch?v=j7iuKI6mvLo\"></oembed></figure><p>&nbsp;</p>','Publicado',NULL,2,'2022-06-17 22:55:20','2022-08-22 20:15:32'),(2,'nosso-clube','Nosso Clube','<p style=\"text-align:justify;\">O Rotary Club Itapema, filiado ao Rotary Club Internacional, foi fundado em 07 de novembro de 1.988, tem sua sede na Rua 406-B, 722, no bairro Morretes, na cidade de Itapema, Estado de Santa Catarina.</p><p style=\"text-align:justify;\">Nesses 33 anos de existência, com apoio de entidades públicas, empresários e cidadãos locais, o Rotary Club Itapema tem trabalhado em prol das comunidades do município, através de programas pontuais e permanentes, como é o caso da Escola Pequeno Príncipe, sob administração da Secretaria de Educação, que atende crianças carentes da região de Morretes, e do Banco Ortopédico, que cede gratuitamente, por empréstimo ou doação, cadeira de rodas, muletas, camas hospitalares, cadeiras de banho e outros equipamentos à pessoas carentes com dificuldade de locomoção.</p>','Publicado',NULL,2,'2022-06-17 22:55:40','2022-06-28 21:17:21'),(3,'eventos','Eventos','<ol><li><a href=\"/eventos/costelaco\">COSTELAÇO – festa anual, realizada com o objetivo de arrecadar recursos para projetos sociais.</a></li><li><a href=\"/eventos/festival-codorna\">FESTIVAL DE CODORNA</a></li><li><a href=\"/eventos/festa-junina\">FESTA JUNINA realizada para as crianças abrigadas pela Casa Teresa de Calcutá, na qual é oferecido almoço e brincadeiras, com apresen</a><a href=\"http://127.0.0.1:8000/junina\">tações de palhaços, mágicos etc</a></li></ol>','Publicado',NULL,2,'2022-06-17 22:56:02','2022-08-05 20:59:32'),(4,'projetos','Nosso Clube - Projetos','<ol><li><a href=\"/projetos/banco-ortopedico\">Banco Ortopédico</a></li></ol><ul><li><img class=\"image_resized\" style=\"width:22.36%;\" src=\"http://rotaryitapema.siteprofissional.com/contents/16611932972017-06-23 17.17.15-3.jpg\">.</li></ul><ol><li><a href=\"/projetos/coleta-de-livros\">Coleta de livros</a></li></ol><p>.<img class=\"image_resized\" style=\"width:18.96%;\" src=\"http://rotaryitapema.siteprofissional.com/contents/16611933302017-06-23 17.17.15.jpg\"></p>','Publicado',NULL,2,'2022-06-17 22:56:15','2022-08-22 21:35:48'),(5,'banco-ortopedico','Banco Ortopédico','<p>O Banco Ortopédico, mantido pelo Rotary Club de Itapema com o apoio de empresários e cidadãos do município, &nbsp; vem a mais de 30 anos auxiliando pessoas necessitadas e com dificuldades de locomoção, através de empréstimo e doação de cadeiras de rodas,&nbsp; botas ortopédicas, andadores, cadeiras de banho e muletas.</p>','Publicado',NULL,2,'2022-06-17 22:56:38','2022-07-07 02:03:12'),(6,'contato','Contato','<h4>Envie por aqui a sua mensagem, dúvida ou sugestão, sobre os nossos projetos e a forma de como você pode ajudar o Rotary a fazer pessoas felizes.</h4><p><a href=\"mailto:contato@rotaryitapema.org.br\">contato@rotaryitapema.org.br</a></p><p>&nbsp;</p><p>&nbsp;</p>','Publicado',NULL,2,'2022-06-17 22:56:55','2022-08-26 13:57:33'),(7,'reunioes-do-clube','Nosso Clube - Reuniões do Clube','<h3>As nossas reuniões semanais são realizadas às segundas-feiras, em nossa sede, na&nbsp;Rua 406-B, 722, no bairro Morretes - Itapema - SC, no horário das 20:00 às 21:00hs.</h3>','Publicado',NULL,2,'2022-06-17 22:57:22','2022-08-23 01:22:22'),(8,'parceiros','Parceiros','<h2><strong>EMPRESAS PARCEIRAS</strong></h2><p>&nbsp;</p><p>1. Construtora ABCXXX &nbsp;- &nbsp; A empresa ABC, especializada em construção de escolas, é uma parceira que sempre se faz presente aos projetos do Rotary, quer através de doações, quer através da cessão de material de AAAAAAAA</p><p>&nbsp;</p><p>2. Supermercado XXXXXXXi – esse é um outro grande parceiro, que sempre apoia os projetos humanitários do Rotary Club de Itapema.</p><p>&nbsp;</p><p>3. Panificadora ZZZZZZZZZ</p>','Publicado',NULL,2,'2022-06-17 22:58:24','2022-08-23 14:23:46'),(9,'home','Bem Vindo','<p>Bem-vindo ao site do Rotary Club de Itapema, entidade privada, sem fins lucrativos, dedicada a projetos humanitários.</p><p>O Rotary Club de Itapema, fundado há 34 anos, além de contribuir com os projetos do Rotary International, mantém em Itapema, entre outros projetos, um banco ortopédico, destinado a socorrer pessoas necessitadas, com empréstimo de cadeiras de rodas e outros equipamentos, tais como botas ortopédicas, andadores, cadeiras de banho e muletas.</p><figure class=\"media\"><oembed url=\"https://youtu.be/14NGqZh0drM\"></oembed></figure><p>&nbsp;</p><p>&nbsp;</p>','Publicado',NULL,2,'2022-06-17 22:58:24','2022-08-23 14:16:04'),(13,'rotaract','Rotaract','<p style=\"text-align:justify;\">Os Rotaract Clubs são clubes que promovem ações sociais, a preservação ao meio ambiente e tem o objetivo de formar líderes. São compostos por jovens/adultos com idade a partir dos 18 anos. Os clubes são afiliados a um Rotary Club local.</p><p style=\"text-align:justify;\">O Rotaract possibilita, através de intercâmbios, além da formação, o encontro de jovens lideranças do mundo. Desde campos de férias, a eventos internacionais, bem como a possibilidade de realizar projetos com dimensão mundial, com qualquer país do mundo.&nbsp;</p><p style=\"text-align:justify;\">São mais de 10 mil Rotaract Clubs distribuídos em 184 países com mais de 250 mil associados, chamados de rotaractianos.</p><p>Se você tem entre 18 e &nbsp;29 anos, quer fazer bons amigos e participar de projetos humanitários, venha para o Rotaract.&nbsp;</p><p>Contato:&nbsp; <a href=\"mailto:contato@rotaryitapema.org.br\">contato@rotaryitapema.org.br</a></p><p style=\"text-align:justify;\">&nbsp;</p><p style=\"text-align:justify;\"><br>&nbsp;</p>','Publicado',NULL,2,'2022-06-22 21:51:16','2022-06-28 21:26:35'),(14,'interact','Interact','<p style=\"text-align:justify;\">Os&nbsp;Interact Clubs&nbsp;são clubes de serviços, formados por jovens entre 12 e 18 anos, que visam ajudar a&nbsp;<a href=\"https://pt.wikipedia.org/wiki/Sociedade\">sociedade</a>&nbsp;de uma forma simples, com campanhas, doações, visitas a&nbsp;<a href=\"https://pt.wikipedia.org/wiki/Creche\">creches</a>&nbsp;e&nbsp;<a href=\"https://pt.wikipedia.org/wiki/Hospital\">hospitais</a>, entre outras muitas ações em defesa do&nbsp;<a href=\"https://pt.wikipedia.org/wiki/Meio-ambiente\">meio ambiente</a>&nbsp;e do bem-estar da população mais carente. São compostos por adolescentes de 12 a 18 anos.&nbsp;Os clubes são afiliados a um Rotary Club local, do qual recebem apoio e orientação.</p><p style=\"text-align:justify;\">Existem mais de 20 mil Interact Clubs distribuídos em 159 países, com mais de 400 mil associados, chamados de interactianos</p><p>Se você tem entre 12 e 17 anos, quer fazer bons amigos e participar de projetos humanitários, se associe a um Interact Club.&nbsp;</p><p><strong>Contato</strong>:&nbsp; <a href=\"mailto:contato@rotaryitapema.org.br\">contato@rotaryitapema.org.br</a></p><p>&nbsp;</p>','Publicado',NULL,2,'2022-06-27 20:23:26','2022-06-28 21:27:53'),(15,'termo-de-utilizacao','Termo de utilização','<p>Declaro ter conhecimento &nbsp;e concordar que ao submeter um pedido de empréstimo de equipamento ortopédico ao Rotary Club de Itapema, me responsabilizo pela sua conservação e devolução no prazo acordado, e que não o fazendo, não tendo o prazo sido prorrogado, me comprometo e entregar um equipamento da mesma qualidade ou a importância equivalente em reais, no prazo máximo de trinta dias, sob as penas da lei.</p><p>Declaro ainda que autorizo ao Rotary uso dos meus dados gravados neste cadastro, sem que nada haja a ser reclamado a titulo de direitos conexos à minha imagem.</p><p>&nbsp;</p>','Publicado',NULL,2,'2022-06-27 20:23:26','2022-08-22 21:46:27'),(21,'costelaco','Costelaço','<p>Costelaço</p>',NULL,NULL,2,'2022-08-06 00:52:25','2022-08-06 00:52:25'),(22,'empresas-cidadas','Empresas Cidadãs','<p><img class=\"image_resized\" style=\"width:26.34%;\" src=\"http://rotaryitapema.siteprofissional.com/contents/1661253650Logo Perfyaço.jpeg\"></p>',NULL,NULL,2,'2022-08-06 00:55:22','2022-08-23 14:22:56'),(24,'presidentes','Nosso Clube - Presidentes','<p>Teste</p><figure class=\"image image_resized\" style=\"width:45.85%;\"><img src=\"http://rotaryitapema.siteprofissional.com/contents/1661509639DSC_2755.jpg\"></figure>',NULL,NULL,2,'2022-08-08 23:27:14','2022-08-26 13:27:29'),(25,'historico','Nosso Clube - Histórico','<p>Teste criação histporico</p>',NULL,NULL,2,'2022-08-22 14:51:19','2022-08-22 14:59:55');

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--


--
-- Table structure for table `posts`
--

CREATE TABLE `posts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `html` text COLLATE utf8mb4_unicode_ci,
  `status_publish_id` bigint(20) unsigned DEFAULT NULL,
  `category_id` bigint(20) unsigned DEFAULT NULL,
  `featured_image_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `posts_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `posts`
--

INSERT INTO `posts` VALUES (8,'banco-ortopedico','Banco Ortopédico -visa auxiliar pessoas com dificuldade de locomoção.','<p><span style=\"background-color:rgb(243,243,249);color:rgb(33,37,41);\">O Banco Ortopédico, mantido pelo Rotary Club de Itapema com o apoio de empresários e cidadãos do município, &nbsp;vem a mais de 30 anos auxiliando pessoas necessitadas e com dificuldades de locomoção, através de empréstimo e doação de cadeiras de rodas,&nbsp; botas ortopédicas, andadores, cadeiras de banho e muletas.</span></p>',2,2,60,'2022-08-23 02:37:33','2022-08-23 03:07:05'),(9,'coleta-de-livros','Coleta de livros para doação a bibliotecas e escolas.','<p>Este projeto visa coletar livros para escolas, bibliotecas e disposição em pontos de acesso público, afim de incentivar o processo de leitura e aprendizado pela população.</p>',2,2,61,'2022-08-23 03:06:09','2022-08-23 03:06:56'),(10,'festa-casa-madre-teresa','Festa para as crianças da Casa Madre Teresa de Calcutá, em 25/06/2022.','<p>Dia 25 de junho de 2022 o Rotary Clube Itapema ofereceu um churrasco a cerca de 180 crianças matriculadas na Casa Madre Teresa de Calcutá. Foi um evento muito festivo, com apresentação de um mágico e muitas brincadeiras.</p><p>&nbsp;</p><figure class=\"media\"><oembed url=\"https://www.youtube.com/watch?v=31vFD3vr_74&amp;feature=youtu.be\"></oembed></figure><p>&nbsp;</p>',2,1,65,'2022-08-23 03:39:49','2022-08-23 03:55:51'),(11,'rotary-noticias','Rotary Clube Itapema','<figure class=\"image\"><img src=\"http://rotaryitapema.siteprofissional.com/contents/1661510354cover-photo-2x.png\"></figure>',2,3,66,'2022-08-26 13:39:17','2022-08-26 13:39:17');

--
-- Table structure for table `request_statuses`
--

CREATE TABLE `request_statuses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `request_statuses`
--

INSERT INTO `request_statuses` VALUES (1,'Aguardando aprovação','2022-07-08 16:27:32','2022-07-08 16:27:32'),(2,'Emprestado','2022-07-08 16:27:33','2022-07-08 16:27:33'),(3,'Devolvido','2022-07-08 16:27:33','2022-07-08 16:27:33');

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--


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

CREATE TABLE `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


--
-- Table structure for table `sexes`
--

CREATE TABLE `sexes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sexes`
--

INSERT INTO `sexes` VALUES (1,'Masculino','2022-07-07 03:43:14','2022-07-07 03:43:14'),(2,'Feminino','2022-07-07 03:43:14','2022-07-07 03:43:14');

--
-- Table structure for table `states`
--

CREATE TABLE `states` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `states`
--

INSERT INTO `states` VALUES (1,'Acre','2022-07-07 03:41:58','2022-07-07 03:41:58'),(2,'Alagoas','2022-07-07 03:41:58','2022-07-07 03:41:58'),(3,'Amapá','2022-07-07 03:41:58','2022-07-07 03:41:58'),(4,'Amazonas','2022-07-07 03:41:58','2022-07-07 03:41:58'),(5,'Bahia','2022-07-07 03:41:58','2022-07-07 03:41:58'),(6,'Ceará','2022-07-07 03:41:58','2022-07-07 03:41:58'),(7,'Espírito Santo','2022-07-07 03:41:58','2022-07-07 03:41:58'),(8,'Goiás','2022-07-07 03:41:58','2022-07-07 03:41:58'),(9,'Maranhão','2022-07-07 03:41:58','2022-07-07 03:41:58'),(10,'Mato Grosso','2022-07-07 03:41:58','2022-07-07 03:41:58'),(11,'Mato Grosso do Sul','2022-07-07 03:41:58','2022-07-07 03:41:58'),(12,'Minas Gerais','2022-07-07 03:41:58','2022-07-07 03:41:58'),(13,'Pará','2022-07-07 03:41:59','2022-07-07 03:41:59'),(14,'Paraíba','2022-07-07 03:41:59','2022-07-07 03:41:59'),(15,'Paraná','2022-07-07 03:41:59','2022-07-07 03:41:59'),(16,'Pernambuco','2022-07-07 03:41:59','2022-07-07 03:41:59'),(17,'Piauí','2022-07-07 03:41:59','2022-07-07 03:41:59'),(18,'Rio de Janeiro','2022-07-07 03:41:59','2022-07-07 03:41:59'),(19,'Rio Grande do Norte','2022-07-07 03:41:59','2022-07-07 03:41:59'),(20,'Rio Grande do Sul','2022-07-07 03:41:59','2022-07-07 03:41:59'),(21,'Rondônia','2022-07-07 03:41:59','2022-07-07 03:41:59'),(22,'Roraima','2022-07-07 03:41:59','2022-07-07 03:41:59'),(23,'Santa Catarina','2022-07-07 03:41:59','2022-07-07 03:41:59'),(24,'São Paulo','2022-07-07 03:41:59','2022-07-07 03:41:59'),(25,'Sergipe','2022-07-07 03:41:59','2022-07-07 03:41:59'),(26,'Tocantins','2022-07-07 03:41:59','2022-07-07 03:41:59'),(27,'Distrito Federal','2022-07-07 03:41:59','2022-07-07 03:41:59');

--
-- Table structure for table `status_equipment`
--

CREATE TABLE `status_equipment` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `status_equipment`
--

INSERT INTO `status_equipment` VALUES (1,'Disponível','2022-06-17 22:40:20','2022-06-17 22:40:20'),(2,'Emprestado','2022-06-17 22:40:20','2022-06-17 22:40:20'),(3,'Doado','2022-06-17 22:40:20','2022-06-17 22:40:20');

--
-- Table structure for table `status_initial_equipment`
--

CREATE TABLE `status_initial_equipment` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `status_initial_equipment`
--

INSERT INTO `status_initial_equipment` VALUES (1,'Novo','2022-07-08 16:54:51','2022-07-08 16:54:51'),(2,'Usado','2022-07-08 16:54:51','2022-07-08 16:54:51');

--
-- Table structure for table `status_maritals`
--

CREATE TABLE `status_maritals` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `status_maritals`
--

INSERT INTO `status_maritals` VALUES (1,'Solteiro(a)','2022-07-08 16:29:49','2022-07-08 16:29:49'),(2,'Casado(a)','2022-07-08 16:29:49','2022-07-08 16:29:49'),(3,'Separado(a)','2022-07-08 16:29:49','2022-07-08 16:29:49'),(4,'Divorciado(a)','2022-07-08 16:29:49','2022-07-08 16:29:49'),(5,'Viúvo(a)','2022-07-08 16:29:49','2022-07-08 16:29:49');

--
-- Table structure for table `status_publishes`
--

CREATE TABLE `status_publishes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `status_publishes`
--

INSERT INTO `status_publishes` VALUES (1,'Em espera',NULL,NULL),(2,'Publicado',NULL,NULL);

--
-- Table structure for table `transaction_statuses`
--

CREATE TABLE `transaction_statuses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `transaction_statuses`
--

INSERT INTO `transaction_statuses` VALUES (1,'Aguardando aprovação','2022-07-08 17:14:56','2022-07-08 17:14:56'),(2,'Emprestado','2022-07-08 17:14:56','2022-07-08 17:14:56'),(3,'Finalizado','2022-07-08 17:14:56','2022-07-08 17:14:56'),(4,'Cancelado','2022-07-08 17:14:56','2022-07-08 17:14:56');

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

CREATE TABLE `transactions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `client_id` bigint(20) unsigned NOT NULL,
  `type_of_equipment_id` bigint(20) unsigned NOT NULL,
  `dependent_id` bigint(20) unsigned NOT NULL,
  `transaction_status_id` bigint(20) unsigned NOT NULL,
  `equipment_id` bigint(20) unsigned DEFAULT NULL,
  `dt_devolucao` date NOT NULL,
  `motivo` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `cep` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `state_id` bigint(20) unsigned NOT NULL,
  `city` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `street` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `complement` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `dt_encerramento` date DEFAULT NULL,
  `obs_encerramento` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `transactions` VALUES (1,1,1,1,3,1,'2022-12-31','Test test','81110-120',15,'Curitiba','Rua Delegado Naby Paraná','209','sobrado 6','2022-07-22 05:54:30','2022-07-27 01:32:25',NULL,NULL),(2,9,5,2,3,14,'2022-08-04','Test','81110-120',15,'Curitiba','Rua Delegado Naby Paraná','209','sobrado 6','2022-07-22 17:38:06','2022-07-27 01:40:58',NULL,NULL),(3,1,11,1,3,13,'2022-08-20','Test','81110-120',15,'Curitiba','Rua Delegado Naby Paraná','209','sobrado 6','2022-07-25 14:17:05','2022-07-27 01:44:20',NULL,NULL),(4,10,11,3,3,13,'2022-10-20','Teste','88220-000',23,'Itapema','Av. Nereu Ramos','560','560','2022-07-25 15:46:27','2022-07-27 01:37:23',NULL,NULL),(5,1,1,1,3,1,'2022-12-31','Test','81110-120',15,'Curitiba','Rua Delegado Naby Parana','209','sobrado 6','2022-07-27 01:51:28','2022-08-01 02:23:45',NULL,NULL),(6,12,12,6,3,15,'2022-10-31','Teste','81110-120',15,'Curitiba','Rua Delegado Naby Paraná','209','sobrado 6','2022-07-27 02:25:23','2022-07-27 02:40:41',NULL,NULL),(7,14,6,7,1,NULL,'2022-10-01','Ac moto. Cirurgia pe','88220-000',23,'Itapema','Rua 261','61','Apto 701','2022-08-02 02:06:09','2022-08-02 02:06:09',NULL,NULL),(8,12,1,5,3,12,'2022-08-05','TEst','81130-230',15,'Curitiba','Delegado Naby Parana','209','sobrado 6','2022-08-05 22:39:40','2022-08-22 22:03:10',NULL,NULL),(9,15,1,8,3,16,'2022-08-10','Test','81110-120',15,'Curitiba','Rua Delegado Naby Paraná','209','sobrado 6','2022-08-06 00:17:50','2022-08-22 22:02:20',NULL,NULL),(10,15,2,8,3,22,'2022-10-01','Test','81120-220',15,'Curitiba','Rua Delegado Naby Paraná','209','sobrado 6','2022-08-06 00:18:42','2022-08-22 23:01:54',NULL,NULL),(11,14,15,7,3,19,'2099-10-05','CIRURGIA','88220-000',23,'ITAPEMA','CENTRO','100','APTO 100','2022-08-06 00:34:52','2022-08-22 21:55:20',NULL,NULL),(12,15,2,8,3,17,'2022-08-30','Test','81130-230',15,'Curitiba','Rua Delegado Naby Parana','209','sobrado 6','2022-08-22 21:02:32','2022-08-22 22:03:54',NULL,NULL),(13,15,1,8,3,20,'2022-01-30','Teste','81110-120',15,'Curitiba','Rua Delegado Naby Parana','209','sobrado 6','2022-08-22 21:29:11','2022-08-22 22:04:03',NULL,NULL),(14,16,15,9,3,21,'2022-08-22','Teste','80240-000',15,'Curitiba','Rua 1150','50','Sala 1602','2022-08-22 21:47:33','2022-08-23 00:35:56','2022-08-22',NULL),(15,16,1,9,3,12,'2022-08-22','xxxxxxxxxxxxxxxxxxxxxxxxxxx','80240-000',15,'Curitiba','Rua 1150','50','Sala 1602','2022-08-22 22:22:12','2022-08-22 23:40:59',NULL,NULL),(16,16,1,9,3,12,'2022-12-31','Teste 3','80240-000',15,'Curitiba','Travessa Lange','277','Sala 1602','2022-08-22 22:24:34','2022-08-22 23:41:30',NULL,NULL),(17,16,2,9,3,23,'2023-01-31','Testessss','80240-000',15,'Curitiba','Travessa Lange','277','Sala 1602','2022-08-22 23:04:08','2022-08-22 23:41:53',NULL,NULL),(18,15,2,8,3,24,'2022-10-30','Test','81110-120',15,'Curitiba','Rua Delegado Naby Parana','209','sobrado 6','2022-08-22 23:15:15','2022-08-22 23:41:39',NULL,NULL),(19,16,2,9,3,23,'2022-08-22','Teste','80240-170',15,'Curitiba','Travessa Lange','277','apt. 602','2022-08-22 23:45:06','2022-08-23 01:08:01','2022-08-22',NULL),(20,15,2,8,3,25,'2022-08-30','Test','81110-120',15,'Curitiba','Rua Delegado Naby Paraná','209','sobrado 6','2022-08-23 00:02:37','2022-08-23 00:04:26',NULL,NULL),(21,15,2,8,3,25,'2022-08-30','Test','81110-120',15,'Curitiba','Rua Delegado Naby Parana','209','sobrado 6','2022-08-23 00:22:20','2022-08-23 00:25:38',NULL,NULL),(22,15,5,10,3,14,'2022-08-30','Test','81110-120',15,'Curitiba','Rua Delegado Naby Paraná','209','sobrado 6','2022-08-24 03:46:47','2022-08-31 04:34:28','2022-08-30','Apenas teste'),(23,16,17,9,3,29,'2022-08-24','Dificuldade para andar','80240-000',15,'Curitiba','Av. Nereu Ramos','560','Sala 1602','2022-08-24 14:12:40','2022-08-25 01:13:06','2022-08-24',NULL),(24,14,17,7,3,29,'2022-09-30','TORÇAO TORNOZELO','88220-000',23,'ITAPEMA','RUIA 261','61','APTO 701','2022-08-26 23:43:03','2022-08-31 13:27:09','2022-08-31','Equipamento vistoriado'),(25,16,14,9,2,28,'2022-01-30','Teste','80240-000',15,'Curitiba','Travessa Lange','277','Sala 1602','2022-08-29 14:57:52','2022-08-29 15:00:16',NULL,NULL),(26,16,15,9,2,19,'2022-10-30','ccccc','80240-000',15,'Curitiba','Travessa Lange','277','Sala 1602','2022-08-30 02:53:15','2022-08-30 02:56:08',NULL,NULL),(27,16,17,9,2,29,'2022-09-30','teste 31/08','80240-000',15,'Curitiba','Travessa Lange','277','Sala 1602','2022-08-31 13:23:42','2022-08-31 13:28:51',NULL,NULL);

--
-- Table structure for table `type_of_equipment`
--

CREATE TABLE `type_of_equipment` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `featured_image_id` bigint(20) unsigned DEFAULT NULL,
  `status_publish_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `type_of_equipment`
--

INSERT INTO `type_of_equipment` VALUES (1,'04 - Cadeira de Rodas','<p style=\"text-align:justify;\">&nbsp;</p>',32,2,'2022-07-06 22:42:29','2022-08-23 00:08:24'),(2,'06 - Cama Hospitalar','<p style=\"text-align:justify;\">&nbsp;</p>',33,2,'2022-07-06 22:42:40','2022-08-23 00:09:15'),(3,'01 - Andador','<p>&nbsp;</p>',38,2,'2022-07-06 22:47:05','2022-08-23 00:06:40'),(5,'05 - Cadeira de Banho','<p>&nbsp;</p>',35,2,'2022-07-08 01:27:08','2022-08-23 00:09:31'),(14,'09 - Muletas Canadenses','<p>&nbsp;</p>',42,2,'2022-08-03 01:08:25','2022-08-23 00:10:58'),(15,'03 - Bota Ortopédica','<p>&nbsp;</p>',43,2,'2022-08-03 01:08:48','2022-08-23 00:07:59'),(16,'07 - Colchão Ortopédico','<p>&nbsp;</p>',46,2,'2022-08-03 01:09:40','2022-08-23 00:10:00'),(17,'02 - Bengala','<p>&nbsp;</p>',44,2,'2022-08-03 01:10:53','2022-08-23 00:07:12'),(18,'08 - Muletas Axilares','<p>&nbsp;</p>',45,2,'2022-08-04 02:07:42','2022-08-23 00:10:26');
/*!50112 PREPARE s FROM @disable_bulk_load */;
/*!50112 EXECUTE s */;
/*!50112 DEALLOCATE PREPARE s */;


