text: -- MySQL dump 10.15  Distrib 10.0.38-MariaDB, for debian-linux-gnu (x86_64)
  --
  -- Host: 127.0.0.1    Database: api
  -- ------------------------------------------------------
  -- Server version	10.0.38-MariaDB-0ubuntu0.16.04.1
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8mb4 */;
  /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  /*!40103 SET TIME_ZONE='+00:00' */;
  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  
  --
  -- Table structure for table `availability`
  --
  
  DROP TABLE IF EXISTS `availability`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `availability` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `clinic_id` int(10) unsigned NOT NULL,
    `provider_id` int(10) unsigned NOT NULL,
    `patient_id` int(10) unsigned DEFAULT NULL,
    `start_datetime` datetime NOT NULL,
    `end_datetime` datetime NOT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `provider_start_datetime_uk` (`provider_id`,`start_datetime`),
    KEY `availability_clinic_fk` (`clinic_id`),
    CONSTRAINT `availability_clinic_fk` FOREIGN KEY (`clinic_id`) REFERENCES `clinic` (`id`),
    CONSTRAINT `availability_provider_fk` FOREIGN KEY (`provider_id`) REFERENCES `provider` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `availability`
  --
  
  LOCK TABLES `availability` WRITE;
  /*!40000 ALTER TABLE `availability` DISABLE KEYS */;
  INSERT INTO `availability` VALUES (1,1,1,NULL,'2020-09-10 08:15:00','2020-09-10 08:30:00',NULL,NULL),(2,1,1,NULL,'2020-09-10 08:30:00','2020-09-10 08:45:00',NULL,NULL),(3,1,1,NULL,'2020-09-10 08:45:00','2020-09-10 09:00:00',NULL,'2020-09-06 22:48:39'),(4,1,2,NULL,'2020-09-10 08:45:00','2020-09-10 09:00:00',NULL,NULL),(5,1,2,NULL,'2020-09-10 09:00:00','2020-09-10 09:15:00',NULL,NULL),(6,1,2,NULL,'2020-09-10 09:15:00','2020-09-10 09:30:00',NULL,NULL);
  /*!40000 ALTER TABLE `availability` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `clinic`
  --
  
  DROP TABLE IF EXISTS `clinic`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `clinic` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(191) NOT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `clinic_name_uk` (`name`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `clinic`
  --
  
  LOCK TABLES `clinic` WRITE;
  /*!40000 ALTER TABLE `clinic` DISABLE KEYS */;
  INSERT INTO `clinic` VALUES (1,'Main Street Clinic',NULL,NULL);
  /*!40000 ALTER TABLE `clinic` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `migrations`
  --
  
  DROP TABLE IF EXISTS `migrations`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  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=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `migrations`
  --
  
  LOCK TABLES `migrations` WRITE;
  /*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
  INSERT INTO `migrations` VALUES (1,'2020_09_05_235748_create_test_table',0),(2,'2020_09_06_133154_create_availability_table',0),(3,'2020_09_06_133154_create_clinic_table',0),(4,'2020_09_06_133154_create_patient_table',0),(5,'2020_09_06_133154_create_provider_table',0),(6,'2020_09_06_133155_add_foreign_keys_to_availability_table',0),(7,'2020_09_06_133155_add_foreign_keys_to_patient_table',0),(8,'2020_09_06_133155_add_foreign_keys_to_provider_table',0);
  /*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `patient`
  --
  
  DROP TABLE IF EXISTS `patient`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `patient` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `clinic_id` int(10) unsigned NOT NULL,
    `first_name` varchar(191) NOT NULL,
    `last_name` varchar(191) NOT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `first_name` (`first_name`,`last_name`),
    KEY `clinic_id` (`clinic_id`),
    CONSTRAINT `patient_ibfk_1` FOREIGN KEY (`clinic_id`) REFERENCES `clinic` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `patient`
  --
  
  LOCK TABLES `patient` WRITE;
  /*!40000 ALTER TABLE `patient` DISABLE KEYS */;
  INSERT INTO `patient` VALUES (1,1,'Rebecca','Adler',NULL,NULL),(2,1,'John','Smith',NULL,NULL);
  /*!40000 ALTER TABLE `patient` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `provider`
  --
  
  DROP TABLE IF EXISTS `provider`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `provider` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `clinic_id` int(10) unsigned NOT NULL,
    `first_name` varchar(191) NOT NULL,
    `last_name` varchar(191) NOT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `first_name` (`first_name`,`last_name`),
    KEY `clinic_id` (`clinic_id`),
    CONSTRAINT `provider_ibfk_1` FOREIGN KEY (`clinic_id`) REFERENCES `clinic` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `provider`
  --
  
  LOCK TABLES `provider` WRITE;
  /*!40000 ALTER TABLE `provider` DISABLE KEYS */;
  INSERT INTO `provider` VALUES (1,1,'Gregory','House',NULL,NULL),(2,1,'James','Wilson',NULL,NULL);
  /*!40000 ALTER TABLE `provider` ENABLE KEYS */;
  UNLOCK TABLES;
  /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  
  -- Dump completed on 2020-09-07 18:44:49
  