CREATE DATABASE  IF NOT EXISTS `event_tracker_1` /*!40100 DEFAULT CHARACTER SET utf8mb4 */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `event_tracker_1`;
--
-- Host: localhost    Database: event_tracker_1
-- ------------------------------------------------------


--
-- Table structure for table `tbl_attendees_master`
--

CREATE TABLE `tbl_attendees_master` (
  `PK_Attendees_id` int NOT NULL AUTO_INCREMENT,
  `registered_date_time` varchar(45) DEFAULT NULL,
  `email_id` varchar(100) DEFAULT NULL,
  `medl_concl_reg_no` varchar(255) DEFAULT NULL,
  `college_place` varchar(500) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `designation` varchar(255) DEFAULT NULL,
  `department` varchar(255) DEFAULT NULL,
  `mobile_number` varchar(15) DEFAULT NULL,
  `event_start_date` varchar(100) DEFAULT NULL,
  `event_end_date` varchar(100) DEFAULT NULL,
  `transaction_link` longtext,
  `transaction_id` varchar(100) DEFAULT NULL,
  `transaction_date` varchar(100) DEFAULT NULL,
  `isActive` tinyint NOT NULL DEFAULT '1',
  `isDeleted` tinyint NOT NULL DEFAULT '0',
  `isSuspended` tinyint DEFAULT '0',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  `created_by` varchar(200) DEFAULT NULL,
  `updated_by` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`PK_Attendees_id`)
) ENGINE=InnoDB AUTO_INCREMENT=350 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `tbl_attendees_master`
--

INSERT INTO `tbl_attendees_master` VALUES (1,'26-10-2024 11:54','saurabh.middha@shardatech.org','36089','Subharti Medical College,Meerut','Dr. Shalini Rastogi','','Physiology ','9711411136','13-11-2024','14-11-2024','https://drive.google.com/open?id=1201aikUeiWTofh5k4KHy7D2rOh-avsYz','XX3118','26-10-2024',1,0,0,NULL,NULL,NULL,NULL);

--
-- Table structure for table `tbl_event_attendees_check`
--

CREATE TABLE `tbl_event_attendees_check` (
  `PK_Attendees_check_id` int NOT NULL AUTO_INCREMENT,
  `FK_Attendees_id` int DEFAULT NULL,
  `check_in` tinyint DEFAULT '0',
  `checkInDate` varchar(200) DEFAULT NULL,
  `checkInTime` varchar(200) DEFAULT NULL,
  `breakfast` tinyint DEFAULT '0',
  `lunch` tinyint DEFAULT '0',
  `refreshment` tinyint DEFAULT '0',
  `dinner` tinyint DEFAULT '0',
  `isActive` tinyint NOT NULL DEFAULT '1',
  `isDeleted` tinyint NOT NULL DEFAULT '0',
  `isSuspended` tinyint DEFAULT '0',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  `created_by` varchar(200) DEFAULT NULL,
  `updated_by` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`PK_Attendees_check_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `tbl_event_attendees_check`
--

INSERT INTO `tbl_event_attendees_check` VALUES (1,1,1,'13-11-2024','09:30:00',1,1,0,0,1,0,0,NULL,NULL,NULL,NULL);

--
-- Table structure for table `tbl_module_master`
--

CREATE TABLE `tbl_module_master` (
  `PK_ModuleId` int NOT NULL AUTO_INCREMENT,
  `moduleName` varchar(225) DEFAULT NULL,
  `description` longtext,
  `isActive` tinyint DEFAULT '1',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `created_by` varchar(200) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_by` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`PK_ModuleId`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `tbl_module_master`
--

INSERT INTO `tbl_module_master` VALUES (1,'Dashboard','Dashboard Descriptions',1,'2024-01-24 07:35:44',NULL,'2024-02-06 07:09:22',NULL),(2,'RoleScreen','RoleScreen Description',1,'2024-01-29 02:54:29',NULL,'2024-02-06 07:09:22',NULL),(3,'ModuleScreen','ModuleScreen Description',1,'2024-01-29 02:54:47',NULL,'2024-02-06 07:09:22',NULL),(4,'UserScreen','UserScreen Description',1,'2024-01-29 06:35:11',NULL,'2024-02-06 07:09:22',NULL);

--
-- Table structure for table `tbl_role_master`
--

CREATE TABLE `tbl_role_master` (
  `PK_RoleId` int NOT NULL AUTO_INCREMENT,
  `roleName` varchar(225) DEFAULT NULL,
  `description` longtext,
  `isActive` tinyint DEFAULT '1',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `created_by` varchar(200) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_by` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`PK_RoleId`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `tbl_role_master`
--

INSERT INTO `tbl_role_master` VALUES (1,'Admin','Admin',1,'2024-01-29 06:58:06',NULL,'2024-04-24 02:42:41',NULL),(2,'Security','Security',1,'2024-01-31 08:36:09',NULL,'2024-11-07 01:11:23',NULL),(3,'Meal','Meal',1,'2024-01-31 08:49:35',NULL,'2024-11-07 01:11:23',NULL);

--
-- Table structure for table `tbl_role_module_permission`
--

CREATE TABLE `tbl_role_module_permission` (
  `PK_role_module_permissionId` int NOT NULL AUTO_INCREMENT,
  `FK_RoleId` int DEFAULT NULL,
  `FK_ModuleId` int DEFAULT NULL,
  `create` tinyint DEFAULT '0',
  `read` tinyint DEFAULT '0',
  `update` tinyint DEFAULT '0',
  `delete` tinyint DEFAULT '0',
  `special` tinyint DEFAULT '0',
  `isActive` tinyint DEFAULT '1',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `created_by` varchar(200) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_by` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`PK_role_module_permissionId`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `tbl_role_module_permission`
--

INSERT INTO `tbl_role_module_permission` VALUES (1,1,1,1,1,1,1,1,1,'2024-01-31 08:36:09',NULL,'2024-11-10 10:16:49',NULL),(2,1,2,1,1,1,1,1,1,'2024-01-31 08:49:35',NULL,'2024-11-10 10:16:49',NULL),(3,1,3,1,1,1,1,1,1,'2024-04-17 05:21:11',NULL,'2024-11-10 10:16:49',NULL),(4,1,4,1,1,1,1,1,1,'2024-04-17 05:21:11',NULL,'2024-11-10 10:16:49',NULL),(5,2,1,1,1,1,0,0,1,'2024-04-17 05:21:11',NULL,'2024-11-10 10:16:49',NULL),(6,3,1,1,1,1,0,0,1,'2024-04-17 05:21:11',NULL,'2024-11-10 10:16:49',NULL);

--
-- Table structure for table `tbl_user_role_permission`
--

CREATE TABLE `tbl_user_role_permission` (
  `PK_user_role_permissionId` int NOT NULL AUTO_INCREMENT,
  `FK_userId` int DEFAULT NULL,
  `FK_RoleId` int DEFAULT NULL,
  `isActive` tinyint DEFAULT '1',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `created_by` varchar(200) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_by` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`PK_user_role_permissionId`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `tbl_user_role_permission`
--

INSERT INTO `tbl_user_role_permission` VALUES (1,1,1,1,'2024-01-31 08:57:56',NULL,'2024-11-10 08:44:19',NULL),(2,4,1,0,'2024-11-10 16:15:40','Saurabh Middha (0008873)','2024-11-11 16:59:55',NULL),(3,5,2,1,'2024-11-10 16:16:58','Saurabh Middha (0008873)','2024-11-10 16:16:58',NULL),(4,6,1,0,'2024-11-10 16:18:17','Saurabh Middha (0008873)','2024-11-10 16:20:22',NULL),(5,7,2,1,'2024-11-10 16:19:24','Saurabh Middha (0008873)','2024-11-10 16:20:34',NULL),(6,7,3,1,'2024-11-10 16:19:24','Saurabh Middha (0008873)','2024-11-10 16:19:24',NULL),(7,3,2,1,'2024-11-10 16:19:40',NULL,'2024-11-10 16:19:40','Saurabh Middha (0008873)'),(8,2,1,0,'2024-11-10 16:19:49',NULL,'2024-11-11 16:59:31','Saurabh Middha (0008873)'),(9,5,3,1,'2024-11-10 16:20:15',NULL,'2024-11-10 16:20:15','Saurabh Middha (0008873)'),(10,6,2,1,'2024-11-10 16:20:22',NULL,'2024-11-10 16:20:22','Saurabh Middha (0008873)'),(11,6,3,1,'2024-11-10 16:20:22',NULL,'2024-11-10 16:20:22','Saurabh Middha (0008873)'),(12,8,1,0,'2024-11-10 16:21:38','Saurabh Middha (0008873)','2024-11-10 16:21:38',NULL),(13,8,2,1,'2024-11-10 16:21:38','Saurabh Middha (0008873)','2024-11-10 16:21:38',NULL),(14,8,3,1,'2024-11-10 16:21:38','Saurabh Middha (0008873)','2024-11-10 16:21:38',NULL),(15,9,1,1,'2024-11-10 16:22:43','Saurabh Middha (0008873)','2024-11-10 16:22:43',NULL),(16,10,2,1,'2024-11-11 15:25:41','Saurabh Middha (0008873)','2024-11-11 15:25:41',NULL),(17,10,3,1,'2024-11-11 15:25:41','Saurabh Middha (0008873)','2024-11-11 15:25:41',NULL),(18,11,2,1,'2024-11-11 15:27:32','Saurabh Middha (0008873)','2024-11-11 15:27:32',NULL),(19,11,3,1,'2024-11-11 15:27:32','Saurabh Middha (0008873)','2024-11-11 15:27:32',NULL),(20,12,2,1,'2024-11-11 15:28:31','Saurabh Middha (0008873)','2024-11-11 15:28:31',NULL),(21,12,3,1,'2024-11-11 15:28:31','Saurabh Middha (0008873)','2024-11-11 15:28:31',NULL),(22,13,2,1,'2024-11-11 15:29:40','Saurabh Middha (0008873)','2024-11-11 15:29:40',NULL),(23,13,3,1,'2024-11-11 15:29:40','Saurabh Middha (0008873)','2024-11-11 15:29:40',NULL),(24,14,2,1,'2024-11-11 15:31:13','Saurabh Middha (0008873)','2024-11-11 15:31:13',NULL),(25,14,3,1,'2024-11-11 15:31:13','Saurabh Middha (0008873)','2024-11-11 15:31:13',NULL),(26,15,2,1,'2024-11-11 15:32:07','Saurabh Middha (0008873)','2024-11-11 15:32:07',NULL),(27,15,3,1,'2024-11-11 15:32:07','Saurabh Middha (0008873)','2024-11-11 15:32:07',NULL),(28,2,2,1,'2024-11-11 16:59:31',NULL,'2024-11-11 16:59:31','Saurabh Middha (0008873)'),(29,2,3,1,'2024-11-11 16:59:31',NULL,'2024-11-11 16:59:31','Saurabh Middha (0008873)'),(30,3,3,1,'2024-11-11 16:59:43',NULL,'2024-11-11 16:59:43','Saurabh Middha (0008873)'),(31,4,2,1,'2024-11-11 16:59:55',NULL,'2024-11-11 16:59:55','Saurabh Middha (0008873)'),(32,4,3,1,'2024-11-11 16:59:55',NULL,'2024-11-11 16:59:55','Saurabh Middha (0008873)'),(33,16,2,1,'2024-11-12 20:42:23','Saurabh Middha (0008873)','2024-11-12 20:42:23',NULL),(34,16,3,1,'2024-11-12 20:42:23','Saurabh Middha (0008873)','2024-11-12 20:42:23',NULL),(35,17,2,1,'2024-11-12 20:43:40','Saurabh Middha (0008873)','2024-11-12 20:43:40',NULL),(36,17,3,1,'2024-11-12 20:43:40','Saurabh Middha (0008873)','2024-11-12 20:43:40',NULL),(37,18,2,1,'2024-11-12 20:44:56','Saurabh Middha (0008873)','2024-11-12 20:44:56',NULL),(38,18,3,1,'2024-11-12 20:44:56','Saurabh Middha (0008873)','2024-11-12 20:44:56',NULL),(39,19,3,1,'2024-11-12 22:31:38','Saurabh Middha (0008873)','2024-11-12 22:31:38',NULL),(40,19,2,1,'2024-11-12 22:31:38','Saurabh Middha (0008873)','2024-11-12 22:31:38',NULL);


