--
-- Host: localhost    Database: trackmeet_db
-- ------------------------------------------------------


--
-- Table structure for table `tbl_attendence_master`
--

CREATE TABLE `tbl_attendence_master` (
  `PK_AttendenceId` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `username` varchar(500) DEFAULT NULL,
  `name` varchar(500) DEFAULT NULL,
  `punchIn` varchar(200) DEFAULT NULL,
  `punchOut` varchar(200) DEFAULT NULL,
  `punchInPic` longtext,
  `punchOutPic` longtext,
  `managerId` 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_AttendenceId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_attendence_master`
--


--
-- Table structure for table `tbl_location_log`
--

CREATE TABLE `tbl_location_log` (
  `PK_locationLogId` int NOT NULL AUTO_INCREMENT,
  `FK_AttendenceId` int DEFAULT NULL,
  `location` longtext,
  `longitude` float DEFAULT NULL,
  `latitude` float 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_locationLogId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_location_log`
--


--
-- Table structure for table `tbl_meeting_log`
--

CREATE TABLE `tbl_meeting_log` (
  `Pk_MeetingId` int NOT NULL AUTO_INCREMENT,
  `FK_AttendenceId` int DEFAULT NULL,
  `meetingIn` varchar(225) DEFAULT NULL,
  `meetingOut` varchar(225) DEFAULT NULL,
  `location` longtext,
  `longitude` float DEFAULT NULL,
  `latitude` float DEFAULT NULL,
  `meetingDesc` 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_MeetingId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_meeting_log`
--


--
-- 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=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `tbl_module_master` VALUES (1,'Dashboard','Dashboard Descriptions',1,'2024-01-25 11:05:44',NULL,'2024-02-07 10:39:22',NULL),(2,'RoleScreen','RoleScreen Description',1,'2024-01-30 06:24:29',NULL,'2024-02-07 10:39:22',NULL),(3,'ModuleScreen','ModuleScreen Description',1,'2024-01-30 06:24:47',NULL,'2024-02-07 10:39:22',NULL),(4,'UserScreen','UserScreen Description',1,'2024-01-30 10:05:11',NULL,'2024-02-07 10:39:22',NULL),(5,'ReportScreen','ReportScreen Description',1,'2024-03-05 06:32:38',NULL,'2025-01-17 06:02:09',NULL),(6,'ProfileScreen','StudentInfo Description',1,'2024-03-11 04:42:43',NULL,'2025-01-17 06:02:09',NULL),(7,'SettingsScreen','SettingsScreen Descriptions',1,'2024-04-05 10:29:35',NULL,'2025-01-17 06:02:09',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 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `tbl_role_master` VALUES (1,'Admin','Admin',1,'2024-01-30 10:28:06',NULL,'2024-04-25 06:12:41',NULL),(2,'Student','Student',1,'2024-02-01 12:06:09',NULL,'2024-02-01 12:06:09',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=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `tbl_role_module_permission` VALUES (1,2,1,0,1,1,0,0,1,'2024-02-01 12:06:09',NULL,'2024-02-06 04:55:04',NULL),(2,2,2,0,1,0,0,0,1,'2024-02-01 12:06:09',NULL,'2024-02-01 12:06:09',NULL),(3,2,3,0,1,0,0,0,1,'2024-02-01 12:06:09',NULL,'2024-02-01 12:06:09',NULL),(4,2,4,0,1,0,0,0,1,'2024-02-01 12:06:09',NULL,'2024-02-08 10:19:57',NULL),(9,2,5,0,1,0,0,0,1,'2024-03-05 06:33:21',NULL,'2024-03-05 06:33:21',NULL),(10,2,6,0,1,0,0,0,1,'2024-03-11 04:44:07',NULL,'2024-03-11 04:44:07',NULL),(11,2,7,0,1,0,0,0,1,'2024-04-05 10:29:52',NULL,'2024-04-05 10:29:52',NULL),(15,1,1,1,1,1,1,1,1,'2024-04-18 08:51:11',NULL,'2024-04-18 08:51:11',NULL),(16,1,2,1,1,1,1,1,1,'2024-04-18 08:51:11',NULL,'2024-04-18 08:51:11',NULL),(17,1,3,1,1,1,1,1,1,'2024-04-18 08:51:11',NULL,'2024-04-18 08:51:11',NULL),(18,1,4,1,1,1,1,1,1,'2024-04-18 08:51:11',NULL,'2024-04-18 08:51:11',NULL),(19,1,5,1,1,1,1,1,1,'2024-04-18 08:51:11',NULL,'2024-04-18 08:51:11',NULL),(20,1,6,1,1,1,1,1,1,'2024-04-18 08:51:11',NULL,'2024-04-18 08:51:11',NULL),(21,1,7,1,1,1,1,1,1,'2024-04-18 08:51:11',NULL,'2024-04-18 08:51:11',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=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `tbl_user_role_permission` VALUES (1,1,1,1,'2025-01-17 09:36:23',NULL,'2025-01-17 09:36:23',NULL);

--
-- Dumping events for database 'trackmeet_db'
--


