-- MySQL dump 10.13  Distrib 8.0.33, for Win64 (x86_64)
--
-- Host: 127.0.0.1    Database: emedsol_test
-- ------------------------------------------------------
-- Server version	8.0.35

/*!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 */;
/*!50503 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 `doctor_specialty`
--

DROP TABLE IF EXISTS `doctor_specialty`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `doctor_specialty` (
  `doctor_specialty_id` int NOT NULL AUTO_INCREMENT,
  `specialty_name` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `shortname` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`doctor_specialty_id`),
  UNIQUE KEY `doctor_specialty_specialty_name_unique` (`specialty_name`)
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `doctor_specialty`
--

/*!40000 ALTER TABLE `doctor_specialty` DISABLE KEYS */;
INSERT INTO `doctor_specialty` VALUES (-1,'Infirmière','Nurse',NULL,'2024-04-19 12:48:48',NULL,NULL),(5,'Généraliste','GP',NULL,'2024-04-19 12:48:48',NULL,NULL),(7,'Pédiatrie','Peds',NULL,'2024-04-19 12:48:48',NULL,NULL),(8,'Médecin de famille','FM',NULL,'2024-04-19 12:48:48',NULL,NULL),(9,'Médecine interne','IM',NULL,'2024-04-19 12:48:48',NULL,NULL),(10,'Allergologie','All.',NULL,'2024-04-19 12:48:48',NULL,NULL),(11,'Anesthésiologie','Anes',NULL,'2024-04-19 12:48:48',NULL,NULL),(12,'Audiologie','Aud',NULL,'2024-04-19 12:48:48',NULL,NULL),(13,'Cardiologie','Card',NULL,'2024-04-19 12:48:48',NULL,NULL),(14,'Dermatologie','Derm',NULL,'2024-04-19 12:48:48',NULL,NULL),(15,'Ontho-hino-laryngologie','ENT ',NULL,'2024-04-19 12:48:48',NULL,NULL),(16,'Endocrinologie','Endo',NULL,'2024-04-19 12:48:48',NULL,NULL),(17,'Chirurgie plastique faciale','FPS',NULL,'2024-04-19 12:48:48',NULL,NULL),(18,'Gastroentérologie','Ge',NULL,'2024-04-19 12:48:48',NULL,NULL),(19,'Obstétrique et Gynécologie','O&G',NULL,'2024-04-19 12:48:48',NULL,NULL),(20,'Hématologie et oncologie','H&O',NULL,'2024-04-19 12:48:48',NULL,NULL),(21,'Médecine hospitalière','HM',NULL,'2024-04-19 12:48:48',NULL,NULL),(22,'Maladies infectieuses et soins des plaie','ID&WC',NULL,'2024-04-19 12:48:48',NULL,NULL),(23,'Néphrologie','Neph',NULL,'2024-04-19 12:48:48',NULL,NULL),(24,'Neurologie','Neuro',NULL,'2024-04-19 12:48:48',NULL,NULL),(25,'Ophtalmologie','Ophth',NULL,'2024-04-19 12:48:48',NULL,NULL),(26,'Chirurgie orthopédique','ORS',NULL,'2024-04-19 12:48:48',NULL,NULL),(27,'Gestion de la douleur','PM',NULL,'2024-04-19 12:48:48',NULL,NULL),(28,'Pathologie','Path',NULL,'2024-04-19 12:48:48',NULL,NULL),(29,'Proctologie','Proct',NULL,'2024-04-19 12:48:48',NULL,NULL),(30,'Psychiatrie','Psych',NULL,'2024-04-19 12:48:48',NULL,NULL),(31,'Pneumologie et troubles du sommeil','Pulm&SD',NULL,'2024-04-19 12:48:48',NULL,NULL),(32,'Radiologie','Rad',NULL,'2024-04-19 12:48:48',NULL,NULL),(33,'Rhumatologie','Rheum',NULL,'2024-04-19 12:48:48',NULL,NULL),(34,'Chirurgie de la colonne vertébrale','SS',NULL,'2024-04-19 12:48:48',NULL,NULL),(35,'Chirurgie','Surg',NULL,'2024-04-19 12:48:48',NULL,NULL),(36,'Urologie','UROL',NULL,'2024-04-19 12:48:48',NULL,NULL),(37,'Kinésithérapie','KT',NULL,'2024-04-19 12:48:48',NULL,NULL),(38,'Physiothérapie','PT',NULL,'2024-04-19 12:48:48',NULL,NULL),(39,'Neuropsychiatre','Neuropsych.',NULL,'2024-04-19 12:48:48',NULL,NULL),(40,'Masothérapeute','Maso.',NULL,'2024-04-19 12:48:48',NULL,NULL),(41,'Oncologie','Onc',NULL,'2024-04-19 12:48:48',NULL,NULL),(42,'Nutritionniste','Nutr',NULL,'2024-04-19 12:48:48',NULL,NULL),(43,'Dentiste','Dent',NULL,'2024-04-19 12:48:48',NULL,NULL),(44,'Orthoptiste','Orthopt',NULL,'2024-04-19 12:48:48',NULL,NULL),(46,'Orthophoniste','Orthoph',NULL,'2024-04-19 12:48:48',NULL,NULL),(47,'Logopédie','Logoped.',NULL,'2024-04-19 12:48:48',NULL,NULL),(50,'Assistant logopé.','Logoped. Assitant',NULL,'2024-04-19 12:48:48',NULL,NULL),(51,'Prothésiste','Prothesist',NULL,'2024-04-19 12:48:48',NULL,NULL),(52,'Urgentiste','Urg.',NULL,'2024-04-19 12:48:48',NULL,NULL),(53,'Medecine du travail','Med. du tr.',NULL,'2024-04-19 12:48:48',NULL,NULL),(57,'Chirurgie ophtalmologie','Surg. oph.',NULL,'2024-04-19 12:48:48',NULL,NULL),(60,'Neurochirurgie','Neurosur.',NULL,'2024-04-19 12:48:48',NULL,NULL),(61,'Formateur spécialiste','Form. spec.',NULL,'2024-04-19 12:48:48',NULL,NULL);
/*!40000 ALTER TABLE `doctor_specialty` ENABLE KEYS */;
/*!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 2024-07-22  4:34:29
