--
-- Host: localhost    Database: jobbox
-- ------------------------------------------------------


--
-- Table structure for table `activations`
--

CREATE TABLE `activations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `code` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `completed` tinyint(1) NOT NULL DEFAULT '0',
  `completed_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `activations_user_id_index` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activations`
--

INSERT INTO `activations` VALUES (1,1,'CbWLrvTqVYMqOYJ9KduMvJZDSefoe01P',1,'2023-03-18 01:06:44','2023-03-18 01:06:44','2023-03-18 01:06:44');

--
-- Table structure for table `admin_notifications`
--

CREATE TABLE `admin_notifications` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `action_label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `action_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci NOT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `admin_notifications`
--


--
-- Table structure for table `audit_histories`
--

CREATE TABLE `audit_histories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `module` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `request` text COLLATE utf8mb4_unicode_ci,
  `action` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `ip_address` varchar(39) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reference_user` bigint unsigned NOT NULL,
  `reference_id` bigint unsigned NOT NULL,
  `reference_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `audit_histories_user_id_index` (`user_id`),
  KEY `audit_histories_module_index` (`module`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `audit_histories`
--


--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent_id` bigint unsigned NOT NULL DEFAULT '0',
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `author_id` bigint unsigned NOT NULL,
  `author_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Botble\\ACL\\Models\\User',
  `icon` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` tinyint NOT NULL DEFAULT '0',
  `is_featured` tinyint NOT NULL DEFAULT '0',
  `is_default` tinyint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `parent_id` (`parent_id`),
  KEY `status` (`status`),
  KEY `created_at` (`created_at`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` VALUES (1,'Design',0,'Est dolores incidunt et tempora nulla. Placeat rerum dolor accusamus minus tempora fugit dolorum. Ipsam et eius odit quia tempora. Repellat aspernatur dolores nisi.','published',1,'Botble\\ACL\\Models\\User',NULL,0,0,1,'2023-03-18 01:06:46','2023-03-18 01:06:46'),(2,'Lifestyle',0,'Unde qui dolorum quia ab. Alias voluptatem ea dolor eum est quisquam dignissimos. Autem et neque maiores alias animi praesentium. Laborum iusto et nulla et.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2023-03-18 01:06:46','2023-03-18 01:06:46'),(3,'Travel Tips',2,'Blanditiis quasi nihil voluptatem autem est iure. Non impedit non sint iusto quidem praesentium. Fugiat est aliquid vel ea accusantium.','published',1,'Botble\\ACL\\Models\\User',NULL,0,0,0,'2023-03-18 01:06:46','2023-03-18 01:06:46'),(4,'Healthy',0,'Illo laudantium odit quibusdam necessitatibus possimus. Corrupti iusto cum cum officiis. Et at autem consequatur voluptates minus et sunt non. Delectus repellendus quia doloremque rerum.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2023-03-18 01:06:46','2023-03-18 01:06:46'),(5,'Travel Tips',4,'Animi porro nihil natus. Est ipsum numquam qui debitis. Repudiandae impedit veniam dolor.','published',1,'Botble\\ACL\\Models\\User',NULL,0,0,0,'2023-03-18 01:06:46','2023-03-18 01:06:46'),(6,'Hotel',0,'Velit quia culpa id quidem nostrum blanditiis inventore repellendus. Perspiciatis doloribus nobis quas. Nihil sed accusantium expedita vel.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2023-03-18 01:06:46','2023-03-18 01:06:46'),(7,'Nature',6,'Rerum libero doloribus nostrum quibusdam. Voluptas asperiores laboriosam deleniti necessitatibus. Autem iure sunt culpa quidem nemo. Et tempora rerum fugiat perspiciatis qui.','published',1,'Botble\\ACL\\Models\\User',NULL,0,0,0,'2023-03-18 01:06:46','2023-03-18 01:06:46');

--
-- Table structure for table `categories_translations`
--

CREATE TABLE `categories_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `categories_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`categories_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories_translations`
--

INSERT INTO `categories_translations` VALUES ('vi',1,'Phong cách sống',NULL),('vi',2,'Sức khỏe',NULL),('vi',3,'Món ngon',NULL);

--
-- Table structure for table `cities`
--

CREATE TABLE `cities` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `state_id` bigint unsigned NOT NULL,
  `country_id` bigint unsigned DEFAULT NULL,
  `record_id` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` tinyint NOT NULL DEFAULT '0',
  `is_default` tinyint unsigned NOT NULL DEFAULT '0',
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cities`
--

INSERT INTO `cities` VALUES (1,'Paris',1,1,NULL,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(2,'London',2,2,NULL,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(3,'New York',3,3,NULL,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(4,'New York',4,4,NULL,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(5,'Copenhagen',5,5,NULL,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(6,'Berlin',6,6,NULL,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49');

--
-- Table structure for table `cities_translations`
--

CREATE TABLE `cities_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cities_id` bigint unsigned NOT NULL,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`cities_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cities_translations`
--


--
-- Table structure for table `contact_replies`
--

CREATE TABLE `contact_replies` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `message` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contact_replies`
--


--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'unread',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contacts`
--

INSERT INTO `contacts` VALUES (1,'Ladarius Cronin','lindgren.ardith@example.net','+12033643050','975 Volkman Run\nWest Orville, VA 52905-6811','Autem ut aut consectetur beatae quia.','Illo ipsum nam in. Eum inventore dolorum officia ut nisi consequuntur. Deleniti mollitia sit sunt pariatur id in sed. Veritatis facere quis dignissimos rem. Rerum accusantium aut omnis totam est dolores aliquid iure. Possimus dignissimos est provident dolore corrupti. Earum esse et pariatur earum perspiciatis molestiae nulla. Rerum molestiae minus quae laboriosam corporis ipsum dolorem. Commodi deserunt necessitatibus consequatur unde voluptatum commodi inventore.','read','2023-03-18 01:06:47','2023-03-18 01:06:47'),(2,'Vida Ratke','nkeebler@example.org','+19497684492','51045 Vinnie Locks Apt. 891\nNorth Christy, CO 90527','Nulla dolorem ut accusamus voluptatem.','Perferendis eos eum tenetur repellat ad neque. Ut voluptatum molestiae distinctio aspernatur voluptate qui. Occaecati qui numquam ipsa omnis voluptas praesentium. Asperiores quas maxime veritatis non corrupti atque cupiditate quos. Occaecati ut quam non praesentium modi reiciendis. Ad rerum tempora architecto voluptas id at vero. Cum eaque laborum ex dicta eum cum odit nobis. Ipsum optio officia veritatis aperiam et.','read','2023-03-18 01:06:47','2023-03-18 01:06:47'),(3,'Candelario Waters','dkuphal@example.org','+18108630088','748 Hill Ridges\nRolfsonfurt, RI 95910','Sint fugiat tempore qui velit voluptate.','Excepturi voluptatibus quas minus cum molestias porro. Ut et voluptatibus quod et quis quos fuga. Quaerat labore et omnis eos. Nulla sint veniam et. Vel voluptatem minus sit voluptatibus qui. Qui reprehenderit vel voluptas earum repellat nihil expedita. Provident temporibus non nihil voluptatum magnam at est. Veniam nesciunt consequuntur in et tempora. Est voluptatem eum fugiat fuga quis. Quia repudiandae et magnam ut maxime assumenda esse.','read','2023-03-18 01:06:47','2023-03-18 01:06:47'),(4,'Anita Gusikowski','ogerlach@example.com','+17474244674','6394 Hahn Dale\nKeelingport, IL 00129','Qui omnis placeat architecto dolores id.','Quae ut et sit sint aut. Quos sit ea inventore est quia quae et. Beatae facere tempore ratione ipsum. Aspernatur voluptas ut voluptas assumenda. Nisi animi suscipit omnis et veniam unde eveniet architecto. Soluta nemo occaecati exercitationem autem error debitis. Aut fugit modi ut quas. Qui at optio sed dolorem consectetur dolorum ut. Ad nihil non repellendus fuga minus magni ullam. Quasi aliquam quisquam at vel error.','read','2023-03-18 01:06:47','2023-03-18 01:06:47'),(5,'Dr. Franz Runolfsdottir V','lherzog@example.org','+19174560793','70753 Hudson Ports Apt. 449\nNorth Gabriellaborough, NV 67192','Nobis quia velit alias non eligendi et sit.','Velit cum esse veniam neque alias recusandae sit. Quas fugit sed quia numquam perferendis aut molestiae. Ipsam et ipsum et rem voluptatem. Laboriosam debitis vel esse. Saepe molestiae asperiores sunt quis quo maxime maxime incidunt. Debitis est dolorum at omnis. Facere ut nisi impedit non dolorum sit quos et. Adipisci culpa ab enim nihil autem. Vero qui expedita minus neque et sed. Modi adipisci quos sed hic hic.','read','2023-03-18 01:06:47','2023-03-18 01:06:47'),(6,'Jayden Tromp','schamberger.josefina@example.net','+16505189950','4047 Andy Circles\nKarianestad, ND 97336-5012','Tempora ipsum qui mollitia corrupti dolorem.','Quasi quas deleniti eum qui optio. Tempora est alias corporis numquam ullam. Accusantium facere est modi odio ratione molestiae. Adipisci eum quia velit aut quia. Nam ut natus est et doloremque. Qui eos voluptatem officia autem suscipit. Deleniti qui iusto qui ea ut numquam. Quos qui officiis consequatur et voluptates neque repellendus. Ad et molestiae maxime vel. Vitae labore soluta recusandae natus voluptatibus.','read','2023-03-18 01:06:47','2023-03-18 01:06:47'),(7,'Emerald Koss','igislason@example.org','+19735630377','5185 Vincent Route Apt. 297\nNew Therese, SD 64880','Sit sed laborum soluta reprehenderit ut eum.','Quia culpa nostrum aliquid nam distinctio dolore. Commodi et quod animi praesentium ut voluptas. Consequatur ad quaerat quod asperiores animi repellendus aliquam. Atque quis ut sunt hic. Aperiam ad nam qui sequi et culpa labore. Non porro voluptatem iure nesciunt facere est. Nam ex illum in sequi ad dolorem sunt. Mollitia quo fugiat ut earum at.','unread','2023-03-18 01:06:47','2023-03-18 01:06:47'),(8,'Phoebe Lockman IV','xebert@example.net','+13603420499','311 Etha Valleys\nLake Caitlyn, MA 60349','Qui neque est aperiam tenetur.','Neque nostrum saepe sit. Molestiae nostrum aperiam est. Sit voluptatibus sunt ullam. Eveniet voluptatem voluptates et omnis. Eaque ipsum nihil vero deserunt quia sunt quam. Et quod perspiciatis quibusdam dolor occaecati voluptatibus quidem. Illo pariatur rerum qui quibusdam fugit officia officia. Ut cum cumque possimus ut qui delectus. Culpa qui ea deleniti rem. Perferendis adipisci sit molestias animi.','read','2023-03-18 01:06:47','2023-03-18 01:06:47'),(9,'Tremaine Herman','clementine72@example.com','+18127090834','975 Rau Prairie Apt. 318\nNew Calista, ME 27314-2140','Qui et molestias nam qui hic esse.','Iste eaque laboriosam error est reiciendis et. Ipsam quia blanditiis aut aspernatur. Eum voluptatem reiciendis et ut facilis nostrum. Ratione autem est in tempore aut quo sint tempore. Dicta autem totam et temporibus. Ut vero porro dolor natus molestiae sed. Accusamus vero explicabo voluptatibus adipisci cum et saepe.','read','2023-03-18 01:06:47','2023-03-18 01:06:47'),(10,'Regan Krajcik','rafael44@example.com','+17472539954','491 Minerva Locks\nMcLaughlinview, MO 64558-1640','Assumenda praesentium ipsum quisquam ipsum porro.','Assumenda in eos numquam modi. Repudiandae id numquam dolorum quis qui reprehenderit facere. Ut deleniti quos at. Ut voluptatibus quas laborum voluptatum quia. Sint quos qui totam ut non amet nihil. Ullam quasi labore eos officiis. Et perspiciatis impedit quia pariatur explicabo quidem molestias sed. Soluta tenetur rerum qui eos quidem ut. Velit aut deserunt consequatur quis praesentium non nostrum. Reiciendis iusto atque laborum qui. Impedit nobis fuga praesentium.','read','2023-03-18 01:06:47','2023-03-18 01:06:47');

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nationality` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` tinyint NOT NULL DEFAULT '0',
  `is_default` tinyint unsigned NOT NULL DEFAULT '0',
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `code` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` VALUES (1,'France','French',0,0,'published','2023-03-18 01:06:49',NULL,'FRA'),(2,'England','English',0,0,'published','2023-03-18 01:06:49',NULL,'UK'),(3,'USA','Americans',0,0,'published','2023-03-18 01:06:49',NULL,'US'),(4,'Holland','Dutch',0,0,'published','2023-03-18 01:06:49',NULL,'HL'),(5,'Denmark','Danish',0,0,'published','2023-03-18 01:06:49',NULL,'DN'),(6,'Germany','Danish',0,0,'published','2023-03-18 01:06:49',NULL,'DN');

--
-- Table structure for table `countries_translations`
--

CREATE TABLE `countries_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `countries_id` bigint unsigned NOT NULL,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nationality` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`countries_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `countries_translations`
--


--
-- Table structure for table `dashboard_widget_settings`
--

CREATE TABLE `dashboard_widget_settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `settings` text COLLATE utf8mb4_unicode_ci,
  `user_id` bigint unsigned NOT NULL,
  `widget_id` bigint unsigned NOT NULL,
  `order` tinyint unsigned NOT NULL DEFAULT '0',
  `status` tinyint unsigned NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `dashboard_widget_settings_user_id_index` (`user_id`),
  KEY `dashboard_widget_settings_widget_id_index` (`widget_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `dashboard_widget_settings`
--


--
-- Table structure for table `dashboard_widgets`
--

CREATE TABLE `dashboard_widgets` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `dashboard_widgets`
--


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

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci 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 `faq_categories`
--

CREATE TABLE `faq_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` tinyint NOT NULL DEFAULT '0',
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `faq_categories`
--

INSERT INTO `faq_categories` VALUES (1,'General',0,'published','2023-03-18 01:06:58','2023-03-18 01:06:58'),(2,'Buying',1,'published','2023-03-18 01:06:58','2023-03-18 01:06:58'),(3,'Payment',2,'published','2023-03-18 01:06:58','2023-03-18 01:06:58'),(4,'Support',3,'published','2023-03-18 01:06:58','2023-03-18 01:06:58');

--
-- Table structure for table `faq_categories_translations`
--

CREATE TABLE `faq_categories_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `faq_categories_id` bigint unsigned NOT NULL,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`faq_categories_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `faq_categories_translations`
--

INSERT INTO `faq_categories_translations` VALUES ('vi',1,'Chung'),('vi',2,'Mua'),('vi',3,'Thanh toán'),('vi',4,'Hổ trợ');

--
-- Table structure for table `faqs`
--

CREATE TABLE `faqs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `question` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `answer` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `category_id` bigint unsigned NOT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `faqs`
--

INSERT INTO `faqs` VALUES (1,'Where does it come from ?','If several languages coalesce, the grammar of the resulting language is more simple and regular than that of the individual languages. The new common language will be more simple and regular than the existing European languages.',1,'published','2023-03-18 01:06:58','2023-03-18 01:06:58'),(2,'How JobBox Work ?','To an English person, it will seem like simplified English, as a skeptical Cambridge friend of mine told me what Occidental is. The European languages are members of the same family. Their separate existence is a myth.',1,'published','2023-03-18 01:06:58','2023-03-18 01:06:58'),(3,'What is your shipping policy?','Everyone realizes why a new common language would be desirable: one could refuse to pay expensive translators. To achieve this, it would be necessary to have uniform grammar, pronunciation and more common words.',1,'published','2023-03-18 01:06:58','2023-03-18 01:06:58'),(4,'Where To Place A FAQ Page','Just as the name suggests, a FAQ page is all about simple questions and answers. Gather common questions your customers have asked from your support team and include them in the FAQ, Use categories to organize questions related to specific topics.',1,'published','2023-03-18 01:06:58','2023-03-18 01:06:58'),(5,'Why do we use it ?','It will be as simple as Occidental; in fact, it will be Occidental. To an English person, it will seem like simplified English, as a skeptical Cambridge friend of mine told me what Occidental.',1,'published','2023-03-18 01:06:58','2023-03-18 01:06:58'),(6,'Where can I get some ?','To an English person, it will seem like simplified English, as a skeptical Cambridge friend of mine told me what Occidental is. The European languages are members of the same family. Their separate existence is a myth.',1,'published','2023-03-18 01:06:58','2023-03-18 01:06:58'),(7,'Where does it come from ?','If several languages coalesce, the grammar of the resulting language is more simple and regular than that of the individual languages. The new common language will be more simple and regular than the existing European languages.',2,'published','2023-03-18 01:06:58','2023-03-18 01:06:58'),(8,'How JobBox Work ?','To an English person, it will seem like simplified English, as a skeptical Cambridge friend of mine told me what Occidental is. The European languages are members of the same family. Their separate existence is a myth.',2,'published','2023-03-18 01:06:58','2023-03-18 01:06:58'),(9,'What is your shipping policy?','Everyone realizes why a new common language would be desirable: one could refuse to pay expensive translators. To achieve this, it would be necessary to have uniform grammar, pronunciation and more common words.',2,'published','2023-03-18 01:06:58','2023-03-18 01:06:58'),(10,'Where To Place A FAQ Page','Just as the name suggests, a FAQ page is all about simple questions and answers. Gather common questions your customers have asked from your support team and include them in the FAQ, Use categories to organize questions related to specific topics.',2,'published','2023-03-18 01:06:58','2023-03-18 01:06:58'),(11,'Why do we use it ?','It will be as simple as Occidental; in fact, it will be Occidental. To an English person, it will seem like simplified English, as a skeptical Cambridge friend of mine told me what Occidental.',2,'published','2023-03-18 01:06:58','2023-03-18 01:06:58'),(12,'Where can I get some ?','To an English person, it will seem like simplified English, as a skeptical Cambridge friend of mine told me what Occidental is. The European languages are members of the same family. Their separate existence is a myth.',2,'published','2023-03-18 01:06:58','2023-03-18 01:06:58'),(13,'Where does it come from ?','If several languages coalesce, the grammar of the resulting language is more simple and regular than that of the individual languages. The new common language will be more simple and regular than the existing European languages.',3,'published','2023-03-18 01:06:58','2023-03-18 01:06:58'),(14,'How JobBox Work ?','To an English person, it will seem like simplified English, as a skeptical Cambridge friend of mine told me what Occidental is. The European languages are members of the same family. Their separate existence is a myth.',3,'published','2023-03-18 01:06:58','2023-03-18 01:06:58'),(15,'What is your shipping policy?','Everyone realizes why a new common language would be desirable: one could refuse to pay expensive translators. To achieve this, it would be necessary to have uniform grammar, pronunciation and more common words.',3,'published','2023-03-18 01:06:58','2023-03-18 01:06:58'),(16,'Where To Place A FAQ Page','Just as the name suggests, a FAQ page is all about simple questions and answers. Gather common questions your customers have asked from your support team and include them in the FAQ, Use categories to organize questions related to specific topics.',3,'published','2023-03-18 01:06:58','2023-03-18 01:06:58'),(17,'Why do we use it ?','It will be as simple as Occidental; in fact, it will be Occidental. To an English person, it will seem like simplified English, as a skeptical Cambridge friend of mine told me what Occidental.',3,'published','2023-03-18 01:06:58','2023-03-18 01:06:58'),(18,'Where can I get some ?','To an English person, it will seem like simplified English, as a skeptical Cambridge friend of mine told me what Occidental is. The European languages are members of the same family. Their separate existence is a myth.',3,'published','2023-03-18 01:06:58','2023-03-18 01:06:58'),(19,'Where does it come from ?','If several languages coalesce, the grammar of the resulting language is more simple and regular than that of the individual languages. The new common language will be more simple and regular than the existing European languages.',4,'published','2023-03-18 01:06:58','2023-03-18 01:06:58'),(20,'How JobBox Work ?','To an English person, it will seem like simplified English, as a skeptical Cambridge friend of mine told me what Occidental is. The European languages are members of the same family. Their separate existence is a myth.',4,'published','2023-03-18 01:06:58','2023-03-18 01:06:58'),(21,'What is your shipping policy?','Everyone realizes why a new common language would be desirable: one could refuse to pay expensive translators. To achieve this, it would be necessary to have uniform grammar, pronunciation and more common words.',4,'published','2023-03-18 01:06:58','2023-03-18 01:06:58'),(22,'Where To Place A FAQ Page','Just as the name suggests, a FAQ page is all about simple questions and answers. Gather common questions your customers have asked from your support team and include them in the FAQ, Use categories to organize questions related to specific topics.',4,'published','2023-03-18 01:06:58','2023-03-18 01:06:58'),(23,'Why do we use it ?','It will be as simple as Occidental; in fact, it will be Occidental. To an English person, it will seem like simplified English, as a skeptical Cambridge friend of mine told me what Occidental.',4,'published','2023-03-18 01:06:58','2023-03-18 01:06:58'),(24,'Where can I get some ?','To an English person, it will seem like simplified English, as a skeptical Cambridge friend of mine told me what Occidental is. The European languages are members of the same family. Their separate existence is a myth.',4,'published','2023-03-18 01:06:58','2023-03-18 01:06:58');

--
-- Table structure for table `faqs_translations`
--

CREATE TABLE `faqs_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `faqs_id` bigint unsigned NOT NULL,
  `question` text COLLATE utf8mb4_unicode_ci,
  `answer` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`lang_code`,`faqs_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `faqs_translations`
--


--
-- Table structure for table `galleries`
--

CREATE TABLE `galleries` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_featured` tinyint unsigned NOT NULL DEFAULT '0',
  `order` tinyint unsigned NOT NULL DEFAULT '0',
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` bigint unsigned NOT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `galleries_user_id_index` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `galleries`
--

INSERT INTO `galleries` VALUES (1,'Perfect','Ipsa labore sed unde. Facere fuga ut ratione et veritatis dolores. Vitae quia facere modi autem mollitia autem sed.',1,0,'galleries/1.jpg',1,'published','2023-03-18 01:06:47','2023-03-18 01:06:47'),(2,'New Day','Sed quasi consequatur et veritatis illo. Dolores eum sit id id sed alias repellendus. Doloribus cum natus nihil.',1,0,'galleries/2.jpg',1,'published','2023-03-18 01:06:47','2023-03-18 01:06:47'),(3,'Happy Day','Sint perspiciatis qui velit tempora odio. Nihil sequi animi placeat dolor sed qui. Velit repellat consectetur est.',1,0,'galleries/3.jpg',1,'published','2023-03-18 01:06:47','2023-03-18 01:06:47'),(4,'Nature','Saepe sit nihil quod libero esse optio consequatur non. Et dolorem et quia possimus. Rerum quis quia quibusdam doloremque maxime praesentium.',1,0,'galleries/4.jpg',1,'published','2023-03-18 01:06:47','2023-03-18 01:06:47'),(5,'Morning','Dolorem cumque adipisci corporis itaque ex sit dolorum. Quaerat id quam eum quis laborum. Tenetur error ab explicabo nihil et.',1,0,'galleries/5.jpg',1,'published','2023-03-18 01:06:47','2023-03-18 01:06:47'),(6,'Photography','Molestiae vel accusantium rerum. Sed saepe consequatur vero. Omnis ex deserunt qui. Quis natus vel perspiciatis laboriosam beatae.',1,0,'galleries/6.jpg',1,'published','2023-03-18 01:06:47','2023-03-18 01:06:47');

--
-- Table structure for table `galleries_translations`
--

CREATE TABLE `galleries_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `galleries_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`lang_code`,`galleries_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `galleries_translations`
--

INSERT INTO `galleries_translations` VALUES ('vi',1,'Hoàn hảo',NULL),('vi',2,'Ngày mới',NULL),('vi',3,'Ngày hạnh phúc',NULL),('vi',4,'Thiên nhiên',NULL),('vi',5,'Buổi sáng',NULL),('vi',6,'Nghệ thuật',NULL);

--
-- Table structure for table `gallery_meta`
--

CREATE TABLE `gallery_meta` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `images` text COLLATE utf8mb4_unicode_ci,
  `reference_id` bigint unsigned NOT NULL,
  `reference_type` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `gallery_meta_reference_id_index` (`reference_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `gallery_meta`
--

INSERT INTO `gallery_meta` VALUES (1,'[{\"img\":\"galleries\\/1.jpg\",\"description\":\"Expedita et veniam laborum quae ullam. Nesciunt sed nisi eligendi qui dolor consequuntur. Iste pariatur sed occaecati unde fugiat.\"},{\"img\":\"galleries\\/2.jpg\",\"description\":\"Ut eaque omnis nulla fuga commodi autem. Qui voluptatum facilis dolorem. Velit quaerat totam laudantium quam autem recusandae est.\"},{\"img\":\"galleries\\/3.jpg\",\"description\":\"Reiciendis cupiditate voluptatem mollitia ipsa deleniti. Aut at modi sint veniam. Est ut est corporis error debitis blanditiis.\"},{\"img\":\"galleries\\/4.jpg\",\"description\":\"Dolor repellat nesciunt ipsam. Harum et voluptas non voluptatem. Cumque delectus repellendus ut dolor veritatis voluptates praesentium.\"},{\"img\":\"galleries\\/5.jpg\",\"description\":\"Quisquam nihil dolores nobis sed doloribus debitis. Et debitis qui vitae. Ducimus et illum ut ut libero temporibus officia.\"},{\"img\":\"galleries\\/6.jpg\",\"description\":\"Ipsa omnis nihil sed totam cumque sit laudantium. Asperiores magnam cupiditate corrupti et.\"},{\"img\":\"galleries\\/7.jpg\",\"description\":\"Provident ipsa repellat praesentium sequi est id est. Sint saepe nemo totam. Enim sit mollitia qui facilis nobis amet.\"},{\"img\":\"galleries\\/8.jpg\",\"description\":\"Nostrum dolores ut est nobis. Velit enim sint dolorum odit. Assumenda nisi non eos dolore maxime. Incidunt quia et ad voluptatum.\"},{\"img\":\"galleries\\/9.jpg\",\"description\":\"Quae nihil eius et quis. Voluptas molestiae quisquam rerum omnis. Repudiandae quae aut excepturi facere fugiat.\"}]',1,'Botble\\Gallery\\Models\\Gallery','2023-03-18 01:06:47','2023-03-18 01:06:47'),(2,'[{\"img\":\"galleries\\/1.jpg\",\"description\":\"Expedita et veniam laborum quae ullam. Nesciunt sed nisi eligendi qui dolor consequuntur. Iste pariatur sed occaecati unde fugiat.\"},{\"img\":\"galleries\\/2.jpg\",\"description\":\"Ut eaque omnis nulla fuga commodi autem. Qui voluptatum facilis dolorem. Velit quaerat totam laudantium quam autem recusandae est.\"},{\"img\":\"galleries\\/3.jpg\",\"description\":\"Reiciendis cupiditate voluptatem mollitia ipsa deleniti. Aut at modi sint veniam. Est ut est corporis error debitis blanditiis.\"},{\"img\":\"galleries\\/4.jpg\",\"description\":\"Dolor repellat nesciunt ipsam. Harum et voluptas non voluptatem. Cumque delectus repellendus ut dolor veritatis voluptates praesentium.\"},{\"img\":\"galleries\\/5.jpg\",\"description\":\"Quisquam nihil dolores nobis sed doloribus debitis. Et debitis qui vitae. Ducimus et illum ut ut libero temporibus officia.\"},{\"img\":\"galleries\\/6.jpg\",\"description\":\"Ipsa omnis nihil sed totam cumque sit laudantium. Asperiores magnam cupiditate corrupti et.\"},{\"img\":\"galleries\\/7.jpg\",\"description\":\"Provident ipsa repellat praesentium sequi est id est. Sint saepe nemo totam. Enim sit mollitia qui facilis nobis amet.\"},{\"img\":\"galleries\\/8.jpg\",\"description\":\"Nostrum dolores ut est nobis. Velit enim sint dolorum odit. Assumenda nisi non eos dolore maxime. Incidunt quia et ad voluptatum.\"},{\"img\":\"galleries\\/9.jpg\",\"description\":\"Quae nihil eius et quis. Voluptas molestiae quisquam rerum omnis. Repudiandae quae aut excepturi facere fugiat.\"}]',2,'Botble\\Gallery\\Models\\Gallery','2023-03-18 01:06:47','2023-03-18 01:06:47'),(3,'[{\"img\":\"galleries\\/1.jpg\",\"description\":\"Expedita et veniam laborum quae ullam. Nesciunt sed nisi eligendi qui dolor consequuntur. Iste pariatur sed occaecati unde fugiat.\"},{\"img\":\"galleries\\/2.jpg\",\"description\":\"Ut eaque omnis nulla fuga commodi autem. Qui voluptatum facilis dolorem. Velit quaerat totam laudantium quam autem recusandae est.\"},{\"img\":\"galleries\\/3.jpg\",\"description\":\"Reiciendis cupiditate voluptatem mollitia ipsa deleniti. Aut at modi sint veniam. Est ut est corporis error debitis blanditiis.\"},{\"img\":\"galleries\\/4.jpg\",\"description\":\"Dolor repellat nesciunt ipsam. Harum et voluptas non voluptatem. Cumque delectus repellendus ut dolor veritatis voluptates praesentium.\"},{\"img\":\"galleries\\/5.jpg\",\"description\":\"Quisquam nihil dolores nobis sed doloribus debitis. Et debitis qui vitae. Ducimus et illum ut ut libero temporibus officia.\"},{\"img\":\"galleries\\/6.jpg\",\"description\":\"Ipsa omnis nihil sed totam cumque sit laudantium. Asperiores magnam cupiditate corrupti et.\"},{\"img\":\"galleries\\/7.jpg\",\"description\":\"Provident ipsa repellat praesentium sequi est id est. Sint saepe nemo totam. Enim sit mollitia qui facilis nobis amet.\"},{\"img\":\"galleries\\/8.jpg\",\"description\":\"Nostrum dolores ut est nobis. Velit enim sint dolorum odit. Assumenda nisi non eos dolore maxime. Incidunt quia et ad voluptatum.\"},{\"img\":\"galleries\\/9.jpg\",\"description\":\"Quae nihil eius et quis. Voluptas molestiae quisquam rerum omnis. Repudiandae quae aut excepturi facere fugiat.\"}]',3,'Botble\\Gallery\\Models\\Gallery','2023-03-18 01:06:47','2023-03-18 01:06:47'),(4,'[{\"img\":\"galleries\\/1.jpg\",\"description\":\"Expedita et veniam laborum quae ullam. Nesciunt sed nisi eligendi qui dolor consequuntur. Iste pariatur sed occaecati unde fugiat.\"},{\"img\":\"galleries\\/2.jpg\",\"description\":\"Ut eaque omnis nulla fuga commodi autem. Qui voluptatum facilis dolorem. Velit quaerat totam laudantium quam autem recusandae est.\"},{\"img\":\"galleries\\/3.jpg\",\"description\":\"Reiciendis cupiditate voluptatem mollitia ipsa deleniti. Aut at modi sint veniam. Est ut est corporis error debitis blanditiis.\"},{\"img\":\"galleries\\/4.jpg\",\"description\":\"Dolor repellat nesciunt ipsam. Harum et voluptas non voluptatem. Cumque delectus repellendus ut dolor veritatis voluptates praesentium.\"},{\"img\":\"galleries\\/5.jpg\",\"description\":\"Quisquam nihil dolores nobis sed doloribus debitis. Et debitis qui vitae. Ducimus et illum ut ut libero temporibus officia.\"},{\"img\":\"galleries\\/6.jpg\",\"description\":\"Ipsa omnis nihil sed totam cumque sit laudantium. Asperiores magnam cupiditate corrupti et.\"},{\"img\":\"galleries\\/7.jpg\",\"description\":\"Provident ipsa repellat praesentium sequi est id est. Sint saepe nemo totam. Enim sit mollitia qui facilis nobis amet.\"},{\"img\":\"galleries\\/8.jpg\",\"description\":\"Nostrum dolores ut est nobis. Velit enim sint dolorum odit. Assumenda nisi non eos dolore maxime. Incidunt quia et ad voluptatum.\"},{\"img\":\"galleries\\/9.jpg\",\"description\":\"Quae nihil eius et quis. Voluptas molestiae quisquam rerum omnis. Repudiandae quae aut excepturi facere fugiat.\"}]',4,'Botble\\Gallery\\Models\\Gallery','2023-03-18 01:06:47','2023-03-18 01:06:47'),(5,'[{\"img\":\"galleries\\/1.jpg\",\"description\":\"Expedita et veniam laborum quae ullam. Nesciunt sed nisi eligendi qui dolor consequuntur. Iste pariatur sed occaecati unde fugiat.\"},{\"img\":\"galleries\\/2.jpg\",\"description\":\"Ut eaque omnis nulla fuga commodi autem. Qui voluptatum facilis dolorem. Velit quaerat totam laudantium quam autem recusandae est.\"},{\"img\":\"galleries\\/3.jpg\",\"description\":\"Reiciendis cupiditate voluptatem mollitia ipsa deleniti. Aut at modi sint veniam. Est ut est corporis error debitis blanditiis.\"},{\"img\":\"galleries\\/4.jpg\",\"description\":\"Dolor repellat nesciunt ipsam. Harum et voluptas non voluptatem. Cumque delectus repellendus ut dolor veritatis voluptates praesentium.\"},{\"img\":\"galleries\\/5.jpg\",\"description\":\"Quisquam nihil dolores nobis sed doloribus debitis. Et debitis qui vitae. Ducimus et illum ut ut libero temporibus officia.\"},{\"img\":\"galleries\\/6.jpg\",\"description\":\"Ipsa omnis nihil sed totam cumque sit laudantium. Asperiores magnam cupiditate corrupti et.\"},{\"img\":\"galleries\\/7.jpg\",\"description\":\"Provident ipsa repellat praesentium sequi est id est. Sint saepe nemo totam. Enim sit mollitia qui facilis nobis amet.\"},{\"img\":\"galleries\\/8.jpg\",\"description\":\"Nostrum dolores ut est nobis. Velit enim sint dolorum odit. Assumenda nisi non eos dolore maxime. Incidunt quia et ad voluptatum.\"},{\"img\":\"galleries\\/9.jpg\",\"description\":\"Quae nihil eius et quis. Voluptas molestiae quisquam rerum omnis. Repudiandae quae aut excepturi facere fugiat.\"}]',5,'Botble\\Gallery\\Models\\Gallery','2023-03-18 01:06:47','2023-03-18 01:06:47'),(6,'[{\"img\":\"galleries\\/1.jpg\",\"description\":\"Expedita et veniam laborum quae ullam. Nesciunt sed nisi eligendi qui dolor consequuntur. Iste pariatur sed occaecati unde fugiat.\"},{\"img\":\"galleries\\/2.jpg\",\"description\":\"Ut eaque omnis nulla fuga commodi autem. Qui voluptatum facilis dolorem. Velit quaerat totam laudantium quam autem recusandae est.\"},{\"img\":\"galleries\\/3.jpg\",\"description\":\"Reiciendis cupiditate voluptatem mollitia ipsa deleniti. Aut at modi sint veniam. Est ut est corporis error debitis blanditiis.\"},{\"img\":\"galleries\\/4.jpg\",\"description\":\"Dolor repellat nesciunt ipsam. Harum et voluptas non voluptatem. Cumque delectus repellendus ut dolor veritatis voluptates praesentium.\"},{\"img\":\"galleries\\/5.jpg\",\"description\":\"Quisquam nihil dolores nobis sed doloribus debitis. Et debitis qui vitae. Ducimus et illum ut ut libero temporibus officia.\"},{\"img\":\"galleries\\/6.jpg\",\"description\":\"Ipsa omnis nihil sed totam cumque sit laudantium. Asperiores magnam cupiditate corrupti et.\"},{\"img\":\"galleries\\/7.jpg\",\"description\":\"Provident ipsa repellat praesentium sequi est id est. Sint saepe nemo totam. Enim sit mollitia qui facilis nobis amet.\"},{\"img\":\"galleries\\/8.jpg\",\"description\":\"Nostrum dolores ut est nobis. Velit enim sint dolorum odit. Assumenda nisi non eos dolore maxime. Incidunt quia et ad voluptatum.\"},{\"img\":\"galleries\\/9.jpg\",\"description\":\"Quae nihil eius et quis. Voluptas molestiae quisquam rerum omnis. Repudiandae quae aut excepturi facere fugiat.\"}]',6,'Botble\\Gallery\\Models\\Gallery','2023-03-18 01:06:47','2023-03-18 01:06:47');

--
-- Table structure for table `gallery_meta_translations`
--

CREATE TABLE `gallery_meta_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gallery_meta_id` bigint unsigned NOT NULL,
  `images` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`lang_code`,`gallery_meta_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `gallery_meta_translations`
--


--
-- Table structure for table `jb_account_activity_logs`
--

CREATE TABLE `jb_account_activity_logs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `action` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `reference_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reference_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ip_address` varchar(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `1` (`account_id`),
  CONSTRAINT `1` FOREIGN KEY (`account_id`) REFERENCES `jb_accounts` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_account_activity_logs`
--


--
-- Table structure for table `jb_account_educations`
--

CREATE TABLE `jb_account_educations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `school` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `account_id` bigint unsigned NOT NULL,
  `specialized` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `started_at` date NOT NULL,
  `ended_at` date DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_account_educations`
--

INSERT INTO `jb_account_educations` VALUES (1,'Adams State College',2,'Classical Studies','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:51','2023-03-18 01:06:51'),(2,'Adams State College',7,'Economics','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:52','2023-03-18 01:06:52'),(3,'Associated Mennonite Biblical Seminary',8,'Classical Studies','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:52','2023-03-18 01:06:52'),(4,'The University of the State of Alabama',9,'Art History','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:52','2023-03-18 01:06:52'),(5,'The University of the State of Alabama',11,'Culture and Technology Studie','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:52','2023-03-18 01:06:52'),(6,'The University of the State of Alabama',12,'Classical Studies','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:52','2023-03-18 01:06:52'),(7,'Antioch University McGregor',13,'Economics','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:52','2023-03-18 01:06:52'),(8,'Associated Mennonite Biblical Seminary',15,'Anthropology','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:52','2023-03-18 01:06:52'),(9,'Gateway Technical College',17,'Classical Studies','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:52','2023-03-18 01:06:52'),(10,'Gateway Technical College',18,'Culture and Technology Studie','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:52','2023-03-18 01:06:52'),(11,'The University of the State of Alabama',22,'Art History','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:53','2023-03-18 01:06:53'),(12,'The University of the State of Alabama',26,'Economics','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:53','2023-03-18 01:06:53'),(13,'Antioch University McGregor',31,'Culture and Technology Studie','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:53','2023-03-18 01:06:53'),(14,'Antioch University McGregor',34,'Anthropology','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:53','2023-03-18 01:06:53'),(15,'Antioch University McGregor',37,'Economics','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:54','2023-03-18 01:06:54'),(16,'Gateway Technical College',38,'Classical Studies','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:54','2023-03-18 01:06:54'),(17,'The University of the State of Alabama',42,'Economics','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:54','2023-03-18 01:06:54'),(18,'Associated Mennonite Biblical Seminary',44,'Anthropology','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:54','2023-03-18 01:06:54'),(19,'American Institute of Health Technology',47,'Culture and Technology Studie','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:54','2023-03-18 01:06:54'),(20,'Associated Mennonite Biblical Seminary',48,'Culture and Technology Studie','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:54','2023-03-18 01:06:54'),(21,'Adams State College',51,'Culture and Technology Studie','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:55','2023-03-18 01:06:55'),(22,'Gateway Technical College',52,'Economics','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:55','2023-03-18 01:06:55'),(23,'Associated Mennonite Biblical Seminary',56,'Classical Studies','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:55','2023-03-18 01:06:55'),(24,'The University of the State of Alabama',59,'Anthropology','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:55','2023-03-18 01:06:55'),(25,'The University of the State of Alabama',62,'Anthropology','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:55','2023-03-18 01:06:55'),(26,'Gateway Technical College',63,'Art History','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:55','2023-03-18 01:06:55'),(27,'Antioch University McGregor',65,'Culture and Technology Studie','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:55','2023-03-18 01:06:55'),(28,'Adams State College',66,'Anthropology','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:56','2023-03-18 01:06:56'),(29,'The University of the State of Alabama',67,'Art History','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:56','2023-03-18 01:06:56'),(30,'Gateway Technical College',71,'Culture and Technology Studie','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:56','2023-03-18 01:06:56'),(31,'The University of the State of Alabama',74,'Culture and Technology Studie','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:56','2023-03-18 01:06:56'),(32,'The University of the State of Alabama',75,'Economics','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:56','2023-03-18 01:06:56'),(33,'Associated Mennonite Biblical Seminary',76,'Anthropology','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:56','2023-03-18 01:06:56'),(34,'The University of the State of Alabama',77,'Art History','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:56','2023-03-18 01:06:56'),(35,'Associated Mennonite Biblical Seminary',80,'Art History','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:56','2023-03-18 01:06:56'),(36,'American Institute of Health Technology',81,'Classical Studies','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:57','2023-03-18 01:06:57'),(37,'American Institute of Health Technology',82,'Anthropology','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:57','2023-03-18 01:06:57'),(38,'American Institute of Health Technology',83,'Economics','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:57','2023-03-18 01:06:57'),(39,'Gateway Technical College',85,'Art History','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:57','2023-03-18 01:06:57'),(40,'Gateway Technical College',86,'Economics','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:57','2023-03-18 01:06:57'),(41,'Adams State College',87,'Anthropology','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:57','2023-03-18 01:06:57'),(42,'The University of the State of Alabama',88,'Economics','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:57','2023-03-18 01:06:57'),(43,'American Institute of Health Technology',91,'Art History','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:57','2023-03-18 01:06:57'),(44,'Antioch University McGregor',92,'Culture and Technology Studie','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:57','2023-03-18 01:06:57'),(45,'The University of the State of Alabama',95,'Classical Studies','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:57','2023-03-18 01:06:57'),(46,'American Institute of Health Technology',96,'Art History','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:57','2023-03-18 01:06:57'),(47,'The University of the State of Alabama',97,'Classical Studies','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:58','2023-03-18 01:06:58'),(48,'American Institute of Health Technology',98,'Anthropology','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:58','2023-03-18 01:06:58'),(49,'Associated Mennonite Biblical Seminary',100,'Art History','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:58','2023-03-18 01:06:58');

--
-- Table structure for table `jb_account_experiences`
--

CREATE TABLE `jb_account_experiences` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `account_id` bigint unsigned NOT NULL,
  `position` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `started_at` date NOT NULL,
  `ended_at` date DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_account_experiences`
--

INSERT INTO `jb_account_experiences` VALUES (1,'Spa Paragon',2,'Marketing Coordinator','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:51','2023-03-18 01:06:51'),(2,'Exploration Kids',7,'Web Designer','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:52','2023-03-18 01:06:52'),(3,'Darwin Travel',8,'Web Designer','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:52','2023-03-18 01:06:52'),(4,'Spa Paragon',9,'Project Manager','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:52','2023-03-18 01:06:52'),(5,'Darwin Travel',11,'Marketing Coordinator','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:52','2023-03-18 01:06:52'),(6,'Party Plex',12,'Dog Trainer','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:52','2023-03-18 01:06:52'),(7,'GameDay Cateringn',13,'Dog Trainer','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:52','2023-03-18 01:06:52'),(8,'Darwin Travel',15,'Marketing Coordinator','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:52','2023-03-18 01:06:52'),(9,'Spa Paragon',17,'President of Sales','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:52','2023-03-18 01:06:52'),(10,'Exploration Kids',18,'President of Sales','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:52','2023-03-18 01:06:52'),(11,'Party Plex',22,'Marketing Coordinator','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:53','2023-03-18 01:06:53'),(12,'Party Plex',26,'Dog Trainer','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:53','2023-03-18 01:06:53'),(13,'Darwin Travel',31,'Project Manager','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:53','2023-03-18 01:06:53'),(14,'Exploration Kids',34,'Project Manager','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:53','2023-03-18 01:06:53'),(15,'GameDay Cateringn',37,'Dog Trainer','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:54','2023-03-18 01:06:54'),(16,'Spa Paragon',38,'Dog Trainer','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:54','2023-03-18 01:06:54'),(17,'Darwin Travel',42,'Marketing Coordinator','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:54','2023-03-18 01:06:54'),(18,'GameDay Cateringn',44,'Project Manager','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:54','2023-03-18 01:06:54'),(19,'GameDay Cateringn',47,'Web Designer','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:54','2023-03-18 01:06:54'),(20,'Party Plex',48,'President of Sales','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:54','2023-03-18 01:06:54'),(21,'Exploration Kids',51,'Dog Trainer','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:55','2023-03-18 01:06:55'),(22,'Exploration Kids',52,'Web Designer','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:55','2023-03-18 01:06:55'),(23,'Darwin Travel',56,'Project Manager','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:55','2023-03-18 01:06:55'),(24,'GameDay Cateringn',59,'Project Manager','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:55','2023-03-18 01:06:55'),(25,'Spa Paragon',62,'Project Manager','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:55','2023-03-18 01:06:55'),(26,'GameDay Cateringn',63,'President of Sales','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:55','2023-03-18 01:06:55'),(27,'Exploration Kids',65,'Marketing Coordinator','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:55','2023-03-18 01:06:55'),(28,'Party Plex',66,'Project Manager','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:56','2023-03-18 01:06:56'),(29,'Darwin Travel',67,'President of Sales','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:56','2023-03-18 01:06:56'),(30,'Party Plex',71,'Dog Trainer','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:56','2023-03-18 01:06:56'),(31,'Exploration Kids',74,'Web Designer','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:56','2023-03-18 01:06:56'),(32,'Exploration Kids',75,'Marketing Coordinator','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:56','2023-03-18 01:06:56'),(33,'GameDay Cateringn',76,'Web Designer','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:56','2023-03-18 01:06:56'),(34,'Spa Paragon',77,'Dog Trainer','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:56','2023-03-18 01:06:56'),(35,'GameDay Cateringn',80,'President of Sales','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:56','2023-03-18 01:06:56'),(36,'Party Plex',81,'Dog Trainer','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:57','2023-03-18 01:06:57'),(37,'Darwin Travel',82,'President of Sales','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:57','2023-03-18 01:06:57'),(38,'Spa Paragon',83,'Project Manager','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:57','2023-03-18 01:06:57'),(39,'Spa Paragon',85,'Web Designer','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:57','2023-03-18 01:06:57'),(40,'Spa Paragon',86,'President of Sales','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:57','2023-03-18 01:06:57'),(41,'GameDay Cateringn',87,'President of Sales','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:57','2023-03-18 01:06:57'),(42,'Party Plex',88,'Project Manager','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:57','2023-03-18 01:06:57'),(43,'Party Plex',91,'Project Manager','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:57','2023-03-18 01:06:57'),(44,'Spa Paragon',92,'Marketing Coordinator','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:57','2023-03-18 01:06:57'),(45,'Exploration Kids',95,'Marketing Coordinator','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:57','2023-03-18 01:06:57'),(46,'Exploration Kids',96,'Project Manager','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:57','2023-03-18 01:06:57'),(47,'Spa Paragon',97,'Project Manager','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:58','2023-03-18 01:06:58'),(48,'Darwin Travel',98,'Dog Trainer','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:58','2023-03-18 01:06:58'),(49,'Spa Paragon',100,'Project Manager','2023-03-18','2023-03-18','There are many variations of passages of available, but the majority alteration in some form.\n                As a highly skilled and successfull product development and design specialist with more than 4 Years of\n                My experience','2023-03-18 01:06:58','2023-03-18 01:06:58');

--
-- Table structure for table `jb_account_favorite_skills`
--

CREATE TABLE `jb_account_favorite_skills` (
  `skill_id` bigint unsigned NOT NULL,
  `account_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`skill_id`,`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_account_favorite_skills`
--


--
-- Table structure for table `jb_account_favorite_tags`
--

CREATE TABLE `jb_account_favorite_tags` (
  `tag_id` bigint unsigned NOT NULL,
  `account_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`tag_id`,`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_account_favorite_tags`
--


--
-- Table structure for table `jb_account_packages`
--

CREATE TABLE `jb_account_packages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `account_id` bigint unsigned NOT NULL,
  `package_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_account_packages`
--


--
-- Table structure for table `jb_account_password_resets`
--

CREATE TABLE `jb_account_password_resets` (
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `jb_account_password_resets_email_index` (`email`),
  KEY `jb_account_password_resets_token_index` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_account_password_resets`
--


--
-- Table structure for table `jb_analytics`
--

CREATE TABLE `jb_analytics` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `job_id` bigint unsigned NOT NULL,
  `country` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_full` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `referer` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ip_address` varchar(300) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_analytics`
--


--
-- Table structure for table `jb_applications`
--

CREATE TABLE `jb_applications` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `first_name` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` text COLLATE utf8mb4_unicode_ci,
  `job_id` bigint unsigned NOT NULL,
  `resume` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cover_letter` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_id` bigint unsigned DEFAULT NULL,
  `is_external_apply` tinyint(1) NOT NULL DEFAULT '0',
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_applications`
--

INSERT INTO `jb_applications` VALUES (1,'Roselyn','Gislason','+18503892649','lina.schmitt@hotmail.com','Alice, \'they\'re sure to make herself useful, and looking at Alice for some way, and the Queen of Hearts, she made out what it was too small, but at the sudden change, but she felt unhappy. \'It was.',10,'resume/01.pdf','resume/01.pdf',88,1,'checked','2023-03-18 01:06:58','2023-03-18 01:06:58'),(2,'Luna','Mohr','+12815449482','emard.eliseo@ledner.net','She was looking at Alice as he spoke. \'A cat may look at it!\' This speech caused a remarkable sensation among the branches, and every now and then all the arches are gone from this morning,\' said.',22,'resume/01.pdf','resume/01.pdf',71,0,'checked','2023-03-18 01:06:58','2023-03-18 01:06:58'),(3,'Theo','Quitzon','+19893745124','cstehr@kozey.com','Rabbit began. Alice thought to herself, rather sharply; \'I advise you to death.\"\' \'You are old,\' said the Duchess: \'what a clear way you can;--but I must be getting somewhere near the looking-glass.',33,'resume/01.pdf','resume/01.pdf',85,1,'checked','2023-03-18 01:06:58','2023-03-18 01:06:58'),(4,'April','O\'Connell','+19176351041','jacey71@gmail.com','It was as steady as ever; Yet you finished the goose, with the lobsters and the other side. The further off from England the nearer is to do this, so that by the end of the hall; but, alas! either.',43,'resume/01.pdf','resume/01.pdf',87,0,'checked','2023-03-18 01:06:58','2023-03-18 01:06:58'),(5,'Desiree','Lakin','+18452678548','padberg.mandy@legros.com','Soo--oop! Beau--ootiful Soo--oop! Soo--oop of the busy farm-yard--while the lowing of the song. \'What trial is it?\' The Gryphon lifted up both its paws in surprise. \'What! Never heard of.',46,'resume/01.pdf','resume/01.pdf',77,1,'checked','2023-03-18 01:06:58','2023-03-18 01:06:58'),(6,'Jacques','Grady','+15807317800','akeem.kreiger@gmail.com','ME, and told me he was speaking, so that her idea of having nothing to do.\" Said the mouse to the voice of the month, and doesn\'t tell what o\'clock it is!\' \'Why should it?\' muttered the Hatter. This.',5,'resume/01.pdf','resume/01.pdf',17,1,'checked','2023-03-18 01:06:58','2023-03-18 01:06:58'),(7,'Jana','Upton','+14354836498','madisen.auer@emmerich.com','If she should meet the real Mary Ann, what ARE you talking to?\' said the Gryphon. \'Of course,\' the Dodo said, \'EVERYBODY has won, and all the rest, Between yourself and me.\' \'That\'s the reason of.',40,'resume/01.pdf','resume/01.pdf',44,0,'checked','2023-03-18 01:06:58','2023-03-18 01:06:58'),(8,'Alphonso','Block','+13046753183','nkuphal@yahoo.com','Lobster Quadrille?\' the Gryphon never learnt it.\' \'Hadn\'t time,\' said the Caterpillar took the place of the moment she appeared; but she could remember about ravens and writing-desks, which wasn\'t.',3,'resume/01.pdf','resume/01.pdf',98,0,'checked','2023-03-18 01:06:58','2023-03-18 01:06:58'),(9,'Adaline','Stehr','+14709817922','job_seeker@archielite.com','I suppose Dinah\'ll be sending me on messages next!\' And she began again. \'I wonder if I\'ve kept her waiting!\' Alice felt that this could not swim. He sent them word I had not gone much farther.',44,'resume/01.pdf','resume/01.pdf',2,0,'checked','2023-03-18 01:06:58','2023-03-18 01:06:58'),(10,'Odessa','Doyle','+15867355643','zhartmann@dickinson.com','Cat. \'Do you play croquet with the tarts, you know--\' \'What did they live at the March Hare. Alice was beginning to think that there was room for her. \'I wish I hadn\'t cried so much!\' Alas! it was.',36,'resume/01.pdf','resume/01.pdf',26,0,'checked','2023-03-18 01:06:58','2023-03-18 01:06:58'),(11,'Estevan','Lockman','+16079484326','estella94@kunze.com','And with that she began fancying the sort of knot, and then I\'ll tell you my history, and you\'ll understand why it is I hate cats and dogs.\' It was the White Rabbit returning, splendidly dressed.',1,'resume/01.pdf','resume/01.pdf',13,0,'checked','2023-03-18 01:06:58','2023-03-18 01:06:58'),(12,'Reyes','Rutherford','+18209549142','lstehr@hotmail.com','Alice could see it again, but it did not like to have changed since her swim in the sky. Alice went on, looking anxiously round to see it pop down a very little! Besides, SHE\'S she, and I\'m sure.',50,'resume/01.pdf','resume/01.pdf',63,1,'checked','2023-03-18 01:06:58','2023-03-18 01:06:58'),(13,'Nathan','Dickinson','+17373170090','alaina.marvin@gmail.com','Alice, \'to pretend to be an advantage,\' said Alice, who always took a great interest in questions of eating and drinking. \'They lived on treacle,\' said the Eaglet. \'I don\'t think it\'s at all.',16,'resume/01.pdf','resume/01.pdf',95,1,'checked','2023-03-18 01:06:58','2023-03-18 01:06:58'),(14,'Jamaal','Conroy','+13349208221','koepp.jeromy@koelpin.com','When they take us up and down, and the Hatter went on, half to herself, \'whenever I eat one of them attempted to explain the paper. \'If there\'s no harm in trying.\' So she began fancying the sort of.',14,'resume/01.pdf','resume/01.pdf',31,0,'checked','2023-03-18 01:06:58','2023-03-18 01:06:58'),(15,'Noemi','Schimmel','+14252786838','abraham.altenwerth@gmail.com','Alice, (she had kept a piece of it at all,\' said Alice: \'she\'s so extremely--\' Just then she remembered the number of bathing machines in the lock, and to her great disappointment it was very nearly.',47,'resume/01.pdf','resume/01.pdf',56,1,'checked','2023-03-18 01:06:58','2023-03-18 01:06:58'),(16,'Elena','Ebert','+14849444695','cordelia91@bahringer.com','Alice\'s great surprise, the Duchess\'s cook. She carried the pepper-box in her lessons in the face. \'I\'ll put a stop to this,\' she said to herself, \'to be going messages for a baby: altogether Alice.',29,'resume/01.pdf','resume/01.pdf',66,0,'checked','2023-03-18 01:06:58','2023-03-18 01:06:58'),(17,'Durward','Willms','+17472961168','kwalker@yahoo.com','Pigeon in a VERY turn-up nose, much more like a serpent. She had quite forgotten the words.\' So they sat down again into its eyes again, to see that the Mouse replied rather impatiently: \'any shrimp.',11,'resume/01.pdf','resume/01.pdf',47,1,'checked','2023-03-18 01:06:58','2023-03-18 01:06:58'),(18,'Tito','Wehner','+18725326016','willms.kian@yahoo.com','Come on!\' So they had been to her, though, as they came nearer, Alice could not think of what work it would be the right way to change the subject. \'Ten hours the first to speak. \'What size do you.',31,'resume/01.pdf','resume/01.pdf',80,1,'checked','2023-03-18 01:06:58','2023-03-18 01:06:58'),(19,'Joyce','Kiehn','+17795050149','neal89@gmail.com','Mouse replied rather impatiently: \'any shrimp could have been changed for any lesson-books!\' And so it was an uncomfortably sharp chin. However, she soon made out the Fish-Footman was gone, and, by.',26,'resume/01.pdf','resume/01.pdf',7,1,'checked','2023-03-18 01:06:58','2023-03-18 01:06:58'),(20,'Eriberto','Towne','+15084317015','hilario.goldner@gmail.com','Alice, very loudly and decidedly, and the moment she quite forgot how to get to,\' said the Dormouse, who was a long way back, and barking hoarsely all the jelly-fish out of his Normans--\" How are.',17,'resume/01.pdf','resume/01.pdf',86,1,'checked','2023-03-18 01:06:58','2023-03-18 01:06:58');

--
-- Table structure for table `jb_career_levels`
--

CREATE TABLE `jb_career_levels` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` tinyint NOT NULL DEFAULT '0',
  `is_default` tinyint unsigned NOT NULL DEFAULT '0',
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_career_levels`
--

INSERT INTO `jb_career_levels` VALUES (1,'Department Head',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(2,'Entry Level',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(3,'Experienced Professional',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(4,'GM / CEO / Country Head / President',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(5,'Intern/Student',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49');

--
-- Table structure for table `jb_career_levels_translations`
--

CREATE TABLE `jb_career_levels_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jb_career_levels_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`jb_career_levels_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_career_levels_translations`
--


--
-- Table structure for table `jb_categories`
--

CREATE TABLE `jb_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` tinyint NOT NULL DEFAULT '0',
  `is_default` tinyint unsigned NOT NULL DEFAULT '0',
  `is_featured` tinyint NOT NULL DEFAULT '0',
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_categories`
--

INSERT INTO `jb_categories` VALUES (1,'Content Writer',NULL,0,0,1,'published','2023-03-18 01:06:50','2023-03-18 01:06:50'),(2,'Market Research',NULL,1,0,1,'published','2023-03-18 01:06:50','2023-03-18 01:06:50'),(3,'Marketing & Sale',NULL,2,0,1,'published','2023-03-18 01:06:50','2023-03-18 01:06:50'),(4,'Customer Help',NULL,3,0,1,'published','2023-03-18 01:06:50','2023-03-18 01:06:50'),(5,'Finance',NULL,4,0,1,'published','2023-03-18 01:06:50','2023-03-18 01:06:50'),(6,'Software',NULL,5,0,1,'published','2023-03-18 01:06:50','2023-03-18 01:06:50'),(7,'Human Resource',NULL,6,0,1,'published','2023-03-18 01:06:50','2023-03-18 01:06:50'),(8,'Management',NULL,7,0,1,'published','2023-03-18 01:06:50','2023-03-18 01:06:50'),(9,'Retail & Products',NULL,8,0,0,'published','2023-03-18 01:06:50','2023-03-18 01:06:50'),(10,'Security Analyst',NULL,9,0,0,'published','2023-03-18 01:06:50','2023-03-18 01:06:50');

--
-- Table structure for table `jb_categories_translations`
--

CREATE TABLE `jb_categories_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jb_categories_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`jb_categories_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_categories_translations`
--

INSERT INTO `jb_categories_translations` VALUES ('vi',1,'Nguời viết nội dung',NULL),('vi',2,'Nghiên cứu thị trường',NULL),('vi',3,'Tiếp thị',NULL),('vi',4,'Chăm sóc khách hàng',NULL),('vi',5,'Tài chính kế toán',NULL),('vi',6,'Kỹ thuật phần mềm',NULL),('vi',7,'Quản lý nhân sự',NULL),('vi',8,'Quản lý',NULL),('vi',9,'Bán hàng',NULL),('vi',10,'Phân thích bảo mật',NULL);

--
-- Table structure for table `jb_companies`
--

CREATE TABLE `jb_companies` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` mediumtext COLLATE utf8mb4_unicode_ci,
  `website` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `latitude` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `longitude` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_id` bigint unsigned DEFAULT '1',
  `state_id` bigint unsigned DEFAULT NULL,
  `city_id` bigint unsigned DEFAULT NULL,
  `postal_code` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year_founded` int unsigned DEFAULT NULL,
  `ceo` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number_of_offices` int unsigned DEFAULT NULL,
  `number_of_employees` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `annual_revenue` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cover_image` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `facebook` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `twitter` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `linkedin` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `instagram` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_featured` tinyint NOT NULL DEFAULT '0',
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `views` bigint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_companies`
--

INSERT INTO `jb_companies` VALUES (1,'LinkedIn',NULL,'Mollitia molestiae alias laboriosam vero enim ut iste. Voluptate velit odit et enim. Fugit voluptatem nobis veniam.','<p class=\"text-muted\"> Objectively pursue diverse catalysts for change for interoperable meta-services. Distinctively re-engineer\n                revolutionary meta-services and premium architectures. Intrinsically incubate intuitive opportunities and\n                real-time potentialities. Appropriately communicate one-to-one technology.</p>\n\n            <p class=\"text-muted\">Intrinsically incubate intuitive opportunities and real-time potentialities Appropriately communicate\n                one-to-one technology.</p>\n\n            <p class=\"text-muted\"> Exercitation photo booth stumptown tote bag Banksy, elit small batch freegan sed. Craft beer elit\n                seitan exercitation, photo booth et 8-bit kale chips proident chillwave deep v laborum. Aliquip veniam delectus, Marfa\n                eiusmod Pinterest in do umami readymade swag.</p>','https://www.linkedin.com/','companies/1.png','43.275687','-75.647276','4454 Pacocha Village\nEast Alfordville, NE 47966',1,1,1,NULL,'+14239594490',2020,'John Doe',5,'6','4M',NULL,NULL,NULL,NULL,NULL,1,'published',0,'2023-03-18 01:06:50','2023-03-18 01:06:50'),(2,'Adobe Illustrator',NULL,'Facere debitis amet suscipit quod. Quia animi consectetur ut tempore similique et quis. Aut eius magni neque assumenda quibusdam impedit reiciendis.','<p class=\"text-muted\"> Objectively pursue diverse catalysts for change for interoperable meta-services. Distinctively re-engineer\n                revolutionary meta-services and premium architectures. Intrinsically incubate intuitive opportunities and\n                real-time potentialities. Appropriately communicate one-to-one technology.</p>\n\n            <p class=\"text-muted\">Intrinsically incubate intuitive opportunities and real-time potentialities Appropriately communicate\n                one-to-one technology.</p>\n\n            <p class=\"text-muted\"> Exercitation photo booth stumptown tote bag Banksy, elit small batch freegan sed. Craft beer elit\n                seitan exercitation, photo booth et 8-bit kale chips proident chillwave deep v laborum. Aliquip veniam delectus, Marfa\n                eiusmod Pinterest in do umami readymade swag.</p>','https://www.adobe.com/','companies/2.png','43.768149','-76.535599','18466 Kshlerin View Suite 937\nMerleview, AR 60703-8179',1,1,1,NULL,'+18023004429',1990,'Jeff Werner',2,'7','5M',NULL,NULL,NULL,NULL,NULL,1,'published',0,'2023-03-18 01:06:50','2023-03-18 01:06:50'),(3,'Bing Search',NULL,'Quisquam eum consequatur quaerat sed eos explicabo sed laudantium. Placeat ad eligendi maxime non aut et ipsa accusamus. Exercitationem nesciunt quas itaque.','<p class=\"text-muted\"> Objectively pursue diverse catalysts for change for interoperable meta-services. Distinctively re-engineer\n                revolutionary meta-services and premium architectures. Intrinsically incubate intuitive opportunities and\n                real-time potentialities. Appropriately communicate one-to-one technology.</p>\n\n            <p class=\"text-muted\">Intrinsically incubate intuitive opportunities and real-time potentialities Appropriately communicate\n                one-to-one technology.</p>\n\n            <p class=\"text-muted\"> Exercitation photo booth stumptown tote bag Banksy, elit small batch freegan sed. Craft beer elit\n                seitan exercitation, photo booth et 8-bit kale chips proident chillwave deep v laborum. Aliquip veniam delectus, Marfa\n                eiusmod Pinterest in do umami readymade swag.</p>','https://www.bing.com/','companies/3.png','42.630841','-75.411847','6630 Hadley Inlet Suite 707\nEast Zelda, VA 61659',3,3,3,NULL,'+15852021006',1993,'Nakamura',3,'9','3M',NULL,NULL,NULL,NULL,NULL,1,'published',0,'2023-03-18 01:06:50','2023-03-18 01:06:50'),(4,'Dailymotion',NULL,'Quae suscipit voluptas et et eligendi corrupti veritatis. Recusandae consectetur est sit debitis harum. Possimus omnis voluptatum esse eos deserunt assumenda.','<p class=\"text-muted\"> Objectively pursue diverse catalysts for change for interoperable meta-services. Distinctively re-engineer\n                revolutionary meta-services and premium architectures. Intrinsically incubate intuitive opportunities and\n                real-time potentialities. Appropriately communicate one-to-one technology.</p>\n\n            <p class=\"text-muted\">Intrinsically incubate intuitive opportunities and real-time potentialities Appropriately communicate\n                one-to-one technology.</p>\n\n            <p class=\"text-muted\"> Exercitation photo booth stumptown tote bag Banksy, elit small batch freegan sed. Craft beer elit\n                seitan exercitation, photo booth et 8-bit kale chips proident chillwave deep v laborum. Aliquip veniam delectus, Marfa\n                eiusmod Pinterest in do umami readymade swag.</p>','https://www.dailymotion.com/','companies/4.png','43.970583','-75.081644','38754 Wilkinson Plains\nSouth Sasha, CO 93372',2,2,2,NULL,'+17318695099',1974,'John Doe',4,'3','4M',NULL,NULL,NULL,NULL,NULL,1,'published',0,'2023-03-18 01:06:50','2023-03-18 01:06:50'),(5,'Linkedin',NULL,'Ut ullam sunt repellat. Earum qui impedit officia eligendi sint sint quasi eum. Occaecati velit aut nulla debitis culpa consectetur.','<p class=\"text-muted\"> Objectively pursue diverse catalysts for change for interoperable meta-services. Distinctively re-engineer\n                revolutionary meta-services and premium architectures. Intrinsically incubate intuitive opportunities and\n                real-time potentialities. Appropriately communicate one-to-one technology.</p>\n\n            <p class=\"text-muted\">Intrinsically incubate intuitive opportunities and real-time potentialities Appropriately communicate\n                one-to-one technology.</p>\n\n            <p class=\"text-muted\"> Exercitation photo booth stumptown tote bag Banksy, elit small batch freegan sed. Craft beer elit\n                seitan exercitation, photo booth et 8-bit kale chips proident chillwave deep v laborum. Aliquip veniam delectus, Marfa\n                eiusmod Pinterest in do umami readymade swag.</p>','https://www.linkedin.com/','companies/5.png','43.999681','-75.95785','1601 Gregg Corner\nTommieview, NC 68286-1159',1,1,1,NULL,'+17265979002',1975,'John Doe',5,'7','5M',NULL,NULL,NULL,NULL,NULL,1,'published',0,'2023-03-18 01:06:50','2023-03-18 01:06:50'),(6,'Quora JSC',NULL,'Dolorem occaecati quam quia. Doloremque recusandae minus ex. Dolores officiis consequatur quibusdam placeat dolorem mollitia.','<p class=\"text-muted\"> Objectively pursue diverse catalysts for change for interoperable meta-services. Distinctively re-engineer\n                revolutionary meta-services and premium architectures. Intrinsically incubate intuitive opportunities and\n                real-time potentialities. Appropriately communicate one-to-one technology.</p>\n\n            <p class=\"text-muted\">Intrinsically incubate intuitive opportunities and real-time potentialities Appropriately communicate\n                one-to-one technology.</p>\n\n            <p class=\"text-muted\"> Exercitation photo booth stumptown tote bag Banksy, elit small batch freegan sed. Craft beer elit\n                seitan exercitation, photo booth et 8-bit kale chips proident chillwave deep v laborum. Aliquip veniam delectus, Marfa\n                eiusmod Pinterest in do umami readymade swag.</p>','https://www.quora.com/','companies/6.png','43.583541','-76.705847','2764 Friedrich Course Apt. 708\nNew Patricia, RI 91300-7369',1,1,1,NULL,'+15317891184',2002,'John Doe',9,'4','3M',NULL,NULL,NULL,NULL,NULL,1,'published',0,'2023-03-18 01:06:50','2023-03-18 01:06:50'),(7,'Nintendo',NULL,'Earum quibusdam totam qui et omnis error fugit. Quasi sit dolores dolores vel omnis facilis asperiores. Qui distinctio ex reiciendis dolores dolores.','<p class=\"text-muted\"> Objectively pursue diverse catalysts for change for interoperable meta-services. Distinctively re-engineer\n                revolutionary meta-services and premium architectures. Intrinsically incubate intuitive opportunities and\n                real-time potentialities. Appropriately communicate one-to-one technology.</p>\n\n            <p class=\"text-muted\">Intrinsically incubate intuitive opportunities and real-time potentialities Appropriately communicate\n                one-to-one technology.</p>\n\n            <p class=\"text-muted\"> Exercitation photo booth stumptown tote bag Banksy, elit small batch freegan sed. Craft beer elit\n                seitan exercitation, photo booth et 8-bit kale chips proident chillwave deep v laborum. Aliquip veniam delectus, Marfa\n                eiusmod Pinterest in do umami readymade swag.</p>','https://www.nintendo.com/','companies/7.png','43.762343','-75.450898','777 Kelvin River\nSouth Keanustad, NM 58312',6,6,6,NULL,'+17327394964',1975,'Steve Jobs',7,'4','7M',NULL,NULL,NULL,NULL,NULL,1,'published',0,'2023-03-18 01:06:50','2023-03-18 01:06:50'),(8,'Periscope',NULL,'Magni accusantium ullam officiis nulla ut. Numquam est voluptas assumenda consequuntur qui et. Ipsum quis et enim veniam atque ut. Maxime et numquam aperiam et iusto accusamus ut.','<p class=\"text-muted\"> Objectively pursue diverse catalysts for change for interoperable meta-services. Distinctively re-engineer\n                revolutionary meta-services and premium architectures. Intrinsically incubate intuitive opportunities and\n                real-time potentialities. Appropriately communicate one-to-one technology.</p>\n\n            <p class=\"text-muted\">Intrinsically incubate intuitive opportunities and real-time potentialities Appropriately communicate\n                one-to-one technology.</p>\n\n            <p class=\"text-muted\"> Exercitation photo booth stumptown tote bag Banksy, elit small batch freegan sed. Craft beer elit\n                seitan exercitation, photo booth et 8-bit kale chips proident chillwave deep v laborum. Aliquip veniam delectus, Marfa\n                eiusmod Pinterest in do umami readymade swag.</p>','https://www.pscp.tv/','companies/8.png','43.434523','-75.651866','768 Carroll Via\nWest Keaganton, MO 81295-4346',6,6,6,NULL,'+12193849745',1993,'John Doe',6,'8','3M',NULL,NULL,NULL,NULL,NULL,1,'published',0,'2023-03-18 01:06:50','2023-03-18 01:06:50'),(9,'NewSum',NULL,'Ut et repellat consequuntur rem nostrum inventore saepe. Delectus porro consequatur inventore exercitationem aut. Dolore illo consequatur totam et. In aliquid voluptatem animi porro tempore.','<p class=\"text-muted\"> Objectively pursue diverse catalysts for change for interoperable meta-services. Distinctively re-engineer\n                revolutionary meta-services and premium architectures. Intrinsically incubate intuitive opportunities and\n                real-time potentialities. Appropriately communicate one-to-one technology.</p>\n\n            <p class=\"text-muted\">Intrinsically incubate intuitive opportunities and real-time potentialities Appropriately communicate\n                one-to-one technology.</p>\n\n            <p class=\"text-muted\"> Exercitation photo booth stumptown tote bag Banksy, elit small batch freegan sed. Craft beer elit\n                seitan exercitation, photo booth et 8-bit kale chips proident chillwave deep v laborum. Aliquip veniam delectus, Marfa\n                eiusmod Pinterest in do umami readymade swag.</p>','https://newsum.us/','companies/4.png','43.775063','-75.158002','318 Reichert Haven\nJakubowskiview, CA 82140-4379',4,4,4,NULL,'+16065937326',1976,'John Doe',3,'8','4M',NULL,NULL,NULL,NULL,NULL,1,'published',0,'2023-03-18 01:06:50','2023-03-18 01:06:50'),(10,'PowerHome',NULL,'Vel provident maxime ab delectus fugiat odio et. Voluptas debitis nulla qui dolorem sed. Ducimus dolorem nemo non sit itaque non repellendus.','<p class=\"text-muted\"> Objectively pursue diverse catalysts for change for interoperable meta-services. Distinctively re-engineer\n                revolutionary meta-services and premium architectures. Intrinsically incubate intuitive opportunities and\n                real-time potentialities. Appropriately communicate one-to-one technology.</p>\n\n            <p class=\"text-muted\">Intrinsically incubate intuitive opportunities and real-time potentialities Appropriately communicate\n                one-to-one technology.</p>\n\n            <p class=\"text-muted\"> Exercitation photo booth stumptown tote bag Banksy, elit small batch freegan sed. Craft beer elit\n                seitan exercitation, photo booth et 8-bit kale chips proident chillwave deep v laborum. Aliquip veniam delectus, Marfa\n                eiusmod Pinterest in do umami readymade swag.</p>','https://www.pscp.tv/','companies/5.png','43.030051','-76.36395','20467 Royal Estates\nNew Kiarachester, AZ 34750-8394',1,1,1,NULL,'+12815697262',1995,'John Doe',5,'5','3M',NULL,NULL,NULL,NULL,NULL,1,'published',0,'2023-03-18 01:06:50','2023-03-18 01:06:50'),(11,'Whop.com',NULL,'Id aut necessitatibus dicta quia. Earum sit laboriosam aut ipsam aliquam eos laudantium. Ut corporis voluptatem non illo aliquam veniam nesciunt. Quo ut sit iusto ea.','<p class=\"text-muted\"> Objectively pursue diverse catalysts for change for interoperable meta-services. Distinctively re-engineer\n                revolutionary meta-services and premium architectures. Intrinsically incubate intuitive opportunities and\n                real-time potentialities. Appropriately communicate one-to-one technology.</p>\n\n            <p class=\"text-muted\">Intrinsically incubate intuitive opportunities and real-time potentialities Appropriately communicate\n                one-to-one technology.</p>\n\n            <p class=\"text-muted\"> Exercitation photo booth stumptown tote bag Banksy, elit small batch freegan sed. Craft beer elit\n                seitan exercitation, photo booth et 8-bit kale chips proident chillwave deep v laborum. Aliquip veniam delectus, Marfa\n                eiusmod Pinterest in do umami readymade swag.</p>','https://whop.com/','companies/6.png','43.409219','-76.727125','39754 Gudrun Burg\nMichaelhaven, MD 24435-9527',6,6,6,NULL,'+15203593386',2015,'John Doe',3,'10','5M',NULL,NULL,NULL,NULL,NULL,1,'published',0,'2023-03-18 01:06:50','2023-03-18 01:06:50'),(12,'Greenwood',NULL,'Ipsum in possimus velit maiores voluptatibus cumque quae. Voluptas sit aut eius eum est vel. Odio saepe molestiae aut illo.','<p class=\"text-muted\"> Objectively pursue diverse catalysts for change for interoperable meta-services. Distinctively re-engineer\n                revolutionary meta-services and premium architectures. Intrinsically incubate intuitive opportunities and\n                real-time potentialities. Appropriately communicate one-to-one technology.</p>\n\n            <p class=\"text-muted\">Intrinsically incubate intuitive opportunities and real-time potentialities Appropriately communicate\n                one-to-one technology.</p>\n\n            <p class=\"text-muted\"> Exercitation photo booth stumptown tote bag Banksy, elit small batch freegan sed. Craft beer elit\n                seitan exercitation, photo booth et 8-bit kale chips proident chillwave deep v laborum. Aliquip veniam delectus, Marfa\n                eiusmod Pinterest in do umami readymade swag.</p>','https://www.greenwoodjs.io/','companies/7.png','43.345086','-75.404832','5925 Demarcus Roads\nPort Jacynthetown, SC 40246',6,6,6,NULL,'+14247226064',2012,'John Doe',3,'1','1M',NULL,NULL,NULL,NULL,NULL,1,'published',0,'2023-03-18 01:06:50','2023-03-18 01:06:50'),(13,'Kentucky',NULL,'Optio a accusamus aut reiciendis rerum rerum sunt. Maiores et nostrum et illo. Tenetur vel dolorum quibusdam et et quos aut. Quis expedita tempore reprehenderit est.','<p class=\"text-muted\"> Objectively pursue diverse catalysts for change for interoperable meta-services. Distinctively re-engineer\n                revolutionary meta-services and premium architectures. Intrinsically incubate intuitive opportunities and\n                real-time potentialities. Appropriately communicate one-to-one technology.</p>\n\n            <p class=\"text-muted\">Intrinsically incubate intuitive opportunities and real-time potentialities Appropriately communicate\n                one-to-one technology.</p>\n\n            <p class=\"text-muted\"> Exercitation photo booth stumptown tote bag Banksy, elit small batch freegan sed. Craft beer elit\n                seitan exercitation, photo booth et 8-bit kale chips proident chillwave deep v laborum. Aliquip veniam delectus, Marfa\n                eiusmod Pinterest in do umami readymade swag.</p>','https://www.kentucky.gov/','companies/8.png','43.970539','-75.789989','53481 Weimann Courts\nLake Alanis, IN 45410-9787',1,1,1,NULL,'+16057912405',1990,'John Doe',3,'4','6M',NULL,NULL,NULL,NULL,NULL,1,'published',0,'2023-03-18 01:06:50','2023-03-18 01:06:50'),(14,'Equity',NULL,'Fugiat ipsum repudiandae ipsum et illum est magnam. Ut accusantium in et ut. Hic dolore accusantium aut ut. Tempora odio impedit aut exercitationem sint explicabo.','<p class=\"text-muted\"> Objectively pursue diverse catalysts for change for interoperable meta-services. Distinctively re-engineer\n                revolutionary meta-services and premium architectures. Intrinsically incubate intuitive opportunities and\n                real-time potentialities. Appropriately communicate one-to-one technology.</p>\n\n            <p class=\"text-muted\">Intrinsically incubate intuitive opportunities and real-time potentialities Appropriately communicate\n                one-to-one technology.</p>\n\n            <p class=\"text-muted\"> Exercitation photo booth stumptown tote bag Banksy, elit small batch freegan sed. Craft beer elit\n                seitan exercitation, photo booth et 8-bit kale chips proident chillwave deep v laborum. Aliquip veniam delectus, Marfa\n                eiusmod Pinterest in do umami readymade swag.</p>','https://www.equity.org.uk/','companies/6.png','42.694298','-74.784936','3888 Christiansen Via\nWisokymouth, IN 45790',3,3,3,NULL,'+19105664697',1992,'John Doe',3,'7','2M',NULL,NULL,NULL,NULL,NULL,1,'published',0,'2023-03-18 01:06:50','2023-03-18 01:06:50'),(15,'Honda',NULL,'Qui aut quas dolor quos asperiores quam commodi non. Sed rem sit deserunt. Quibusdam odit temporibus commodi dolor aut nobis nobis. Molestiae ut est quidem distinctio suscipit.','<p class=\"text-muted\"> Objectively pursue diverse catalysts for change for interoperable meta-services. Distinctively re-engineer\n                revolutionary meta-services and premium architectures. Intrinsically incubate intuitive opportunities and\n                real-time potentialities. Appropriately communicate one-to-one technology.</p>\n\n            <p class=\"text-muted\">Intrinsically incubate intuitive opportunities and real-time potentialities Appropriately communicate\n                one-to-one technology.</p>\n\n            <p class=\"text-muted\"> Exercitation photo booth stumptown tote bag Banksy, elit small batch freegan sed. Craft beer elit\n                seitan exercitation, photo booth et 8-bit kale chips proident chillwave deep v laborum. Aliquip veniam delectus, Marfa\n                eiusmod Pinterest in do umami readymade swag.</p>','https://www.honda.com/','companies/9.png','43.043666','-76.602992','55495 Trudie Fords Apt. 298\nPort Brandi, AZ 19997',3,3,3,NULL,'+12798421859',1974,'John Doe',2,'4','10M',NULL,NULL,NULL,NULL,NULL,1,'published',0,'2023-03-18 01:06:50','2023-03-18 01:06:50'),(16,'Toyota',NULL,'Quam laborum unde ipsum est dolor. Eaque autem cumque in ut. Totam amet pariatur sed culpa magnam a nobis.','<p class=\"text-muted\"> Objectively pursue diverse catalysts for change for interoperable meta-services. Distinctively re-engineer\n                revolutionary meta-services and premium architectures. Intrinsically incubate intuitive opportunities and\n                real-time potentialities. Appropriately communicate one-to-one technology.</p>\n\n            <p class=\"text-muted\">Intrinsically incubate intuitive opportunities and real-time potentialities Appropriately communicate\n                one-to-one technology.</p>\n\n            <p class=\"text-muted\"> Exercitation photo booth stumptown tote bag Banksy, elit small batch freegan sed. Craft beer elit\n                seitan exercitation, photo booth et 8-bit kale chips proident chillwave deep v laborum. Aliquip veniam delectus, Marfa\n                eiusmod Pinterest in do umami readymade swag.</p>','https://www.toyota.com/','companies/5.png','44.010469','-76.452166','759 King Isle Suite 676\nWuckertstad, WY 11490-9753',5,5,5,NULL,'+12817986429',2012,'John Doe',2,'6','9M',NULL,NULL,NULL,NULL,NULL,0,'published',0,'2023-03-18 01:06:50','2023-03-18 01:06:50'),(17,'Lexus',NULL,'Atque iste nemo laborum aut. Hic voluptatem id et maiores ea nisi. Aut facere aut quasi quia impedit. Nihil expedita fugiat qui earum qui.','<p class=\"text-muted\"> Objectively pursue diverse catalysts for change for interoperable meta-services. Distinctively re-engineer\n                revolutionary meta-services and premium architectures. Intrinsically incubate intuitive opportunities and\n                real-time potentialities. Appropriately communicate one-to-one technology.</p>\n\n            <p class=\"text-muted\">Intrinsically incubate intuitive opportunities and real-time potentialities Appropriately communicate\n                one-to-one technology.</p>\n\n            <p class=\"text-muted\"> Exercitation photo booth stumptown tote bag Banksy, elit small batch freegan sed. Craft beer elit\n                seitan exercitation, photo booth et 8-bit kale chips proident chillwave deep v laborum. Aliquip veniam delectus, Marfa\n                eiusmod Pinterest in do umami readymade swag.</p>','https://www.pscp.tv/','companies/3.png','43.611725','-74.878346','5433 Gilberto Spring Suite 903\nLake Otis, OR 44382-1202',2,2,2,NULL,'+13864126167',2021,'John Doe',8,'3','4M',NULL,NULL,NULL,NULL,NULL,0,'published',0,'2023-03-18 01:06:50','2023-03-18 01:06:50'),(18,'Ondo',NULL,'Qui in pariatur iusto provident nesciunt. Laudantium facilis veniam quam dolor asperiores. Aut totam voluptatem nostrum excepturi nostrum.','<p class=\"text-muted\"> Objectively pursue diverse catalysts for change for interoperable meta-services. Distinctively re-engineer\n                revolutionary meta-services and premium architectures. Intrinsically incubate intuitive opportunities and\n                real-time potentialities. Appropriately communicate one-to-one technology.</p>\n\n            <p class=\"text-muted\">Intrinsically incubate intuitive opportunities and real-time potentialities Appropriately communicate\n                one-to-one technology.</p>\n\n            <p class=\"text-muted\"> Exercitation photo booth stumptown tote bag Banksy, elit small batch freegan sed. Craft beer elit\n                seitan exercitation, photo booth et 8-bit kale chips proident chillwave deep v laborum. Aliquip veniam delectus, Marfa\n                eiusmod Pinterest in do umami readymade swag.</p>','https://ondo.mn/','companies/6.png','43.837091','-74.910296','7885 Sipes Cape Apt. 796\nPort Lenny, WI 81704',5,5,5,NULL,'+16404353644',2013,'John Doe',7,'10','9M',NULL,NULL,NULL,NULL,NULL,0,'published',0,'2023-03-18 01:06:50','2023-03-18 01:06:50'),(19,'Square',NULL,'Consequuntur quae tenetur sed. Sit et voluptate est. Nesciunt vel itaque mollitia ullam et commodi cupiditate.','<p class=\"text-muted\"> Objectively pursue diverse catalysts for change for interoperable meta-services. Distinctively re-engineer\n                revolutionary meta-services and premium architectures. Intrinsically incubate intuitive opportunities and\n                real-time potentialities. Appropriately communicate one-to-one technology.</p>\n\n            <p class=\"text-muted\">Intrinsically incubate intuitive opportunities and real-time potentialities Appropriately communicate\n                one-to-one technology.</p>\n\n            <p class=\"text-muted\"> Exercitation photo booth stumptown tote bag Banksy, elit small batch freegan sed. Craft beer elit\n                seitan exercitation, photo booth et 8-bit kale chips proident chillwave deep v laborum. Aliquip veniam delectus, Marfa\n                eiusmod Pinterest in do umami readymade swag.</p>','https://squareup.com/','companies/2.png','43.739249','-75.169543','38756 Anthony Mill Suite 117\nKaydenmouth, ME 54613-6664',4,4,4,NULL,'+14843258957',1987,'John Doe',6,'7','6M',NULL,NULL,NULL,NULL,NULL,0,'published',0,'2023-03-18 01:06:50','2023-03-18 01:06:50'),(20,'Vista',NULL,'Debitis pariatur laudantium vitae aspernatur enim atque. Reiciendis illum non ullam voluptatem et officiis. Voluptatem et ea et. In at laborum omnis aspernatur pariatur.','<p class=\"text-muted\"> Objectively pursue diverse catalysts for change for interoperable meta-services. Distinctively re-engineer\n                revolutionary meta-services and premium architectures. Intrinsically incubate intuitive opportunities and\n                real-time potentialities. Appropriately communicate one-to-one technology.</p>\n\n            <p class=\"text-muted\">Intrinsically incubate intuitive opportunities and real-time potentialities Appropriately communicate\n                one-to-one technology.</p>\n\n            <p class=\"text-muted\"> Exercitation photo booth stumptown tote bag Banksy, elit small batch freegan sed. Craft beer elit\n                seitan exercitation, photo booth et 8-bit kale chips proident chillwave deep v laborum. Aliquip veniam delectus, Marfa\n                eiusmod Pinterest in do umami readymade swag.</p>','https://vista.com/','companies/8.png','43.832571','-75.915858','83299 Ziemann Terrace\nPort Lauren, MT 40022-6424',4,4,4,NULL,'+17739984351',1987,'John Doe',5,'5','4M',NULL,NULL,NULL,NULL,NULL,0,'published',0,'2023-03-18 01:06:50','2023-03-18 01:06:50');

--
-- Table structure for table `jb_companies_accounts`
--

CREATE TABLE `jb_companies_accounts` (
  `company_id` bigint unsigned NOT NULL,
  `account_id` bigint unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_companies_accounts`
--

INSERT INTO `jb_companies_accounts` VALUES (1,1),(1,4),(2,1),(2,4),(3,1),(3,4),(4,1),(4,4),(5,1),(5,4),(6,1),(6,4),(7,1),(7,4),(8,1),(8,4),(9,1),(9,4),(10,1),(10,4),(11,1),(11,4),(12,1),(12,4),(13,1),(13,4),(14,1),(14,4),(15,1),(15,4),(16,1),(16,4),(17,1),(17,4),(18,1),(18,4),(19,1),(19,4),(20,1),(20,4);

--
-- Table structure for table `jb_currencies`
--

CREATE TABLE `jb_currencies` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `symbol` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_prefix_symbol` tinyint unsigned NOT NULL DEFAULT '0',
  `decimals` tinyint unsigned NOT NULL DEFAULT '0',
  `order` int unsigned NOT NULL DEFAULT '0',
  `is_default` tinyint NOT NULL DEFAULT '0',
  `exchange_rate` double NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_currencies`
--

INSERT INTO `jb_currencies` VALUES (1,'USD','$',1,0,0,1,1,'2023-03-18 01:06:51','2023-03-18 01:06:51'),(2,'EUR','€',0,0,1,0,0.84,'2023-03-18 01:06:51','2023-03-18 01:06:51'),(3,'VND','₫',0,0,1,0,23203,'2023-03-18 01:06:51','2023-03-18 01:06:51');

--
-- Table structure for table `jb_custom_field_options`
--

CREATE TABLE `jb_custom_field_options` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `custom_field_id` bigint unsigned NOT NULL,
  `label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` int NOT NULL DEFAULT '999',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_custom_field_options`
--


--
-- Table structure for table `jb_custom_field_options_translations`
--

CREATE TABLE `jb_custom_field_options_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jb_custom_field_options_id` bigint unsigned NOT NULL,
  `label` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`jb_custom_field_options_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_custom_field_options_translations`
--


--
-- Table structure for table `jb_custom_field_values`
--

CREATE TABLE `jb_custom_field_values` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reference_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reference_id` bigint unsigned NOT NULL,
  `custom_field_id` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `jb_custom_field_values_reference_type_reference_id_index` (`reference_type`,`reference_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_custom_field_values`
--


--
-- Table structure for table `jb_custom_field_values_translations`
--

CREATE TABLE `jb_custom_field_values_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jb_custom_field_values_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`jb_custom_field_values_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_custom_field_values_translations`
--


--
-- Table structure for table `jb_custom_fields`
--

CREATE TABLE `jb_custom_fields` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` int NOT NULL DEFAULT '999',
  `is_global` tinyint(1) NOT NULL DEFAULT '0',
  `authorable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `authorable_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `jb_custom_fields_authorable_type_authorable_id_index` (`authorable_type`,`authorable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_custom_fields`
--


--
-- Table structure for table `jb_custom_fields_translations`
--

CREATE TABLE `jb_custom_fields_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jb_custom_fields_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`jb_custom_fields_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_custom_fields_translations`
--


--
-- Table structure for table `jb_degree_levels`
--

CREATE TABLE `jb_degree_levels` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` tinyint NOT NULL DEFAULT '0',
  `is_default` tinyint unsigned NOT NULL DEFAULT '0',
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_degree_levels`
--

INSERT INTO `jb_degree_levels` VALUES (1,'Non-Matriculation',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(2,'Matriculation/O-Level',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(3,'Intermediate/A-Level',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(4,'Bachelors',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(5,'Masters',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(6,'MPhil/MS',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(7,'PHD/Doctorate',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(8,'Certification',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(9,'Diploma',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(10,'Short Course',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49');

--
-- Table structure for table `jb_degree_levels_translations`
--

CREATE TABLE `jb_degree_levels_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jb_degree_levels_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`jb_degree_levels_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_degree_levels_translations`
--


--
-- Table structure for table `jb_degree_types`
--

CREATE TABLE `jb_degree_types` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `degree_level_id` bigint unsigned NOT NULL,
  `order` tinyint NOT NULL DEFAULT '0',
  `is_default` tinyint unsigned NOT NULL DEFAULT '0',
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_degree_types`
--

INSERT INTO `jb_degree_types` VALUES (1,'Matric in Arts',2,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(2,'Matric in Science',2,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(3,'O-Levels',2,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(4,'A-Levels',3,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(5,'Faculty of Arts',3,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(6,'Faculty of Science (Pre-medical)',3,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(7,'Faculty of Science (Pre-Engineering)',3,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(8,'Intermediate in Computer Science',3,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(9,'Intermediate in Commerce',3,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(10,'Intermediate in General Science',3,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(11,'Bachelors in Arts',4,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(12,'Bachelors in Architecture',4,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(13,'Bachelors in Business Administration',4,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(14,'Bachelors in Commerce',4,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(15,'Bachelors of Dental Surgery',4,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(16,'Bachelors of Education',4,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(17,'Bachelors in Engineering',4,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(18,'Bachelors in Pharmacy',4,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(19,'Bachelors in Science',4,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(20,'Bachelors of Science in Nursing (Registered Nursing)',4,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(21,'Bachelors in Law',4,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(22,'Bachelors in Technology',4,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(23,'BCS/BS',4,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(24,'Doctor of Veterinary Medicine',4,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(25,'MBBS',4,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(26,'Post Registered Nursing B.S.',4,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(27,'Masters in Arts',5,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(28,'Masters in Business Administration',5,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(29,'Masters in Commerce',5,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(30,'Masters of Education',5,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(31,'Masters in Law',5,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(32,'Masters in Science',5,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(33,'Executive Masters in Business Administration',5,0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49');

--
-- Table structure for table `jb_degree_types_translations`
--

CREATE TABLE `jb_degree_types_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jb_degree_types_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`jb_degree_types_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_degree_types_translations`
--


--
-- Table structure for table `jb_functional_areas`
--

CREATE TABLE `jb_functional_areas` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` tinyint NOT NULL DEFAULT '0',
  `is_default` tinyint unsigned NOT NULL DEFAULT '0',
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=157 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_functional_areas`
--

INSERT INTO `jb_functional_areas` VALUES (1,'Accountant',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(2,'Accounts, Finance & Financial Services',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(3,'Admin',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(4,'Admin Operation',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(5,'Administration',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(6,'Administration Clerical',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(7,'Advertising',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(8,'Advertising',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(9,'Advertisement',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(10,'Architects & Construction',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(11,'Architecture',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(12,'Bank Operation',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(13,'Business Development',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(14,'Business Management',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(15,'Business Systems Analyst',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(16,'Clerical',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(17,'Client Services & Customer Support',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(18,'Computer Hardware',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(19,'Computer Networking',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(20,'Consultant',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(21,'Content Writer',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(22,'Corporate Affairs',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(23,'Creative Design',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(24,'Creative Writer',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(25,'Customer Support',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(26,'Data Entry',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(27,'Data Entry Operator',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(28,'Database Administration (DBA)',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(29,'Development',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(30,'Distribution & Logistics',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(31,'Education & Training',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(32,'Electronics Technician',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(33,'Engineering',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(34,'Engineering Construction',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(35,'Executive Management',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(36,'Executive Secretary',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(37,'Field Operations',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(38,'Front Desk Clerk',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(39,'Front Desk Officer',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(40,'Graphic Design',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(41,'Hardware',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(42,'Health & Medicine',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(43,'Health & Safety',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(44,'Health Care',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(45,'Health Related',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(46,'Hotel Management',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(47,'Hotel/Restaurant Management',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(48,'HR',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(49,'Human Resources',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(50,'Import & Export',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(51,'Industrial Production',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(52,'Installation & Repair',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(53,'Interior Designers & Architects',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(54,'Intern',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(55,'Internship',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(56,'Investment Operations',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(57,'IT Security',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(58,'IT Systems Analyst',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(59,'Legal & Corporate Affairs',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(60,'Legal Affairs',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(61,'Legal Research',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(62,'Logistics & Warehousing',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(63,'Maintenance/Repair',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(64,'Management Consulting',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(65,'Management Information System (MIS)',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(66,'Managerial',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(67,'Manufacturing',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(68,'Manufacturing & Operations',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(69,'Marketing',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(70,'Marketing',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(71,'Media - Print & Electronic',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(72,'Media & Advertising',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(73,'Medical',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(74,'Medicine',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(75,'Merchandising',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(76,'Merchandising & Product Management',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(77,'Monitoring & Evaluation (M&E)',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(78,'Network Administration',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(79,'Network Operation',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(80,'Online Advertising',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(81,'Online Marketing',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(82,'Operations',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(83,'Planning',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(84,'Planning & Development',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(85,'PR',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(86,'Print Media',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(87,'Printing',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(88,'Procurement',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(89,'Product Developer',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(90,'Product Development',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(91,'Product Development',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(92,'Product Management',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(93,'Production',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(94,'Production & Quality Control',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(95,'Project Management',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(96,'Project Management Consultant',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(97,'Public Relations',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(98,'QA',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(99,'QC',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(100,'Qualitative Research',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(101,'Quality Assurance (QA)',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(102,'Quality Control',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(103,'Quality Inspection',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(104,'Recruiting',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(105,'Recruitment',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(106,'Repair & Overhaul',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(107,'Research & Development (R&D)',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(108,'Research & Evaluation',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(109,'Research & Fellowships',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(110,'Researcher',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(111,'Restaurant Management',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(112,'Retail',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(113,'Retail & Wholesale',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(114,'Retail Buyer',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(115,'Retail Buying',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(116,'Retail Merchandising',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(117,'Safety & Environment',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(118,'Sales',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(119,'Sales & Business Development',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(120,'Sales Support',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(121,'Search Engine Optimization (SEO)',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(122,'Secretarial, Clerical & Front Office',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(123,'Security',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(124,'Security & Environment',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(125,'Security Guard',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(126,'SEM',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(127,'SMO',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(128,'Software & Web Development',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(129,'Software Engineer',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(130,'Software Testing',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(131,'Stores & Warehousing',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(132,'Supply Chain',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(133,'Supply Chain Management',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(134,'Systems Analyst',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(135,'Teachers/Education, Training & Development',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(136,'Technical Writer',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(137,'Tele Sale Representative',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(138,'Telemarketing',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(139,'Training & Development',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(140,'Transportation & Warehousing',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(141,'TSR',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(142,'Typing',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(143,'Warehousing',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(144,'Web Developer',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(145,'Web Marketing',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(146,'Writer',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(147,'PR',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(148,'QA',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(149,'QC',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(150,'SEM',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(151,'SMO',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(152,'TSR',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(153,'HR',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(154,'QA',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(155,'QC',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49'),(156,'SEM',0,0,'published','2023-03-18 01:06:49','2023-03-18 01:06:49');

--
-- Table structure for table `jb_functional_areas_translations`
--

CREATE TABLE `jb_functional_areas_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jb_functional_areas_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`jb_functional_areas_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_functional_areas_translations`
--


--
-- Table structure for table `jb_invoice_items`
--

CREATE TABLE `jb_invoice_items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `invoice_id` bigint unsigned NOT NULL,
  `reference_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reference_id` bigint unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `qty` int unsigned NOT NULL,
  `sub_total` decimal(15,2) unsigned NOT NULL,
  `tax_amount` decimal(15,2) unsigned NOT NULL DEFAULT '0.00',
  `discount_amount` decimal(15,2) unsigned NOT NULL DEFAULT '0.00',
  `amount` decimal(15,2) unsigned NOT NULL,
  `metadata` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `jb_invoice_items_reference_type_reference_id_index` (`reference_type`,`reference_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_invoice_items`
--


--
-- Table structure for table `jb_invoices`
--

CREATE TABLE `jb_invoices` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `reference_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reference_id` bigint unsigned NOT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `company_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_logo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_tax_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sub_total` decimal(15,2) unsigned NOT NULL,
  `tax_amount` decimal(15,2) unsigned NOT NULL DEFAULT '0.00',
  `shipping_amount` decimal(15,2) unsigned NOT NULL DEFAULT '0.00',
  `discount_amount` decimal(15,2) unsigned NOT NULL DEFAULT '0.00',
  `amount` decimal(15,2) unsigned NOT NULL,
  `payment_id` int unsigned DEFAULT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `paid_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `jb_invoices_code_unique` (`code`),
  KEY `jb_invoices_reference_type_reference_id_index` (`reference_type`,`reference_id`),
  KEY `jb_invoices_payment_id_index` (`payment_id`),
  KEY `jb_invoices_status_index` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_invoices`
--


--
-- Table structure for table `jb_job_experiences`
--

CREATE TABLE `jb_job_experiences` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` tinyint NOT NULL DEFAULT '0',
  `is_default` tinyint unsigned NOT NULL DEFAULT '0',
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_job_experiences`
--

INSERT INTO `jb_job_experiences` VALUES (1,'Fresh',0,0,'published','2023-03-18 01:06:50','2023-03-18 01:06:50'),(2,'Less Than 1 Year',0,0,'published','2023-03-18 01:06:50','2023-03-18 01:06:50'),(3,'1 Year',0,0,'published','2023-03-18 01:06:50','2023-03-18 01:06:50'),(4,'2 Year',0,0,'published','2023-03-18 01:06:50','2023-03-18 01:06:50'),(5,'3 Year',0,0,'published','2023-03-18 01:06:50','2023-03-18 01:06:50'),(6,'4 Year',0,0,'published','2023-03-18 01:06:50','2023-03-18 01:06:50'),(7,'5 Year',0,0,'published','2023-03-18 01:06:50','2023-03-18 01:06:50'),(8,'6 Year',0,0,'published','2023-03-18 01:06:50','2023-03-18 01:06:50'),(9,'7 Year',0,0,'published','2023-03-18 01:06:50','2023-03-18 01:06:50'),(10,'8 Year',0,0,'published','2023-03-18 01:06:50','2023-03-18 01:06:50'),(11,'9 Year',0,0,'published','2023-03-18 01:06:50','2023-03-18 01:06:50'),(12,'10 Year',0,0,'published','2023-03-18 01:06:50','2023-03-18 01:06:50');

--
-- Table structure for table `jb_job_experiences_translations`
--

CREATE TABLE `jb_job_experiences_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jb_job_experiences_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`jb_job_experiences_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_job_experiences_translations`
--

INSERT INTO `jb_job_experiences_translations` VALUES ('vi',1,'Mới'),('vi',2,'Dưới 1 năm'),('vi',3,'1 Năm'),('vi',4,'2 Năm'),('vi',5,'3 Năm'),('vi',6,'4 Năm'),('vi',7,'5 Năm'),('vi',8,'6 Năm'),('vi',9,'7 Năm'),('vi',10,'8 Năm'),('vi',11,'9 Năm'),('vi',12,'10 Năm');

--
-- Table structure for table `jb_job_shifts`
--

CREATE TABLE `jb_job_shifts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` tinyint NOT NULL DEFAULT '0',
  `is_default` tinyint unsigned NOT NULL DEFAULT '0',
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_job_shifts`
--

INSERT INTO `jb_job_shifts` VALUES (1,'First Shift (Day)',0,0,'published','2023-03-18 01:06:50','2023-03-18 01:06:50'),(2,'Second Shift (Afternoon)',0,0,'published','2023-03-18 01:06:50','2023-03-18 01:06:50'),(3,'Third Shift (Night)',0,0,'published','2023-03-18 01:06:50','2023-03-18 01:06:50'),(4,'Rotating',0,0,'published','2023-03-18 01:06:50','2023-03-18 01:06:50');

--
-- Table structure for table `jb_job_shifts_translations`
--

CREATE TABLE `jb_job_shifts_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jb_job_shifts_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`jb_job_shifts_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_job_shifts_translations`
--


--
-- Table structure for table `jb_job_skills`
--

CREATE TABLE `jb_job_skills` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` tinyint NOT NULL DEFAULT '0',
  `is_default` tinyint unsigned NOT NULL DEFAULT '0',
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_job_skills`
--

INSERT INTO `jb_job_skills` VALUES (1,'Javascript',0,0,'published','2023-03-18 01:06:50','2023-03-18 01:06:50'),(2,'PHP',0,0,'published','2023-03-18 01:06:50','2023-03-18 01:06:50'),(3,'Python',0,0,'published','2023-03-18 01:06:50','2023-03-18 01:06:50'),(4,'Laravel',0,0,'published','2023-03-18 01:06:50','2023-03-18 01:06:50'),(5,'CakePHP',0,0,'published','2023-03-18 01:06:50','2023-03-18 01:06:50'),(6,'Wordpress',0,0,'published','2023-03-18 01:06:50','2023-03-18 01:06:50');

--
-- Table structure for table `jb_job_skills_translations`
--

CREATE TABLE `jb_job_skills_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jb_job_skills_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`jb_job_skills_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_job_skills_translations`
--


--
-- Table structure for table `jb_job_types`
--

CREATE TABLE `jb_job_types` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` tinyint NOT NULL DEFAULT '0',
  `is_default` tinyint unsigned NOT NULL DEFAULT '0',
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_job_types`
--

INSERT INTO `jb_job_types` VALUES (1,'Contract',0,0,'published','2023-03-18 01:06:50','2023-03-18 01:06:50'),(2,'Freelance',0,0,'published','2023-03-18 01:06:50','2023-03-18 01:06:50'),(3,'Full Time',0,1,'published','2023-03-18 01:06:50','2023-03-18 01:06:50'),(4,'Internship',0,0,'published','2023-03-18 01:06:50','2023-03-18 01:06:50'),(5,'Part Time',0,0,'published','2023-03-18 01:06:50','2023-03-18 01:06:50');

--
-- Table structure for table `jb_job_types_translations`
--

CREATE TABLE `jb_job_types_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jb_job_types_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`jb_job_types_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_job_types_translations`
--


--
-- Table structure for table `jb_jobs`
--

CREATE TABLE `jb_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `content` text COLLATE utf8mb4_unicode_ci,
  `apply_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_id` bigint unsigned DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_id` bigint unsigned DEFAULT '1',
  `state_id` bigint unsigned DEFAULT NULL,
  `city_id` bigint unsigned DEFAULT NULL,
  `is_freelance` tinyint unsigned NOT NULL DEFAULT '0',
  `career_level_id` bigint unsigned DEFAULT NULL,
  `salary_from` decimal(15,2) unsigned DEFAULT NULL,
  `salary_to` decimal(15,2) unsigned DEFAULT NULL,
  `salary_range` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'hour',
  `currency_id` bigint unsigned DEFAULT NULL,
  `degree_level_id` bigint unsigned DEFAULT NULL,
  `job_shift_id` bigint unsigned DEFAULT NULL,
  `job_experience_id` bigint unsigned DEFAULT NULL,
  `functional_area_id` bigint unsigned DEFAULT NULL,
  `hide_salary` tinyint(1) NOT NULL DEFAULT '0',
  `number_of_positions` int unsigned NOT NULL DEFAULT '1',
  `expire_date` date DEFAULT NULL,
  `author_id` bigint unsigned DEFAULT NULL,
  `author_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Botble\\ACL\\Models\\User',
  `views` int unsigned NOT NULL DEFAULT '0',
  `number_of_applied` int unsigned NOT NULL DEFAULT '0',
  `hide_company` tinyint(1) NOT NULL DEFAULT '0',
  `latitude` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `longitude` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `auto_renew` tinyint(1) NOT NULL DEFAULT '0',
  `external_apply_clicks` int unsigned NOT NULL DEFAULT '0',
  `never_expired` tinyint(1) NOT NULL DEFAULT '0',
  `is_featured` tinyint NOT NULL DEFAULT '0',
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `moderation_status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `employer_colleagues` text COLLATE utf8mb4_unicode_ci,
  `start_date` date DEFAULT NULL,
  `application_closing_date` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jb_jobs`
--

INSERT INTO `jb_jobs` VALUES (1,'UI / UX Designer fulltime','Porro praesentium dolor magnam dignissimos soluta consequatur. Rem alias saepe error neque aliquid et id. Nihil impedit modi asperiores illum. Aut culpa laudantium reiciendis qui nam optio ut.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,1,NULL,1,1,1,0,4,1300.00,2900.00,'hourly',1,1,3,5,58,0,5,'2023-04-04',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.275687','-75.647276',0,0,0,1,'published','approved','2023-01-23 21:32:15','2023-03-18 01:06:50',NULL,NULL,NULL),(2,'Full Stack Engineer','Aut officiis perspiciatis perferendis. Accusantium omnis quo sapiente ut nostrum ut placeat. Quibusdam in non et quia. Facilis voluptatum consequatur illum optio minus et est.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>','https://google.com',8,NULL,6,6,6,0,4,900.00,2000.00,'yearly',1,10,4,2,5,0,7,'2023-03-28',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.434523','-75.651866',0,0,0,0,'published','approved','2023-02-19 01:30:17','2023-03-18 01:06:50',NULL,NULL,NULL),(3,'Java Software Engineer','Esse reprehenderit veniam aperiam et. Est commodi perferendis laboriosam harum earum. Cupiditate saepe ea aliquam est.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,16,NULL,5,5,5,0,2,700.00,2000.00,'monthly',1,10,1,2,77,0,4,'2023-05-17',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'44.010469','-76.452166',0,0,1,1,'published','approved','2023-03-01 01:43:49','2023-03-18 01:06:50',NULL,NULL,NULL),(4,'Digital Marketing Manager','Voluptas eligendi ut nobis quibusdam aliquid. Perferendis quo quia minima. Enim aut quam quidem error. Ut hic dolores et expedita magnam. Praesentium vel fugit in ullam.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,4,NULL,2,2,2,0,2,500.00,3000.00,'monthly',0,9,1,1,40,0,7,'2023-05-06',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.970583','-75.081644',0,0,0,1,'published','approved','2023-01-29 15:12:38','2023-03-18 01:06:50',NULL,NULL,NULL),(5,'Frontend Developer','Quo blanditiis esse voluptatum sed necessitatibus commodi officiis laborum. Exercitationem itaque saepe non ullam commodi. Consectetur iste quasi rem. Ut suscipit optio maxime porro illum.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,1,NULL,1,1,1,0,4,1400.00,2300.00,'hourly',1,5,1,2,114,0,8,'2023-04-21',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.275687','-75.647276',0,0,0,1,'published','approved','2023-01-31 14:54:31','2023-03-18 01:06:50',NULL,NULL,NULL),(6,'React Native Web Developer','Tenetur velit debitis quam cum praesentium. Nobis adipisci alias fugiat natus molestiae ut ab. Doloribus sit quis animi repellat.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,4,NULL,2,2,2,0,5,900.00,2800.00,'hourly',1,10,4,5,8,0,10,'2023-04-07',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.970583','-75.081644',0,0,0,1,'published','approved','2023-03-07 18:16:40','2023-03-18 01:06:50',NULL,NULL,NULL),(7,'Senior System Engineer','Eligendi vero et illo rem non. Tempore nemo id et odit sit itaque velit. Velit minima dolore recusandae placeat placeat veritatis sint tempora.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,6,NULL,1,1,1,0,4,1500.00,2000.00,'monthly',1,3,4,4,19,0,6,'2023-04-12',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.583541','-76.705847',0,0,0,0,'published','approved','2023-01-19 14:56:50','2023-03-18 01:06:50',NULL,NULL,NULL),(8,'Products Manager','Quis excepturi suscipit accusantium vel cupiditate omnis rem veniam. Voluptatem expedita officia necessitatibus quis.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,13,NULL,1,1,1,0,1,800.00,2300.00,'weekly',1,1,2,5,74,0,6,'2023-04-09',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.970539','-75.789989',0,0,1,1,'published','approved','2023-01-23 02:59:00','2023-03-18 01:06:50',NULL,NULL,NULL),(9,'Lead Quality Control QA','Voluptas sint neque et. Magnam culpa expedita unde totam ducimus saepe corporis. Inventore aliquid dignissimos sit quis amet quibusdam ea et.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,11,NULL,6,6,6,0,5,1100.00,2800.00,'monthly',0,3,4,4,122,0,7,'2023-03-24',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.409219','-76.727125',0,0,1,0,'published','approved','2023-01-27 03:45:24','2023-03-18 01:06:50',NULL,NULL,NULL),(10,'Principal Designer, Design Systems','Qui quas aut suscipit voluptas dolore. Qui voluptatem voluptas laudantium officiis sed vel in. Consequuntur quis voluptatem ipsum natus quasi.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,17,NULL,2,2,2,0,3,500.00,2800.00,'yearly',0,2,1,2,24,0,8,'2023-05-08',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.611725','-74.878346',0,0,1,0,'published','approved','2023-02-16 04:53:03','2023-03-18 01:06:50',NULL,NULL,NULL),(11,'DevOps Architect','Quo adipisci beatae quo ipsa iure ducimus quo autem. Et exercitationem saepe ut maxime molestias. Ex ut et blanditiis rerum ut. Iure atque doloremque maiores illum corrupti.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,1,NULL,1,1,1,0,2,1100.00,2900.00,'monthly',0,5,2,3,140,0,3,'2023-04-23',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.275687','-75.647276',0,0,1,1,'published','approved','2023-02-08 07:44:36','2023-03-18 01:06:50',NULL,NULL,NULL),(12,'Senior Software Engineer, npm CLI','Nesciunt dolore velit minima tempore quibusdam possimus in. Velit adipisci voluptatem enim recusandae.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,2,NULL,1,1,1,0,1,1100.00,3000.00,'yearly',0,5,3,1,27,0,7,'2023-05-02',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.768149','-76.535599',0,0,1,0,'published','approved','2023-01-23 05:52:22','2023-03-18 01:06:50',NULL,NULL,NULL),(13,'Senior Systems Engineer','Est eveniet cupiditate voluptatem ut impedit sunt libero eveniet. Sint est et earum itaque voluptas earum eaque. Distinctio ad esse harum.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,10,NULL,1,1,1,0,2,1500.00,2800.00,'weekly',1,7,1,2,62,0,2,'2023-04-21',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.030051','-76.36395',0,0,1,1,'published','approved','2023-03-15 18:52:31','2023-03-18 01:06:50',NULL,NULL,NULL),(14,'Software Engineer Actions Platform','Dolorem autem facere voluptatibus sed qui. Est modi laudantium facere et. Vitae veritatis culpa molestiae qui aut.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,19,NULL,4,4,4,0,3,1200.00,2700.00,'monthly',1,4,3,2,148,0,4,'2023-05-15',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.739249','-75.169543',0,0,0,0,'published','approved','2023-02-28 06:26:38','2023-03-18 01:06:50',NULL,NULL,NULL),(15,'Staff Engineering Manager, Actions','Aut officia sit maiores impedit deleniti. Ipsa et ut eligendi accusantium numquam fugiat reprehenderit. Inventore eius quasi consequuntur. Veniam autem fuga repellendus temporibus sint eum et.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,12,NULL,6,6,6,0,5,600.00,2400.00,'hourly',1,1,1,3,99,0,2,'2023-04-27',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.345086','-75.404832',0,0,1,0,'published','approved','2023-03-05 23:53:21','2023-03-18 01:06:50',NULL,NULL,NULL),(16,'Staff Engineering Manager: Actions Runtime','Minima laudantium corporis rerum modi deleniti. Aspernatur vel molestiae cumque.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,3,NULL,3,3,3,0,3,500.00,2100.00,'weekly',0,3,1,4,25,0,9,'2023-04-18',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'42.630841','-75.411847',0,0,1,0,'published','approved','2023-02-15 23:30:39','2023-03-18 01:06:50',NULL,NULL,NULL),(17,'Staff Engineering Manager, Packages','Quo necessitatibus et eius magnam dolorem nostrum. Ea commodi quia cumque consequatur recusandae. Voluptas est magnam dolores corrupti repellat est. Quisquam libero alias qui consectetur.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,20,NULL,4,4,4,0,4,700.00,2700.00,'yearly',1,10,2,2,86,0,2,'2023-05-16',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.832571','-75.915858',0,0,0,1,'published','approved','2023-02-21 17:05:51','2023-03-18 01:06:50',NULL,NULL,NULL),(18,'Staff Software Engineer','Porro qui et cupiditate sapiente eaque. Non reprehenderit explicabo fugit iure. Distinctio ut quasi nostrum autem sapiente soluta. Et modi eligendi porro quidem rerum.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,9,NULL,4,4,4,0,2,1500.00,2600.00,'weekly',1,4,3,5,74,0,10,'2023-04-11',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.775063','-75.158002',0,0,0,1,'published','approved','2023-01-18 13:28:25','2023-03-18 01:06:50',NULL,NULL,NULL),(19,'Systems Software Engineer','Dolor eum sed distinctio dolore culpa. Sunt nihil perspiciatis aut id. Commodi hic aut commodi dolorem sapiente.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,10,NULL,1,1,1,0,1,500.00,2700.00,'hourly',0,6,3,3,142,0,10,'2023-05-14',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.030051','-76.36395',0,0,1,0,'published','approved','2023-02-13 04:50:03','2023-03-18 01:06:50',NULL,NULL,NULL),(20,'Senior Compensation Analyst','Ratione harum saepe odio. Neque sunt consequatur rerum adipisci quia. Itaque deleniti veritatis molestiae praesentium. Consequatur omnis illum est aliquid illum corrupti qui.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,9,NULL,4,4,4,0,3,700.00,2700.00,'yearly',1,1,3,5,73,0,10,'2023-04-28',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.775063','-75.158002',0,0,0,1,'published','approved','2023-03-08 08:18:00','2023-03-18 01:06:50',NULL,NULL,NULL),(21,'Senior Accessibility Program Manager','Doloribus voluptatum labore corrupti magni animi vel. Repellat dolores odio omnis eos praesentium. Dolore assumenda eos odio id.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,11,NULL,6,6,6,0,3,500.00,2000.00,'hourly',0,6,2,2,22,0,2,'2023-03-24',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.409219','-76.727125',0,0,0,1,'published','approved','2023-02-16 21:04:40','2023-03-18 01:06:50',NULL,NULL,NULL),(22,'Analyst Relations Manager, Application Security','Laudantium enim molestiae asperiores consequuntur. Explicabo consequatur ipsum quis est. Et aut facere quae ut dolores reprehenderit.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,9,NULL,4,4,4,0,1,900.00,2900.00,'yearly',0,10,4,4,110,0,3,'2023-04-12',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.775063','-75.158002',0,0,1,1,'published','approved','2023-02-28 15:35:38','2023-03-18 01:06:50',NULL,NULL,NULL),(23,'Senior Enterprise Advocate, EMEA','Totam veritatis aperiam alias quia blanditiis. Dolore voluptatum facere accusamus unde est saepe quia. Iusto voluptate consequatur reiciendis qui quam culpa sit.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,1,NULL,1,1,1,0,4,1100.00,2800.00,'hourly',1,10,3,5,145,0,2,'2023-03-25',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.275687','-75.647276',0,0,0,0,'published','approved','2023-02-14 04:01:02','2023-03-18 01:06:50',NULL,NULL,NULL),(24,'Deal Desk Manager','Saepe aperiam similique incidunt ut. Et ut voluptas et ducimus. Accusantium vero voluptatum accusamus distinctio veritatis. Optio omnis id nihil aliquam voluptas. Cupiditate non provident cum rerum.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,6,NULL,1,1,1,0,2,700.00,2200.00,'weekly',0,8,4,2,19,0,3,'2023-04-29',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.583541','-76.705847',0,0,1,1,'published','approved','2023-02-02 09:04:35','2023-03-18 01:06:50',NULL,NULL,NULL),(25,'Director, Revenue Compensation','Officiis quibusdam molestiae illo ipsa quisquam sint dolores sed. Qui est explicabo nemo. Soluta facilis enim pariatur repudiandae similique aspernatur.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,1,NULL,1,1,1,0,1,1500.00,2000.00,'monthly',0,1,4,5,89,0,9,'2023-04-07',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.275687','-75.647276',0,0,1,0,'published','approved','2023-03-17 00:09:09','2023-03-18 01:06:50',NULL,NULL,NULL),(26,'Program Manager','Sequi quasi in et veniam. Numquam autem et eum veritatis. Quibusdam veritatis animi voluptatem et a.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,18,NULL,5,5,5,0,3,700.00,2900.00,'weekly',1,7,1,2,101,0,6,'2023-04-07',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.837091','-74.910296',0,0,0,1,'published','approved','2023-01-18 20:09:08','2023-03-18 01:06:50',NULL,NULL,NULL),(27,'Sr. Manager, Deal Desk - INTL','Quia qui consectetur quisquam soluta. Alias reprehenderit corrupti delectus id quaerat. Tempora officia non et ullam. Non voluptatibus nesciunt vel.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,16,NULL,5,5,5,0,3,1200.00,2400.00,'monthly',0,5,2,2,81,0,3,'2023-04-10',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'44.010469','-76.452166',0,0,1,0,'published','approved','2023-02-10 00:42:53','2023-03-18 01:06:50',NULL,NULL,NULL),(28,'Senior Director, Product Management, Actions Runners and Compute Services','Sunt laboriosam dolorum sint ipsum iste maiores. Error neque vel dicta ex dolor. Aut voluptas ea consectetur dolor voluptatibus et iste.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,3,NULL,3,3,3,0,4,1200.00,2600.00,'weekly',0,4,4,5,45,0,5,'2023-04-08',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'42.630841','-75.411847',0,0,0,0,'published','approved','2023-03-01 10:18:27','2023-03-18 01:06:50',NULL,NULL,NULL),(29,'Alliances Director','Eveniet eius et molestias non vitae amet. Consequatur tenetur aliquam distinctio sit et. Nam expedita ut animi voluptas quis. Sed modi maxime quia voluptate autem voluptatem aut.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,3,NULL,3,3,3,0,4,700.00,2500.00,'weekly',0,6,3,1,21,0,4,'2023-05-09',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'42.630841','-75.411847',0,0,1,0,'published','approved','2023-01-27 09:11:01','2023-03-18 01:06:50',NULL,NULL,NULL),(30,'Corporate Sales Representative','Repudiandae ducimus quos ipsum possimus. Possimus ab sequi aperiam earum non dicta. Molestiae cumque qui quasi.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,14,NULL,3,3,3,0,5,1500.00,2900.00,'weekly',1,3,3,2,128,0,8,'2023-05-13',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'42.694298','-74.784936',0,0,1,1,'published','approved','2023-02-15 10:32:38','2023-03-18 01:06:50',NULL,NULL,NULL),(31,'Country Leader','Sequi voluptas veritatis placeat reprehenderit et quae. Et facilis temporibus aut laboriosam reprehenderit. Voluptatem doloribus fuga ut voluptate.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,20,NULL,4,4,4,0,3,600.00,2500.00,'monthly',1,3,1,1,80,0,5,'2023-04-23',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.832571','-75.915858',0,0,1,1,'published','approved','2023-03-12 05:41:52','2023-03-18 01:06:50',NULL,NULL,NULL),(32,'Customer Success Architect','Vel assumenda in in aspernatur. Perspiciatis pariatur et aut minus. Dolores animi laboriosam amet iusto eaque reprehenderit qui. Est et rem voluptas non nemo molestias.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,9,NULL,4,4,4,0,4,900.00,2100.00,'hourly',0,3,2,5,34,0,4,'2023-03-24',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.775063','-75.158002',0,0,0,1,'published','approved','2023-02-08 20:29:09','2023-03-18 01:06:50',NULL,NULL,NULL),(33,'DevOps Account Executive - US Public Sector','Voluptas quis saepe dignissimos. Corrupti dolorem aut inventore rerum. Quaerat sunt debitis odio beatae ea. Deleniti repellendus provident odit velit saepe officia exercitationem.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,16,NULL,5,5,5,0,5,600.00,3000.00,'hourly',0,10,3,5,64,0,9,'2023-04-09',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'44.010469','-76.452166',0,0,1,0,'published','approved','2023-02-24 12:49:15','2023-03-18 01:06:51',NULL,NULL,NULL),(34,'Enterprise Account Executive','Corporis fugiat at exercitationem. Sit est id architecto dignissimos nam et qui. Quas explicabo est quae ut culpa.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,3,NULL,3,3,3,0,2,1100.00,3000.00,'hourly',0,2,2,1,51,0,10,'2023-05-12',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'42.630841','-75.411847',0,0,0,1,'published','approved','2023-02-16 10:05:39','2023-03-18 01:06:51',NULL,NULL,NULL),(35,'Senior Engineering Manager, Product Security Engineering - Paved Paths','Provident dolorem quasi id quaerat ad. Non natus esse ex voluptas enim. Dolores dignissimos quis sunt quae maxime vel.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,8,NULL,6,6,6,0,2,1400.00,2700.00,'yearly',1,2,1,2,52,0,5,'2023-03-26',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.434523','-75.651866',0,0,1,0,'published','approved','2023-02-19 17:18:43','2023-03-18 01:06:51',NULL,NULL,NULL),(36,'Customer Reliability Engineer III','Consequatur voluptatem fuga molestiae ratione id in. Necessitatibus iste ratione eaque et saepe ullam. Impedit ad quos quam quaerat alias et tenetur.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,13,NULL,1,1,1,0,4,700.00,2200.00,'weekly',0,10,1,1,14,0,7,'2023-04-02',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.970539','-75.789989',0,0,0,1,'published','approved','2023-02-26 18:19:01','2023-03-18 01:06:51',NULL,NULL,NULL),(37,'Support Engineer (Enterprise Support Japanese)','Repudiandae qui qui magnam reprehenderit consequuntur similique modi. Voluptas placeat animi aut libero rerum. Quidem et similique labore illo non quia adipisci.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,18,NULL,5,5,5,0,1,1100.00,2800.00,'monthly',0,6,3,2,108,0,4,'2023-04-05',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.837091','-74.910296',0,0,0,0,'published','approved','2023-02-07 16:58:43','2023-03-18 01:06:51',NULL,NULL,NULL),(38,'Technical Partner Manager','Tempora iusto similique consequatur incidunt sequi. Dolore et neque totam at dolor voluptate laboriosam. Atque saepe illo facilis provident alias. Asperiores est amet illo earum deleniti magni.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,8,NULL,6,6,6,0,2,500.00,2100.00,'yearly',1,2,1,5,35,0,9,'2023-05-02',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.434523','-75.651866',0,0,1,0,'published','approved','2023-02-22 18:43:45','2023-03-18 01:06:51',NULL,NULL,NULL),(39,'Sr Manager, Inside Account Management','Quia minima alias hic aut. In quaerat dolorem sed dicta nemo aut qui. Aut magnam id commodi omnis et error nostrum.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,2,NULL,1,1,1,0,1,500.00,2600.00,'yearly',1,6,1,1,154,0,4,'2023-03-30',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.768149','-76.535599',0,0,1,1,'published','approved','2023-02-27 06:08:51','2023-03-18 01:06:51',NULL,NULL,NULL),(40,'Services Sales Representative','Voluptatem consequuntur laudantium id officia enim nisi. Est optio sit eos maiores corporis cumque numquam aperiam. Sed labore expedita ea deleniti.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,10,NULL,1,1,1,0,1,1300.00,2900.00,'monthly',0,4,3,5,37,0,5,'2023-05-08',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.030051','-76.36395',0,0,0,0,'published','approved','2023-02-02 23:24:28','2023-03-18 01:06:51',NULL,NULL,NULL),(41,'Services Delivery Manager','Aut velit non illum explicabo. Et velit ut aspernatur soluta voluptatibus. Et non aut sed rerum rerum. Ab porro pariatur ipsa sed id recusandae.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,20,NULL,4,4,4,0,5,1100.00,3000.00,'weekly',0,10,3,4,137,0,5,'2023-05-01',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.832571','-75.915858',0,0,0,1,'published','approved','2023-02-21 06:06:38','2023-03-18 01:06:51',NULL,NULL,NULL),(42,'Senior Solutions Engineer','Quia reprehenderit eius modi ab asperiores. Aliquid vel provident magni officia doloribus atque. Est assumenda aut omnis rem aut et.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,2,NULL,1,1,1,0,5,1000.00,2600.00,'weekly',1,1,2,5,109,0,4,'2023-04-03',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.768149','-76.535599',0,0,0,0,'published','approved','2023-02-26 20:26:28','2023-03-18 01:06:51',NULL,NULL,NULL),(43,'Senior Service Delivery Engineer','Odit numquam quis quae rerum omnis dolor numquam. Expedita at nihil id voluptas. Officia quidem fuga est inventore recusandae ex.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,10,NULL,1,1,1,0,5,1300.00,2100.00,'hourly',1,7,2,2,16,0,2,'2023-05-11',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.030051','-76.36395',0,0,1,0,'published','approved','2023-03-08 22:32:53','2023-03-18 01:06:51',NULL,NULL,NULL),(44,'Senior Director, Global Sales Development','Provident labore et maxime omnis est velit. Quod debitis molestias sed magnam quasi. Voluptas maxime accusantium harum expedita maiores quia sed.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,1,NULL,1,1,1,0,3,1500.00,2100.00,'yearly',1,4,4,1,48,0,6,'2023-04-26',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.275687','-75.647276',0,0,1,1,'published','approved','2023-01-19 15:58:26','2023-03-18 01:06:51',NULL,NULL,NULL),(45,'Partner Program Manager','Quae reiciendis sunt fugit sint ullam. Perferendis voluptas voluptatem placeat voluptatem quo reprehenderit. Non magni voluptatem dolor. Et dicta quia ut debitis deleniti.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,9,NULL,4,4,4,0,4,1100.00,2000.00,'hourly',1,9,2,3,42,0,5,'2023-04-25',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.775063','-75.158002',0,0,0,1,'published','approved','2023-03-07 19:35:10','2023-03-18 01:06:51',NULL,NULL,NULL),(46,'Principal Cloud Solutions Engineer','Soluta est eius est optio error unde beatae. Ea fugit id eos. Fugit cum ut amet repudiandae velit sit quasi.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,8,NULL,6,6,6,0,5,800.00,2200.00,'hourly',1,4,2,1,13,0,8,'2023-04-11',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.434523','-75.651866',0,0,1,0,'published','approved','2023-03-06 14:39:01','2023-03-18 01:06:51',NULL,NULL,NULL),(47,'Senior Cloud Solutions Engineer','Et voluptatem et ut qui. Facere alias nihil ipsam et est architecto. Facilis ullam iste dolorem non animi ducimus adipisci repellendus. Quia est sunt et voluptatum molestiae qui alias.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,2,NULL,1,1,1,0,4,1000.00,3000.00,'monthly',0,10,3,1,11,0,6,'2023-03-23',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.768149','-76.535599',0,0,1,1,'published','approved','2023-03-16 06:05:01','2023-03-18 01:06:51',NULL,NULL,NULL),(48,'Senior Customer Success Manager','Fuga quis explicabo quia cupiditate incidunt voluptatem est. Enim aut voluptatibus adipisci consequatur. Veniam voluptatem labore voluptatem nemo vel ducimus soluta.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,6,NULL,1,1,1,0,3,1000.00,2800.00,'weekly',1,7,4,3,28,0,5,'2023-04-06',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.583541','-76.705847',0,0,1,1,'published','approved','2023-02-18 11:57:48','2023-03-18 01:06:51',NULL,NULL,NULL),(49,'Inside Account Manager','Dolorem qui autem eum ipsa aliquam qui. Vel ut repudiandae quis dolore. Sit veritatis dolor dolore rerum nostrum impedit doloribus. Blanditiis eos fugit ex ipsa.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,10,NULL,1,1,1,0,3,700.00,2700.00,'yearly',1,4,1,3,79,0,3,'2023-04-13',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.030051','-76.36395',0,0,1,0,'published','approved','2023-02-27 22:41:27','2023-03-18 01:06:51',NULL,NULL,NULL),(50,'UX Jobs Board','Occaecati consequatur exercitationem dolore esse molestias. Sapiente minima vitae sed. Aliquam eos quasi consequuntur laudantium libero sapiente. Cumque adipisci quam nulla ut ut dolores.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,10,NULL,1,1,1,0,4,700.00,2300.00,'monthly',1,6,2,5,63,0,7,'2023-04-17',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.030051','-76.36395',0,0,0,0,'published','approved','2023-02-26 10:08:21','2023-03-18 01:06:51',NULL,NULL,NULL),(51,'Senior Laravel Developer (TALL Stack)','Laudantium alias repudiandae voluptatem repellendus quos sint. Fugit occaecati sit saepe exercitationem libero rerum animi odio.','<h5>Responsibilities</h5>\n                <div>\n                    <p>As a Product Designer, you will work within a Product Delivery Team fused with UX, engineering, product and data talent.</p>\n                    <ul>\n                        <li>Have sound knowledge of commercial activities.</li>\n                        <li>Build next-generation web applications with a focus on the client side</li>\n                        <li>Work on multiple projects at once, and consistently meet draft deadlines</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Revise the work of previous designers to create a unified aesthetic for our brand materials</li>\n                    </ul>\n                </div>\n                <h5>Qualification </h5>\n                <div>\n                    <ul>\n                        <li>B.C.A / M.C.A under National University course complete.</li>\n                        <li>3 or more years of professional design experience</li>\n                        <li>have already graduated or are currently in any year of study</li>\n                        <li>Advanced degree or equivalent experience in graphic and web design</li>\n                    </ul>\n                </div>',NULL,20,NULL,4,4,4,0,4,1200.00,2600.00,'monthly',0,6,1,2,35,0,6,'2023-04-18',1,'Botble\\JobBoard\\Models\\Account',0,0,0,'43.832571','-75.915858',0,0,1,0,'published','approved','2023-02-24 01:58:42','2023-03-18 01:06:51',NULL,NULL,NULL);

--
