{"slug":"wedevs-project-manager","name":"Project Manager – AI Powered Project Management, Task Management, Kanban Board & Time Tracker","description":"Ease Project Management and Task Management using a powerful project manager with Kanban board, Gantt chart, milestone tracking & project reporting.","author":"weDevs","active_installs":6000,"version":"4.0.5","wp_org_url":"https://wordpress.org/plugins/wedevs-project-manager/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"cpm_file_relationship","full_table_name":"wp_cpm_file_relationship","description":"Stores cpm file relationship data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"cpm_time_tracker","full_table_name":"wp_cpm_time_tracker","description":"Stores cpm time tracker data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"cpm_user_role","full_table_name":"wp_cpm_user_role","description":"Stores cpm user role data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"pm_activities","full_table_name":"wp_pm_activities","description":"Stores pm activities data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_pm_activities` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `actor_id` int unsigned NOT NULL,\\n  `action` varchar(255) NOT NULL,\\n  `action_type` varchar(255) NOT NULL,\\n  `resource_id` int unsigned DEFAULT NULL,\\n  `resource_type` varchar(255) DEFAULT NULL,\\n  `meta` text,\\n  `project_id` int unsigned NOT NULL,\\n  `created_at` timestamp NULL DEFAULT NULL,\\n  `updated_at` timestamp NULL DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `project_id` (`project_id`),\\n  KEY `actor_id` (`actor_id`),\\n  KEY `resource_id` (`resource_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"pm_assignees","full_table_name":"wp_pm_assignees","description":"Stores pm assignees data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_pm_assignees` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `task_id` int unsigned NOT NULL,\\n  `assigned_to` int unsigned NOT NULL,\\n  `status` tinyint NOT NULL DEFAULT '0',\\n  `created_by` int unsigned DEFAULT NULL,\\n  `updated_by` int unsigned DEFAULT NULL,\\n  `assigned_at` timestamp NULL DEFAULT NULL,\\n  `started_at` timestamp NULL DEFAULT NULL,\\n  `completed_at` timestamp NULL DEFAULT NULL,\\n  `project_id` int unsigned NOT NULL,\\n  `created_at` timestamp NULL DEFAULT NULL,\\n  `updated_at` timestamp NULL DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `task_id` (`task_id`),\\n  KEY `assigned_to` (`assigned_to`),\\n  KEY `project_id` (`project_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"pm_boardables","full_table_name":"wp_pm_boardables","description":"Stores pm boardables data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_pm_boardables` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `board_id` int unsigned NOT NULL,\\n  `board_type` varchar(255) NOT NULL,\\n  `boardable_id` int unsigned NOT NULL,\\n  `boardable_type` varchar(255) NOT NULL,\\n  `order` int NOT NULL DEFAULT '0',\\n  `created_by` int unsigned DEFAULT NULL,\\n  `updated_by` int unsigned DEFAULT NULL,\\n  `created_at` timestamp NULL DEFAULT NULL,\\n  `updated_at` timestamp NULL DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `board_id` (`board_id`),\\n  KEY `boardable_id` (`boardable_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"pm_boards","full_table_name":"wp_pm_boards","description":"Stores pm boards data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_pm_boards` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `title` varchar(255) NOT NULL,\\n  `description` text,\\n  `order` int unsigned DEFAULT NULL,\\n  `type` varchar(255) DEFAULT NULL,\\n  `status` tinyint unsigned NOT NULL DEFAULT '1',\\n  `is_private` tinyint unsigned DEFAULT '0',\\n  `project_id` int unsigned NOT NULL,\\n  `created_by` int unsigned DEFAULT NULL,\\n  `updated_by` int unsigned DEFAULT NULL,\\n  `created_at` timestamp NULL DEFAULT NULL,\\n  `updated_at` timestamp NULL DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `project_id` (`project_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"pm_capabilities","full_table_name":"wp_pm_capabilities","description":"Stores pm capabilities data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"name","type":"varchar(100)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_pm_capabilities ( `id` int(20) UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) DEFAULT CHARSET"},{"table_name":"pm_categories","full_table_name":"wp_pm_categories","description":"Stores pm categories data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_pm_categories` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `title` varchar(255) NOT NULL,\\n  `description` text,\\n  `categorible_type` varchar(255) DEFAULT NULL,\\n  `created_by` int unsigned DEFAULT NULL,\\n  `updated_by` int unsigned DEFAULT NULL,\\n  `created_at` timestamp NULL DEFAULT NULL,\\n  `updated_at` timestamp NULL DEFAULT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"pm_category_project","full_table_name":"wp_pm_category_project","description":"Stores pm category project data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_pm_category_project` (\\n  `project_id` int unsigned NOT NULL,\\n  `category_id` int unsigned NOT NULL,\\n  KEY `project_id` (`project_id`),\\n  KEY `category_id` (`category_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"pm_comments","full_table_name":"wp_pm_comments","description":"Stores pm comments data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_pm_comments` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `content` text NOT NULL,\\n  `mentioned_users` varchar(255) DEFAULT NULL,\\n  `commentable_id` int unsigned NOT NULL,\\n  `commentable_type` varchar(255) NOT NULL,\\n  `project_id` int unsigned NOT NULL,\\n  `created_by` int unsigned DEFAULT NULL,\\n  `updated_by` int unsigned DEFAULT NULL,\\n  `created_at` timestamp NULL DEFAULT NULL,\\n  `updated_at` timestamp NULL DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `project_id` (`project_id`),\\n  KEY `commentable_id` (`commentable_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"pm_files","full_table_name":"wp_pm_files","description":"Stores pm files data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_pm_files` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `fileable_id` int DEFAULT NULL,\\n  `fileable_type` varchar(255) DEFAULT NULL,\\n  `type` varchar(255) NOT NULL DEFAULT 'file',\\n  `attachment_id` bigint DEFAULT NULL,\\n  `parent` int NOT NULL DEFAULT '0',\\n  `project_id` int unsigned DEFAULT NULL,\\n  `created_by` int unsigned DEFAULT NULL,\\n  `updated_by` int unsigned DEFAULT NULL,\\n  `created_at` timestamp NULL DEFAULT NULL,\\n  `updated_at` timestamp NULL DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `project_id` (`project_id`),\\n  KEY `fileable_id` (`fileable_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"pm_gantt_chart_links","full_table_name":"wp_pm_gantt_chart_links","description":"Stores pm gantt chart links data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"pm_imports","full_table_name":"wp_pm_imports","description":"Stores pm imports data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_pm_imports` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `type` varchar(40) NOT NULL,\\n  `remote_id` varchar(150) NOT NULL,\\n  `local_id` varchar(150) NOT NULL,\\n  `creator_id` int unsigned DEFAULT NULL,\\n  `source` varchar(30) NOT NULL,\\n  `created_at` timestamp NULL DEFAULT NULL,\\n  `updated_at` timestamp NULL DEFAULT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"pm_invoice","full_table_name":"wp_pm_invoice","description":"Stores pm invoice data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"pm_meta","full_table_name":"wp_pm_meta","description":"Stores additional metadata (key-value pairs) for pm records.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_pm_meta` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `entity_id` int unsigned NOT NULL,\\n  `entity_type` varchar(255) NOT NULL,\\n  `meta_key` varchar(255) NOT NULL,\\n  `meta_value` text,\\n  `project_id` int unsigned DEFAULT NULL,\\n  `created_by` int unsigned DEFAULT NULL,\\n  `updated_by` int unsigned DEFAULT NULL,\\n  `created_at` timestamp NULL DEFAULT NULL,\\n  `updated_at` timestamp NULL DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `entity_id` (`entity_id`),\\n  KEY `project_id` (`project_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"pm_projects","full_table_name":"wp_pm_projects","description":"Stores pm projects data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_pm_projects` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `title` varchar(255) NOT NULL,\\n  `description` text,\\n  `status` tinyint NOT NULL DEFAULT '0',\\n  `budget` double(8,2) DEFAULT NULL,\\n  `pay_rate` double(8,2) DEFAULT NULL,\\n  `est_completion_date` timestamp NULL DEFAULT NULL,\\n  `color_code` varchar(255) DEFAULT NULL,\\n  `order` tinyint DEFAULT NULL,\\n  `projectable_type` varchar(255) DEFAULT NULL,\\n  `completed_at` timestamp NULL DEFAULT NULL,\\n  `created_by` int unsigned DEFAULT NULL,\\n  `updated_by` int unsigned DEFAULT NULL,\\n  `created_at` timestamp NULL DEFAULT NULL,\\n  `updated_at` timestamp NULL DEFAULT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"pm_role_project","full_table_name":"wp_pm_role_project","description":"Stores pm role project data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"project_id","type":"int(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"role_id","type":"int(20) UNSIGNED","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_pm_role_project ( `id` int(20) UNSIGNED NOT NULL AUTO_INCREMENT, `project_id` int(20) UNSIGNED NOT NULL, `role_id` int(20) UNSIGNED NOT NULL, PRIMARY KEY (`id`) ) DEFAULT CHARSET"},{"table_name":"pm_role_project_capabilities","full_table_name":"wp_pm_role_project_capabilities","description":"Stores pm role project capabilities data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"role_project_id","type":"int(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"capability_id","type":"int(20) UNSIGNED","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_pm_role_project_capabilities ( `role_project_id` int(20) UNSIGNED NOT NULL, `capability_id` int(20) UNSIGNED NOT NULL, KEY `role_project_id` (`role_project_id`) ) DEFAULT CHARSET"},{"table_name":"pm_role_project_users","full_table_name":"wp_pm_role_project_users","description":"Stores pm role project users data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"role_project_id","type":"int(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"user_id","type":"int(20) UNSIGNED","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_pm_role_project_users ( `role_project_id` int(20) UNSIGNED NOT NULL, `user_id` int(20) UNSIGNED NOT NULL, KEY `role_project_id` (`role_project_id`) ) DEFAULT CHARSET"},{"table_name":"pm_role_user","full_table_name":"wp_pm_role_user","description":"Stores pm role user data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_pm_role_user` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `user_id` int unsigned NOT NULL,\\n  `role_id` int unsigned NOT NULL,\\n  `project_id` int unsigned DEFAULT NULL,\\n  `assigned_by` int unsigned NOT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `project_id` (`project_id`),\\n  KEY `role_id` (`role_id`),\\n  KEY `user_id` (`user_id`),\\n  KEY `assigned_by` (`assigned_by`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"pm_roles","full_table_name":"wp_pm_roles","description":"Stores pm roles data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_pm_roles` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `title` varchar(255) NOT NULL,\\n  `slug` varchar(255) NOT NULL,\\n  `description` text,\\n  `status` tinyint unsigned NOT NULL DEFAULT '1',\\n  `created_by` int unsigned DEFAULT NULL,\\n  `updated_by` int unsigned DEFAULT NULL,\\n  `created_at` timestamp NULL DEFAULT NULL,\\n  `updated_at` timestamp NULL DEFAULT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3"},{"table_name":"pm_settings","full_table_name":"wp_pm_settings","description":"Stores pm settings data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_pm_settings` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `key` varchar(255) NOT NULL,\\n  `value` text,\\n  `project_id` int unsigned DEFAULT NULL,\\n  `created_by` int unsigned DEFAULT NULL,\\n  `updated_by` int unsigned DEFAULT NULL,\\n  `created_at` timestamp NULL DEFAULT NULL,\\n  `updated_at` timestamp NULL DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `project_id` (`project_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"pm_task_type_task","full_table_name":"wp_pm_task_type_task","description":"Stores pm task type task data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_pm_task_type_task` (\\n  `type_id` int unsigned NOT NULL,\\n  `task_id` int unsigned NOT NULL,\\n  `project_id` int unsigned NOT NULL,\\n  `list_id` int unsigned NOT NULL,\\n  UNIQUE KEY `task_id` (`task_id`),\\n  KEY `type_id` (`type_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"pm_task_types","full_table_name":"wp_pm_task_types","description":"Stores pm task types data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_pm_task_types` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `title` varchar(255) NOT NULL,\\n  `description` text,\\n  `type` varchar(255) NOT NULL,\\n  `status` tinyint NOT NULL DEFAULT '0',\\n  `created_by` int unsigned DEFAULT NULL,\\n  `updated_by` int unsigned DEFAULT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"pm_tasks","full_table_name":"wp_pm_tasks","description":"Stores pm tasks data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_pm_tasks` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `title` varchar(255) NOT NULL,\\n  `description` text,\\n  `estimation` int DEFAULT '0',\\n  `start_at` timestamp NULL DEFAULT NULL,\\n  `due_date` timestamp NULL DEFAULT NULL,\\n  `complexity` tinyint DEFAULT NULL,\\n  `priority` tinyint NOT NULL DEFAULT '1',\\n  `payable` tinyint(1) NOT NULL DEFAULT '0',\\n  `recurrent` tinyint(1) NOT NULL DEFAULT '0',\\n  `status` tinyint NOT NULL DEFAULT '0',\\n  `is_private` tinyint unsigned DEFAULT '0',\\n  `project_id` int unsigned NOT NULL,\\n  `parent_id` int unsigned NOT NULL DEFAULT '0',\\n  `completed_by` int unsigned DEFAULT NULL,\\n  `completed_at` timestamp NULL DEFAULT NULL,\\n  `created_by` int unsigned DEFAULT NULL,\\n  `updated_by` int unsigned DEFAULT NULL,\\n  `created_at` timestamp NULL DEFAULT NULL,\\n  `updated_at` timestamp NULL DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `project_id` (`project_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"pm_time_tracker","full_table_name":"wp_pm_time_tracker","description":"Stores pm time tracker data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null}],"table_count":27}