-- 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 `meta_data`
--

DROP TABLE IF EXISTS `meta_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `meta_data` (
  `meta_data_id` int NOT NULL AUTO_INCREMENT,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'the type of dropdown',
  `value1` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value2` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value3` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int NOT NULL,
  `updated_by` int 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 (`meta_data_id`),
  KEY `fk_user_id` (`created_by`),
  KEY `fk_user_id_update` (`updated_by`),
  CONSTRAINT `fk_user_id` FOREIGN KEY (`created_by`) REFERENCES `user` (`user_id`) ON UPDATE CASCADE,
  CONSTRAINT `fk_user_id_update` FOREIGN KEY (`updated_by`) REFERENCES `user` (`user_id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `meta_data`
--

/*!40000 ALTER TABLE `meta_data` DISABLE KEYS */;
use emedsol;
INSERT INTO `meta_data` VALUES (1,'default_language_user','french','fr',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(2,'default_language_user','english','en',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(3,'configParametersTypeValue','Bool','BOOLEAN',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(4,'configParametersTypeValue','Varchar','VARCHAR',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(5,'configParametersTypeValue','Html','HTML',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(6,'configParametersTypeValue','Date','DATE',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(7,'configParametersTypeValue','Datetime','DATETIME',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(8,'configParametersTypeValue','Double','DOUBLE',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(9,'configParametersTypeValue','Int','INT',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(10,'configParametersTypeValue','File','FILE',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(11,'configParametersTypeValue','Link','LINK',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(12,'configParametersTypeValue','List','LIST',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(13,'configParametersTypeValue','Tel','TEL',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(14,'configParametersTypeValue','Time','TIME',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(15,'configParametersTypeValue','Text','TEXT',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(16,'objective_assessment','Bonne','Bonne',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(17,'objective_assessment','Pas d\'évolution','Pas d\'évolution',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(18,'objective_assessment','Se détériore','Se détériore',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(19,'objective_assessment','Très bonne','Très bonne',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(20,'protocol','Bétadine dermique','Bétadine dermique',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(21,'protocol','Eosine acqueuse','Eosine acqueuse',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(22,'protocol','Eosine alcolisée','Eosine alcolisée',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(23,'protocol','Plaie laissé à l\'air libre','Plaie laissé à l\'air libre',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(24,'protocol','S Physio+ Sol Kibadi','S Physio+ Sol Kibadi',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(25,'protocol','Sérum physiologique','Sérum physiologique',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(26,'protocol','Solution dakin et mèche','Solution dakin et mèche',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(27,'protocol','Solution de dakin','Solution de dakin',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(28,'protocol','Solution Kibadi','Solution Kibadi',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(29,'protocol','Tuille gras','Tuille gras',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(30,'state_wound','Autres','Autres',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(31,'state_wound','Bourgeonnante','Bourgeonnante',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(32,'state_wound','Cicatrisée','Cicatrisée',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(33,'state_wound','Infecté','Infecté',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(34,'state_wound','Nécrosée','Nécrosée',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(35,'state_wound','Propre sec','Propre sec',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(36,'state_wound','Sécrétant (autres)','Sécrétant (autres)',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(37,'state_wound','Sécrétant (graisse)','Sécrétant (graisse)',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(38,'state_wound','Sécrétant (pus)','Sécrétant (pus)',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(39,'state_wound','Sécrétant (sang)','Sécrétant (sang)',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(40,'subjective_assessment','Ablation fil','Ablation fil',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(41,'subjective_assessment','Attitude en cours','Attitude en cours',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(42,'subjective_assessment','Avis chirurgien souhaité','Avis chirurgien souhaité',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(43,'subjective_assessment','Suture secondaire à programmer','Suture secondaire à programmer',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(44,'type_transfusion','Culot','Culot',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(45,'type_transfusion','Plaquettes','Plaquettes',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(46,'type_transfusion','Plasma','Plasma',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(47,'type_transfusion','Sang total','Sang total',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(48,'sample_type','Blood','Blood',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(49,'sample_type','Urine','Urine',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(50,'billingCategoryType','Normal','0',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(51,'billingCategoryType','Urgent','1',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(52,'billingCategoryType','Result','2',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(53,'billingCategoryType','Remote','3',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(54,'billingCategoryType','Request','4',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(55,'billingCategoryType','Procedure or surgery','5',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(56,'joinedBy','joined_whatsapp','1',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(57,'joinedBy','joined_sms','2',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(58,'joinedBy','joined_phone','3',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(59,'joinedBy','joined_email','4',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(60,'hospitalisationType','Normal','1','#82ccff',1,NULL,'2024-04-19 12:48:32',NULL,NULL),(61,'hospitalisationType','Observation','2','#722F12',1,NULL,'2024-04-19 12:48:32',NULL,NULL),(62,'hospitalisationType','USC','3','#fae1dd',1,NULL,'2024-04-19 12:48:32',NULL,NULL),(63,'hospitalisationType','ICU','4','#f94144',1,NULL,'2024-04-19 12:48:32',NULL,NULL),(64,'unitQuantity','Microgramme(s)','mcg',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(65,'unitQuantity','Milligramme(s)','mg',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(66,'unitQuantity','Gramme(s)','g',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(67,'unitQuantity','Millilitres(s)','mL',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(68,'unitQuantity','Litres(s)','L',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(69,'unitQuantity','Kilogramme(s)','kg',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(70,'unitQuantity','Once','oz',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(71,'unitQuantity','Goutte(s)','gtte',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(72,'unitQuantity','Comprimé sublingual','co s.L',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(73,'unitQuantity','Comprimé(s)','co',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(74,'unitQuantity','Suppositoire(s)','supp',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(75,'unitQuantity','Ampoule(s)','amp',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(76,'unitQuantity','Ovule(s)','ov',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(77,'unitQuantity','Miliéquivalent','mEq',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(78,'unitQuantity','Milimole','mmol',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(79,'unitQuantity','Comprimé à longue action','co LA',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(80,'unitQuantity','Sachet(s)','sachet',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(81,'prescriptionAdministration','Per Os','p.o.',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(82,'prescriptionAdministration','Intra-Musculaire','i.m.',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(83,'prescriptionAdministration','Intra-Veineux','i.v.',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(84,'prescriptionAdministration','Intra-Rectal','i.r.',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(85,'prescriptionAdministration','Intra-Vaginal','i.v.',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(86,'prescriptionAdministration','Sublingual','s.L.',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(87,'prescriptionAdministration','Intra-Oriculaire','i.o.',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(88,'prescriptionAdministration','Sous-Cutané','s.c.',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(89,'prescriptionAdministration','Nasal','n.s.',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(90,'prescriptionAdministration','Occulaire','o.c.',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(91,'prescriptionAdministration','Aérosol','a.r.',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(92,'unitFrequency','hour','1',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(93,'unitFrequency','day','2',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(94,'unitFrequency','weeks','3',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(95,'tubeColor','red','red',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(96,'tubeColor','green','green',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(97,'tubeColor','mauve','mauve',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(98,'tubeColor','black','black',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL),(99,'tubeColor','yellow','yellow',NULL,1,NULL,'2024-04-19 12:48:32',NULL,NULL);
/*!40000 ALTER TABLE `meta_data` 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-28 12:43:53
