--
-- Host: localhost    Database: arvind_pm
-- ------------------------------------------------------


--
-- Table structure for table `comments`
--

CREATE TABLE `comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `project_id` int(11) NOT NULL,
  `task_id` int(11) DEFAULT NULL,
  `enteredbyid` int(11) NOT NULL DEFAULT 0,
  `documents` text DEFAULT NULL,
  `rollback` tinyint(1) DEFAULT 0,
  `assigned_ids` text DEFAULT NULL,
  `comments` text DEFAULT NULL,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `audio_recording` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `comments`
--


--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `masters`
--

CREATE TABLE `masters` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `type` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `labelid` int(11) NOT NULL DEFAULT 0,
  `label` varchar(50) DEFAULT NULL,
  `value` int(11) DEFAULT 0,
  `value_string` text DEFAULT NULL,
  `note` text DEFAULT NULL,
  `sequence` smallint(6) DEFAULT NULL,
  `rolledback` tinyint(1) NOT NULL DEFAULT 0,
  `organisation_id` varchar(50) DEFAULT NULL,
  `enteredbyid` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=341 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `masters`
--

INSERT INTO `masters` VALUES (132,0,'2024-12-10 18:40:02','2025-03-30 14:28:03',35,'Hotel Type',0,'this is hotel types',NULL,NULL,1,NULL,0),(249,0,'2025-03-30 08:14:15','2025-03-31 06:34:16',36,'Department',3,'0','this is new department master added in master',NULL,1,NULL,0),(250,0,'2025-03-30 08:15:16','2025-03-31 06:34:36',37,'Department',0,'0','this is new department master added in master',NULL,1,NULL,0),(251,0,'2025-03-30 08:16:44','2025-03-31 06:40:34',38,'Department',0,'0','this is new department master added in master',NULL,1,NULL,0),(252,0,'2025-03-30 08:17:29','2025-03-31 06:53:52',39,'Department',0,'0','this is new department master added in master',NULL,1,NULL,0),(253,0,'2025-03-30 10:54:54','2025-03-31 06:54:02',40,'IT',0,'0','this is It department',NULL,1,NULL,0),(254,0,'2025-03-30 10:56:06','2025-03-31 06:54:09',41,'IT2',0,'0','this is new IT department',NULL,1,NULL,0),(255,0,'2025-03-30 10:57:03','2025-03-31 06:54:16',42,'IT3',0,'0','this is new IT department 3',NULL,1,NULL,0),(256,0,'2025-03-30 11:02:29','2025-03-31 06:54:24',43,'aaaa',0,'0','this is new value',NULL,1,NULL,0),(257,35,'2025-03-30 11:04:56','2025-03-30 15:47:29',1,'It45',2,'0','this is new master type that was try to included',NULL,1,NULL,0),(258,35,'2025-03-30 11:05:53','2025-03-30 14:20:04',2,'sssss',0,'0','this is new',NULL,1,NULL,0),(259,36,'2025-03-30 16:05:03','2025-03-30 16:06:47',1,'IT',3,'3','this is new IT department',NULL,0,NULL,0),(260,0,'2025-03-30 17:14:27','2025-03-30 17:14:27',44,'Department',0,NULL,NULL,NULL,0,NULL,0),(261,44,'2025-03-30 17:15:07','2025-03-30 17:15:07',1,'IT',0,NULL,NULL,NULL,0,NULL,0),(262,44,'2025-03-30 17:15:46','2025-03-30 17:15:46',2,'Marketing',0,NULL,NULL,NULL,0,NULL,0),(263,0,'2025-03-30 17:17:16','2025-03-30 17:17:16',45,'Designation',0,NULL,NULL,NULL,0,NULL,0),(264,45,'2025-03-30 17:17:38','2025-03-30 17:17:38',1,'Manager',0,NULL,NULL,NULL,0,NULL,0),(265,45,'2025-03-30 17:18:24','2025-03-30 17:18:24',2,'Team Lead',0,NULL,NULL,NULL,0,NULL,0),(266,45,'2025-03-30 17:19:00','2025-03-30 17:19:00',3,'Tester',0,NULL,NULL,NULL,0,NULL,0),(267,45,'2025-03-30 17:19:25','2025-04-04 07:35:06',4,'Jr. Developer (FE)',0,NULL,NULL,NULL,0,NULL,0),(268,45,'2025-03-30 17:19:45','2025-04-04 07:35:28',5,'Sr. Developer (FE)',0,NULL,NULL,NULL,0,NULL,0),(269,0,'2025-03-30 17:20:13','2025-04-03 06:50:49',46,'Skill Set',0,NULL,NULL,NULL,0,NULL,0),(270,46,'2025-03-30 17:20:43','2025-03-30 17:20:43',1,'React',0,NULL,NULL,NULL,0,NULL,0),(271,46,'2025-03-30 17:21:01','2025-04-03 06:50:13',2,'Java Script',0,NULL,NULL,NULL,0,NULL,0),(272,46,'2025-03-30 17:21:18','2025-03-30 17:21:18',3,'HTML',0,NULL,NULL,NULL,0,NULL,0),(273,46,'2025-03-30 17:21:33','2025-03-30 17:21:33',4,'CSS',0,NULL,NULL,NULL,0,NULL,0),(274,46,'2025-03-30 17:21:50','2025-03-30 17:21:50',5,'Tailwind CSS',0,NULL,NULL,NULL,0,NULL,0),(275,46,'2025-03-30 17:22:06','2025-03-30 17:22:06',6,'Bootstarp',0,NULL,NULL,NULL,0,NULL,0),(276,46,'2025-03-30 17:22:30','2025-03-30 17:22:30',7,'Node.js',0,NULL,NULL,NULL,0,NULL,0),(277,46,'2025-03-30 17:22:56','2025-03-30 17:22:56',8,'Express.js',0,NULL,NULL,NULL,0,NULL,0),(278,46,'2025-03-30 17:23:12','2025-03-30 17:23:12',9,'SQL',0,NULL,NULL,NULL,0,NULL,0),(279,46,'2025-03-30 17:23:26','2025-03-30 17:23:26',10,'MongoDB',0,NULL,NULL,NULL,0,NULL,0),(280,46,'2025-03-30 17:23:42','2025-03-30 17:23:42',11,'Git',0,NULL,NULL,NULL,0,NULL,0),(281,46,'2025-03-30 17:23:54','2025-03-30 17:23:54',12,'Git-Hub',0,NULL,NULL,NULL,0,NULL,0),(282,46,'2025-03-30 17:24:14','2025-03-30 17:24:14',13,'Firebase',0,NULL,NULL,NULL,0,NULL,0),(283,46,'2025-03-30 17:24:30','2025-04-03 06:49:58',14,'Axios',0,NULL,NULL,NULL,1,NULL,0),(284,0,'2025-03-30 17:25:53','2025-03-30 17:25:53',47,'Priority',0,NULL,NULL,NULL,0,NULL,0),(285,47,'2025-03-30 17:26:15','2025-03-30 17:26:15',1,'High',0,NULL,NULL,NULL,0,NULL,0),(286,47,'2025-03-30 17:26:31','2025-03-30 17:26:31',2,'Low',0,NULL,NULL,NULL,0,NULL,0),(287,47,'2025-03-30 17:26:50','2025-03-30 17:26:50',3,'Medium',0,NULL,NULL,NULL,0,NULL,0),(288,0,'2025-03-30 17:27:21','2025-03-30 17:27:21',48,'Project Stage',0,NULL,NULL,NULL,0,NULL,0),(289,48,'2025-03-30 17:27:41','2025-03-30 17:27:41',1,'Stage 1',0,NULL,NULL,NULL,0,NULL,0),(290,48,'2025-03-30 17:27:56','2025-03-30 17:27:56',2,'Stage 2',0,NULL,NULL,NULL,0,NULL,0),(291,48,'2025-03-30 17:28:11','2025-03-30 17:28:11',3,'Stage 3',0,NULL,NULL,NULL,0,NULL,0),(292,0,'2025-03-30 17:29:13','2025-03-30 17:29:13',49,'Task Type',0,NULL,NULL,NULL,0,NULL,0),(293,49,'2025-03-30 17:29:32','2025-03-30 17:29:32',1,'Documentation',0,NULL,NULL,NULL,0,NULL,0),(294,49,'2025-03-30 17:29:49','2025-03-30 17:29:49',2,'Bug Fix',0,NULL,NULL,NULL,0,NULL,0),(295,49,'2025-03-30 17:30:06','2025-04-04 05:30:50',3,'Frontend Development',0,NULL,NULL,NULL,0,NULL,0),(296,49,'2025-03-30 17:31:02','2025-03-30 17:31:02',4,'Review',0,NULL,NULL,NULL,0,NULL,0),(297,0,'2025-03-30 17:31:27','2025-03-31 06:54:42',50,'Priority',0,NULL,NULL,NULL,1,NULL,0),(298,50,'2025-03-30 17:31:49','2025-03-30 17:31:49',1,'High',0,NULL,NULL,NULL,0,NULL,0),(299,50,'2025-03-30 17:32:05','2025-03-30 17:32:05',2,'Low',0,NULL,NULL,NULL,0,NULL,0),(300,50,'2025-03-30 17:32:19','2025-03-30 17:32:19',3,'Medium',0,NULL,NULL,NULL,0,NULL,0),(301,0,'2025-03-30 17:32:39','2025-03-31 06:54:52',51,'Department',0,NULL,NULL,NULL,1,NULL,0),(302,51,'2025-03-30 17:32:58','2025-03-30 17:32:58',1,'IT',0,NULL,NULL,NULL,0,NULL,0),(303,51,'2025-03-30 17:33:30','2025-03-30 17:33:30',2,'Marketing',0,NULL,NULL,NULL,0,NULL,0),(304,0,'2025-03-30 17:33:52','2025-03-30 17:33:52',52,'Visibility',0,NULL,NULL,NULL,0,NULL,0),(305,52,'2025-03-30 17:34:08','2025-03-30 17:34:08',1,'Public',0,NULL,NULL,NULL,0,NULL,0),(306,52,'2025-03-30 17:34:31','2025-03-30 17:34:31',2,'Private',0,NULL,NULL,NULL,0,NULL,0),(307,46,'2025-03-30 17:36:06','2025-03-30 17:36:06',15,'PHP',0,NULL,NULL,NULL,0,NULL,0),(308,39,'2025-03-31 06:47:08','2025-03-31 06:51:33',1,'HHhhh',0,'2','thisssssssssssssssssss',NULL,1,NULL,0),(309,39,'2025-03-31 06:53:00','2025-03-31 06:53:35',1,'ddd',0,NULL,NULL,NULL,1,NULL,0),(310,0,'2025-04-01 05:46:54','2025-04-01 05:47:13',53,'sss',0,NULL,NULL,NULL,1,NULL,0),(311,46,'2025-04-03 06:49:37','2025-04-03 06:49:37',16,'Laravel',0,NULL,NULL,NULL,0,NULL,0),(312,0,'2025-04-03 06:52:20','2025-04-03 06:53:00',53,'Payment Status',0,NULL,NULL,NULL,1,NULL,0),(313,53,'2025-04-03 06:52:30','2025-04-03 06:52:30',1,'Paid',0,NULL,NULL,NULL,0,NULL,0),(314,53,'2025-04-03 06:52:48','2025-04-03 06:52:48',2,'Unpaid',0,NULL,NULL,NULL,0,NULL,0),(315,0,'2025-04-03 08:23:55','2025-04-03 08:24:26',53,'One new',0,NULL,NULL,NULL,1,NULL,0),(316,0,'2025-04-03 08:25:53','2025-04-03 08:27:04',53,'aaaaaa',0,NULL,NULL,NULL,1,NULL,0),(317,0,'2025-04-03 08:28:20','2025-04-03 08:28:36',53,'aaaaaaaaaa',0,NULL,NULL,NULL,1,NULL,0),(318,0,'2025-04-03 08:30:17','2025-04-03 08:30:43',53,'aaaaaa',0,NULL,NULL,NULL,1,NULL,0),(319,53,'2025-04-03 08:30:34','2025-04-03 08:30:34',3,'aaaaa',0,NULL,NULL,NULL,0,NULL,0),(320,0,'2025-04-03 08:31:01','2025-04-03 08:31:10',53,'aaaaaa',0,NULL,NULL,NULL,1,NULL,0),(321,45,'2025-04-04 05:25:44','2025-04-04 05:25:44',6,'UI Designer',0,NULL,NULL,NULL,0,NULL,0),(322,45,'2025-04-04 05:26:57','2025-04-04 05:26:57',7,'Figma Designer',0,NULL,NULL,NULL,0,NULL,0),(323,45,'2025-04-04 05:27:25','2025-04-04 07:35:45',8,'Jr Developer (BE)',0,NULL,NULL,NULL,0,NULL,0),(324,45,'2025-04-04 05:29:28','2025-04-04 07:36:00',9,'Sr Developer (BE)',0,NULL,NULL,NULL,0,NULL,0),(325,49,'2025-04-04 05:31:09','2025-04-04 05:31:09',5,'Backend Development',0,NULL,NULL,NULL,0,NULL,0),(326,49,'2025-04-04 05:31:22','2025-04-04 05:31:22',6,'UI Design',0,NULL,NULL,NULL,0,NULL,0),(327,49,'2025-04-04 05:37:31','2025-04-04 05:37:31',7,'Figma Design',0,NULL,NULL,NULL,0,NULL,0),(328,46,'2025-04-04 07:39:07','2025-04-04 07:39:07',17,'Typescript',0,NULL,NULL,NULL,0,NULL,0),(329,46,'2025-04-04 07:41:50','2025-04-04 07:42:11',18,'Next.js',0,NULL,NULL,NULL,0,NULL,0),(330,46,'2025-04-04 07:46:25','2025-04-04 07:46:25',19,'Express.js',0,NULL,NULL,NULL,0,NULL,0),(331,46,'2025-04-04 07:47:03','2025-04-04 07:47:03',20,'Postgress',0,NULL,NULL,NULL,0,NULL,0),(332,46,'2025-04-04 07:47:19','2025-04-04 07:47:19',21,'Rest api',0,NULL,NULL,NULL,0,NULL,0),(333,46,'2025-04-04 07:47:38','2025-04-04 07:47:38',22,'Axios',0,NULL,NULL,NULL,0,NULL,0),(334,46,'2025-04-04 07:47:53','2025-04-04 07:47:53',23,'Bitbucket',0,NULL,NULL,NULL,0,NULL,0),(335,46,'2025-04-04 07:55:48','2025-04-04 07:55:48',24,'Figma',0,NULL,NULL,NULL,0,NULL,0),(336,46,'2025-04-04 07:59:32','2025-04-04 07:59:32',25,'Vue.js',0,NULL,NULL,NULL,0,NULL,0),(337,46,'2025-04-04 07:59:43','2025-04-04 07:59:43',26,'MySQL',0,NULL,NULL,NULL,0,NULL,0),(338,46,'2025-04-04 08:04:54','2025-04-04 08:04:54',27,'Python',0,NULL,NULL,NULL,0,NULL,0),(339,46,'2025-04-04 08:05:04','2025-04-04 08:05:04',28,'Codenighter',0,NULL,NULL,NULL,0,NULL,0),(340,45,'2025-04-04 08:22:08','2025-04-04 08:22:08',10,'Project Manager',0,NULL,NULL,NULL,0,NULL,0);

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_reset_tokens_table',1),(3,'2019_08_19_000000_create_failed_jobs_table',1),(4,'2019_12_14_000001_create_personal_access_tokens_table',1),(5,'2025_03_03_110255_create_views_table',2);

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `body` text DEFAULT NULL,
  `heading` varchar(255) DEFAULT NULL,
  `enteredbyid` int(11) DEFAULT 0,
  `is_mark_read` tinyint(1) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=240 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `notifications`
--

INSERT INTO `notifications` VALUES (2,0,'You are assigned to a User as a Employee: Ravi','User Role Assignment',1,0,'2025-04-04 05:42:31','2025-04-04 05:42:31'),(6,0,'You are assigned to a User as a Employee: Ravi','User Role Assignment',1,0,'2025-04-04 05:42:31','2025-04-04 05:42:31'),(8,0,'You are assigned to a User as a Employee: Sathyjeeth','User Role Assignment',1,0,'2025-04-04 06:56:47','2025-04-04 06:56:47'),(12,0,'You are assigned to a User as a Employee: Sathyjeeth','User Role Assignment',1,0,'2025-04-04 06:56:47','2025-04-04 06:56:47'),(14,0,'You are assigned to a User as a User: Sathyjeeth','User Role Assignment',1,0,'2025-04-04 06:58:11','2025-04-04 06:58:11'),(16,0,'You are assigned to a User as a User: Sathyjeeth','User Role Assignment',1,0,'2025-04-04 06:58:11','2025-04-04 06:58:11'),(18,0,'You are assigned to a User as a User: Sathyjeeth','User Role Assignment',1,0,'2025-04-04 06:58:11','2025-04-04 06:58:11'),(20,0,'You are assigned to a User as a User: Sathyjeeth','User Role Assignment',1,0,'2025-04-04 07:00:28','2025-04-04 07:00:28'),(22,0,'You are assigned to a User as a User: Sathyjeeth','User Role Assignment',1,0,'2025-04-04 07:00:28','2025-04-04 07:00:28'),(24,0,'You are assigned to a User as a User: Sathyjeeth','User Role Assignment',1,0,'2025-04-04 07:00:28','2025-04-04 07:00:28'),(26,0,'You are assigned to a User as a User: Sathyjeeth','User Role Assignment',1,0,'2025-04-04 07:01:18','2025-04-04 07:01:18'),(28,0,'You are assigned to a User as a User: Sathyjeeth','User Role Assignment',1,0,'2025-04-04 07:01:18','2025-04-04 07:01:18'),(30,0,'You are assigned to a User as a User: Sathyjeeth','User Role Assignment',1,0,'2025-04-04 07:01:18','2025-04-04 07:01:18'),(32,0,'You are assigned to a User as a Employee: Puneet Omar','User Role Assignment',1,0,'2025-04-04 07:25:59','2025-04-04 07:25:59'),(36,0,'You are assigned to a User as a Employee: Puneet Omar','User Role Assignment',1,0,'2025-04-04 07:25:59','2025-04-04 07:25:59'),(38,0,'You are assigned to a User as a User: Puneet Omar','User Role Assignment',1,0,'2025-04-04 07:27:43','2025-04-04 07:27:43'),(40,0,'You are assigned to a User as a User: Puneet Omar','User Role Assignment',1,0,'2025-04-04 07:27:43','2025-04-04 07:27:43'),(42,0,'You are assigned to a User as a User: Puneet Omar','User Role Assignment',1,0,'2025-04-04 07:27:43','2025-04-04 07:27:43'),(44,0,'You are assigned to a User as a User: Sathyjeeth','User Role Assignment',1,0,'2025-04-04 07:28:04','2025-04-04 07:28:04'),(46,0,'You are assigned to a User as a User: Sathyjeeth','User Role Assignment',1,0,'2025-04-04 07:28:04','2025-04-04 07:28:04'),(48,0,'You are assigned to a User as a User: Sathyjeeth','User Role Assignment',1,0,'2025-04-04 07:28:04','2025-04-04 07:28:04'),(50,0,'You are assigned to a User as a Employee: Anurag','User Role Assignment',1,0,'2025-04-04 07:30:52','2025-04-04 07:30:52'),(54,0,'You are assigned to a User as a Employee: Anurag','User Role Assignment',1,0,'2025-04-04 07:30:53','2025-04-04 07:30:53'),(56,0,'You are assigned to a User as a User: Anurag','User Role Assignment',1,0,'2025-04-04 07:33:38','2025-04-04 07:33:38'),(58,0,'You are assigned to a User as a User: Anurag','User Role Assignment',1,0,'2025-04-04 07:33:38','2025-04-04 07:33:38'),(60,0,'You are assigned to a User as a User: Anurag','User Role Assignment',1,0,'2025-04-04 07:33:38','2025-04-04 07:33:38'),(62,0,'You are assigned to a User as a User: Anurag','User Role Assignment',1,0,'2025-04-04 07:34:25','2025-04-04 07:34:25'),(64,0,'You are assigned to a User as a User: Anurag','User Role Assignment',1,0,'2025-04-04 07:34:25','2025-04-04 07:34:25'),(66,0,'You are assigned to a User as a User: Anurag','User Role Assignment',1,0,'2025-04-04 07:34:25','2025-04-04 07:34:25'),(68,0,'You are assigned to a User as a User: Anurag','User Role Assignment',1,0,'2025-04-04 07:36:17','2025-04-04 07:36:17'),(70,0,'You are assigned to a User as a User: Anurag','User Role Assignment',1,0,'2025-04-04 07:36:17','2025-04-04 07:36:17'),(72,0,'You are assigned to a User as a User: Anurag','User Role Assignment',1,0,'2025-04-04 07:36:18','2025-04-04 07:36:18'),(74,0,'You are assigned to a User as a User: Anurag','User Role Assignment',1,0,'2025-04-04 07:36:37','2025-04-04 07:36:37'),(76,0,'You are assigned to a User as a User: Anurag','User Role Assignment',1,0,'2025-04-04 07:36:37','2025-04-04 07:36:37'),(78,0,'You are assigned to a User as a User: Anurag','User Role Assignment',1,0,'2025-04-04 07:36:37','2025-04-04 07:36:37'),(80,0,'You are assigned to a User as a Employee: Swati','User Role Assignment',1,0,'2025-04-04 07:41:28','2025-04-04 07:41:28'),(84,0,'You are assigned to a User as a Employee: Swati','User Role Assignment',1,0,'2025-04-04 07:41:28','2025-04-04 07:41:28'),(86,0,'You are assigned to a User as a User: Swati','User Role Assignment',1,0,'2025-04-04 07:42:34','2025-04-04 07:42:34'),(88,0,'You are assigned to a User as a User: Swati','User Role Assignment',1,0,'2025-04-04 07:42:34','2025-04-04 07:42:34'),(90,0,'You are assigned to a User as a User: Swati','User Role Assignment',1,0,'2025-04-04 07:42:34','2025-04-04 07:42:34'),(92,0,'You are assigned to a User as a Employee: Prachi','User Role Assignment',1,0,'2025-04-04 07:46:04','2025-04-04 07:46:04'),(96,0,'You are assigned to a User as a Employee: Prachi','User Role Assignment',1,0,'2025-04-04 07:46:04','2025-04-04 07:46:04'),(98,0,'You are assigned to a User as a User: Prachi','User Role Assignment',1,0,'2025-04-04 07:48:41','2025-04-04 07:48:41'),(100,0,'You are assigned to a User as a User: Prachi','User Role Assignment',1,0,'2025-04-04 07:48:41','2025-04-04 07:48:41'),(102,0,'You are assigned to a User as a User: Prachi','User Role Assignment',1,0,'2025-04-04 07:48:41','2025-04-04 07:48:41'),(104,0,'You are assigned to a User as a Employee: Aryan','User Role Assignment',1,0,'2025-04-04 07:51:44','2025-04-04 07:51:44'),(108,0,'You are assigned to a User as a Employee: Aryan','User Role Assignment',1,0,'2025-04-04 07:51:44','2025-04-04 07:51:44'),(110,0,'You are assigned to a User as a User: Sathyjeeth BR','User Role Assignment',1,0,'2025-04-04 07:52:58','2025-04-04 07:52:58'),(112,0,'You are assigned to a User as a User: Sathyjeeth BR','User Role Assignment',1,0,'2025-04-04 07:52:58','2025-04-04 07:52:58'),(114,0,'You are assigned to a User as a User: Sathyjeeth BR','User Role Assignment',1,0,'2025-04-04 07:52:58','2025-04-04 07:52:58'),(116,0,'You are assigned to a User as a User: Sathyjeeth BR','User Role Assignment',1,0,'2025-04-04 07:53:21','2025-04-04 07:53:21'),(118,0,'You are assigned to a User as a User: Sathyjeeth BR','User Role Assignment',1,0,'2025-04-04 07:53:21','2025-04-04 07:53:21'),(120,0,'You are assigned to a User as a User: Sathyjeeth BR','User Role Assignment',1,0,'2025-04-04 07:53:21','2025-04-04 07:53:21'),(122,0,'You are assigned to a User as a Employee: Sumit','User Role Assignment',1,0,'2025-04-04 07:55:34','2025-04-04 07:55:34'),(126,0,'You are assigned to a User as a Employee: Sumit','User Role Assignment',1,0,'2025-04-04 07:55:34','2025-04-04 07:55:34'),(128,0,'You are assigned to a User as a User: Sumit','User Role Assignment',1,0,'2025-04-04 07:56:06','2025-04-04 07:56:06'),(130,0,'You are assigned to a User as a User: Sumit','User Role Assignment',1,0,'2025-04-04 07:56:06','2025-04-04 07:56:06'),(132,0,'You are assigned to a User as a User: Sumit','User Role Assignment',1,0,'2025-04-04 07:56:06','2025-04-04 07:56:06'),(134,0,'You are assigned to a User as a Employee: Arvind','User Role Assignment',1,0,'2025-04-04 07:59:13','2025-04-04 07:59:13'),(138,0,'You are assigned to a User as a Employee: Arvind','User Role Assignment',1,0,'2025-04-04 07:59:13','2025-04-04 07:59:13'),(140,0,'You are assigned to a User as a User: Arvind','User Role Assignment',1,0,'2025-04-04 07:59:59','2025-04-04 07:59:59'),(142,0,'You are assigned to a User as a User: Arvind','User Role Assignment',1,0,'2025-04-04 07:59:59','2025-04-04 07:59:59'),(144,0,'You are assigned to a User as a User: Arvind','User Role Assignment',1,0,'2025-04-04 07:59:59','2025-04-04 07:59:59'),(146,0,'You are assigned to a User as a User: Arvind','User Role Assignment',1,0,'2025-04-04 08:00:21','2025-04-04 08:00:21'),(148,0,'You are assigned to a User as a User: Arvind','User Role Assignment',1,0,'2025-04-04 08:00:21','2025-04-04 08:00:21'),(150,0,'You are assigned to a User as a User: Arvind','User Role Assignment',1,0,'2025-04-04 08:00:21','2025-04-04 08:00:21'),(152,0,'You are assigned to a User as a Employee: Satyam','User Role Assignment',1,0,'2025-04-04 08:04:41','2025-04-04 08:04:41'),(156,0,'You are assigned to a User as a Employee: Satyam','User Role Assignment',1,0,'2025-04-04 08:04:41','2025-04-04 08:04:41'),(158,0,'You are assigned to a User as a User: Satyam','User Role Assignment',1,0,'2025-04-04 08:05:25','2025-04-04 08:05:25'),(160,0,'You are assigned to a User as a User: Satyam','User Role Assignment',1,0,'2025-04-04 08:05:25','2025-04-04 08:05:25'),(162,0,'You are assigned to a User as a User: Satyam','User Role Assignment',1,0,'2025-04-04 08:05:25','2025-04-04 08:05:25'),(164,0,'You are assigned to a User as a Client: OBW','User Role Assignment',1,0,'2025-04-04 08:09:15','2025-04-04 08:09:15'),(168,0,'You are assigned to a User as a Client: OBW','User Role Assignment',1,0,'2025-04-04 08:09:15','2025-04-04 08:09:15'),(170,0,'You are assigned to a User as a Client: Vokks','User Role Assignment',1,0,'2025-04-04 08:10:47','2025-04-04 08:10:47'),(174,0,'You are assigned to a User as a Client: Vokks','User Role Assignment',1,0,'2025-04-04 08:10:47','2025-04-04 08:10:47'),(176,0,'You are assigned to a User as a Client: SRH Community','User Role Assignment',1,0,'2025-04-04 08:11:48','2025-04-04 08:11:48'),(180,0,'You are assigned to a User as a Client: SRH Community','User Role Assignment',1,0,'2025-04-04 08:11:48','2025-04-04 08:11:48'),(182,0,'You are assigned to a User as a Client: Naksha','User Role Assignment',1,0,'2025-04-04 08:15:08','2025-04-04 08:15:08'),(186,0,'You are assigned to a User as a Client: Naksha','User Role Assignment',1,0,'2025-04-04 08:15:08','2025-04-04 08:15:08'),(188,0,'You are assigned to a User as a User: Sathyjeeth BR','User Role Assignment',1,0,'2025-04-04 08:22:27','2025-04-04 08:22:27'),(190,0,'You are assigned to a User as a User: Sathyjeeth BR','User Role Assignment',1,0,'2025-04-04 08:22:27','2025-04-04 08:22:27'),(192,0,'You are assigned to a User as a User: Sathyjeeth BR','User Role Assignment',1,0,'2025-04-04 08:22:27','2025-04-04 08:22:27'),(194,0,'You are assigned to a User as a User: Ravi','User Role Assignment',1,0,'2025-04-04 08:29:01','2025-04-04 08:29:01'),(196,0,'You are assigned to a User as a User: Ravi','User Role Assignment',1,0,'2025-04-04 08:29:01','2025-04-04 08:29:01'),(198,0,'You are assigned to a User as a User: Ravi','User Role Assignment',1,0,'2025-04-04 08:29:01','2025-04-04 08:29:01'),(200,0,'You are assigned to a User as a User: Viju','User Role Assignment',1,0,'2025-04-04 08:30:46','2025-04-04 08:30:46'),(202,0,'You are assigned to a User as a User: Viju','User Role Assignment',1,0,'2025-04-04 08:30:46','2025-04-04 08:30:46'),(204,0,'You are assigned to a User as a User: Viju','User Role Assignment',1,0,'2025-04-04 08:30:46','2025-04-04 08:30:46'),(206,0,'You are assigned to a User as a Client: Unknown','User Role Assignment',1,0,'2025-04-04 08:38:18','2025-04-04 08:38:18'),(210,0,'You are assigned to a User as a Client: Unknown','User Role Assignment',1,0,'2025-04-04 08:38:18','2025-04-04 08:38:18'),(211,8,'You are assigned to a new project: OBW Clinic Website','Project Assignment',1,0,'2025-04-04 08:43:39','2025-04-04 08:43:39'),(212,11,'You are assigned to a new project: OBW Clinic Website','Project Assignment',1,0,'2025-04-04 08:43:39','2025-04-04 08:43:39'),(213,8,'You are assigned to a new project: OBW Salon Website','Project Assignment',1,0,'2025-04-04 08:46:09','2025-04-04 08:46:09'),(214,11,'You are assigned to a new project: OBW Salon Website','Project Assignment',1,0,'2025-04-04 08:46:09','2025-04-04 08:46:09'),(215,4,'You are assigned to a new project: OBW Salon Management','Project Assignment',1,0,'2025-04-04 08:51:55','2025-04-04 08:51:55'),(216,8,'You are assigned to a new project: SRH Community','Project Assignment',1,0,'2025-04-04 08:58:55','2025-04-04 08:58:55'),(217,6,'You are assigned to a new project: SRH Community','Project Assignment',1,0,'2025-04-04 08:58:55','2025-04-04 08:58:55'),(218,4,'You are assigned to a new project: SRH Community','Project Assignment',1,0,'2025-04-04 08:58:55','2025-04-04 08:58:55'),(219,5,'You are assigned to a new project: Vokks','Project Assignment',1,0,'2025-04-04 09:05:34','2025-04-04 09:05:34'),(220,4,'You are assigned to a new project: Vokks','Project Assignment',1,0,'2025-04-04 09:05:34','2025-04-04 09:05:34'),(221,3,'You are assigned to a new project: Vokks','Project Assignment',1,0,'2025-04-04 09:05:34','2025-04-04 09:05:34'),(222,4,'You are assigned to a new project: Freshair Holding','Project Assignment',1,0,'2025-04-04 09:06:38','2025-04-04 09:06:38'),(223,5,'You are assigned to a new project: Freshair Holding','Project Assignment',1,0,'2025-04-04 09:06:38','2025-04-04 09:06:38'),(224,5,'You are assigned to a new project: Freshair Shipping','Project Assignment',1,0,'2025-04-04 09:09:33','2025-04-04 09:09:33'),(225,4,'You are assigned to a new project: Freshair Shipping','Project Assignment',1,0,'2025-04-04 09:09:33','2025-04-04 09:09:33'),(226,10,'You are assigned to a new project: Project Management','Project Assignment',1,0,'2025-04-04 09:13:32','2025-04-04 09:13:32'),(227,7,'You are assigned to a new project: Project Management','Project Assignment',1,0,'2025-04-04 09:13:32','2025-04-04 09:13:32'),(228,7,'You are assigned to a new project: Marketing Management','Project Assignment',1,0,'2025-04-04 09:14:25','2025-04-04 09:14:25'),(229,10,'You are assigned to a new project: Marketing Management','Project Assignment',1,0,'2025-04-04 09:14:25','2025-04-04 09:14:25'),(230,4,'You are assigned to a new project: CMS Laravel','Project Assignment',1,0,'2025-04-04 09:18:44','2025-04-04 09:18:44'),(231,4,'You are assigned to a new project: TMS Laravel','Project Assignment',1,0,'2025-04-04 09:19:30','2025-04-04 09:19:30'),(232,4,'You are assigned to a new project: Megamarket ERP','Project Assignment',1,0,'2025-04-04 09:20:43','2025-04-04 09:20:43'),(233,5,'You are assigned to a new project: Megamarket ERP','Project Assignment',1,0,'2025-04-04 09:20:43','2025-04-04 09:20:43'),(234,4,'You are assigned to a new project: Naksha Travels','Project Assignment',1,0,'2025-04-04 09:22:57','2025-04-04 09:22:57'),(235,5,'You are assigned to a new project: Naksha Travels','Project Assignment',1,0,'2025-04-04 09:22:57','2025-04-04 09:22:57'),(236,4,'You are assigned to a new project: Accounting','Project Assignment',1,0,'2025-04-04 09:24:40','2025-04-04 09:24:40'),(237,3,'You are assigned to a new project: Accounting','Project Assignment',1,0,'2025-04-04 09:24:40','2025-04-04 09:24:40'),(238,2,'You are assigned to a new project: Accounting','Project Assignment',1,0,'2025-04-04 09:24:40','2025-04-04 09:24:40'),(239,5,'You are assigned to a new project: Accounting','Project Assignment',1,0,'2025-04-04 09:24:40','2025-04-04 09:24:40');

--
-- Table structure for table `projects`
--

CREATE TABLE `projects` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `project_name` varchar(255) NOT NULL,
  `client_id` int(11) NOT NULL DEFAULT 0,
  `start_date` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `priority` enum('Low','Medium','High') DEFAULT 'Medium',
  `project_leader` bigint(20) unsigned DEFAULT NULL,
  `project_stage` varchar(255) DEFAULT NULL,
  `team` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `attachments` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `description` text DEFAULT NULL,
  `status` enum('To Do','In Progress','Under Review','Completed','On Hold') DEFAULT 'To Do',
  `project_status` tinyint(1) DEFAULT 1,
  `enteredbyid` int(11) NOT NULL DEFAULT 0,
  `github_backend_date` date DEFAULT NULL,
  `github_frontend_date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `projects`
--

INSERT INTO `projects` VALUES (1,'OBW Clinic Website',12,NULL,NULL,NULL,2,NULL,'[8,11]','[]',NULL,'To Do',1,1,NULL,NULL,'2025-04-04 08:43:39','2025-04-04 08:46:56'),(2,'OBW Salon Website',12,NULL,NULL,NULL,2,NULL,'[8,11]','[]',NULL,'To Do',1,1,NULL,NULL,'2025-04-04 08:46:09','2025-04-04 08:46:41'),(3,'OBW Salon Management',12,NULL,NULL,NULL,2,NULL,'[4]','[]',NULL,'To Do',1,1,NULL,NULL,'2025-04-04 08:51:55','2025-04-04 08:51:55'),(4,'SRH Community',14,NULL,NULL,NULL,2,NULL,'[8,6,4]','[]',NULL,'To Do',1,1,NULL,NULL,'2025-04-04 08:58:55','2025-04-04 08:58:55'),(5,'Vokks',13,NULL,NULL,NULL,4,NULL,'[5,4,3]','[]',NULL,'To Do',1,1,NULL,NULL,'2025-04-04 09:05:34','2025-04-04 09:05:34'),(6,'Freshair Holding',15,NULL,NULL,NULL,2,NULL,'[4,5]','[]',NULL,'To Do',1,1,NULL,NULL,'2025-04-04 09:06:38','2025-04-04 09:06:38'),(7,'Freshair Shipping',15,NULL,NULL,NULL,2,NULL,'[5,4]','[]',NULL,'To Do',1,1,NULL,NULL,'2025-04-04 09:09:33','2025-04-04 09:09:33'),(8,'Project Management',15,NULL,NULL,NULL,3,NULL,'[10,7]','[]',NULL,'To Do',1,1,NULL,NULL,'2025-04-04 09:13:32','2025-04-04 09:13:32'),(9,'Marketing Management',15,NULL,NULL,NULL,3,NULL,'[7,10]','[]',NULL,'To Do',1,1,NULL,NULL,'2025-04-04 09:14:25','2025-04-04 09:14:25'),(10,'CMS Laravel',13,NULL,NULL,NULL,2,NULL,'[4]','[]',NULL,'To Do',1,1,NULL,NULL,'2025-04-04 09:18:44','2025-04-04 09:18:44'),(11,'TMS Laravel',13,NULL,NULL,NULL,2,NULL,'[4]','[]',NULL,'To Do',1,1,NULL,NULL,'2025-04-04 09:19:30','2025-04-04 09:19:30'),(12,'Megamarket ERP',13,NULL,NULL,NULL,4,NULL,'[4,5]','[]',NULL,'To Do',1,1,NULL,NULL,'2025-04-04 09:20:43','2025-04-04 09:20:43'),(13,'Naksha Travels',13,NULL,NULL,NULL,4,NULL,'[4,5]','[]',NULL,'To Do',1,1,NULL,NULL,'2025-04-04 09:22:57','2025-04-04 09:22:57'),(14,'Accounting',15,NULL,NULL,NULL,2,NULL,'[4,3,2,5]','[]',NULL,'To Do',1,1,NULL,NULL,'2025-04-04 09:24:40','2025-04-04 09:24:40');

--
-- Table structure for table `tasks`
--

CREATE TABLE `tasks` (
  `id` bigint(20) unsigned NOT NULL,
  `project_id` int(10) unsigned DEFAULT 0,
  `task_title` varchar(255) NOT NULL,
  `task_type` varchar(255) DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `priority` enum('Low','Medium','High') DEFAULT 'Medium',
  `department` varchar(255) DEFAULT NULL,
  `team` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `visibility` enum('Public','Private') DEFAULT NULL,
  `attachment` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `description` text DEFAULT NULL,
  `status` enum('To Do','In Progress','Under Review','Completed','On Hold') DEFAULT 'To Do',
  `task_status` tinyint(1) NOT NULL DEFAULT 0,
  `rolledback` tinyint(1) NOT NULL DEFAULT 0,
  `platform` varchar(50) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `enteredbyid` int(11) NOT NULL DEFAULT 0,
  `github_backend_date` date DEFAULT NULL,
  `github_frontend_date` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tasks_project_id_foreign` (`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tasks`
--



