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

START TRANSACTION;



--
-- Database: `realestate`
--

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

--
-- Table structure for table `accountstypes`
--

CREATE TABLE `accountstypes` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `Name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `accountstypes`
--

INSERT INTO `accountstypes` (`ID`, `Code`, `Name`) VALUES
(21, 'N001P001', 'Sales'),
(22, 'N001P001', 'Revenue'),
(23, 'N001P001', 'Expenses'),
(24, 'N001P001', 'Bank'),
(25, 'N001P001', 'Assets'),
(26, 'N001P001', 'Liability'),
(27, 'N001P001', 'Trade Receivable'),
(28, 'N001P001', 'Trade Payable'),
(29, 'N001P001', 'Taxation'),
(30, 'N001P001', 'Rent Receivable');

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

--
-- Table structure for table `banks`
--

CREATE TABLE `banks` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `Name` varchar(255) NOT NULL,
  `Account` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `banks`
--

INSERT INTO `banks` (`ID`, `Code`, `Name`, `Account`) VALUES
(2, 'N001P001', 'CBZ Bank Account', '27635637728'),
(3, 'N001P001', 'NMB Bank Account', '647663564773');

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

--
-- Table structure for table `cashbook`
--

CREATE TABLE `cashbook` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `AccCode` varchar(255) NOT NULL,
  `Name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `cashbook`
--

INSERT INTO `cashbook` (`ID`, `Code`, `AccCode`, `Name`) VALUES
(8, 'N001P001', '8400', 'CABS USD');

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

--
-- Table structure for table `currencys`
--

CREATE TABLE `currencys` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `Symbol` varchar(255) NOT NULL,
  `Name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `currencys`
--

INSERT INTO `currencys` (`ID`, `Code`, `Symbol`, `Name`) VALUES
(9, 'N001P001', 'ZIG', 'ZIMBABWE GOLD'),
(10, 'N001P001', 'USD', 'USD Dollar'),
(11, 'N001P001', 'RAND', 'RAND');

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

--
-- Table structure for table `customerinvoicegenaration`
--

CREATE TABLE `customerinvoicegenaration` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `Status` varchar(255) NOT NULL,
  `AddedBy` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `customers`
--

CREATE TABLE `customers` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `AccCode` varchar(255) NOT NULL,
  `CustomeCode` varchar(255) NOT NULL,
  `Name` varchar(255) NOT NULL,
  `ContactPerson` varchar(255) NOT NULL,
  `Contact1` varchar(255) NOT NULL,
  `Contact2` varchar(255) NOT NULL,
  `Email` varchar(255) NOT NULL,
  `Address` varchar(255) NOT NULL,
  `EntryDate` date NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `customers`
--

INSERT INTO `customers` (`ID`, `Code`, `AccCode`, `CustomeCode`, `Name`, `ContactPerson`, `Contact1`, `Contact2`, `Email`, `Address`, `EntryDate`) VALUES
(9, 'N001P001', 'CUS001', 'N001C001', 'Gimatech Solutions Pvt Ltd', 'Taurayi Gift Nhiwatiwa', '0772662776', '0772662776', 'taurayigiftnhiwatiwa@gmail.com', '15307 1st Sunningdale', '2024-07-16');

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

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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `floors`
--

CREATE TABLE `floors` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `FloorNumber` varchar(255) NOT NULL,
  `Rooms` varchar(255) NOT NULL,
  `Space` varchar(255) NOT NULL,
  `EntryDate` date NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `floors`
--

INSERT INTO `floors` (`ID`, `Code`, `FloorNumber`, `Rooms`, `Space`, `EntryDate`) VALUES
(4, 'N001P001', '1', '11', '300sm', '2024-07-16'),
(5, 'N001P001', '10', '12', '30000sm', '2024-07-22'),
(6, 'N001P001', '2', '12', '300sm', '2024-07-22'),
(7, 'N001P001', '3', '12', '300sm', '2024-07-22');

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

--
-- Table structure for table `homecurrency`
--

CREATE TABLE `homecurrency` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `Currency` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `homecurrency`
--

INSERT INTO `homecurrency` (`ID`, `Code`, `Currency`) VALUES
(4, 'N001P001', '10');

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

--
-- Table structure for table `invoicegenaration`
--

CREATE TABLE `invoicegenaration` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `Status` varchar(255) NOT NULL,
  `AddedBy` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `invoicegenaration`
--

INSERT INTO `invoicegenaration` (`ID`, `Code`, `Status`, `AddedBy`) VALUES
(64, 'N001P001', '1', 'N001'),
(65, 'N001P001', '1', 'N001'),
(66, 'N001P001', '1', 'N001'),
(67, 'N001P001', '1', 'N001');

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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `journals`
--

CREATE TABLE `journals` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `AccCode` varchar(255) NOT NULL,
  `Name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `journals`
--

INSERT INTO `journals` (`ID`, `Code`, `AccCode`, `Name`) VALUES
(4, 'N001P001', 'GJ001', 'General Journal'),
(5, 'N001P001', 'TEN001', 'Tenant Journal'),
(6, 'N001P001', 'CUS001', 'Customer Journal'),
(7, 'N001P001', 'SUP001', 'Supplier Journal'),
(8, 'N001P001', 'CRJ001', 'Customer Return Journal'),
(9, 'N001P001', 'SJR001', 'Supplier Journal Return'),
(10, 'N001P001', 'TEN002', 'Tenant Return');

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

--
-- Table structure for table `mainaccounts`
--

CREATE TABLE `mainaccounts` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `Acctype` varchar(255) NOT NULL,
  `AccCode` varchar(255) NOT NULL,
  `AccName` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mainaccounts`
--

INSERT INTO `mainaccounts` (`ID`, `Code`, `Acctype`, `AccCode`, `AccName`) VALUES
(26, 'N001P001', '22', '1000', 'Rent Received'),
(27, 'N001P001', '23', '4000', 'OP Costs'),
(28, 'N001P001', '27', '7100', 'Accounts Receivable'),
(29, 'N001P001', '28', '9100', 'Accounts Payable'),
(30, 'N001P001', '24', '8400', 'CABS USD'),
(31, 'N001P001', '24', '8401', 'CABS ZIG'),
(32, 'N001P001', '26', '9550', 'Take on Suspense'),
(36, 'N001P001', '30', '6000', 'Tenant Receivable');

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1);

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

--
-- Table structure for table `otheraccounts`
--

CREATE TABLE `otheraccounts` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `AccCode` varchar(255) NOT NULL,
  `Name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `otheraccounts`
--

INSERT INTO `otheraccounts` (`ID`, `Code`, `AccCode`, `Name`) VALUES
(16, 'N001P001', '9100', 'Suppliers'),
(17, 'N001P001', '7100', 'Customers'),
(18, 'N001P001', '6000', 'Tenants');

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

--
-- Table structure for table `propertydetails`
--

CREATE TABLE `propertydetails` (
  `ID` int(100) NOT NULL,
  `Ownerreg` varchar(255) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `Name` varchar(255) NOT NULL,
  `Address` varchar(255) NOT NULL,
  `Type` varchar(255) NOT NULL,
  `Floors` varchar(255) NOT NULL,
  `Area` varchar(255) NOT NULL,
  `Groups` varchar(255) NOT NULL,
  `Rooms` varchar(255) NOT NULL,
  `Space` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `propertydetails`
--

INSERT INTO `propertydetails` (`ID`, `Ownerreg`, `Code`, `Name`, `Address`, `Type`, `Floors`, `Area`, `Groups`, `Rooms`, `Space`) VALUES
(32, 'N001', 'N001P001', 'Regal Star House', '25 George Silundika Harare', 'Story Building1', '10', 'CBD Harare', 'Commercial', '11', '30000sm');

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

--
-- Table structure for table `rates`
--

CREATE TABLE `rates` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `Currency` varchar(255) NOT NULL,
  `Rate` varchar(255) NOT NULL,
  `EntryDate` date NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `rates`
--

INSERT INTO `rates` (`ID`, `Code`, `Currency`, `Rate`, `EntryDate`) VALUES
(7, 'N001P001', '9', '15', '2024-07-15'),
(8, 'N001P001', '9', '15', '2024-07-15'),
(9, 'N001P001', '9', '17', '2024-07-15'),
(10, 'N001P001', '11', '17', '2024-07-15'),
(11, 'N001P001', '9', '13.56', '2024-08-02');

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

--
-- Table structure for table `rooms`
--

CREATE TABLE `rooms` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `Floor` varchar(255) NOT NULL,
  `Room` varchar(255) NOT NULL,
  `Space` varchar(255) NOT NULL,
  `Tenant` varchar(255) NOT NULL,
  `EntryDate` date NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `rooms`
--

INSERT INTO `rooms` (`ID`, `Code`, `Floor`, `Room`, `Space`, `Tenant`, `EntryDate`) VALUES
(2, 'N001P001', '10', '1004', '18sqm', 'N001T001', '2024-07-22'),
(3, 'N001P001', '10', '1005', '18sqm', 'N001T001', '2024-07-22'),
(4, 'N001P001', '10', '1006', '18sqm', 'N001T001', '2024-07-22');

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('PxXougmw1UM0oVnJQlQKk0aknJ0JE4CuasSNu2Ib', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36 Edg/127.0.0.0', 'YTo3OntzOjY6Il90b2tlbiI7czo0MDoidUVITWlTZ2lWamlLUkRnZUtTYXo5Y1R3VTdTU1pkMWNmVjdoZkN4QyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzY6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9JbnZvaWNlL1RlbmFudCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NDoiTmFtZSI7czoyMjoiVGF1cmF5aSBHaWZ0IE5oaXdhdGl3YSI7czo1OiJSZWdObyI7czo0OiJOMDAxIjtzOjEyOiJQcm9wZXJ0eU5hbWUiO3M6MTY6IlJlZ2FsIFN0YXIgSG91c2UiO3M6MTI6IlByb3BlcnR5Q29kZSI7czo4OiJOMDAxUDAwMSI7fQ==', 1722583278),
('q7oBtqOlmYEBSwyu6XOGv4odK3vKKumgfgP4IWZW', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36 Edg/127.0.0.0', 'YTo3OntzOjY6Il90b2tlbiI7czo0MDoidzdnYTJ5RnJlR0RWc2lHRGZZc0djU3E0RFVCYWVPYjlBYnJmZUszaSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDk6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9QcmludEludm9pY2UvVGVuYW50L0lOVjAwMDQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjQ6Ik5hbWUiO3M6MjI6IlRhdXJheWkgR2lmdCBOaGl3YXRpd2EiO3M6NToiUmVnTm8iO3M6NDoiTjAwMSI7czoxMjoiUHJvcGVydHlOYW1lIjtzOjE2OiJSZWdhbCBTdGFyIEhvdXNlIjtzOjEyOiJQcm9wZXJ0eUNvZGUiO3M6ODoiTjAwMVAwMDEiO30=', 1722590916);

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

--
-- Table structure for table `subaccounts`
--

CREATE TABLE `subaccounts` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `AccCode` varchar(255) NOT NULL,
  `SubCode` varchar(255) NOT NULL,
  `SubName` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `subaccounts`
--

INSERT INTO `subaccounts` (`ID`, `Code`, `AccCode`, `SubCode`, `SubName`) VALUES
(22, 'N001P001', '4000', '100', 'Cleaning'),
(23, 'N001P001', '4000', '101', 'Electricity'),
(24, 'N001P001', '4000', '102', 'Plumbing');

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

--
-- Table structure for table `suppliers`
--

CREATE TABLE `suppliers` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `AccCode` varchar(255) NOT NULL,
  `SupplierCode` varchar(255) NOT NULL,
  `Name` varchar(255) NOT NULL,
  `ContactPerson` varchar(255) NOT NULL,
  `Contact1` varchar(255) NOT NULL,
  `Contact2` varchar(255) NOT NULL,
  `Address` varchar(255) NOT NULL,
  `Email` text NOT NULL,
  `EntryDate` date NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `suppliers`
--

INSERT INTO `suppliers` (`ID`, `Code`, `AccCode`, `SupplierCode`, `Name`, `ContactPerson`, `Contact1`, `Contact2`, `Address`, `Email`, `EntryDate`) VALUES
(4, 'N001P001', 'SUP001', 'N001S001', 'Melsoft Solutions Pvt Ltd', 'Taurayi Gift Nhiwatiwa', '0772662776', '0772662776', '15307 1st Sunningdale', 'taurayigiftnhiwatiwa@gmail.com', '2024-07-16');

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

--
-- Table structure for table `tax`
--

CREATE TABLE `tax` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `Name` varchar(255) NOT NULL,
  `Rate` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tax`
--

INSERT INTO `tax` (`ID`, `Code`, `Name`, `Rate`) VALUES
(9, 'N001P001', 'Zero-Rated', '0'),
(11, 'N001P001', 'VAT', '15'),
(12, 'N001P001', 'Exempted', '0'),
(13, 'N001P001', 'Adjustment Input', '15'),
(14, 'N001P001', 'Adjustment Output', '15');

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

--
-- Table structure for table `tenants`
--

CREATE TABLE `tenants` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `AccCode` varchar(255) NOT NULL,
  `TenantCode` varchar(255) NOT NULL,
  `Name` varchar(255) NOT NULL,
  `ContactPerson` varchar(255) NOT NULL,
  `Contact` varchar(255) NOT NULL,
  `Email` varchar(255) NOT NULL,
  `Address` varchar(255) NOT NULL,
  `VAT` varchar(255) NOT NULL,
  `TIN` varchar(255) NOT NULL,
  `Floor` varchar(255) NOT NULL,
  `Space` varchar(255) NOT NULL,
  `Rooms` varchar(255) NOT NULL,
  `EntryDate` date NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tenants`
--

INSERT INTO `tenants` (`ID`, `Code`, `AccCode`, `TenantCode`, `Name`, `ContactPerson`, `Contact`, `Email`, `Address`, `VAT`, `TIN`, `Floor`, `Space`, `Rooms`, `EntryDate`) VALUES
(11, 'N001P001', '6000', 'N001T001', 'Melsoft Solutions Pvt Ltd', 'Ellia Zibayiwa', '0772662776', 'taurayigiftnhiwatiwa@gmail.com', '15307 1st Sunningdale', '0000', '000', '10', '300sm', '3', '2024-07-22');

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

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `EntryDate` varchar(255) NOT NULL,
  `Narration` varchar(255) NOT NULL,
  `Refference` varchar(255) NOT NULL,
  `Accode` varchar(255) NOT NULL,
  `AccSubCode` varchar(255) NOT NULL,
  `ContraCode` varchar(255) NOT NULL,
  `ContraSubCode` varchar(255) NOT NULL,
  `DR` varchar(255) NOT NULL,
  `CR` varchar(255) NOT NULL,
  `Addedby` varchar(255) NOT NULL,
  `Source` varchar(255) NOT NULL,
  `Qnty` varchar(255) NOT NULL,
  `Price` varchar(255) NOT NULL,
  `Tax` varchar(255) NOT NULL,
  `TaxID` varchar(255) NOT NULL,
  `Discount` varchar(255) NOT NULL,
  `Total` varchar(255) NOT NULL,
  `Batch` varchar(255) NOT NULL,
  `Currency` varchar(255) NOT NULL,
  `Rate` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`ID`, `Code`, `EntryDate`, `Narration`, `Refference`, `Accode`, `AccSubCode`, `ContraCode`, `ContraSubCode`, `DR`, `CR`, `Addedby`, `Source`, `Qnty`, `Price`, `Tax`, `TaxID`, `Discount`, `Total`, `Batch`, `Currency`, `Rate`) VALUES
(93, 'N001P001', '2024-08-02', 'Operation Cost', 'Refference', '6000', 'N001T001', '4000', '100', '0', '8.311209439528', 'N001', 'Tenant', '1', '7.3746312684366', '15', '11', '2', '7.3746312684366', 'INV0001', '9', '13.56'),
(94, 'N001P001', '2024-08-02', 'Operation Cost', 'Refference', '6000', 'N001T001', '4000', '100', '0', '6.6294117647059', 'N001', 'Tenant', '1', '5.8823529411765', '15', '11', '2', '5.8823529411765', 'INV0002', '11', '17'),
(95, 'N001P001', '2024-08-02', 'Operation Cost', 'Refference', '6000', 'N001T001', '4000', '100', '0', '112.7', 'N001', 'Tenant', '1', '100', '15', '11', '2', '100', 'INV0003', '10', '1'),
(96, 'N001P001', '2024-08-02', 'Operation Cost', 'Refference', '6000', 'N001T001', '4000', '100', '0', '112.7', 'N001', 'Tenant', '1', '100', '15', '11', '2', '100', 'INV0004', '10', '1'),
(97, 'N001P001', '2024-08-02', 'JULY RENT', 'JULY RENT', '6000', 'N001T001', '1000', '0', '0', '805', 'N001', 'Tenant', '1', '700', '15', '11', '0', '700', 'INV0004', '10', '1');

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

--
-- Table structure for table `transactionsjob`
--

CREATE TABLE `transactionsjob` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `EntryDate` varchar(255) NOT NULL,
  `Narration` varchar(255) NOT NULL,
  `Refference` varchar(255) NOT NULL,
  `Accode` varchar(255) NOT NULL,
  `AccSubCode` varchar(255) NOT NULL,
  `ContraCode` varchar(255) NOT NULL,
  `ContraSubCode` varchar(255) NOT NULL,
  `DR` varchar(255) NOT NULL,
  `CR` varchar(255) NOT NULL,
  `Addedby` varchar(255) NOT NULL,
  `Source` varchar(255) NOT NULL,
  `Qnty` varchar(255) NOT NULL,
  `Price` varchar(255) NOT NULL,
  `Tax` varchar(255) NOT NULL,
  `TaxID` varchar(255) NOT NULL,
  `Discount` varchar(255) NOT NULL,
  `Total` varchar(255) NOT NULL,
  `Batch` varchar(255) NOT NULL,
  `Currency` varchar(255) NOT NULL,
  `Rate` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `accountstypes`
--
ALTER TABLE `accountstypes`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `banks`
--
ALTER TABLE `banks`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `cashbook`
--
ALTER TABLE `cashbook`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `currencys`
--
ALTER TABLE `currencys`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `customerinvoicegenaration`
--
ALTER TABLE `customerinvoicegenaration`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `customers`
--
ALTER TABLE `customers`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `floors`
--
ALTER TABLE `floors`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `homecurrency`
--
ALTER TABLE `homecurrency`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `invoicegenaration`
--
ALTER TABLE `invoicegenaration`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

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

--
-- Indexes for table `journals`
--
ALTER TABLE `journals`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `mainaccounts`
--
ALTER TABLE `mainaccounts`
  ADD PRIMARY KEY (`ID`);

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

--
-- Indexes for table `otheraccounts`
--
ALTER TABLE `otheraccounts`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `propertydetails`
--
ALTER TABLE `propertydetails`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `rates`
--
ALTER TABLE `rates`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `rooms`
--
ALTER TABLE `rooms`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

--
-- Indexes for table `subaccounts`
--
ALTER TABLE `subaccounts`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `suppliers`
--
ALTER TABLE `suppliers`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `tax`
--
ALTER TABLE `tax`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `tenants`
--
ALTER TABLE `tenants`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `transactionsjob`
--
ALTER TABLE `transactionsjob`
  ADD PRIMARY KEY (`ID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `accountstypes`
--
ALTER TABLE `accountstypes`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `banks`
--
ALTER TABLE `banks`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `cashbook`
--
ALTER TABLE `cashbook`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `currencys`
--
ALTER TABLE `currencys`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `customerinvoicegenaration`
--
ALTER TABLE `customerinvoicegenaration`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;

--
-- AUTO_INCREMENT for table `customers`
--
ALTER TABLE `customers`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `floors`
--
ALTER TABLE `floors`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `homecurrency`
--
ALTER TABLE `homecurrency`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `invoicegenaration`
--
ALTER TABLE `invoicegenaration`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=68;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `journals`
--
ALTER TABLE `journals`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `mainaccounts`
--
ALTER TABLE `mainaccounts`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `otheraccounts`
--
ALTER TABLE `otheraccounts`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `propertydetails`
--
ALTER TABLE `propertydetails`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT for table `rates`
--
ALTER TABLE `rates`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `rooms`
--
ALTER TABLE `rooms`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `subaccounts`
--
ALTER TABLE `subaccounts`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT for table `suppliers`
--
ALTER TABLE `suppliers`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `tax`
--
ALTER TABLE `tax`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `tenants`
--
ALTER TABLE `tenants`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=99;

--
-- AUTO_INCREMENT for table `transactionsjob`
--
ALTER TABLE `transactionsjob`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=76;
COMMIT;

