--
-- Host: localhost    Database: medical_congress
-- ------------------------------------------------------


--
-- Table structure for table `certificate_template`
--

CREATE TABLE `certificate_template` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `event_id` bigint NOT NULL,
  `path` longtext NOT NULL,
  `status` int NOT NULL,
  `created_at` varchar(45) NOT NULL,
  `updated_at` varchar(45) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `certificate_template`
--


--
-- Table structure for table `evaluation_question`
--

CREATE TABLE `evaluation_question` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `question` longtext NOT NULL,
  `type` int NOT NULL,
  `mandatory` int NOT NULL,
  `event_id` bigint NOT NULL,
  `status` int NOT NULL,
  `created_at` varchar(45) NOT NULL,
  `updated_at` varchar(45) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `evaluation_question`
--

INSERT INTO `evaluation_question` VALUES (1,'nmbhgcfdghjk',2,1,2,1,'2023-04-25 17:29:47','2023-04-25 17:29:47');

--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `start_date` varchar(45) NOT NULL,
  `end_date` varchar(45) NOT NULL,
  `logo` longtext NOT NULL,
  `banner` longtext NOT NULL,
  `url` longtext NOT NULL,
  `status` tinyint NOT NULL,
  `created_at` varchar(45) NOT NULL,
  `updated_at` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `events`
--

INSERT INTO `events` VALUES (1,'kjadhskas','2023-04-28','2023-04-29','http://localhost:8002/storage/images/6pNlgnniRM4CywTA/logo1.png','http://localhost:8002/storage/images/7aNHoPd9XzqhdrSW/p-7.jpg','jhkjhsda',1,'2023-04-24 19:21:36','2023-04-24 19:21:36'),(2,'kjadhskas','2023-04-28','2023-04-29','http://localhost:8002/storage/images/w939FJJoVXxY4N02/logo1.png','http://localhost:8002/storage/images/7GmZxERz9IyBbUJP/p-7.jpg','jhkjhsda',1,'2023-04-24 19:21:38','2023-04-24 19:21:38'),(3,'kjadhskas','2023-04-28','2023-04-29','http://localhost:8002/storage/images/afc5Sjt2MTib3o8R/logo1.png','http://localhost:8002/storage/images/FKw5uAsdFLZ4GlUc/p-7.jpg','jhkjhsda',1,'2023-04-24 19:21:39','2023-04-24 19:21:39'),(4,'kjhkjh','2023-04-28','2023-04-29','http://localhost:8002/storage/images/ufIQe0hzy5T9GCZS/p-7.jpg','http://localhost:8002/storage/images/JWBWYcBxQ4FrgSKS/spacejoy-YI2YkyaREHk-unsplash (1).jpg','nmncgvhbjhk',1,'2023-04-25 00:48:12','2023-04-25 00:48:12'),(5,'kjhkjh','2023-04-28','2023-04-29','http://localhost:8002/storage/images/3aCUuMiP3chN6lbd/p-7.jpg','http://localhost:8002/storage/images/5MgGjnQZGkxnVXHM/spacejoy-YI2YkyaREHk-unsplash (1).jpg','nmncgvhbjhk',1,'2023-04-25 00:48:43','2023-04-25 00:48:43');

--
-- Table structure for table `user_certificate`
--

CREATE TABLE `user_certificate` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` bigint NOT NULL,
  `event_id` bigint NOT NULL,
  `template_id` bigint NOT NULL,
  `status` int NOT NULL,
  `created_at` varchar(45) NOT NULL,
  `updated_at` varchar(45) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `user_certificate`
--


--
-- Table structure for table `user_details`
--

CREATE TABLE `user_details` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` bigint NOT NULL,
  `email` longtext,
  `mobile` varchar(25) DEFAULT NULL,
  `company` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `status` int NOT NULL,
  `created_at` varchar(45) NOT NULL,
  `updated_at` varchar(45) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `user_details`
--

INSERT INTO `user_details` VALUES (1,2,NULL,NULL,'Acceser','India',1,'2023-04-25 12:34:40','2023-04-25 12:34:40');

--
-- Table structure for table `user_evaluation`
--

CREATE TABLE `user_evaluation` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` bigint NOT NULL,
  `event_id` bigint NOT NULL,
  `evaluation_id` bigint NOT NULL,
  `answer` longtext NOT NULL,
  `date` timestamp NOT NULL,
  `status` int NOT NULL,
  `created_at` varchar(45) NOT NULL,
  `updated_at` varchar(45) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `user_evaluation`
--


--
-- Table structure for table `user_event`
--

CREATE TABLE `user_event` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` bigint NOT NULL,
  `event_id` bigint NOT NULL,
  `status` int NOT NULL,
  `created_at` varchar(45) NOT NULL,
  `updated_at` varchar(45) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `user_event`
--


--
-- Table structure for table `user_video`
--

CREATE TABLE `user_video` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `event_id` bigint NOT NULL,
  `user_id` bigint NOT NULL,
  `video_id` bigint NOT NULL,
  `watch_time` int NOT NULL,
  `total_time` int DEFAULT NULL,
  `status` int NOT NULL,
  `created_at` varchar(45) NOT NULL,
  `updated_at` varchar(45) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `user_video`
--


--
-- Table structure for table `videos`
--

CREATE TABLE `videos` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `event_id` bigint NOT NULL,
  `video_url` longtext NOT NULL,
  `is_live` int NOT NULL DEFAULT '0',
  `status` tinyint NOT NULL,
  `created_at` varchar(45) NOT NULL,
  `updated_at` varchar(45) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `videos`
--

INSERT INTO `videos` VALUES (1,3,'khjkfhsd',1,1,'2023-04-25 12:31:53','2023-04-25 12:31:53'),(2,3,'khjkfhsd',1,1,'2023-04-25 12:34:40','2023-04-25 12:34:40'),(3,3,'khjkfhsd',1,1,'2023-04-25 12:36:13','2023-04-25 12:36:13'),(4,3,'khjkfhsd',1,1,'2023-04-25 12:38:13','2023-04-25 12:38:13');


