--
-- Host: localhost    Database: tra
-- ------------------------------------------------------


--
-- Table structure for table `acl_rules`
--

CREATE TABLE `acl_rules` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `disk` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `path` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `access` tinyint(4) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `acl_rules_user_id_foreign` (`user_id`),
  CONSTRAINT `acl_rules_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `acl_rules`
--


--
-- Table structure for table `activity_log`
--

CREATE TABLE `activity_log` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `log_name` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `subject_id` bigint(20) unsigned DEFAULT NULL,
  `subject_type` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `causer_id` bigint(20) unsigned DEFAULT NULL,
  `causer_type` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `properties` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`properties`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `activity_log_log_name_index` (`log_name`),
  KEY `subject` (`subject_id`,`subject_type`),
  KEY `causer` (`causer_id`,`causer_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `activity_log`
--


--
-- Table structure for table `address`
--

CREATE TABLE `address` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `address_line_1` varchar(256) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address_line_2` varchar(256) COLLATE utf8_unicode_ci DEFAULT NULL,
  `city` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `state` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `district_id` bigint(20) unsigned NOT NULL,
  `country` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `address_district_id_foreign` (`district_id`),
  CONSTRAINT `address_district_id_foreign` FOREIGN KEY (`district_id`) REFERENCES `district` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `address`
--

INSERT INTO `address` VALUES (1,'1 Wall Street',NULL,'New York','NY',1,'USA',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(2,'45 Main Street',NULL,'Long Island','NY',1,'USA',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL);

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

CREATE TABLE `categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `slug` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `order` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `created_by` int(10) unsigned DEFAULT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned 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=utf8 COLLATE=utf8_unicode_ci;

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


--
-- Table structure for table `classification_type`
--

CREATE TABLE `classification_type` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `classification_type_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `classification_type`
--

INSERT INTO `classification_type` VALUES (1,'Private',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(2,'Public',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(3,'Government',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL);

--
-- Table structure for table `comment`
--

CREATE TABLE `comment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `comment` blob NOT NULL,
  `commentable_id` int(11) NOT NULL,
  `commentable_type` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned 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=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `comment`
--


--
-- Table structure for table `company`
--

CREATE TABLE `company` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `company_name` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `contact_party_id` bigint(20) unsigned NOT NULL,
  `company_type_id` int(11) NOT NULL,
  `registration_date` datetime NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_company_company_type2` (`company_type_id`),
  KEY `fk_company_person1` (`contact_party_id`),
  CONSTRAINT `company_contact_party_id_foreign` FOREIGN KEY (`contact_party_id`) REFERENCES `party` (`id`),
  CONSTRAINT `fk_company_company_type2` FOREIGN KEY (`company_type_id`) REFERENCES `company_type` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_company_person1` FOREIGN KEY (`contact_party_id`) REFERENCES `party` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `company`
--

INSERT INTO `company` VALUES (1,'Sven Pty Ltd ',2,1,'2021-09-28 14:01:35',1,1,NULL,'2021-09-28 04:01:35','2021-09-28 04:01:35',NULL),(2,'Eladio Pty Ltd ',5,1,'2021-09-28 14:01:37',1,1,NULL,'2021-09-28 04:01:37','2021-09-28 04:01:37',NULL),(3,'Carlie Pty Ltd ',8,1,'2021-09-28 14:01:38',1,1,NULL,'2021-09-28 04:01:38','2021-09-28 04:01:38',NULL),(4,'Tess Pty Ltd ',11,1,'2021-09-28 14:01:38',1,1,NULL,'2021-09-28 04:01:38','2021-09-28 04:01:38',NULL),(5,'Hayley Pty Ltd ',14,1,'2021-09-28 14:01:39',1,1,NULL,'2021-09-28 04:01:39','2021-09-28 04:01:39',NULL),(6,'Name Pty Ltd ',17,1,'2021-09-28 14:01:39',1,1,NULL,'2021-09-28 04:01:39','2021-09-28 04:01:39',NULL),(7,'Kyra Pty Ltd ',20,1,'2021-09-28 14:01:40',1,1,NULL,'2021-09-28 04:01:40','2021-09-28 04:01:40',NULL),(8,'Alana Pty Ltd ',23,1,'2021-09-28 14:01:40',1,1,NULL,'2021-09-28 04:01:40','2021-09-28 04:01:40',NULL),(9,'Elmore Pty Ltd ',26,1,'2021-09-29 00:23:26',7,7,NULL,'2021-09-28 14:23:26','2021-09-28 14:23:26',NULL),(10,'Zachariah Pty Ltd ',29,1,'2021-09-29 00:23:28',7,7,NULL,'2021-09-28 14:23:28','2021-09-28 14:23:28',NULL),(11,'Cayla Pty Ltd ',32,1,'2021-09-29 00:23:28',7,7,NULL,'2021-09-28 14:23:28','2021-09-28 14:23:28',NULL),(12,'Chase Pty Ltd ',35,1,'2021-09-29 00:23:29',7,7,NULL,'2021-09-28 14:23:29','2021-09-28 14:23:29',NULL),(13,'Devonte Pty Ltd ',38,1,'2021-09-29 00:23:29',7,7,NULL,'2021-09-28 14:23:29','2021-09-28 14:23:29',NULL),(14,'Arne Pty Ltd ',41,1,'2021-09-29 00:23:29',7,7,NULL,'2021-09-28 14:23:29','2021-09-28 14:23:29',NULL),(15,'Angel Pty Ltd ',44,1,'2021-09-29 00:23:30',7,7,NULL,'2021-09-28 14:23:30','2021-09-28 14:23:30',NULL),(16,'Marlen Pty Ltd ',47,1,'2021-09-29 00:23:30',7,7,NULL,'2021-09-28 14:23:30','2021-09-28 14:23:30',NULL);

--
-- Table structure for table `company_type`
--

CREATE TABLE `company_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `company_type_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `company_type`
--

INSERT INTO `company_type` VALUES (1,'Private Ltd',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(2,'Public Ltd',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(3,'Government',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(4,'Non Profit',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(5,'Sole Trader',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL);

--
-- Table structure for table `discount`
--

CREATE TABLE `discount` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `description` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `percentage` decimal(10,2) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `expiry_date` datetime NOT NULL,
  `party_id` bigint(20) unsigned DEFAULT NULL,
  `service_id` bigint(20) unsigned DEFAULT NULL,
  `vehicle_tax_id` bigint(20) unsigned DEFAULT NULL,
  `party_vehicle_id` bigint(20) unsigned DEFAULT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `discount_party_id_foreign` (`party_id`),
  KEY `discount_service_id_foreign` (`service_id`),
  KEY `discount_vehicle_tax_id_foreign` (`vehicle_tax_id`),
  KEY `discount_party_vehicle_id_foreign` (`party_vehicle_id`),
  CONSTRAINT `discount_party_id_foreign` FOREIGN KEY (`party_id`) REFERENCES `party` (`id`),
  CONSTRAINT `discount_party_vehicle_id_foreign` FOREIGN KEY (`party_vehicle_id`) REFERENCES `party_vehicle` (`id`),
  CONSTRAINT `discount_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `service` (`id`),
  CONSTRAINT `discount_vehicle_tax_id_foreign` FOREIGN KEY (`vehicle_tax_id`) REFERENCES `vehicle_tax` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `discount`
--


--
-- Table structure for table `district`
--

CREATE TABLE `district` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `region_id` bigint(20) unsigned NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `district_name_unique` (`name`),
  KEY `district_region_id_foreign` (`region_id`),
  CONSTRAINT `district_region_id_foreign` FOREIGN KEY (`region_id`) REFERENCES `region` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `district`
--

INSERT INTO `district` VALUES (1,'Gaalkacyo',1,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(2,'Galdogob',1,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(3,'Jarriiban',1,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(4,'Xarfo',1,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(5,'Towfiiq',1,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(6,'Saaxo',1,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(7,'Bursaalax',1,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(8,'Badhan',2,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(9,'Laasqoray',2,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(10,'Ceerigaabo',2,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(11,'Fiqifuliye',2,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(12,'Xingalool',2,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(13,'yubbe',2,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(14,'Dhahar',3,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(15,'Buraan',3,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(16,'Ceelaayo',3,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(17,'Garoowe',4,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(18,'Eyl',4,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(19,'Burtinle',4,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(20,'Dangoranyo',4,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(21,'Godob',4,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(22,'Boosaaso',5,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(23,'Qandala',5,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(24,'Iskushuban',5,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(25,'Uffayn',5,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(26,'Ballidhidin',5,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(27,'Carmo',5,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(28,'Qardho',6,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(29,'Bayla',6,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(30,'Xaafuun',6,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(31,'Waaciya',6,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(32,'Rako',6,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(33,'Xumbays',6,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(34,'Dhudhub',6,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(35,'Shaxda',6,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(36,'Caluula',7,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(37,'Bargaal',7,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(38,'Gumbax',7,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(39,'Bareeda',7,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(40,'Murcanyo',7,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(41,'Laascaanood',8,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(42,'Taleex',8,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(43,'Xudun',8,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(44,'Boocame',8,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(45,'Kalabaydh',8,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(46,'Dharkayngenyo',8,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(47,'Buuhodle',9,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(48,'Widhwidh',9,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(49,'Horufadhi',9,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL),(50,'ceegaag',9,1,NULL,NULL,'2021-10-05 09:24:47',NULL,NULL);

--
-- Table structure for table `document`
--

CREATE TABLE `document` (
  `id` int(11) NOT NULL,
  `name` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `uri` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `status` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `document_type_id` bigint(20) unsigned NOT NULL,
  `documentable_id` int(11) NOT NULL,
  `documentable_type` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `document_document_type_id_foreign` (`document_type_id`),
  CONSTRAINT `document_document_type_id_foreign` FOREIGN KEY (`document_type_id`) REFERENCES `document_type` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `document`
--


--
-- Table structure for table `document_type`
--

CREATE TABLE `document_type` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `document_type_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `document_type`
--

INSERT INTO `document_type` VALUES (1,'CUSTOMER_ID',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(2,'PASSPORT',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(3,'TITLE_CERTIFICATE',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL);

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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `connection` text COLLATE utf8_unicode_ci NOT NULL,
  `queue` text COLLATE utf8_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


--
-- Table structure for table `frequency_type`
--

CREATE TABLE `frequency_type` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `frequency_type_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `frequency_type`
--

INSERT INTO `frequency_type` VALUES (1,'Monthly',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(2,'Quarterly',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(3,'Yearly',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(4,'OneTime',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL);

--
-- Table structure for table `fuel_type`
--

CREATE TABLE `fuel_type` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `fuel_type_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `fuel_type`
--

INSERT INTO `fuel_type` VALUES (1,'PETROL',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(2,'DIESEL',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL);

--
-- Table structure for table `invoice`
--

CREATE TABLE `invoice` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `invoice_number` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `transaction_id` bigint(20) unsigned NOT NULL,
  `party_id` bigint(20) unsigned NOT NULL,
  `invoice_amount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `invoice_date` datetime NOT NULL,
  `due_date` datetime NOT NULL,
  `outstanding_balance` decimal(10,2) NOT NULL DEFAULT 0.00,
  `tax_amount` decimal(10,2) DEFAULT NULL,
  `total_invoice_amount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `status` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `siinpay_invoice_number` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `invoice_transaction_id_foreign` (`transaction_id`),
  KEY `invoice_party_id_foreign` (`party_id`),
  CONSTRAINT `invoice_party_id_foreign` FOREIGN KEY (`party_id`) REFERENCES `party` (`id`),
  CONSTRAINT `invoice_transaction_id_foreign` FOREIGN KEY (`transaction_id`) REFERENCES `transaction` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `invoice`
--

INSERT INTO `invoice` VALUES (1,'INV-458-1282',1,11,30.00,'2021-10-03 18:15:32','2021-11-03 18:15:32',30.00,NULL,30.00,'OPEN',NULL,5,5,NULL,'2021-10-03 07:15:32','2021-10-03 07:15:32',NULL),(2,'INV-676-2260',2,41,25.00,'2021-10-03 18:32:33','2021-11-03 18:32:33',0.00,NULL,25.00,'PAID',NULL,5,7,NULL,'2021-10-03 07:32:33','2021-10-03 07:54:00',NULL),(3,'INV-986-3526',3,41,14.00,'2021-10-03 19:11:30','2021-11-03 19:11:30',0.00,NULL,14.00,'PAID',NULL,8,7,NULL,'2021-10-03 08:11:30','2021-10-04 02:53:38',NULL),(4,'INV-551-4636',4,41,14.00,'2021-10-03 19:11:30','2021-11-03 19:11:30',0.00,NULL,14.00,'PAID',NULL,8,7,NULL,'2021-10-03 08:11:30','2021-10-04 02:53:38',NULL),(5,'INV-394-5563',5,41,14.00,'2021-10-03 19:11:30','2021-11-03 19:11:30',0.00,NULL,14.00,'PAID',NULL,8,7,NULL,'2021-10-03 08:11:30','2021-10-04 02:53:38',NULL),(6,'INV-480-6331',6,41,14.00,'2021-10-03 19:11:30','2021-11-03 19:11:30',0.00,NULL,14.00,'PAID',NULL,8,7,NULL,'2021-10-03 08:11:30','2021-10-04 02:53:38',NULL),(7,'INV-727-7680',7,41,14.00,'2021-10-03 19:11:30','2021-11-03 19:11:30',0.00,NULL,14.00,'PAID',NULL,8,7,NULL,'2021-10-03 08:11:30','2021-10-04 02:53:38',NULL),(8,'INV-329-8952',8,28,33.00,'2021-10-03 19:15:21','2021-11-03 19:15:21',33.00,NULL,33.00,'OPEN',NULL,5,5,NULL,'2021-10-03 08:15:21','2021-10-03 08:15:21',NULL),(12,'INV-390-12508',12,46,33.00,'2021-10-04 22:51:15','2021-11-04 22:51:15',33.00,NULL,33.00,'OPEN',NULL,5,5,NULL,'2021-10-04 11:51:15','2021-10-04 11:51:15',NULL),(13,'INV-750-13689',13,2,25.00,'2021-10-04 22:58:52','2021-11-04 22:58:52',25.00,NULL,25.00,'OPEN',NULL,5,5,NULL,'2021-10-04 11:58:52','2021-10-04 11:58:52',NULL),(14,'INV-613-14310',14,10,25.00,'2021-10-04 23:14:45','2021-11-04 23:14:45',25.00,NULL,25.00,'OPEN',NULL,5,5,NULL,'2021-10-04 12:14:45','2021-10-04 12:14:45',NULL),(15,'INV-279-15873',15,38,25.00,'2021-10-04 23:25:49','2021-11-04 23:25:49',0.00,NULL,25.00,'PAID',NULL,5,7,NULL,'2021-10-04 12:25:49','2021-10-05 12:12:38',NULL),(16,'INV-758-16923',16,38,14.00,'2021-10-05 23:13:41','2021-11-05 23:13:41',0.00,NULL,14.00,'PAID',NULL,1,7,NULL,'2021-10-05 12:13:41','2021-10-05 13:16:48',NULL),(17,'INV-401-17564',17,38,14.00,'2021-10-05 23:13:42','2021-11-05 23:13:42',0.00,NULL,14.00,'PAID',NULL,1,7,NULL,'2021-10-05 12:13:42','2021-10-05 13:16:48',NULL),(18,'INV-395-18429',18,38,14.00,'2021-10-05 23:13:44','2021-11-05 23:13:44',0.00,NULL,14.00,'PAID',NULL,1,7,NULL,'2021-10-05 12:13:44','2021-10-05 13:16:48',NULL),(19,'INV-273-19318',19,38,14.00,'2021-10-05 23:13:47','2021-11-05 23:13:47',0.00,NULL,14.00,'PAID',NULL,1,7,NULL,'2021-10-05 12:13:47','2021-10-05 13:16:48',NULL),(20,'INV-578-20298',20,11,25.00,'2021-10-06 00:13:11','2021-11-06 00:13:11',25.00,NULL,25.00,'OPEN',NULL,1,1,NULL,'2021-10-05 13:13:11','2021-10-05 13:13:11',NULL);

--
-- Table structure for table `invoice_item`
--

CREATE TABLE `invoice_item` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `item` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `unit_price` decimal(10,2) NOT NULL,
  `total_price` decimal(10,2) NOT NULL,
  `quantity` int(10) unsigned NOT NULL,
  `invoice_id` bigint(20) unsigned NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `invoice_item_invoice_id_foreign` (`invoice_id`),
  CONSTRAINT `invoice_item_invoice_id_foreign` FOREIGN KEY (`invoice_id`) REFERENCES `invoice` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `invoice_item`
--

INSERT INTO `invoice_item` VALUES (1,'Title Fee','Government Fee for Title Registration',18.00,18.00,1,1,5,5,NULL,'2021-10-03 07:15:32','2021-10-03 07:15:32',NULL),(2,'Service Fee','Service Fee for Title Registration',12.00,12.00,1,1,5,5,NULL,'2021-10-03 07:15:32','2021-10-03 07:15:32',NULL),(3,'Title Fee','Government Fee for Title Registration',13.00,13.00,1,2,5,5,NULL,'2021-10-03 07:32:33','2021-10-03 07:32:33',NULL),(4,'Service Fee','Service Fee for Title Registration',12.00,12.00,1,2,5,5,NULL,'2021-10-03 07:32:33','2021-10-03 07:32:33',NULL),(5,'Tax Fee','Quertery Tax Fee',4.00,4.00,1,3,8,8,NULL,'2021-10-03 08:11:30','2021-10-03 08:11:30',NULL),(6,'Service Fee','Service Fee for Tax Registration',10.00,10.00,1,3,8,8,NULL,'2021-10-03 08:11:30','2021-10-03 08:11:30',NULL),(7,'Tax Fee','Quertery Tax Fee',4.00,4.00,1,4,8,8,NULL,'2021-10-03 08:11:30','2021-10-03 08:11:30',NULL),(8,'Service Fee','Service Fee for Tax Registration',10.00,10.00,1,4,8,8,NULL,'2021-10-03 08:11:30','2021-10-03 08:11:30',NULL),(9,'Tax Fee','Quertery Tax Fee',4.00,4.00,1,5,8,8,NULL,'2021-10-03 08:11:30','2021-10-03 08:11:30',NULL),(10,'Service Fee','Service Fee for Tax Registration',10.00,10.00,1,5,8,8,NULL,'2021-10-03 08:11:30','2021-10-03 08:11:30',NULL),(11,'Tax Fee','Quertery Tax Fee',4.00,4.00,1,6,8,8,NULL,'2021-10-03 08:11:30','2021-10-03 08:11:30',NULL),(12,'Service Fee','Service Fee for Tax Registration',10.00,10.00,1,6,8,8,NULL,'2021-10-03 08:11:30','2021-10-03 08:11:30',NULL),(13,'Tax Fee','Quertery Tax Fee',4.00,4.00,1,7,8,8,NULL,'2021-10-03 08:11:30','2021-10-03 08:11:30',NULL),(14,'Service Fee','Service Fee for Tax Registration',10.00,10.00,1,7,8,8,NULL,'2021-10-03 08:11:30','2021-10-03 08:11:30',NULL),(15,'Title Fee','Government Fee for Title Registration',21.00,21.00,1,8,5,5,NULL,'2021-10-03 08:15:21','2021-10-03 08:15:21',NULL),(16,'Service Fee','Service Fee for Title Registration',12.00,12.00,1,8,5,5,NULL,'2021-10-03 08:15:21','2021-10-03 08:15:21',NULL),(23,'Title Fee','Government Fee for Title Registration',21.00,21.00,1,12,5,5,NULL,'2021-10-04 11:51:15','2021-10-04 11:51:15',NULL),(24,'Service Fee','Service Fee for Title Registration',12.00,12.00,1,12,5,5,NULL,'2021-10-04 11:51:15','2021-10-04 11:51:15',NULL),(25,'Title Fee','Government Fee for Title Registration',13.00,13.00,1,13,5,5,NULL,'2021-10-04 11:58:52','2021-10-04 11:58:52',NULL),(26,'Service Fee','Service Fee for Title Registration',12.00,12.00,1,13,5,5,NULL,'2021-10-04 11:58:52','2021-10-04 11:58:52',NULL),(27,'Title Fee','Government Fee for Title Registration',13.00,13.00,1,14,5,5,NULL,'2021-10-04 12:14:45','2021-10-04 12:14:45',NULL),(28,'Service Fee','Service Fee for Title Registration',12.00,12.00,1,14,5,5,NULL,'2021-10-04 12:14:45','2021-10-04 12:14:45',NULL),(29,'Title Fee','Government Fee for Title Registration',13.00,13.00,1,15,5,5,NULL,'2021-10-04 12:25:49','2021-10-04 12:25:49',NULL),(30,'Service Fee','Service Fee for Title Registration',12.00,12.00,1,15,5,5,NULL,'2021-10-04 12:25:49','2021-10-04 12:25:49',NULL),(31,'Tax Fee','Quertery Tax Fee',4.00,4.00,1,16,1,1,NULL,'2021-10-05 12:13:41','2021-10-05 12:13:41',NULL),(32,'Service Fee','Service Fee for Tax Registration',10.00,10.00,1,16,1,1,NULL,'2021-10-05 12:13:41','2021-10-05 12:13:41',NULL),(33,'Tax Fee','Quertery Tax Fee',4.00,4.00,1,17,1,1,NULL,'2021-10-05 12:13:42','2021-10-05 12:13:42',NULL),(34,'Service Fee','Service Fee for Tax Registration',10.00,10.00,1,17,1,1,NULL,'2021-10-05 12:13:42','2021-10-05 12:13:42',NULL),(35,'Tax Fee','Quertery Tax Fee',4.00,4.00,1,18,1,1,NULL,'2021-10-05 12:13:44','2021-10-05 12:13:44',NULL),(36,'Service Fee','Service Fee for Tax Registration',10.00,10.00,1,18,1,1,NULL,'2021-10-05 12:13:44','2021-10-05 12:13:44',NULL),(37,'Tax Fee','Quertery Tax Fee',4.00,4.00,1,19,1,1,NULL,'2021-10-05 12:13:47','2021-10-05 12:13:47',NULL),(38,'Service Fee','Service Fee for Tax Registration',10.00,10.00,1,19,1,1,NULL,'2021-10-05 12:13:47','2021-10-05 12:13:47',NULL),(39,'Title Fee','Government Fee for Title Registration',13.00,13.00,1,20,1,1,NULL,'2021-10-05 13:13:11','2021-10-05 13:13:11',NULL),(40,'Service Fee','Service Fee for Title Registration',12.00,12.00,1,20,1,1,NULL,'2021-10-05 13:13:11','2021-10-05 13:13:11',NULL);

--
-- Table structure for table `invoice_logs`
--

CREATE TABLE `invoice_logs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `invoice_id` bigint(20) unsigned NOT NULL,
  `status` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `invoice_logs_invoice_id_foreign` (`invoice_id`),
  CONSTRAINT `invoice_logs_invoice_id_foreign` FOREIGN KEY (`invoice_id`) REFERENCES `invoice` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `invoice_logs`
--


--
-- Table structure for table `invoice_payment`
--

CREATE TABLE `invoice_payment` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `invoice_id` bigint(20) unsigned NOT NULL,
  `payment_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `invoice_payment_invoice_id_foreign` (`invoice_id`),
  KEY `invoice_payment_payment_id_foreign` (`payment_id`),
  CONSTRAINT `invoice_payment_invoice_id_foreign` FOREIGN KEY (`invoice_id`) REFERENCES `invoice` (`id`),
  CONSTRAINT `invoice_payment_payment_id_foreign` FOREIGN KEY (`payment_id`) REFERENCES `payment` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `invoice_payment`
--


--
-- Table structure for table `make`
--

CREATE TABLE `make` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `make_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `make`
--

INSERT INTO `make` VALUES (1,'Honda',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(2,'Toyota',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(3,'BMW',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL);

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

CREATE TABLE `media` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `model_type` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  `uuid` char(36) COLLATE utf8_unicode_ci DEFAULT NULL,
  `collection_name` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `file_name` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `mime_type` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `disk` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `conversions_disk` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `size` bigint(20) unsigned NOT NULL,
  `manipulations` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`manipulations`)),
  `custom_properties` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`custom_properties`)),
  `responsive_images` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`responsive_images`)),
  `order_column` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `generated_conversions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`generated_conversions`)),
  PRIMARY KEY (`id`),
  KEY `media_model_type_model_id_index` (`model_type`,`model_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `migrations` VALUES (1,'2014_09_19_111450_create_region_table',1),(2,'2014_09_19_111451_create_district_table',1),(3,'2014_10_12_000000_create_users_table',1),(4,'2014_10_12_100000_create_password_resets_table',1),(5,'2016_06_01_000001_create_oauth_auth_codes_table',1),(6,'2016_06_01_000002_create_oauth_access_tokens_table',1),(7,'2016_06_01_000003_create_oauth_refresh_tokens_table',1),(8,'2016_06_01_000004_create_oauth_clients_table',1),(9,'2016_06_01_000005_create_oauth_personal_access_clients_table',1),(10,'2018_03_11_062135_create_posts_table',1),(11,'2018_03_12_062135_create_categories_table',1),(12,'2019_02_06_174631_make_acl_rules_table',1),(13,'2019_08_19_000000_create_failed_jobs_table',1),(14,'2020_02_19_152418_create_permission_tables',1),(15,'2020_02_19_173115_create_activity_log_table',1),(16,'2020_02_19_173641_create_settings_table',1),(17,'2020_02_19_173700_create_userprofiles_table',1),(18,'2020_02_22_115918_create_user_providers_table',1),(19,'2020_10_27_155557_create_media_table',1),(20,'2020_12_30_020508_add_generated_conversions_to_media_table',1),(21,'2021_09_04_111452_create_tax_sticker_table',1),(22,'2021_09_19_111450_create_service_table',1),(23,'2021_09_19_111450_create_sub_category_table',1),(24,'2021_09_19_111450_create_workflow_table',1),(25,'2021_09_19_111451_create_document_type_table',1),(26,'2021_09_19_111451_create_notification_type_table',1),(27,'2021_09_19_111451_create_workflow_definition_table',1),(28,'2021_09_19_111452_create_address_table',1),(29,'2021_09_19_111452_create_classification_type_table',1),(30,'2021_09_19_111452_create_comment_table',1),(31,'2021_09_19_111452_create_company_type_table',1),(32,'2021_09_19_111452_create_document_table',1),(33,'2021_09_19_111452_create_frequency_type_table',1),(34,'2021_09_19_111452_create_fuel_type_table',1),(35,'2021_09_19_111452_create_make_table',1),(36,'2021_09_19_111452_create_model_table',1),(37,'2021_09_19_111452_create_notification_table',1),(38,'2021_09_19_111452_create_party_table',1),(39,'2021_09_19_111452_create_payment_method_table',1),(40,'2021_09_19_111452_create_person_table',1),(41,'2021_09_19_111452_create_service_fee_table',1),(42,'2021_09_19_111452_create_service_purchase_table',1),(43,'2021_09_19_111452_create_service_workflow_table',1),(44,'2021_09_19_111452_create_term_table',1),(45,'2021_09_19_111452_create_vehicle_color_table',1),(46,'2021_09_19_111452_create_vehicle_table',1),(47,'2021_09_19_111452_create_vehicle_title_table',1),(48,'2021_09_19_111452_create_vehicle_type_table',1),(49,'2021_09_19_111453_create_company_table',1),(50,'2021_09_19_111453_create_party_vehicle_purchase_table',1),(51,'2021_09_19_111453_create_transaction_table',1),(52,'2021_09_19_111453_create_workflow_checklist_table',1),(53,'2021_09_19_111454_add_foreign_keys_to_company_table',1),(54,'2021_09_19_111454_add_foreign_keys_to_party_table',1),(55,'2021_09_19_111454_add_foreign_keys_to_vehicle_table',1),(56,'2021_09_19_111454_create_invoice_table',1),(57,'2021_09_19_111454_create_payment_table',1),(58,'2021_09_19_111454_create_transaction_workflow_table',1),(59,'2021_09_19_111455_create_invoice_items_table',1),(60,'2021_09_19_111455_create_invoice_payment_table',1),(61,'2021_09_19_111455_create_party_address_table',1),(62,'2021_09_19_111455_create_party_vehicle_table',1),(63,'2021_09_19_111456_add_foreign_keys_to_party_address_table',1),(64,'2021_09_19_111456_create_vehicle_tax_table',1),(65,'2021_09_19_111460_create_discount_table',1),(66,'2021_09_22_130328_create_invoice_logs_table',1),(67,'2021_10_04_201323_add_sticker_id_to_vehicle_tax_table',1);

--
-- Table structure for table `model`
--

CREATE TABLE `model` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `make_id` bigint(20) unsigned NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `model_name_unique` (`name`),
  KEY `model_make_id_foreign` (`make_id`),
  CONSTRAINT `model_make_id_foreign` FOREIGN KEY (`make_id`) REFERENCES `make` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `model`
--

INSERT INTO `model` VALUES (1,'Camry',1,1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(2,'CRV',2,1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(3,'3 Series',3,1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL);

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `model_has_permissions`
--


--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` VALUES (1,'App\\Models\\User',1),(2,'App\\Models\\User',2),(3,'App\\Models\\User',3),(4,'App\\Models\\User',4),(5,'App\\Models\\User',5),(6,'App\\Models\\User',6),(7,'App\\Models\\User',7),(8,'App\\Models\\User',8);

--
-- Table structure for table `notification`
--

CREATE TABLE `notification` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `notification_type_id` bigint(20) unsigned NOT NULL,
  `notifiable_id` int(11) NOT NULL,
  `notifiable_type` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notification_notification_type_id_foreign` (`notification_type_id`),
  CONSTRAINT `notification_notification_type_id_foreign` FOREIGN KEY (`notification_type_id`) REFERENCES `notification_type` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `notification`
--


--
-- Table structure for table `notification_type`
--

CREATE TABLE `notification_type` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `notification_type` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned 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=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `notification_type`
--


--
-- Table structure for table `oauth_auth_codes`
--

CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `client_id` bigint(20) unsigned NOT NULL,
  `scopes` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_auth_codes_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `oauth_auth_codes`
--


--
-- Table structure for table `oauth_personal_access_clients`
--

CREATE TABLE `oauth_personal_access_clients` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `client_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `oauth_personal_access_clients`
--


--
-- Table structure for table `party`
--

CREATE TABLE `party` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone_number_1` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `phone_number_2` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address_id` int(11) NOT NULL,
  `siinpay_account_number` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `partyable_id` int(10) unsigned NOT NULL,
  `partyable_type` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_party_address1_idx` (`address_id`),
  CONSTRAINT `fk_party_address1` FOREIGN KEY (`address_id`) REFERENCES `address` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `party`
--

INSERT INTO `party` VALUES (1,'woconnell@example.com','+18285124074','1-234-667-1795',1,'CN0-078-395',1,'Person',1,1,NULL,'2021-09-28 04:01:35','2021-09-28 04:01:35',NULL),(2,'stanton12@example.net','432-302-9780','+17816925763',1,'CN0-078-395',2,'Person',1,1,NULL,'2021-09-28 04:01:35','2021-09-28 04:01:35',NULL),(3,'domenico.weber@example.com','+1.754.403.1242','228-782-7788',1,'CN0-078-395',1,'Company',1,1,NULL,'2021-09-28 04:01:35','2021-09-28 04:01:35',NULL),(4,'elubowitz@example.net','334.629.8273','+1-346-526-5277',1,'CN0-078-395',3,'Person',1,1,NULL,'2021-09-28 04:01:37','2021-09-28 04:01:37',NULL),(5,'amie87@example.com','734.307.0097','+1.347.368.5325',1,'CN0-078-395',4,'Person',1,1,NULL,'2021-09-28 04:01:37','2021-09-28 04:01:37',NULL),(6,'nitzsche.alize@example.net','+1-847-905-9334','1-541-885-1909',1,'CN2-677-800',2,'Company',1,1,NULL,'2021-09-28 04:01:37','2021-09-28 04:01:37',NULL),(7,'randall74@example.com','+14755294915','1-754-624-7172',1,'CN2-677-800',5,'Person',1,1,NULL,'2021-09-28 04:01:38','2021-09-28 04:01:38',NULL),(8,'fhirthe@example.org','+1-360-424-8200','1-401-926-3112',1,'CN2-677-800',6,'Person',1,1,NULL,'2021-09-28 04:01:38','2021-09-28 04:01:38',NULL),(9,'tommie13@example.com','(743) 359-3716','773.446.2922',1,'CN2-677-800',3,'Company',1,1,NULL,'2021-09-28 04:01:38','2021-09-28 04:01:38',NULL),(10,'aurelia32@example.net','747-382-5192','872-586-1123',1,'CN2-677-800',7,'Person',1,1,NULL,'2021-09-28 04:01:38','2021-09-28 04:01:38',NULL),(11,'sawayn.bette@example.org','+1-814-739-7401','1-360-424-9713',1,'CN2-677-800',8,'Person',1,1,NULL,'2021-09-28 04:01:38','2021-09-28 04:01:38',NULL),(12,'beer.fidel@example.com','+1.540.823.9975','+15407525629',1,'CN2-677-800',4,'Company',1,1,NULL,'2021-09-28 04:01:38','2021-09-28 04:01:38',NULL),(13,'torp.ulises@example.org','719.425.4196','+1.330.409.6808',1,'CN2-677-800',9,'Person',1,1,NULL,'2021-09-28 04:01:39','2021-09-28 04:01:39',NULL),(14,'quinten.witting@example.com','1-828-200-3502','+1-781-470-8457',1,'CN2-677-800',10,'Person',1,1,NULL,'2021-09-28 04:01:39','2021-09-28 04:01:39',NULL),(15,'kirk60@example.com','+1-864-569-3372','1-785-924-8316',1,'CN2-677-800',5,'Company',1,1,NULL,'2021-09-28 04:01:39','2021-09-28 04:01:39',NULL),(16,'aurelio.runte@example.org','+1.475.833.2284','541-505-1501',1,'CN2-677-800',11,'Person',1,1,NULL,'2021-09-28 04:01:39','2021-09-28 04:01:39',NULL),(17,'savanah63@example.org','1-616-752-2303','(281) 618-5167',1,'CN2-677-800',12,'Person',1,1,NULL,'2021-09-28 04:01:39','2021-09-28 04:01:39',NULL),(18,'astrosin@example.net','956-751-1267','321.529.1550',1,'CN2-677-800',6,'Company',1,1,NULL,'2021-09-28 04:01:39','2021-09-28 04:01:39',NULL),(19,'jabari.jaskolski@example.net','+1-702-734-0919','+1-989-295-8940',1,'CN2-677-800',13,'Person',1,1,NULL,'2021-09-28 04:01:40','2021-09-28 04:01:40',NULL),(20,'jullrich@example.net','1-435-430-7429','1-920-963-2804',1,'CN2-677-800',14,'Person',1,1,NULL,'2021-09-28 04:01:40','2021-09-28 04:01:40',NULL),(21,'percival53@example.org','+19204157508','+1-747-651-4885',1,'CN2-677-800',7,'Company',1,1,NULL,'2021-09-28 04:01:40','2021-09-28 04:01:40',NULL),(22,'lempi.carter@example.net','530-215-1660','+1.567.747.2404',1,'CN2-677-800',15,'Person',1,1,NULL,'2021-09-28 04:01:40','2021-09-28 04:01:40',NULL),(23,'gabriella.gibson@example.net','1-458-486-2903','(724) 672-5031',1,'CN2-677-800',16,'Person',1,1,NULL,'2021-09-28 04:01:40','2021-09-28 04:01:40',NULL),(24,'mromaguera@example.org','714.287.9085','859-721-1638',1,'CN2-677-800',8,'Company',1,1,NULL,'2021-09-28 04:01:40','2021-09-28 04:01:40',NULL),(25,'desiree27@example.net','(908) 641-7604','(857) 345-8247',1,'CN2-677-800',17,'Person',7,7,NULL,'2021-09-28 14:23:26','2021-09-28 14:23:26',NULL),(26,'eliane96@example.net','(808) 652-6366','+1 (651) 921-8561',1,'CN2-677-800',18,'Person',7,7,NULL,'2021-09-28 14:23:26','2021-09-28 14:23:26',NULL),(27,'haag.aidan@example.com','(828) 697-4501','907-707-7521',1,'CN2-677-800',9,'Company',7,7,NULL,'2021-09-28 14:23:27','2021-09-28 14:23:27',NULL),(28,'braeden.herman@example.net','1-640-855-1786','(959) 770-7858',1,'CN2-677-800',19,'Person',7,7,NULL,'2021-09-28 14:23:28','2021-09-28 14:23:28',NULL),(29,'hwilliamson@example.net','1-458-637-0360','(480) 404-5506',1,'CN2-677-800',20,'Person',7,7,NULL,'2021-09-28 14:23:28','2021-09-28 14:23:28',NULL),(30,'hillard.anderson@example.net','+15208886408','+1 (714) 506-9562',1,'CN2-677-800',10,'Company',7,7,NULL,'2021-09-28 14:23:28','2021-09-28 14:23:28',NULL),(31,'henderson.schaden@example.com','+14585040664','+1.225.927.8186',1,'CN2-677-800',21,'Person',7,7,NULL,'2021-09-28 14:23:28','2021-09-28 14:23:28',NULL),(32,'hschuster@example.com','458-839-3817','623-565-5056',1,'CN2-677-800',22,'Person',7,7,NULL,'2021-09-28 14:23:28','2021-09-28 14:23:28',NULL),(33,'iraynor@example.com','+1.937.688.6993','+1 (224) 605-8345',1,'CN2-677-800',11,'Company',7,7,NULL,'2021-09-28 14:23:28','2021-09-28 14:23:28',NULL),(34,'reinger.nasir@example.com','+1-256-252-8770','1-617-897-3939',1,'CN2-677-800',23,'Person',7,7,NULL,'2021-09-28 14:23:29','2021-09-28 14:23:29',NULL),(35,'betty25@example.org','+1.757.945.1140','850.583.9631',1,'CN2-677-800',24,'Person',7,7,NULL,'2021-09-28 14:23:29','2021-09-28 14:23:29',NULL),(36,'dortha.stiedemann@example.com','(725) 674-1447','+1-361-722-0296',1,'CN2-677-800',12,'Company',7,7,NULL,'2021-09-28 14:23:29','2021-09-28 14:23:29',NULL),(37,'ibrekke@example.net','+1.908.598.2960','(458) 310-6269',1,'CN2-677-800',25,'Person',7,7,NULL,'2021-09-28 14:23:29','2021-09-28 14:23:29',NULL),(38,'vivienne.bartoletti@example.com','+1.435.464.6787','515-718-8148',1,'CN2-677-800',26,'Person',7,7,NULL,'2021-09-28 14:23:29','2021-09-28 14:23:29',NULL),(39,'drew02@example.com','1-785-690-6721','1-302-538-2418',1,'CN2-677-800',13,'Company',7,7,NULL,'2021-09-28 14:23:29','2021-09-28 14:23:29',NULL),(40,'kayley.hauck@example.org','1-458-454-5128','283.951.9206',1,'CN2-677-800',27,'Person',7,7,NULL,'2021-09-28 14:23:29','2021-09-28 14:23:29',NULL),(41,'cassandre27@example.net','947-408-8542','+1-725-618-9389',1,'CN2-677-800',28,'Person',7,7,NULL,'2021-09-28 14:23:29','2021-09-28 14:23:29',NULL),(42,'griffin.zemlak@example.org','+1-847-494-1318','805-863-0626',1,'CN2-677-800',14,'Company',7,7,NULL,'2021-09-28 14:23:29','2021-09-28 14:23:29',NULL),(43,'ykerluke@example.com','+1.484.688.4176','651.358.2782',1,'CN2-677-800',29,'Person',7,7,NULL,'2021-09-28 14:23:30','2021-09-28 14:23:30',NULL),(44,'camila.gottlieb@example.net','936.724.0181','440-531-9751',1,'CN2-677-800',30,'Person',7,7,NULL,'2021-09-28 14:23:30','2021-09-28 14:23:30',NULL),(45,'jordon33@example.net','+14797908808','424-299-0382',1,'CN2-677-800',15,'Company',7,7,NULL,'2021-09-28 14:23:30','2021-09-28 14:23:30',NULL),(46,'federico.ritchie@example.com','1-308-270-1254','202.229.4920',1,'CN2-677-800',31,'Person',7,7,NULL,'2021-09-28 14:23:30','2021-09-28 14:23:30',NULL),(47,'marcellus.labadie@example.com','+1-815-559-7786','+1-816-983-6096',1,'CN2-677-800',32,'Person',7,7,NULL,'2021-09-28 14:23:30','2021-09-28 14:23:30',NULL),(48,'hansen.harrison@example.com','(281) 377-3675','207-785-0877',1,'CN2-677-800',16,'Company',7,7,NULL,'2021-09-28 14:23:30','2021-09-28 14:23:30',NULL);

--
-- Table structure for table `party_address`
--

CREATE TABLE `party_address` (
  `party_id` bigint(20) unsigned NOT NULL,
  `address_id` int(11) NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`party_id`,`address_id`),
  KEY `fk_party_has_address_address1_idx` (`address_id`),
  CONSTRAINT `fk_party_has_address_address1` FOREIGN KEY (`address_id`) REFERENCES `address` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `party_address_party_id_foreign` FOREIGN KEY (`party_id`) REFERENCES `party` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `party_address`
--


--
-- Table structure for table `party_vehicle`
--

CREATE TABLE `party_vehicle` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `party_id` bigint(20) unsigned NOT NULL,
  `vehicle_id` bigint(20) unsigned NOT NULL,
  `classification_id` bigint(20) unsigned NOT NULL,
  `transaction_id` bigint(20) unsigned NOT NULL,
  `title_number` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `is_owner` varchar(191) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Y',
  `security_interest` varchar(191) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
  `printed` varchar(191) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
  `deliver_district_id` bigint(20) unsigned NOT NULL,
  `status` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `issued_date` datetime DEFAULT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `party_vehicle_party_id_vehicle_id_is_owner_unique` (`party_id`,`vehicle_id`,`is_owner`),
  UNIQUE KEY `party_vehicle_party_id_vehicle_id_classification_id_unique` (`party_id`,`vehicle_id`,`classification_id`),
  UNIQUE KEY `party_vehicle_title_number_unique` (`title_number`),
  KEY `party_vehicle_vehicle_id_foreign` (`vehicle_id`),
  KEY `party_vehicle_classification_id_foreign` (`classification_id`),
  KEY `party_vehicle_transaction_id_foreign` (`transaction_id`),
  KEY `party_vehicle_deliver_district_id_foreign` (`deliver_district_id`),
  CONSTRAINT `party_vehicle_classification_id_foreign` FOREIGN KEY (`classification_id`) REFERENCES `classification_type` (`id`),
  CONSTRAINT `party_vehicle_deliver_district_id_foreign` FOREIGN KEY (`deliver_district_id`) REFERENCES `district` (`id`),
  CONSTRAINT `party_vehicle_party_id_foreign` FOREIGN KEY (`party_id`) REFERENCES `party` (`id`),
  CONSTRAINT `party_vehicle_transaction_id_foreign` FOREIGN KEY (`transaction_id`) REFERENCES `transaction` (`id`),
  CONSTRAINT `party_vehicle_vehicle_id_foreign` FOREIGN KEY (`vehicle_id`) REFERENCES `vehicle` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `party_vehicle`
--

INSERT INTO `party_vehicle` VALUES (1,11,7,2,1,'F4R-1-532','Y','N','N',1,'INPROGRESS',NULL,5,5,NULL,'2020-10-03 08:15:32','2021-10-03 07:15:32',NULL),(2,41,3,1,2,'8OA-2-729','Y','N','N',1,'REGISTERED','2021-10-03 18:54:55',5,8,NULL,'2020-10-03 08:32:33','2021-10-03 07:54:55',NULL),(3,28,1,3,8,'WEK-8-272','Y','N','N',1,'INPROGRESS',NULL,5,5,NULL,'2010-10-03 08:15:21','2021-10-03 08:15:21',NULL),(7,46,2,3,12,'158-12-505','Y','N','N',1,'INPROGRESS',NULL,5,5,NULL,'2019-10-04 12:51:15','2021-10-04 11:51:15',NULL),(8,2,18,1,13,'RUS-13-726','Y','N','N',1,'INPROGRESS',NULL,5,5,NULL,'2018-10-04 12:58:52','2021-10-04 11:58:52',NULL),(9,10,9,1,14,'TVP-14-641','Y','N','N',1,'INPROGRESS',NULL,5,5,NULL,'2017-10-04 12:14:45','2021-10-04 12:14:45',NULL),(10,38,5,1,15,'88S-15-227','Y','N','N',1,'REGISTERED','2021-10-05 23:13:17',5,8,NULL,'2021-01-04 12:25:49','2021-10-05 12:13:17',NULL),(11,11,11,1,20,'JT1-20-417','Y','N','N',18,'INPROGRESS',NULL,1,1,NULL,'2021-10-05 13:13:11','2021-10-05 13:13:11',NULL);

--
-- Table structure for table `party_vehicle_purchase`
--

CREATE TABLE `party_vehicle_purchase` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `purchase_date` datetime DEFAULT NULL,
  `sale_date` datetime DEFAULT NULL,
  `purchase_price` decimal(10,2) DEFAULT NULL,
  `sale_price` decimal(10,2) DEFAULT NULL,
  `buyer_party_id` bigint(20) unsigned NOT NULL,
  `seller_party_id` bigint(20) unsigned DEFAULT NULL,
  `vehicle_id` bigint(20) unsigned NOT NULL,
  `comments` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `party_vehicle_purchase_buyer_party_id_foreign` (`buyer_party_id`),
  KEY `party_vehicle_purchase_seller_party_id_foreign` (`seller_party_id`),
  KEY `party_vehicle_purchase_vehicle_id_foreign` (`vehicle_id`),
  CONSTRAINT `party_vehicle_purchase_buyer_party_id_foreign` FOREIGN KEY (`buyer_party_id`) REFERENCES `party` (`id`),
  CONSTRAINT `party_vehicle_purchase_seller_party_id_foreign` FOREIGN KEY (`seller_party_id`) REFERENCES `party` (`id`),
  CONSTRAINT `party_vehicle_purchase_vehicle_id_foreign` FOREIGN KEY (`vehicle_id`) REFERENCES `vehicle` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `party_vehicle_purchase`
--

INSERT INTO `party_vehicle_purchase` VALUES (1,'2021-10-02 04:38:52',NULL,123.00,NULL,31,NULL,1,NULL,5,5,NULL,'2021-10-01 18:38:52','2021-10-01 18:38:52',NULL),(2,'2021-10-02 04:39:25',NULL,12.00,NULL,19,NULL,2,NULL,5,5,NULL,'2021-10-01 18:39:25','2021-10-01 18:39:25',NULL),(3,'2021-10-02 04:39:46',NULL,678.00,NULL,20,NULL,3,NULL,5,5,NULL,'2021-10-01 18:39:46','2021-10-01 18:39:46',NULL),(4,'2021-10-02 04:40:09',NULL,567.00,NULL,40,NULL,7,NULL,5,5,NULL,'2021-10-01 18:40:09','2021-10-01 18:40:09',NULL);

--
-- Table structure for table `payment`
--

CREATE TABLE `payment` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `payment_amount` decimal(10,2) NOT NULL,
  `payment_date` datetime DEFAULT NULL,
  `external_payment_reference_no` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `payment_method_id` bigint(20) unsigned NOT NULL,
  `paid_by` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `paid_by_mobile` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `siinpay_payref_number` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `payment_payment_method_id_foreign` (`payment_method_id`),
  CONSTRAINT `payment_payment_method_id_foreign` FOREIGN KEY (`payment_method_id`) REFERENCES `payment_method` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `payment`
--

INSERT INTO `payment` VALUES (1,25.00,'2021-10-03 18:54:00','23',1,'acd','1234',NULL,7,7,NULL,'2021-10-03 07:54:00','2021-10-03 07:54:00',NULL),(4,70.00,'2021-10-04 13:09:01','123',2,'sdfdsf','34343',NULL,7,7,NULL,'2021-10-04 02:09:01','2021-10-04 02:09:01',NULL),(5,70.00,'2021-10-04 13:35:49','234',1,'dfd','32454325',NULL,7,7,NULL,'2021-10-04 02:35:49','2021-10-04 02:35:49',NULL),(8,70.00,'2021-10-04 13:52:14','dsfdsf',2,'234324','343',NULL,7,7,NULL,'2021-10-04 02:52:14','2021-10-04 02:52:14',NULL),(9,70.00,'2021-10-04 13:53:38','123',2,'213','2323',NULL,7,7,NULL,'2021-10-04 02:53:38','2021-10-04 02:53:38',NULL),(10,70.00,'2021-10-04 13:53:38','123',2,'213','2323',NULL,7,7,NULL,'2021-10-04 02:53:38','2021-10-04 02:53:38',NULL),(11,70.00,'2021-10-04 13:53:38','123',2,'213','2323',NULL,7,7,NULL,'2021-10-04 02:53:38','2021-10-04 02:53:38',NULL),(12,70.00,'2021-10-04 13:53:38','123',2,'213','2323',NULL,7,7,NULL,'2021-10-04 02:53:38','2021-10-04 02:53:38',NULL),(13,70.00,'2021-10-04 13:53:38','123',2,'213','2323',NULL,7,7,NULL,'2021-10-04 02:53:38','2021-10-04 02:53:38',NULL),(14,25.00,'2021-10-05 23:12:38','23321',1,'34','3434',NULL,7,7,NULL,'2021-10-05 12:12:38','2021-10-05 12:12:38',NULL),(15,56.00,'2021-10-06 00:16:48','34',2,'34','3343',NULL,7,7,NULL,'2021-10-05 13:16:48','2021-10-05 13:16:48',NULL),(16,56.00,'2021-10-06 00:16:48','34',2,'34','3343',NULL,7,7,NULL,'2021-10-05 13:16:48','2021-10-05 13:16:48',NULL),(17,56.00,'2021-10-06 00:16:48','34',2,'34','3343',NULL,7,7,NULL,'2021-10-05 13:16:48','2021-10-05 13:16:48',NULL),(18,56.00,'2021-10-06 00:16:48','34',2,'34','3343',NULL,7,7,NULL,'2021-10-05 13:16:48','2021-10-05 13:16:48',NULL);

--
-- Table structure for table `payment_method`
--

CREATE TABLE `payment_method` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `payment_method_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `payment_method`
--

INSERT INTO `payment_method` VALUES (1,'Visa',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(2,'Mastercard',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(3,'Paypal',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(4,'Cash',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL);

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

CREATE TABLE `permissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `guard_name` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `permissions` VALUES (1,'view_backend','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(2,'edit_settings','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(3,'view_logs','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(4,'non_transactional','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(5,'list_transactions','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(6,'list_invoice','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(7,'view_invoice','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(8,'collect_payment','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(9,'print_document','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(10,'create_tax_workflow','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(11,'register_title_workflow','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(12,'assign_smarttag_workflow','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(13,'transfer_vehicle_workflow','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(14,'view_all_workflow','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(15,'claim_workflow','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(16,'release_workflow','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(17,'view_party','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(18,'create_party','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(19,'update_party','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(20,'view_vehicle','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(21,'view_users','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(22,'add_users','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(23,'edit_users','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(24,'delete_users','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(25,'restore_users','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(26,'block_users','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(27,'view_roles','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(28,'add_roles','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(29,'edit_roles','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(30,'delete_roles','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(31,'restore_roles','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(32,'view_backups','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(33,'add_backups','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(34,'create_backups','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(35,'download_backups','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(36,'delete_backups','web','2021-10-08 01:53:28','2021-10-08 01:53:28');

--
-- Table structure for table `person`
--

CREATE TABLE `person` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `first_name` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `second_name` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `third_name` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fourth_name` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_of_birth` datetime NOT NULL,
  `gender` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `occupation` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `place_of_birth` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `height` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `weight` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `eye_color` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `hair_color` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `mother_first_name` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mother_second_name` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mother_third_name` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mother_fourth_name` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `father_first_name` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `father_second_name` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `father_third_name` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `father_fourth_name` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned 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=33 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `person`
--

INSERT INTO `person` VALUES (1,'Janiya','Kristofer','Effertz','Johnston','2010-03-28 00:00:00','Male','Engineer','London','123','123','Blue','Black','Wallace','Maurine','Toy','Quigley','Katelin','Enola','Smitham','Strosin',1,1,NULL,'2021-09-28 04:01:35','2021-09-28 04:01:35',NULL),(2,'Sophie','Ludwig','Cummerata','Stracke','1984-10-05 00:00:00','Female','Engineer','London','123','123','Blue','Black','Cali','Odessa','Labadie','Nader','Javonte','Elise','Gusikowski','Little',1,1,NULL,'2021-09-28 04:01:35','2021-09-28 04:01:35',NULL),(3,'Dennis','Jaydon','Huels','Wiegand','2003-01-13 00:00:00','Female','Engineer','London','123','123','Blue','Black','Nicholas','Aniyah','Smith','Okuneva','Darryl','Virginie','Waters','Russel',1,1,NULL,'2021-09-28 04:01:37','2021-09-28 04:01:37',NULL),(4,'Jammie','Savanna','Huel','Okuneva','2013-08-26 00:00:00','Male','Engineer','London','123','123','Blue','Black','Margarette','Manuel','Parisian','Hills','Sincere','Zoe','Corwin','Lind',1,1,NULL,'2021-09-28 04:01:37','2021-09-28 04:01:37',NULL),(5,'Larry','Alexys','Marks','Koelpin','1992-02-16 00:00:00','Male','Engineer','London','123','123','Blue','Black','Sydnee','Erik','Krajcik','Hintz','Hank','Ellsworth','Hermann','Schumm',1,1,NULL,'2021-09-28 04:01:38','2021-09-28 04:01:38',NULL),(6,'Sheila','Alexandro','Lemke','Balistreri','2008-01-23 00:00:00','Male','Engineer','London','123','123','Blue','Black','Corrine','Iliana','Rutherford','Heathcote','Juliana','Dominique','Wunsch','Lebsack',1,1,NULL,'2021-09-28 04:01:38','2021-09-28 04:01:38',NULL),(7,'Elza','Grady','Jacobi','Lueilwitz','2005-01-14 00:00:00','Female','Engineer','London','123','123','Blue','Black','Dangelo','Ludie','Murray','Rodriguez','Henry','Tara','Howell','Connelly',1,1,NULL,'2021-09-28 04:01:38','2021-09-28 04:01:38',NULL),(8,'Carmella','Dave','Donnelly','Witting','1996-01-04 00:00:00','Female','Engineer','London','123','123','Blue','Black','Shayna','Lera','Mills','Mayert','Kurt','Enrico','Gusikowski','Parker',1,1,NULL,'2021-09-28 04:01:38','2021-09-28 04:01:38',NULL),(9,'Marlin','Cyrus','Grimes','Zieme','1972-09-08 00:00:00','Female','Engineer','London','123','123','Blue','Black','Jerrell','Rickie','O\'Keefe','Davis','Jeanie','Darlene','Morar','Kohler',1,1,NULL,'2021-09-28 04:01:39','2021-09-28 04:01:39',NULL),(10,'Dante','Horacio','Yost','Gaylord','1989-12-29 00:00:00','Female','Engineer','London','123','123','Blue','Black','Anabelle','D\'angelo','Von','Gorczany','Chadd','Tatyana','Champlin','Kilback',1,1,NULL,'2021-09-28 04:01:39','2021-09-28 04:01:39',NULL),(11,'Reese','Cesar','Windler','Hettinger','2016-07-12 00:00:00','Male','Engineer','London','123','123','Blue','Black','Dean','Brandon','Wolf','Blanda','Haskell','Kylee','Hand','Reinger',1,1,NULL,'2021-09-28 04:01:39','2021-09-28 04:01:39',NULL),(12,'Deon','Abe','Hackett','Douglas','1981-09-12 00:00:00','Male','Engineer','London','123','123','Blue','Black','Kyler','Isabell','Schneider','Stehr','Sarah','Kirstin','Cole','Stroman',1,1,NULL,'2021-09-28 04:01:39','2021-09-28 04:01:39',NULL),(13,'Alf','Felicia','Rempel','Gottlieb','2015-12-17 00:00:00','Female','Engineer','London','123','123','Blue','Black','Salvador','Lenore','Hyatt','Monahan','Savannah','Branson','Cremin','Kozey',1,1,NULL,'2021-09-28 04:01:40','2021-09-28 04:01:40',NULL),(14,'Annie','Maymie','Keebler','West','2013-12-10 00:00:00','Female','Engineer','London','123','123','Blue','Black','Shakira','Catharine','Predovic','Buckridge','Queenie','Sienna','Kub','Stanton',1,1,NULL,'2021-09-28 04:01:40','2021-09-28 04:01:40',NULL),(15,'Lynn','Fabiola','Kutch','O\'Hara','1981-03-09 00:00:00','Female','Engineer','London','123','123','Blue','Black','Myra','Natalia','Davis','Quitzon','Malvina','Hope','Hilpert','Harvey',1,1,NULL,'2021-09-28 04:01:40','2021-09-28 04:01:40',NULL),(16,'Nicholas','Isabell','Erdman','Huels','2005-03-26 00:00:00','Female','Engineer','London','123','123','Blue','Black','Eleonore','Erin','Bergstrom','Hyatt','Deja','Rylee','O\'Hara','Lebsack',1,1,NULL,'2021-09-28 04:01:40','2021-09-28 04:01:40',NULL),(17,'Loraine','Wayne','Grady','Koss','1986-08-14 00:00:00','Male','Engineer','London','123','123','Blue','Black','Jefferey','Desmond','Sipes','Buckridge','Justus','Major','Connelly','Fadel',7,7,NULL,'2021-09-28 14:23:26','2021-09-28 14:23:26',NULL),(18,'Lesly','Corene','Schuster','Mertz','2000-06-29 00:00:00','Male','Engineer','London','123','123','Blue','Black','Saige','Derek','Bruen','Olson','Kathryne','Roselyn','Kertzmann','Gorczany',7,7,NULL,'2021-09-28 14:23:26','2021-09-28 14:23:26',NULL),(19,'Gwendolyn','Kasandra','Gutmann','Predovic','2017-11-30 00:00:00','Female','Engineer','London','123','123','Blue','Black','Melody','Clifton','Krajcik','Shields','Magnus','Anderson','Kautzer','Mitchell',7,7,NULL,'2021-09-28 14:23:28','2021-09-28 14:23:28',NULL),(20,'Darryl','Megane','Kiehn','Klein','1980-10-30 00:00:00','Male','Engineer','London','123','123','Blue','Black','Amelia','Tess','Mante','Larkin','Lelia','Rosalind','Blanda','Morar',7,7,NULL,'2021-09-28 14:23:28','2021-09-28 14:23:28',NULL),(21,'Alejandra','Harmony','Roberts','Hilpert','1996-10-22 00:00:00','Male','Engineer','London','123','123','Blue','Black','Roxane','Melvin','Dickinson','Hartmann','George','Halle','Flatley','Considine',7,7,NULL,'2021-09-28 14:23:28','2021-09-28 14:23:28',NULL),(22,'Pearl','Kaela','Jakubowski','Feest','1995-03-02 00:00:00','Female','Engineer','London','123','123','Blue','Black','Glenna','Jeff','Pfeffer','Waelchi','Lue','Louvenia','Marks','Schowalter',7,7,NULL,'2021-09-28 14:23:28','2021-09-28 14:23:28',NULL),(23,'Crystal','Amiya','Tremblay','Rath','1991-11-09 00:00:00','Female','Engineer','London','123','123','Blue','Black','Ettie','Martin','Russel','Barrows','Maegan','Alvena','Ondricka','Mohr',7,7,NULL,'2021-09-28 14:23:29','2021-09-28 14:23:29',NULL),(24,'Manuela','Hayden','Jacobi','Ziemann','2012-11-03 00:00:00','Male','Engineer','London','123','123','Blue','Black','Marilou','Ryley','Turner','Sawayn','Garth','Terrance','Hayes','Walker',7,7,NULL,'2021-09-28 14:23:29','2021-09-28 14:23:29',NULL),(25,'Gianni','Rickie','Veum','Schuppe','1970-06-07 00:00:00','Male','Engineer','London','123','123','Blue','Black','Jerrod','Reagan','Marks','Cruickshank','Zetta','Cathrine','Torphy','Gulgowski',7,7,NULL,'2021-09-28 14:23:29','2021-09-28 14:23:29',NULL),(26,'Chauncey','Greta','Schowalter','Brown','1972-06-29 00:00:00','Female','Engineer','London','123','123','Blue','Black','Elinore','Ramon','Kunde','Crist','Jessyca','Zoey','Langworth','Kessler',7,7,NULL,'2021-09-28 14:23:29','2021-09-28 14:23:29',NULL),(27,'Bethany','Kameron','Altenwerth','Rohan','2011-09-26 00:00:00','Female','Engineer','London','123','123','Blue','Black','Kathlyn','Taylor','Kovacek','Doyle','Mylene','Raquel','Miller','Blanda',7,7,NULL,'2021-09-28 14:23:29','2021-09-28 14:23:29',NULL),(28,'Daniella','Enrico','Jacobson','Schamberger','1994-07-18 00:00:00','Male','Engineer','London','123','123','Blue','Black','Tressie','Pink','Harris','Conroy','Ashley','Jazlyn','Braun','Toy',7,7,NULL,'2021-09-28 14:23:29','2021-09-28 14:23:29',NULL),(29,'Jessika','Flavie','Wisoky','Runolfsson','2010-12-15 00:00:00','Male','Engineer','London','123','123','Blue','Black','Otha','Neil','Rau','Romaguera','Felicity','Ora','Williamson','Howe',7,7,NULL,'2021-09-28 14:23:30','2021-09-28 14:23:30',NULL),(30,'Burley','Jedediah','Weissnat','Davis','1972-04-16 00:00:00','Female','Engineer','London','123','123','Blue','Black','Alberta','Donnell','Kuvalis','Little','Otilia','Bradford','Mueller','Stanton',7,7,NULL,'2021-09-28 14:23:30','2021-09-28 14:23:30',NULL),(31,'Christelle','Wiley','Swaniawski','Bergstrom','1976-09-04 00:00:00','Female','Engineer','London','123','123','Blue','Black','Geovanni','Eudora','Ruecker','Champlin','Eloy','Simone','Harvey','Stroman',7,7,NULL,'2021-09-28 14:23:30','2021-09-28 14:23:30',NULL),(32,'Dylan','Cory','Gleason','Kling','1989-12-20 00:00:00','Female','Engineer','London','123','123','Blue','Black','Rickey','Hosea','Considine','Medhurst','Ena','Verna','Jacobs','Wilderman',7,7,NULL,'2021-09-28 14:23:30','2021-09-28 14:23:30',NULL);

--
-- Table structure for table `posts`
--

CREATE TABLE `posts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `slug` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `intro` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `category_id` int(10) unsigned DEFAULT NULL,
  `category_name` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `is_featured` int(11) DEFAULT NULL,
  `featured_image` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `meta_title` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `meta_keywords` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `meta_description` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `meta_og_image` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `meta_og_url` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `hits` int(10) unsigned NOT NULL DEFAULT 0,
  `order` int(11) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `moderated_by` int(10) unsigned DEFAULT NULL,
  `moderated_at` datetime DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `created_by_name` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_by_alias` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `published_at` timestamp NULL 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=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `posts`
--


--
-- Table structure for table `region`
--

CREATE TABLE `region` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `region_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `region`
--

INSERT INTO `region` VALUES (1,'Mudug',1,NULL,NULL,'2021-10-05 09:24:46',NULL,NULL),(2,'Sanaag',1,NULL,NULL,'2021-10-05 09:24:46',NULL,NULL),(3,'Haylaan',1,NULL,NULL,'2021-10-05 09:24:46',NULL,NULL),(4,'Nugaal',1,NULL,NULL,'2021-10-05 09:24:46',NULL,NULL),(5,'Bari',1,NULL,NULL,'2021-10-05 09:24:46',NULL,NULL),(6,'Karkaar',1,NULL,NULL,'2021-10-05 09:24:46',NULL,NULL),(7,'Gardafuu',1,NULL,NULL,'2021-10-05 09:24:46',NULL,NULL),(8,'Sool',1,NULL,NULL,'2021-10-05 09:24:46',NULL,NULL),(9,'Cayn',1,NULL,NULL,'2021-10-05 09:24:46',NULL,NULL);

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` VALUES (1,2),(1,3),(1,4),(1,5),(1,6),(1,7),(1,8),(2,2),(3,2),(4,2),(4,3),(4,4),(5,2),(6,2),(6,7),(7,2),(7,5),(7,7),(8,2),(8,7),(9,2),(9,8),(10,2),(10,5),(11,2),(11,5),(12,2),(12,5),(13,2),(13,5),(14,2),(15,2),(15,5),(15,6),(15,7),(15,8),(16,2),(17,2),(17,5),(17,6),(17,7),(17,8),(18,2),(18,5),(19,2),(20,2),(20,5),(20,6),(20,7),(20,8),(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);

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

CREATE TABLE `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `guard_name` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `roles` VALUES (1,'super admin','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(2,'administrator','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(3,'manager','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(4,'executive','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(5,'teller','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(6,'officer','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(7,'payment','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(8,'delivery','web','2021-10-08 01:53:28','2021-10-08 01:53:28'),(9,'completed','web','2021-10-08 01:53:28','2021-10-08 01:53:28');

--
-- Table structure for table `service`
--

CREATE TABLE `service` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned 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=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `service`
--

INSERT INTO `service` VALUES (1,'Title','Title Registration',1,1,NULL,'2021-09-23 21:06:08','2021-09-23 21:06:08',NULL),(2,'Tax','Quarterly Tax Payment',1,1,NULL,'2021-09-23 21:07:27','2021-09-23 21:07:27',NULL),(3,'Transfer','Title Transfer',1,1,NULL,'2021-09-23 21:07:28','2021-09-23 21:07:28',NULL),(4,'Ban','Ban Vehicle',1,1,NULL,'2021-09-23 21:07:29','2021-09-23 21:07:29',NULL);

--
-- Table structure for table `service_fee`
--

CREATE TABLE `service_fee` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `service_id` bigint(20) unsigned NOT NULL,
  `sub_category_id` bigint(20) unsigned DEFAULT NULL,
  `classification_id` bigint(20) unsigned DEFAULT NULL,
  `fee_name` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `fee` decimal(10,2) NOT NULL,
  `district_id` bigint(20) unsigned DEFAULT NULL,
  `frequency_type_id` bigint(20) unsigned NOT NULL,
  `recurring` varchar(45) COLLATE utf8_unicode_ci DEFAULT 'N',
  `fee_description` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `service_fee_service_id_foreign` (`service_id`),
  KEY `service_fee_sub_category_id_foreign` (`sub_category_id`),
  KEY `service_fee_classification_id_foreign` (`classification_id`),
  KEY `service_fee_district_id_foreign` (`district_id`),
  KEY `service_fee_frequency_type_id_foreign` (`frequency_type_id`),
  CONSTRAINT `service_fee_classification_id_foreign` FOREIGN KEY (`classification_id`) REFERENCES `classification_type` (`id`),
  CONSTRAINT `service_fee_district_id_foreign` FOREIGN KEY (`district_id`) REFERENCES `district` (`id`),
  CONSTRAINT `service_fee_frequency_type_id_foreign` FOREIGN KEY (`frequency_type_id`) REFERENCES `frequency_type` (`id`),
  CONSTRAINT `service_fee_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `service` (`id`),
  CONSTRAINT `service_fee_sub_category_id_foreign` FOREIGN KEY (`sub_category_id`) REFERENCES `sub_category` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `service_fee`
--

INSERT INTO `service_fee` VALUES (1,1,NULL,NULL,'Service Fee',12.00,NULL,4,'N','Service Fee for Title Registration',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(2,2,NULL,NULL,'Service Fee',10.00,NULL,2,'N','Service Fee for Tax Registration',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(3,1,1,1,'Title Fee',13.00,NULL,4,'N','Government Fee for Title Registration',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(4,1,1,2,'Title Fee',18.00,NULL,4,'N','Government Fee for Title Registration',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(5,1,1,3,'Title Fee',21.00,NULL,4,'N','Government Fee for Title Registration',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(6,2,1,1,'Tax Fee',4.00,NULL,4,'N','Quertery Tax Fee',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(7,2,1,2,'Tax Fee',6.00,NULL,4,'N','Quertery Tax Fee',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(8,2,1,3,'Tax Fee',28.00,NULL,4,'N','Quertery Tax Fee',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL);

--
-- Table structure for table `service_purchase`
--

CREATE TABLE `service_purchase` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `party_id` bigint(20) unsigned NOT NULL,
  `service_id` bigint(20) unsigned NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `service_purchase_party_id_foreign` (`party_id`),
  KEY `service_purchase_service_id_foreign` (`service_id`),
  CONSTRAINT `service_purchase_party_id_foreign` FOREIGN KEY (`party_id`) REFERENCES `party` (`id`),
  CONSTRAINT `service_purchase_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `service` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `service_purchase`
--

INSERT INTO `service_purchase` VALUES (1,11,1,5,5,NULL,'2021-10-03 07:15:32','2021-10-03 07:15:32',NULL),(2,41,1,5,5,NULL,'2021-10-03 07:32:33','2021-10-03 07:32:33',NULL),(3,41,2,8,8,NULL,'2021-10-03 08:11:30','2021-10-03 08:11:30',NULL),(4,41,2,8,8,NULL,'2021-10-03 08:11:30','2021-10-03 08:11:30',NULL),(5,41,2,8,8,NULL,'2021-10-03 08:11:30','2021-10-03 08:11:30',NULL),(6,41,2,8,8,NULL,'2021-10-03 08:11:30','2021-10-03 08:11:30',NULL),(7,41,2,8,8,NULL,'2021-10-03 08:11:30','2021-10-03 08:11:30',NULL),(8,28,1,5,5,NULL,'2021-10-03 08:15:21','2021-10-03 08:15:21',NULL),(12,46,1,5,5,NULL,'2021-10-04 11:51:15','2021-10-04 11:51:15',NULL),(13,2,1,5,5,NULL,'2021-10-04 11:58:52','2021-10-04 11:58:52',NULL),(14,10,1,5,5,NULL,'2021-10-04 12:14:45','2021-10-04 12:14:45',NULL),(15,38,1,5,5,NULL,'2021-10-04 12:25:49','2021-10-04 12:25:49',NULL),(16,38,2,1,1,NULL,'2021-10-05 12:13:41','2021-10-05 12:13:41',NULL),(17,38,2,1,1,NULL,'2021-10-05 12:13:42','2021-10-05 12:13:42',NULL),(18,38,2,1,1,NULL,'2021-10-05 12:13:44','2021-10-05 12:13:44',NULL),(19,38,2,1,1,NULL,'2021-10-05 12:13:47','2021-10-05 12:13:47',NULL),(20,11,1,1,1,NULL,'2021-10-05 13:13:11','2021-10-05 13:13:11',NULL);

--
-- Table structure for table `service_workflow`
--

CREATE TABLE `service_workflow` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `service_id` bigint(20) unsigned NOT NULL,
  `workflow_id` bigint(20) unsigned NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `service_workflow_service_id_foreign` (`service_id`),
  KEY `service_workflow_workflow_id_foreign` (`workflow_id`),
  CONSTRAINT `service_workflow_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `service` (`id`),
  CONSTRAINT `service_workflow_workflow_id_foreign` FOREIGN KEY (`workflow_id`) REFERENCES `workflow` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `service_workflow`
--

INSERT INTO `service_workflow` VALUES (1,1,1,1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(2,2,2,1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL);

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `val` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` char(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'string',
  `created_by` int(10) unsigned DEFAULT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned 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=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `settings`
--


--
-- Table structure for table `sub_category`
--

CREATE TABLE `sub_category` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sub_category_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `sub_category`
--

INSERT INTO `sub_category` VALUES (1,'HP1',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(2,'HP10',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(3,'HP12',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(4,'HP14',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(5,'HP16',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(6,'HP18',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(7,'HP2',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(8,'HP21',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(9,'HP24',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(10,'HP3',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(11,'HP4',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(12,'HP6',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(13,'HP8',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL);

--
-- Table structure for table `tax_sticker`
--

CREATE TABLE `tax_sticker` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `assigned` varchar(45) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned 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=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tax_sticker`
--

INSERT INTO `tax_sticker` VALUES (1,'ABCD1234','Y',1,8,NULL,'2021-08-31 14:00:00','2021-10-04 10:52:06',NULL),(2,'QWER1234','N',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(3,'ASDF1234','N',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(4,'ZXCV1234','N',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL);

--
-- Table structure for table `term`
--

CREATE TABLE `term` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `year` int(11) NOT NULL,
  `quarter` int(11) NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned 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=101 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `term`
--

INSERT INTO `term` VALUES (1,2000,1,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(2,2000,2,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(3,2000,3,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(4,2000,4,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(5,2001,1,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(6,2001,2,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(7,2001,3,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(8,2001,4,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(9,2002,1,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(10,2002,2,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(11,2002,3,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(12,2002,4,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(13,2003,1,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(14,2003,2,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(15,2003,3,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(16,2003,4,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(17,2004,1,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(18,2004,2,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(19,2004,3,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(20,2004,4,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(21,2005,1,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(22,2005,2,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(23,2005,3,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(24,2005,4,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(25,2006,1,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(26,2006,2,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(27,2006,3,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(28,2006,4,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(29,2007,1,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(30,2007,2,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(31,2007,3,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(32,2007,4,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(33,2008,1,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(34,2008,2,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(35,2008,3,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(36,2008,4,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(37,2009,1,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(38,2009,2,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(39,2009,3,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(40,2009,4,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(41,2010,1,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(42,2010,2,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(43,2010,3,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(44,2010,4,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(45,2011,1,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(46,2011,2,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(47,2011,3,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(48,2011,4,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(49,2012,1,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(50,2012,2,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(51,2012,3,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(52,2012,4,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(53,2013,1,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(54,2013,2,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(55,2013,3,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(56,2013,4,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(57,2014,1,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(58,2014,2,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(59,2014,3,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(60,2014,4,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(61,2015,1,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(62,2015,2,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(63,2015,3,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(64,2015,4,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(65,2016,1,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(66,2016,2,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(67,2016,3,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(68,2016,4,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(69,2017,1,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(70,2017,2,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(71,2017,3,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(72,2017,4,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(73,2018,1,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(74,2018,2,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(75,2018,3,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(76,2018,4,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(77,2019,1,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(78,2019,2,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(79,2019,3,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(80,2019,4,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(81,2020,1,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(82,2020,2,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(83,2020,3,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(84,2020,4,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(85,2021,1,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(86,2021,2,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(87,2021,3,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(88,2021,4,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(89,2022,1,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(90,2022,2,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(91,2022,3,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(92,2022,4,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(93,2023,1,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(94,2023,2,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(95,2023,3,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(96,2023,4,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(97,2024,1,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(98,2024,2,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(99,2024,3,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL),(100,2024,4,1,1,NULL,'2021-10-03 00:33:13','2021-10-03 00:33:13',NULL);

--
-- Table structure for table `transaction`
--

CREATE TABLE `transaction` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `service_purchase_id` bigint(20) unsigned NOT NULL,
  `service_workflow_id` bigint(20) unsigned NOT NULL,
  `assigned_to` int(11) DEFAULT NULL,
  `party_id` bigint(20) unsigned NOT NULL,
  `vehicle_id` bigint(20) unsigned NOT NULL,
  `invoice_id` bigint(20) unsigned DEFAULT NULL,
  `party_vehicle_id` int(11) DEFAULT NULL,
  `vehicle_tax_id` int(11) DEFAULT NULL,
  `current_workflow_state_id` bigint(20) unsigned NOT NULL,
  `status` varchar(191) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'PENDING',
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `transaction_service_purchase_id_foreign` (`service_purchase_id`),
  KEY `transaction_service_workflow_id_foreign` (`service_workflow_id`),
  KEY `transaction_party_id_foreign` (`party_id`),
  KEY `transaction_vehicle_id_foreign` (`vehicle_id`),
  KEY `transaction_current_workflow_state_id_foreign` (`current_workflow_state_id`),
  CONSTRAINT `transaction_current_workflow_state_id_foreign` FOREIGN KEY (`current_workflow_state_id`) REFERENCES `workflow_definition` (`id`),
  CONSTRAINT `transaction_party_id_foreign` FOREIGN KEY (`party_id`) REFERENCES `party` (`id`),
  CONSTRAINT `transaction_service_purchase_id_foreign` FOREIGN KEY (`service_purchase_id`) REFERENCES `service_purchase` (`id`),
  CONSTRAINT `transaction_service_workflow_id_foreign` FOREIGN KEY (`service_workflow_id`) REFERENCES `service_workflow` (`id`),
  CONSTRAINT `transaction_vehicle_id_foreign` FOREIGN KEY (`vehicle_id`) REFERENCES `vehicle` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `transaction`
--

INSERT INTO `transaction` VALUES (1,1,1,NULL,11,7,1,1,NULL,2,'INPROGRESS',5,5,NULL,'2021-10-03 07:15:32','2021-10-03 07:15:32',NULL),(2,2,1,NULL,41,3,2,2,NULL,5,'COMPLETED',5,8,NULL,'2021-10-03 07:32:33','2021-10-03 07:54:55',NULL),(3,3,2,NULL,41,3,3,2,1,9,'COMPLETED',8,8,NULL,'2021-10-03 08:11:30','2021-10-04 10:58:22',NULL),(4,4,2,8,41,3,4,2,2,8,'INPROGRESS',8,8,NULL,'2021-10-03 08:11:30','2021-10-04 05:34:02',NULL),(5,5,2,NULL,41,3,5,2,3,8,'INPROGRESS',8,7,NULL,'2021-10-03 08:11:30','2021-10-04 02:53:38',NULL),(6,6,2,NULL,41,3,6,2,4,8,'INPROGRESS',8,7,NULL,'2021-10-03 08:11:30','2021-10-04 02:53:38',NULL),(7,7,2,NULL,41,3,7,2,5,8,'INPROGRESS',8,7,NULL,'2021-10-03 08:11:30','2021-10-04 02:53:39',NULL),(8,8,1,NULL,28,1,8,3,NULL,3,'INPROGRESS',5,6,NULL,'2021-10-03 08:15:21','2021-10-03 08:53:58',NULL),(12,12,1,NULL,46,2,12,7,NULL,2,'INPROGRESS',5,5,NULL,'2021-10-04 11:51:15','2021-10-04 11:51:16',NULL),(13,13,1,NULL,2,18,13,8,NULL,2,'INPROGRESS',5,5,NULL,'2021-10-04 11:58:52','2021-10-04 11:58:53',NULL),(14,14,1,NULL,10,9,14,9,NULL,2,'INPROGRESS',5,5,NULL,'2021-10-04 12:14:45','2021-10-04 12:14:46',NULL),(15,15,1,NULL,38,5,15,10,NULL,5,'COMPLETED',5,8,NULL,'2021-10-04 12:25:49','2021-10-05 12:13:17',NULL),(16,16,2,NULL,38,5,16,10,6,8,'PAID',1,7,NULL,'2021-10-05 12:13:41','2021-10-05 13:16:48',NULL),(17,17,2,NULL,38,5,17,10,7,8,'PAID',1,7,NULL,'2021-10-05 12:13:42','2021-10-05 13:16:48',NULL),(18,18,2,NULL,38,5,18,10,8,8,'PAID',1,7,NULL,'2021-10-05 12:13:44','2021-10-05 13:16:48',NULL),(19,19,2,NULL,38,5,19,10,9,8,'PAID',1,7,NULL,'2021-10-05 12:13:47','2021-10-05 13:16:48',NULL),(20,20,1,NULL,11,11,20,11,NULL,2,'INPROGRESS',1,1,NULL,'2021-10-05 13:13:11','2021-10-05 13:13:15',NULL);

--
-- Table structure for table `transaction_workflow`
--

CREATE TABLE `transaction_workflow` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `action` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `comments` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `action_date` datetime DEFAULT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `transaction_id` bigint(20) unsigned NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `transaction_workflow_role_id_foreign` (`role_id`),
  KEY `transaction_workflow_user_id_foreign` (`user_id`),
  KEY `transaction_workflow_transaction_id_foreign` (`transaction_id`),
  CONSTRAINT `transaction_workflow_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`),
  CONSTRAINT `transaction_workflow_transaction_id_foreign` FOREIGN KEY (`transaction_id`) REFERENCES `transaction` (`id`),
  CONSTRAINT `transaction_workflow_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `transaction_workflow`
--

INSERT INTO `transaction_workflow` VALUES (1,'INITIATED',NULL,'2021-10-03 18:15:32',5,5,1,5,5,NULL,'2021-10-03 07:15:32','2021-10-03 07:15:32',NULL),(2,'INITIATED',NULL,'2021-10-03 18:32:33',5,5,2,5,5,NULL,'2021-10-03 07:32:33','2021-10-03 07:32:33',NULL),(3,'CLAIMED',NULL,'2021-10-03 18:41:29',6,6,2,6,6,NULL,'2021-10-03 07:41:29','2021-10-03 07:41:29',NULL),(4,'APPROVED',NULL,'2021-10-03 18:53:33',6,6,2,6,6,NULL,'2021-10-03 07:53:33','2021-10-03 07:53:33',NULL),(5,'CLAIMED',NULL,'2021-10-03 18:53:45',7,7,2,7,7,NULL,'2021-10-03 07:53:45','2021-10-03 07:53:45',NULL),(6,'PAID',NULL,'2021-10-03 18:54:00',7,7,2,7,7,NULL,'2021-10-03 07:54:00','2021-10-03 07:54:00',NULL),(7,'CLAIMED',NULL,'2021-10-03 18:54:12',8,8,2,8,8,NULL,'2021-10-03 07:54:12','2021-10-03 07:54:12',NULL),(8,'APPROVED',NULL,'2021-10-03 18:54:55',8,8,2,8,8,NULL,'2021-10-03 07:54:55','2021-10-03 07:54:55',NULL),(9,'INITIATED',NULL,'2021-10-03 19:11:30',5,8,3,8,8,NULL,'2021-10-03 08:11:30','2021-10-03 08:11:30',NULL),(10,'INITIATED',NULL,'2021-10-03 19:11:30',5,8,4,8,8,NULL,'2021-10-03 08:11:30','2021-10-03 08:11:30',NULL),(11,'INITIATED',NULL,'2021-10-03 19:11:30',5,8,5,8,8,NULL,'2021-10-03 08:11:30','2021-10-03 08:11:30',NULL),(12,'INITIATED',NULL,'2021-10-03 19:11:30',5,8,6,8,8,NULL,'2021-10-03 08:11:30','2021-10-03 08:11:30',NULL),(13,'INITIATED',NULL,'2021-10-03 19:11:30',5,8,7,8,8,NULL,'2021-10-03 08:11:30','2021-10-03 08:11:30',NULL),(14,'INITIATED',NULL,'2021-10-03 19:15:21',5,5,8,5,5,NULL,'2021-10-03 08:15:21','2021-10-03 08:15:21',NULL),(15,'CLAIMED',NULL,'2021-10-03 19:53:53',6,6,8,6,6,NULL,'2021-10-03 08:53:53','2021-10-03 08:53:53',NULL),(16,'APPROVED',NULL,'2021-10-03 19:53:58',6,6,8,6,6,NULL,'2021-10-03 08:53:58','2021-10-03 08:53:58',NULL),(17,'PAID',NULL,'2021-10-04 13:09:01',7,7,3,7,7,NULL,'2021-10-04 02:09:01','2021-10-04 02:09:01',NULL),(18,'PAID',NULL,'2021-10-04 13:35:49',7,7,7,7,7,NULL,'2021-10-04 02:35:49','2021-10-04 02:35:49',NULL),(19,'PAID',NULL,'2021-10-04 13:52:14',7,7,7,7,7,NULL,'2021-10-04 02:52:14','2021-10-04 02:52:14',NULL),(20,'PAID',NULL,'2021-10-04 13:53:38',7,7,3,7,7,NULL,'2021-10-04 02:53:38','2021-10-04 02:53:38',NULL),(21,'PAID',NULL,'2021-10-04 13:53:38',7,7,4,7,7,NULL,'2021-10-04 02:53:38','2021-10-04 02:53:38',NULL),(22,'PAID',NULL,'2021-10-04 13:53:38',7,7,5,7,7,NULL,'2021-10-04 02:53:38','2021-10-04 02:53:38',NULL),(23,'PAID',NULL,'2021-10-04 13:53:38',7,7,6,7,7,NULL,'2021-10-04 02:53:38','2021-10-04 02:53:38',NULL),(24,'PAID',NULL,'2021-10-04 13:53:38',7,7,7,7,7,NULL,'2021-10-04 02:53:38','2021-10-04 02:53:38',NULL),(25,'CLAIMED',NULL,'2021-10-04 16:32:19',8,8,3,8,8,NULL,'2021-10-04 05:32:19','2021-10-04 05:32:19',NULL),(26,'CLAIMED',NULL,'2021-10-04 16:34:02',8,8,4,8,8,NULL,'2021-10-04 05:34:02','2021-10-04 05:34:02',NULL),(27,'APPROVED',NULL,'2021-10-04 21:55:26',8,8,3,8,8,NULL,'2021-10-04 10:55:26','2021-10-04 10:55:26',NULL),(28,'CLAIMED',NULL,'2021-10-04 21:57:17',8,8,3,8,8,NULL,'2021-10-04 10:57:17','2021-10-04 10:57:17',NULL),(29,'RELEASED',NULL,'2021-10-04 21:57:54',8,1,3,1,1,NULL,'2021-10-04 10:57:54','2021-10-04 10:57:54',NULL),(30,'APPROVED',NULL,'2021-10-04 21:58:22',8,8,3,8,8,NULL,'2021-10-04 10:58:22','2021-10-04 10:58:22',NULL),(34,'INITIATED',NULL,'2021-10-04 22:51:15',5,5,12,5,5,NULL,'2021-10-04 11:51:15','2021-10-04 11:51:15',NULL),(35,'INITIATED',NULL,'2021-10-04 22:58:52',5,5,13,5,5,NULL,'2021-10-04 11:58:52','2021-10-04 11:58:52',NULL),(36,'INITIATED',NULL,'2021-10-04 23:14:45',5,5,14,5,5,NULL,'2021-10-04 12:14:45','2021-10-04 12:14:45',NULL),(37,'INITIATED',NULL,'2021-10-04 23:25:49',5,5,15,5,5,NULL,'2021-10-04 12:25:49','2021-10-04 12:25:49',NULL),(38,'CLAIMED',NULL,'2021-10-05 23:12:04',6,6,15,6,6,NULL,'2021-10-05 12:12:04','2021-10-05 12:12:04',NULL),(39,'APPROVED',NULL,'2021-10-05 23:12:08',6,6,15,6,6,NULL,'2021-10-05 12:12:08','2021-10-05 12:12:08',NULL),(40,'CLAIMED',NULL,'2021-10-05 23:12:26',7,7,15,7,7,NULL,'2021-10-05 12:12:26','2021-10-05 12:12:26',NULL),(41,'PAID',NULL,'2021-10-05 23:12:38',7,7,15,7,7,NULL,'2021-10-05 12:12:38','2021-10-05 12:12:38',NULL),(42,'CLAIMED',NULL,'2021-10-05 23:13:09',8,8,15,8,8,NULL,'2021-10-05 12:13:09','2021-10-05 12:13:09',NULL),(43,'APPROVED',NULL,'2021-10-05 23:13:17',8,8,15,8,8,NULL,'2021-10-05 12:13:17','2021-10-05 12:13:17',NULL),(44,'INITIATED',NULL,'2021-10-05 23:13:41',5,1,16,1,1,NULL,'2021-10-05 12:13:41','2021-10-05 12:13:41',NULL),(45,'INITIATED',NULL,'2021-10-05 23:13:42',5,1,17,1,1,NULL,'2021-10-05 12:13:42','2021-10-05 12:13:42',NULL),(46,'INITIATED',NULL,'2021-10-05 23:13:44',5,1,18,1,1,NULL,'2021-10-05 12:13:44','2021-10-05 12:13:44',NULL),(47,'INITIATED',NULL,'2021-10-05 23:13:47',5,1,19,1,1,NULL,'2021-10-05 12:13:47','2021-10-05 12:13:47',NULL),(48,'INITIATED',NULL,'2021-10-06 00:13:11',5,1,20,1,1,NULL,'2021-10-05 13:13:11','2021-10-05 13:13:11',NULL),(49,'PAID',NULL,'2021-10-06 00:16:48',7,7,16,7,7,NULL,'2021-10-05 13:16:48','2021-10-05 13:16:48',NULL),(50,'PAID',NULL,'2021-10-06 00:16:48',7,7,17,7,7,NULL,'2021-10-05 13:16:48','2021-10-05 13:16:48',NULL),(51,'PAID',NULL,'2021-10-06 00:16:48',7,7,18,7,7,NULL,'2021-10-05 13:16:48','2021-10-05 13:16:48',NULL),(52,'PAID',NULL,'2021-10-06 00:16:48',7,7,19,7,7,NULL,'2021-10-05 13:16:48','2021-10-05 13:16:48',NULL);

--
-- Table structure for table `user_providers`
--

CREATE TABLE `user_providers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `provider` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `provider_id` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `avatar` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_providers_user_id_foreign` (`user_id`),
  CONSTRAINT `user_providers_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `user_providers`
--


--
-- Table structure for table `userprofiles`
--

CREATE TABLE `userprofiles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `name` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `first_name` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `last_name` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `username` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mobile` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `gender` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_of_birth` date DEFAULT NULL,
  `address` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `avatar` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_ip` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
  `login_count` int(11) NOT NULL DEFAULT 0,
  `last_login` timestamp NULL DEFAULT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `status` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `created_by` int(10) unsigned DEFAULT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned 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=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `userprofiles`
--

INSERT INTO `userprofiles` VALUES (1,1,'Super Admin','Super','Admin','100001','super@admin.com','+1.914.563.1292','Other','1971-09-11',NULL,'img/default-avatar.jpg',NULL,0,NULL,NULL,1,1,1,NULL,'2021-10-08 01:53:28','2021-10-08 01:53:28',NULL),(2,2,'Admin Istrator','Admin','Istrator','100002','admin@admin.com','+16692375646','Female','2012-08-21',NULL,'img/default-avatar.jpg',NULL,0,NULL,NULL,1,1,1,NULL,'2021-10-08 01:53:28','2021-10-08 01:53:28',NULL),(3,3,'Manager','Manager','User User','100003','manager@manager.com','234.631.6651','Other','2004-02-04',NULL,'img/default-avatar.jpg',NULL,0,NULL,NULL,1,1,1,NULL,'2021-10-08 01:53:28','2021-10-08 01:53:28',NULL),(4,4,'Executive User','Executive','User','100004','executive@executive.com','1-520-615-5622','Female','2002-07-23',NULL,'img/default-avatar.jpg',NULL,0,NULL,NULL,1,1,1,NULL,'2021-10-08 01:53:28','2021-10-08 01:53:28',NULL),(5,5,'John Teller','John','Teller','teller','teller@user.com','(743) 938-4764','Male','2014-08-15',NULL,'img/default-avatar.jpg',NULL,0,NULL,NULL,1,1,1,NULL,'2021-10-08 01:53:28','2021-10-08 01:53:28',NULL),(6,6,'Mark Officer','Mark','officer','approval','approval@user.com','+1.531.523.3719','Female','1997-02-09',NULL,'img/default-avatar.jpg',NULL,0,NULL,NULL,1,1,1,NULL,'2021-10-08 01:53:28','2021-10-08 01:53:28',NULL),(7,7,'David Pay','David','Payment','payment','payment@user.com','+1 (681) 704-1637','Female','2001-01-05',NULL,'img/default-avatar.jpg',NULL,0,NULL,NULL,1,1,1,NULL,'2021-10-08 01:53:28','2021-10-08 01:53:28',NULL),(8,8,'Marsha Deliver','Marsha','Delviery','delivery','delivery@user.com','+1-316-908-7578','Male','1972-04-20',NULL,'img/default-avatar.jpg',NULL,0,NULL,NULL,1,1,1,NULL,'2021-10-08 01:53:28','2021-10-08 01:53:28',NULL);

--
-- Table structure for table `vehicle`
--

CREATE TABLE `vehicle` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `odometer` bigint(20) NOT NULL,
  `license_plate` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `vin` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `year` int(11) NOT NULL,
  `sub_category_id` bigint(20) unsigned DEFAULT NULL,
  `smart_tag` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  `vehicle_color_id` bigint(20) unsigned NOT NULL,
  `fuel_type_id` bigint(20) unsigned NOT NULL,
  `vehicle_type_id` bigint(20) unsigned NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `vehicle_type` (`vehicle_type_id`),
  KEY `fk_vehicle_fuel_type1` (`fuel_type_id`),
  KEY `fk_vehicle_model1` (`model_id`),
  KEY `fk_vehicle_sub_category1` (`sub_category_id`),
  KEY `fk_vehicle_vehicle_color1` (`vehicle_color_id`),
  CONSTRAINT `fk_vehicle_fuel_type1` FOREIGN KEY (`fuel_type_id`) REFERENCES `fuel_type` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_vehicle_model1` FOREIGN KEY (`model_id`) REFERENCES `model` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_vehicle_sub_category1` FOREIGN KEY (`sub_category_id`) REFERENCES `sub_category` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_vehicle_vehicle_color1` FOREIGN KEY (`vehicle_color_id`) REFERENCES `vehicle_color` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_vehicle_vehicle_type1` FOREIGN KEY (`vehicle_type_id`) REFERENCES `vehicle_type` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `vehicle_fuel_type_id_foreign` FOREIGN KEY (`fuel_type_id`) REFERENCES `fuel_type` (`id`),
  CONSTRAINT `vehicle_model_id_foreign` FOREIGN KEY (`model_id`) REFERENCES `model` (`id`),
  CONSTRAINT `vehicle_sub_category_id_foreign` FOREIGN KEY (`sub_category_id`) REFERENCES `sub_category` (`id`),
  CONSTRAINT `vehicle_vehicle_color_id_foreign` FOREIGN KEY (`vehicle_color_id`) REFERENCES `vehicle_color` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `vehicle`
--

INSERT INTO `vehicle` VALUES (1,90000,'POA-989','JK18822',2010,1,'xvg67',1,1,1,1,1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(2,9982,'KIA-434','I1k908',2019,1,'ui453',2,2,2,2,1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(3,90000,'ASZDP','6qabGlp7etk7aLZUoneA',2019,1,'j8sv7VzuCAjT9SjbvXZk',1,1,1,1,1,1,NULL,'2021-09-28 04:01:35','2021-09-28 04:01:35',NULL),(4,90000,'N43S4','2DecWlWMOkSqFhS7Lplw',2019,1,'mDs1Nw9XCux2HUTD6LYY',1,1,1,1,1,1,NULL,'2021-09-28 04:01:37','2021-09-28 04:01:37',NULL),(5,90000,'JSG2T','wVfVhiIPXcTWhArT9VXj',2010,1,'yuzrRHxyHIt3dDibT371',1,1,1,1,1,1,NULL,'2021-09-28 04:01:38','2021-09-28 04:01:38',NULL),(6,90000,'6VV6W','1fkhf8NIqwsgBLNY2Kqr',2012,1,'zpBSyFjuohP5qJf4524Y',1,1,1,1,1,1,NULL,'2021-09-28 04:01:38','2021-09-28 04:01:38',NULL),(7,90000,'JA51F','3dJXCDkzhP7IYwD4evWj',2012,1,'lWu1DW4UAJEBmCcOX97w',1,1,1,1,1,1,NULL,'2021-09-28 04:01:39','2021-09-28 04:01:39',NULL),(8,90000,'U2B6V','N33F03PegdvadhlpqET1',2011,1,'fE9IUNRQV6dckchK00DJ',1,1,1,1,1,1,NULL,'2021-09-28 04:01:39','2021-09-28 04:01:39',NULL),(9,90000,'OZ3PF','lryse4IDEF1GI8tTrlAf',2010,1,'SGxklOBDYimAJhIhUdkP',1,1,1,1,1,1,NULL,'2021-09-28 04:01:40','2021-09-28 04:01:40',NULL),(10,90000,'FKQIV','6nRK3H2WDxOLan3ooUQD',2012,1,'UvftUJbxv1Osi8nTdnlR',1,1,1,1,1,1,NULL,'2021-09-28 04:01:40','2021-09-28 04:01:40',NULL),(11,90000,'EJTQP','XPBv1Cdm7Gz4SAG3Xflq',2019,1,'j8fo7Bhk8l98H37h3t1W',1,1,1,1,7,7,NULL,'2021-09-28 14:23:27','2021-09-28 14:23:27',NULL),(12,90000,'MRIIL','ihEbh6nDngKUvHuTRaPo',2010,1,'Samn34uiFa3wDu5kDijg',1,1,1,1,7,7,NULL,'2021-09-28 14:23:28','2021-09-28 14:23:28',NULL),(13,90000,'2I7F2','Y5RvTNpQYYQwajwZKgPt',2012,1,'GklvuiKIDviJsF7ytUVQ',1,1,1,1,7,7,NULL,'2021-09-28 14:23:28','2021-09-28 14:23:28',NULL),(14,90000,'K3SN1','3nARcsXP2YPTx1Zw11kH',2011,1,'FJEzXFs8Xx9q2mtsjmSQ',1,1,1,1,7,7,NULL,'2021-09-28 14:23:29','2021-09-28 14:23:29',NULL),(15,90000,'KZVLN','7QSRPZ78AA7ufYduqPUD',2012,1,'YHL2WYKq171yjoAVwoge',1,1,1,1,7,7,NULL,'2021-09-28 14:23:29','2021-09-28 14:23:29',NULL),(16,90000,'NTEQ1','ItIKZGSqj0mtgo0UUODI',2021,1,'LXLFkE4cnOKIfUkcE3Y4',1,1,1,1,7,7,NULL,'2021-09-28 14:23:29','2021-09-28 14:23:29',NULL),(17,90000,'99O8I','qBrfndeyaa6qXt1VGEPj',2010,1,'9OXraUQo3W0s7h0fJhqO',1,1,1,1,7,7,NULL,'2021-09-28 14:23:30','2021-09-28 14:23:30',NULL),(18,90000,'YBDPV','AVbsvbxAr65I5Qh96BzM',2012,1,'ZnvXvN3tdXrUb7UFtSCh',1,1,1,1,7,7,NULL,'2021-09-28 14:23:30','2021-09-28 14:23:30',NULL);

--
-- Table structure for table `vehicle_color`
--

CREATE TABLE `vehicle_color` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `vehicle_color_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `vehicle_color`
--

INSERT INTO `vehicle_color` VALUES (1,'RED',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(2,'GREEN',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL);

--
-- Table structure for table `vehicle_tax`
--

CREATE TABLE `vehicle_tax` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `status` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `tax_number` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `sticker_number` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `vehicle_id` bigint(20) unsigned NOT NULL,
  `party_id` bigint(20) unsigned NOT NULL,
  `party_vehicle_id` bigint(20) unsigned NOT NULL,
  `term_id` bigint(20) unsigned NOT NULL,
  `transaction_id` bigint(20) unsigned NOT NULL,
  `deliver_district_id` bigint(20) unsigned DEFAULT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `tax_sticker_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `vehicle_tax_vehicle_id_foreign` (`vehicle_id`),
  KEY `vehicle_tax_party_id_foreign` (`party_id`),
  KEY `vehicle_tax_party_vehicle_id_foreign` (`party_vehicle_id`),
  KEY `vehicle_tax_term_id_foreign` (`term_id`),
  KEY `vehicle_tax_transaction_id_foreign` (`transaction_id`),
  KEY `vehicle_tax_deliver_district_id_foreign` (`deliver_district_id`),
  KEY `vehicle_tax_tax_sticker_id_foreign` (`tax_sticker_id`),
  CONSTRAINT `vehicle_tax_deliver_district_id_foreign` FOREIGN KEY (`deliver_district_id`) REFERENCES `district` (`id`),
  CONSTRAINT `vehicle_tax_party_id_foreign` FOREIGN KEY (`party_id`) REFERENCES `party` (`id`),
  CONSTRAINT `vehicle_tax_party_vehicle_id_foreign` FOREIGN KEY (`party_vehicle_id`) REFERENCES `party_vehicle` (`id`),
  CONSTRAINT `vehicle_tax_tax_sticker_id_foreign` FOREIGN KEY (`tax_sticker_id`) REFERENCES `tax_sticker` (`id`),
  CONSTRAINT `vehicle_tax_term_id_foreign` FOREIGN KEY (`term_id`) REFERENCES `term` (`id`),
  CONSTRAINT `vehicle_tax_transaction_id_foreign` FOREIGN KEY (`transaction_id`) REFERENCES `transaction` (`id`),
  CONSTRAINT `vehicle_tax_vehicle_id_foreign` FOREIGN KEY (`vehicle_id`) REFERENCES `vehicle` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `vehicle_tax`
--

INSERT INTO `vehicle_tax` VALUES (1,'PAID','Y1A-2-720',NULL,3,41,2,84,3,1,8,8,NULL,'2021-10-03 08:11:30','2021-10-04 10:58:22',NULL,1),(2,'PAID','H9X-2-932',NULL,3,41,2,85,4,1,8,7,NULL,'2021-10-03 08:11:30','2021-10-04 02:53:38',NULL,NULL),(3,'PAID','BSE-2-789',NULL,3,41,2,86,5,1,8,7,NULL,'2021-10-03 08:11:30','2021-10-04 02:53:38',NULL,NULL),(4,'PAID','SYP-2-904',NULL,3,41,2,87,6,1,8,7,NULL,'2021-10-03 08:11:30','2021-10-04 02:53:38',NULL,NULL),(5,'PAID','EU7-2-859',NULL,3,41,2,88,7,1,8,7,NULL,'2021-10-03 08:11:30','2021-10-04 02:53:39',NULL,NULL),(6,'PAID','9UC-15-607',NULL,5,38,10,85,16,NULL,1,7,NULL,'2021-10-05 12:13:41','2021-10-05 13:16:48',NULL,NULL),(7,'OPEN','UFW-15-293',NULL,5,38,10,86,17,16,1,7,NULL,'2021-10-05 12:13:42','2021-10-05 13:27:15',NULL,NULL),(8,'PAID','SWY-15-908',NULL,5,38,10,87,18,NULL,1,7,NULL,'2021-10-05 12:13:44','2021-10-05 13:16:48',NULL,NULL),(9,'PAID','9XR-15-959',NULL,5,38,10,88,19,NULL,1,7,NULL,'2021-10-05 12:13:47','2021-10-05 13:16:48',NULL,NULL);

--
-- Table structure for table `vehicle_title`
--

CREATE TABLE `vehicle_title` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title_number` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `vehicle_id` bigint(20) unsigned NOT NULL,
  `party_id` bigint(20) unsigned NOT NULL,
  `issued_date` datetime NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `vehicle_title_title_number_unique` (`title_number`),
  KEY `vehicle_title_vehicle_id_foreign` (`vehicle_id`),
  KEY `vehicle_title_party_id_foreign` (`party_id`),
  CONSTRAINT `vehicle_title_party_id_foreign` FOREIGN KEY (`party_id`) REFERENCES `party` (`id`),
  CONSTRAINT `vehicle_title_vehicle_id_foreign` FOREIGN KEY (`vehicle_id`) REFERENCES `vehicle` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `vehicle_title`
--

INSERT INTO `vehicle_title` VALUES (1,'8OA-2-729',3,41,'2021-10-03 18:54:55',8,8,NULL,'2021-10-03 07:54:55','2021-10-03 07:54:55',NULL),(2,'88S-15-227',5,38,'2021-10-05 23:13:17',8,8,NULL,'2021-10-05 12:13:17','2021-10-05 12:13:17',NULL);

--
-- Table structure for table `vehicle_type`
--

CREATE TABLE `vehicle_type` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `vehicle_type_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `vehicle_type`
--

INSERT INTO `vehicle_type` VALUES (1,'SEDAN',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(2,'TRUCK',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL);

--
-- Table structure for table `workflow`
--

CREATE TABLE `workflow` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `version` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned 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=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `workflow`
--

INSERT INTO `workflow` VALUES (1,'Registration Workflow','1.0',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(2,'Tax Workflow','1.0',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(3,'Ownership Transfer Workflow','1.0',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL);

--
-- Table structure for table `workflow_checklist`
--

CREATE TABLE `workflow_checklist` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `workflow_id` bigint(20) unsigned NOT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `workflow_checklist_workflow_id_foreign` (`workflow_id`),
  KEY `workflow_checklist_role_id_foreign` (`role_id`),
  CONSTRAINT `workflow_checklist_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`),
  CONSTRAINT `workflow_checklist_workflow_id_foreign` FOREIGN KEY (`workflow_id`) REFERENCES `service_workflow` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `workflow_checklist`
--

INSERT INTO `workflow_checklist` VALUES (1,1,5,'Customer ID','Verify Customer ID e.g., Passport, Driver License',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(2,1,6,'Verify Vehicle Classification','Verify vehicle classification is right',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(3,1,8,'Verify Delviery documents','Verify Delviery documents are right',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(4,2,8,'Verify Delviery documents','Verify Delviery documents are right',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL);

--
-- Table structure for table `workflow_definition`
--

CREATE TABLE `workflow_definition` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `workflow_id` bigint(20) unsigned NOT NULL,
  `step_number` int(11) NOT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  `final_step` varchar(191) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `workflow_definition_workflow_id_foreign` (`workflow_id`),
  KEY `workflow_definition_role_id_foreign` (`role_id`),
  CONSTRAINT `workflow_definition_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`),
  CONSTRAINT `workflow_definition_workflow_id_foreign` FOREIGN KEY (`workflow_id`) REFERENCES `workflow` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `workflow_definition`
--

INSERT INTO `workflow_definition` VALUES (1,1,1,5,'N',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(2,1,2,6,'N',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(3,1,3,7,'N',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(4,1,4,8,'N',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(5,1,5,9,'Y',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(6,2,1,5,'N',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(7,2,2,7,'N',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(8,2,3,8,'N',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL),(9,2,4,9,'Y',1,1,NULL,'2021-08-31 14:00:00','2021-08-31 14:00:00',NULL);


