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


--
-- Table structure for table `tbl_alum_achievements`
--

CREATE TABLE `tbl_alum_achievements` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `category` text,
  `title` varchar(500) DEFAULT NULL,
  `description` varchar(500) DEFAULT NULL,
  `achievement_mon` varchar(200) DEFAULT NULL,
  `achievement_yr` varchar(200) DEFAULT NULL,
  `isActive` enum('0','1') NOT NULL DEFAULT '1',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  `isDeleted` enum('0','1') NOT NULL DEFAULT '0',
  `isSuspended` enum('0','1') NOT NULL DEFAULT '0',
  `createdBy` int DEFAULT NULL,
  `updatedBy` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_alum_achievements`
--


--
-- Table structure for table `tbl_alum_comments`
--

CREATE TABLE `tbl_alum_comments` (
  `comment_id` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `post_id` varchar(100) DEFAULT NULL,
  `comment` longtext,
  `isActive` enum('1','0') DEFAULT '1',
  `isVerified` enum('0','1') DEFAULT '0',
  `isSuspended` enum('0','1') DEFAULT '0',
  `CreatedBy` int DEFAULT NULL,
  `updatedBy` int DEFAULT NULL,
  `isDeleted` enum('0','1') DEFAULT '0',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  PRIMARY KEY (`comment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_alum_comments`
--


--
-- Table structure for table `tbl_alum_comments_like`
--

CREATE TABLE `tbl_alum_comments_like` (
  `comment_like_id` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `comment_id` int DEFAULT NULL,
  `comment_like` enum('1','0') DEFAULT '1',
  `isActive` enum('1','0') DEFAULT '1',
  `isVerified` enum('0','1') DEFAULT '0',
  `isSuspended` enum('0','1') DEFAULT '0',
  `CreatedBy` int DEFAULT NULL,
  `updatedBy` int DEFAULT NULL,
  `isDeleted` enum('0','1') DEFAULT '0',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  PRIMARY KEY (`comment_like_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_alum_comments_like`
--


--
-- Table structure for table `tbl_alum_connections`
--

CREATE TABLE `tbl_alum_connections` (
  `connection_id` int NOT NULL AUTO_INCREMENT,
  `sender_id` int DEFAULT NULL,
  `reciever_id` int DEFAULT NULL,
  `connectionStatus` enum('0','1','2') DEFAULT '1',
  `isActive` enum('0','1') NOT NULL DEFAULT '1',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  `isDeleted` enum('0','1') NOT NULL DEFAULT '0',
  `isSuspended` enum('0','1') NOT NULL DEFAULT '0',
  `createdBy` int DEFAULT NULL,
  `updatedBy` int DEFAULT NULL,
  PRIMARY KEY (`connection_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_alum_connections`
--


--
-- Table structure for table `tbl_alum_education`
--

CREATE TABLE `tbl_alum_education` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `prog_code` varchar(50) DEFAULT NULL,
  `prog_name` varchar(200) DEFAULT NULL,
  `prog_desc` varchar(500) DEFAULT NULL,
  `plan_code` varchar(50) DEFAULT NULL,
  `plan_name` varchar(200) DEFAULT NULL,
  `plan_desc` varchar(500) DEFAULT NULL,
  `sub_plan_code` varchar(50) DEFAULT NULL,
  `sub_plan_name` varchar(200) DEFAULT NULL,
  `sub_plan_desc` varchar(500) DEFAULT NULL,
  `univ_name` varchar(200) DEFAULT NULL,
  `univ_logo` varchar(200) DEFAULT NULL,
  `batch_start_year` varchar(20) DEFAULT NULL,
  `batch_end_year` varchar(20) DEFAULT NULL,
  `isActive` enum('0','1') NOT NULL DEFAULT '1',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  `isDeleted` enum('0','1') NOT NULL DEFAULT '0',
  `isSuspended` enum('0','1') NOT NULL DEFAULT '0',
  `createdBy` int DEFAULT NULL,
  `updatedBy` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_alum_education`
--


--
-- Table structure for table `tbl_alum_election_candidate`
--

CREATE TABLE `tbl_alum_election_candidate` (
  `candidate_id` int NOT NULL AUTO_INCREMENT,
  `election_id` int DEFAULT NULL,
  `position_id` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `status` varchar(500) DEFAULT NULL,
  `vote_count` int DEFAULT '0',
  `document` varchar(500) DEFAULT NULL,
  `isActive` enum('0','1') NOT NULL DEFAULT '1',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  `isDeleted` enum('0','1') NOT NULL DEFAULT '0',
  `isSuspended` enum('0','1') NOT NULL DEFAULT '0',
  `createdBy` int DEFAULT NULL,
  `updatedBy` int DEFAULT NULL,
  PRIMARY KEY (`candidate_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_alum_election_candidate`
--


--
-- Table structure for table `tbl_alum_election_master`
--

CREATE TABLE `tbl_alum_election_master` (
  `election_id` int NOT NULL AUTO_INCREMENT,
  `election_image` longtext,
  `year` varchar(500) DEFAULT NULL,
  `title` longtext,
  `description` varchar(500) DEFAULT NULL,
  `votingResult` varchar(500) DEFAULT NULL,
  `isActive` enum('0','1') NOT NULL DEFAULT '1',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  `isDeleted` enum('0','1') NOT NULL DEFAULT '0',
  `isSuspended` enum('0','1') NOT NULL DEFAULT '0',
  `createdBy` int DEFAULT NULL,
  `updatedBy` int DEFAULT NULL,
  PRIMARY KEY (`election_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_alum_election_master`
--


--
-- Table structure for table `tbl_alum_election_position`
--

CREATE TABLE `tbl_alum_election_position` (
  `position_id` int NOT NULL AUTO_INCREMENT,
  `election_id` int DEFAULT NULL,
  `position_setup_id` int DEFAULT NULL,
  `total_seats` int DEFAULT NULL,
  `start_date_of_application` varchar(500) DEFAULT NULL,
  `last_date_of_application` varchar(500) DEFAULT NULL,
  `last_date_of_withdraw` varchar(500) DEFAULT NULL,
  `start_date_of_campaign` varchar(500) DEFAULT NULL,
  `last_date_of_campaign` varchar(500) DEFAULT NULL,
  `date_of_election` varchar(500) DEFAULT NULL,
  `date_of_result` varchar(500) DEFAULT NULL,
  `date_of_oathCeremony` varchar(500) DEFAULT NULL,
  `isActive` enum('0','1') NOT NULL DEFAULT '1',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  `isDeleted` enum('0','1') NOT NULL DEFAULT '0',
  `isSuspended` enum('0','1') NOT NULL DEFAULT '0',
  `createdBy` int DEFAULT NULL,
  `updatedBy` int DEFAULT NULL,
  PRIMARY KEY (`position_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_alum_election_position`
--


--
-- Table structure for table `tbl_alum_election_position_setup`
--

CREATE TABLE `tbl_alum_election_position_setup` (
  `position_setup_id` int NOT NULL AUTO_INCREMENT,
  `position` varchar(500) DEFAULT NULL,
  `eligibilty` longtext,
  `document` longtext,
  `isActive` enum('0','1') NOT NULL DEFAULT '1',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  `isDeleted` enum('0','1') NOT NULL DEFAULT '0',
  `isSuspended` enum('0','1') NOT NULL DEFAULT '0',
  `createdBy` int DEFAULT NULL,
  `updatedBy` int DEFAULT NULL,
  PRIMARY KEY (`position_setup_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_alum_election_position_setup`
--


--
-- Table structure for table `tbl_alum_election_voting`
--

CREATE TABLE `tbl_alum_election_voting` (
  `voter_id` int NOT NULL AUTO_INCREMENT,
  `election_id` int DEFAULT NULL,
  `position_id` int DEFAULT NULL,
  `candidate_id` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `isActive` enum('0','1') NOT NULL DEFAULT '1',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  `isDeleted` enum('0','1') NOT NULL DEFAULT '0',
  `isSuspended` enum('0','1') NOT NULL DEFAULT '0',
  `createdBy` int DEFAULT NULL,
  `updatedBy` int DEFAULT NULL,
  PRIMARY KEY (`voter_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_alum_election_voting`
--


--
-- Table structure for table `tbl_alum_event`
--

CREATE TABLE `tbl_alum_event` (
  `event_id` int NOT NULL AUTO_INCREMENT,
  `event_name` varchar(500) DEFAULT NULL,
  `event_type` varchar(100) DEFAULT 'inPerson',
  `event_link` varchar(500) DEFAULT NULL,
  `event_status` varchar(100) DEFAULT 'Anyone',
  `event_start_date` varchar(50) DEFAULT NULL,
  `event_start_time` varchar(50) DEFAULT NULL,
  `event_end_date` varchar(50) DEFAULT NULL,
  `event_end_time` varchar(50) DEFAULT NULL,
  `event_description` longtext,
  `event_address_line1` longtext,
  `event_addrerss_line2` longtext,
  `event_country` varchar(100) DEFAULT NULL,
  `event_state` varchar(100) DEFAULT NULL,
  `event_city` varchar(100) DEFAULT NULL,
  `event_pincode` varchar(100) DEFAULT NULL,
  `event_image` varchar(500) DEFAULT NULL,
  `event_organizer_username` int DEFAULT NULL,
  `event_organizer_name` varchar(500) DEFAULT NULL,
  `isActive` enum('1','0') DEFAULT '1',
  `isVerified` enum('0','1') DEFAULT '0',
  `isSuspended` enum('0','1') DEFAULT '0',
  `CreatedBy` int DEFAULT NULL,
  `updatedBy` int DEFAULT NULL,
  `isDeleted` enum('0','1') DEFAULT '0',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  `status` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`event_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_alum_event`
--


--
-- Table structure for table `tbl_alum_event_attend`
--

CREATE TABLE `tbl_alum_event_attend` (
  `event_attend_id` int NOT NULL AUTO_INCREMENT,
  `event_id` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `isActive` enum('0','1') NOT NULL DEFAULT '1',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  `isDeleted` enum('0','1') NOT NULL DEFAULT '0',
  `isSuspended` enum('0','1') NOT NULL DEFAULT '0',
  `createdBy` int DEFAULT NULL,
  `updatedBy` int DEFAULT NULL,
  PRIMARY KEY (`event_attend_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_alum_event_attend`
--


--
-- Table structure for table `tbl_alum_group`
--

CREATE TABLE `tbl_alum_group` (
  `group_id` int NOT NULL AUTO_INCREMENT,
  `group_name` varchar(500) DEFAULT NULL,
  `group_description` longtext,
  `group_image` varchar(500) DEFAULT NULL,
  `group_status` varchar(100) DEFAULT NULL,
  `isActive` enum('0','1') NOT NULL DEFAULT '1',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  `isDeleted` enum('0','1') NOT NULL DEFAULT '0',
  `isSuspended` enum('0','1') NOT NULL DEFAULT '0',
  `createdBy` int DEFAULT NULL,
  `updatedBy` int DEFAULT NULL,
  PRIMARY KEY (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_alum_group`
--


--
-- Table structure for table `tbl_alum_likes`
--

CREATE TABLE `tbl_alum_likes` (
  `like_id` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `post_id` varchar(100) DEFAULT NULL,
  `like` enum('1','0') DEFAULT '1',
  `isActive` enum('1','0') DEFAULT '1',
  `isVerified` enum('0','1') DEFAULT '0',
  `isSuspended` enum('0','1') DEFAULT '0',
  `CreatedBy` int DEFAULT NULL,
  `updatedBy` int DEFAULT NULL,
  `isDeleted` enum('0','1') DEFAULT '0',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  PRIMARY KEY (`like_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_alum_likes`
--


--
-- Table structure for table `tbl_alum_notification`
--

CREATE TABLE `tbl_alum_notification` (
  `notification_id` int NOT NULL AUTO_INCREMENT,
  `sender_id` int DEFAULT NULL,
  `reciever_id` int DEFAULT NULL,
  `post_id` varchar(100) DEFAULT NULL,
  `not_type` varchar(100) DEFAULT NULL,
  `not_message` longtext,
  `not_status` enum('0','1') DEFAULT '0',
  `isActive` enum('1','0') DEFAULT '1',
  `isVerified` enum('0','1') DEFAULT '0',
  `isSuspended` enum('0','1') DEFAULT '0',
  `CreatedBy` int DEFAULT NULL,
  `updatedBy` int DEFAULT NULL,
  `isDeleted` enum('0','1') DEFAULT '0',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  PRIMARY KEY (`notification_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_alum_notification`
--


--
-- Table structure for table `tbl_alum_private_messages`
--

CREATE TABLE `tbl_alum_private_messages` (
  `message_id` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `sender_id` int DEFAULT NULL,
  `reciever_id` int DEFAULT NULL,
  `message` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `readStatus` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0',
  `isActive` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '1',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  `isDeleted` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0',
  `isSuspended` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0',
  `createdBy` int DEFAULT NULL,
  `updatedBy` int DEFAULT NULL,
  PRIMARY KEY (`message_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_alum_private_messages`
--


--
-- Table structure for table `tbl_alum_profile`
--

CREATE TABLE `tbl_alum_profile` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `about` text,
  `relationship_status` varchar(20) DEFAULT NULL,
  `cover_image_url` varchar(200) DEFAULT NULL,
  `profile_image_url` varchar(200) DEFAULT NULL,
  `alt_email` varchar(225) DEFAULT NULL,
  `mobile_num` varchar(13) DEFAULT NULL,
  `fb_url` varchar(500) DEFAULT NULL,
  `twitter_url` varchar(500) DEFAULT NULL,
  `linkedin_url` varchar(500) DEFAULT NULL,
  `insta_url` varchar(500) DEFAULT NULL,
  `youtube_url` varchar(500) DEFAULT NULL,
  `web_url` varchar(500) DEFAULT NULL,
  `isActive` enum('0','1') NOT NULL DEFAULT '1',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  `isDeleted` enum('0','1') NOT NULL DEFAULT '0',
  `isSuspended` enum('0','1') NOT NULL DEFAULT '0',
  `createdBy` int DEFAULT NULL,
  `updatedBy` int DEFAULT NULL,
  `perm_addr_line1` varchar(500) DEFAULT NULL,
  `perm_addr_line2` varchar(500) DEFAULT NULL,
  `perm_addr_line3` varchar(500) DEFAULT NULL,
  `perm_country` varchar(450) DEFAULT NULL,
  `perm_state` varchar(450) DEFAULT NULL,
  `perm_city` varchar(450) DEFAULT NULL,
  `perm_postal` varchar(450) DEFAULT NULL,
  `cur_addr_line1` varchar(500) DEFAULT NULL,
  `cur_addr_line2` varchar(500) DEFAULT NULL,
  `cur_addr_line3` varchar(500) DEFAULT NULL,
  `cur_country` varchar(450) DEFAULT NULL,
  `cur_state` varchar(450) DEFAULT NULL,
  `cur_city` varchar(450) DEFAULT NULL,
  `cur_postal` varchar(450) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_alum_profile`
--

INSERT INTO `tbl_alum_profile` VALUES (1,1,NULL,NULL,NULL,NULL,NULL,NULL,'','','','','','','1','2024-03-04 14:17:49','2024-03-04 14:17:49','0','0',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `tbl_alum_service_request`
--

CREATE TABLE `tbl_alum_service_request` (
  `service_request_id` int NOT NULL AUTO_INCREMENT,
  `request_ref_id` varchar(45) DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `description` longtext,
  `request_status` varchar(100) DEFAULT NULL,
  `school` varchar(500) DEFAULT NULL,
  `department` varchar(500) DEFAULT NULL,
  `isActive` enum('0','1') NOT NULL DEFAULT '1',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  `isDeleted` enum('0','1') NOT NULL DEFAULT '0',
  `isSuspended` enum('0','1') NOT NULL DEFAULT '0',
  `createdBy` int DEFAULT NULL,
  `updatedBy` int DEFAULT NULL,
  PRIMARY KEY (`service_request_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_alum_service_request`
--


--
-- Table structure for table `tbl_alum_service_request_setup`
--

CREATE TABLE `tbl_alum_service_request_setup` (
  `request_id` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `request_type` varchar(500) DEFAULT NULL,
  `request_description` longtext,
  `charges` varchar(500) DEFAULT NULL,
  `isActive` enum('0','1') NOT NULL DEFAULT '1',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  `isDeleted` enum('0','1') NOT NULL DEFAULT '0',
  `isSuspended` enum('0','1') NOT NULL DEFAULT '0',
  `createdBy` int DEFAULT NULL,
  `updatedBy` int DEFAULT NULL,
  PRIMARY KEY (`request_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_alum_service_request_setup`
--


--
-- Table structure for table `tbl_alum_slambook`
--

CREATE TABLE `tbl_alum_slambook` (
  `slambook_id` int NOT NULL AUTO_INCREMENT,
  `sender_id` int DEFAULT NULL,
  `reciever_id` int DEFAULT NULL,
  `slambook_message` longtext,
  `Slambook_image` varchar(500) DEFAULT NULL,
  `isActive` enum('0','1') NOT NULL DEFAULT '1',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  `isDeleted` enum('0','1') NOT NULL DEFAULT '0',
  `isSuspended` enum('0','1') NOT NULL DEFAULT '0',
  `createdBy` int DEFAULT NULL,
  `updatedBy` int DEFAULT NULL,
  PRIMARY KEY (`slambook_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_alum_slambook`
--


--
-- Table structure for table `tbl_alum_souvenir_shop`
--

CREATE TABLE `tbl_alum_souvenir_shop` (
  `product_id` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `product_name` varchar(500) DEFAULT NULL,
  `product_category` varchar(500) DEFAULT NULL,
  `brand_name` varchar(500) DEFAULT NULL,
  `product_description` longtext,
  `total_amount` varchar(500) DEFAULT NULL,
  `discount_percentage` varchar(100) DEFAULT NULL,
  `product_image` varchar(500) DEFAULT NULL,
  `view_status` varchar(100) DEFAULT NULL,
  `isActive` enum('1','0') DEFAULT '1',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  `isDeleted` enum('0','1') DEFAULT '0',
  `isSuspended` enum('0','1') DEFAULT '0',
  `createdBy` int DEFAULT NULL,
  `updatedBy` int DEFAULT NULL,
  PRIMARY KEY (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_alum_souvenir_shop`
--


--
-- Table structure for table `tbl_alum_testimonials`
--

CREATE TABLE `tbl_alum_testimonials` (
  `testimonials_id` int NOT NULL AUTO_INCREMENT,
  `sender_id` int DEFAULT NULL,
  `reciever_id` int DEFAULT NULL,
  `testimonials_desc` longtext,
  `testimonials_image` varchar(500) DEFAULT NULL,
  `testimonials_relatonships` varchar(500) DEFAULT NULL,
  `pending_status` enum('0','1') DEFAULT '0',
  `isActive` enum('0','1') NOT NULL DEFAULT '1',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  `isDeleted` enum('0','1') NOT NULL DEFAULT '0',
  `isSuspended` enum('0','1') NOT NULL DEFAULT '0',
  `createdBy` int DEFAULT NULL,
  `updatedBy` int DEFAULT NULL,
  PRIMARY KEY (`testimonials_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_alum_testimonials`
--


--
-- Table structure for table `tbl_alum_timeline_post`
--

CREATE TABLE `tbl_alum_timeline_post` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `group_id` int DEFAULT NULL,
  `post_desc` longtext,
  `post_url` text,
  `post_type` varchar(100) DEFAULT NULL,
  `post_ref` varchar(500) DEFAULT NULL,
  `post_ref_id` int DEFAULT NULL,
  `post_status` varchar(500) DEFAULT NULL,
  `shareRefPostId` int DEFAULT NULL,
  `job_title` varchar(500) DEFAULT NULL,
  `company_name` varchar(500) DEFAULT NULL,
  `workplace_type` varchar(500) DEFAULT NULL,
  `job_location` longtext,
  `job_type` varchar(500) DEFAULT NULL,
  `view_status` varchar(100) DEFAULT NULL,
  `isActive` enum('1','0') DEFAULT '1',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  `isDeleted` enum('0','1') DEFAULT '0',
  `isSuspended` enum('0','1') DEFAULT '0',
  `createdBy` int DEFAULT NULL,
  `updatedBy` int DEFAULT NULL,
  `min_experience` varchar(500) DEFAULT NULL,
  `max_experience` varchar(500) DEFAULT NULL,
  `min_salary` varchar(500) DEFAULT NULL,
  `max_salary` varchar(500) DEFAULT NULL,
  `web_url` varchar(500) DEFAULT NULL,
  `contact_no` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_alum_timeline_post`
--


--
-- Table structure for table `tbl_alum_timeline_viewed_profile`
--

CREATE TABLE `tbl_alum_timeline_viewed_profile` (
  `view_profile_id` int NOT NULL AUTO_INCREMENT,
  `viewer_id` varchar(100) DEFAULT NULL,
  `viewed_id` varchar(100) DEFAULT NULL,
  `isActive` enum('0','1') NOT NULL DEFAULT '1',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  `isDeleted` enum('0','1') NOT NULL DEFAULT '0',
  `isSuspended` enum('0','1') NOT NULL DEFAULT '0',
  `createdBy` int DEFAULT NULL,
  `updatedBy` int DEFAULT NULL,
  PRIMARY KEY (`view_profile_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_alum_timeline_viewed_profile`
--


--
-- Table structure for table `tbl_alum_workex`
--

CREATE TABLE `tbl_alum_workex` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `company_name` text,
  `designation` varchar(20) DEFAULT NULL,
  `job_start_date` varchar(200) DEFAULT NULL,
  `job_end_date` varchar(200) DEFAULT NULL,
  `isActive` enum('0','1') NOT NULL DEFAULT '1',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  `isDeleted` enum('0','1') NOT NULL DEFAULT '0',
  `isSuspended` enum('0','1') NOT NULL DEFAULT '0',
  `createdBy` int DEFAULT NULL,
  `updatedBy` int DEFAULT NULL,
  `isCurrWorking` enum('1','0') DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_alum_workex`
--


--
-- Table structure for table `tbl_alumn_success_stories`
--

CREATE TABLE `tbl_alumn_success_stories` (
  `stories_id` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `story_desc` longtext,
  `story_img_url` varchar(500) DEFAULT NULL,
  `pending_status` enum('0','1') DEFAULT '0',
  `isActive` enum('0','1') NOT NULL DEFAULT '1',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  `isDeleted` enum('0','1') NOT NULL DEFAULT '0',
  `isSuspended` enum('0','1') NOT NULL DEFAULT '0',
  `createdBy` int DEFAULT NULL,
  `updatedBy` int DEFAULT NULL,
  PRIMARY KEY (`stories_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_alumn_success_stories`
--


--
-- Table structure for table `tbl_group_x_user`
--

CREATE TABLE `tbl_group_x_user` (
  `group_x_user_id` int NOT NULL AUTO_INCREMENT,
  `group_id` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `isActive` enum('0','1') NOT NULL DEFAULT '1',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  `isDeleted` enum('0','1') NOT NULL DEFAULT '0',
  `isSuspended` enum('0','1') NOT NULL DEFAULT '0',
  `createdBy` int DEFAULT NULL,
  `updatedBy` int DEFAULT NULL,
  PRIMARY KEY (`group_x_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_group_x_user`
--


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

CREATE TABLE `tbl_module_master` (
  `id` int NOT NULL AUTO_INCREMENT,
  `module` varchar(100) DEFAULT NULL,
  `module_description` varchar(500) DEFAULT NULL,
  `description` varchar(100) DEFAULT NULL,
  `isActive` enum('1','0') DEFAULT '1',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  `isDeleted` enum('0','1') DEFAULT '0',
  `isSuspended` enum('0','1') DEFAULT '0',
  `createdBy` int DEFAULT NULL,
  `updatedBy` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `tbl_module_master` VALUES (1,'Home','Homepage','/home','1','2022-12-06 14:03:20','2022-12-06 14:03:20','0','0',NULL,NULL),(2,'Profile','Profile Page','/profile','1','2022-12-06 14:03:20','2022-12-06 14:03:20','0','0',NULL,NULL),(3,'SearchAlumni','Search Alumni Page','/search-alumni','1','2022-12-06 14:03:20','2022-12-06 14:03:20','0','0',NULL,NULL),(4,'SettingPrivacy','Settings Page','/settings','1','2022-12-06 14:03:20','2022-12-06 14:03:20','0','0',NULL,NULL),(5,'Event','Event Page','/event','1','2022-12-06 14:03:20','2022-12-06 14:03:20','0','0',NULL,NULL),(6,'EventDetail','Event Detail Page','/event-detail','1','2022-12-06 14:03:20','2022-12-06 14:03:20','0','0',NULL,NULL),(7,'Notification','Notifications','/notification','1','2022-12-06 14:03:20','2022-12-06 14:03:20','0','0',NULL,NULL),(8,'Message','Message','/message','1','2022-12-06 14:03:20','2022-12-06 14:03:20','0','0',NULL,NULL),(9,'Group','Group Page','/group','1','2022-12-06 14:03:20','2022-12-06 14:03:20','0','0',NULL,NULL),(10,'GroupListing','Group Listing Page','/group-listing','1','2022-12-06 14:03:20','2022-12-06 14:03:20','0','0',NULL,NULL),(11,'MyConnections','My Connections','/my-connections','1','2023-01-25 10:45:14','2023-01-25 10:45:14','0','0',NULL,NULL),(12,'SlamBook','Slambook','/slambook','1','2023-02-23 10:45:14','2023-02-23 10:45:14','0','0',NULL,NULL),(13,'SuccessStories','Success Stories','/success-stories','1','2023-02-27 10:45:14','2023-02-27 10:45:14','0','0',NULL,NULL),(14,'ServiceRequest','Service Request','/service-request','1','2023-03-01 12:59:17','2023-03-01 12:59:17','0','0',NULL,NULL),(15,'Election','Election','/election','1','2023-03-01 12:59:17','2023-03-01 12:59:17','0','0',NULL,NULL),(16,'ElectionManagement','Election Management','/election-management','1','2023-03-01 12:59:17','2023-03-01 12:59:17','0','0',NULL,NULL),(17,'SouvenirShop','Souvenir Shop','/souvenir-shop','1','2023-06-08 15:50:31','2023-06-08 15:50:31','0','0',NULL,NULL),(18,'ManageModule','Manage Module','/manage-modules','1','2023-06-08 15:50:31','2023-06-08 15:50:31','0','0',NULL,NULL),(19,'ManageRole','Manage Role','/manage-roles','1','2023-06-08 15:50:31','2023-06-08 15:50:31','0','0',NULL,NULL),(20,'ServiceRequestSetup','Service Request Setup','/service-request-setup','1','2023-06-08 15:50:31','2023-06-08 15:50:31','0','0',NULL,NULL),(21,'ManageUsers','Manage Users','/manage-users','1','2023-06-08 15:50:31','2023-06-08 15:50:31','0','0',NULL,NULL);

--
-- Table structure for table `tbl_poll_survey_master`
--

CREATE TABLE `tbl_poll_survey_master` (
  `poll_survey_id` int NOT NULL AUTO_INCREMENT,
  `post_id` int DEFAULT NULL,
  `poll_survey_question` varchar(500) DEFAULT NULL,
  `poll_survey_duration` varchar(500) DEFAULT NULL,
  `isActive` enum('1','0') DEFAULT '1',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  `isDeleted` enum('0','1') DEFAULT '0',
  `isSuspended` enum('0','1') DEFAULT '0',
  `createdBy` int DEFAULT NULL,
  `updatedBy` int DEFAULT NULL,
  PRIMARY KEY (`poll_survey_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_poll_survey_master`
--


--
-- Table structure for table `tbl_poll_survey_x_user`
--

CREATE TABLE `tbl_poll_survey_x_user` (
  `poll_survey_x_user_id` int NOT NULL AUTO_INCREMENT,
  `post_id` int DEFAULT NULL,
  `poll_survey_id` int DEFAULT NULL,
  `poll_x_option_id` int DEFAULT NULL,
  `poll_x_option_name` varchar(500) DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `isActive` enum('0','1') NOT NULL DEFAULT '1',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  `isDeleted` enum('0','1') NOT NULL DEFAULT '0',
  `isSuspended` enum('0','1') NOT NULL DEFAULT '0',
  `createdBy` int DEFAULT NULL,
  `updatedBy` int DEFAULT NULL,
  PRIMARY KEY (`poll_survey_x_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_poll_survey_x_user`
--


--
-- Table structure for table `tbl_poll_x_option`
--

CREATE TABLE `tbl_poll_x_option` (
  `poll_x_option_id` int NOT NULL AUTO_INCREMENT,
  `poll_survey_id` int DEFAULT NULL,
  `option` varchar(500) DEFAULT NULL,
  `isActive` enum('0','1') NOT NULL DEFAULT '1',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  `isDeleted` enum('0','1') NOT NULL DEFAULT '0',
  `isSuspended` enum('0','1') NOT NULL DEFAULT '0',
  `createdBy` int DEFAULT NULL,
  `updatedBy` int DEFAULT NULL,
  PRIMARY KEY (`poll_x_option_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_poll_x_option`
--


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

CREATE TABLE `tbl_role_master` (
  `id` int NOT NULL AUTO_INCREMENT,
  `role` varchar(100) NOT NULL,
  `description` varchar(100) NOT NULL,
  `isActive` enum('1','0') NOT NULL DEFAULT '1',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  `isDeleted` enum('0','1') NOT NULL DEFAULT '0',
  `isSuspended` enum('0','1') NOT NULL DEFAULT '0',
  `createdBy` int DEFAULT NULL,
  `updatedBy` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1005 DEFAULT CHARSET=latin1;

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

INSERT INTO `tbl_role_master` VALUES (1001,'Admin','This is Admin Role','1','2022-12-05 22:15:49','2023-06-27 15:39:06','0','0',NULL,NULL),(1002,'Manager','This is Manager Role','1','2022-12-05 22:16:11','2024-03-14 12:35:38','0','0',NULL,1),(1003,'Alumni','This is Alumni Role','1','2022-12-05 22:16:32','2024-03-11 12:48:33','0','0',NULL,1),(1004,'Employee','This is Employee','1','2022-12-06 11:18:16','2024-03-11 17:04:20','0','0',NULL,1);

--
-- Table structure for table `tbl_role_x_module`
--

CREATE TABLE `tbl_role_x_module` (
  `id` int NOT NULL AUTO_INCREMENT,
  `role_id` int DEFAULT NULL,
  `module_id` int NOT NULL,
  `create` tinyint DEFAULT '0',
  `read` tinyint DEFAULT '0',
  `update` tinyint DEFAULT '0',
  `delete` tinyint DEFAULT '0',
  `special` tinyint DEFAULT '0',
  `isActive` enum('1','0') NOT NULL DEFAULT '1',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  `isDeleted` tinyint DEFAULT '0',
  `isSuspended` tinyint DEFAULT '0',
  `createdBy` int DEFAULT NULL,
  `updatedBy` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=518 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_role_x_module`
--

INSERT INTO `tbl_role_x_module` VALUES (183,1001,1,1,1,1,1,0,'1','2023-06-27 15:39:06','2023-06-27 15:39:06',0,0,NULL,NULL),(184,1001,2,1,1,1,1,0,'1','2023-06-27 15:39:06','2023-06-27 15:39:06',0,0,NULL,NULL),(185,1001,3,1,1,1,1,0,'1','2023-06-27 15:39:06','2023-06-27 15:39:06',0,0,NULL,NULL),(186,1001,4,1,1,1,1,0,'1','2023-06-27 15:39:07','2023-06-27 15:39:07',0,0,NULL,NULL),(187,1001,5,1,1,1,1,0,'1','2023-06-27 15:39:07','2023-06-27 15:39:07',0,0,NULL,NULL),(188,1001,6,1,1,1,1,0,'1','2023-06-27 15:39:07','2023-06-27 15:39:07',0,0,NULL,NULL),(189,1001,7,1,1,1,1,0,'1','2023-06-27 15:39:07','2023-06-27 15:39:07',0,0,NULL,NULL),(190,1001,8,1,1,1,1,0,'1','2023-06-27 15:39:07','2023-06-27 15:39:07',0,0,NULL,NULL),(191,1001,9,1,1,1,1,0,'1','2023-06-27 15:39:07','2023-06-27 15:39:07',0,0,NULL,NULL),(192,1001,10,1,1,1,1,0,'1','2023-06-27 15:39:07','2023-06-27 15:39:07',0,0,NULL,NULL),(193,1001,11,1,1,1,1,0,'1','2023-06-27 15:39:07','2023-06-27 15:39:07',0,0,NULL,NULL),(194,1001,12,1,1,1,1,0,'1','2023-06-27 15:39:07','2023-06-27 15:39:07',0,0,NULL,NULL),(195,1001,13,1,1,1,1,0,'1','2023-06-27 15:39:07','2023-06-27 15:39:07',0,0,NULL,NULL),(196,1001,14,1,1,1,1,0,'1','2023-06-27 15:39:07','2023-06-27 15:39:07',0,0,NULL,NULL),(197,1001,15,1,1,1,1,0,'1','2023-06-27 15:39:07','2023-06-27 15:39:07',0,0,NULL,NULL),(198,1001,16,1,1,1,1,0,'1','2023-06-27 15:39:07','2023-06-27 15:39:07',0,0,NULL,NULL),(199,1001,17,1,1,1,1,0,'1','2023-06-27 15:39:07','2023-06-27 15:39:07',0,0,NULL,NULL),(408,1003,1,1,1,1,1,0,'1','2024-03-11 12:48:33','2024-03-11 12:48:33',0,0,1,1),(409,1003,2,1,1,1,1,0,'1','2024-03-11 12:48:33','2024-03-11 12:48:33',0,0,1,1),(410,1003,3,1,1,1,0,0,'1','2024-03-11 12:48:33','2024-03-11 12:48:33',0,0,1,1),(411,1003,4,0,1,1,0,0,'1','2024-03-11 12:48:33','2024-03-11 12:48:33',0,0,1,1),(412,1003,5,0,1,0,0,0,'1','2024-03-11 12:48:33','2024-03-11 12:48:33',0,0,1,1),(413,1003,6,0,1,0,0,0,'1','2024-03-11 12:48:33','2024-03-11 12:48:33',0,0,1,1),(414,1003,7,0,1,0,0,0,'1','2024-03-11 12:48:33','2024-03-11 12:48:33',0,0,1,1),(415,1003,8,1,1,1,1,0,'1','2024-03-11 12:48:33','2024-03-11 12:48:33',0,0,1,1),(416,1003,9,1,1,1,1,0,'1','2024-03-11 12:48:33','2024-03-11 12:48:33',0,0,1,1),(417,1003,10,1,1,1,1,0,'1','2024-03-11 12:48:33','2024-03-11 12:48:33',0,0,1,1),(418,1003,11,1,1,0,0,0,'1','2024-03-11 12:48:33','2024-03-11 12:48:33',0,0,1,1),(419,1003,12,1,1,1,1,0,'1','2024-03-11 12:48:33','2024-03-11 12:48:33',0,0,1,1),(420,1003,13,1,1,1,1,0,'1','2024-03-11 12:48:33','2024-03-11 12:48:33',0,0,1,1),(421,1003,14,1,1,1,1,0,'1','2024-03-11 12:48:33','2024-03-11 12:48:33',0,0,1,1),(422,1003,15,0,0,0,0,0,'1','2024-03-11 12:48:33','2024-03-11 12:48:33',0,0,1,1),(423,1003,16,0,0,0,0,0,'1','2024-03-11 12:48:33','2024-03-11 12:48:33',0,0,1,1),(424,1003,17,0,0,0,0,0,'1','2024-03-11 12:48:33','2024-03-11 12:48:33',0,0,1,1),(463,1004,1,0,1,0,0,0,'1','2024-03-11 17:04:20','2024-03-11 17:04:20',0,0,1,1),(464,1004,2,1,1,1,0,0,'1','2024-03-11 17:04:20','2024-03-11 17:04:20',0,0,1,1),(465,1004,3,0,1,0,0,0,'1','2024-03-11 17:04:20','2024-03-11 17:04:20',0,0,1,1),(466,1004,4,0,1,1,0,0,'1','2024-03-11 17:04:20','2024-03-11 17:04:20',0,0,1,1),(467,1004,5,0,1,0,0,0,'1','2024-03-11 17:04:20','2024-03-11 17:04:20',0,0,1,1),(468,1004,6,0,1,0,0,0,'1','2024-03-11 17:04:20','2024-03-11 17:04:20',0,0,1,1),(469,1004,7,0,1,0,0,0,'1','2024-03-11 17:04:20','2024-03-11 17:04:20',0,0,1,1),(470,1004,8,0,0,0,0,0,'1','2024-03-11 17:04:20','2024-03-11 17:04:20',0,0,1,1),(471,1004,9,0,1,0,0,0,'1','2024-03-11 17:04:20','2024-03-11 17:04:20',0,0,1,1),(472,1004,10,0,1,0,0,0,'1','2024-03-11 17:04:20','2024-03-11 17:04:20',0,0,1,1),(473,1004,11,0,1,0,0,0,'1','2024-03-11 17:04:20','2024-03-11 17:04:20',0,0,1,1),(474,1004,12,0,1,0,0,0,'1','2024-03-11 17:04:20','2024-03-11 17:04:20',0,0,1,1),(475,1004,13,0,1,0,0,0,'1','2024-03-11 17:04:20','2024-03-11 17:04:20',0,0,1,1),(476,1004,14,0,1,0,0,0,'1','2024-03-11 17:04:20','2024-03-11 17:04:20',0,0,1,1),(477,1004,15,0,0,0,0,0,'1','2024-03-11 17:04:20','2024-03-11 17:04:20',0,0,1,1),(478,1004,16,0,0,0,0,0,'1','2024-03-11 17:04:20','2024-03-11 17:04:20',0,0,1,1),(479,1004,17,0,0,0,0,0,'1','2024-03-11 17:04:20','2024-03-11 17:04:20',0,0,1,1),(499,1002,1,1,1,1,1,0,'1','2024-03-14 12:35:38','2024-03-14 12:35:38',0,0,1,1),(500,1002,2,1,1,1,0,0,'1','2024-03-14 12:35:38','2024-03-14 12:35:38',0,0,1,1),(501,1002,3,0,1,0,0,0,'1','2024-03-14 12:35:38','2024-03-14 12:35:38',0,0,1,1),(502,1002,4,0,1,1,0,0,'1','2024-03-14 12:35:38','2024-03-14 12:35:38',0,0,1,1),(503,1002,5,1,1,1,1,0,'1','2024-03-14 12:35:38','2024-03-14 12:35:38',0,0,1,1),(504,1002,6,1,1,1,1,0,'1','2024-03-14 12:35:38','2024-03-14 12:35:38',0,0,1,1),(505,1002,7,0,1,0,0,0,'1','2024-03-14 12:35:38','2024-03-14 12:35:38',0,0,1,1),(506,1002,8,0,0,0,0,0,'1','2024-03-14 12:35:38','2024-03-14 12:35:38',0,0,1,1),(507,1002,9,0,1,0,0,0,'1','2024-03-14 12:35:38','2024-03-14 12:35:38',0,0,1,1),(508,1002,10,0,1,0,0,0,'1','2024-03-14 12:35:38','2024-03-14 12:35:38',0,0,1,1),(509,1002,11,0,0,0,0,0,'1','2024-03-14 12:35:38','2024-03-14 12:35:38',0,0,1,1),(510,1002,12,0,0,0,0,0,'1','2024-03-14 12:35:38','2024-03-14 12:35:38',0,0,1,1),(511,1002,13,0,1,0,0,1,'1','2024-03-14 12:35:38','2024-03-14 12:35:38',0,0,1,1),(512,1002,14,0,1,0,0,0,'1','2024-03-14 12:35:38','2024-03-14 12:35:38',0,0,1,1),(513,1002,15,0,0,0,0,0,'1','2024-03-14 12:35:38','2024-03-14 12:35:38',0,0,1,1),(514,1002,16,0,0,0,0,0,'1','2024-03-14 12:35:38','2024-03-14 12:35:38',0,0,1,1),(515,1002,17,0,0,0,0,0,'1','2024-03-14 12:35:38','2024-03-14 12:35:38',0,0,1,1),(516,1002,20,1,1,1,0,0,'1','2024-03-14 12:35:38','2024-03-14 12:35:38',0,0,1,1),(517,1002,21,1,1,1,0,0,'1','2024-03-14 12:35:38','2024-03-14 12:35:38',0,0,1,1);

--
-- Table structure for table `tbl_service_request_documents`
--

CREATE TABLE `tbl_service_request_documents` (
  `request_documents_id` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `document_id` varchar(100) DEFAULT NULL,
  `service_request_id` int DEFAULT NULL,
  `document_link` varchar(500) DEFAULT NULL,
  `isActive` enum('1','0') DEFAULT '1',
  `isVerified` enum('0','1') DEFAULT '0',
  `isSuspended` enum('0','1') DEFAULT '0',
  `CreatedBy` int DEFAULT NULL,
  `updatedBy` int DEFAULT NULL,
  `isDeleted` enum('0','1') DEFAULT '0',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  PRIMARY KEY (`request_documents_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_service_request_documents`
--


--
-- Table structure for table `tbl_service_x_documents`
--

CREATE TABLE `tbl_service_x_documents` (
  `service_documents_id` int NOT NULL AUTO_INCREMENT,
  `request_id` int DEFAULT NULL,
  `document_id` varchar(500) DEFAULT NULL,
  `isActive` enum('1','0') DEFAULT '1',
  `isVerified` enum('0','1') DEFAULT '0',
  `isSuspended` enum('0','1') DEFAULT '0',
  `CreatedBy` int DEFAULT NULL,
  `updatedBy` int DEFAULT NULL,
  `isDeleted` enum('0','1') DEFAULT '0',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  PRIMARY KEY (`service_documents_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_service_x_documents`
--


--
-- Table structure for table `tbl_service_x_spoc`
--

CREATE TABLE `tbl_service_x_spoc` (
  `service_spoc_id` int NOT NULL AUTO_INCREMENT,
  `request_id` int DEFAULT NULL,
  `school_id` varchar(500) DEFAULT NULL,
  `department_id` varchar(500) DEFAULT NULL,
  `spoc_id` varchar(500) DEFAULT NULL,
  `spoc_name` varchar(500) DEFAULT NULL,
  `isActive` enum('1','0') DEFAULT '1',
  `isVerified` enum('0','1') DEFAULT '0',
  `isSuspended` enum('0','1') DEFAULT '0',
  `CreatedBy` int DEFAULT NULL,
  `updatedBy` int DEFAULT NULL,
  `isDeleted` enum('0','1') DEFAULT '0',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  PRIMARY KEY (`service_spoc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_service_x_spoc`
--


--
-- Table structure for table `tbl_user_x_role`
--

CREATE TABLE `tbl_user_x_role` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `role_id` int NOT NULL,
  `isActive` enum('1','0') NOT NULL DEFAULT '1',
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  `isDeleted` enum('0','1') NOT NULL DEFAULT '0',
  `isSuspended` enum('0','1') NOT NULL DEFAULT '0',
  `createdBy` int DEFAULT NULL,
  `updatedBy` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_user_x_role`
--

INSERT INTO `tbl_user_x_role` VALUES (1,1,1001,'1','2024-03-04 14:17:49','2024-03-04 14:17:49','0','0',1,1);


