--
-- Host: localhost    Database: fusi
-- ------------------------------------------------------


--
-- Table structure for table `audit_logs`
--

CREATE TABLE `audit_logs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject_id` bigint(20) unsigned DEFAULT NULL,
  `subject_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `properties` text COLLATE utf8mb4_unicode_ci,
  `host` varchar(46) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_uuid` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `audit_logs`
--

INSERT INTO `audit_logs` VALUES (1,'audit:created',1,'App\\Models\\Order#1',1,'{\"user_id\":1,\"code\":\"210730030158\",\"status\":\"open\",\"updated_at\":\"2021-07-30 15:01:58\",\"created_at\":\"2021-07-30 15:01:58\",\"id\":1}','36.71.252.129','2021-07-30 15:01:58','2021-07-30 15:01:58',NULL),(2,'audit:created',2,'App\\Models\\Order#2',1,'{\"user_id\":1,\"code\":\"210802111657\",\"status\":\"open\",\"updated_at\":\"2021-08-02 11:16:57\",\"created_at\":\"2021-08-02 11:16:57\",\"id\":2}','180.251.135.75','2021-08-02 11:16:57','2021-08-02 11:16:57',NULL),(3,'audit:created',3,'App\\Models\\Order#3',1,'{\"user_id\":1,\"code\":\"210805052116\",\"status\":\"open\",\"updated_at\":\"2021-08-05 17:21:16\",\"created_at\":\"2021-08-05 17:21:16\",\"id\":3}','118.96.215.228','2021-08-05 17:21:16','2021-08-05 17:21:16',NULL),(4,'audit:updated',3,'App\\Models\\Order#3',1,'{\"updated_at\":\"2021-08-05 17:21:17\",\"attributes\":{\"user\":{\"fname\":\"Yan Syafri\",\"lname\":\"Hidayat\",\"email\":\"yansyaf@gmail.com\",\"phone\":\"08118040685\",\"country\":\"Indonesia\",\"city\":\"Bandung\",\"address\":\"Jl. PHH Mustopa No.39\",\"channel\":\"fusi_bniva\"},\"payment\":{\"merchant_trxid\":\"210805052116\",\"amount\":\"935000\",\"name\":\"Yan Syafri Hidayat\",\"email\":\"yansyaf@gmail.com\",\"phone\":\"Yan Syafri Hidayat\",\"request_datetime\":\"05-08-2021 17:21:16\",\"expire_datetime\":\"06-08-2021 17:21:16\",\"va_number\":\"9884068521080502\",\"url\":\"\",\"qstring\":\"\",\"image_url\":\"https:\\/\\/payment.fusi.id\\/storage\\/15\\/60fe1614e38a3_logo_bni.png\"}},\"deadline\":\"06-08-2021\",\"id\":3}','118.96.215.228','2021-08-05 17:21:17','2021-08-05 17:21:17',NULL),(5,'audit:created',4,'App\\Models\\Order#4',1,'{\"user_id\":1,\"code\":\"210806090132\",\"status\":\"open\",\"updated_at\":\"2021-08-06 09:01:32\",\"created_at\":\"2021-08-06 09:01:32\",\"id\":4}','180.251.141.137','2021-08-06 09:01:32','2021-08-06 09:01:32',NULL),(6,'audit:updated',4,'App\\Models\\Order#4',1,'{\"updated_at\":\"2021-08-06 09:01:33\",\"attributes\":{\"user\":{\"fname\":\"Fusi\",\"lname\":\"Alim\",\"email\":\"muahamadalim424@gmail.com\",\"phone\":\"08956672312\",\"country\":\"Indonesia\",\"city\":\"Bandung\",\"address\":\"Surapati core blok M6\",\"channel\":\"fusi_bniva\"},\"payment\":{\"merchant_trxid\":\"210806090132\",\"amount\":\"99000\",\"name\":\"Fusi Alim\",\"email\":\"muahamadalim424@gmail.com\",\"phone\":\"Fusi Alim\",\"request_datetime\":\"06-08-2021 09:01:32\",\"expire_datetime\":\"07-08-2021 09:01:32\",\"va_number\":\"9884068521080601\",\"url\":\"\",\"qstring\":\"\",\"image_url\":\"https:\\/\\/payment.fusi.id\\/storage\\/15\\/60fe1614e38a3_logo_bni.png\"}},\"deadline\":\"07-08-2021\",\"id\":4}','180.251.141.137','2021-08-06 09:01:33','2021-08-06 09:01:33',NULL),(7,'audit:created',5,'App\\Models\\Order#5',1,'{\"user_id\":1,\"code\":\"210806123928\",\"status\":\"open\",\"updated_at\":\"2021-08-06 12:39:28\",\"created_at\":\"2021-08-06 12:39:28\",\"id\":5}','180.253.24.188','2021-08-06 12:39:28','2021-08-06 12:39:28',NULL),(8,'audit:updated',5,'App\\Models\\Order#5',1,'{\"updated_at\":\"2021-08-06 12:39:29\",\"attributes\":{\"user\":{\"fname\":\"Yan Syafri\",\"lname\":\"Hidayat\",\"email\":\"yansyaf@gmail.com\",\"phone\":\"08118040685\",\"country\":\"Indonesia\",\"city\":\"Bandung\",\"address\":\"Surapati Core\",\"channel\":\"fusi_alfa\"},\"payment\":{\"merchant_trxid\":\"210806123928\",\"amount\":\"1969000\",\"name\":\"Yan Syafri Hidayat\",\"email\":\"yansyaf@gmail.com\",\"phone\":\"Yan Syafri Hidayat\",\"request_datetime\":\"06-08-2021 12:39:28\",\"expire_datetime\":\"07-08-2021 12:39:28\",\"va_number\":\"3399970735609345\",\"url\":\"\",\"qstring\":\"\",\"image_url\":\"https:\\/\\/payment.fusi.id\\/storage\\/8\\/60fe159cd042c_logo_alfamart.png\"}},\"deadline\":\"07-08-2021\",\"id\":5}','180.253.24.188','2021-08-06 12:39:29','2021-08-06 12:39:29',NULL),(9,'audit:created',6,'App\\Models\\Order#6',NULL,'{\"user_uuid\":\"13ed55b2-bd56-4877-8e5e-905bf2deb8e0\",\"code\":\"211006125640\",\"status\":\"open\",\"updated_at\":\"2021-10-06 12:56:40\",\"created_at\":\"2021-10-06 12:56:40\",\"id\":6}','36.78.67.66','2021-10-06 12:56:40','2021-10-06 12:56:40','admin@admin.com'),(10,'audit:updated',6,'App\\Models\\Order#6',NULL,'{\"updated_at\":\"2021-10-06 12:56:41\",\"attributes\":{\"user\":{\"fname\":\"Bagasraga\",\"lname\":\"raga\",\"email\":\"hasea23@gmail.com\",\"phone\":\"089694026392\",\"city\":\"80\",\"address\":\"Jl Raya Batujajar No 26 RT01 RW 02\",\"channel\":\"fusi_ovo\"},\"payment\":{\"merchant_trxid\":\"211006125640\",\"amount\":\"51000\",\"name\":\"Bagasraga raga\",\"email\":\"hasea23@gmail.com\",\"phone\":\"Bagasraga raga\",\"request_datetime\":\"06-10-2021 12:56:40\",\"expire_datetime\":\"07-10-2021 12:56:40\",\"va_number\":\"\",\"url\":\"https:\\/\\/payment.fusi.id\\/pay?trxid=3399981299786892&phonenumber=089694026392&channel=ovo&bill_no=0016334998013418&signature=5d2497af199b1aeebf7260f1d5d3661bf7767e88\",\"qstring\":\"\",\"image_url\":\"https:\\/\\/payment.fusi.id\\/storage\\/1\\/60fe1524697bb_logo_ovo.png\"}},\"deadline\":\"07-10-2021\",\"id\":6}','36.78.67.66','2021-10-06 12:56:41','2021-10-06 12:56:41','admin@admin.com'),(11,'audit:created',7,'App\\Models\\Order#7',NULL,'{\"user_uuid\":\"e0f29989-0c94-45be-b7b3-da76f8981d9b\",\"code\":\"211006011214\",\"status\":\"open\",\"updated_at\":\"2021-10-06 13:12:14\",\"created_at\":\"2021-10-06 13:12:14\",\"id\":7}','36.78.67.66','2021-10-06 13:12:14','2021-10-06 13:12:14','admin@fusi.id'),(12,'audit:updated',7,'App\\Models\\Order#7',NULL,'{\"updated_at\":\"2021-10-06 13:12:16\",\"attributes\":{\"user\":{\"fname\":\"Mohamad\",\"lname\":\"Al Jihad\",\"email\":\"aljihadmohamad@gmail.com\",\"phone\":\"081211526580\",\"city\":\"710\",\"address\":\"Alamat: Komplek Surapati Core No.M6 Jl. PHH. Mustofa No, 39, Pasirlayung, Kec. Cibeunying Kidul, Kota Bandung, Jawa Barat 40192\",\"channel\":\"fusi_ovo\"},\"payment\":{\"merchant_trxid\":\"211006011214\",\"amount\":\"20000\",\"name\":\"Mohamad Al Jihad\",\"email\":\"aljihadmohamad@gmail.com\",\"phone\":\"Mohamad Al Jihad\",\"request_datetime\":\"06-10-2021 13:12:14\",\"expire_datetime\":\"07-10-2021 13:12:14\",\"va_number\":\"\",\"url\":\"https:\\/\\/payment.fusi.id\\/pay?trxid=3399981272168074&phonenumber=081211526580&channel=ovo&bill_no=0016335007361390&signature=98fbc7b8565ce3de237a34cc8870362e5664bc71\",\"qstring\":\"\",\"image_url\":\"https:\\/\\/payment.fusi.id\\/storage\\/1\\/60fe1524697bb_logo_ovo.png\"}},\"deadline\":\"07-10-2021\",\"id\":7}','36.78.67.66','2021-10-06 13:12:16','2021-10-06 13:12:16','admin@fusi.id'),(13,'audit:created',8,'App\\Models\\Order#8',NULL,'{\"user_uuid\":\"13ed55b2-bd56-4877-8e5e-905bf2deb8e0\",\"code\":\"211012024430\",\"status\":\"open\",\"updated_at\":\"2021-10-12 14:44:30\",\"created_at\":\"2021-10-12 14:44:30\",\"id\":8}','36.71.226.43','2021-10-12 14:44:30','2021-10-12 14:44:30','admin@admin.com'),(14,'audit:updated',8,'App\\Models\\Order#8',NULL,'{\"updated_at\":\"2021-10-12 14:44:31\",\"attributes\":{\"user\":{\"fname\":\"Bagasraga\",\"lname\":\"raga\",\"email\":\"hasea23@gmail.com\",\"phone\":\"089694026392\",\"city\":\"80\",\"address\":\"Jl Raya Batujajar No 26 RT01 RW 02\",\"channel\":\"fusi_ovo\"},\"payment\":{\"merchant_trxid\":\"211012024430\",\"amount\":\"34000\",\"name\":\"Bagasraga raga\",\"email\":\"hasea23@gmail.com\",\"phone\":\"Bagasraga raga\",\"request_datetime\":\"12-10-2021 14:44:30\",\"expire_datetime\":\"13-10-2021 14:44:30\",\"va_number\":\"\",\"url\":\"https:\\/\\/payment.fusi.id\\/pay?trxid=3399981246557793&phonenumber=089694026392&channel=ovo&bill_no=0016340246703698&signature=1ab5d1f0a564800fb0238242a7f8fc8d0d6e947d\",\"qstring\":\"\",\"image_url\":\"https:\\/\\/payment.fusi.id\\/storage\\/1\\/60fe1524697bb_logo_ovo.png\"}},\"deadline\":\"13-10-2021\",\"id\":8}','36.71.226.43','2021-10-12 14:44:31','2021-10-12 14:44:31','admin@admin.com'),(15,'audit:created',9,'App\\Models\\Order#9',NULL,'{\"user_uuid\":\"e0f29989-0c94-45be-b7b3-da76f8981d9b\",\"code\":\"211012024734\",\"status\":\"open\",\"updated_at\":\"2021-10-12 14:47:34\",\"created_at\":\"2021-10-12 14:47:34\",\"id\":9}','36.71.226.43','2021-10-12 14:47:34','2021-10-12 14:47:34','admin@fusi.id'),(16,'audit:updated',9,'App\\Models\\Order#9',NULL,'{\"updated_at\":\"2021-10-12 14:47:35\",\"attributes\":{\"user\":{\"fname\":\"mohamad\",\"lname\":\"al jihad\",\"email\":\"aljihadmohamad@gmail.com\",\"phone\":\"081211526580\",\"city\":\"710\",\"address\":\"Komplek Surapati Core No.M6 Jl. PHH. Mustofa No, 39, Pasirlayung, Kec. Cibeunying Kidul, Kota Bandung, Jawa Barat 40192\",\"channel\":\"fusi_ovo\"},\"payment\":{\"merchant_trxid\":\"211012024734\",\"amount\":\"35000\",\"name\":\"mohamad al jihad\",\"email\":\"aljihadmohamad@gmail.com\",\"phone\":\"mohamad al jihad\",\"request_datetime\":\"12-10-2021 14:47:34\",\"expire_datetime\":\"13-10-2021 14:47:34\",\"va_number\":\"\",\"url\":\"https:\\/\\/payment.fusi.id\\/pay?trxid=3399981283978991&phonenumber=081211526580&channel=ovo&bill_no=0016340248540237&signature=c7726b2b56508afa328bc1071849ac9a9807108f\",\"qstring\":\"\",\"image_url\":\"https:\\/\\/payment.fusi.id\\/storage\\/1\\/60fe1524697bb_logo_ovo.png\"}},\"deadline\":\"13-10-2021\",\"id\":9}','36.71.226.43','2021-10-12 14:47:35','2021-10-12 14:47:35','admin@fusi.id'),(17,'audit:created',10,'App\\Models\\Order#10',NULL,'{\"user_uuid\":\"e0f29989-0c94-45be-b7b3-da76f8981d9b\",\"code\":\"211012024840\",\"status\":\"open\",\"updated_at\":\"2021-10-12 14:48:40\",\"created_at\":\"2021-10-12 14:48:40\",\"id\":10}','36.71.226.43','2021-10-12 14:48:40','2021-10-12 14:48:40','admin@fusi.id'),(18,'audit:updated',10,'App\\Models\\Order#10',NULL,'{\"attributes\":{\"user\":{\"fname\":\"Mohamad\",\"lname\":\"Al Jihad\",\"email\":\"aljihadmohamad@gmail.com\",\"phone\":\"081211526580\",\"city\":\"710\",\"address\":\"Komplek Surapati Core No.M6 Jl. PHH. Mustofa No, 39, Pasirlayung, Kec. Cibeunying Kidul, Kota Bandung, Jawa Barat 40192\",\"channel\":\"fusi_mandiri\"},\"payment\":{\"merchant_trxid\":\"211012024840\",\"amount\":\"20000\",\"name\":\"Mohamad Al Jihad\",\"email\":\"aljihadmohamad@gmail.com\",\"phone\":\"Mohamad Al Jihad\",\"request_datetime\":\"12-10-2021 14:48:40\",\"expire_datetime\":\"13-10-2021 14:48:40\",\"va_number\":\"8830833999570759\",\"url\":\"\",\"qstring\":\"\",\"image_url\":\"https:\\/\\/payment.fusi.id\\/storage\\/13\\/60fe15f936172_logo_mandiri.png\"}},\"deadline\":\"13-10-2021\",\"id\":10}','36.71.226.43','2021-10-12 14:48:40','2021-10-12 14:48:40','admin@fusi.id'),(19,'audit:created',11,'App\\Models\\Order#11',NULL,'{\"user_uuid\":\"e0f29989-0c94-45be-b7b3-da76f8981d9b\",\"code\":\"211108094124\",\"status\":\"open\",\"updated_at\":\"2021-11-08 09:41:24\",\"created_at\":\"2021-11-08 09:41:24\",\"id\":11}','125.163.29.218','2021-11-08 09:41:24','2021-11-08 09:41:24','admin@fusi.id'),(20,'audit:created',12,'App\\Models\\Order#12',NULL,'{\"user_uuid\":\"e0f29989-0c94-45be-b7b3-da76f8981d9b\",\"code\":\"211108094929\",\"status\":\"open\",\"updated_at\":\"2021-11-08 09:49:29\",\"created_at\":\"2021-11-08 09:49:29\",\"id\":12}','125.163.29.218','2021-11-08 09:49:29','2021-11-08 09:49:29','admin@fusi.id'),(21,'audit:created',13,'App\\Models\\Order#13',NULL,'{\"user_uuid\":\"e0f29989-0c94-45be-b7b3-da76f8981d9b\",\"code\":\"211108110357\",\"status\":\"open\",\"updated_at\":\"2021-11-08 11:03:57\",\"created_at\":\"2021-11-08 11:03:57\",\"id\":13}','125.163.29.218','2021-11-08 11:03:57','2021-11-08 11:03:57','admin@fusi.id'),(22,'audit:created',14,'App\\Models\\Order#14',NULL,'{\"user_uuid\":\"e0f29989-0c94-45be-b7b3-da76f8981d9b\",\"code\":\"211108120227\",\"status\":\"open\",\"updated_at\":\"2021-11-08 12:02:27\",\"created_at\":\"2021-11-08 12:02:27\",\"id\":14}','125.163.29.218','2021-11-08 12:02:27','2021-11-08 12:02:27','admin@fusi.id');

--
-- Table structure for table `capabilities`
--

CREATE TABLE `capabilities` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `category_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `category_fk_4236738` (`category_id`),
  CONSTRAINT `category_fk_4236738` FOREIGN KEY (`category_id`) REFERENCES `capability_categories` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `capabilities`
--


--
-- Table structure for table `capability_categories`
--

CREATE TABLE `capability_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `capability_categories_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `capability_categories`
--


--
-- Table structure for table `capability_resource`
--

CREATE TABLE `capability_resource` (
  `capability_id` bigint(20) unsigned NOT NULL,
  `resource_id` bigint(20) unsigned NOT NULL,
  KEY `capability_id_fk_4236741` (`capability_id`),
  KEY `resource_id_fk_4236741` (`resource_id`),
  CONSTRAINT `capability_id_fk_4236741` FOREIGN KEY (`capability_id`) REFERENCES `capabilities` (`id`) ON DELETE CASCADE,
  CONSTRAINT `resource_id_fk_4236741` FOREIGN KEY (`resource_id`) REFERENCES `resources` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `capability_resource`
--


--
-- Table structure for table `capability_tag`
--

CREATE TABLE `capability_tag` (
  `capability_id` bigint(20) unsigned NOT NULL,
  `tag_id` bigint(20) unsigned NOT NULL,
  KEY `capability_id_fk_4236742` (`capability_id`),
  KEY `tag_id_fk_4236742` (`tag_id`),
  CONSTRAINT `capability_id_fk_4236742` FOREIGN KEY (`capability_id`) REFERENCES `capabilities` (`id`) ON DELETE CASCADE,
  CONSTRAINT `tag_id_fk_4236742` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `capability_tag`
--


--
-- Table structure for table `carts`
--

CREATE TABLE `carts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `qty` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `product_id` bigint(20) unsigned NOT NULL,
  `user_uuid` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_fk_4236744` (`user_id`),
  KEY `product_fk_4236745` (`product_id`),
  CONSTRAINT `product_fk_4236745` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`),
  CONSTRAINT `user_fk_4236744` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `carts`
--

INSERT INTO `carts` VALUES (1,NULL,'2021-07-01 08:29:35','2021-07-30 09:34:01','2021-07-30 09:34:01',1,1,NULL),(2,NULL,'2021-07-01 08:37:50','2021-07-30 09:34:05','2021-07-30 09:34:05',1,1,NULL),(3,NULL,'2021-07-08 05:39:01','2021-07-08 05:39:10','2021-07-08 05:39:10',1,17,NULL),(4,1,'2021-07-30 09:33:51','2021-07-30 09:34:09','2021-07-30 09:34:09',1,2,NULL),(5,1,'2021-07-30 09:34:40','2021-08-05 15:27:27','2021-08-05 15:27:27',1,3,NULL),(6,1,'2021-07-30 09:53:53','2021-07-30 15:01:43','2021-07-30 15:01:43',1,1,NULL),(7,1,'2021-07-30 15:01:38','2021-07-30 15:01:46','2021-07-30 15:01:46',1,3,NULL),(8,1,'2021-08-02 09:33:51','2021-08-02 11:16:49','2021-08-02 11:16:49',1,3,NULL),(9,1,'2021-08-02 11:16:44','2021-08-02 11:16:47','2021-08-02 11:16:47',1,3,NULL),(10,1,'2021-08-05 15:27:18','2021-08-06 09:00:46','2021-08-06 09:00:46',1,1,NULL),(11,1,'2021-08-06 09:00:53','2021-09-03 11:01:53','2021-09-03 11:01:53',1,3,NULL),(12,1,'2021-08-06 09:08:21','2021-09-03 11:01:50','2021-09-03 11:01:50',1,1,NULL),(13,1,'2021-08-06 12:38:31','2021-09-03 11:01:46','2021-09-03 11:01:46',1,1,NULL),(14,6,'2021-09-03 11:47:48','2021-09-03 16:20:41','2021-09-03 16:20:41',1,3,'e0f29989-0c94-45be-b7b3-da76f8981d9b'),(15,1,'2021-09-03 16:20:59','2021-10-04 11:13:05','2021-10-04 11:13:05',1,2,'c2d66419-abf5-4402-af5a-2eee04dc5849'),(16,1,'2021-09-09 10:35:28','2021-10-04 11:13:09','2021-10-04 11:13:09',1,1,'66703c25-a977-4c40-ba51-e6e1a0066a54'),(17,12,'2021-10-04 10:55:50','2021-10-04 11:17:12','2021-10-04 11:17:12',1,1,'13ed55b2-bd56-4877-8e5e-905bf2deb8e0'),(18,1,'2021-10-04 11:17:27','2021-10-06 12:56:40','2021-10-06 12:56:40',1,3,'13ed55b2-bd56-4877-8e5e-905bf2deb8e0'),(19,2,'2021-10-04 15:16:00','2021-10-06 10:37:50','2021-10-06 10:37:50',1,1,'e0f29989-0c94-45be-b7b3-da76f8981d9b'),(20,1,'2021-10-06 13:13:18','2021-10-06 13:17:55','2021-10-06 13:17:55',1,3,'e0f29989-0c94-45be-b7b3-da76f8981d9b'),(21,1,'2021-10-06 13:17:52','2021-10-12 14:47:34','2021-10-12 14:47:34',1,32,'e0f29989-0c94-45be-b7b3-da76f8981d9b'),(22,1,'2021-10-12 14:44:03','2021-10-12 14:44:30','2021-10-12 14:44:30',1,3,'13ed55b2-bd56-4877-8e5e-905bf2deb8e0'),(23,1,'2021-10-12 14:45:49','2021-10-12 14:45:53','2021-10-12 14:45:53',1,3,'e0f29989-0c94-45be-b7b3-da76f8981d9b'),(24,1,'2021-10-12 14:48:07','2021-10-12 14:48:40','2021-10-12 14:48:40',1,3,'e0f29989-0c94-45be-b7b3-da76f8981d9b'),(25,1,'2021-10-12 15:10:21','2021-11-08 09:41:24','2021-11-08 09:41:24',1,2,'e0f29989-0c94-45be-b7b3-da76f8981d9b'),(26,1,'2021-10-14 10:53:19','2021-10-14 10:53:19',NULL,1,2,'13ed55b2-bd56-4877-8e5e-905bf2deb8e0'),(27,1,'2021-11-08 09:39:31','2021-11-08 09:39:39','2021-11-08 09:39:39',1,4,'e0f29989-0c94-45be-b7b3-da76f8981d9b'),(28,1,'2021-11-08 09:48:44','2021-11-08 09:49:29','2021-11-08 09:49:29',1,32,'e0f29989-0c94-45be-b7b3-da76f8981d9b'),(29,1,'2021-11-08 11:02:18','2021-11-08 11:03:57','2021-11-08 11:03:57',1,2,'e0f29989-0c94-45be-b7b3-da76f8981d9b'),(30,2,'2021-11-08 11:17:49','2021-11-08 12:02:27','2021-11-08 12:02:27',1,2,'e0f29989-0c94-45be-b7b3-da76f8981d9b'),(31,3,'2021-11-08 15:45:46','2021-11-08 18:29:48',NULL,1,2,'e0f29989-0c94-45be-b7b3-da76f8981d9b');

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

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

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


--
-- Table structure for table `complaints`
--

CREATE TABLE `complaints` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_id` int(11) NOT NULL,
  `message` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('open','inprocess','closed') 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 `complaints`
--


--
-- Table structure for table `districts`
--

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

--
-- Dumping data for table `districts`
--


--
-- Table structure for table `inquiries`
--

CREATE TABLE `inquiries` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `inquiries`
--

INSERT INTO `inquiries` VALUES (1,'e0f29989-0c94-45be-b7b3-da76f8981d9b','Looking for bagas, 1 Pcs, Request price','2021-09-03 13:47:14','2021-09-03 13:47:14'),(2,'e0f29989-0c94-45be-b7b3-da76f8981d9b','Looking for Agriculture Drone, 1 Pcs, Request price, Request sample','2021-10-06 13:37:39','2021-10-06 13:37:39');

--
-- Table structure for table `media`
--

CREATE TABLE `media` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `collection_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mime_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `disk` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `conversions_disk` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `size` bigint(20) unsigned NOT NULL,
  `manipulations` json NOT NULL,
  `custom_properties` json NOT NULL,
  `responsive_images` json NOT NULL,
  `order_column` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `media_model_type_model_id_index` (`model_type`,`model_id`)
) ENGINE=InnoDB AUTO_INCREMENT=183 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `media`
--

INSERT INTO `media` VALUES (1,'App\\Models\\ProductCategory',1,'28ac0603-41f3-4fef-b9e4-f6bb9b4a2572','image','60d57528a320b_iosense','60d57528a320b_iosense.png','image/png','public','public',5559,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',1,'2021-06-25 06:18:27','2021-06-25 06:18:28'),(2,'App\\Models\\ProductCategory',2,'41f612a1-6b5a-4179-bd1b-2ef3cef475bb','image','60dd3fefb1a8e_intelli','60dd3fefb1a8e_intelli.png','image/png','public','public',6808,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',2,'2021-07-01 04:09:22','2021-07-01 04:09:22'),(3,'App\\Models\\ProductCategory',3,'21364bd2-7615-42f0-9b62-1bc88415ff2d','image','60dd401f6f1c6_iocomm','60dd401f6f1c6_iocomm.png','image/png','public','public',3620,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',3,'2021-07-01 04:10:09','2021-07-01 04:10:09'),(4,'App\\Models\\ProductCategory',4,'19a07a5d-c561-4e51-ae24-b56883d983e1','image','60dd406ad1196_iocontrol','60dd406ad1196_iocontrol.png','image/png','public','public',4581,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',4,'2021-07-01 04:11:25','2021-07-01 04:11:25'),(5,'App\\Models\\ProductCategory',5,'12efc941-cdbe-471e-b917-9b40bc64bf86','image','60dd4077532bf_iometer','60dd4077532bf_iometer.png','image/png','public','public',3679,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',5,'2021-07-01 04:11:44','2021-07-01 04:11:45'),(6,'App\\Models\\ProductCategory',6,'817ba5b0-a0b8-4dc0-b362-0f2ad1ede0f1','image','60dd40b0ba7c0_ioreader','60dd40b0ba7c0_ioreader.png','image/png','public','public',5484,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',6,'2021-07-01 04:12:35','2021-07-01 04:12:35'),(7,'App\\Models\\ProductCategory',7,'e0ef5d4a-2c04-4ee4-bd9c-607de6a93d42','image','60dd40c5951d2_iotags','60dd40c5951d2_iotags.png','image/png','public','public',4060,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',7,'2021-07-01 04:12:55','2021-07-01 04:12:55'),(8,'App\\Models\\ProductCategory',8,'c823ca8a-b4fe-4e0b-81b8-0543f087ee8c','image','60dd40dcdb864_iotrack','60dd40dcdb864_iotrack.png','image/png','public','public',3625,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',8,'2021-07-01 04:13:18','2021-07-01 04:13:18'),(9,'App\\Models\\ResourceCategory',1,'35c0a457-6716-4beb-ac91-a0f35a5fe84d','image','60dd4a035a212_207-2071835_document-icon-png-transparent-png','60dd4a035a212_207-2071835_document-icon-png-transparent-png.png','image/png','public','public',11109,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',9,'2021-07-01 04:52:31','2021-07-01 04:52:31'),(10,'App\\Models\\ResourceCategory',2,'ba082800-37f9-4554-9a87-57ee9c2b6c78','image','60dd4a78175ad_document-1','60dd4a78175ad_document-1.png','image/png','public','public',4040,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',10,'2021-07-01 04:54:18','2021-07-01 04:54:18'),(11,'App\\Models\\Resource',1,'2180286e-e4bf-432f-99c1-ba4bffdfa673','file','60dd4ab29f7d2_Intelli USER GUIDE','60dd4ab29f7d2_Intelli-USER-GUIDE.pdf','application/pdf','public','public',1164175,'[]','[]','[]',11,'2021-07-01 04:55:44','2021-07-01 04:55:44'),(12,'App\\Models\\Product',0,'36770a2a-b532-4c21-9fb9-81ed78af920f','ck-media','WhatsApp Image 2021-06-22 at 10.23.44','WhatsApp-Image-2021-06-22-at-10.23.44.jpeg','image/jpeg','public','public',78415,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',12,'2021-07-01 07:07:48','2021-07-01 07:07:48'),(13,'App\\Models\\Product',3,'7f5259d9-d60a-444a-a205-0012bd355d1e','ck-media','WhatsApp Image 2021-06-22 at 10.23.44','WhatsApp-Image-2021-06-22-at-10.23.44.jpeg','image/jpeg','public','public',111084,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',13,'2021-07-01 07:29:24','2021-07-01 07:29:50'),(14,'App\\Models\\Product',2,'ddfcb6e3-c124-47c9-a01d-44e482f85b30','ck-media','intellilora','intellilora.jpg','image/jpeg','public','public',240977,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',14,'2021-07-01 07:31:07','2021-07-01 07:31:07'),(15,'App\\Models\\Product',1,'c99726d3-5b43-4b80-9c93-6307436399fb','ck-media','WhatsApp Image 2021-06-22 at 10.22.58','WhatsApp-Image-2021-06-22-at-10.22.58.jpeg','image/jpeg','public','public',312733,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',15,'2021-07-01 07:33:09','2021-07-01 07:33:09'),(16,'App\\Models\\Product',4,'02c606d6-ab00-465a-b0ac-13a6b17241b6','ck-media','smartlampuji3','smartlampuji3.jpg','image/jpeg','public','public',154245,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',16,'2021-07-01 08:44:40','2021-07-01 08:45:12'),(17,'App\\Models\\Product',4,'ba6eb05a-6c79-4c0e-9f9b-eac9a3ac0c4e','ck-media','smartlampnema2','smartlampnema2.jpg','image/jpeg','public','public',289927,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',17,'2021-07-01 08:44:40','2021-07-01 08:45:12'),(18,'App\\Models\\Product',5,'9d372483-fef5-4a43-84e5-f60c36a1f15b','ck-media','tector','tector.jpeg','image/jpeg','public','public',64644,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',18,'2021-07-01 09:02:34','2021-07-01 09:02:48'),(19,'App\\Models\\Product',5,'3f7ebc0b-2a63-4125-8788-fac7aba2ab58','ck-media','WhatsApp Image 2021-06-23 at 07.01.16','WhatsApp-Image-2021-06-23-at-07.01.16.jpeg','image/jpeg','public','public',121006,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',19,'2021-07-01 09:02:34','2021-07-01 09:02:48'),(20,'App\\Models\\Product',6,'82ae5f57-a2b2-4699-9f9b-1787147d1183','ck-media','image','image.png','image/png','public','public',91094,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',20,'2021-07-01 09:09:37','2021-07-01 09:27:18'),(21,'App\\Models\\Product',6,'b9e3b0a0-e05a-4405-a873-73afaaaa8214','ck-media','image','image.png','image/png','public','public',50186,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',21,'2021-07-01 09:10:35','2021-07-01 09:27:18'),(22,'App\\Models\\Product',6,'a4f447c6-2bed-4c2b-a4e6-841ebcf819cd','ck-media','image','image.png','image/png','public','public',59072,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',22,'2021-07-01 09:11:45','2021-07-01 09:27:18'),(23,'App\\Models\\Product',6,'51cab09d-7211-47a2-8e7a-9c9e73933475','ck-media','image','image.png','image/png','public','public',139093,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',23,'2021-07-01 09:12:52','2021-07-01 09:27:18'),(24,'App\\Models\\Product',7,'b6504a37-fdbc-42e5-a74e-4042ca622410','ck-media','image','image.png','image/png','public','public',525888,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',24,'2021-07-01 09:39:41','2021-07-01 09:39:41'),(25,'App\\Models\\Product',8,'4c48f690-0151-47dd-9e94-3a56b9b28922','ck-media','image','image.png','image/png','public','public',77787,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',25,'2021-07-01 09:47:09','2021-07-01 09:51:35'),(26,'App\\Models\\Product',8,'1f75987f-377f-4dea-b528-d52f9da396e3','ck-media','image','image.png','image/png','public','public',126967,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',26,'2021-07-01 09:48:26','2021-07-01 09:51:35'),(27,'App\\Models\\ProductCategory',9,'31636548-46c7-43ba-9e31-2ce1a085cb51','image','60dd99ee58275_sc','60dd99ee58275_sc.png','image/png','public','public',8183,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',27,'2021-07-01 10:33:21','2021-07-01 10:33:21'),(28,'App\\Models\\Product',9,'956ff283-478a-43af-b553-087dd48eef64','ck-media','image','image.png','image/png','public','public',25116,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',28,'2021-07-01 10:37:51','2021-07-01 10:42:51'),(29,'App\\Models\\Product',9,'e97c46c7-d3a8-4655-a8af-445035c0d3af','ck-media','image','image.png','image/png','public','public',236442,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',29,'2021-07-01 10:39:40','2021-07-01 10:42:51'),(30,'App\\Models\\Product',9,'359bd962-7e5a-4d23-9838-49f49eb3719e','ck-media','image','image.png','image/png','public','public',382119,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',30,'2021-07-01 10:40:04','2021-07-01 10:42:51'),(31,'App\\Models\\Product',9,'55583540-6fb6-495a-bc54-fe7d33eb8f4d','ck-media','WhatsApp Image 2021-03-25 at 10.09.42','WhatsApp-Image-2021-03-25-at-10.09.42.jpeg','image/jpeg','public','public',402967,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',31,'2021-07-01 10:41:31','2021-07-01 10:42:51'),(32,'App\\Models\\Product',9,'26108809-365b-45b3-ac09-59e3ed761aae','ck-media','WhatsApp Image 2020-01-31 at 11.20.03','WhatsApp-Image-2020-01-31-at-11.20.03.jpeg','image/jpeg','public','public',282510,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',32,'2021-07-01 10:42:01','2021-07-01 10:42:51'),(33,'App\\Models\\Product',9,'14e76cd0-5740-4c5e-90f0-8f0577cfced4','ck-media','WhatsApp Image 2020-01-31 at 11.20.03','WhatsApp-Image-2020-01-31-at-11.20.03.jpeg','image/jpeg','public','public',282510,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',33,'2021-07-01 10:42:29','2021-07-01 10:42:51'),(34,'App\\Models\\UsecaseCategory',1,'cb1a1293-df68-4f13-ba3f-aa7f7243f174','image','60dd9e689fc5f_smart-living','60dd9e689fc5f_smart-living.jpg','image/jpeg','public','public',73063,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',34,'2021-07-01 10:52:29','2021-07-01 10:52:29'),(35,'App\\Models\\UsecaseCategory',2,'e85d1ff8-b1e8-441d-b09d-c2028756aacd','image','60dd9ea38cbed_smart-agriculture','60dd9ea38cbed_smart-agriculture.jpg','image/jpeg','public','public',80226,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',35,'2021-07-01 10:53:32','2021-07-01 10:53:32'),(36,'App\\Models\\Product',10,'db38df82-98c3-485f-9bf7-0340b2b663a1','ck-media','image','image.png','image/png','public','public',90034,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',36,'2021-07-01 10:54:28','2021-07-01 10:55:46'),(37,'App\\Models\\UsecaseCategory',3,'e8e91816-f01b-4db1-a22f-5969a1bbd30a','image','60dd9ee0a62c7_industry-40','60dd9ee0a62c7_industry-40.jpg','image/jpeg','public','public',123502,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',37,'2021-07-01 10:54:41','2021-07-01 10:54:41'),(38,'App\\Models\\Product',10,'761355ce-77e9-44de-af14-796b1f2f797e','ck-media','image','image.png','image/png','public','public',191474,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',38,'2021-07-01 10:55:04','2021-07-01 10:55:46'),(39,'App\\Models\\Product',10,'2bd4e5bb-8a1a-4c1c-9afd-7d0d206c785c','ck-media','image','image.png','image/png','public','public',255205,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',39,'2021-07-01 10:55:34','2021-07-01 10:55:46'),(40,'App\\Models\\UsecaseCategory',4,'d476a718-78dd-4fc5-a75c-4b9f8b4b5d7f','image','60de7631a8769_use-case5','60de7631a8769_use-case5.png','image/png','public','public',249335,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',40,'2021-07-02 02:13:21','2021-07-02 02:13:21'),(41,'App\\Models\\Usecase',1,'c68cc064-9be1-436d-9625-7c59d9fc411e','featured_image','60de770416a18_bikesharing','60de770416a18_bikesharing.png','image/png','public','public',236442,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',41,'2021-07-02 02:17:01','2021-07-02 02:17:01'),(42,'App\\Models\\ProductCategory',10,'18eec839-a1d0-4930-804c-f35c87468dbf','image','60de7b35af9b8_iopanel','60de7b35af9b8_iopanel.png','image/png','public','public',12119,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',42,'2021-07-02 02:34:50','2021-07-02 02:34:50'),(43,'App\\Models\\Product',11,'2fdf8bc3-465b-409d-a558-a8a2dfdc095e','ck-media','image','image.png','image/png','public','public',206239,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',43,'2021-07-06 05:48:19','2021-07-06 06:03:05'),(44,'App\\Models\\Product',11,'ca1dd677-5579-4e44-b12b-8da9a602c33f','ck-media','image','image.png','image/png','public','public',433829,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',44,'2021-07-06 05:49:15','2021-07-06 06:03:05'),(45,'App\\Models\\ResourceCategory',3,'88feb67a-6838-4ad1-8b11-f48f66199d82','image','60e3f2a599050_brochur','60e3f2a599050_brochur.png','image/png','public','public',4125,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',45,'2021-07-06 06:05:47','2021-07-06 06:05:47'),(46,'App\\Models\\ResourceCategory',4,'689602c8-1406-4318-9998-a2a3d512ad6a','image','60e3f2f91ac89_presentation','60e3f2f91ac89_presentation.png','image/png','public','public',10867,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',46,'2021-07-06 06:07:03','2021-07-06 06:07:03'),(47,'App\\Models\\Resource',2,'30e5a5b6-0a33-46b1-9c54-cc83eab86ef5','file','60e3f35aee35d_FUSI Smart Meter Watering(1)','60e3f35aee35d_FUSI-Smart-Meter-Watering(1).pdf','application/pdf','public','public',1285502,'[]','[]','[]',47,'2021-07-06 06:08:39','2021-07-06 06:08:39'),(48,'App\\Models\\Usecase',2,'fd7df3ee-4e03-4d4b-9aef-3032a8c6f376','featured_image','60e566af84aac_farmer-managing-his-industrial-farm-260nw-1578994345','60e566af84aac_farmer-managing-his-industrial-farm-260nw-1578994345.jpg','image/jpeg','public','public',39613,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',48,'2021-07-07 08:32:50','2021-07-07 08:32:50'),(49,'App\\Models\\Usecase',3,'f6877834-1faf-4ce1-a212-bd05c23ed96f','ck-media','image','image.png','image/png','public','public',592094,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',49,'2021-07-07 08:34:05','2021-07-07 08:47:28'),(50,'App\\Models\\Usecase',3,'0cef14f7-9494-4f88-a4b5-cbaff2e17bf5','ck-media','image','image.png','image/png','public','public',347640,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',50,'2021-07-07 08:47:08','2021-07-07 08:47:28'),(51,'App\\Models\\Usecase',3,'44763964-0e61-439a-a91d-4bee20a2317c','featured_image','60e5674b4cab9_casing1','60e5674b4cab9_casing1.jpeg','image/jpeg','public','public',195495,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',51,'2021-07-07 08:47:28','2021-07-07 08:47:28'),(52,'App\\Models\\Product',12,'aae497e9-d99d-4a6c-aa36-dd3ecf59786a','ck-media','photo1625648278','photo1625648278.jpeg','image/jpeg','public','public',132285,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',52,'2021-07-07 09:05:44','2021-07-07 09:05:50'),(53,'App\\Models\\Resource',3,'6690ef74-e203-417d-a1fe-aa0a5d0e4a42','file','60e56f1f9560c_Smart Water Quality Monitoring System i-WQu (1)','60e56f1f9560c_Smart-Water-Quality-Monitoring-System-i-WQu-(1).pdf','application/pdf','public','public',561001,'[]','[]','[]',53,'2021-07-07 09:08:56','2021-07-07 09:08:56'),(54,'App\\Models\\Resource',4,'468a282e-bdcc-463b-9647-b5ab51f1a80f','file','60e56fa35508f_BOKS Smart Locker','60e56fa35508f_BOKS-Smart-Locker.pdf','application/pdf','public','public',779387,'[]','[]','[]',54,'2021-07-07 09:11:06','2021-07-07 09:11:06'),(55,'App\\Models\\Product',13,'08a02a6c-5508-44f8-9b6c-387701a97a3d','ck-media','image','image.png','image/png','public','public',310447,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',55,'2021-07-07 09:17:00','2021-07-07 09:19:00'),(56,'App\\Models\\Product',13,'6ebd8ba4-5271-41a6-a7c6-330c926e673c','ck-media','image','image.png','image/png','public','public',43023,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',56,'2021-07-07 09:18:28','2021-07-07 09:19:00'),(57,'App\\Models\\Product',14,'6bb39185-a865-404f-86c1-01f806e39cce','ck-media','image','image.png','image/png','public','public',50524,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',57,'2021-07-07 10:17:24','2021-07-07 10:17:37'),(58,'App\\Models\\Usecase',4,'5f262b80-e097-40b2-a1ad-4a1fcc5311f0','ck-media','image','image.png','image/png','public','public',194273,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',58,'2021-07-07 10:28:32','2021-07-07 10:32:52'),(59,'App\\Models\\Usecase',4,'f8a30675-3c54-47b4-ae8b-2b0d80ee4a4d','ck-media','image','image.png','image/png','public','public',184293,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',59,'2021-07-07 10:29:08','2021-07-07 10:32:52'),(60,'App\\Models\\Usecase',4,'050c1fd2-1abb-4d29-ab66-0793affd7308','ck-media','image','image.png','image/png','public','public',134987,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',60,'2021-07-07 10:29:32','2021-07-07 10:32:52'),(61,'App\\Models\\Usecase',4,'1d48356c-4493-48a3-b907-4fd35236e6f8','featured_image','60e582cebcda2_smartsurveillance-Early Warning System','60e582cebcda2_smartsurveillance-Early-Warning-System.png','image/png','public','public',1552228,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',61,'2021-07-07 10:32:52','2021-07-07 10:32:52'),(62,'App\\Models\\Usecase',5,'6202deac-6fb2-4e0e-aaa7-89295f34290e','featured_image','60e66b5fc8647_smartsurveillance-SmartTracking','60e66b5fc8647_smartsurveillance-SmartTracking.png','image/png','public','public',1716427,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',62,'2021-07-08 03:05:19','2021-07-08 03:05:19'),(63,'App\\Models\\Resource',5,'f6c7bc16-cd3f-41f5-a8bf-284fb21d48b8','file','60e675626cbc4_Solusi Fleet Managment IoT','60e675626cbc4_Solusi-Fleet-Managment-IoT.pdf','application/pdf','public','public',601748,'[]','[]','[]',63,'2021-07-08 03:48:01','2021-07-08 03:48:01'),(64,'App\\Models\\Usecase',6,'bb3fde26-2099-4d35-bdc0-9ce1f91e16e1','ck-media','image','image.png','image/png','public','public',35126,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',64,'2021-07-08 03:50:23','2021-07-08 04:58:29'),(65,'App\\Models\\Usecase',6,'848cce1c-ec9e-4142-a7b7-f6f7ed0d723b','ck-media','image','image.png','image/png','public','public',73201,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',65,'2021-07-08 04:50:50','2021-07-08 04:58:29'),(66,'App\\Models\\Usecase',6,'74466908-e077-4c64-9420-3178adfce6df','ck-media','image','image.png','image/png','public','public',286670,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',66,'2021-07-08 04:52:01','2021-07-08 04:58:29'),(67,'App\\Models\\Usecase',6,'05326a22-469f-481d-8689-30d1228375d9','ck-media','image','image.png','image/png','public','public',303026,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',67,'2021-07-08 04:52:42','2021-07-08 04:58:29'),(68,'App\\Models\\Usecase',6,'42af84b3-277b-4e3f-a9a8-1dde4dd5e672','featured_image','60e685e03f322_tvr','60e685e03f322_tvr.jpg','image/jpeg','public','public',30692,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',68,'2021-07-08 04:58:29','2021-07-08 04:58:29'),(69,'App\\Models\\Usecase',7,'ba70fe30-7e63-4dd0-84ad-7c8b57ae6c86','featured_image','60e68c347e264_e-learning-icons-flat_1284-3950','60e68c347e264_e-learning-icons-flat_1284-3950.jpg','image/jpeg','public','public',79606,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',69,'2021-07-08 05:25:44','2021-07-08 05:25:44'),(70,'App\\Models\\Product',12,'c6f76228-e8d9-403f-91e0-d33da64de0c0','ck-media','4G NBIoT_GSM modem','4G-NBIoT_GSM-modem.jpg','image/jpeg','public','public',230466,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',70,'2021-07-26 03:12:56','2021-07-26 03:12:56'),(71,'App\\Models\\Product',1,'47ea72fe-2b90-4f49-8c79-c5beed2cd690','ck-media','INTELLI NB-IoT','INTELLI-NB-IoT.jpg','image/jpeg','public','public',260095,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',71,'2021-07-26 03:14:01','2021-07-26 03:14:01'),(72,'App\\Models\\Product',1,'b8a88b73-cd2f-4e86-b4c0-e837f030a935','ck-media','INTELLI NB-IoT_2','INTELLI-NB-IoT_2.jpg','image/jpeg','public','public',370674,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',72,'2021-07-26 03:14:26','2021-07-26 03:14:26'),(73,'App\\Models\\Product',1,'fdc6a2fe-b2c7-4a29-83d5-b5c6a7883d52','ck-media','INTELLI NB-IoT','INTELLI-NB-IoT.jpg','image/jpeg','public','public',260095,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',73,'2021-07-26 03:14:52','2021-07-26 03:14:52'),(74,'App\\Models\\Product',1,'2910dfac-c3d5-4a10-b8e8-76e58fe8f031','ck-media','INTELLI NB-IoT_2','INTELLI-NB-IoT_2.jpg','image/jpeg','public','public',370674,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',74,'2021-07-26 03:14:53','2021-07-26 03:14:53'),(75,'App\\Models\\Product',2,'feeee6a8-bc4a-4218-9c36-e7556baa4b4e','ck-media','Intellilora','Intellilora.jpg','image/jpeg','public','public',378382,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',75,'2021-07-26 03:16:12','2021-07-26 03:16:13'),(76,'App\\Models\\Product',3,'0a42a0de-c371-4371-a66c-f6df9d9596ca','ck-media','Intelli WiBLE','Intelli-WiBLE.jpg','image/jpeg','public','public',270107,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',76,'2021-07-26 03:19:32','2021-07-26 03:19:33'),(77,'App\\Models\\Product',4,'3f342e5c-9d6e-42bc-8ae4-bbb19ac85f3f','ck-media','Smart Street Lamp Nema','Smart-Street-Lamp-Nema.jpg','image/jpeg','public','public',264336,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',77,'2021-07-26 03:20:36','2021-07-26 03:20:36'),(78,'App\\Models\\Product',4,'42cd658c-9299-4cf7-8f01-30a295804767','ck-media','Smart Street Lamp Nema','Smart-Street-Lamp-Nema.jpg','image/jpeg','public','public',264336,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',78,'2021-07-26 03:20:50','2021-07-26 03:20:50'),(79,'App\\Models\\Product',4,'65366212-daca-4341-afee-284cbb691853','ck-media','Nema Adapter','Nema-Adapter.jpg','image/jpeg','public','public',251244,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',79,'2021-07-26 03:21:27','2021-07-26 03:21:28'),(80,'App\\Models\\Product',4,'eb27ba25-25d8-4acf-9e22-ccee6f7a8d1c','ck-media','Smart Street Lamp Nema','Smart-Street-Lamp-Nema.jpg','image/jpeg','public','public',264336,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',80,'2021-07-26 03:21:28','2021-07-26 03:21:29'),(81,'App\\Models\\Product',4,'87e3ac54-2f30-4b7e-93b3-b4c4bd2a4ce1','ck-media','Nema Adapter','Nema-Adapter.jpg','image/jpeg','public','public',251244,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',81,'2021-07-26 03:22:13','2021-07-26 03:22:14'),(82,'App\\Models\\Product',4,'68b9dbd1-d55f-40b2-84ce-264c907485b1','ck-media','Smart Street Lamp Nema','Smart-Street-Lamp-Nema.jpg','image/jpeg','public','public',264336,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',82,'2021-07-26 03:22:14','2021-07-26 03:22:15'),(83,'App\\Models\\Product',6,'5c960810-646e-43c8-8ecf-7b51a487a61a','ck-media','Batching Plant Base Controller','Batching-Plant-Base-Controller.jpg','image/jpeg','public','public',399672,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',83,'2021-07-26 03:23:41','2021-07-26 03:23:41'),(84,'App\\Models\\Product',7,'a9cc907c-9c9c-4542-a7ec-4d0e9f4ee6b7','ck-media','Industrial e-Controller','Industrial-e-Controller.jpg','image/jpeg','public','public',344916,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',84,'2021-07-26 03:25:11','2021-07-26 03:25:11'),(85,'App\\Models\\Product',17,'beeb4453-24fc-4e08-9b4f-913335f0f82d','ck-media','Rugged RFID Tag','Rugged-RFID-Tag.jpg','image/jpeg','public','public',244288,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',85,'2021-07-26 03:30:08','2021-07-26 03:30:08'),(86,'App\\Models\\Product',11,'dc40f39e-8679-4e1d-92a3-d01246046c27','ck-media','Smart Water Meter','Smart-Water-Meter.jpg','image/jpeg','public','public',218133,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',86,'2021-07-26 03:43:57','2021-07-26 03:43:57'),(87,'App\\Models\\Product',16,'dc4ef876-3850-4613-b164-decce2c52304','ck-media','Fuel Tracking','Fuel-Tracking.jpg','image/jpeg','public','public',241335,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',87,'2021-07-28 07:35:56','2021-07-28 07:35:57'),(88,'App\\Models\\Product',15,'5c687233-4859-4197-a7d5-e79e8535cdd7','ck-media','GPS Tracking','GPS-Tracking.jpg','image/jpeg','public','public',218261,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',88,'2021-07-28 07:36:19','2021-07-28 07:36:19'),(89,'App\\Models\\Product',14,'9fb20ad2-8330-42ed-a3a0-05b56617e630','ck-media','FID Reade Handheld','FID-Reade-Handheld.jpg','image/jpeg','public','public',213251,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',89,'2021-07-28 07:36:44','2021-07-28 07:36:44'),(90,'App\\Models\\Product',14,'18f50b59-c5d8-4f79-8dd3-ece28b94618d','ck-media','FID Reader Fixed','FID-Reader-Fixed.jpg','image/jpeg','public','public',217063,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',90,'2021-07-28 07:36:45','2021-07-28 07:36:45'),(91,'App\\Models\\Product',13,'2cae7a62-4ffd-43ab-b8f8-8c9d6ce3d7ac','ck-media','SmartLocker','SmartLocker.jpg','image/jpeg','public','public',263880,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',91,'2021-07-28 07:37:04','2021-07-28 07:37:04'),(92,'App\\Models\\Product',10,'76600ce9-318a-4714-9763-ff88ee0f9ba5','ck-media','Water Qualty Sensor','Water-Qualty-Sensor.jpg','image/jpeg','public','public',233267,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',92,'2021-07-28 07:39:58','2021-07-28 07:39:58'),(93,'App\\Models\\Product',4,'a045bfe1-f3fb-43db-98e8-9ab893e90b47','ck-media','Smart Lamp_1','Smart-Lamp_1.jpg','image/jpeg','public','public',249707,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',93,'2021-07-28 07:40:51','2021-07-28 07:40:51'),(94,'App\\Models\\Product',4,'976b5d37-86d3-48b8-8cb4-4c68097364e6','ck-media','Smart Lamp_3','Smart-Lamp_3.jpg','image/jpeg','public','public',208313,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',94,'2021-07-28 07:40:52','2021-07-28 07:40:53'),(95,'App\\Models\\Product',4,'9c017368-ea1d-4265-a3af-fa7bc1838df8','ck-media','Smart Lamp_2','Smart-Lamp_2.jpg','image/jpeg','public','public',200756,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',95,'2021-07-28 07:40:53','2021-07-28 07:40:53'),(96,'App\\Models\\Product',8,'8748de37-0126-44af-8442-842cdcbc8c5a','ck-media','Batching Plant Base Controller','Batching-Plant-Base-Controller.jpg','image/jpeg','public','public',399672,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',96,'2021-07-29 09:06:03','2021-07-29 09:06:03'),(97,'App\\Models\\Usecase',8,'630a90e6-bfeb-422d-889e-2d5a2def7d9f','ck-media','Picture2','Picture2.png','image/png','public','public',589121,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',97,'2021-08-04 08:21:38','2021-08-04 08:26:40'),(98,'App\\Models\\Usecase',8,'0ee38fbb-6ec8-4d4c-a891-9d97d8745976','ck-media','Picture2','Picture2.png','image/png','public','public',589121,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',98,'2021-08-04 08:22:52','2021-08-04 08:26:40'),(99,'App\\Models\\Usecase',8,'659e7033-60cd-40e7-a2ff-b4dafcb52f79','featured_image','6109eb20f1e71_Picture1','6109eb20f1e71_Picture1.jpg','image/jpeg','public','public',33134,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',99,'2021-08-04 08:26:40','2021-08-04 08:26:40'),(101,'App\\Models\\Product',17,'6ad25755-f2b7-4582-bee0-38a1cfa364a4','featured_image','610a359a0c524_Rugged RFID Tag','610a359a0c524_Rugged-RFID-Tag.jpg','image/jpeg','public','public',244288,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',101,'2021-08-04 13:37:18','2021-08-04 13:37:19'),(102,'App\\Models\\Product',16,'e3fb5a09-3082-4d6a-b456-622e57246617','featured_image','610a35f3c75e1_Fuel Tracking','610a35f3c75e1_Fuel-Tracking.jpg','image/jpeg','public','public',241335,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',102,'2021-08-04 13:38:46','2021-08-04 13:38:46'),(103,'App\\Models\\Product',15,'f8cfdf2d-1905-44b3-a8f4-dbc43d638489','featured_image','610a3607c8330_GPS Tracking','610a3607c8330_GPS-Tracking.jpg','image/jpeg','public','public',218261,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',103,'2021-08-04 13:39:06','2021-08-04 13:39:06'),(104,'App\\Models\\Product',14,'30d5d4bb-5abc-4ae6-b1ae-f9365cfa4e4d','featured_image','610a3630ed313_FID Reader Fixed','610a3630ed313_FID-Reader-Fixed.jpg','image/jpeg','public','public',217063,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',104,'2021-08-04 13:39:50','2021-08-04 13:39:50'),(105,'App\\Models\\Product',13,'aaa28e11-4ba9-47b9-9e6a-ea14321f09d7','featured_image','610a366a2a6d4_SmartLocker','610a366a2a6d4_SmartLocker.jpg','image/jpeg','public','public',263880,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',105,'2021-08-04 13:40:45','2021-08-04 13:40:45'),(106,'App\\Models\\Product',12,'71600f56-8679-4e08-8831-ce92d024386c','featured_image','610a38578ef1a_4G NBIoT_GSM modem','610a38578ef1a_4G-NBIoT_GSM-modem.jpg','image/jpeg','public','public',230466,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',106,'2021-08-04 13:48:59','2021-08-04 13:48:59'),(107,'App\\Models\\Product',11,'b6dfb021-4c5d-4ba8-8f20-b7a7a548d116','featured_image','610a386f00c65_Smart Water Meter','610a386f00c65_Smart-Water-Meter.jpg','image/jpeg','public','public',218133,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',107,'2021-08-04 13:49:22','2021-08-04 13:49:23'),(108,'App\\Models\\Product',10,'8c73ae9f-919c-4fe0-9bf0-8a61d49e39b6','featured_image','610a3882904ca_Water Qualty Sensor','610a3882904ca_Water-Qualty-Sensor.jpg','image/jpeg','public','public',233267,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',108,'2021-08-04 13:49:41','2021-08-04 13:49:41'),(109,'App\\Models\\Product',8,'cfb845ab-bb04-488d-b730-8f5a15df3a23','featured_image','610a3898471fc_Batching Plant Base Controller','610a3898471fc_Batching-Plant-Base-Controller.jpg','image/jpeg','public','public',399672,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',109,'2021-08-04 13:50:03','2021-08-04 13:50:03'),(110,'App\\Models\\Product',1,'0e239949-11d6-4d3a-ad87-85e4468da94c','featured_image','610a39317f3cf_INTELLI NB-IoT','610a39317f3cf_INTELLI-NB-IoT.jpg','image/jpeg','public','public',260095,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',110,'2021-08-04 13:52:36','2021-08-04 13:52:36'),(111,'App\\Models\\Product',2,'a4984432-a68f-4f8c-99f1-e9046ff2cb2d','featured_image','610a42febfe68_Intellilora','610a42febfe68_Intellilora.jpg','image/jpeg','public','public',378382,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',111,'2021-08-04 14:34:25','2021-08-04 14:34:26'),(113,'App\\Models\\Product',3,'11aa97f6-9561-4260-bdaa-797d12d2947f','featured_image','610a4342ef186_Intelli WiBLE','610a4342ef186_Intelli-WiBLE.jpg','image/jpeg','public','public',270107,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',112,'2021-08-04 14:35:33','2021-08-04 14:35:34'),(115,'App\\Models\\Product',5,'fc81adc5-c866-43c9-9cb7-2ae54b404933','featured_image','610a61a720571_Energy Meter','610a61a720571_Energy-Meter.jpg','image/jpeg','public','public',253344,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',114,'2021-08-04 16:45:14','2021-08-04 16:45:14'),(116,'App\\Models\\Product',0,'cffb9920-c2b9-4fcf-be40-6b67575fc1c6','ck-media','Bikesharing Controller','Bikesharing-Controller.jpg','image/jpeg','public','public',374046,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',115,'2021-08-31 16:22:05','2021-08-31 16:22:05'),(117,'App\\Models\\Product',0,'5e940920-9ee9-4d43-a4e3-a7a3885f5b32','ck-media','Smart Agriculture','Smart-Agriculture.jpg','image/jpeg','public','public',412846,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',116,'2021-08-31 16:28:55','2021-08-31 16:28:55'),(118,'App\\Models\\Product',0,'32a3ef7c-ac39-4b72-afeb-618257bebb53','ck-media','Smart Agriculture','Smart-Agriculture.jpg','image/jpeg','public','public',412846,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',117,'2021-08-31 16:31:34','2021-08-31 16:31:34'),(119,'App\\Models\\Product',0,'7413de4f-2160-43df-af5a-9036ebef875d','ck-media','PCB_Smart_Agriculture','PCB_Smart_Agriculture.jpg','image/jpeg','public','public',375855,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',118,'2021-08-31 16:56:18','2021-08-31 16:56:18'),(120,'App\\Models\\Product',0,'cb8d57fa-49f6-433c-a6d5-b5f1deac2b66','ck-media','PCB_Smart_Agriculture','PCB_Smart_Agriculture.jpg','image/jpeg','public','public',375855,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',119,'2021-08-31 16:59:14','2021-08-31 16:59:14'),(121,'App\\Models\\Product',0,'6bc8e0a0-4157-4a26-8a52-b2756ca221e2','ck-media','Smart Agriculture','Smart-Agriculture.jpg','image/jpeg','public','public',412846,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',120,'2021-08-31 16:59:15','2021-08-31 16:59:15'),(122,'App\\Models\\Product',0,'fc969dc9-c91a-411a-9c18-cfe85456ed23','ck-media','Bikeshare Pico','Bikeshare-Pico.jpg','image/jpeg','public','public',355147,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',121,'2021-09-01 10:06:06','2021-09-01 10:06:06'),(123,'App\\Models\\Product',0,'b6be820f-7c3c-4f47-9997-691f4438bdd8','ck-media','Bikeshare Pico','Bikeshare-Pico.jpg','image/jpeg','public','public',355147,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',122,'2021-09-01 10:06:52','2021-09-01 10:06:52'),(124,'App\\Models\\Product',18,'49dd3fa0-440e-40ef-9d13-dced23082440','featured_image','612eeeb489334_Bikeshare Pico','612eeeb489334_Bikeshare-Pico.jpg','image/jpeg','public','public',355147,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',123,'2021-09-01 10:08:50','2021-09-01 10:08:50'),(125,'App\\Models\\Product',0,'b49be05b-4192-4522-b480-12af9e565d49','ck-media','Bikeshare Controller','Bikeshare-Controller.jpg','image/jpeg','public','public',256286,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',124,'2021-09-01 10:11:44','2021-09-01 10:11:44'),(126,'App\\Models\\Product',19,'db26bbbd-f3e1-4381-8011-416021ab994c','featured_image','612eefc7c9477_Bikeshare Controller','612eefc7c9477_Bikeshare-Controller.jpg','image/jpeg','public','public',256286,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',125,'2021-09-01 10:13:14','2021-09-01 10:13:14'),(127,'App\\Models\\Product',20,'221d089e-2b3e-4eff-af4e-8e8713a8059e','ck-media','Bikesharing Controller','Bikesharing-Controller.jpg','image/jpeg','public','public',374046,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',126,'2021-09-01 10:15:21','2021-09-01 10:15:36'),(128,'App\\Models\\Product',20,'698ae033-5a9f-468d-b4f3-d66912cce73e','featured_image','612eeff9305bc_Bikesharing Controller','612eeff9305bc_Bikesharing-Controller.jpg','image/jpeg','public','public',374046,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',127,'2021-09-01 10:15:35','2021-09-01 10:15:36'),(129,'App\\Models\\Product',4,'c978be66-3d49-427d-96e9-6c2111c347e1','featured_image','612ef0afefdff_Smart Street Lamp Nema','612ef0afefdff_Smart-Street-Lamp-Nema.jpg','image/jpeg','public','public',264336,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',128,'2021-09-01 10:17:20','2021-09-01 10:17:20'),(130,'App\\Models\\Product',21,'e2f13573-bba9-4fd7-bd7a-ec2606bde190','ck-media','Bikeshare Docking Board','Bikeshare-Docking-Board.jpg','image/jpeg','public','public',331523,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',129,'2021-09-01 10:18:37','2021-09-01 10:18:50'),(131,'App\\Models\\Product',21,'a3d66e01-a44d-4ebc-8de7-9ff13a8cbba3','featured_image','612ef0fd0a9bd_Bikeshare Docking Board','612ef0fd0a9bd_Bikeshare-Docking-Board.jpg','image/jpeg','public','public',331523,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',130,'2021-09-01 10:18:50','2021-09-01 10:18:50'),(132,'App\\Models\\Product',23,'d6b8120d-1468-496c-b7fa-24ea22a130c9','featured_image','612ef14e1dc77_Bikeshare Docking Board','612ef14e1dc77_Bikeshare-Docking-Board.jpg','image/jpeg','public','public',331523,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',131,'2021-09-01 10:19:46','2021-09-01 10:19:46'),(133,'App\\Models\\Product',24,'de7e3a39-70fd-4a81-b5ef-beb2e2fbc249','ck-media','PCB_Smart_Agriculture','PCB_Smart_Agriculture.jpg','image/jpeg','public','public',375855,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',132,'2021-09-01 10:21:28','2021-09-01 10:21:40'),(134,'App\\Models\\Product',24,'6f6ce416-1847-4722-af5f-2466c201f587','ck-media','Smart Agriculture','Smart-Agriculture.jpg','image/jpeg','public','public',412846,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',133,'2021-09-01 10:21:29','2021-09-01 10:21:40'),(135,'App\\Models\\Product',24,'a992f9f9-33f9-4646-95b2-7fd4df4a4865','featured_image','612ef196baed8_Smart Agriculture','612ef196baed8_Smart-Agriculture.jpg','image/jpeg','public','public',412846,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',134,'2021-09-01 10:21:40','2021-09-01 10:21:40'),(136,'App\\Models\\Product',7,'17a44525-ac5f-4b80-848f-1db883210805','featured_image','612ef21cade47_Industrial e-Controller','612ef21cade47_Industrial-e-Controller.jpg','image/jpeg','public','public',344916,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',135,'2021-09-01 10:23:24','2021-09-01 10:23:24'),(137,'App\\Models\\Product',25,'4afa607a-bc02-414e-ba5b-0acde2d0d05a','ck-media','TV Measurment COntroller','TV-Measurment-COntroller.jpg','image/jpeg','public','public',394540,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',136,'2021-09-01 10:25:13','2021-09-01 10:25:29'),(138,'App\\Models\\Product',25,'82029a05-6d21-4307-874c-d74bec78cd1a','featured_image','612ef280a1ecc_TV Measurment COntroller','612ef280a1ecc_TV-Measurment-COntroller.jpg','image/jpeg','public','public',394540,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',137,'2021-09-01 10:25:29','2021-09-01 10:25:29'),(139,'App\\Models\\Product',26,'ef330827-d6e5-42cd-af56-9570948ebd5d','ck-media','Eltres_2','Eltres_2.jpg','image/jpeg','public','public',248691,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',138,'2021-09-02 15:35:35','2021-09-02 15:35:47'),(140,'App\\Models\\Product',26,'74e21b85-be45-4f5b-af61-cfc1ac0abad1','ck-media','Eltres_1','Eltres_1.jpg','image/jpeg','public','public',341180,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',139,'2021-09-02 15:35:36','2021-09-02 15:35:47'),(141,'App\\Models\\Product',26,'a8485b61-c51a-438b-a038-118c966883aa','featured_image','61308cc116c4c_Eltres_3','61308cc116c4c_Eltres_3.jpg','image/jpeg','public','public',402970,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',140,'2021-09-02 15:35:47','2021-09-02 15:35:47'),(142,'App\\Models\\Product',32,'6ecb2a7a-a4ce-4d7c-83fb-73c96bffc1d6','featured_image','6149438e2d992_Socket NEMA 7 PIN','6149438e2d992_Socket-NEMA-7-PIN.jpg','image/jpeg','public','public',45078,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',141,'2021-09-21 09:31:09','2021-09-21 09:31:09'),(143,'App\\Models\\Usecase',9,'2682292f-fe5f-4d19-beb7-8365ed68bb0e','featured_image','61727af6c91bd_Example-of-Building-Management-System-BMS','61727af6c91bd_Example-of-Building-Management-System-BMS.png','image/jpeg','public','public',54272,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',142,'2021-10-22 15:49:04','2021-10-22 15:49:04'),(144,'App\\Models\\Usecase',9,'9e535f00-3166-4162-9e4d-5edc8e42491a','ck-media','Building Monitoring Systems','Building-Monitoring-Systems.png','image/jpeg','public','public',54272,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',143,'2021-10-22 15:54:07','2021-10-22 15:54:07'),(145,'App\\Models\\Usecase',0,'3fad9bec-fc4a-4478-bc08-f8b4cea9bf6e','ck-media','automated-hydroponics','automated-hydroponics.jpg','image/jpeg','public','public',1521692,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',144,'2021-11-10 10:08:16','2021-11-10 10:08:17'),(146,'App\\Models\\Usecase',10,'fb1b5560-805f-45cc-b204-a3c5033a854f','featured_image','618b38c8312ca_photo_2021-11-10_09-47-17','618b38c8312ca_photo_2021-11-10_09-47-17.jpg','image/jpeg','public','public',144337,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',145,'2021-11-10 10:13:26','2021-11-10 10:13:26'),(147,'App\\Models\\Usecase',10,'95535b66-8549-45c8-ab1d-ce50f6bdd244','ck-media','automated-hydroponics system','automated-hydroponics-system.jpg','image/jpeg','public','public',649811,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',146,'2021-11-10 10:16:13','2021-11-10 10:16:13'),(148,'App\\Models\\Usecase',10,'492cb383-a3b4-4047-8035-65f3a51de2ad','ck-media','photo_2021-11-10_09-47-17','photo_2021-11-10_09-47-17.jpg','image/jpeg','public','public',144337,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',147,'2021-11-10 10:16:23','2021-11-10 10:16:23'),(149,'App\\Models\\Usecase',10,'d89e3bc4-2313-4e5f-8608-5a7acdd22240','ck-media','Sistem Otomasi Hidroponik','Sistem-Otomasi-Hidroponik.jpg','image/jpeg','public','public',71037,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',148,'2021-11-10 10:22:16','2021-11-10 10:22:17'),(150,'App\\Models\\UsecaseCategory',5,'82e623dc-6584-4a38-81b9-4bc5e5ec70a1','image','618b407dd8a7f_Smart-Home-Technology','618b407dd8a7f_Smart-Home-Technology.jpg','image/jpeg','public','public',275408,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',149,'2021-11-10 10:46:15','2021-11-10 10:46:15'),(151,'App\\Models\\Usecase',11,'32992a66-c2ed-459b-bf3c-183dafdeb5e6','ck-media','Smart Traffic Control','Smart-Traffic-Control.jpg','image/jpeg','public','public',267933,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',150,'2021-11-10 10:49:33','2021-11-10 10:56:45'),(152,'App\\Models\\Usecase',11,'57d51548-c1e1-4816-88ec-d39ac1ae2525','ck-media','smart_traffic_control','smart_traffic_control.jpg','image/jpeg','public','public',86666,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',151,'2021-11-10 10:56:11','2021-11-10 10:56:45'),(153,'App\\Models\\Usecase',11,'78d1498c-54a2-4fac-9431-3bd4c7cad224','featured_image','618b413c0d2b1_Smart Traffic Control','618b413c0d2b1_Smart-Traffic-Control.jpg','image/jpeg','public','public',267933,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',152,'2021-11-10 10:56:45','2021-11-10 10:56:45'),(154,'App\\Models\\Usecase',0,'075173ea-5472-4733-976c-ab8be718c4d7','ck-media','agricultural drone','agricultural-drone.jpg','image/jpeg','public','public',47140,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',153,'2021-11-10 11:17:28','2021-11-10 11:17:28'),(155,'App\\Models\\Usecase',0,'b9e97fbd-cf75-4dd8-97a3-9f89d3686a9a','ck-media','drone-imagery','drone-imagery.jpg','image/jpeg','public','public',233601,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',154,'2021-11-10 11:25:11','2021-11-10 11:25:12'),(156,'App\\Models\\Usecase',12,'14a99550-6a43-4874-9b96-246d1a138c99','featured_image','618b49c441c87_agricultural drone','618b49c441c87_agricultural-drone.jpg','image/jpeg','public','public',47140,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',155,'2021-11-10 11:25:42','2021-11-10 11:25:43'),(157,'App\\Models\\Usecase',2,'f2c593b4-684c-4c78-a7b7-1b457b42d96a','ck-media','smart-farm','smart-farm.jpg','image/jpeg','public','public',262666,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',156,'2021-11-10 11:43:57','2021-11-10 11:43:57'),(158,'App\\Models\\Usecase',13,'4a669f5e-76fa-44d7-b17f-5fb9e82eca8b','featured_image','618b5242e8afa_Efficient-waste-management-in-Smart-Cities','618b5242e8afa_Efficient-waste-management-in-Smart-Cities.png','image/png','public','public',92323,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',157,'2021-11-10 12:02:02','2021-11-10 12:02:03'),(159,'App\\Models\\Usecase',14,'6cc0024c-ae44-4aa1-8b27-81c1e539671f','ck-media','smart-home-automation','smart-home-automation.jpg','image/jpeg','public','public',127413,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',158,'2021-11-10 12:36:05','2021-11-10 12:36:30'),(160,'App\\Models\\Usecase',14,'29a2be1c-efa7-4ff1-8d79-a2de7fea9602','featured_image','618b5a42d5f50_smart-home-automation','618b5a42d5f50_smart-home-automation.jpg','image/jpeg','public','public',127413,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',159,'2021-11-10 12:36:30','2021-11-10 12:36:30'),(161,'App\\Models\\Usecase',15,'83bff353-317d-4a56-8929-63f6027ee277','ck-media','Smart-Lamp_1','Smart-Lamp_1.jpg','image/jpeg','public','public',249707,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',160,'2021-11-10 12:41:14','2021-11-10 12:41:30'),(162,'App\\Models\\Usecase',15,'ca51138c-ea96-4bc3-a4f1-c9eb78a27f4c','featured_image','618b5afb27210_Smart-Lamp_1','618b5afb27210_Smart-Lamp_1.jpg','image/jpeg','public','public',249707,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',161,'2021-11-10 12:41:30','2021-11-10 12:41:30'),(163,'App\\Models\\Usecase',16,'fa7ce081-5ca3-44a6-983d-e1ac2249bc0d','ck-media','Smart-Water-Management','Smart-Water-Management.png','image/png','public','public',60428,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',162,'2021-11-10 12:58:33','2021-11-10 12:58:38'),(164,'App\\Models\\Usecase',16,'ecdddfa2-174f-440e-9e7e-062ce0e5b404','featured_image','618b5f8506cf2_Smart-Water-Management','618b5f8506cf2_Smart-Water-Management.png','image/png','public','public',60428,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',163,'2021-11-10 12:58:38','2021-11-10 12:58:38'),(165,'App\\Models\\UsecaseCategory',6,'c8e9eb6e-d6fd-4506-9f0e-610ddf497c2a','image','618b6a977994d_smart-villages','618b6a977994d_smart-villages.jpg','image/jpeg','public','public',310336,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',164,'2021-11-10 13:45:45','2021-11-10 13:45:46'),(166,'App\\Models\\Usecase',17,'9937ca46-b8ec-4896-978f-5112e8fd4db6','ck-media','moisture-based-irrigation-system (2)','moisture-based-irrigation-system-(2).jpg','image/jpeg','public','public',65021,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',165,'2021-11-11 10:12:00','2021-11-11 10:12:36'),(167,'App\\Models\\Usecase',17,'5fbdfc80-2615-4631-9e72-23c209ffacff','ck-media','weather-based-irrigation-syste,','weather-based-irrigation-syste,.jpg','image/jpeg','public','public',48077,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',166,'2021-11-11 10:12:10','2021-11-11 10:12:36'),(168,'App\\Models\\Usecase',17,'9ff50171-3c9c-4996-b9ca-3297e3092e85','featured_image','618c8833962a1_weather-based-irrigation-system','618c8833962a1_weather-based-irrigation-system.jpg','image/jpeg','public','public',48077,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',167,'2021-11-11 10:12:36','2021-11-11 10:12:36'),(169,'App\\Models\\Usecase',18,'fbe7315c-a9e1-4085-859b-7524b34a71c3','ck-media','integrated-farming-system','integrated-farming-system.jpg','image/jpeg','public','public',66781,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',168,'2021-11-11 14:16:34','2021-11-11 14:18:38'),(170,'App\\Models\\Usecase',18,'16cf4167-a101-4308-8c9e-ae792ec567fa','ck-media','rsz_integrated-farming-system','rsz_integrated-farming-system.jpg','image/jpeg','public','public',31924,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',169,'2021-11-11 14:17:21','2021-11-11 14:18:38'),(171,'App\\Models\\Usecase',18,'913ca215-3455-4b1e-8e31-60edc14c932b','ck-media','integrated-farming-system','integrated-farming-system.gif','image/gif','public','public',15138,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',170,'2021-11-11 14:17:45','2021-11-11 14:18:38'),(172,'App\\Models\\Usecase',18,'77187e64-da82-430b-a8f8-144fe2df38d2','ck-media','integrated-farming-system','integrated-farming-system.gif','image/gif','public','public',15138,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',171,'2021-11-11 14:18:12','2021-11-11 14:18:38'),(173,'App\\Models\\Usecase',18,'05aa88d8-2bc6-4b6a-a8b2-e71ba4718f8d','featured_image','618cc25d03cc7_integrated-farming-system','618cc25d03cc7_integrated-farming-system.jpg','image/jpeg','public','public',66781,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',172,'2021-11-11 14:18:38','2021-11-11 14:18:38'),(174,'App\\Models\\Product',34,'e9a855dd-8238-4baf-ac15-b9d48ba1cbdf','featured_image','620b56ae7f908_Light Contoller_1','620b56ae7f908_Light-Contoller_1.jpg','image/jpeg','public','public',381385,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',173,'2022-02-15 14:31:04','2022-02-15 14:31:05'),(175,'App\\Models\\Product',33,'9740b7ac-751f-4b9e-9996-5a02e287bad1','ck-media','Blank diagram','Blank-diagram.png','image/png','public','public',25389,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',174,'2022-02-15 14:34:40','2022-02-15 14:34:40'),(176,'App\\Models\\Product',34,'0b3de73b-d442-47f8-a267-30a47eef906c','ck-media','Light Contoller_1','Light-Contoller_1.jpg','image/jpeg','public','public',381385,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',175,'2022-02-15 14:35:01','2022-02-15 14:35:02'),(177,'App\\Models\\Product',34,'39c8512c-29ca-4f1c-b7a0-949783491eee','ck-media','Light Contoller_2','Light-Contoller_2.jpg','image/jpeg','public','public',326706,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',176,'2022-02-15 14:35:12','2022-02-15 14:35:12'),(178,'App\\Models\\Product',33,'9252f78e-e5d6-491e-80d2-42d455350dd4','ck-media','photo1643776119','photo1643776119.jpeg','image/jpeg','public','public',56343,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',177,'2022-02-15 14:38:16','2022-02-15 14:38:16'),(179,'App\\Models\\Product',33,'de76e8e1-2044-4a05-9e4a-05567345ae55','ck-media','Screenshot (22)','Screenshot-(22).png','image/png','public','public',4727,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',178,'2022-02-15 14:42:13','2022-02-15 14:42:13'),(180,'App\\Models\\Product',33,'48304f65-695b-4535-ad8d-b6878e15ecce','featured_image','620b595181574_Blank diagram','620b595181574_Blank-diagram.png','image/png','public','public',25389,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',179,'2022-02-15 14:42:15','2022-02-15 14:42:15'),(181,'App\\Models\\Product',34,'7ceadab9-ea78-45c3-b777-3c73ef36d069','ck-media','Light Contoller_1','Light-Contoller_1.jpg','image/jpeg','public','public',381385,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',180,'2022-02-15 14:42:49','2022-02-15 14:42:49'),(182,'App\\Models\\Product',34,'89bb7c69-8752-4444-a42b-975083a73292','ck-media','Light Contoller_2','Light-Contoller_2.jpg','image/jpeg','public','public',326706,'[]','{\"generated_conversions\": {\"thumb\": true, \"preview\": true}}','[]',181,'2022-02-15 14:42:50','2022-02-15 14:42:50');

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

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

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

INSERT INTO `migrations` VALUES (1,'2014_10_12_100000_create_password_resets_table',1),(2,'2019_12_14_000001_create_personal_access_tokens_table',1),(3,'2021_06_24_000001_create_media_table',1),(4,'2021_06_24_000002_create_audit_logs_table',1),(5,'2021_06_24_000003_create_tags_table',1),(6,'2021_06_24_000004_create_orders_table',1),(7,'2021_06_24_000005_create_carts_table',1),(8,'2021_06_24_000006_create_capabilities_table',1),(9,'2021_06_24_000007_create_capability_categories_table',1),(10,'2021_06_24_000008_create_usecases_table',1),(11,'2021_06_24_000009_create_usecase_categories_table',1),(12,'2021_06_24_000010_create_news_table',1),(13,'2021_06_24_000011_create_products_table',1),(14,'2021_06_24_000012_create_resources_table',1),(15,'2021_06_24_000013_create_news_categories_table',1),(16,'2021_06_24_000014_create_resource_categories_table',1),(17,'2021_06_24_000015_create_product_categories_table',1),(18,'2021_06_24_000016_create_permissions_table',1),(19,'2021_06_24_000017_create_provinces_table',1),(20,'2021_06_24_000018_create_roles_table',1),(21,'2021_06_24_000019_create_cities_table',1),(22,'2021_06_24_000020_create_districts_table',1),(23,'2021_06_24_000021_create_users_table',1),(24,'2021_06_24_000022_create_villages_table',1),(25,'2021_06_24_000023_create_order_product_pivot_table',1),(26,'2021_06_24_000024_create_capability_tag_pivot_table',1),(27,'2021_06_24_000025_create_capability_resource_pivot_table',1),(28,'2021_06_24_000026_create_permission_role_pivot_table',1),(29,'2021_06_24_000027_create_tag_usecase_pivot_table',1),(30,'2021_06_24_000028_create_resource_usecase_pivot_table',1),(31,'2021_06_24_000029_create_role_user_pivot_table',1),(32,'2021_06_24_000030_create_news_tag_pivot_table',1),(33,'2021_06_24_000031_create_news_resource_pivot_table',1),(34,'2021_06_24_000032_create_product_tag_pivot_table',1),(35,'2021_06_24_000033_create_product_resource_pivot_table',1),(36,'2021_06_24_000034_create_resource_tag_pivot_table',1),(37,'2021_06_24_000035_add_relationship_fields_to_news_table',1),(38,'2021_06_24_000036_add_relationship_fields_to_usecases_table',1),(39,'2021_06_24_000037_add_relationship_fields_to_products_table',1),(40,'2021_06_24_000038_add_relationship_fields_to_capabilities_table',1),(41,'2021_06_24_000039_add_relationship_fields_to_carts_table',1),(42,'2021_06_24_000040_add_relationship_fields_to_resources_table',1),(43,'2021_06_24_000041_add_relationship_fields_to_orders_table',1),(44,'2021_06_24_000042_add_verification_fields',1),(45,'2021_06_24_000043_create_qa_topics_table',1),(46,'2021_06_24_000044_create_qa_messages_table',1),(47,'2021_08_09_093411_create_inquiries_table',2),(48,'2021_08_09_094407_create_complaints_table',3);

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `excerpt` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `veiwed` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `category_id` bigint(20) unsigned NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `category_fk_4236704` (`category_id`),
  CONSTRAINT `category_fk_4236704` FOREIGN KEY (`category_id`) REFERENCES `news_categories` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `news`
--


--
-- Table structure for table `news_categories`
--

CREATE TABLE `news_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `news_categories_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `news_categories`
--


--
-- Table structure for table `news_resource`
--

CREATE TABLE `news_resource` (
  `news_id` bigint(20) unsigned NOT NULL,
  `resource_id` bigint(20) unsigned NOT NULL,
  KEY `news_id_fk_4236709` (`news_id`),
  KEY `resource_id_fk_4236709` (`resource_id`),
  CONSTRAINT `news_id_fk_4236709` FOREIGN KEY (`news_id`) REFERENCES `news` (`id`) ON DELETE CASCADE,
  CONSTRAINT `resource_id_fk_4236709` FOREIGN KEY (`resource_id`) REFERENCES `resources` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `news_resource`
--


--
-- Table structure for table `news_tag`
--

CREATE TABLE `news_tag` (
  `news_id` bigint(20) unsigned NOT NULL,
  `tag_id` bigint(20) unsigned NOT NULL,
  KEY `news_id_fk_4236710` (`news_id`),
  KEY `tag_id_fk_4236710` (`tag_id`),
  CONSTRAINT `news_id_fk_4236710` FOREIGN KEY (`news_id`) REFERENCES `news` (`id`) ON DELETE CASCADE,
  CONSTRAINT `tag_id_fk_4236710` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `news_tag`
--


--
-- Table structure for table `order_product`
--

CREATE TABLE `order_product` (
  `order_id` bigint(20) unsigned NOT NULL,
  `product_id` bigint(20) unsigned NOT NULL,
  KEY `order_id_fk_4236756` (`order_id`),
  KEY `product_id_fk_4236756` (`product_id`),
  CONSTRAINT `order_id_fk_4236756` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `product_id_fk_4236756` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_product`
--

INSERT INTO `order_product` VALUES (1,3),(2,3),(3,1),(4,3),(5,3),(5,1),(1,3),(2,3),(3,1),(4,3),(5,3),(5,1);

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `attributes` longtext COLLATE utf8mb4_unicode_ci,
  `deadline` date DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `user_uuid` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `orders_code_unique` (`code`),
  KEY `user_fk_4236751` (`user_id`),
  CONSTRAINT `user_fk_4236751` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` VALUES (1,'210730030158',NULL,NULL,'open','2021-07-30 15:01:58','2021-07-30 15:01:58',NULL,1,NULL),(2,'210802111657',NULL,NULL,'open','2021-08-02 11:16:57','2021-08-02 11:16:57',NULL,1,NULL),(3,'210805052116','{\"user\":{\"fname\":\"Yan Syafri\",\"lname\":\"Hidayat\",\"email\":\"yansyaf@gmail.com\",\"phone\":\"08118040685\",\"country\":\"Indonesia\",\"city\":\"Bandung\",\"address\":\"Jl. PHH Mustopa No.39\",\"channel\":\"fusi_bniva\"},\"payment\":{\"merchant_trxid\":\"210805052116\",\"amount\":\"935000\",\"name\":\"Yan Syafri Hidayat\",\"email\":\"yansyaf@gmail.com\",\"phone\":\"Yan Syafri Hidayat\",\"request_datetime\":\"05-08-2021 17:21:16\",\"expire_datetime\":\"06-08-2021 17:21:16\",\"va_number\":\"9884068521080502\",\"url\":\"\",\"qstring\":\"\",\"image_url\":\"https:\\/\\/payment.fusi.id\\/storage\\/15\\/60fe1614e38a3_logo_bni.png\"}}','2021-08-06','open','2021-08-05 17:21:16','2021-08-05 17:21:17',NULL,1,NULL),(4,'210806090132','{\"user\":{\"fname\":\"Fusi\",\"lname\":\"Alim\",\"email\":\"muahamadalim424@gmail.com\",\"phone\":\"08956672312\",\"country\":\"Indonesia\",\"city\":\"Bandung\",\"address\":\"Surapati core blok M6\",\"channel\":\"fusi_bniva\"},\"payment\":{\"merchant_trxid\":\"210806090132\",\"amount\":\"99000\",\"name\":\"Fusi Alim\",\"email\":\"muahamadalim424@gmail.com\",\"phone\":\"Fusi Alim\",\"request_datetime\":\"06-08-2021 09:01:32\",\"expire_datetime\":\"07-08-2021 09:01:32\",\"va_number\":\"9884068521080601\",\"url\":\"\",\"qstring\":\"\",\"image_url\":\"https:\\/\\/payment.fusi.id\\/storage\\/15\\/60fe1614e38a3_logo_bni.png\"}}','2021-08-07','open','2021-08-06 09:01:32','2021-08-06 09:01:33',NULL,1,NULL),(5,'210806123928','{\"user\":{\"fname\":\"Yan Syafri\",\"lname\":\"Hidayat\",\"email\":\"yansyaf@gmail.com\",\"phone\":\"08118040685\",\"country\":\"Indonesia\",\"city\":\"Bandung\",\"address\":\"Surapati Core\",\"channel\":\"fusi_alfa\"},\"payment\":{\"merchant_trxid\":\"210806123928\",\"amount\":\"1969000\",\"name\":\"Yan Syafri Hidayat\",\"email\":\"yansyaf@gmail.com\",\"phone\":\"Yan Syafri Hidayat\",\"request_datetime\":\"06-08-2021 12:39:28\",\"expire_datetime\":\"07-08-2021 12:39:28\",\"va_number\":\"3399970735609345\",\"url\":\"\",\"qstring\":\"\",\"image_url\":\"https:\\/\\/payment.fusi.id\\/storage\\/8\\/60fe159cd042c_logo_alfamart.png\"}}','2021-08-07','open','2021-08-06 12:39:28','2021-08-06 12:39:29',NULL,1,NULL),(6,'211006125640','{\"user\":{\"fname\":\"Bagasraga\",\"lname\":\"raga\",\"email\":\"hasea23@gmail.com\",\"phone\":\"089694026392\",\"city\":\"80\",\"address\":\"Jl Raya Batujajar No 26 RT01 RW 02\",\"channel\":\"fusi_ovo\"},\"payment\":{\"merchant_trxid\":\"211006125640\",\"amount\":\"51000\",\"name\":\"Bagasraga raga\",\"email\":\"hasea23@gmail.com\",\"phone\":\"Bagasraga raga\",\"request_datetime\":\"06-10-2021 12:56:40\",\"expire_datetime\":\"07-10-2021 12:56:40\",\"va_number\":\"\",\"url\":\"https:\\/\\/payment.fusi.id\\/pay?trxid=3399981299786892&phonenumber=089694026392&channel=ovo&bill_no=0016334998013418&signature=5d2497af199b1aeebf7260f1d5d3661bf7767e88\",\"qstring\":\"\",\"image_url\":\"https:\\/\\/payment.fusi.id\\/storage\\/1\\/60fe1524697bb_logo_ovo.png\"}}','2021-10-07','open','2021-10-06 12:56:40','2021-10-06 12:56:41',NULL,NULL,'13ed55b2-bd56-4877-8e5e-905bf2deb8e0'),(7,'211006011214','{\"user\":{\"fname\":\"Mohamad\",\"lname\":\"Al Jihad\",\"email\":\"aljihadmohamad@gmail.com\",\"phone\":\"081211526580\",\"city\":\"710\",\"address\":\"Alamat: Komplek Surapati Core No.M6 Jl. PHH. Mustofa No, 39, Pasirlayung, Kec. Cibeunying Kidul, Kota Bandung, Jawa Barat 40192\",\"channel\":\"fusi_ovo\"},\"payment\":{\"merchant_trxid\":\"211006011214\",\"amount\":\"20000\",\"name\":\"Mohamad Al Jihad\",\"email\":\"aljihadmohamad@gmail.com\",\"phone\":\"Mohamad Al Jihad\",\"request_datetime\":\"06-10-2021 13:12:14\",\"expire_datetime\":\"07-10-2021 13:12:14\",\"va_number\":\"\",\"url\":\"https:\\/\\/payment.fusi.id\\/pay?trxid=3399981272168074&phonenumber=081211526580&channel=ovo&bill_no=0016335007361390&signature=98fbc7b8565ce3de237a34cc8870362e5664bc71\",\"qstring\":\"\",\"image_url\":\"https:\\/\\/payment.fusi.id\\/storage\\/1\\/60fe1524697bb_logo_ovo.png\"}}','2021-10-07','open','2021-10-06 13:12:14','2021-10-06 13:12:16',NULL,NULL,'e0f29989-0c94-45be-b7b3-da76f8981d9b'),(8,'211012024430','{\"user\":{\"fname\":\"Bagasraga\",\"lname\":\"raga\",\"email\":\"hasea23@gmail.com\",\"phone\":\"089694026392\",\"city\":\"80\",\"address\":\"Jl Raya Batujajar No 26 RT01 RW 02\",\"channel\":\"fusi_ovo\"},\"payment\":{\"merchant_trxid\":\"211012024430\",\"amount\":\"34000\",\"name\":\"Bagasraga raga\",\"email\":\"hasea23@gmail.com\",\"phone\":\"Bagasraga raga\",\"request_datetime\":\"12-10-2021 14:44:30\",\"expire_datetime\":\"13-10-2021 14:44:30\",\"va_number\":\"\",\"url\":\"https:\\/\\/payment.fusi.id\\/pay?trxid=3399981246557793&phonenumber=089694026392&channel=ovo&bill_no=0016340246703698&signature=1ab5d1f0a564800fb0238242a7f8fc8d0d6e947d\",\"qstring\":\"\",\"image_url\":\"https:\\/\\/payment.fusi.id\\/storage\\/1\\/60fe1524697bb_logo_ovo.png\"}}','2021-10-13','open','2021-10-12 14:44:30','2021-10-12 14:44:31',NULL,NULL,'13ed55b2-bd56-4877-8e5e-905bf2deb8e0'),(9,'211012024734','{\"user\":{\"fname\":\"mohamad\",\"lname\":\"al jihad\",\"email\":\"aljihadmohamad@gmail.com\",\"phone\":\"081211526580\",\"city\":\"710\",\"address\":\"Komplek Surapati Core No.M6 Jl. PHH. Mustofa No, 39, Pasirlayung, Kec. Cibeunying Kidul, Kota Bandung, Jawa Barat 40192\",\"channel\":\"fusi_ovo\"},\"payment\":{\"merchant_trxid\":\"211012024734\",\"amount\":\"35000\",\"name\":\"mohamad al jihad\",\"email\":\"aljihadmohamad@gmail.com\",\"phone\":\"mohamad al jihad\",\"request_datetime\":\"12-10-2021 14:47:34\",\"expire_datetime\":\"13-10-2021 14:47:34\",\"va_number\":\"\",\"url\":\"https:\\/\\/payment.fusi.id\\/pay?trxid=3399981283978991&phonenumber=081211526580&channel=ovo&bill_no=0016340248540237&signature=c7726b2b56508afa328bc1071849ac9a9807108f\",\"qstring\":\"\",\"image_url\":\"https:\\/\\/payment.fusi.id\\/storage\\/1\\/60fe1524697bb_logo_ovo.png\"}}','2021-10-13','open','2021-10-12 14:47:34','2021-10-12 14:47:35',NULL,NULL,'e0f29989-0c94-45be-b7b3-da76f8981d9b'),(10,'211012024840','{\"user\":{\"fname\":\"Mohamad\",\"lname\":\"Al Jihad\",\"email\":\"aljihadmohamad@gmail.com\",\"phone\":\"081211526580\",\"city\":\"710\",\"address\":\"Komplek Surapati Core No.M6 Jl. PHH. Mustofa No, 39, Pasirlayung, Kec. Cibeunying Kidul, Kota Bandung, Jawa Barat 40192\",\"channel\":\"fusi_mandiri\"},\"payment\":{\"merchant_trxid\":\"211012024840\",\"amount\":\"20000\",\"name\":\"Mohamad Al Jihad\",\"email\":\"aljihadmohamad@gmail.com\",\"phone\":\"Mohamad Al Jihad\",\"request_datetime\":\"12-10-2021 14:48:40\",\"expire_datetime\":\"13-10-2021 14:48:40\",\"va_number\":\"8830833999570759\",\"url\":\"\",\"qstring\":\"\",\"image_url\":\"https:\\/\\/payment.fusi.id\\/storage\\/13\\/60fe15f936172_logo_mandiri.png\"}}','2021-10-13','open','2021-10-12 14:48:40','2021-10-12 14:48:40',NULL,NULL,'e0f29989-0c94-45be-b7b3-da76f8981d9b'),(11,'211108094124',NULL,NULL,'open','2021-11-08 09:41:24','2021-11-08 09:41:24',NULL,NULL,'e0f29989-0c94-45be-b7b3-da76f8981d9b'),(12,'211108094929',NULL,NULL,'open','2021-11-08 09:49:29','2021-11-08 09:49:29',NULL,NULL,'e0f29989-0c94-45be-b7b3-da76f8981d9b'),(13,'211108110357',NULL,NULL,'open','2021-11-08 11:03:57','2021-11-08 11:03:57',NULL,NULL,'e0f29989-0c94-45be-b7b3-da76f8981d9b'),(14,'211108120227',NULL,NULL,'open','2021-11-08 12:02:27','2021-11-08 12:02:27',NULL,NULL,'e0f29989-0c94-45be-b7b3-da76f8981d9b');

--
-- Table structure for table `permission_role`
--

CREATE TABLE `permission_role` (
  `role_id` bigint(20) unsigned NOT NULL,
  `permission_id` bigint(20) unsigned NOT NULL,
  KEY `role_id_fk_4236579` (`role_id`),
  KEY `permission_id_fk_4236579` (`permission_id`),
  CONSTRAINT `permission_id_fk_4236579` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_id_fk_4236579` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permission_role`
--

INSERT INTO `permission_role` VALUES (1,1),(1,2),(1,3),(1,4),(1,5),(1,6),(1,7),(1,8),(1,9),(1,10),(1,11),(1,12),(1,13),(1,14),(1,15),(1,16),(1,17),(1,18),(1,19),(1,20),(1,21),(1,22),(1,23),(1,24),(1,25),(1,26),(1,27),(1,28),(1,29),(1,30),(1,31),(1,32),(1,33),(1,34),(1,35),(1,36),(1,37),(1,38),(1,39),(1,40),(1,41),(1,42),(1,43),(1,44),(1,45),(1,46),(1,47),(1,48),(1,49),(1,50),(1,51),(1,52),(1,53),(1,54),(1,55),(1,56),(1,57),(1,58),(1,59),(1,60),(1,61),(1,62),(1,63),(1,64),(1,65),(1,66),(1,67),(1,68),(1,69),(1,70),(1,71),(1,72),(1,73),(1,74),(1,75),(1,76),(1,77),(1,78),(1,79),(1,80),(1,81),(1,82),(1,83),(1,84),(1,85),(1,86),(1,87),(1,88),(1,89),(1,90),(1,91),(1,92),(1,93),(1,94),(1,95),(1,96),(1,97),(1,98),(1,99),(1,100),(1,101),(1,102),(1,103),(1,104),(1,105),(1,106),(1,107),(2,17),(2,18),(2,19),(2,20),(2,21),(2,22),(2,23),(2,24),(2,25),(2,26),(2,27),(2,28),(2,29),(2,30),(2,31),(2,32),(2,33),(2,34),(2,35),(2,36),(2,37),(2,38),(2,39),(2,40),(2,41),(2,42),(2,43),(2,44),(2,45),(2,46),(2,47),(2,48),(2,49),(2,50),(2,51),(2,52),(2,53),(2,54),(2,55),(2,56),(2,57),(2,58),(2,59),(2,60),(2,61),(2,62),(2,63),(2,64),(2,65),(2,66),(2,67),(2,68),(2,69),(2,70),(2,71),(2,72),(2,73),(2,74),(2,75),(2,76),(2,77),(2,78),(2,79),(2,80),(2,81),(2,82),(2,83),(2,84),(2,85),(2,86),(2,87),(2,88),(2,89),(2,90),(2,91),(2,92),(2,93),(2,94),(2,95),(2,96),(2,97),(2,98),(2,99),(2,100),(2,101),(2,102),(2,103),(2,104),(2,105),(2,106),(2,107),(1,1),(1,2),(1,3),(1,4),(1,5),(1,6),(1,7),(1,8),(1,9),(1,10),(1,11),(1,12),(1,13),(1,14),(1,15),(1,16),(1,17),(1,18),(1,19),(1,20),(1,21),(1,22),(1,23),(1,24),(1,25),(1,26),(1,27),(1,28),(1,29),(1,30),(1,31),(1,32),(1,33),(1,34),(1,35),(1,36),(1,37),(1,38),(1,39),(1,40),(1,41),(1,42),(1,43),(1,44),(1,45),(1,46),(1,47),(1,48),(1,49),(1,50),(1,51),(1,52),(1,53),(1,54),(1,55),(1,56),(1,57),(1,58),(1,59),(1,60),(1,61),(1,62),(1,63),(1,64),(1,65),(1,66),(1,67),(1,68),(1,69),(1,70),(1,71),(1,72),(1,73),(1,74),(1,75),(1,76),(1,77),(1,78),(1,79),(1,80),(1,81),(1,82),(1,83),(1,84),(1,85),(1,86),(1,87),(1,88),(1,89),(1,90),(1,91),(1,92),(1,93),(1,94),(1,95),(1,96),(1,97),(1,98),(1,99),(1,100),(1,101),(1,102),(1,103),(1,104),(1,105),(1,106),(1,107),(2,17),(2,18),(2,19),(2,20),(2,21),(2,22),(2,23),(2,24),(2,25),(2,26),(2,27),(2,28),(2,29),(2,30),(2,31),(2,32),(2,33),(2,34),(2,35),(2,36),(2,37),(2,38),(2,39),(2,40),(2,41),(2,42),(2,43),(2,44),(2,45),(2,46),(2,47),(2,48),(2,49),(2,50),(2,51),(2,52),(2,53),(2,54),(2,55),(2,56),(2,57),(2,58),(2,59),(2,60),(2,61),(2,62),(2,63),(2,64),(2,65),(2,66),(2,67),(2,68),(2,69),(2,70),(2,71),(2,72),(2,73),(2,74),(2,75),(2,76),(2,77),(2,78),(2,79),(2,80),(2,81),(2,82),(2,83),(2,84),(2,85),(2,86),(2,87),(2,88),(2,89),(2,90),(2,91),(2,92),(2,93),(2,94),(2,95),(2,96),(2,97),(2,98),(2,99),(2,100),(2,101),(2,102),(2,103),(2,104),(2,105),(2,106),(2,107);

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=108 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` VALUES (1,'user_management_access',NULL,NULL,NULL),(2,'permission_create',NULL,NULL,NULL),(3,'permission_edit',NULL,NULL,NULL),(4,'permission_show',NULL,NULL,NULL),(5,'permission_delete',NULL,NULL,NULL),(6,'permission_access',NULL,NULL,NULL),(7,'role_create',NULL,NULL,NULL),(8,'role_edit',NULL,NULL,NULL),(9,'role_show',NULL,NULL,NULL),(10,'role_delete',NULL,NULL,NULL),(11,'role_access',NULL,NULL,NULL),(12,'user_create',NULL,NULL,NULL),(13,'user_edit',NULL,NULL,NULL),(14,'user_show',NULL,NULL,NULL),(15,'user_delete',NULL,NULL,NULL),(16,'user_access',NULL,NULL,NULL),(17,'audit_log_show',NULL,NULL,NULL),(18,'audit_log_access',NULL,NULL,NULL),(19,'master_data_access',NULL,NULL,NULL),(20,'village_create',NULL,NULL,NULL),(21,'village_edit',NULL,NULL,NULL),(22,'village_show',NULL,NULL,NULL),(23,'village_delete',NULL,NULL,NULL),(24,'village_access',NULL,NULL,NULL),(25,'district_create',NULL,NULL,NULL),(26,'district_edit',NULL,NULL,NULL),(27,'district_show',NULL,NULL,NULL),(28,'district_delete',NULL,NULL,NULL),(29,'district_access',NULL,NULL,NULL),(30,'city_create',NULL,NULL,NULL),(31,'city_edit',NULL,NULL,NULL),(32,'city_show',NULL,NULL,NULL),(33,'city_delete',NULL,NULL,NULL),(34,'city_access',NULL,NULL,NULL),(35,'province_create',NULL,NULL,NULL),(36,'province_edit',NULL,NULL,NULL),(37,'province_show',NULL,NULL,NULL),(38,'province_delete',NULL,NULL,NULL),(39,'province_access',NULL,NULL,NULL),(40,'category_access',NULL,NULL,NULL),(41,'product_category_create',NULL,NULL,NULL),(42,'product_category_edit',NULL,NULL,NULL),(43,'product_category_show',NULL,NULL,NULL),(44,'product_category_delete',NULL,NULL,NULL),(45,'product_category_access',NULL,NULL,NULL),(46,'resource_category_create',NULL,NULL,NULL),(47,'resource_category_edit',NULL,NULL,NULL),(48,'resource_category_show',NULL,NULL,NULL),(49,'resource_category_delete',NULL,NULL,NULL),(50,'resource_category_access',NULL,NULL,NULL),(51,'tag_create',NULL,NULL,NULL),(52,'tag_edit',NULL,NULL,NULL),(53,'tag_show',NULL,NULL,NULL),(54,'tag_delete',NULL,NULL,NULL),(55,'tag_access',NULL,NULL,NULL),(56,'resource_create',NULL,NULL,NULL),(57,'resource_edit',NULL,NULL,NULL),(58,'resource_show',NULL,NULL,NULL),(59,'resource_delete',NULL,NULL,NULL),(60,'resource_access',NULL,NULL,NULL),(61,'product_create',NULL,NULL,NULL),(62,'product_edit',NULL,NULL,NULL),(63,'product_show',NULL,NULL,NULL),(64,'product_delete',NULL,NULL,NULL),(65,'product_access',NULL,NULL,NULL),(66,'news_category_create',NULL,NULL,NULL),(67,'news_category_edit',NULL,NULL,NULL),(68,'news_category_show',NULL,NULL,NULL),(69,'news_category_delete',NULL,NULL,NULL),(70,'news_category_access',NULL,NULL,NULL),(71,'news_create',NULL,NULL,NULL),(72,'news_edit',NULL,NULL,NULL),(73,'news_show',NULL,NULL,NULL),(74,'news_delete',NULL,NULL,NULL),(75,'news_access',NULL,NULL,NULL),(76,'usecase_category_create',NULL,NULL,NULL),(77,'usecase_category_edit',NULL,NULL,NULL),(78,'usecase_category_show',NULL,NULL,NULL),(79,'usecase_category_delete',NULL,NULL,NULL),(80,'usecase_category_access',NULL,NULL,NULL),(81,'usecase_create',NULL,NULL,NULL),(82,'usecase_edit',NULL,NULL,NULL),(83,'usecase_show',NULL,NULL,NULL),(84,'usecase_delete',NULL,NULL,NULL),(85,'usecase_access',NULL,NULL,NULL),(86,'capability_category_create',NULL,NULL,NULL),(87,'capability_category_edit',NULL,NULL,NULL),(88,'capability_category_show',NULL,NULL,NULL),(89,'capability_category_delete',NULL,NULL,NULL),(90,'capability_category_access',NULL,NULL,NULL),(91,'capability_create',NULL,NULL,NULL),(92,'capability_edit',NULL,NULL,NULL),(93,'capability_show',NULL,NULL,NULL),(94,'capability_delete',NULL,NULL,NULL),(95,'capability_access',NULL,NULL,NULL),(96,'transaction_access',NULL,NULL,NULL),(97,'cart_create',NULL,NULL,NULL),(98,'cart_edit',NULL,NULL,NULL),(99,'cart_show',NULL,NULL,NULL),(100,'cart_delete',NULL,NULL,NULL),(101,'cart_access',NULL,NULL,NULL),(102,'order_create',NULL,NULL,NULL),(103,'order_edit',NULL,NULL,NULL),(104,'order_show',NULL,NULL,NULL),(105,'order_delete',NULL,NULL,NULL),(106,'order_access',NULL,NULL,NULL),(107,'profile_password_edit',NULL,NULL,NULL);

--
-- Table structure for table `product_categories`
--

CREATE TABLE `product_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `product_categories_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_categories`
--

INSERT INTO `product_categories` VALUES (1,'ioSense','io-sense','2021-06-25 06:18:27','2021-06-25 06:18:27',NULL),(2,'IoT Shield','iot-shield','2021-07-01 04:09:22','2021-08-04 14:42:38',NULL),(3,'IoComm','iocomm','2021-07-01 04:10:09','2021-07-01 04:11:58',NULL),(4,'IoControl','iocontrol','2021-07-01 04:11:25','2021-07-01 04:11:25',NULL),(5,'IoMeter','iometer','2021-07-01 04:11:44','2021-07-01 04:11:44',NULL),(6,'IoReader','ioreader','2021-07-01 04:12:35','2021-07-01 04:12:35',NULL),(7,'IoTags','iotags','2021-07-01 04:12:55','2021-07-01 04:12:55',NULL),(8,'IoTrack','iotrack','2021-07-01 04:13:18','2021-07-01 04:13:18',NULL),(9,'SmartCity','smartcity','2021-07-01 10:33:21','2021-07-02 02:17:35','2021-07-02 02:17:35'),(10,'ioPanel','iopanel','2021-07-02 02:34:50','2021-07-02 02:35:10',NULL);

--
-- Table structure for table `product_resource`
--

CREATE TABLE `product_resource` (
  `product_id` bigint(20) unsigned NOT NULL,
  `resource_id` bigint(20) unsigned NOT NULL,
  KEY `product_id_fk_4236691` (`product_id`),
  KEY `resource_id_fk_4236691` (`resource_id`),
  CONSTRAINT `product_id_fk_4236691` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  CONSTRAINT `resource_id_fk_4236691` FOREIGN KEY (`resource_id`) REFERENCES `resources` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_resource`
--

INSERT INTO `product_resource` VALUES (1,1),(11,2),(10,3),(13,4),(1,1),(11,2),(10,3),(13,4);

--
-- Table structure for table `product_tag`
--

CREATE TABLE `product_tag` (
  `product_id` bigint(20) unsigned NOT NULL,
  `tag_id` bigint(20) unsigned NOT NULL,
  KEY `product_id_fk_4236692` (`product_id`),
  KEY `tag_id_fk_4236692` (`tag_id`),
  CONSTRAINT `product_id_fk_4236692` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  CONSTRAINT `tag_id_fk_4236692` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_tag`
--

INSERT INTO `product_tag` VALUES (1,5),(11,2),(11,5),(11,6),(11,7),(11,8),(10,2),(10,5),(10,6),(10,7),(10,9),(12,4),(12,5),(12,6),(13,2),(14,4),(15,2),(15,5),(15,6),(17,10),(1,5),(11,2),(11,5),(11,6),(11,7),(11,8),(10,2),(10,5),(10,6),(10,7),(10,9),(12,4),(12,5),(12,6),(13,2),(14,4),(15,2),(15,5),(15,6),(17,10);

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `specification` longtext COLLATE utf8mb4_unicode_ci,
  `price_range` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `stock` int(11) DEFAULT NULL,
  `is_preorder` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `preorder_day` int(11) DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `category_id` bigint(20) unsigned NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `weight` int(10) NOT NULL,
  `is_variant` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_homepage` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `part_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `excerpt` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `category_fk_4236688` (`category_id`),
  CONSTRAINT `category_fk_4236688` FOREIGN KEY (`category_id`) REFERENCES `product_categories` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `products`
--

INSERT INTO `products` VALUES (1,'Intelli NB-IoT','<p>Intelli BG96 NB-IoT board is a complete IoT wireless communication board produced by Fusi. The main communication chip is based on Quectel LTE Cat M1/Cat NB1/EGPRS BG96 IC. It features global frequency bands, ultra-low power consumption, and packed with onboard positioning using GPS, GLONASS, BeiDou/Compass, Galileo, QZSS standard.&nbsp;</p><p>On Processing side this board equipped with ESP32 which widely supported by Arduino IDE and communities. It is the best solution for applications that need low power consumption, integrated IoT (WIFI and BLE). Intelli BG96 NB-IoT board will help developer to evaluate and design any IoT solution in no time.&nbsp;</p><figure class=\"image\"><img src=\"https://fusi.co.id/storage/73/INTELLI-NB-IoT.jpg\"></figure><figure class=\"image\"><img src=\"https://fusi.co.id/storage/74/INTELLI-NB-IoT_2.jpg\"></figure>','<ul><li>Input Voltage: 5VDC from USB micro port or 2.54 pitch male Header</li><li>Communication Module: BG96<ul><li>Quectel LTE Cat M1/Cat NB1/EGPRS with global frequency bands (B1/ B2/ B3/ B4/ B5/ B8/ B12/ B13/ B18/B19/ B20/&nbsp;B25/ B26*/ B28)</li><li>ultra-low power consumption</li><li>GPS, GLONASS, BeiDou/Compass, Galileo, QZSS standard positioning</li></ul></li><li>WIFI/BLE support</li><li>Module interfaces support SD card, UART, SPI, SDIO, I 2 C, LED PWM, Motor PWM, I 2 S, IR, pulse counter, GPIO, capacitive touch sensor, ADC, DAC</li><li>Operating Temperature：-25℃~+85℃</li><li>Dimension: 5,85 cm x&nbsp; &nbsp; &nbsp; 5.6 cm</li></ul>','1350000',1,'yes',NULL,'ga','2021-07-01 04:22:37','2021-09-13 11:48:26',NULL,2,'intelli-nbiot',1,'no','yes','1','Intelli BG96 NB-IoT board is a complete IoT wireless communication board produced by Fusi.'),(2,'Intelli LoRA','<p>Intelli LoRA board is a long range IoT wireless board produced by Fusi. Intelli LoRa is based on SX1276/SX1278 Semtech chip. Using Semtech’s patented LoRa™ modulation technique the LoRa Shield can achieve a sensitivity of over -148dBm using a low cost crystal and bill of materials. The high sensitivity combined with the integrated +20 dBm power amplifier yields industry leading link budget making it optimal for any application requiring range or robustness. LoRa™ also provides significant advantages in both blocking and selectivity over conventional modulation techniques, solving the traditional design compromise between range, interference immunity and energy consumption.</p><p>Onboard is packed with Quectell GPS L80-R which can achieves the highest performance and fully meets the industrial standard.&nbsp;</p><p>On Processing side this board equipped with ESP32 which widely supported by Arduino IDE and communities. It is the best solution for applications that need low power consumption, integrated IoT (WIFI and BLE). Intelli LoRA board will help developer to evaluate and develop any IoT solution in no time.&nbsp;</p><figure class=\"image\"><img src=\"https://fusi.co.id/storage/75/Intellilora.jpg\"></figure>','<ul><li>WIFI/BLE support</li><li>Module interfaces support SD card, UART, SPI, SDIO, I 2 C, LED PWM, Motor PWM, I 2 S, IR, pulse counter, GPIO, capacitive touch sensor, ADC, DAC</li><li>Operating Temperature：-25℃~+85℃</li><li>Dimension: 5,85 cm x&nbsp; 5.6 cm</li><li>LoRA Specification:<ul><li>168 dB maximum link budget.</li><li>+20 dBm - 100 mW constant RF output vs.</li><li>+14 dBm high efficiency PA.</li><li>Programmable bit rate up to 300 kbps.</li><li>High sensitivity: down to -148 dBm.</li><li>Bullet-proof front end: IIP3 = -12.5 dBm.</li><li>Excellent blocking immunity.</li><li>FSK, GFSK, MSK, GMSK, LoRaTM and OOK modulation.</li></ul></li><li>GPS Specification<ul><li>Ultra low power consumpti on in tracking mode, 20mA</li><li>High sensiti vity: -165dBm @Tracking, -148dBm @Acquisiti on</li><li>66 acquisiti on channels, 22 tracking channels</li><li>Support QZSS</li></ul></li></ul>','450000',1,'yes',30,'ga','2021-07-01 04:50:57','2021-09-13 11:49:16',NULL,2,'intelli-lora',1,'no','yes','1','Intelli LoRA board is a long range IoT wireless board produced by Fusi. Intelli LoRa is based on SX1276/SX1278 Semtech chip.'),(3,'Intelli WiBLE','<p>Intelli WiBLE is compact module that providing flexibility of generic MCU, combined with Wi-Fi and Bluetooth ® functionalities. It is the core of IoT enabler for any solution. With its ultra-small size, robust performance and low-energy consumption, Intelli WiBLE is well suited for any space-limited or battery-operated applications, such as wearable electronics, medical equipment, sensors and other IoT products.</p><figure class=\"image\"><img src=\"https://fusi.co.id/storage/76/Intelli-WiBLE.jpg\"></figure><p>&nbsp;</p>','<ul><li>LowPower 32-bit LX6 microprocessors&nbsp; 2 core 40 MHz</li><li>Wi-Fi 2.4 GHz, 802.11 b/g/n (802.11n up to 150 Mbps)</li><li>Bluetooth V4.2 BR/EDR and Bluetooth LE specification</li><li>Support Interfaces :ADC, DAC, touch sensor, SD/SDIO/MMC Host Controller, SPI, SDIO/SPI Slave Controller, EMAC, motor PWM, LEDPWM, UART, I2C, I2S, infrared remote controller, GPIO, pulse counter</li><li>Integrated Hall sensor</li><li>Operating Temperature：-25℃~+85℃</li><li>On board 3-axis accelerometer with high resolution (13-bit) based on ADXL345</li></ul>','90000',NULL,'yes',NULL,'ga','2021-07-01 07:29:50','2021-08-19 11:10:43',NULL,2,'intelli-wible',0,'','','intelli-wible','Intelli WiBLE is compact module that providing flexibility of generic MCU, combined with Wi-Fi and Bluetooth ® functionalities.'),(4,'Smart Street Lamp (PJU)','<p>Fusi Smart Street Lamp is smart lighting controller using standard NEMA socket which will enhance the capability of any Street Lamp. The communication module is using latest IoT technology (NB-IoT/GSM and LoRA) and can be configured according to user requirement. Thus provide great flexibility and ease on deployment.</p><p>&nbsp; &nbsp;</p><figure class=\"image\"><img src=\"https://fusi.co.id/storage/93/Smart-Lamp_1.jpg\"></figure><figure class=\"image\"><img src=\"https://fusi.co.id/storage/95/Smart-Lamp_2.jpg\"></figure><figure class=\"image\"><img src=\"https://fusi.co.id/storage/94/Smart-Lamp_3.jpg\"></figure><figure class=\"image\"><img src=\"https://fusi.co.id/storage/81/Nema-Adapter.jpg\"></figure><figure class=\"image\"><img src=\"https://fusi.co.id/storage/82/Smart-Street-Lamp-Nema.jpg\"></figure>','<p><strong>Feature</strong></p><ul><li>The Lamp Brightness can be controlled directly via Dashboard/Apps.</li><li>Periodic Statistic Report: (Temp/humidity, Power Consumption, Fault Condition)</li><li>Low Power Consumption</li><li><strong>NB-IoT/GSM</strong> or <strong>LoRA</strong> for IoT connection</li><li>WIFI and BLE for local connectivity support</li><li>NEMA Lighting Dome IP67 casing standard</li><li>Real time Control/Monitoring</li><li>Sense Voltage (V), Current (A), Power (W), Power Factor</li></ul>',NULL,NULL,'yes',30,'ga','2021-07-01 08:45:12','2021-09-09 10:31:22',NULL,4,'smart-street-lamp',1,'no','yes','-','Smart Street Lamp (PJU)'),(5,'Energy Meter','<p>Fusi Energy Meter is a smart device to improve the effectivity of energy usage in your house or office. This device will measure energy consumption and analyze it on cloud. You can also control the switch anywhere from Apps. Combine it with Fusi Smart Home system, it will improve the efficiency of energy consumption by eliminate waste or unproductive energy usage.</p><figure class=\"image\"><img src=\"https://fusi.co.id/new/storage/18/tector.jpeg\"></figure><figure class=\"image image-style-side\"><img src=\"https://fusi.co.id/new/storage/19/WhatsApp-Image-2021-06-23-at-07.01.16.jpeg\"></figure>','<ul><li>Measurement:<ul><li>Voltage Monitoring: 220 -1000 VAC</li><li>Maximum Current up to 100A (22000 kVA)</li><li>Cos phi</li></ul></li><li>Low Power Consumption &lt; 1.5 Watt</li><li>Casing IP66</li><li>Real Time Data Sensing</li><li>Communication Interface:<ul><li>Quad-band GSM / GPRS module, 800/900 /1800/1900 MHz</li><li>Bluetooth v4.2 BR/EDR</li><li>GPS: GNSS BDS, L1 (1575.42 Mhz) and L2 (1227.60 MHz). (optional)</li><li>WIFI 2.4 GHz</li></ul></li><li>Dimension: (P x l x t ) 110 x 110 x 60 mm</li></ul>',NULL,NULL,'yes',NULL,'ga','2021-07-01 09:02:48','2021-07-08 05:36:01',NULL,5,'energy-meter',0,'','','',''),(6,'IO Fleet Management','<p>&nbsp;</p><p>&nbsp;</p><p>IO Fleet Management Solutions provides complete mobile asset tracking and management tools that provide complete return on investment typically in less than one year. Hard dollar savings in fuel, vehicle miles driven, and worker overtime are obvious benefits. In addition, fewer accidents, improved driver behavior and better execution of corporate and agency mandates deliver even more value to the organization.</p><p>IO Fleet Management solution is multi-layer technology consist of GPS Tracker, several IoT devices or sensor combined with Cloud Analytic and also ERP.</p><p>&nbsp;</p><figure class=\"image\"><img src=\"https://fusi.co.id/new/storage/20/image.png\"><figcaption>IO Fleet Management Architechture</figcaption></figure><p>&nbsp;</p><figure class=\"image\"><img src=\"https://fusi.co.id/new/storage/23/image.png\"></figure><figure class=\"image\"><img src=\"https://fusi.co.id/new/storage/21/image.png\"><figcaption>Fuel Tracker Sensor</figcaption></figure><figure class=\"image\"><img src=\"https://fusi.co.id/new/storage/22/image.png\"><figcaption>GPS Tracker</figcaption></figure><p>&nbsp;</p>','<ul><li>FusiERP, provide flexible module to be integrated<ul><li>CRM</li><li>Projects</li><li>Helpdesk</li><li>Asset Management</li><li>Accounting</li><li>Manufacturing</li><li>Sales and Purchase</li></ul></li><li>Fuel Consumption Sensor<ul><li>Flow rate range, 0.0085-0.85L/min</li><li>Maximum operating pressure,<strong> </strong>0.5MPa (When the liquid is at 20°C).</li></ul></li><li>Communication Module: BG96<ul><li>Quectel LTE Cat M1/Cat NB1/EGPRS with global frequency bands (B1/ B2/ B3/ B4/ B5/ B8/ B12/ B13/ B18/B19/ B20/&nbsp;B25/ B26*/ B28)</li><li>ultra-low power consumption</li><li>GPS, GLONASS, BeiDou/Compass, Galileo, QZSS standard positioning</li></ul></li><li>GPS Specification<ul><li>Ultra low power consumpti on in tracking mode, 20mA</li><li>High sensiti vity: -165dBm @Tracking, -148dBm @Acquisiti on</li><li>66 acquisiti on channels, 22 tracking channels</li><li>Support QZSS</li></ul></li></ul>',NULL,10,'yes',14,'ga','2021-07-01 09:27:18','2021-09-13 09:24:44',NULL,8,'fleet-management',1,'no','no','-','IO Fleet Management'),(7,'Industrial IO Controller','<p>Industrial IO Controller is industrial module which functioned as Industry 4.0 enabler. It will perform automation task by first, using IntelliSense to grab or sense parameter from object and second is control any machine using adaptiveIO. The processing part can be done on the fly. If much processing power is needed, it can use assist from Fusi cloud computing or Fusi Industrial HP controller.</p><figure class=\"image\"><img src=\"https://fusi.co.id/storage/84/Industrial-e-Controller.jpg\"></figure><p>&nbsp;</p>','<ul><li>40MHz LowPower 32-bit LX6 microprocessors&nbsp; 2 core</li><li>Module interfaces support SD card, UART, SPI, SDIO, I2C, LED PWM, Motor PWM, I2S, IR, pulse counter, GPIO, capacitive touch sensor, ADC, DAC</li><li>RS232 interface</li><li>RS485 interface</li><li>Alarm/disaster prevention</li><li>Generic programmable</li></ul>',NULL,NULL,'yes',NULL,'ga','2021-07-01 09:37:39','2021-09-01 10:23:43',NULL,4,'industrial-io-controller',1,'','','-','Industrial IO Controller'),(8,'Industrial HP Controller','<p>Fusi Industrial HP (High Performance) Controller is versatile Industrial Controller to perform any task that need a lot of computing resource. It can perform AI computation for any algorithm such as object detection or anomaly detection which often be used in industrial use case. Along with Fusi Industrial IO Controller ,IoSense, and Intelli IoT Module it will suit any automation scenario needed for industry.</p><figure class=\"image\"><img src=\"https://fusi.co.id/storage/96/Batching-Plant-Base-Controller.jpg\"></figure><figure class=\"image\"><img src=\"https://fusi.co.id/new/storage/25/image.png\"></figure><figure class=\"image\"><img src=\"https://fusi.co.id/new/storage/26/image.png\"></figure>','<ul><li>CPU:<ul><li><strong>Intel Atom up to i9 core</strong>, RAM 4-8 GB, HDD</li><li>Embedded: LowPower 32-bit LX6 microprocessors&nbsp; 2 core</li></ul></li><li>LCD Touchscreen Display</li><li>•Power Source<ul><li>Input 220V AC</li><li>Consumption up to 100 Watt</li></ul></li><li>RF Interface<ul><li>BLE</li><li>WIFI</li><li>GSM</li><li>LoRA</li></ul></li><li>IO interface<ul><li>SD card, UART, SPI, SDIO, I2C, LED PWM, Motor PWM, I2S, IR, pulse counter, GPIO, capacitive touch sensor, ADC, DAC</li><li>Industrial CAN, RS485, or RS232</li><li>Relay</li></ul></li><li>Operating temperature 0 °C ~ +80 °C</li></ul>',NULL,NULL,'yes',NULL,'ga','2021-07-01 09:51:35','2021-07-29 09:06:06',NULL,4,'Industrial-hp-controller',0,'','','',''),(9,'Bikeshare 5G','<p>&nbsp;</p><p>Bikeshare 5G is Fusi solution for bikesharing platform. It\'s called hybrid system because it\'s combine benefit from robustness of old docking bikesharing system with flexibility of latest dockless system. To understand the advantages we can see the diagram below</p><figure class=\"image\"><img src=\"https://fusi.co.id/new/storage/28/image.png\"></figure><figure class=\"image\"><img src=\"https://fusi.co.id/new/storage/29/image.png\"><figcaption>Docking Problem</figcaption></figure><figure class=\"image\"><img src=\"https://fusi.co.id/new/storage/30/image.png\"><figcaption>Dockless Problem</figcaption></figure><figure class=\"image\"><img src=\"https://fusi.co.id/new/storage/33/WhatsApp-Image-2020-01-31-at-11.20.03.jpeg\"></figure><p>&nbsp;</p>',NULL,NULL,NULL,'yes',NULL,'ga','2021-07-01 10:42:51','2021-07-02 02:17:25','2021-07-02 02:17:25',9,'bikeshare5g',0,'','','',''),(10,'Water Quality Sensor','<p>Intelli i-WQu (Water Quality Monitoring System) is integrated solution for monitoring environment quality especially on water. Below is features of i-WQu:</p><ul><li>Realtime monitoring 24x7</li><li>Push notification warning if monitoring data exceeds any threshold parameter</li><li>AMDAL monitoring</li><li>Improve water quality and public health</li></ul><figure class=\"image\"><img src=\"https://fusi.co.id/storage/92/Water-Qualty-Sensor.jpg\"></figure>','<ul><li>Low Power Consumption, &lt;1.5 Watt</li><li>Solar Panel Integration for offgrid scenario</li><li>Real time monitoring and reporting</li><li>Real time alert notification (email, mobile, WA)</li><li>Terintegrasi dengan Octopus IoT Platform dan Analytic AI</li><li>Anti vandal/theft protection<ul><li>Vibration sensor</li><li>GPS positioning</li></ul></li><li>Dapat ditambahkan berbagai sensor<ul><li>Sensor banjir</li><li>Sensor cuaca (curah hujan)</li><li>Sensor suhu atau temperatur</li></ul></li><li>Active sensor:<ul><li>pH, DO, ORP, temperature, conductivity, turbidity, ions: Calcium (Ca2+), Chloride (Cl–), Fluoride (F–), Nitrate (NO3–), Iodide (I–), Cupric (Cu2+), Bromide (Br–), &nbsp;Ammonia (NH4), Lithium (Li+), Magnesium (Mg2+), Nitrite (NO2-), Perchlorate &nbsp;(ClO4), Potassium (K+), Sodium (Na+), Fluoroborate (BF4–), Silver (Ag+)</li></ul></li><li>RF Communication Interface:<ul><li>NB-IoT / Quad-band GSM / GPRS module, 800/900 /1800/1900 MHz</li><li>LoRA</li></ul></li><li>Operating condition : -20°C ~ +75°C with &lt; 90% RH</li><li>Dimension: (P x L x T) 190 x 290 x 140 mm</li><li>Power Supply:<ul><li>Grid Mode: AC 220V</li><li>Off-grid Mode: Solar Panel 10WP 12VDC, Battery 12V 7200 mAH</li></ul></li></ul><figure class=\"image\"><img src=\"https://fusi.co.id/new/storage/36/image.png\"><figcaption>Sensor</figcaption></figure>',NULL,NULL,'yes',NULL,'ga','2021-07-01 10:55:46','2021-07-28 07:40:06',NULL,1,'intelli-iwqu',0,'','','',''),(11,'Smart Water Meter','<p>Fusi Smart Water Meter is an IoT solution for water distribution system. It will measure water usage ,billing calculation &nbsp;and periodically push the data into server. The valve can be remotely controlled into ON or OFF position or by program.&nbsp;</p><p>The benefit of using Smart Water Meter is:</p><ul><li>Accurate realtime data usage report</li><li>Lower operational cost</li><li>Improve customer satisfaction</li><li>Eliminate dispute on payment bill</li><li>Support prepaid scenario</li></ul><p>&nbsp;</p><figure class=\"image\"><img src=\"https://fusi.co.id/storage/86/Smart-Water-Meter.jpg\"></figure><figure class=\"image\"><img src=\"https://fusi.co.id/new/storage/44/image.png\"><figcaption>Dashboard Monitoring</figcaption></figure>','<p>Features:</p><ul><li>Debit flow measurement</li><li>Realtime control and monitoring (cloud)</li><li>Push Notification</li><li>Support prepaid/postpaid scenario</li><li>Top Up Method :<ul><li>Smartcard</li><li>NFC 13.56mhz mifare/desfire,</li><li>online push,</li><li>token (optional)</li></ul></li><li>API Integration</li></ul><p>Technical Specification</p><ul><li>Pulse signal accuracy: 0.005 m3</li><li>Water temperature: 0.1℃ - 30℃</li><li>Working voltage: 3.6V/2.4Ah lithium battery (optional)</li><li>Ambient humidity: ≤ 93%</li><li>Battery service life: ≥ 2 years</li><li>Working pressure: ≤ 1.6 mpa</li><li>Pipe material: brass/cast iron</li><li>Data storage: cloud based and internal storage</li><li>Connectivity: NB-IoT</li><li>Top up method: smartcard, NFC 13.56mhz mifare/desfire, online push, token (optional)</li></ul>',NULL,NULL,'yes',NULL,'ga','2021-07-06 06:03:05','2021-07-26 03:44:05',NULL,5,'smart-water-meter',0,'','','',''),(12,'4G NBIoT/GSM modem','<p>Fusi NBIoT/GSM modem is industrial grade telecommunication modem, ready to be deployed for IoT application. It support industrial RS232, RS485, or modbus protocol as interface with LTE Cat M1/Cat NB1/EGPRS.&nbsp;</p><figure class=\"image\"><img src=\"https://fusi.co.id/storage/70/4G-NBIoT_GSM-modem.jpg\"></figure>','<h3>Specification</h3><ul><li>Input Voltage: 12VDC or 220VAC</li><li>Communication standard<ul><li>LTE Cat M1/Cat NB1/EGPRS with global frequency bands (B1/ B2/ B3/ B4/ B5/ B8/ B12/ B13/ B18/B19/ B20/&nbsp;B25/ B26*/ B28)</li><li>GPS, GLONASS, BeiDou/Compass, Galileo, QZSS standard positioning (optional)</li></ul></li><li>WIFI/BLE support for LAN connection</li><li>Module interfaces support RS232, RS485 modbus, and GPIO</li><li>Operating Temperature：-25℃~+85℃</li></ul>',NULL,NULL,'yes',NULL,'ga','2021-07-07 09:05:50','2021-07-26 03:13:01',NULL,3,'nbiot-modem',0,'','','',''),(13,'Smart Locker','<p>BOKS adalah sebuah sistem loker cerdas yang bermanfaat sebagai alamat virtual bagi pengguna sekaligus juga sebagai ruang privat untuk keperluan penyimpanan/penitipan barang. BOKS terdiri &nbsp;dari &nbsp;sebuah &nbsp;terminal &nbsp;kiosk &nbsp;sebagai &nbsp;komponen &nbsp;utama &nbsp;yang &nbsp;akan &nbsp;berinteraksi &nbsp;langsung &nbsp;dengan &nbsp;pengguna &nbsp;dan &nbsp;juga &nbsp;lemari &nbsp;penyimpanan &nbsp;yang &nbsp;bersifat &nbsp;ekstensi.</p><p>&nbsp;</p><figure class=\"image\"><img src=\"https://fusi.co.id/storage/91/SmartLocker.jpg\"></figure><figure class=\"image\"><img src=\"https://fusi.co.id/new/storage/56/image.png\"><figcaption>Diagram Penggunaan</figcaption></figure>','<p>Spesifikasi Terminal Kiosk dan Ekstensi &nbsp;</p><ul><li>Rangka dan Tubuh &nbsp;: &nbsp;ABS Steel</li><li>Warna &nbsp;: &nbsp;Dapat dikustomisasi</li><li>Ukuran &nbsp;: &nbsp;Tersedia dalam 3 ukuran (besar, sedang, kecil)</li><li>Kunci &nbsp;: &nbsp;Solenoid dengan ketahanan beban sampai 220 Kg</li><li>Tipe Bukaan Kunci &nbsp;: &nbsp;Kartu dan Dynamic Key Lock</li><li>(PIN/Barcode yang dapat berubah-ubah secara dinamis)</li><li>Controller &nbsp;: &nbsp;Mainboard dengan daya tampung 64 loker</li><li>Sistem Data &nbsp;: &nbsp;Terintegrasi dengan cloud</li></ul><p>Spesifikasi Kartu NFC</p><ul><li>Ukuran non-volatile memory sebesar 4KB</li><li>Umur penyimpanan data 10 tahun</li><li>Umur baca/tulis 500.000 Cycle</li><li>Kecepatan pemindahan data 848 kbit/s</li><li>Jarak baca/tulis 10 cm</li><li>Frekuensi operasi 13,56 MHz</li><li>Ukuran identifier (UUID) 7 byte</li><li>Protokol ISO/IEC 14443A</li><li>Interface ISO/IEC 7816</li></ul><p>&nbsp;</p>',NULL,NULL,'yes',NULL,'ga','2021-07-07 09:19:00','2021-07-28 07:37:10',NULL,10,'boks',0,'','','',''),(14,'FID Reader','<p>Fusi Fixed RFID Reader is reliable long range UHF reader. It can be used for various application including asset management, gate system, security, etc.</p><figure class=\"image\"><img src=\"https://fusi.co.id/storage/89/FID-Reade-Handheld.jpg\"></figure><figure class=\"image\"><img src=\"https://fusi.co.id/storage/90/FID-Reader-Fixed.jpg\"></figure>','<figure class=\"table\"><table><tbody><tr><td><strong>AC input</strong></td><td>100V ~ 50Hz, 240V ~ 60Hz</td></tr><tr><td><strong>Reading Speed</strong></td><td>Up to 500 times/second</td></tr><tr><td><strong>Reading Distance</strong></td><td>0-15 m</td></tr><tr><td><strong>Enclosure</strong></td><td>Industrial Grade (IP53)</td></tr><tr><td><strong>Applications</strong></td><td>Asset management, warehouse management</td></tr></tbody></table></figure>',NULL,NULL,'yes',NULL,'ga','2021-07-07 10:17:37','2021-07-28 07:36:49',NULL,6,'rfid-reader',0,'','','',''),(15,'GPS Tracking','<p>Fusi GPS Tracker is smart product to trace exact location of vehicle or asset. The installation process is seamless and easy and already came with complete web dashboard/android apps. &nbsp;</p><figure class=\"image\"><img src=\"https://fusi.co.id/storage/88/GPS-Tracking.jpg\"></figure>','<ul><li>Input Voltage: 12VDC</li><li>Communication Module: BG96<ul><li>Quectel LTE Cat M1/Cat NB1/EGPRS with global frequency bands (B1/ B2/ B3/ B4/ B5/ B8/ B12/ B13/ B18/B19/ B20/&nbsp;B25/ B26*/ B28)</li><li>ultra-low power consumption</li></ul></li><li>GPS Specification:<ul><li>Support GLONASS, BeiDou/Compass, Galileo, QZSS standard positioning</li><li>Built in LNA to ensure fast locking</li></ul></li><li>WIFI/BLE support</li><li>Operating Temperature：-25℃~+85℃</li></ul>',NULL,NULL,'yes',NULL,'ga','2021-07-08 03:18:30','2021-07-28 07:36:24',NULL,8,'gps-tracker',0,'','','',''),(16,'Fuel Tracking','<p>Fusi Fuel Track is smart device to monitor fuel consumption of vehicle. The data will be sent into cloud and can be monitored real time via dashboard or apps. Using analytics we can detect any anomaly and also predict fuel usage. Combined together with GPS tracker and FusiERP you can have smart fleet management solution.&nbsp;</p><figure class=\"image\"><img src=\"https://fusi.co.id/storage/87/Fuel-Tracking.jpg\"></figure>','<ul><li>Fuel Consumption Sensor<ul><li>Flow rate range, 0.0085-0.85L/min</li><li>Maximum operating pressure,<strong> </strong>0.5MPa (When the liquid is at 20°C).</li></ul></li><li>Communication Module:<ul><li>Quectel LTE Cat M1/Cat NB1/EGPRS with global frequency bands (B1/ B2/ B3/ B4/ B5/ B8/ B12/ B13/ B18/B19/ B20/&nbsp;B25/ B26*/ B28)</li><li>ultra-low power consumption</li></ul></li><li>Power Input: 12V DC</li></ul>',NULL,NULL,'yes',NULL,'ga','2021-07-08 03:45:02','2021-07-28 07:36:01',NULL,5,'fuel-track',0,'','','',''),(17,'Rugged RFID Tag','<p>Rugged RFID Tag is an Outdoor Waterproof Rugged RFID Tag. It has ABS material and can be installed on metal survace. The tag is highly recommended for industrial asset management scenario</p><figure class=\"image\"><img src=\"https://fusi.co.id/storage/85/Rugged-RFID-Tag.jpg\"></figure>','<ul><li>Frequency 865-868MHZ/902-928MHZ UHF</li><li>EPC Gen2 Long Distance Rewritable Rugged UHF RFID ABS On Metal hard Tag</li><li>Material: ABS</li><li>Size: 155*26*14.5mm</li><li>Chip: Impinj Monza 4QT</li><li>Reading distance: 12-18m</li><li>Application: Metal parts ,warehouse management,asset managements</li></ul>',NULL,NULL,'yes',NULL,'ga','2021-07-08 05:08:59','2021-07-26 03:30:09',NULL,7,'rugged-rfid-tag',0,'','','',''),(18,'Intelli Pico','<p>Intelli Pico</p><figure class=\"image\"><img src=\"https://fusi.co.id/storage/123/Bikeshare-Pico.jpg\"></figure>',NULL,NULL,10,'yes',14,'ga','2021-09-01 10:07:59','2021-09-01 10:16:43',NULL,2,'intelli-pico',1,'no','yes','-','Intelli Pico'),(19,'Bikeshare Controller 1','<p>Bikeshare Controller</p><figure class=\"image\"><img src=\"https://fusi.co.id/storage/125/Bikeshare-Controller.jpg\"></figure>',NULL,NULL,10,'yes',14,'ga','2021-09-01 10:13:14','2021-09-09 10:33:59',NULL,2,'bikeshare-controller-1',1,'no','no','-','Bikeshare Controller 1'),(20,'Bikeshare Controller 2','<p>Bikeshare Controller 2</p><figure class=\"image\"><img src=\"https://fusi.co.id/storage/127/Bikesharing-Controller.jpg\"></figure>',NULL,NULL,10,'yes',14,'ga','2021-09-01 10:15:35','2021-09-01 10:15:35',NULL,2,'bikeshare-controller-2',1,'no','yes','-','Bikeshare Controller 2'),(21,'Bikeshare Docking Board','<p>Bikeshare Docking Board</p><figure class=\"image\"><img src=\"https://fusi.co.id/storage/130/Bikeshare-Docking-Board.jpg\"></figure>',NULL,NULL,10,'yes',14,'ga','2021-09-01 10:18:50','2021-09-01 10:18:50',NULL,2,'bikeshare-docking-board',1,'no','yes','-','Bikeshare Docking Board'),(22,'Bikeshare Docking Board','<p>Bikeshare Docking Board</p><figure class=\"image\"><img src=\"https://fusi.co.id/storage/130/Bikeshare-Docking-Board.jpg\"></figure>',NULL,NULL,10,'yes',14,'ga','2021-09-01 10:19:26','2021-09-01 10:20:02','2021-09-01 10:20:02',2,'bikeshare-docking-board',1,'no','yes','-','Bikeshare Docking Board'),(23,'Bikeshare Docking Board','<p>Bikeshare Docking Board</p><figure class=\"image\"><img src=\"https://fusi.co.id/storage/130/Bikeshare-Docking-Board.jpg\"></figure>',NULL,NULL,10,'yes',14,'ga','2021-09-01 10:19:46','2021-09-01 10:20:19','2021-09-01 10:20:19',2,'bikeshare-docking-board',1,'no','yes','-','Bikeshare Docking Board'),(24,'Smart Agriculture','<p>Smart Agriculture</p><figure class=\"image\"><img src=\"https://fusi.co.id/storage/133/PCB_Smart_Agriculture.jpg\"></figure><figure class=\"image\"><img src=\"https://fusi.co.id/storage/134/Smart-Agriculture.jpg\"></figure>',NULL,NULL,10,'yes',14,'ga','2021-09-01 10:21:40','2021-09-01 10:21:40',NULL,4,'smart-agriculture',1,'no','yes','-','Smart Agriculture'),(25,'TV Measurements','<p>TV Measurements</p><figure class=\"image\"><img src=\"https://fusi.co.id/storage/137/TV-Measurment-COntroller.jpg\"></figure>',NULL,NULL,10,'yes',14,'ga','2021-09-01 10:25:29','2021-09-01 10:25:29',NULL,4,'tv-measurements',1,'no','yes','-','TV Measurements'),(26,'Eltres','<figure class=\"image\"><img src=\"https://fusi.co.id/storage/140/Eltres_1.jpg\"></figure><figure class=\"image\"><img src=\"https://fusi.co.id/storage/139/Eltres_2.jpg\"></figure>',NULL,NULL,10,'yes',14,'ga','2021-09-02 15:35:47','2021-09-02 15:35:47',NULL,2,'eltres',1,'no','yes','-','Eltres'),(27,'Mobile Cognitive Radio Base Station (MCRBS)','<p>Mobile Cognitive Radio Base Station (MCRBS) allows the user to setup a Cellular Network base station for your communication during disaster recovery.&nbsp;</p>','<p><strong>Base Station Spesification</strong>&nbsp;</p><p>Support 2G, 3G, 4G, and 5G Standard in single tower continuous RF coverage from 70 MHz – 6 GHz Full duplex, MIMO (2 Tx &amp; 2 Rx) operation with up to 56 MHz of real-time bandwidth (61.44MS/s quadrature) Mobile Tower and Easy to deploy.</p><p>&nbsp;</p><p><strong>Antenna Specification</strong></p><p>Light, Compact and wideband Antenna</p><p>• Frek : 0.5 – 3.5 GHz</p><p>• Support : 2G, 3G, 4G and 5G</p><p>• RL≤-10 dB</p>',NULL,10,'yes',14,'ga','2021-09-10 14:27:59','2021-09-13 09:22:49',NULL,3,'Mobile-Cognitive-Radio-Base-Station-(MCRBS)',1,'no','no','-','Mobile Cognitive Radio Base Station (MCRBS)'),(28,'Flood Sensor','<p>The flood sensor measures the distance between itself and the surface of water. This sensor is frequently used in similar applications, such as measuring liquid level or detecting presence. The sensor ultrasound which rebound in the water and offers the system the distance between the node and the water. The water level of the river can be known by applying simple calculations.</p>','<p>CPU &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : LowPower 32-bit RISC microprocessors</p><p>Clock Speed&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : 80 MHz to 240 MHz</p><p>RF Comm Interface&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : Quad-band GSM / GPRS module, 800/900 /1800/1900 MHz Bluetooth v4.2 BR/EDR</p><p>GPS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : GNSS BDS, L1 (1575.42 Mhz) and L2 (1227.60 MHz).</p><p>Operating Condition&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : -20°C ~ +75°C with &lt; 90% RH</p><p>Dimension&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : 110 x 110 x 60 mm (LxWxH)</p><p>Power Supply&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : Grid Mode: AC 220V</p><p>Offgrid Mode&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : Solar Panel 50WP 12VDC,</p><p>Battery&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : 12000 mAH Lithium Ion</p>',NULL,10,'yes',14,'ga','2021-09-10 14:30:34','2021-09-13 09:23:22',NULL,1,'Flood-Sensor',1,'no','no','-','Flood Sensor'),(29,'Earthquake Sensor','<p>Earthquake Sensor detects the acceleration caused by an earthquake using a small built-in accelerometer and then calculates and outputs the synthetic acceleration, the estimated Japan Meteorological Agency seismic intensity scale (shindo scale) value, and the SI value, which is an estimation of damage to structures caused by earthquake motion.</p>','<p>CPU &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : LowPower 32-bit LX6 microprocessors</p><p>Clock Speed&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : 80 MHz to 240 MHz</p><p>RF Comm Interface&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : Quad-band GSM / GPRS module, 800/900 /1800/1900 MHz Bluetooth v4.2 BR/EDR</p><p>GPS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : GNSS BDS, L1 (1575.42 Mhz) and L2 (1227.60 MHz).</p><p>Operating Condition&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : -20°C ~ +75°C with &lt; 90% RH</p><p>Dimension&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : -20°C ~ +75°C with &lt; 90% RH</p><p>Power Supply&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : Grid Mode: AC 220V</p><p>Offgrid Mode&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : Solar Panel 50WP 12VDC</p><p>Battery&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : 12000 mAH Lithium Ion</p>',NULL,10,'yes',14,'ga','2021-09-10 14:31:39','2021-09-13 09:23:10',NULL,1,'Earthquake-Sensor',1,'no','no','-','Earthquake Sensor'),(30,'Landslide Sensor','<p>The ultrasound sensor measures the distance between itself and the surface of water. This sensor is frequently used in similar applications, such as measuring liquid level or detecting presence. The sensor emits ultrasonic waves which rebound in the water and offers the system the distance between the node and the water. The water level of the river can be known by applying simple calculations.</p>','<p>CPU &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : ATMega328P 2KB SRAM 1KB EEPROM microprocessors</p><p>Clock Speed&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : Up to 20 MHz</p><p>RF Comm Interface&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : Quad-band GSM / GPRS module, 800/900 /1800/1900 MHz</p><p>Temperature&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : -40°C ~ +80°C with &lt;0~90% RH</p><p>Soil Moisture&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : 0-100% m3/m3, Accuracy : 2%0-50%;</p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; Output signal: 4-210Ma, 0-5V, 0-2V, Respone Time: 1a</p><p>LVDT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : Length sensing 10mm</p><p>Accelerometer&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : 3-D Angular Velocuty, Range: 16g</p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; Resolution: 6.1e-5g, Attitude Stability Measurement: 0.01</p><p>Dimension&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : 400 x 600 x 200 mm (LxWxH)</p><p>Power Supply&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : Grid Mode: AC 220V</p><p>Offgrid Mode&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : Solar Panel 100WP 12VDC</p><p>Battery&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : 65 AH Lithium Ion</p>',NULL,10,'yes',14,'ga','2021-09-10 14:33:33','2021-09-13 09:23:02',NULL,1,'Landslide-Sensor',1,'no','no','-','Landslide Sensor'),(31,'Tsunami Sensor','<p>The ultrasound sensor measures the distance between itself and the surface of water. This sensor is frequently used in similar applications, such as measuring liquid level or detecting presence. The sensor emits ultrasonic waves which rebound in the water and offers the system the distance between the node and the water. The water level of the river can be known by applying simple calculations.</p>','<p>CPU &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : LowPower 32-bit LX6 microprocessors</p><p>Clock Speed&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : 80 MHz to 240 MHz</p><p>RF Comm Interface&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : Quad-band GSM / GPRS module, 800/900 /1800/1900 MHz Bluetooth v4.2 BR/EDR</p><p>GPS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : GNSS BDS, L1 (1575.42 Mhz) and L2 (1227.60 MHz)</p><p>Operating Condition&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : -20°C ~ +75°C with &lt; 90% RH</p><p>Dimension&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : 110 x 110 x 60 mm (LxWxH)</p><p>Power Supply&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : Grid Mode: AC 220V</p><p>Offgrid Mode&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : Solar Panel 50WP 12VDC</p><p>Battery&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : 12000 mAH Lithium Ion</p>',NULL,10,'yes',14,'ga','2021-09-10 14:34:25','2021-09-13 09:23:53',NULL,1,'Tsunami-Sensor',1,'no','no','-','Tsunami Sensor'),(32,'Socket NEMA 7 PIN','<p>-</p>','<p>Rated Voltage: &nbsp;480VAC/DC &nbsp;</p><p>Rated Current: &nbsp;15A &nbsp;</p><p>&nbsp;</p><p>Standard: &nbsp;ANSI C136.41 &nbsp;</p><p>UL standard: &nbsp;UL773 &nbsp;</p><p>Material: &nbsp;PC &nbsp;</p><p>Color: &nbsp;Grey</p>','75000',10,'yes',14,'ga','2021-09-21 09:31:09','2021-09-21 09:31:09',NULL,4,'socket-nema-7-pin',1,'no','no','-','Socket NEMA 7 PIN'),(33,'Smartlamp','<p>asdasdasd</p><figure class=\"image\"><img src=\"https://fusi.co.id/storage/179/Screenshot-(22).png\"></figure>','<p>asdasdasdasdasd</p>','2000',0,'yes',30,'eola','2022-02-15 14:07:02','2022-02-15 14:42:15',NULL,2,'asdasd',1,'no','yes','123123123','asdasdasd'),(34,'PCB Intelli v2','<p>-</p><figure class=\"image\"><img src=\"https://fusi.co.id/storage/181/Light-Contoller_1.jpg\"></figure><figure class=\"image\"><img src=\"https://fusi.co.id/storage/182/Light-Contoller_2.jpg\"></figure>','<p>-</p>',NULL,0,'yes',30,'ga','2022-02-15 14:31:04','2022-02-15 14:42:57',NULL,4,'pcb-intelli-v2',1,'no','yes','-','PCB Intelli v2');

--
-- Table structure for table `provinces`
--

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

--
-- Dumping data for table `provinces`
--


--
-- Table structure for table `qa_messages`
--

CREATE TABLE `qa_messages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `topic_id` bigint(20) unsigned NOT NULL,
  `sender_id` bigint(20) unsigned NOT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `qa_messages_topic_id_foreign` (`topic_id`),
  KEY `qa_messages_sender_id_foreign` (`sender_id`),
  CONSTRAINT `qa_messages_sender_id_foreign` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `qa_messages_topic_id_foreign` FOREIGN KEY (`topic_id`) REFERENCES `qa_topics` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `qa_messages`
--


--
-- Table structure for table `qa_topics`
--

CREATE TABLE `qa_topics` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `creator_id` bigint(20) unsigned NOT NULL,
  `receiver_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `qa_topics_creator_id_foreign` (`creator_id`),
  KEY `qa_topics_receiver_id_foreign` (`receiver_id`),
  CONSTRAINT `qa_topics_creator_id_foreign` FOREIGN KEY (`creator_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `qa_topics_receiver_id_foreign` FOREIGN KEY (`receiver_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `qa_topics`
--


--
-- Table structure for table `resource_categories`
--

CREATE TABLE `resource_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `resource_categories_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `resource_categories`
--

INSERT INTO `resource_categories` VALUES (1,'User Manual','user-manual','2021-07-01 04:52:31','2021-07-01 04:53:07',NULL),(2,'Datasheet','datasheet','2021-07-01 04:54:18','2021-07-01 04:54:18',NULL),(3,'brochure','brochure','2021-07-06 06:05:47','2021-07-06 06:05:47',NULL),(4,'presentation','presentation','2021-07-06 06:07:03','2021-07-06 06:07:03',NULL);

--
-- Table structure for table `resource_tag`
--

CREATE TABLE `resource_tag` (
  `resource_id` bigint(20) unsigned NOT NULL,
  `tag_id` bigint(20) unsigned NOT NULL,
  KEY `resource_id_fk_4236677` (`resource_id`),
  KEY `tag_id_fk_4236677` (`tag_id`),
  CONSTRAINT `resource_id_fk_4236677` FOREIGN KEY (`resource_id`) REFERENCES `resources` (`id`) ON DELETE CASCADE,
  CONSTRAINT `tag_id_fk_4236677` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `resource_tag`
--

INSERT INTO `resource_tag` VALUES (1,1),(3,2),(4,2),(5,4),(1,1),(3,2),(4,2),(5,4);

--
-- Table structure for table `resource_usecase`
--

CREATE TABLE `resource_usecase` (
  `usecase_id` bigint(20) unsigned NOT NULL,
  `resource_id` bigint(20) unsigned NOT NULL,
  KEY `usecase_id_fk_4236725` (`usecase_id`),
  KEY `resource_id_fk_4236725` (`resource_id`),
  CONSTRAINT `resource_id_fk_4236725` FOREIGN KEY (`resource_id`) REFERENCES `resources` (`id`) ON DELETE CASCADE,
  CONSTRAINT `usecase_id_fk_4236725` FOREIGN KEY (`usecase_id`) REFERENCES `usecases` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `resource_usecase`
--


--
-- Table structure for table `resources`
--

CREATE TABLE `resources` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `category_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `category_fk_4236676` (`category_id`),
  CONSTRAINT `category_fk_4236676` FOREIGN KEY (`category_id`) REFERENCES `resource_categories` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `resources`
--

INSERT INTO `resources` VALUES (1,'Intelli NB-IoT','2021-07-01 04:55:44','2021-07-01 04:55:44',NULL,1),(2,'Smart Water Meter','2021-07-06 06:08:39','2021-07-06 06:08:39',NULL,4),(3,'iwqu','2021-07-07 09:08:56','2021-07-07 09:08:56',NULL,4),(4,'boks','2021-07-07 09:11:06','2021-07-07 09:11:06',NULL,2),(5,'Fleet Management','2021-07-08 03:48:01','2021-07-08 03:48:01',NULL,4);

--
-- Table structure for table `role_user`
--

CREATE TABLE `role_user` (
  `user_id` bigint(20) unsigned NOT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  KEY `user_id_fk_4236588` (`user_id`),
  KEY `role_id_fk_4236588` (`role_id`),
  CONSTRAINT `role_id_fk_4236588` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_id_fk_4236588` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_user`
--

INSERT INTO `role_user` VALUES (1,1),(2,2),(3,2),(4,2),(5,1),(6,2),(7,2),(8,2),(9,2),(1,1),(2,2),(3,2),(4,2),(5,1),(6,2),(7,2),(8,2),(9,2),(11,2),(12,2),(13,2),(14,2);

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (1,'Admin',NULL,NULL,NULL),(2,'User',NULL,NULL,NULL);

--
-- Table structure for table `tag_usecase`
--

CREATE TABLE `tag_usecase` (
  `usecase_id` bigint(20) unsigned NOT NULL,
  `tag_id` bigint(20) unsigned NOT NULL,
  KEY `usecase_id_fk_4236726` (`usecase_id`),
  KEY `tag_id_fk_4236726` (`tag_id`),
  CONSTRAINT `tag_id_fk_4236726` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`) ON DELETE CASCADE,
  CONSTRAINT `usecase_id_fk_4236726` FOREIGN KEY (`usecase_id`) REFERENCES `usecases` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tag_usecase`
--

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

--
-- Table structure for table `tags`
--

CREATE TABLE `tags` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tags_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tags`
--

INSERT INTO `tags` VALUES (1,'User Manual','user-manual','2021-07-01 04:56:10','2021-07-01 04:56:10',NULL),(2,'Smart City','smartcity','2021-07-06 06:09:41','2021-07-06 06:09:41',NULL),(3,'Smart Agriculture','smart-agriculture','2021-07-06 06:10:39','2021-07-06 06:10:39',NULL),(4,'Industry 4.0','industry4','2021-07-06 06:10:52','2021-07-06 06:10:52',NULL),(5,'NB-IoT','nbiot','2021-07-06 06:11:14','2021-07-06 06:11:14',NULL),(6,'GSM','gsm','2021-07-06 06:11:22','2021-07-06 06:11:22',NULL),(7,'LoRA','lora','2021-07-06 06:11:40','2021-07-06 06:11:40',NULL),(8,'payment','payment','2021-07-06 06:12:01','2021-07-06 06:12:01',NULL),(9,'cloud','cloud','2021-07-06 06:13:49','2021-07-06 06:13:49',NULL),(10,'Big Data','big-data','2021-07-08 05:09:56','2021-07-08 05:09:56',NULL),(11,'Surveillance','surveillance','2021-07-08 05:10:08','2021-07-08 05:10:08',NULL),(12,'Hardware','hardware','2021-07-08 05:10:37','2021-07-08 05:10:37',NULL),(13,'Software','software','2021-07-08 05:10:50','2021-07-08 05:10:50',NULL),(14,'AI','ai','2021-07-08 05:10:59','2021-07-08 05:10:59',NULL),(15,'Machine Learning','machine-learning','2021-07-08 05:11:13','2021-07-08 05:11:13',NULL),(16,'Smart Home Technology','Smart-Home-Technology','2021-11-11 11:02:24','2021-11-11 11:02:24',NULL),(17,'Smart Village','Smart-Village','2021-11-11 11:02:31','2021-11-11 11:02:31',NULL),(18,'Mobile Apps','mobile-apps','2021-11-12 15:58:49','2021-11-12 15:58:49',NULL);

--
-- Table structure for table `usecase_categories`
--

CREATE TABLE `usecase_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `usecase_categories_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `usecase_categories`
--

INSERT INTO `usecase_categories` VALUES (1,'Smart City','smart-city','2021-07-01 10:52:29','2021-07-01 10:55:26',NULL),(2,'Smart Agriculture','smart-agriculture','2021-07-01 10:53:32','2021-07-01 10:53:32',NULL),(3,'Industry 4.0','industry-4.0','2021-07-01 10:54:41','2021-07-01 10:54:41',NULL),(4,'Smart Services','smart-services','2021-07-02 02:13:20','2021-07-02 02:13:20',NULL),(5,'Smart Home Technology','Smart-Home-Technology','2021-11-10 10:46:15','2021-11-10 10:46:15',NULL),(6,'Smart Village','Smart-Village','2021-11-10 13:45:45','2021-11-10 13:45:45',NULL);

--
-- Table structure for table `usecases`
--

CREATE TABLE `usecases` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `category_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `category_fk_4236722` (`category_id`),
  CONSTRAINT `category_fk_4236722` FOREIGN KEY (`category_id`) REFERENCES `usecase_categories` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `usecases`
--

INSERT INTO `usecases` VALUES (1,'E Bikesharing','<h3>Why do we need Bike Sharing?</h3>\n<p>Kebanyakan dari kita bepergian dengan berkendara atau naik kendaraan umum, tetapi bagaimana jika ada cara yang lebih mudah? Dengan menggunakan layanan Bike Sharing, anda dapat melakukan perjalanan dari ujung ke ujung kota dengan mudah, murah, dan ramah lingkungan tanpa harus mencari tempat parkir maupun mengisi bahan bakar. Pergi ke kantor, ke tempat-tempat umum, atau sekadar bersepeda, Bike Sharing sangat cocok untuk kebutuhan anda.</p>\n\n<h3>Where can I find Bike Sharing?</h3>\n<p>Alasan memilih Bike Sharing adalah karena kemudahannya bagi orang-orang yang tinggal di perkotaan. Jika Anda tinggal di dekat halte bus, anda tidak perlu berjalan terlalu jauh. Jika Anda tinggal di dekat stasiun kereta, MRT, LRT seringkali ada banyak shelter yang mudah dijangkau.</p>\n\n<figure class=\"image\"><img width=\"50%\" src=\"https://fusi.co.id/new/storage/33/WhatsApp-Image-2020-01-31-at-11.20.03.jpeg\"></figure>\n\n<h3>How does it work?</h3>\n<p>Menyewa Bike Sharing sangatlah mudah, anda hanya perlu mendaftar melalui shelter dan melakukan pembayaran menggunakan e-money. Anda dapat meminjam sepeda yang tersedia di semua shelter Bike Sharing.</p>\n\n<h3>Reducing our Environmental Impact</h3>\n<p>Ingin memiliki gaya hidup ramah lingkungan? Mudah kok. Dengan bersepeda, anda sudah berperan dalam mengurangi emisi karbon serta mengurangi konsumsi bahan bakar.</p>\n\n<h3>Get exercise, have more fun.</h3>\n<p>Ketika kita memikirkan olahraga, pikiran kita adalah berkeringat di atas treadmill di gym yang membosankan. Dengan bersepeda, olahraga bisa jauh lebih menyenangkan.</p>\n<p>Bukankah indah, menjaga kebugaran tubuh sembari melihat dan menikmati setiap sudut kota?</p>\n\n<p>&nbsp;</p>\n\n<h3>Our Bikesharing Solution</h3>\n<p>Bikeshare 5G is Fusi solution for bikesharing platform. It\'s called hybrid system because it\'s combine benefit from robustness of old docking bikesharing system with flexibility of latest dockless system. To understand the advantages we can see the diagram below</p><figure class=\"image\"><img src=\"https://fusi.co.id/new/storage/28/image.png\"></figure>\n<figure class=\"image\"><img src=\"https://fusi.co.id/new/storage/29/image.png\"><figcaption>Docking Problem</figcaption></figure><figure class=\"image\"><img src=\"https://fusi.co.id/new/storage/30/image.png\"><figcaption>Dockless Problem</figcaption></figure><p>&nbsp;</p>','2021-07-02 02:17:01','2021-07-13 03:00:44',NULL,1),(2,'Smart Agriculture','<p>Smart Agriculture is integrated system solution to improve yield and efficiency on farming. It combines hardware and software AI to perform precision task. Main task that can be handled is:</p><ul><li>Fertigation. It\'s the key activity of farming which combine watering and applying fertilizer to the plant.</li><li>Analytic based on feedback from several sensor (soil humidity, pH, Light intensity, etc)</li><li>Insecticide distribution</li><li>Crop prediction</li></ul><figure class=\"image\"><img src=\"https://fusi.co.id/storage/157/smart-farm.jpg\"></figure>','2021-07-07 08:32:50','2021-11-10 11:44:02',NULL,2),(3,'Batching Plant Smart Controller','<p>Batching Plant Smart Controller is one of Fusi Industrial customized solution which tailored for batching plant factory. &nbsp;The system will enabling automation on any cement mixing platform including integration with ERP system. The controller designed to be able to interact with any sensor/actuator/relay and perform weighing, dumping, and mixing material with utmost precision. &nbsp;</p><p>It brings many advantages such as:</p><ul><li>Perform task efficiently and accurate</li><li>Auto report system</li><li>online monitoring&nbsp;</li><li>Fraud prevention</li><li>Seamless process start from customer purchase order until delivery</li><li>Support on premise delivery</li></ul><figure class=\"image\"><img src=\"https://fusi.co.id/new/storage/50/image.png\"><figcaption>System Diagram</figcaption></figure><p>&nbsp;</p><p>&nbsp;</p>','2021-07-07 08:47:28','2021-07-07 08:47:28',NULL,3),(4,'Early Warning System','<p>Fusi Early Warning System is a series of systems (consist of devices and applications) to notify the occurrence of natural events, which can be in the form of disasters or other natural signs. Early warning to the public on disasters is an act of providing information in language that is easily digested by the community.</p>\n\n<p>In critical situations, in general, early warning which is the delivery of information is manifested in the form of sirens, gongs and so on. However, hiding sirens is only part of the form of conveying information that needs to be done because there is no other faster way to deliver information to the public. The hope is that the public can respond to the information quickly and accurately. The alertness and speed of the public\'s reaction is needed because of the limited time from when the information is issued to the time (allegedly) the disaster will occur. Critical conditions, limited time, major disasters and saving residents are factors that require early warning. The earlier the information is submitted, the less time for the population to respond.</p>\n\n<p>The release of information about hazard conditions is the estuary of a process flow for analyzing raw data about disaster sources and synthesizing various considerations. Information accuracy can only be achieved if the quality of analysis and synthesis that leads to the release of information has high accuracy. Thus, in this case there are two main parts in early warning, namely the upstream part in the form of efforts to package data into accurate information and downstream in the form of efforts to quickly reach the community.</p>\n\n<div class=\"row\">\n<div class=\"col-md-4\">\n<figure class=\"image\"><img src=\"https://fusi.co.id/new/storage/58/image.png\"></figure>\n</div>\n<div class=\"col-md-4\">\n<figure class=\"image\"><img src=\"https://fusi.co.id/new/storage/59/image.png\"></figure>\n</div>\n<div class=\"col-md-4\">\n<figure class=\"image\"><img src=\"https://fusi.co.id/new/storage/60/image.png\"></figure>\n</div>\n</div>\n','2021-07-07 10:32:52','2021-08-03 10:27:26',NULL,1),(5,'Fleet Management System','<p>IO Fleet Management Solutions provides complete mobile asset tracking and management tools that provide complete return on investment typically in less than one year. Hard dollar savings in fuel, vehicle miles driven, and worker overtime are obvious benefits. In addition, fewer accidents, improved driver behavior and better execution of corporate and agency mandates deliver even more value to the organization.</p><p>IO Fleet Management solution is multi-layer technology consist of GPS Tracker, several IoT devices or sensor combined with Cloud Analytic and also ERP.</p><figure class=\"image\"><img src=\"https://fusi.co.id/new/storage/20/image.png\"><figcaption>IO Fleet Management Architechture</figcaption></figure><figure class=\"image\"><img src=\"https://fusi.co.id/new/storage/23/image.png\"></figure><ul><li>FusiERP, provide flexible module to be integrated<ul><li>CRM</li><li>Projects</li><li>Helpdesk</li><li>Asset Management</li><li>Accounting</li><li>Manufacturing</li><li>Sales and Purchase</li></ul></li><li>Fuel Consumption Sensor<ul><li>Flow rate range, 0.0085-0.85L/min</li><li>Maximum operating pressure,<strong> </strong>0.5MPa (When the liquid is at 20°C).</li></ul></li><li>Communication Module: BG96<ul><li>Quectel LTE Cat M1/Cat NB1/EGPRS with global frequency bands (B1/ B2/ B3/ B4/ B5/ B8/ B12/ B13/ B18/B19/ B20/&nbsp;B25/ B26*/ B28)</li><li>ultra-low power consumption</li><li>GPS, GLONASS, BeiDou/Compass, Galileo, QZSS standard positioning</li></ul></li><li>GPS Specification<ul><li>Ultra low power consumpti on in tracking mode, 20mA</li><li>High sensiti vity: -165dBm @Tracking, -148dBm @Acquisiti on</li><li>66 acquisiti on channels, 22 tracking channels</li><li>Support QZSS</li></ul></li></ul>','2021-07-08 03:05:19','2021-07-08 05:37:00',NULL,3),(6,'TV Audience Measurement','<p><strong>TV RHYME</strong>&nbsp;is custom service solution to provide smart way on survey and data acquisition. It\'s an&nbsp;audience<a href=\"https://en.wikipedia.org/wiki/Audience_measurement\"> </a>measurement&nbsp;tool used to measure the viewing habits of&nbsp;TV&nbsp;and&nbsp;cable&nbsp;audiences. By understanding what and how user watching it will help to guarantee successful marketing campaign.&nbsp;</p><p>What’s being measured?</p><ul><li>User profile (age, sex, etc)</li><li>Viewing status</li></ul><figure class=\"image\"><img src=\"https://fusi.co.id/new/storage/67/image.png\"></figure><figure class=\"image\"><img src=\"https://fusi.co.id/new/storage/65/image.png\"></figure><p>&nbsp;</p><figure class=\"image\"><img src=\"https://fusi.co.id/new/storage/66/image.png\"></figure><p>Features:</p><ul><li>Support up to 99 channel* and 8 user*</li><li>Compatible with any TV from any manufacturer including analog TV, Digital TV (Cable, Antenna, Sattelite), and STB</li><li>Fault protection using Current sensing</li><li>Can be integrated with wearable BLE devices for auto user detection</li></ul><p>Specification:</p><ul><li>CPU: 1.2 GHZ quad-core ARM Cortex A53</li><li>Memory: 1 GB LPDDR2-900 SDRAM.</li><li>Support up to 999 channel and 8 user</li><li>Connectivity:<ul><li>10/100 MBPS Ethernet,</li><li>802.11n Wireless LAN</li><li>Bluetooth V 4.0</li></ul></li><li>Universal IR Transmitter, compatible with any analog TV, Digital TV (DVB), STB</li><li>Fault protection<ul><li>Current sensing</li><li>IR scanning</li></ul></li><li>Power consumption<ul><li>Base Unit 15 W /AC 220V input (15 W)</li><li>Remote&nbsp; &lt;5mW in active state/ DC 4.5 V (3x AAA batteries)</li></ul></li><li>Dimension WxHxL (mm)= 102x54x192</li></ul><p>&nbsp;</p>','2021-07-08 04:58:29','2021-07-08 05:37:22',NULL,4),(7,'Smart Education','<p>Smart education is a complete service solution for school or university. There are several services that running:</p><ul><li>Smart Tuition Payment</li><li>CoVID-19 scanner and auto hand sanitizer</li><li>Smart absence</li><li>educationERP</li></ul><p>&nbsp;</p><p>&nbsp;</p>','2021-07-08 05:25:44','2021-07-08 05:25:44',NULL,4),(8,'Industrial Mining IoT Solutions','<p>The intelligent networking of machines and processes in industry with the aid of information and communication technology. Industry 4.0 is the integration of data, artificial intelligence, machinery and communication to create an efficient industrial ecosystem that is not just automated but intelligent.</p><p>IoT Architecture Diagram:</p><figure class=\"image\"><img src=\"https://fusi.co.id/storage/98/Picture2.png\"></figure><p>&nbsp;</p><p>Fusi Industrial Solution Matrix:</p><p>ï¿½Fleet Management</p><p>ï¿½GPS Tracker</p><p>ï¿½Fuel Consumption</p><p>ï¿½Fusi Industrial Controller</p><p>&nbsp;</p><p>Fusi Industrial Solution:</p><p>Fusi Industrial Controller</p><p>Spesifikasi :</p><ul><li>CPU:<ul><li>Intel Celeron up to i7, RAM 4-8 GB, HDD</li><li>Embedded: LowPower 32-bit LX6 microprocessors&nbsp; 2 core</li></ul></li><li>Power<ul><li>Input 220V AC</li><li>Consumption 100 Watt</li></ul></li><li>RF Interface<ul><li>BLE</li><li>WIFI</li><li>GSM</li><li>LoRA</li></ul></li><li>IO interface<ul><li>SD card, UART, SPI, SDIO, I2C, LED PWM, Motor PWM, I2S, IR, pulse counter, GPIO, capacitive touch sensor, ADC, DAC</li><li>Relay</li></ul></li><li>Operating temperature 0 ï¿½C ~ +80 ï¿½C</li></ul><p>Fitur:</p><p>- Industrial Grade</p><p>- Support any industrial protocol: Modbus, CAN Bus</p><p>- Using modular form make it adaptive to any solution&nbsp;</p><p>&nbsp;</p><p>Fusi Intelli Module:</p><p>ï¿½Intelli Energy Meter Shield</p><p>ï¿½Intelli NB IoT shield</p><p>ï¿½Intelli GSM Shield</p><p>ï¿½Intelli LoRA Shield</p>','2021-08-04 08:26:40','2021-08-04 08:27:35',NULL,3),(9,'Building Monitoring System','<p>The Building Monitoring System is a computer-based control system installed in buildings that controls and monitors the building\'s mechanical and electrical equipment such as ventilation, lighting, power systems, fire systems, and security systems.</p><figure class=\"image\"><img src=\"https://fusi.co.id/storage/144/Building-Monitoring-Systems.png\"></figure>','2021-10-22 15:49:03','2021-10-22 15:56:03',NULL,3),(10,'Automated Hydroponics System','<p>Hydroponic farming is a method of growing crops without soil, with the main benefits of environmental and nutrient control, water conservation, and reduction of labor. This technique relies on a number of technologies that the principles of automation can be applied in order to improve yield and consistency. Many of the aspects that make hydroponic farming so efficient can also make it challenging to implement. Water and nutrients must be provided in a balanced ratio while being constantly monitored and adjusted as plants develop. Temperature regulation can also become a problem since the circulating water system acts as a heat pump. Additionally, the microbial communities that can benefit or harm your crops are now competing in an aqueous rather than a terrestrial environment, sending us even further into unknown and potentially dangerous territory. And to make matters worse, if you have a prolonged power outage, you may need to manually water or have a generator to keep the water pump going, else you may injure your crops.&nbsp;<br>Although there are several different hydroponic and cultivation techniques, the application of automation principles to monitor and manage greenhouses and hydroponics is very useful.</p><p>At the core of this automated hydroponic system is the Raspberry Pi single board computer. This $35 computer is only the size of a deck of playing cards, but it has all the components you would find in a full computer, including CPU, RAM, video/audio output, USB, WiFi, Bluetooth, Ethernet, and micro SD slot. The most important feature of the Raspberry Pi for our application is its general purpose input-output (GPIO) pins, which will be used to connect inputs, such as switches and sensors to measure the environment, and outputs such as pumps and relays to move liquids and control electrical devices that will manipulate the environment.</p><figure class=\"image\"><img src=\"https://fusi.co.id/storage/147/automated-hydroponics-system.jpg\"></figure><p>Fusi has developed automation technology for hydroponic systems that include water sensors and nutrient sensors. This device is applied to greenhouses which in the future will be developed with several sensors such as:</p><p>- water and nutrition sensors</p><p>- humidity sensor</p><p>- temperature sensor</p><p>- CO2 sensor sensor</p><p>- LED sensors</p><figure class=\"image\"><img src=\"https://fusi.co.id/storage/149/Sistem-Otomasi-Hidroponik.jpg\"><figcaption>Controller untuk Sistem Otomasi Greenhouse Fusi</figcaption></figure>','2021-11-10 10:13:26','2021-11-10 10:22:41',NULL,2),(11,'Smart Traffic Control System','<p>Smart Traffic Management System is a smart system that runs traffic lights automatically. This system takes traffic data as input in the form of calculating the number of vehicles through the camera, the camera has been integrated and can perform digital image processing or Image Processing. The system as a whole will run automatically without any further intervention, such as the manual setting of traffic lights by officers as is happening now.</p><p>This system includes:</p><p>- Touchless technology for all buttons on the road</p><p>- Smart pedestrian crossings</p><p>- The new Real Time Optimizer (RTO)</p><p>RTO system will change how these timings are optimized by taking into account a much greater variety of rich data sources, covering all road users rather than just motor vehicles.</p><figure class=\"image\"><img src=\"https://fusi.co.id/storage/152/smart_traffic_control.jpg\"></figure>','2021-11-10 10:56:45','2021-11-10 10:56:45',NULL,1),(12,'Agriculture Drone','<p>An agricultural drone is an unmanned aerial vehicle used to help optimize agriculture operations, increase crop production, and monitor crop growth. Sensors and digital imaging capabilities can give farmers a richer picture of their fields. Using an agriculture drone and gathering information from it may prove useful in improving crop yields and farm efficiency.</p><figure class=\"image\"><img src=\"https://fusi.co.id/storage/154/agricultural-drone.jpg\"></figure><p>The aerial view provided by a drone can reveal many issues such as irrigation problems, soil variation, and pest and fungal infestations. Multispectral images show a near-infrared view as well as a visual spectrum view. The combination shows the farmer the differences between healthy and unhealthy plants, a difference not always clearly visible to the human eye. Thus, these views can assist in assessing crop growth and production. Crops can be surveyed at any time using agricultural drones, allowing for rapid identification of problems.</p><figure class=\"image\"><img src=\"https://fusi.co.id/storage/155/drone-imagery.jpg\"></figure>','2021-11-10 11:25:42','2021-11-10 11:25:42',NULL,2),(13,'Waste Management System','<h3>Introducing the Waste Management System: A New Way to Manage Your Waste</h3>\n\n<p>Utilization of automation in waste management systems serves several advantages such as improved productivity, reduces time and resource utilization, increased efficiency over manual system. Most smart waste management process adapts some processes of the traditional waste management but includes innovation and new technology in performing its action. Smart waste management involves an innovative approach that involves the use of information and communication technology (ICT) to making strategic decisions with respect to waste characterization, waste generation, waste collection, transportation of waste, waste treatment and waste disposal processes.Combating the waste issues due to development, a large amount of data is involved because of this automated data acquisition, communication, identification, and storage, are used for easier analysis. Several sensor technologies today are embedded into waste management systems such as infrared sensors, metal detectors and odor receptors for monitoring.</p><figure class=\"image\"><img src=\"https://www.researchgate.net/profile/Charith-Perera-2/publication/315492466/figure/fig2/AS:613934444843015@1523384786238/Efficient-waste-management-in-Smart-Cities.png\"></figure>\n\n<p>Ketika anda memikirkan pembuangan sampah, apa yang pertama kali terlintas di benak anda? Kemungkinan besar, anda membayangkan tempat sampah kuno dengan potongan-potongan sampah yang dibuang sembarangan oleh orang yang lewat. Tapi itu tidak lagi berlaku untuk waste management system, cara baru untuk membuang sampah anda! Waste management system adalah bagian penting dari sebagian besar bisnis, organisasi, dan bahkan rumah tangga karena anda tidak dapat membuang sampah kecuali anda tahu cara membuangnya dengan benar. Seperti pepatah lama, Jika anda membuangnya dan tidak ada yang mengambilnya, apakah sampah itu benar-benar hilang?\nTempat pembuangan sampah telah ada sejak zaman prasejarah, dan masih menjadi salah satu cara paling umum untuk membuang sampah saat ini. Namun, ketika orang menjadi lebih sadar lingkungan, mereka mencari cara untuk mendaur ulang, menggunakan kembali, dan mengelola limbah mereka dengan cara yang tidak terlalu berbahaya bagi lingkungan. Waste management system ada di sini untuk membantu anda mengetahui bagaimana anda dapat menggunakan limbah untuk keuntungan anda.</p>\n\n<h5>What is the Waste Management System?</h5>\n<p>Waste management system adalah sistem baru yang membantu anda mengelola sampah dengan cara yang lebih baik. Dengan sistem ini, kini anda dapat mengontrol di mana dan kapan sampah anda dibuang ke TPA serta berapa banyak uang yang anda keluarkan untuk itu.</p>\n\n<h5>Why Do We Need a Waste Management System?</h5>\n<p>Masalah sampah kita hanya akan bertambah buruk di tahun-tahun mendatang. Jumlah sampah yang sama yang kita hasilkan sekarang akan berlipat ganda dalam 10 tahun. Ketika anda mempertimbangkan bahwa sekitar 80% sampah kita berakhir di tempat pembuangan sampah, jelas kita membutuhkan sistem yang berbeda jika kita ingin melestarikan planet kita dan sumber dayanya untuk generasi mendatang. Ketika sampai pada itu, metode lama kita tidak berkelanjutan. Bagaimana jika ada cara yang lebih mudah? Waste management system dapat menjawab semua itu.</p>\n\n<h5>Who can use it?</h5>\n<p>Waste management system dapat digunakan oleh semua orang dimanapun anda ingin membuang sampah, baik itu di rumah, di sekolah, di stasiun, di kantor, maupun di pabrik. anda dapat mengintegrasikannya di seluruh penjuru kota sehingga kota anda menjadi lebih bersih. </p>\n\n<h5>How does it work?</h5>\nWaste management system melibatkan pendekatan inovatif yang melibatkan penggunaan teknologi informasi dan komunikasi untuk membuat keputusan strategis terkait dengan karakterisasi sampah, timbulan sampah, pengumpulan sampah, pengangkutan sampah, pengolahan sampah, dan proses pembuangan sampah. Tong sampah terbuat dari stainless steel berkualitas tinggi, yang membuatnya tahan terhadap karat, korosi, dan asam. Beberapa teknologi sensor diterapkan ke dalam waste management system seperti sensor inframerah, detektor logam, dan reseptor bau untuk pemantauan.</p>\n\n<h5>Why is it better than other ways of managing waste?</p>\n<p>Waste management system lebih efektif dibandingkan metode lain seperti TPA. Waste management system juga jauh lebih murah daripada menjalankan TPA. Selain itu, meminimalkan polusi dan gas berbahaya yang dilepaskan ke lingkungan kita.</p>\n\n<h5>Automating Waste Collection in Factories</h5>\n<p>Apakah anda lelah mengumpulkan limbah secara manual dari mesin anda dan membuangnya? Jika demikian, maka waste management system kami sangat cocok untuk anda. Ini menampilkan sejumlah fitur cerdas yang dapat membantu menghilangkan kesalahan manusia saat menangani bahan berbahaya di pabrik.</p>\n\n<h5>Monitoring Street Bins at University Campus, Park, or City Center</h5>\n<p>Bagi banyak organisasi pengelolaan limbah, mengumpulkan dan memantau tempat sampah adalah hal yang merepotkan. Dengan begitu banyak tempat sampah, sulit untuk melacak di mana setiap tempat sampah berada. Seringkali, barang-barang tidak didaur ulang atau tidak dibuang dengan benar, organisasi pengelolaan limbah dapat memberitahu anda tentang semua barang yang dapat didaur ulang yang berakhir di tempat pembuangan sampah yang berarti lebih banyak biaya untuk semua orang yang terlibat. Waste management system akan mempermudah dalam mengelompokkan sampah-sampah tersebut, serta menghubungkannya dengan tempat-tempat seperti pengolahan limbah tertentu dan tempat daur ulang melalui teknologi informasi sehingga koordinasi akan lebih mudah.</p>\n','2021-11-10 12:02:02','2021-11-10 12:02:02',NULL,1),(14,'Home Remote Control','<p>Settings on Smart Home are done by relying on an internet connection with a mobile device (smartphone) as the media/remote. Therefore, a smart home system connects all devices in the house, allowing residents to control various functions such as security access to the house, room temperature, lighting, turning on the air conditioner, turning off the TV and even the home theater remotely. In appearance, a house equipped with a smart home system looks no different from a conventional house. Interestingly, there are also those who embed the mood lamp feature in the smart home system. This feature functions to change the color of the lights in the room, and can be set lighter or dimmer according to the needs of the occupants. These various conveniences certainly make the existence of a smart home system provide qualified comfort. Even when the occupants leave the house, they don\'t have to worry because they can control the security system at any time.</p><figure class=\"image\"><img src=\"https://fusi.co.id/storage/159/smart-home-automation.jpg\"></figure>','2021-11-10 12:36:30','2021-11-10 12:36:30',NULL,5),(15,'Smart Street Lamp','<p>A smart streetlight is a public lighting fixture that incorporates technology, such as cameras, light-sensing photocells and other sensors, to introduce real-time monitoring functionalities. Also referred to as adaptive lighting or intelligent street lighting, this type of lighting system is recognized as a significant step in the development of smart cities.</p><p>Fusi Smart Street Lamp is smart lighting controller using standard NEMA socket which will enhance the capability of any Street Lamp. The communication module is using latest IoT technology (NB-IoT/GSM and LoRA) and can be configured according to user requirement. Thus provide great flexibility and ease on deployment.</p><figure class=\"image\"><img src=\"https://fusi.co.id/storage/161/Smart-Lamp_1.jpg\"></figure>','2021-11-10 12:41:30','2021-11-10 12:41:30',NULL,1),(16,'Smart Water Management','<h3>Is Your Water Bill High? A Smart Water Meter May Be The Solution</h3>\n\n<p>The water system of a city is one of the most important aspects for building future smart cities. Effective and energy-efficient transportation and use of water, and cost-effective and environment-friendly treatment of wastewater are critical in smart water management at city-scales. A smart water system is expected to help monitor citywide water consumption, transportation, prediction of future water use, and so on. For example, Figure 4 describes the needs of water harvesting and ground water monitoring, which will rely on the support from Fog/Cloud computing infrastructure, such as wireless sensors, smart meters, GPS devices, Fog gateways, Cloud platforms, IPv6 technology and long-distance communication protocols like 3G, 4G, LTE, etc. On top of all these useful aspects of the city water network, the smart water system is expected to analyze collected information and generate actionable data for management, reduction of water losses and other improvements of the city water system.</p><figure class=\"image\"><img src=\"https://fusi.co.id/storage/163/Smart-Water-Management.png\"></figure>\n\n<p>Apakah anda frustasi dengan tagihan air anda yang terus meningkat? Jika demikian, anda mungkin ingin berinvestasi dalam meteran air pintar untuk membantu mengurangi penggunaan air anda dan menghindari membayar lebih dari yang anda perlukan setiap bulan. Smart water meter memungkinkan anda mengetahui berapa banyak air yang anda gunakan secara berkala, menyesuaikan pada kehidupan sehari-hari dan menghemat uang pada saat yang bersamaan.</p>\n\n<h5>Why should I buy a smart water meter?</h5>\n<p>Pemilik rumah sering mengeluh tentang tagihan air mereka yang tiba-tiba tinggi. Terkadang ada masalah pada meteran atau perpipaan. Tetapi seringkali ketika membayar berdasarkan penggunaan, orang tidak tahu berapa banyak air yang mereka gunakan. Dengan memasang smart water meter, anda dapat dengan mudah melacak penggunaan air di rumah anda dan menyesuaikan agar biaya menjadi lebih rendah.</p>\n\n<h5>How does it work?</h5>\n<p>Tidak seperti meteran air tradisional, yang memberi anda informasi setiap dua bulan sekali, smart water meter dapat memantau penggunaan air anda 24/7. Karena teknologinya yang canggih, smart water meter dapat mendeteksi kebocoran jauh lebih cepat daripada meteran tradisional. Katup dapat dikendalikan dari jarak jauh ke posisi ON atau OFF melalui aplikasi. Jika kebocoran terdeteksi, anda akan segera mendapat pemberitahuan sehingga anda dapat segera memperbaikinya dan menghindari potensi kerusakan pada rumah anda atau aset lainnya.</p>\n\n<h5>Which places can use a smart water meter?</h5>\n<p>Beberapa pemilik properti dapat memasang smart water meter untuk menghemat penggunaan air dan menghemat uang. Meskipun smart water meter dapat digunakan hampir di mana saja, alat ini sangat berguna untuk properti komersial besar seperti gedung perkantoran dan kompleks industri yang menggunakan air dalam jumlah besar. Sistem otomatis sangat bermanfaat bagi bisnis yang memiliki penggunaan air yang berfluktuasi dari waktu ke waktu.</p>\n\n<h5>Potential benefits of installing a smart water meter</h5>\n<p>Untuk pemilik rumah, smart water meter dapat membuat tagihan listrik yang lebih rendah. Karena penggunaan air bervariasi dari bulan ke bulan, pemilik rumah dengan smart meter akan menerima informasi penggunaan air yang sebenarnya dengan lebih akurat dari waktu ke waktu. Hal ini berarti mereka akan lebih siap untuk melacak konsumsi mereka dan membuat keputusan yang lebih cerdas tentang bagaimana mereka menggunakan air setiap bulan.</p>\n\n<p>Memiliki meteran air pintar yang dipasang di rumah anda dapat membawa sejumlah manfaat bagi anda, termasuk: kenyamanan yang lebih baik dan informasi yang lebih akurat. Smart water meter memberi anda akses terhadap penggunaan air anda melalui aplikasi di ponsel atau komputer anda, memberi anda lebih banyak waktu untuk menganalisis pola penggunaan anda dan menyesuaikannya. Dengan lebih banyak informasi di tangan, anda akan dapat menghemat uang sambil tetap yakin bahwa anda memiliki cukup air yang tersedia untuk pekerjaan apa pun yang perlu dilakukan di sekitar rumah, apartemen, atau kantor anda.</p>\n','2021-11-10 12:58:38','2021-11-10 12:58:38',NULL,1),(17,'Smart Irrigation System','<p>Smart irrigation systems are a combination of an advanced technology of sprinklers with nozzles that improve coverage and irrigation controllers that are watering and water conservation systems that monitor moisture-related conditions on your property and automatically adjust watering to optimal levels.</p><p>There are two general types of smart irrigation technology: weather based and soil moisture based. Both can help you save water, but there are some important differences.</p><p>1. Weather-Based Irrigation System &nbsp;</p><p>Weather-based irrigation system includes either a mini on-site weather station or weather sensor capable of monitoring conditions such as temperature, rainfall, and solar radiation on your property, or this same information is broadcast to the irrigation controller from a remote weather site.</p><figure class=\"image\"><img src=\"https://fusi.co.id/storage/167/weather-based-irrigation-syste,.jpg\"></figure><p>2. Moisture-Based System &nbsp;</p><p>This technology uses sensors to measure the actual moisture content of the soil. It then adjusts the time of irrigation water based on this data. As with weather-based systems, moisture-based systems are marketed both as integrated controllers and as add-on technology. Prices for this type of system vary considerably, from a couple hundred to thousands of dollars.</p><p>&nbsp;</p><figure class=\"image\"><img src=\"https://fusi.co.id/storage/166/moisture-based-irrigation-system-(2).jpg\"></figure>','2021-11-11 10:12:36','2021-11-11 10:12:36',NULL,6),(18,'Integrated Farming System','<p>&nbsp;</p><figure class=\"image\"><img src=\"https://fusi.co.id/storage/172/integrated-farming-system.gif\"></figure><p>Integrated farming system is an agricultural system which combines the activities of crops and horticulture, animal husbandry, fishery, forestry and other sciences related to agriculture within an area simultaneously at a time or so. Developing an integrated farming system needs an appropriate technology, because such technology is partly important in sustainable farming and food security. As a tool, it is necessary to think about how to help farmers improve the quality of their crops. Technology also needs to be considered as a solution to overcome and to balance decrease in food production due to decrease of agricultural land. Some countries with small land are still able to overcome their food problem because of technology. Crop production can increase if irrigated areas are expanded or irrigation is intensified, but these may increase the rate of environmental degradation.&nbsp;</p><figure class=\"image\"><img src=\"https://fusi.co.id/storage/170/rsz_integrated-farming-system.jpg\"></figure>\n\n<p>Anda pasti pernah mendengar tentang makanan organik dan alami, tetapi bagaimana dengan integrated farming system? Meskipun anda mungkin tidak mengetahuinya, cara makanan diproduksi dan didistribusikan selama beberapa dekade terakhir telah menciptakan sistem pangan yang tidak berkelanjutan yang dapat menyebabkan malapetaka bagi lingkungan dan generasi masa depan manusia dan hewan. Untungnya, ada cara berkelanjutan untuk menanam dan mendistribusikan makanan kita yang benar-benar menurunkan biaya sambil tetap mempertahankan kontrol kualitas. Salah satu contoh yang bagus adalah integrated farming system (IFS). Inilah semua yang perlu anda ketahui tentang IFS dan bagaimana mereka dapat mengubah cara kita menanam makanan.</p>\n\n<h5>The Modern Farms of Today</h5>\n<p>Pertumbuhan populasi menempatkan tekanan yang signifikan pada kemampuan pertanian untuk menghasilkan makanan yang cukup. Tetapi teknologi menemukan cara untuk membantu petani mengadaptasi metode produksi mereka dengan cara yang inovatif. Dan di antara inovasi ini adalah pertanian terpadu atau integrated farming, yang mungkin menjadi salah satu harapan terbaik pertanian untuk pertumbuhan yang berkelanjutan.</p>\n\n<h5>Why is the Integrated Farming System Important?</h5>\n<p>Pada tahun 2014, diperkirakan pada tahun 2050, kita akan menghadapi peningkatan permintaan pangan sebesar 40% karena pertumbuhan penduduk dan peningkatan pendapatan di negara-negara berkembang. Untuk memenuhi tuntutan ini dan untuk menghasilkan makanan yang cukup untuk semua orang, kami membutuhkan solusi inovatif baru. Salah satu solusi tersebut adalah integrated farming system (IFS). IFS menggabungkan produksi tanaman dan pemeliharaan ternak menjadi satu sistem. Ini bertujuan untuk meningkatkan produktivitas, mengurangi degradasi lingkungan dan menyediakan produk berkualitas tinggi dengan memaksimalkan manfaat dari sumber daya pertanian dan meminimalisir kerugian.</p>\n\n<h5>The Concept of Integrated Farming System</h5>\n<p>Integrated farming system memungkinkan pendekatan pertanian yang lebih berkelanjutan dan pengelolaan sumber daya yang langka dengan lebih baik.Konsep ini menggabungkan kegiatan sub sektor pertanian, tanaman, ternak, ikan untuk meningkatkan efisiensi dan produktivitas sumber daya (lahan, manusia, dan faktor tumbuh lainnya), yang mendukung produksi pertanian, peningkatan ekonomi dan pelestarian sumberdaya alam, serta kemandirian dan kesejahteraan petani secara berkelanjutan. Output dari konsep ini sering disebut 4F (food, feed, fuel, fertilizer. Gagasan dibalik integrated farming sangat sederhana: Optimalkan hasil dari beberapa tanaman (dan terkadang ternak) di sebidang tanah tertentu dengan menggabungkan berbagai pendekatan dan praktik.</p>\n\n<h5>Sustainable Agriculture â€“ The Future</h5>\n<p>Semakin banyak, petani di seluruh dunia mengambil langkah pertama mereka menuju pendekatan pertanian yang lebih berkelanjutan. Dari praktik manajemen lapangan seperti rotasi tanaman hingga perusahaan sosial yang berfokus pada keberlanjutan seperti pasar pertanian lokal, tidak pernah ada waktu yang lebih baik untuk pertanian berkelanjutan. </p>\n\n<h5>Application of technology in integrated farming systems.</h5>\n<p>Anda dapat menerapkan sistem pertanian terpadu atau integrated farming system dengan sederhana, contohnya yaitu menempatkan kandang ayam diatas kolam lele dan di sekelilingnya adalah sawah serta perkebunan. Kotoran ayam akan menjadi makanan ikan lele, dan endapan pada kolam lele bisa menjadi pupuk organik untuk sawah serta perkebunan, dengan hasil samping bahan bakar biogas. Penerapan teknologi disini dapat menciptakan sistem automasi termasuk kontrol pada pengairan, lampu, serta input informasi dan data secara real-time yang dapat terintegrasi dengan aplikasi pada ponsel anda. </p>\n\n<h5>The Benefits of Integrated Farming System</h5>\n<p>Manfaat dari integrated farming system termasuk efisiensi yang lebih besar, kualitas panen yang lebih baik, hasil yang lebih besar, dan biaya yang lebih rendah. Sistem ini mampu menjaga keseimbangan ekosistem di dalamnya sehingga aliran nutrisi dan energi berimbang serta menghasilkan produktivitas yang tinggi dan berkelanjutan. Sistem ini juga meminimalisir limbah karena pemanfaatan kembali didalam sistem.</p>\n','2021-11-11 14:18:38','2021-11-11 14:18:38',NULL,2),(19,'Smart Locker for Storage and Logistic','<h3>Introducing the Smart Locker: Your New Best Friend for Storage and Shipping</h3\n<h5>Butuh penyimpanan? Malas mengantri di kantor pengiriman?</h5>\n<p>Smart Locker adalah solusi permasalahan anda! Daripada mengantre untuk mengantar atau mengambil barang, cukup kirimkan ke Smart Locker anda dan ambil kembali saat anda siap menggunakannya. anda bahkan dapat membeli barang dari toko lain dan mengirimkannya langsung ke loker anda sehingga anda dapat mengaksesnya kapanpun anda mau tanpa harus mengantre atau repot reservasi.</p>\n\n<h5>Why would I need a smart locker?</h5>\n<p>Sama seperti layanan pengiriman atau kios, Smart Locker menyediakan tempat yang aman untuk menyimpan barang-barang anda, baik itu barang pribadi anda atau seluruh produk bisnis. Smart Locker juga dirancang untuk memberi anda akses 24 jam ke barang-barang ini, artinya tidak perlu menunggu waktu tertentu hanya untuk memeriksa sesuatu. Dan meskipun mereka berpotensi digunakan oleh siapa saja kapan saja, mereka biasanya disediakan khusus untuk perusahaan yang mengirimkan produk dalam jumlah besar.</p>\n\n<h5>How do they work?</h5>\n<p>Anda mungkin membawa banyak barang anda kemanapun anda pergi; baik itu komputer, ponsel, atau dokumen anda dari kantor. Menyimpan barang-barang ini bisa jadi sulit jika anda tidak memiliki tempat yang aman untuk menyimpannya saat di rumah atau saat bepergian. Kebanyakan orang tidak memiliki cukup ruang di rumah mereka untuk menyimpan barang-barang ini dan mereka juga tidak mampu membayar orang lain untuk menyimpan barang-barang mereka di loker yang mahal. Smart Locker memecahkan semua masalah ini.</p>\n\n<h5>Types of lockers available</h5>\n<p>Loker kami tersedia dalam berbagai ukuran, dari ekstra kecil hingga ekstra besar. Masing-masing dapat menampung jumlah berat tertentu, jadi pastikan untuk mengukur apa yang anda rencanakan untuk disimpan sebelum membeli. Jenis loker yang kami miliki mencakup beberapa kompartemen yang sempurna untuk melacak barang-barang anda, membuatnya mudah ditemukan saat anda membutuhkannya!</p>\n\n<h5>How it works with/for you</h5>\n<p>Dengan Smart Locker, anda dapat menyimpan barang-barang dengan aman di tempat tujuan pilihan anda. anda bahkan dapat menyewakannya kepada orang lain sebagai ruang penyimpanan. anda dapat dengan mudah membuka kunci loker anda dengan memindai kode QR atau memasukkan kode akses. Dan karena terhubung ke GPS, anda tidak perlu khawatir kehilangan barang-barang anda. </p>\n\n<h5>Where can I find a smart locker?</h5>\n<p>Jangan khawatir! Smart Locker sangat cocok untuk di tempat-tempat strategis seperti perusahaan jasa pengiriman, supermarket, kampus, dan perkantoran. Dengan begitu, anda akan dengan mudah menyimpan atau mengirim dan menerima barang anda dimanapun anda berada.</p>\n\n<h5>How does the smart locker work in shipping</h5>\n<p>Setelah anda menyimpan kiriman anda di Smart Locker, anda dapat melacaknya melalui aplikasi. Ketika tiba di tujuannya, pemberitahuan akan dikirim ke ponsel anda dan kode akan diberikan untuk mengambilnya. Setiap Smart Locker memiliki paket baterai ekstra, jadi pemadaman listrik tidak menghentikan pengiriman! Dan tentunya semua transaksi aman, karena setiap Smart Locker memiliki teknologi anti maling di dalamnya.</p>\n\n',NULL,NULL,NULL,4),(20,'Drink Vending Machine','<h3>Get Your Caffeine Fix Anytime, Anywhere with a Coffee Vending Machine</h3>\n\n<p>Coffee Vending Machine atau mesin penjual kopi telah ada sejak pertengahan 1900-an, dan telah berkembang hingga sekarang. Saat ini, ada banyak mesin penjual kopi yang berbeda yang dapat memuaskan hasrat pecinta kopi, baik anda ingin panas atau dingin, hitam atau dengan krim dan gula. Jika anda memiliki bisnis sendiri, anda mungkin ingin mempertimbangkan untuk menambahkan salah satu mesin penjual kopi yang trendi ini ke ruang istirahat kantor atau kafe anda untuk menarik pelanggan dan menambahkan variasi ke menu anda. Anda juga dapat menempatkan mesin penjual kopi ini di tempat-tempat strategis seperti stasiun, bandara, maupun kampus.Artikel ini memberikan gambaran umum tentang mesin penjual kopi otomatis, apa yang mereka tawarkan dan bagaimana memilih coffee vending machine yang tepat untuk kebutuhan anda.\n\nWhy Should You Invest in a Coffee Vending Machine?\nCoffee Vending Machine dapat beroperasi secara independen, anda tidak menghabiskan waktu ekstra untuk bisnis sampingan ini saat anda melakukan pekerjaan lain. Anda hanya perlu memeriksa mesin Anda sesekali untuk mengumpulkan uang dan mengganti kopi dan krimer. Coffee Vending Machine ini dapat dianggap sebagai investasi yang baik jika anda menempatkan mesin yang banyak dilalui orang. Hal ini akan membantu menghasilkan lebih banyak pendapatan karena lebih banyak segelas kopi yang dijual, terlebih lagi orang sibuk tidak selalu punya waktu untuk menunggu kopi disajikan atau dibuat sendiri. </p>\n\n<h5>What Are the Types of Coffee Vending Machines?</h5>\n<p>Anda dapat menentukan sendiri tipe coffee vending machine yang anda mau. Kami akan memberikan beberapa referensi mengenai tipe-tipe tersebut antara lain coffee vending machine yang fokus pada kopi panas atau kopi dingin saja, kemudian ada coffee vending machine yang lengkap untuk menjual kopi panas, kopi dingin, kopi hitam, kopi dengan krimer, maupun minuman kopi inovasi seperti kopi matcha atau kopi coklat. Anda juga bisa menentukan sendiri menu kopi yang anda jual di mesin ini. Harga mesin inipun beragam, mulai dari yang terjangkau hingga mahal, tergantung kebutuhan anda. Salah satu keuntungan membeli mesin penjual kopi adalah memberi anda kendali atas jenis kopi yang anda sajikan.</p>\n\n<h5>The Benefits of a Coffee Vending Machine</h5>\n<p>Jika anda menjalankan bisnis yang sibuk, seperti kantor atau pabrik yang membutuhkan banyak orang untuk melakukan tugas berat sepanjang hari, menyediakan kopi dapat membantu mereka tetap waspada dan membuat mereka lebih produktif. Penting juga bagi pemberi kerja untuk membuat karyawan mereka senang dan beristirahat dengan baik sehingga mereka dapat masuk kerja setiap hari dengan siap untuk melakukan yang terbaik. Menyediakan coffee vending machine di tempat adalah salah satu cara yang bagus untuk memberi kafein dan memberi penghargaan kepada karyawan anda.</p>\n\n<h5>Where is The Best Place for a Coffee Vending Machine Business?</h5>\n<p>Bisnis coffee vending machine sangat cocok untuk di dalam dan di luar ruangan. Anda dapat menempatkannya toko di kantor, gedung publik, stasiun kereta api, atau tempat umum lainnya di mana karyawan dan / atau pelanggan membutuhkan kopi untuk meningkatkan produktivitas mereka.</p>\n',NULL,NULL,NULL,4);

--
-- Table structure for table `villages`
--

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

--
-- Dumping data for table `villages`
--



