-- https://www.phpmyadmin.net/
--




-- --------------------------------------------------------

--
-- Table structure for table `cancelled_parking_requests`
--

CREATE TABLE `cancelled_parking_requests` (
  `cancelled_parking_request_id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `request_id` int(11) NOT NULL,
  `space_provider_id` int(11) NOT NULL,
  `reason` text,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cancelled_parking_requests`
--

INSERT INTO `cancelled_parking_requests` (`cancelled_parking_request_id`, `customer_id`, `request_id`, `space_provider_id`, `reason`, `created_at`, `updated_at`) VALUES
(1, 2, 7, 6, NULL, '2019-04-14 10:30:18', '2019-04-14 10:30:18'),
(2, 2, 7, 6, NULL, '2019-04-14 10:32:08', '2019-04-14 10:32:08'),
(3, 2, 7, 6, NULL, '2019-04-14 10:35:35', '2019-04-14 10:35:35'),
(4, 2, 18, 6, NULL, '2019-04-14 11:44:57', '2019-04-14 11:44:57'),
(5, 2, 20, 6, NULL, '2019-04-14 11:56:21', '2019-04-14 11:56:21'),
(6, 2, 20, 6, NULL, '2019-04-14 11:56:52', '2019-04-14 11:56:52'),
(7, 2, 21, 6, NULL, '2019-04-18 10:23:18', '2019-04-18 10:23:18'),
(8, 2, 23, 6, NULL, '2019-04-24 11:53:40', '2019-04-24 11:53:40'),
(9, 2, 24, 6, NULL, '2019-04-24 11:56:45', '2019-04-24 11:56:45'),
(10, 2, 35, 6, NULL, '2019-04-28 12:07:00', '2019-04-28 12:07:00'),
(11, 2, 38, 6, NULL, '2019-04-28 12:37:56', '2019-04-28 12:37:56'),
(12, 5, 1, 7, NULL, '2019-06-24 12:16:02', '2019-06-24 12:16:02'),
(13, 5, 1, 7, NULL, '2019-08-20 04:47:57', '2019-08-20 04:47:57'),
(14, 5, 1, 7, NULL, '2019-09-13 03:05:51', '2019-09-13 03:05:51'),
(15, 5, 3, 7, NULL, '2019-10-18 06:55:34', '2019-10-18 06:55:34'),
(16, 5, 1, 11, NULL, '2020-05-12 08:47:05', '2020-05-12 08:47:05');

-- --------------------------------------------------------

--
-- Table structure for table `customer_preferred_location`
--

CREATE TABLE `customer_preferred_location` (
  `customer_preferred_location_id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `preferred_name` varchar(50) NOT NULL,
  `latitude` varchar(15) NOT NULL,
  `longitude` varchar(15) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `status` varchar(25) NOT NULL DEFAULT 'ACTIVE'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `customer_vehicle_details`
--

CREATE TABLE `customer_vehicle_details` (
  `customer_vehicle_id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `car_manufacturer` varchar(50) NOT NULL,
  `car_type` varchar(50) NOT NULL,
  `car_image` varchar(50) NOT NULL,
  `car_number` varchar(30) NOT NULL,
  `status` varchar(15) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `customer_vehicle_details`
--

INSERT INTO `customer_vehicle_details` (`customer_vehicle_id`, `customer_id`, `car_manufacturer`, `car_type`, `car_image`, `car_number`, `status`, `created_at`, `updated_at`) VALUES
(1, 2, 'HONDA', 'Four Wheeler', '', 'KS12345', 'ACTIVE', '2019-04-11 12:20:03', '2019-04-11 12:20:03'),
(2, 1, 'TATA', 'Four Wheeler', '', 'KA34FY689', 'ACTIVE', '2019-04-24 06:36:36', '2019-04-24 06:36:36'),
(3, 3, 'TATA', 'Four Wheeler', '', 'TN4566', 'ACTIVE', '2019-04-26 09:30:00', '2019-04-26 09:30:00'),
(4, 4, 'HONDA ', 'Four Wheeler', '', 'KA45VB6788', 'ACTIVE', '2019-06-23 17:47:34', '2019-06-23 17:47:34'),
(5, 5, 'TATA', 'Four Wheeler', '', 'Tn2111', 'ACTIVE', '2019-08-19 23:17:32', '2019-08-19 23:17:32'),
(6, 4, 'HONDA ', 'Two Wheeler', '', 'KA45VB6787', 'ACTIVE', '2019-08-20 08:27:56', '2019-08-20 08:27:56'),
(7, 5, 'FATA', 'Four Wheeler', '', 'Tn37t0802', 'ACTIVE', '2019-10-18 01:25:20', '2019-10-18 01:25:20');

-- --------------------------------------------------------

--
-- Table structure for table `documents`
--

CREATE TABLE `documents` (
  `document_id` int(11) NOT NULL,
  `space_provider_id` int(11) NOT NULL,
  `parking_lot_id` int(11) NOT NULL,
  `document_type_id` int(11) NOT NULL,
  `document_url` varchar(100) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

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

CREATE TABLE `document_type` (
  `document_type_id` int(11) NOT NULL,
  `document_type` varchar(50) NOT NULL,
  `status` varchar(15) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `employee_parking_lot`
--

CREATE TABLE `employee_parking_lot` (
  `emp_par_id` int(11) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `parking_id` int(11) NOT NULL,
  `status` varchar(15) NOT NULL DEFAULT 'ACTIVE',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `employee_parking_lot`
--

INSERT INTO `employee_parking_lot` (`emp_par_id`, `employee_id`, `parking_id`, `status`, `created_at`, `updated_at`) VALUES
(2, 2, 6, 'ACTIVE', '2019-04-11 06:08:40', '2019-04-11 06:08:40'),
(8, 5, 6, 'ACTIVE', '2019-04-26 09:32:53', '2019-04-26 09:32:53'),
(9, 6, 6, 'ACTIVE', '2019-04-26 09:33:15', '2019-04-26 09:33:15'),
(11, 1, 6, 'ACTIVE', '2019-05-03 04:43:52', '2019-05-03 04:43:52'),
(12, 5, 6, 'ACTIVE', '2019-05-03 04:44:39', '2019-05-03 04:44:39'),
(13, 6, 6, 'ACTIVE', '2019-05-03 04:53:04', '2019-05-03 04:53:04'),
(14, 7, 2, 'ACTIVE', '2019-05-03 05:39:48', '2019-05-03 05:39:48'),
(15, 8, 6, 'ACTIVE', '2019-05-03 06:10:29', '2019-05-03 06:10:29'),
(16, 10, 6, 'ACTIVE', '2019-05-03 06:44:53', '2019-05-03 06:44:53'),
(17, 11, 6, 'ACTIVE', '2019-05-03 06:52:22', '2019-05-03 06:52:22'),
(19, 4, 6, 'ACTIVE', '2019-05-03 17:33:24', '2019-05-03 17:33:24'),
(21, 3, 5, 'ACTIVE', '2019-05-11 18:10:14', '2019-05-11 18:10:14'),
(22, 3, 6, 'ACTIVE', '2019-05-11 18:10:14', '2019-05-11 18:10:14'),
(23, 12, 5, 'ACTIVE', '2019-05-11 19:14:09', '2019-05-11 19:14:09'),
(24, 12, 6, 'ACTIVE', '2019-05-11 19:14:09', '2019-05-11 19:14:09'),
(29, 14, 5, 'ACTIVE', '2019-05-15 08:28:28', '2019-05-15 08:28:28'),
(30, 14, 6, 'ACTIVE', '2019-05-15 08:28:28', '2019-05-15 08:28:28'),
(31, 18, 1, 'ACTIVE', '2019-05-15 09:15:07', '2019-05-15 09:15:07'),
(32, 18, 6, 'ACTIVE', '2019-05-15 09:15:07', '2019-05-15 09:15:07'),
(33, 23, 5, 'ACTIVE', '2019-05-19 19:10:15', '2019-05-19 19:10:15'),
(34, 24, 6, 'ACTIVE', '2019-05-20 04:49:35', '2019-05-20 04:49:35'),
(35, 13, 7, 'ACTIVE', '2019-06-23 19:16:20', '2019-06-23 19:16:20'),
(36, 25, 7, 'ACTIVE', '2020-02-02 15:58:37', '2020-02-02 15:58:37'),
(37, 26, 7, 'ACTIVE', '2020-02-18 06:19:11', '2020-02-18 06:19:11'),
(45, 28, 7, 'ACTIVE', '2020-05-13 09:17:28', '2020-05-13 09:17:28'),
(46, 28, 8, 'ACTIVE', '2020-05-13 09:17:28', '2020-05-13 09:17:28'),
(47, 28, 9, 'ACTIVE', '2020-05-13 09:17:28', '2020-05-13 09:17:28'),
(48, 28, 10, 'ACTIVE', '2020-05-13 09:17:28', '2020-05-13 09:17:28'),
(49, 27, 24, 'ACTIVE', '2020-05-14 17:22:58', '2020-05-14 17:22:58'),
(50, 28, 24, 'ACTIVE', '2020-05-16 15:19:32', '2020-05-16 15:19:32'),
(66, 29, 25, 'ACTIVE', '2020-07-14 18:51:59', '2020-07-14 18:51:59'),
(67, 29, 26, 'ACTIVE', '2020-07-14 18:51:59', '2020-07-14 18:51:59'),
(74, 31, 24, 'ACTIVE', '2021-03-03 16:57:38', '2021-03-03 16:57:38'),
(75, 31, 25, 'ACTIVE', '2021-03-03 16:57:38', '2021-03-03 16:57:38'),
(76, 31, 27, 'ACTIVE', '2021-03-03 16:57:38', '2021-03-03 16:57:38'),
(77, 31, 28, 'ACTIVE', '2021-03-03 16:57:38', '2021-03-03 16:57:38'),
(84, 30, 24, 'ACTIVE', '2021-03-04 12:51:49', '2021-03-04 12:51:49'),
(85, 30, 25, 'ACTIVE', '2021-03-04 12:51:49', '2021-03-04 12:51:49'),
(86, 30, 29, 'ACTIVE', '2021-03-04 12:51:49', '2021-03-04 12:51:49'),
(87, 30, 30, 'ACTIVE', '2021-03-04 12:51:49', '2021-03-04 12:51:49'),
(88, 30, 31, 'ACTIVE', '2021-03-04 12:51:49', '2021-03-04 12:51:49'),
(89, 30, 32, 'ACTIVE', '2021-03-04 12:51:49', '2021-03-04 12:51:49');

-- --------------------------------------------------------

--
-- Table structure for table `gcm_settings`
--

CREATE TABLE `gcm_settings` (
  `gcm_id` int(11) NOT NULL,
  `gcm_key` varchar(50) NOT NULL,
  `provider_link` varchar(100) NOT NULL,
  `status` varchar(15) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `images`
--

CREATE TABLE `images` (
  `image_id` int(11) NOT NULL,
  `space_provider_id` int(11) NOT NULL,
  `image_url` text NOT NULL,
  `image_name` varchar(50) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `status` varchar(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `ledger`
--

CREATE TABLE `ledger` (
  `id` int(10) UNSIGNED NOT NULL,
  `owner_id` int(10) UNSIGNED NOT NULL,
  `referral_code` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,
  `total_referrals` int(11) NOT NULL,
  `amount_earned` float(8,2) NOT NULL,
  `amount_spent` float(8,2) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `lot_specification`
--

CREATE TABLE `lot_specification` (
  `lot_specification_id` int(11) NOT NULL,
  `description_type` varchar(100) NOT NULL,
  `maximum_ratings` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `status` varchar(15) NOT NULL DEFAULT 'ACTIVE'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `lot_specification_with_provider`
--

CREATE TABLE `lot_specification_with_provider` (
  `id` int(11) NOT NULL,
  `lot_specification_id` int(11) NOT NULL,
  `provider_id` int(11) NOT NULL,
  `ratings` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `status` varchar(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `lot_types`
--

CREATE TABLE `lot_types` (
  `lot_id` int(11) NOT NULL,
  `lot_type_name` varchar(50) NOT NULL,
  `status` varchar(15) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `lot_types`
--

INSERT INTO `lot_types` (`lot_id`, `lot_type_name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Two Wheeler', 'ACTIVE', '2019-04-08 01:35:56', '2019-04-08 01:35:56'),
(2, 'Four Wheeler', 'ACTIVE', '2019-05-15 07:35:51', '2021-04-21 14:59:05');

-- --------------------------------------------------------

--
-- Table structure for table `parking_requests`
--

CREATE TABLE `parking_requests` (
  `request_id` int(11) NOT NULL,
  `referance_id` varchar(50) NOT NULL,
  `order_id` varchar(100) DEFAULT NULL COMMENT 'RazorPay Payment Order ID',
  `customer_id` int(11) NOT NULL,
  `provider_id` int(11) NOT NULL,
  `vehicle_number` varchar(30) NOT NULL,
  `start_time` datetime NOT NULL,
  `end_time` datetime DEFAULT NULL,
  `base_fare` float NOT NULL,
  `extra_fare` float NOT NULL,
  `is_started` int(11) NOT NULL,
  `is_completed` int(11) NOT NULL,
  `is_payment_done` int(11) NOT NULL,
  `accept_status` int(11) NOT NULL,
  `latitude` varchar(15) NOT NULL,
  `longitude` varchar(15) NOT NULL,
  `request_date` date NOT NULL,
  `status` varchar(15) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `parking_requests_offline`
--

CREATE TABLE `parking_requests_offline` (
  `request_id` int(11) NOT NULL,
  `referance_id` varchar(50) NOT NULL,
  `app_request_id` varchar(50) NOT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `provider_id` int(11) NOT NULL,
  `vehicle_number` varchar(30) NOT NULL,
  `start_time` datetime NOT NULL,
  `end_time` datetime DEFAULT NULL,
  `is_started` int(11) NOT NULL,
  `is_completed` int(11) NOT NULL,
  `is_payment_done` int(11) NOT NULL,
  `request_date` date NOT NULL,
  `paid_by` varchar(64) NOT NULL,
  `amount_paid` varchar(24) NOT NULL,
  `duration` varchar(24) NOT NULL,
  `total_amount` varchar(24) NOT NULL,
  `status` varchar(15) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `parking_requests_offline`
--

INSERT INTO `parking_requests_offline` (`request_id`, `referance_id`, `app_request_id`, `customer_id`, `provider_id`, `vehicle_number`, `start_time`, `end_time`, `is_started`, `is_completed`, `is_payment_done`, `request_date`, `paid_by`, `amount_paid`, `duration`, `total_amount`, `status`, `created_at`, `updated_at`) VALUES
(44, 'ParkNXT2021050419582326', '1620138502075', 7, 24, '3082', '2021-05-04 19:58:22', '0000-00-00 00:00:00', 1, 0, 0, '2021-05-04', 'cash', '0', '0', '0', 'ACTIVE', '2021-05-04 19:58:23', '2021-05-04 19:58:23'),
(45, 'ParkNXT2021050419593125', '1620138569595', 7, 24, '1431', '2021-05-04 19:59:29', '0000-00-00 00:00:00', 1, 0, 0, '2021-05-04', 'cash', '0', '0', '0', 'ACTIVE', '2021-05-04 19:59:31', '2021-05-04 19:59:31'),
(173, 'ParkNXT2021050714222317', '1620377534650', 7, 24, 'CT3168', '2021-05-07 14:22:14', '0000-00-00 00:00:00', 1, 0, 0, '2021-05-07', 'cash', '0', '0', '0', 'ACTIVE', '2021-05-07 14:22:23', '2021-05-07 14:22:23'),
(174, 'ParkNXT2021050714534227', '1620379419157', 5, 25, 'DC3508', '2021-05-07 14:53:39', '0000-00-00 00:00:00', 1, 0, 0, '2021-05-07', 'cash', '0', '0', '0', 'ACTIVE', '2021-05-07 14:53:42', '2021-05-07 14:53:42'),
(175, 'ParkNXT2021050715105610', '1620380453443', 7, 24, 'NEW CAR', '2021-05-07 15:10:53', '0000-00-00 00:00:00', 1, 0, 0, '2021-05-07', 'cash', '0', '0', '0', 'ACTIVE', '2021-05-07 15:10:56', '2021-05-07 15:10:56'),
(176, 'ParkNXT2021050715302724', '1620381625320', 7, 24, 'BJ4545', '2021-05-07 15:30:25', '0000-00-00 00:00:00', 1, 0, 0, '2021-05-07', 'cash', '0', '0', '0', 'ACTIVE', '2021-05-07 15:30:27', '2021-05-07 15:30:27'),
(177, 'ParkNXT2021050715430924', '1620382318503', 7, 24, 'CK6606', '2021-05-07 15:41:58', '0000-00-00 00:00:00', 1, 0, 0, '2021-05-07', 'cash', '0', '0', '0', 'ACTIVE', '2021-05-07 15:43:09', '2021-05-07 15:43:09');

-- --------------------------------------------------------

--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `payment_id` int(11) NOT NULL,
  `request_id` int(11) NOT NULL,
  `referance_id` varchar(50) NOT NULL COMMENT 'Table = parking_requests, Column = referance_id',
  `provider_id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `start_time` datetime NOT NULL,
  `end_time` datetime DEFAULT NULL,
  `payment_mode` int(11) NOT NULL,
  `gift_code` int(11) NOT NULL,
  `coupon_code` int(11) NOT NULL,
  `transaction_number` int(11) NOT NULL,
  `order_id` varchar(25) NOT NULL,
  `amount` float UNSIGNED NOT NULL,
  `company_profit` float NOT NULL,
  `provider_profit` float NOT NULL,
  `payment_status` varchar(20) NOT NULL COMMENT 'C = Complate',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `payments_offline`
--

CREATE TABLE `payments_offline` (
  `payment_id` int(11) NOT NULL,
  `request_id` int(11) NOT NULL,
  `provider_id` int(11) NOT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `vehicle_number` varchar(50) DEFAULT NULL,
  `start_time` datetime NOT NULL,
  `end_time` datetime DEFAULT NULL,
  `payment_mode` varchar(50) DEFAULT NULL,
  `gift_code` int(11) DEFAULT NULL,
  `coupon_code` int(11) DEFAULT NULL,
  `transaction_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order_id` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_profit` float DEFAULT NULL,
  `provider_profit` float DEFAULT NULL,
  `payment_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `payments_offline`
--

INSERT INTO `payments_offline` (`payment_id`, `request_id`, `provider_id`, `customer_id`, `vehicle_number`, `start_time`, `end_time`, `payment_mode`, `gift_code`, `coupon_code`, `transaction_number`, `order_id`, `amount`, `company_profit`, `provider_profit`, `payment_status`, `created_at`, `updated_at`) VALUES
(1, 1, 32, 5, 'TN66D7205', '2021-05-03 11:32:31', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '202046213401', '202046213401', '0', 0, 0, 'C', '2021-05-03 11:32:32', '2021-05-03 11:32:32'),
(2, 2, 32, 5, 'TN38BR3533', '2021-05-03 11:50:41', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201343510786', '201343510786', '0', 0, 0, 'C', '2021-05-03 11:50:43', '2021-05-03 11:50:43'),
(3, 3, 29, 5, 'TN66AC3539', '2021-05-04 12:45:25', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '202032268281', '202032268281', '500', 50, 450, 'C', '2021-05-04 12:45:29', '2021-05-04 12:45:29'),
(4, 4, 29, 5, 'TN99E5234', '2021-05-04 12:46:43', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201487902286', '201487902286', '500', 50, 450, 'C', '2021-05-04 12:46:45', '2021-05-04 12:46:45'),
(5, 5, 29, 5, 'TN38S6271', '2021-05-04 12:49:02', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201673825652', '201673825652', '500', 50, 450, 'C', '2021-05-04 12:49:04', '2021-05-04 12:49:04'),
(6, 6, 29, 5, 'TN66Z0949', '2021-05-04 12:50:11', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201345466549', '201345466549', '500', 50, 450, 'C', '2021-05-04 12:50:21', '2021-05-04 12:50:21'),
(7, 7, 29, 5, 'TN66H1759', '2021-05-04 12:51:09', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201405000559', '201405000559', '500', 50, 450, 'C', '2021-05-04 12:51:11', '2021-05-04 12:51:11'),
(8, 8, 29, 5, 'TN66BT2650', '2021-05-04 12:57:38', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201877859693', '201877859693', '500', 50, 450, 'C', '2021-05-04 12:57:40', '2021-05-04 12:57:40'),
(9, 9, 29, 5, 'TN37DH5131', '2021-05-04 12:58:37', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201626154410', '201626154410', '500', 50, 450, 'C', '2021-05-04 12:58:39', '2021-05-04 12:58:39'),
(10, 10, 29, 5, 'TN66M2254', '2021-05-04 12:59:21', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201777920724', '201777920724', '500', 50, 450, 'C', '2021-05-04 12:59:23', '2021-05-04 12:59:23'),
(11, 11, 29, 5, 'TN37CP5940', '2021-05-04 13:00:33', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201396770949', '201396770949', '500', 50, 450, 'C', '2021-05-04 13:00:35', '2021-05-04 13:00:35'),
(12, 12, 29, 5, 'TN37BH6520', '2021-05-04 13:01:13', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201608126331', '201608126331', '500', 50, 450, 'C', '2021-05-04 13:01:14', '2021-05-04 13:01:14'),
(13, 13, 29, 5, 'TN38BM6302', '2021-05-04 13:03:37', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201340842556', '201340842556', '500', 50, 450, 'C', '2021-05-04 13:03:39', '2021-05-04 13:03:39'),
(14, 14, 29, 5, 'TN37AM1396', '2021-05-04 13:04:17', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201312905883', '201312905883', '500', 50, 450, 'C', '2021-05-04 13:04:19', '2021-05-04 13:04:19'),
(15, 15, 29, 5, 'TN66V6370', '2021-05-04 13:05:05', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201325621886', '201325621886', '500', 50, 450, 'C', '2021-05-04 13:05:07', '2021-05-04 13:05:07'),
(16, 16, 29, 5, 'TN66E8436', '2021-05-04 13:07:35', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '202101435688', '202101435688', '500', 50, 450, 'C', '2021-05-04 13:07:37', '2021-05-04 13:07:37'),
(17, 17, 29, 5, 'TN37DC5872', '2021-05-04 13:08:13', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201397679237', '201397679237', '500', 50, 450, 'C', '2021-05-04 13:08:14', '2021-05-04 13:08:14'),
(18, 18, 29, 5, 'TN38BB3223', '2021-05-04 13:08:46', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201567858991', '201567858991', '500', 50, 450, 'C', '2021-05-04 13:08:48', '2021-05-04 13:08:48'),
(19, 19, 29, 5, 'TN66X5135', '2021-05-04 13:13:27', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201381660377', '201381660377', '500', 50, 450, 'C', '2021-05-04 13:13:31', '2021-05-04 13:13:31'),
(20, 20, 29, 5, 'TN66X2896', '2021-05-04 13:14:24', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '202031800440', '202031800440', '500', 50, 450, 'C', '2021-05-04 13:14:26', '2021-05-04 13:14:26'),
(21, 21, 29, 5, 'TN41AZ3463', '2021-05-04 13:16:37', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201312575599', '201312575599', '500', 50, 450, 'C', '2021-05-04 13:16:39', '2021-05-04 13:16:39'),
(22, 22, 29, 5, 'TN37CM1317', '2021-05-04 13:17:34', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '202026295679', '202026295679', '500', 50, 450, 'C', '2021-05-04 13:17:35', '2021-05-04 13:17:35'),
(23, 23, 29, 5, 'TN37BS1509', '2021-05-04 13:18:14', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201714588460', '201714588460', '500', 50, 450, 'C', '2021-05-04 13:18:15', '2021-05-04 13:18:15'),
(24, 24, 29, 5, 'TN99T4578', '2021-05-04 13:50:57', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201276299212', '201276299212', '500', 50, 450, 'C', '2021-05-04 13:51:02', '2021-05-04 13:51:02'),
(25, 25, 29, 5, 'TN37AL9988', '2021-05-04 13:52:48', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201637384172', '201637384172', '500', 50, 450, 'C', '2021-05-04 13:52:50', '2021-05-04 13:52:50'),
(26, 26, 29, 5, 'TN37DE3412', '2021-05-04 14:03:07', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201591501990', '201591501990', '500', 50, 450, 'C', '2021-05-04 14:03:29', '2021-05-04 14:03:29'),
(27, 27, 29, 5, 'TN66U8375', '2021-05-04 14:04:56', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201538931497', '201538931497', '500', 50, 450, 'C', '2021-05-04 14:04:58', '2021-05-04 14:04:58'),
(28, 28, 29, 5, 'TN66AD4675', '2021-05-04 14:05:26', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201211480623', '201211480623', '500', 50, 450, 'C', '2021-05-04 14:05:28', '2021-05-04 14:05:28'),
(29, 29, 29, 5, 'TN66T5037', '2021-05-04 14:06:11', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201467231949', '201467231949', '500', 50, 450, 'C', '2021-05-04 14:06:13', '2021-05-04 14:06:13'),
(30, 30, 29, 5, 'TN38CH9992', '2021-05-04 14:12:56', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201819591884', '201819591884', '500', 50, 450, 'C', '2021-05-04 14:12:58', '2021-05-04 14:12:58'),
(31, 31, 29, 5, 'TN66Y3442', '2021-05-04 15:27:43', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201515206007', '201515206007', '500', 50, 450, 'C', '2021-05-04 15:27:46', '2021-05-04 15:27:46'),
(32, 32, 29, 5, 'TN86D5007', '2021-05-04 15:28:11', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201361980886', '201361980886', '500', 50, 450, 'C', '2021-05-04 15:28:14', '2021-05-04 15:28:14'),
(33, 33, 29, 5, 'TN66V3761', '2021-05-04 15:28:48', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201667385223', '201667385223', '500', 50, 450, 'C', '2021-05-04 15:28:50', '2021-05-04 15:28:50'),
(34, 34, 29, 5, 'TN38CL5990', '2021-05-04 15:29:23', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '202063810843', '202063810843', '500', 50, 450, 'C', '2021-05-04 15:29:25', '2021-05-04 15:29:25'),
(35, 35, 29, 5, 'TN99T8397', '2021-05-04 15:29:51', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201811692627', '201811692627', '500', 50, 450, 'C', '2021-05-04 15:29:53', '2021-05-04 15:29:53'),
(36, 36, 29, 5, 'TN37CZ7809', '2021-05-04 15:30:27', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201370017843', '201370017843', '500', 50, 450, 'C', '2021-05-04 15:30:28', '2021-05-04 15:30:28'),
(37, 37, 29, 5, 'TN37CE3602', '2021-05-04 15:31:06', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201486939043', '201486939043', '500', 50, 450, 'C', '2021-05-04 15:31:08', '2021-05-04 15:31:08'),
(38, 38, 29, 5, 'TN47V1576', '2021-05-04 15:31:36', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201222462629', '201222462629', '500', 50, 450, 'C', '2021-05-04 15:31:38', '2021-05-04 15:31:38'),
(39, 39, 29, 5, 'TN66K5785', '2021-05-04 15:32:11', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201749956694', '201749956694', '500', 50, 450, 'C', '2021-05-04 15:32:13', '2021-05-04 15:32:13'),
(40, 40, 29, 5, 'TN66Z8667', '2021-05-04 15:32:37', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201987707476', '201987707476', '500', 50, 450, 'C', '2021-05-04 15:32:40', '2021-05-04 15:32:40'),
(41, 41, 29, 5, 'TN66K5785', '2021-05-04 15:32:11', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201273409225', '201273409225', '500', 50, 450, 'C', '2021-05-04 15:33:23', '2021-05-04 15:33:23'),
(42, 42, 24, 7, 'AL4646', '2021-05-04 17:02:25', '2021-05-04 17:33:16', 'Cash', NULL, NULL, '201479480148', '201479480148', '20', 2, 18, 'C', '2021-05-04 17:33:19', '2021-05-04 17:33:19'),
(43, 43, 24, 7, '9636', '2021-05-04 19:58:07', '2021-05-04 20:55:07', 'Cash', NULL, NULL, '201981515067', '201981515067', '20', 2, 18, 'C', '2021-05-04 20:55:10', '2021-05-04 20:55:10'),
(44, 46, 30, 5, 'TN37BY9843', '2021-05-05 11:47:03', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201668793905', '201668793905', '1000', 100, 900, 'C', '2021-05-05 11:47:06', '2021-05-05 11:47:06'),
(45, 47, 30, 5, 'TN99M5976', '2021-05-05 11:47:49', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201649031589', '201649031589', '1000', 100, 900, 'C', '2021-05-05 11:47:50', '2021-05-05 11:47:50'),
(46, 48, 30, 5, 'TN81C4039', '2021-05-05 11:48:42', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201917501820', '201917501820', '1000', 100, 900, 'C', '2021-05-05 11:48:43', '2021-05-05 11:48:43'),
(47, 49, 30, 5, 'TN58AA2277', '2021-05-05 11:49:41', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201422205347', '201422205347', '1000', 100, 900, 'C', '2021-05-05 11:49:42', '2021-05-05 11:49:42'),
(48, 50, 30, 5, 'TN38CM8525', '2021-05-05 11:51:54', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201287529846', '201287529846', '1000', 100, 900, 'C', '2021-05-05 11:51:55', '2021-05-05 11:51:55'),
(49, 51, 30, 5, 'TN38BA9641', '2021-05-05 11:54:10', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201669426963', '201669426963', '1000', 100, 900, 'C', '2021-05-05 11:54:11', '2021-05-05 11:54:11'),
(50, 52, 30, 5, 'TN37CH3414', '2021-05-05 11:55:11', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '202009680092', '202009680092', '1000', 100, 900, 'C', '2021-05-05 11:55:12', '2021-05-05 11:55:12'),
(51, 53, 30, 5, 'TN66W6423', '2021-05-05 11:57:05', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201499382972', '201499382972', '1000', 100, 900, 'C', '2021-05-05 11:57:06', '2021-05-05 11:57:06'),
(52, 54, 30, 5, 'TN37DD5900', '2021-05-05 11:57:58', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201256207402', '201256207402', '1000', 100, 900, 'C', '2021-05-05 11:58:05', '2021-05-05 11:58:05'),
(53, 55, 30, 5, 'TN38BE5544', '2021-05-05 11:58:41', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201463711717', '201463711717', '1000', 100, 900, 'C', '2021-05-05 11:58:42', '2021-05-05 11:58:42'),
(54, 56, 30, 5, 'TN38BT8060', '2021-05-05 11:59:20', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201702758671', '201702758671', '1000', 100, 900, 'C', '2021-05-05 11:59:21', '2021-05-05 11:59:21'),
(55, 57, 30, 5, 'TN09BE8448', '2021-05-05 12:00:04', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201433132435', '201433132435', '1000', 100, 900, 'C', '2021-05-05 12:00:05', '2021-05-05 12:00:05'),
(56, 58, 30, 5, 'TN66R4198', '2021-05-05 12:01:44', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201657976954', '201657976954', '1000', 100, 900, 'C', '2021-05-05 12:01:45', '2021-05-05 12:01:45'),
(57, 59, 30, 5, 'TN38BZ5502', '2021-05-05 12:03:00', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201279657953', '201279657953', '1000', 100, 900, 'C', '2021-05-05 12:03:01', '2021-05-05 12:03:01'),
(58, 60, 30, 5, 'TN37CB4097', '2021-05-05 12:03:43', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201429581824', '201429581824', '1000', 100, 900, 'C', '2021-05-05 12:03:44', '2021-05-05 12:03:44'),
(59, 61, 30, 5, 'TN49H1959', '2021-05-05 12:08:09', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201574744024', '201574744024', '1000', 100, 900, 'C', '2021-05-05 12:08:20', '2021-05-05 12:08:20'),
(60, 62, 29, 5, 'TN66V3721', '2021-05-05 12:12:51', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201715529891', '201715529891', '500', 50, 450, 'C', '2021-05-05 12:12:52', '2021-05-05 12:12:52'),
(61, 63, 29, 5, 'TN38CV8820', '2021-05-05 12:16:20', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201963990110', '201963990110', '500', 50, 450, 'C', '2021-05-05 12:16:21', '2021-05-05 12:16:21'),
(62, 64, 29, 5, 'KL09AQ5087', '2021-05-05 12:17:23', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201828296207', '201828296207', '500', 50, 450, 'C', '2021-05-05 12:17:24', '2021-05-05 12:17:24'),
(63, 65, 29, 5, 'TN37CP7414', '2021-05-05 12:18:01', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201643196511', '201643196511', '500', 50, 450, 'C', '2021-05-05 12:18:01', '2021-05-05 12:18:01'),
(64, 66, 29, 5, 'TN66Y1167', '2021-05-05 12:18:44', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201499878426', '201499878426', '500', 50, 450, 'C', '2021-05-05 12:18:45', '2021-05-05 12:18:45'),
(65, 67, 29, 5, 'TN99L6085', '2021-05-05 12:19:15', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201400681504', '201400681504', '500', 50, 450, 'C', '2021-05-05 12:19:16', '2021-05-05 12:19:16'),
(66, 68, 29, 5, 'TN66AB8631', '2021-05-05 15:23:32', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '202065114014', '202065114014', '500', 50, 450, 'C', '2021-05-05 15:23:34', '2021-05-05 15:23:34'),
(67, 69, 29, 5, 'TN66Q9471', '2021-05-05 15:26:00', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201813048054', '201813048054', '500', 50, 450, 'C', '2021-05-05 15:26:01', '2021-05-05 15:26:01'),
(68, 70, 29, 5, 'TN66E1773', '2021-05-05 15:29:59', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201923199617', '201923199617', '500', 50, 450, 'C', '2021-05-05 15:30:00', '2021-05-05 15:30:00'),
(69, 71, 29, 5, 'TN37DA4968', '2021-05-05 15:31:51', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201710272964', '201710272964', '500', 50, 450, 'C', '2021-05-05 15:31:51', '2021-05-05 15:31:51'),
(70, 72, 29, 5, 'TN37BX3728', '2021-05-05 15:32:32', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201879546352', '201879546352', '500', 50, 450, 'C', '2021-05-05 15:32:32', '2021-05-05 15:32:32'),
(71, 73, 29, 5, 'KL30B881', '2021-05-05 15:33:49', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201420251228', '201420251228', '500', 50, 450, 'C', '2021-05-05 15:33:50', '2021-05-05 15:33:50'),
(72, 74, 29, 5, 'TN38BR1667', '2021-05-05 15:38:33', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201894767199', '201894767199', '500', 50, 450, 'C', '2021-05-05 15:38:34', '2021-05-05 15:38:34'),
(73, 75, 29, 5, 'TN37D9708', '2021-05-05 15:40:31', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201685418681', '201685418681', '500', 50, 450, 'C', '2021-05-05 15:40:32', '2021-05-05 15:40:32'),
(74, 76, 29, 5, 'KL12L5795', '2021-05-05 15:41:22', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201383148705', '201383148705', '500', 50, 450, 'C', '2021-05-05 15:41:23', '2021-05-05 15:41:23'),
(75, 77, 29, 5, 'KL05AR1252', '2021-05-05 15:43:14', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201276052322', '201276052322', '500', 50, 450, 'C', '2021-05-05 15:43:15', '2021-05-05 15:43:15'),
(76, 78, 29, 5, 'TN37DH6141', '2021-05-05 15:43:56', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201302778250', '201302778250', '500', 50, 450, 'C', '2021-05-05 15:43:57', '2021-05-05 15:43:57'),
(77, 79, 29, 5, 'TN23W6681', '2021-05-05 15:49:14', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201596983661', '201596983661', '500', 50, 450, 'C', '2021-05-05 15:49:15', '2021-05-05 15:49:15'),
(78, 80, 29, 5, 'TN40Q1891', '2021-05-05 15:50:17', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201646306900', '201646306900', '500', 50, 450, 'C', '2021-05-05 15:50:18', '2021-05-05 15:50:18'),
(79, 81, 29, 5, 'TN38CP7456', '2021-05-05 15:51:12', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201466354147', '201466354147', '500', 50, 450, 'C', '2021-05-05 15:51:13', '2021-05-05 15:51:13'),
(80, 82, 29, 5, 'KL52L939', '2021-05-05 15:52:01', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201575927704', '201575927704', '500', 50, 450, 'C', '2021-05-05 15:52:02', '2021-05-05 15:52:02'),
(81, 83, 29, 5, 'TN66X3316', '2021-05-05 15:52:57', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201260748907', '201260748907', '500', 50, 450, 'C', '2021-05-05 15:52:58', '2021-05-05 15:52:58'),
(82, 84, 29, 5, 'TN66Z1462', '2021-05-05 15:53:49', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201779413587', '201779413587', '500', 50, 450, 'C', '2021-05-05 15:53:50', '2021-05-05 15:53:50'),
(83, 85, 29, 5, 'TN38BD3675', '2021-05-05 15:54:46', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201798432761', '201798432761', '500', 50, 450, 'C', '2021-05-05 15:54:47', '2021-05-05 15:54:47'),
(84, 86, 29, 5, 'TN66F2981', '2021-05-05 15:55:29', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201860554720', '201860554720', '500', 50, 450, 'C', '2021-05-05 15:55:29', '2021-05-05 15:55:29'),
(85, 87, 29, 5, 'TN30F3253', '2021-05-05 15:56:22', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201822186085', '201822186085', '500', 50, 450, 'C', '2021-05-05 15:56:23', '2021-05-05 15:56:23'),
(86, 88, 29, 5, 'TN37CP2401', '2021-05-05 15:57:14', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201360111012', '201360111012', '500', 50, 450, 'C', '2021-05-05 15:57:14', '2021-05-05 15:57:14'),
(87, 89, 29, 5, 'TN662468', '2021-05-05 15:57:48', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '202001725978', '202001725978', '500', 50, 450, 'C', '2021-05-05 15:57:49', '2021-05-05 15:57:49'),
(88, 90, 29, 5, 'TN38CR3081', '2021-05-05 15:58:25', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201729732538', '201729732538', '500', 50, 450, 'C', '2021-05-05 15:58:26', '2021-05-05 15:58:26'),
(89, 91, 29, 5, 'TN40T9964', '2021-05-05 15:59:13', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201278529494', '201278529494', '500', 50, 450, 'C', '2021-05-05 15:59:14', '2021-05-05 15:59:14'),
(90, 92, 29, 5, 'TN39CD9756', '2021-05-05 16:01:30', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201620764532', '201620764532', '500', 50, 450, 'C', '2021-05-05 16:01:30', '2021-05-05 16:01:30'),
(91, 93, 29, 5, 'TN22DD5946', '2021-05-05 16:02:04', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201590432941', '201590432941', '500', 50, 450, 'C', '2021-05-05 16:02:05', '2021-05-05 16:02:05'),
(92, 94, 29, 5, 'TN66S5959', '2021-05-05 16:02:45', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201750678427', '201750678427', '500', 50, 450, 'C', '2021-05-05 16:02:46', '2021-05-05 16:02:46'),
(93, 95, 29, 5, 'TN38CS8006', '2021-05-05 16:03:44', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201387552578', '201387552578', '500', 50, 450, 'C', '2021-05-05 16:03:45', '2021-05-05 16:03:45'),
(94, 96, 29, 5, 'TN38CP6845', '2021-05-05 16:04:36', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201787863528', '201787863528', '500', 50, 450, 'C', '2021-05-05 16:04:36', '2021-05-05 16:04:36'),
(95, 97, 29, 5, 'TN38BR6972', '2021-05-05 16:05:25', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '202093656616', '202093656616', '500', 50, 450, 'C', '2021-05-05 16:05:26', '2021-05-05 16:05:26'),
(96, 98, 29, 5, 'TN37BV4984', '2021-05-05 16:06:20', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201909822950', '201909822950', '500', 50, 450, 'C', '2021-05-05 16:06:21', '2021-05-05 16:06:21'),
(97, 99, 29, 5, 'TN38BJ2615', '2021-05-05 16:07:10', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201611488903', '201611488903', '500', 50, 450, 'C', '2021-05-05 16:07:11', '2021-05-05 16:07:11'),
(98, 100, 29, 5, 'TN66S0767', '2021-05-05 16:08:24', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201396718114', '201396718114', '500', 50, 450, 'C', '2021-05-05 16:08:25', '2021-05-05 16:08:25'),
(99, 101, 29, 5, 'TN43J6261', '2021-05-05 16:09:57', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201731934498', '201731934498', '500', 50, 450, 'C', '2021-05-05 16:09:58', '2021-05-05 16:09:58'),
(100, 102, 29, 5, 'TN38H6078', '2021-05-05 16:10:28', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201503649361', '201503649361', '500', 50, 450, 'C', '2021-05-05 16:10:29', '2021-05-05 16:10:29'),
(101, 103, 29, 5, 'TN38AL3818', '2021-05-05 16:10:58', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201741540420', '201741540420', '500', 50, 450, 'C', '2021-05-05 16:10:59', '2021-05-05 16:10:59'),
(102, 104, 29, 5, 'TN37CP4854', '2021-05-05 16:11:32', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201366028709', '201366028709', '500', 50, 450, 'C', '2021-05-05 16:11:33', '2021-05-05 16:11:33'),
(103, 105, 29, 5, 'TN37DJ5697', '2021-05-05 16:12:28', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201480584141', '201480584141', '500', 50, 450, 'C', '2021-05-05 16:12:28', '2021-05-05 16:12:28'),
(104, 106, 29, 5, 'TN38CF2587', '2021-05-05 16:13:39', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201396883260', '201396883260', '500', 50, 450, 'C', '2021-05-05 16:13:39', '2021-05-05 16:13:39'),
(105, 107, 29, 5, 'TN37BY9443', '2021-05-05 16:20:08', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201478850123', '201478850123', '500', 50, 450, 'C', '2021-05-05 16:20:09', '2021-05-05 16:20:09'),
(106, 108, 29, 5, 'TN66W9963', '2021-05-05 16:20:50', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '202028396916', '202028396916', '500', 50, 450, 'C', '2021-05-05 16:20:51', '2021-05-05 16:20:51'),
(107, 109, 29, 5, 'TN66Z0834', '2021-05-05 16:21:34', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201775532728', '201775532728', '500', 50, 450, 'C', '2021-05-05 16:21:34', '2021-05-05 16:21:34'),
(108, 110, 29, 5, 'TN41AH6161', '2021-05-05 16:22:10', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201433242639', '201433242639', '500', 50, 450, 'C', '2021-05-05 16:22:11', '2021-05-05 16:22:11'),
(109, 111, 29, 5, 'TN66A6793', '2021-05-05 16:22:56', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201480694240', '201480694240', '500', 50, 450, 'C', '2021-05-05 16:22:56', '2021-05-05 16:22:56'),
(110, 112, 29, 5, 'TN66A9545', '2021-05-05 16:24:38', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201724695661', '201724695661', '500', 50, 450, 'C', '2021-05-05 16:24:39', '2021-05-05 16:24:39'),
(111, 113, 29, 5, 'TN36Y4376', '2021-05-05 16:25:19', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201586772241', '201586772241', '500', 50, 450, 'C', '2021-05-05 16:25:19', '2021-05-05 16:25:19'),
(112, 114, 29, 5, 'TN39AY0816', '2021-05-05 16:26:22', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '202017029456', '202017029456', '500', 50, 450, 'C', '2021-05-05 16:26:22', '2021-05-05 16:26:22'),
(113, 115, 29, 5, 'TN45AU8610', '2021-05-05 16:27:21', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201362918485', '201362918485', '500', 50, 450, 'C', '2021-05-05 16:27:22', '2021-05-05 16:27:22'),
(114, 116, 29, 5, 'TN99F3511', '2021-05-05 16:28:09', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201373515276', '201373515276', '500', 50, 450, 'C', '2021-05-05 16:28:09', '2021-05-05 16:28:09'),
(115, 117, 29, 5, 'TN66AE1768', '2021-05-05 16:29:16', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201663124182', '201663124182', '500', 50, 450, 'C', '2021-05-05 16:29:17', '2021-05-05 16:29:17'),
(116, 118, 29, 5, 'TN66AF7434', '2021-05-05 16:30:01', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201749329761', '201749329761', '500', 50, 450, 'C', '2021-05-05 16:30:01', '2021-05-05 16:30:01'),
(117, 119, 29, 5, 'TS36A2778', '2021-05-05 16:31:14', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201873738834', '201873738834', '500', 50, 450, 'C', '2021-05-05 16:31:15', '2021-05-05 16:31:15'),
(118, 120, 29, 5, 'TN37CT6622', '2021-05-05 16:31:51', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201487052317', '201487052317', '500', 50, 450, 'C', '2021-05-05 16:31:51', '2021-05-05 16:31:51'),
(119, 121, 29, 5, 'KL09AG5728', '2021-05-05 16:32:38', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '202027323486', '202027323486', '500', 50, 450, 'C', '2021-05-05 16:32:38', '2021-05-05 16:32:38'),
(120, 122, 29, 5, 'TN37CP8980', '2021-05-05 16:33:16', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201941090385', '201941090385', '500', 50, 450, 'C', '2021-05-05 16:33:17', '2021-05-05 16:33:17'),
(121, 123, 29, 5, 'TN18AE9196', '2021-05-05 16:34:13', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201317806436', '201317806436', '500', 50, 450, 'C', '2021-05-05 16:34:14', '2021-05-05 16:34:14'),
(122, 124, 29, 5, 'TN38BL1308', '2021-05-05 16:34:52', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201554596536', '201554596536', '500', 50, 450, 'C', '2021-05-05 16:34:53', '2021-05-05 16:34:53'),
(123, 125, 29, 5, 'TN37CL0758', '2021-05-05 16:35:36', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201838645570', '201838645570', '500', 50, 450, 'C', '2021-05-05 16:35:36', '2021-05-05 16:35:36'),
(124, 126, 29, 5, 'TN99P2783', '2021-05-05 16:36:17', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201768734277', '201768734277', '500', 50, 450, 'C', '2021-05-05 16:36:20', '2021-05-05 16:36:20'),
(125, 127, 29, 5, 'TN38BQ9034', '2021-05-05 16:36:51', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201563046445', '201563046445', '500', 50, 450, 'C', '2021-05-05 16:36:51', '2021-05-05 16:36:51'),
(126, 128, 29, 5, 'TN99C1450', '2021-05-05 16:37:40', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201793505996', '201793505996', '500', 50, 450, 'C', '2021-05-05 16:37:41', '2021-05-05 16:37:41'),
(127, 129, 29, 5, 'TN69M2435', '2021-05-05 16:38:32', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201622911431', '201622911431', '500', 50, 450, 'C', '2021-05-05 16:38:32', '2021-05-05 16:38:32'),
(128, 130, 29, 5, 'TN69TJ2734', '2021-05-05 16:39:24', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201208976021', '201208976021', '500', 50, 450, 'C', '2021-05-05 16:39:25', '2021-05-05 16:39:25'),
(129, 131, 30, 5, 'TN37DH5445', '2021-05-05 16:45:38', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201984385853', '201984385853', '1000', 100, 900, 'C', '2021-05-05 16:45:40', '2021-05-05 16:45:40'),
(130, 132, 30, 5, 'TN37BT2380', '2021-05-05 16:46:17', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201856233498', '201856233498', '1000', 100, 900, 'C', '2021-05-05 16:46:18', '2021-05-05 16:46:18'),
(131, 133, 30, 5, 'TN38AR1729', '2021-05-05 16:46:52', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201556963616', '201556963616', '1000', 100, 900, 'C', '2021-05-05 16:46:53', '2021-05-05 16:46:53'),
(132, 134, 30, 5, 'TN37CJ2922', '2021-05-05 16:48:46', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201831599401', '201831599401', '1000', 100, 900, 'C', '2021-05-05 16:48:47', '2021-05-05 16:48:47'),
(133, 135, 30, 5, 'TN22CR6015', '2021-05-05 16:49:20', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '202088619743', '202088619743', '1000', 100, 900, 'C', '2021-05-05 16:49:21', '2021-05-05 16:49:21'),
(134, 136, 30, 5, 'TN30BK9430', '2021-05-06 10:13:17', '2021-05-07 10:13:17', 'Cash', NULL, NULL, '201430465068', '201430465068', '1000', 100, 900, 'C', '2021-05-06 10:13:22', '2021-05-06 10:13:22'),
(135, 137, 30, 5, 'TN09BH3700', '2021-05-06 10:14:06', '2021-05-07 10:14:06', 'Cash', NULL, NULL, '201641659923', '201641659923', '1000', 100, 900, 'C', '2021-05-06 10:14:07', '2021-05-06 10:14:07'),
(136, 138, 30, 5, 'TN66H464637', '2021-05-06 10:14:50', '2021-05-07 10:14:50', 'Cash', NULL, NULL, '201976384363', '201976384363', '1000', 100, 900, 'C', '2021-05-06 10:14:53', '2021-05-06 10:14:53'),
(137, 139, 30, 5, 'TN66W6917', '2021-05-06 10:15:47', '2021-05-07 10:15:47', 'Cash', NULL, NULL, '201524598577', '201524598577', '1000', 100, 900, 'C', '2021-05-06 10:15:48', '2021-05-06 10:15:48'),
(138, 140, 30, 5, 'TN37CB7525', '2021-05-06 10:16:35', '2021-05-07 10:16:35', 'Cash', NULL, NULL, '201514579689', '201514579689', '1000', 100, 900, 'C', '2021-05-06 10:16:35', '2021-05-06 10:16:35'),
(139, 141, 30, 5, 'TN99E5410', '2021-05-06 10:17:08', '2021-05-07 10:17:08', 'Cash', NULL, NULL, '201489559994', '201489559994', '1000', 100, 900, 'C', '2021-05-06 10:17:09', '2021-05-06 10:17:09'),
(140, 142, 30, 5, 'TN66R0342', '2021-05-06 10:17:46', '2021-05-07 10:17:46', 'Cash', NULL, NULL, '201291439237', '201291439237', '1000', 100, 900, 'C', '2021-05-06 10:17:47', '2021-05-06 10:17:47'),
(141, 143, 30, 5, 'TN66E7695', '2021-05-06 10:18:25', '2021-05-07 10:18:25', 'Cash', NULL, NULL, '201925188950', '201925188950', '1000', 100, 900, 'C', '2021-05-06 10:18:26', '2021-05-06 10:18:26'),
(142, 144, 30, 5, 'TN66R3003', '2021-05-06 10:18:52', '2021-05-07 10:18:52', 'Cash', NULL, NULL, '202043598994', '202043598994', '1000', 100, 900, 'C', '2021-05-06 10:18:53', '2021-05-06 10:18:53'),
(143, 145, 30, 5, 'TNBK2269', '2021-05-06 10:19:25', '2021-05-07 10:19:25', 'Cash', NULL, NULL, '201745894895', '201745894895', '1000', 100, 900, 'C', '2021-05-06 10:19:26', '2021-05-06 10:19:26'),
(144, 146, 30, 5, 'MH43AR3889', '2021-05-06 10:20:04', '2021-05-07 10:20:04', 'Cash', NULL, NULL, '201428758556', '201428758556', '1000', 100, 900, 'C', '2021-05-06 10:20:06', '2021-05-06 10:20:06'),
(145, 147, 30, 5, 'KL32K3429', '2021-05-06 10:20:47', '2021-05-07 10:20:47', 'Cash', NULL, NULL, '201230857994', '201230857994', '1000', 100, 900, 'C', '2021-05-06 10:20:48', '2021-05-06 10:20:48'),
(146, 148, 30, 5, 'TN38CT8944', '2021-05-06 10:21:27', '2021-05-07 10:21:27', 'Cash', NULL, NULL, '201675019521', '201675019521', '1000', 100, 900, 'C', '2021-05-06 10:21:28', '2021-05-06 10:21:28'),
(147, 149, 30, 5, 'TN37CP0177', '2021-05-06 10:22:39', '2021-05-07 10:22:39', 'Cash', NULL, NULL, '202066719509', '202066719509', '1000', 100, 900, 'C', '2021-05-06 10:22:40', '2021-05-06 10:22:40'),
(148, 150, 30, 5, 'TN38BM1977', '2021-05-06 10:23:20', '2021-05-07 10:23:20', 'Cash', NULL, NULL, '201864690284', '201864690284', '1000', 100, 900, 'C', '2021-05-06 10:23:21', '2021-05-06 10:23:21'),
(149, 151, 30, 5, 'TN37BF2556', '2021-05-06 10:23:52', '2021-05-07 10:23:52', 'Cash', NULL, NULL, '201341065762', '201341065762', '1000', 100, 900, 'C', '2021-05-06 10:23:53', '2021-05-06 10:23:53'),
(150, 152, 30, 5, 'TN38CU2289', '2021-05-06 10:24:16', '2021-05-07 10:24:16', 'Cash', NULL, NULL, '201659440702', '201659440702', '1000', 100, 900, 'C', '2021-05-06 10:24:17', '2021-05-06 10:24:17'),
(151, 153, 30, 5, 'TN38CE7571', '2021-05-06 10:24:48', '2021-05-07 10:24:48', 'Cash', NULL, NULL, '201949107674', '201949107674', '1000', 100, 900, 'C', '2021-05-06 10:24:48', '2021-05-06 10:24:48'),
(152, 154, 30, 5, 'TN66L8778', '2021-05-06 10:25:24', '2021-05-07 10:25:24', 'Cash', NULL, NULL, '201644494944', '201644494944', '1000', 100, 900, 'C', '2021-05-06 10:25:24', '2021-05-06 10:25:24'),
(153, 155, 30, 5, 'TN07CF4595', '2021-05-06 10:25:55', '2021-05-07 10:25:55', 'Cash', NULL, NULL, '201788667844', '201788667844', '1000', 100, 900, 'C', '2021-05-06 10:25:56', '2021-05-06 10:25:56'),
(154, 156, 30, 5, 'TN3841S4093', '2021-05-06 10:26:51', '2021-05-07 10:26:51', 'Cash', NULL, NULL, '201355516082', '201355516082', '1000', 100, 900, 'C', '2021-05-06 10:26:52', '2021-05-06 10:26:52'),
(155, 157, 30, 5, 'TN39CB5303', '2021-05-06 10:27:36', '2021-05-07 10:27:36', 'Cash', NULL, NULL, '201332010230', '201332010230', '1000', 100, 900, 'C', '2021-05-06 10:27:36', '2021-05-06 10:27:36'),
(156, 158, 30, 5, 'TN66AA1499', '2021-05-06 18:35:46', '2021-05-06 18:36:10', 'Cash', NULL, NULL, '201927281463', '201927281463', '0', 0, 0, 'C', '2021-05-06 18:36:12', '2021-05-06 18:36:12'),
(157, 162, 30, 5, 'TN66Z1735', '2021-05-07 10:13:13', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201891038771', '201891038771', '1000', 100, 900, 'C', '2021-05-07 10:13:14', '2021-05-07 10:13:14'),
(158, 163, 29, 5, 'TN66Z8667', '2021-05-07 10:16:23', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201556806067', '201556806067', '500', 50, 450, 'C', '2021-05-07 10:16:24', '2021-05-07 10:16:24'),
(159, 164, 29, 5, 'TN99J8100', '2021-05-07 10:17:54', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201327112256', '201327112256', '500', 50, 450, 'C', '2021-05-07 10:17:56', '2021-05-07 10:17:56'),
(160, 165, 29, 5, 'TN37BZ9367', '2021-05-07 10:18:43', '2021-05-31 23:59:59', 'Cash', NULL, NULL, '201226124049', '201226124049', '500', 50, 450, 'C', '2021-05-07 10:18:44', '2021-05-07 10:18:44'),
(161, 160, 24, 7, 'DB6204', '2021-05-07 10:04:03', '2021-05-07 10:20:22', 'Cash', NULL, NULL, '201203195955', '201203195955', '20', 2, 18, 'C', '2021-05-07 10:20:23', '2021-05-07 10:20:23'),
(162, 159, 24, 7, 'AG9804', '2021-05-07 10:03:25', '2021-05-07 11:20:49', 'Cash', NULL, NULL, '201240519483', '201240519483', '40', 4, 36, 'C', '2021-05-07 11:20:53', '2021-05-07 11:20:53'),
(163, 166, 24, 7, 'CL2398', '2021-05-07 10:51:19', '2021-05-07 11:34:16', 'Cash', NULL, NULL, '201773453233', '201773453233', '20', 2, 18, 'C', '2021-05-07 11:34:18', '2021-05-07 11:34:18'),
(164, 161, 25, 5, 'CD9939', '2021-05-07 10:05:53', '2021-05-07 11:57:13', 'Cash', NULL, NULL, '201842210015', '201842210015', '20', 2, 18, 'C', '2021-05-07 11:57:15', '2021-05-07 11:57:15'),
(165, 168, 24, 7, 'BR6676', '2021-05-07 11:41:08', '2021-05-07 11:57:44', 'Cash', NULL, NULL, '201741166743', '201741166743', '20', 2, 18, 'C', '2021-05-07 11:57:45', '2021-05-07 11:57:45'),
(166, 167, 24, 7, 'CF5367', '2021-05-07 11:27:58', '2021-05-07 12:17:07', 'Cash', NULL, NULL, '201745240438', '201745240438', '20', 2, 18, 'C', '2021-05-07 12:17:10', '2021-05-07 12:17:10'),
(167, 171, 24, 7, 'CZ6055', '2021-05-07 12:41:23', '2021-05-07 13:12:20', 'Cash', NULL, NULL, '201359123560', '201359123560', '20', 2, 18, 'C', '2021-05-07 13:12:22', '2021-05-07 13:12:22'),
(168, 172, 24, 7, 'AH9019', '2021-05-07 13:18:40', '2021-05-07 13:30:18', 'Cash', NULL, NULL, '201601588929', '201601588929', '20', 2, 18, 'C', '2021-05-07 13:30:19', '2021-05-07 13:30:19'),
(169, 169, 25, 5, 'V6661', '2021-05-07 11:44:25', '2021-05-07 13:40:54', 'Cash', NULL, NULL, '201384556417', '201384556417', '20', 2, 18, 'C', '2021-05-07 13:40:55', '2021-05-07 13:40:55'),
(170, 170, 24, 7, 'AB9219', '2021-05-07 12:18:45', '2021-05-07 13:44:05', 'Cash', NULL, NULL, '201752094173', '201752094173', '40', 4, 36, 'C', '2021-05-07 13:44:06', '2021-05-07 13:44:06'),
(171, 178, 24, 7, 'AL4646', '2021-05-07 17:55:12', '2021-05-07 18:53:44', 'Cash', NULL, NULL, '202066151860', '202066151860', '20', 2, 18, 'C', '2021-05-07 18:53:46', '2021-05-07 18:53:46'),
(172, 180, 25, 5, '9939', '2021-05-07 19:06:16', '2021-05-07 19:54:10', 'Cash', NULL, NULL, '201902902657', '201902902657', '10', 1, 9, 'C', '2021-05-07 19:54:14', '2021-05-07 19:54:14'),
(173, 179, 24, 7, '9804', '2021-05-07 17:56:12', '2021-05-07 20:21:07', 'Cash', NULL, NULL, '201940914393', '201940914393', '60', 6, 54, 'C', '2021-05-07 20:21:09', '2021-05-07 20:21:09'),
(174, 182, 24, 7, 'AD2857', '2021-05-08 10:23:21', '2021-05-08 10:27:53', 'Cash', NULL, NULL, '202103512101', '202103512101', '20', 2, 18, 'C', '2021-05-08 10:27:55', '2021-05-08 10:27:55'),
(175, 183, 25, 5, 'Q5294', '2021-05-08 10:28:47', '2021-05-08 10:57:23', 'Cash', NULL, NULL, '201861980001', '201861980001', '10', 1, 9, 'C', '2021-05-08 10:57:25', '2021-05-08 10:57:25'),
(176, 181, 24, 7, 'BU6144', '2021-05-08 10:07:08', '2021-05-08 11:42:55', 'Cash', NULL, NULL, '201386980592', '201386980592', '40', 4, 36, 'C', '2021-05-08 11:42:57', '2021-05-08 11:42:57');

-- --------------------------------------------------------

--
-- Table structure for table `payment_lists`
--

CREATE TABLE `payment_lists` (
  `id` int(10) UNSIGNED NOT NULL,
  `payment_id` int(10) UNSIGNED NOT NULL COMMENT 'Table = payments, Column = payment_id',
  `request_id` int(10) UNSIGNED NOT NULL COMMENT 'Table = payments, Column = request_id',
  `razorpay_payment_id` varchar(150) NOT NULL COMMENT 'RazorPay Payment ID',
  `amount` double NOT NULL COMMENT 'Amount paid via razorpay',
  `is_amount_transferred` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Transfer to Lot Owner, 0 = No, 1 = Transferred ',
  `transfer_account_number` varchar(100) DEFAULT NULL,
  `transfer_amount` float UNSIGNED DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `payment_type`
--

CREATE TABLE `payment_type` (
  `paymeny_type_id` int(11) NOT NULL,
  `payment_type_name` varchar(100) NOT NULL,
  `status` varchar(15) NOT NULL DEFAULT 'ACTIVE',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `promo_code`
--

CREATE TABLE `promo_code` (
  `promo_code_id` int(11) NOT NULL,
  `coupon_code` varchar(25) NOT NULL,
  `value` float NOT NULL,
  `type` varchar(30) NOT NULL,
  `uses` int(11) NOT NULL,
  `state_id` int(11) NOT NULL,
  `start_date` date NOT NULL,
  `expiry_date` date NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `promo_history`
--

CREATE TABLE `promo_history` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `promo_code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `amount_earned` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `space_provider`
--

CREATE TABLE `space_provider` (
  `provider_id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `lot_name` varchar(50) NOT NULL,
  `lot_unique_id` varchar(50) NOT NULL,
  `nearest_landmark` text NOT NULL,
  `lot_type_id` int(11) NOT NULL,
  `number_of_slots` int(11) NOT NULL,
  `is_land_verified` int(11) NOT NULL,
  `is_request_accessed` int(11) NOT NULL,
  `latitude` varchar(10) NOT NULL,
  `longitude` varchar(10) NOT NULL,
  `lot_location` text NOT NULL,
  `tarriff_id` int(11) NOT NULL,
  `timings` varchar(20) NOT NULL,
  `parking_capacity` int(11) NOT NULL,
  `QR_code` text NOT NULL,
  `base_fare` float NOT NULL,
  `base_duration` int(11) NOT NULL,
  `fare_after_basetime` varchar(100) NOT NULL,
  `fixed_amount` varchar(25) NOT NULL,
  `owner_share` varchar(25) NOT NULL,
  `agent_share` varchar(25) NOT NULL,
  `peak_hour_status` int(11) DEFAULT NULL,
  `peak_hour_fee` varchar(50) DEFAULT NULL,
  `peak_hour_start_time` varchar(50) DEFAULT NULL,
  `peak_hour_end_time` varchar(50) DEFAULT NULL,
  `ratings` int(11) DEFAULT NULL,
  `start_date` date NOT NULL,
  `lot_timings` varchar(64) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `extra_duration_hr` smallint(5) UNSIGNED DEFAULT NULL,
  `status` varchar(15) NOT NULL COMMENT 'A-Accepted,R-Rejected,P-Pending',
  `razorpay_account_id` varchar(100) DEFAULT NULL COMMENT 'Razorpay Account ID, Amount transfer via this ID ',
  `is_default_plan` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `custom_tariff_one` float UNSIGNED NOT NULL DEFAULT '0',
  `custom_tariff_two` float UNSIGNED NOT NULL DEFAULT '0',
  `custom_tariff_three` float UNSIGNED NOT NULL DEFAULT '0',
  `custom_tariff_four` float UNSIGNED NOT NULL DEFAULT '0',
  `custom_tariff_fare_one` float NOT NULL DEFAULT '0',
  `custom_tariff_fare_two` float NOT NULL DEFAULT '0',
  `custom_tariff_fare_three` float NOT NULL DEFAULT '0',
  `custom_tariff_fare_four` float NOT NULL DEFAULT '0',
  `flat_rate_charge` float NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `space_provider`
--

INSERT INTO `space_provider` (`provider_id`, `customer_id`, `lot_name`, `lot_unique_id`, `nearest_landmark`, `lot_type_id`, `number_of_slots`, `is_land_verified`, `is_request_accessed`, `latitude`, `longitude`, `lot_location`, `tarriff_id`, `timings`, `parking_capacity`, `QR_code`, `base_fare`, `base_duration`, `fare_after_basetime`, `fixed_amount`, `owner_share`, `agent_share`, `peak_hour_status`, `peak_hour_fee`, `peak_hour_start_time`, `peak_hour_end_time`, `ratings`, `start_date`, `lot_timings`, `created_at`, `updated_at`, `extra_duration_hr`, `status`, `razorpay_account_id`, `is_default_plan`, `custom_tariff_one`, `custom_tariff_two`, `custom_tariff_three`, `custom_tariff_four`, `custom_tariff_fare_one`, `custom_tariff_fare_two`, `custom_tariff_fare_three`, `custom_tariff_fare_four`, `flat_rate_charge`) VALUES
(24, 7, 'TIMC CAR PARKING', '', 'Coimbatore', 2, 60, 1, 1, '11.0168445', '76.9558321', 'Coimbatore, Tamil Nadu, India', 2, '', 1, '', 20, 1, '20', '100', '100', '100', 0, '', '04:45 PM', '04:45 PM', NULL, '2020-07-08', '09:00 AM-09:00 AM', '2020-05-14 00:00:00', '2020-05-14 00:00:00', 1, 'A', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 20),
(25, 5, 'TIMC BIKE PARKING', '', 'Coimbatore', 1, 126, 1, 1, '11.0168445', '76.9558321', 'Coimbatore, Tamil Nadu, India', 2, '', 1, '', 10, 1, '10', '10', '100', '100', 0, '', '04:15 PM', '04:15 PM', NULL, '2020-05-16', '09:00 AM-09:00 AM', '2020-05-16 00:00:00', '2020-05-16 00:00:00', 1, 'A', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 10),
(29, 5, 'TIMC BIKE PASS(COMPLEX)', '', 'Coimbatore', 1, 126, 1, 1, '11.0168445', '76.9558321', 'Coimbatore, Tamil Nadu, India', 2, '', 1, '', 10, 1, '10', '10', '100', '100', 0, '', '04:15 PM', '04:15 PM', NULL, '2020-05-16', '09:00 AM-09:00 AM', '2020-05-16 00:00:00', '2020-05-16 00:00:00', 1, 'A', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 500),
(30, 5, 'TIMC CAR PASS(COMPLEX)', '', 'Coimbatore', 1, 126, 1, 1, '11.0168445', '76.9558321', 'Coimbatore, Tamil Nadu, India', 2, '', 1, '', 10, 1, '10', '10', '100', '100', 0, '', '04:15 PM', '04:15 PM', NULL, '2020-05-16', '09:00 AM-09:00 AM', '2020-05-16 00:00:00', '2020-05-16 00:00:00', 1, 'A', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 1000),
(31, 5, 'YEARLY PASS (BIKE)', '', 'Coimbatore', 1, 126, 1, 1, '11.0168445', '76.9558321', 'Coimbatore, Tamil Nadu, India', 1, '', 1, '', 10, 1, '10', '0', '100', '100', 0, '', '04:15 PM', '04:15 PM', NULL, '2020-05-16', '09:00 AM-09:00 AM', '2020-05-16 00:00:00', '2020-05-16 00:00:00', 1, 'A', '', 1, 1, 1, 1, 1, 0, 0, 0, 0, 0),
(32, 5, 'YEARLY PASS (CAR)', '', 'Coimbatore', 2, 126, 1, 1, '11.0168445', '76.9558321', 'Coimbatore, Tamil Nadu, India', 2, '', 1, '', 1800, 720, '10', '0', '100', '100', 0, '', '04:15 PM', '04:15 PM', NULL, '2020-05-16', '09:00 AM-09:00 AM', '2020-05-16 00:00:00', '2020-05-16 00:00:00', 1, 'A', '', 1, 6, 6, 6, 6, 60, 60, 60, 60, 0);

-- --------------------------------------------------------

--
-- Table structure for table `tariff`
--

CREATE TABLE `tariff` (
  `tariff_id` int(11) NOT NULL,
  `tariff_name` varchar(50) NOT NULL,
  `tariff_type` varchar(50) NOT NULL,
  `tariff_duration` int(11) NOT NULL,
  `tax_id` int(11) NOT NULL,
  `tariff_timings` varchar(30) NOT NULL,
  `status` varchar(15) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tariff`
--

INSERT INTO `tariff` (`tariff_id`, `tariff_name`, `tariff_type`, `tariff_duration`, `tax_id`, `tariff_timings`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Bike Tariff', 'Hourly', 2, 1, '08:00 AM - 08:00 PM', 'ACTIVE', '2019-04-08 01:43:17', '2021-03-04 13:45:20'),
(2, 'Car Tariff', 'Hourly', 2, 1, '08:00 AM - 08:00 PM', 'ACTIVE', '2019-05-15 07:38:01', '2021-03-04 13:45:39');

-- --------------------------------------------------------

--
-- Table structure for table `taxes`
--

CREATE TABLE `taxes` (
  `tax_id` int(11) NOT NULL,
  `tax_name` varchar(50) NOT NULL,
  `tax_value` varchar(20) NOT NULL,
  `effective_from` date NOT NULL,
  `description` text NOT NULL,
  `status` varchar(15) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `taxes`
--

INSERT INTO `taxes` (`tax_id`, `tax_name`, `tax_value`, `effective_from`, `description`, `status`, `created_at`, `updated_at`) VALUES
(1, 'GST', '18', '2021-03-03', 'SGST & CGST', '', '2019-04-08 01:42:04', '2021-03-03 21:28:38');

--
-- Indexes for table `cancelled_parking_requests`
--
ALTER TABLE `cancelled_parking_requests`
  ADD PRIMARY KEY (`cancelled_parking_request_id`);

--
-- Indexes for table `customer_preferred_location`
--
ALTER TABLE `customer_preferred_location`
  ADD PRIMARY KEY (`customer_preferred_location_id`);

--
-- Indexes for table `customer_vehicle_details`
--
ALTER TABLE `customer_vehicle_details`
  ADD PRIMARY KEY (`customer_vehicle_id`);

--
-- Indexes for table `documents`
--
ALTER TABLE `documents`
  ADD PRIMARY KEY (`document_id`);

--
-- Indexes for table `document_type`
--
ALTER TABLE `document_type`
  ADD PRIMARY KEY (`document_type_id`);

--
-- Indexes for table `employee_parking_lot`
--
ALTER TABLE `employee_parking_lot`
  ADD PRIMARY KEY (`emp_par_id`);

--
-- Indexes for table `gcm_settings`
--
ALTER TABLE `gcm_settings`
  ADD PRIMARY KEY (`gcm_id`);

--
-- Indexes for table `images`
--
ALTER TABLE `images`
  ADD PRIMARY KEY (`image_id`);

--
-- Indexes for table `ledger`
--
ALTER TABLE `ledger`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ledger_owner_id_foreign` (`owner_id`);

--
-- Indexes for table `lot_specification`
--
ALTER TABLE `lot_specification`
  ADD PRIMARY KEY (`lot_specification_id`);

--
-- Indexes for table `lot_specification_with_provider`
--
ALTER TABLE `lot_specification_with_provider`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `lot_types`
--
ALTER TABLE `lot_types`
  ADD PRIMARY KEY (`lot_id`);

--
-- Indexes for table `parking_requests`
--
ALTER TABLE `parking_requests`
  ADD PRIMARY KEY (`request_id`),
  ADD UNIQUE KEY `payment_order_id` (`order_id`);

--
-- Indexes for table `parking_requests_offline`
--
ALTER TABLE `parking_requests_offline`
  ADD PRIMARY KEY (`request_id`);

--
-- Indexes for table `payments`
--
ALTER TABLE `payments`
  ADD UNIQUE KEY `payment_id` (`payment_id`);

--
-- Indexes for table `payments_offline`
--
ALTER TABLE `payments_offline`
  ADD UNIQUE KEY `payment_id` (`payment_id`);

--
-- Indexes for table `payment_lists`
--
ALTER TABLE `payment_lists`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `razorpay_payment_id` (`razorpay_payment_id`);

--
-- Indexes for table `payment_type`
--
ALTER TABLE `payment_type`
  ADD PRIMARY KEY (`paymeny_type_id`);

--
-- Indexes for table `promo_code`
--
ALTER TABLE `promo_code`
  ADD PRIMARY KEY (`promo_code_id`);

--
-- Indexes for table `promo_history`
--
ALTER TABLE `promo_history`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `space_provider`
--
ALTER TABLE `space_provider`
  ADD PRIMARY KEY (`provider_id`);

--
-- Indexes for table `tariff`
--
ALTER TABLE `tariff`
  ADD PRIMARY KEY (`tariff_id`);

--
-- Indexes for table `taxes`
--
ALTER TABLE `taxes`
  ADD PRIMARY KEY (`tax_id`);
--
-- AUTO_INCREMENT for table `cancelled_parking_requests`
--
ALTER TABLE `cancelled_parking_requests`
  MODIFY `cancelled_parking_request_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT for table `customer_preferred_location`
--
ALTER TABLE `customer_preferred_location`
  MODIFY `customer_preferred_location_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `customer_vehicle_details`
--
ALTER TABLE `customer_vehicle_details`
  MODIFY `customer_vehicle_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `documents`
--
ALTER TABLE `documents`
  MODIFY `document_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `document_type`
--
ALTER TABLE `document_type`
  MODIFY `document_type_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `employee_parking_lot`
--
ALTER TABLE `employee_parking_lot`
  MODIFY `emp_par_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=90;
--
-- AUTO_INCREMENT for table `gcm_settings`
--
ALTER TABLE `gcm_settings`
  MODIFY `gcm_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `images`
--
ALTER TABLE `images`
  MODIFY `image_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `ledger`
--
ALTER TABLE `ledger`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `lot_specification`
--
ALTER TABLE `lot_specification`
  MODIFY `lot_specification_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `lot_specification_with_provider`
--
ALTER TABLE `lot_specification_with_provider`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `lot_types`
--
ALTER TABLE `lot_types`
  MODIFY `lot_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `parking_requests`
--
ALTER TABLE `parking_requests`
  MODIFY `request_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `parking_requests_offline`
--
ALTER TABLE `parking_requests_offline`
  MODIFY `request_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=178;
--
-- AUTO_INCREMENT for table `payments`
--
ALTER TABLE `payments`
  MODIFY `payment_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `payments_offline`
--
ALTER TABLE `payments_offline`
  MODIFY `payment_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=177;
--
-- AUTO_INCREMENT for table `payment_lists`
--
ALTER TABLE `payment_lists`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `payment_type`
--
ALTER TABLE `payment_type`
  MODIFY `paymeny_type_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `promo_code`
--
ALTER TABLE `promo_code`
  MODIFY `promo_code_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `promo_history`
--
ALTER TABLE `promo_history`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `space_provider`
--
ALTER TABLE `space_provider`
  MODIFY `provider_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;
--
-- AUTO_INCREMENT for table `tariff`
--
ALTER TABLE `tariff`
  MODIFY `tariff_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `taxes`
--
ALTER TABLE `taxes`
  MODIFY `tax_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
