
-- phpMyAdmin SQL Dump
-- version 5.0.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jun 21, 2021 at 08:12 PM
-- Server version: 10.4.11-MariaDB
-- PHP Version: 7.2.31

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `dhhl_soft`
--

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

--
-- Table structure for table `accounts`
--

CREATE TABLE `accounts` (
  `id` int(11) NOT NULL,
  `reference_id` int(11) NOT NULL,
  `member_id` int(11) DEFAULT NULL,
  `sell_id` int(11) DEFAULT NULL,
  `company_log` double DEFAULT NULL,
  `reference_log` double DEFAULT NULL,
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `accounts`
--

INSERT INTO `accounts` (`id`, `reference_id`, `member_id`, `sell_id`, `company_log`, `reference_log`, `updated_at`, `created_at`) VALUES
(107, 29, 44, 107, 69000, NULL, '2021-06-20 20:11:14', '2021-06-20 19:58:28');

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

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

CREATE TABLE `banks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ac_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slip_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `current_balance` double DEFAULT NULL,
  `after_dp_balance` double DEFAULT NULL,
  `after_wd_balance` double DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `bank_withdraws`
--

CREATE TABLE `bank_withdraws` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `bank_id` int(10) UNSIGNED NOT NULL,
  `amount` double NOT NULL,
  `slip_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `baynas`
--

CREATE TABLE `baynas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `donor_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `land_volume` double DEFAULT NULL,
  `stain_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ledger` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shotok_price` double DEFAULT NULL,
  `total_price` double DEFAULT NULL,
  `paid_amount` double DEFAULT NULL,
  `deu_amount` double DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `baynas`
--

INSERT INTO `baynas` (`id`, `donor_name`, `land_volume`, `stain_number`, `ledger`, `shotok_price`, `total_price`, `paid_amount`, `deu_amount`, `created_at`, `updated_at`) VALUES
(1, 'Shubhra', 120, '43598jdkf', 'sdhfkjs', 6, 720, 67544, -66824, '2020-03-03 12:01:41', '2021-02-03 16:15:16');

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

--
-- Table structure for table `blocks`
--

CREATE TABLE `blocks` (
  `id` int(11) NOT NULL,
  `block_no` int(11) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `katha` double NOT NULL,
  `booking_amount` double NOT NULL,
  `installment_amount` double NOT NULL,
  `ekkalin_amount` double NOT NULL,
  `status` int(11) DEFAULT NULL,
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `blocks`
--

INSERT INTO `blocks` (`id`, `block_no`, `title`, `katha`, `booking_amount`, `installment_amount`, `ekkalin_amount`, `status`, `updated_at`, `created_at`) VALUES
(15, 1, 'Block A', 5, 100000, 20, 40, 0, '2021-06-20 19:57:49', '2021-06-19 18:02:11');

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

--
-- Table structure for table `booking_forms`
--

CREATE TABLE `booking_forms` (
  `id` int(11) NOT NULL,
  `member_id` int(11) DEFAULT NULL,
  `mem_signature` text DEFAULT NULL,
  `serial_id` int(11) DEFAULT NULL,
  `sale_id` int(11) DEFAULT NULL,
  `name` text DEFAULT NULL,
  `so` text DEFAULT NULL,
  `mother` text DEFAULT NULL,
  `dob` text DEFAULT NULL,
  `profession` text DEFAULT NULL,
  `religion` text DEFAULT NULL,
  `present_address` text DEFAULT NULL,
  `permanent_address` text DEFAULT NULL,
  `mobile` text DEFAULT NULL,
  `office` text DEFAULT NULL,
  `res` text DEFAULT NULL,
  `email` text DEFAULT NULL,
  `n_name` text DEFAULT NULL,
  `n_so` text DEFAULT NULL,
  `n_address` text DEFAULT NULL,
  `n_relation` text DEFAULT NULL,
  `nationality` text DEFAULT NULL,
  `n_nationality` text DEFAULT NULL,
  `n_dob` text DEFAULT NULL,
  `nominee_pic` text DEFAULT NULL,
  `ref` text DEFAULT NULL,
  `ref_signature` text DEFAULT NULL,
  `check_no` text DEFAULT NULL,
  `name_project` text DEFAULT NULL,
  `bank` text DEFAULT NULL,
  `branch` text DEFAULT NULL,
  `date` text DEFAULT NULL,
  `tk` text DEFAULT NULL,
  `tk_word` text DEFAULT NULL,
  `auth_date` text DEFAULT NULL,
  `app_date` text DEFAULT NULL,
  `down_pay` text DEFAULT NULL,
  `block` text DEFAULT NULL,
  `block_no` int(11) DEFAULT NULL,
  `plot_no` int(11) DEFAULT NULL,
  `face` varchar(191) DEFAULT NULL,
  `road` varchar(191) DEFAULT NULL,
  `plot_size` varchar(191) DEFAULT NULL,
  `ins` text DEFAULT NULL,
  `booking` int(11) DEFAULT NULL,
  `rate_per` double DEFAULT NULL,
  `total_rate` double DEFAULT NULL,
  `ins_no` int(11) DEFAULT NULL,
  `ins_am` double DEFAULT NULL,
  `one` text DEFAULT NULL,
  `file_no` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `booking_forms`
--

INSERT INTO `booking_forms` (`id`, `member_id`, `mem_signature`, `serial_id`, `sale_id`, `name`, `so`, `mother`, `dob`, `profession`, `religion`, `present_address`, `permanent_address`, `mobile`, `office`, `res`, `email`, `n_name`, `n_so`, `n_address`, `n_relation`, `nationality`, `n_nationality`, `n_dob`, `nominee_pic`, `ref`, `ref_signature`, `check_no`, `name_project`, `bank`, `branch`, `date`, `tk`, `tk_word`, `auth_date`, `app_date`, `down_pay`, `block`, `block_no`, `plot_no`, `face`, `road`, `plot_size`, `ins`, `booking`, `rate_per`, `total_rate`, `ins_no`, `ins_am`, `one`, `file_no`, `created_at`, `updated_at`) VALUES
(1, NULL, 'members/dvI2Uw5o9x2li6IEnhkzVBu01hdRL5RKSCaD4GtG.png', 1, 107, 'Harry Potter', 'Potter', 'Potter', '21-06-2021', 'Wizard', 'christian', 'Hogwarts', 'Hogwarts', '55876685765', 'No information', 'No information', 'harry@gmail.com', NULL, NULL, NULL, NULL, 'American', NULL, NULL, NULL, NULL, 'members/LgjH2m5c8emE66pjdExmgep47BAdKTrCJ7ZGyEyb.jpeg', 'No information', 'No information', 'City', 'Rangpur', '2-5-2020', '60000', 'Sixty Thousand Only', 'No information', 'No information', 'No information', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'No information', NULL, NULL, '2021-06-20 20:26:23');

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

--
-- Table structure for table `commision_plans`
--

CREATE TABLE `commision_plans` (
  `id` int(11) NOT NULL,
  `katha` double NOT NULL,
  `booking_amount` double NOT NULL,
  `installment_amount` double NOT NULL,
  `ekkalin_amount` double NOT NULL,
  `block_id` int(11) NOT NULL,
  `block_title` varchar(255) NOT NULL,
  `status` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `commision_plans`
--

INSERT INTO `commision_plans` (`id`, `katha`, `booking_amount`, `installment_amount`, `ekkalin_amount`, `block_id`, `block_title`, `status`, `created_at`, `updated_at`) VALUES
(46, 5, 100000, 20, 40, 15, 'Block A', 0, '2021-06-20 13:57:49', '2021-06-20 13:57:49');

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

--
-- Table structure for table `companies`
--

CREATE TABLE `companies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mobile` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `logo` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `quote` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `companies`
--

INSERT INTO `companies` (`id`, `name`, `mobile`, `address`, `logo`, `email`, `quote`, `created_at`, `updated_at`) VALUES
(1, 'Dream Haven Housing Ltd.', '+8801915-618117', '5B-1 ittefaq Bhaban, 1 R.K Mission Road, Motizil , Dhaka - 1203', 'logo/nArY4r6hVjlhh2XpxiANkztoCnvrHZKi1ssa9ytY.png', 'dreamgreencity@gmail.com', '5B-1 ittefaq Bhaban, 1 R.K Mission Road, Motizil , Dhaka - 1203', '2020-03-03 12:19:38', '2021-06-14 05:35:00');

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

--
-- Table structure for table `custom_installments`
--

CREATE TABLE `custom_installments` (
  `id` bigint(11) NOT NULL,
  `amount` double DEFAULT NULL,
  `remark` text DEFAULT NULL,
  `via` text DEFAULT NULL,
  `bank_name` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `account_no` text DEFAULT NULL,
  `money_rec` text DEFAULT NULL,
  `isDelete` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `member_id` int(11) NOT NULL,
  `saled_id` int(11) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `serial_id` int(11) NOT NULL,
  `reference_id` int(11) NOT NULL,
  `due` double NOT NULL,
  `ins_no` int(11) DEFAULT NULL,
  `company_log` double DEFAULT NULL,
  `refference_log` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `demo_installments`
--

CREATE TABLE `demo_installments` (
  `id` bigint(20) NOT NULL,
  `member_id` int(11) DEFAULT NULL,
  `serial_id` int(11) DEFAULT NULL,
  `reference_id` int(11) DEFAULT NULL,
  `sales_id` int(11) DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `company_log` double DEFAULT NULL,
  `refference_log` double DEFAULT NULL,
  `due` double DEFAULT NULL,
  `date` date DEFAULT NULL,
  `ins_no` int(11) DEFAULT NULL,
  `remark` text DEFAULT NULL,
  `via` text DEFAULT NULL,
  `bank_name` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `account_no` text DEFAULT NULL,
  `money_rec` text DEFAULT NULL,
  `isDelete` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `deposits`
--

CREATE TABLE `deposits` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `slip_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank_id` int(11) DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `expences`
--

CREATE TABLE `expences` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `expence_head_id` int(10) UNSIGNED NOT NULL,
  `date` date DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `isDelete` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `expences`
--

INSERT INTO `expences` (`id`, `expence_head_id`, `date`, `description`, `note`, `amount`, `isDelete`, `created_at`, `updated_at`) VALUES
(2, 6, '2020-03-04', 'CNG Refuel', 'fef', 768, 0, '2020-03-04 04:26:51', '2021-06-21 12:08:18'),
(3, 2, '2020-03-05', 'f', 'f', 500, 0, '2020-03-04 04:56:03', '2020-03-04 04:56:03'),
(4, 3, '2020-12-14', 'Food Distribution', 'Huze Finance Delavery', 135700, 0, '2020-12-14 12:16:24', '2020-12-14 12:16:24'),
(5, 1, '2021-02-03', 'rabbi;lmm, lsd;l', 'ai taka Abdur rahim er', 500, 0, '2021-02-03 16:33:42', '2021-02-03 16:33:42'),
(6, 4, '2021-03-11', 'Mr - lksij\r\nklsjdoj\r\nlkasjdjasd', 'korim rigestruy ভালু না । রা', 100000, 0, '2021-03-11 16:09:20', '2021-03-11 16:11:04'),
(7, 5, '2021-03-21', 'alu , si 1 , kjsadhniiaskdn', 'lkjasdkjnid', 500000, 0, '2021-03-21 12:29:41', '2021-03-21 12:29:41'),
(8, 5, '2021-03-22', 'kgnb', 'kighkjgh', 100000, 0, '2021-03-21 12:30:06', '2021-03-21 12:30:06'),
(9, 5, '2021-03-18', 'fdhtd cuiyhkjhkjh', 'fgjhtyg', 100000, 0, '2021-03-21 13:26:06', '2021-03-21 13:26:06'),
(10, 7, '2021-03-20', '2 days Vehicle Gas', NULL, 1735, 0, '2021-03-22 12:20:13', '2021-03-22 12:20:13'),
(11, 8, '2021-03-20', 'Office Mobile Recharge', 'Imtiaj', 100, 0, '2021-03-22 12:25:49', '2021-03-22 12:25:49'),
(12, 9, '2021-05-07', 'ছাত্রদের নিজস্ব কর্তব্য আছে। নিজেদের প্রতি, পিতামাতার প্রতি, আত্মীয়-স্বজনের প্রতি, দেশের প্রতি এবং সামগ্রিকভাবে সমাজের প্রতি তাদের কর্তব্য আছে। ছাত্রজীবন হলো জীবনের বীজ বপনের সময়। সেজন্য একজন ছাত্রের উচিত তার স্বাস্থ্য গঠণ করা, ভালো অভ্যাস গড়ে তোলা এবং ভালো ব্যবহার করা। জীবনে ভালো এবং বড়ো হওয়ার নিশ্চিত পথগুলির অন্যতম পথ হলো পিতামাতা ও শিক্ষকের প্রতি অকৃত্রিম শ্রদ্ধা ও ভালোবাসা পোষণ করা এবং মহাপুরুষদের জীবনী পাঠ করা।', 'ছাত্রদের নিজস্ব কর্তব্য আছে। নিজেদের প্রতি, পিতামাতার প্রতি, আত্মীয়-স্বজনের প্রতি, দেশের প্রতি এবং সামগ্রিকভাবে সমাজের প্রতি তাদের কর্তব্য আছে। ছাত্রজীবন হলো জীবনের বীজ বপনের সময়। সেজন্য একজন ছাত্রের উচিত তার স্বাস্থ্য গঠণ করা, ভালো অভ্যাস গড়ে তোলা এবং ভালো ব্যবহার করা। জীবনে ভালো এবং বড়ো হওয়ার নিশ্চিত পথগুলির অন্যতম পথ হলো পিতামাতা ও শিক্ষকের প্রতি অকৃত্রিম শ্রদ্ধা ও ভালোবাসা পোষণ করা এবং মহাপুরুষদের জীবনী পাঠ করা।', 10000, 0, '2021-05-07 15:30:07', '2021-05-07 15:30:07'),
(13, 2, '2021-05-01', 'rabbani sir', NULL, 5200, 0, '2021-05-31 13:18:59', '2021-05-31 13:18:59'),
(14, 2, '2021-05-02', 'rahat sir', 'project visit', 895, 0, '2021-05-31 13:19:47', '2021-05-31 13:19:47'),
(15, 2, '2021-05-04', 'ahmmed sir', 'office', 2321, 0, '2021-05-31 13:20:25', '2021-05-31 13:20:25'),
(16, 2, '2021-05-15', 'chairman sir', 'gulshan office', 1720, 0, '2021-05-31 13:21:26', '2021-05-31 13:21:26'),
(17, 11, '2021-06-07', NULL, NULL, 375000, 0, '2021-06-07 13:31:13', '2021-06-07 13:31:13'),
(18, 5, '2021-06-21', 'fsdf', 'sfs', 700, 0, '2021-06-21 05:35:31', '2021-06-21 05:35:31');

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

--
-- Table structure for table `expence_heads`
--

CREATE TABLE `expence_heads` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `isDelete` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `expence_heads`
--

INSERT INTO `expence_heads` (`id`, `name`, `slug`, `isDelete`, `created_at`, `updated_at`) VALUES
(13, 'Hermione Granger', 'hermione-granger', 1, '2021-06-21 12:07:35', '2021-06-21 12:07:40'),
(4, 'Land purchaseew', 'land-purchaseew', 0, '2021-03-11 15:53:30', '2021-06-21 12:07:48'),
(5, 'Comission', 'comission', 0, '2021-03-21 12:28:28', '2021-03-21 12:28:28'),
(6, 'interest', 'interest', 0, '2021-03-21 13:25:40', '2021-03-21 13:25:40'),
(7, 'Vechile Gas', 'vechile-gas', 0, '2021-03-22 12:18:06', '2021-03-22 12:18:06'),
(8, 'Office Mobile Bill', 'office-mobile-bill', 0, '2021-03-22 12:24:23', '2021-03-22 12:24:23'),
(10, 'Land Purchase', 'land-purchase', 0, '2021-06-07 10:53:25', '2021-06-07 10:53:25'),
(11, 'Land Purchase File No. 19 Investor name: Ahmed Loan - 500000', 'land-purchase-file-no-19-investor-name-ahmed-loan-500000', 0, '2021-06-07 13:30:42', '2021-06-07 13:30:42'),
(12, 'Land Purchase File No. 19 Marketer Commission - 62500', 'land-purchase-file-no-19-marketer-commission-62500', 0, '2021-06-07 13:33:09', '2021-06-07 13:33:09');

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

--
-- Table structure for table `incomes`
--

CREATE TABLE `incomes` (
  `id` int(11) NOT NULL,
  `income_head_id` int(11) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `description` text DEFAULT NULL,
  `note` text DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `isDelete` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `incomes`
--

INSERT INTO `incomes` (`id`, `income_head_id`, `date`, `description`, `note`, `amount`, `isDelete`, `created_at`, `updated_at`) VALUES
(3, 1, '2021-06-21', 'fdf', 'sfsdf', 50000, 0, '2021-06-21 11:34:01', '2021-06-21 11:34:01');

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

--
-- Table structure for table `income_heads`
--

CREATE TABLE `income_heads` (
  `id` int(11) NOT NULL,
  `name` text DEFAULT NULL,
  `slug` text DEFAULT NULL,
  `isDelete` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `income_heads`
--

INSERT INTO `income_heads` (`id`, `name`, `slug`, `isDelete`, `created_at`, `updated_at`) VALUES
(1, 'The vinchi', 'the-vinchi', 0, '2021-06-21 10:09:35', '2021-06-21 10:09:35'),
(2, 'asas', 'asas', 1, '2021-06-21 10:09:41', '2021-06-21 10:14:56'),
(3, 'Demon Salvator', 'demon-salvator', 1, '2021-06-21 17:56:25', '2021-06-21 18:07:10'),
(4, 'The vinchi', 'the-vinchi', 1, '2021-06-21 18:08:29', '2021-06-21 18:08:36'),
(5, 'Hermione Granger', 'hermione-granger', 0, '2021-06-21 18:08:39', '2021-06-21 18:08:39');

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

--
-- Table structure for table `installments`
--

CREATE TABLE `installments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `member_id` int(10) UNSIGNED NOT NULL,
  `serial_id` int(11) DEFAULT NULL,
  `reference_id` int(11) NOT NULL,
  `sales_id` int(10) UNSIGNED NOT NULL,
  `amount` double DEFAULT NULL,
  `company_log` double UNSIGNED DEFAULT NULL,
  `refference_log` double UNSIGNED DEFAULT NULL,
  `due` double DEFAULT NULL,
  `date` date DEFAULT NULL,
  `ins_no` int(11) DEFAULT NULL,
  `remark` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `money_rec` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `isDelete` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `installments`
--

INSERT INTO `installments` (`id`, `member_id`, `serial_id`, `reference_id`, `sales_id`, `amount`, `company_log`, `refference_log`, `due`, `date`, `ins_no`, `remark`, `money_rec`, `isDelete`, `status`, `created_at`, `updated_at`) VALUES
(167, 44, 1, 29, 107, 9000, 9000, NULL, 928000, '2021-06-21', 1, 'installment no 1', '11111', NULL, NULL, '2021-06-20 14:11:14', '2021-06-20 14:11:14');

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

--
-- Table structure for table `land_purchases`
--

CREATE TABLE `land_purchases` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `date` timestamp NULL DEFAULT NULL,
  `owner_name` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reference_name` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reference_file_no` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dolil_no` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rs_dag` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `land_poriman` double DEFAULT NULL,
  `commision_percentage` double DEFAULT NULL,
  `investor_name` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `investor_number` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `investor_total_invest` double DEFAULT NULL,
  `total_commision` double DEFAULT NULL,
  `investor_interest` double DEFAULT NULL,
  `investor_total_interest` double DEFAULT NULL,
  `registri_amount` double DEFAULT NULL,
  `total_fee` double DEFAULT NULL,
  `details` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shotok_price` double DEFAULT NULL,
  `total_price` double DEFAULT NULL,
  `paid_amount` double DEFAULT NULL,
  `deu_amount` double DEFAULT NULL,
  `ledger` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `land_purchases`
--

INSERT INTO `land_purchases` (`id`, `date`, `owner_name`, `reference_name`, `reference_file_no`, `dolil_no`, `rs_dag`, `land_poriman`, `commision_percentage`, `investor_name`, `investor_number`, `investor_total_invest`, `total_commision`, `investor_interest`, `investor_total_interest`, `registri_amount`, `total_fee`, `details`, `shotok_price`, `total_price`, `paid_amount`, `deu_amount`, `ledger`, `status`, `created_at`, `updated_at`) VALUES
(8, '2021-05-26 04:00:00', 'Anik', 'Das', '11', '77', '124', 10, 5, 'RRf', '1223455', 50, 50, 5, 83.33333333333334, 100, 263.33333333333337, 'No details', 3, 30, 40, 223.33333333333337, 'aaa', NULL, '2021-05-26 15:29:48', '2021-05-26 15:29:48'),
(7, '2021-05-10 04:00:00', 'Angel', 'tA', '11', '44', '124', 10, 5, 'RR', '1223455', 50, 50, 5, 83.33333333333334, 100, 263.33333333333337, 'No details', 3, 30, 40, 223.33333333333337, 'aaa', NULL, '2021-05-10 12:21:50', '2021-05-10 12:22:37'),
(9, '2021-06-02 04:00:00', 'aVX RRR 555', 'aVX RRR 555', 'aVX RRR 555', 'aVX RRR 555', 'aVX RRR 555 aVX RRR 555 aVX RRR 555', 10, 5, 'aVX RRR 555', 'aVX RRR 555', 50, 50, 5, 83.33333333333334, 100, 263.33333333333337, 'aVX RRR 555 aVX RRR 555aVX RRR 555', 3, 30, 40, 223.33333333333337, 'aVX RRR 555', NULL, '2021-06-02 10:53:13', '2021-06-02 10:53:13'),
(10, '2021-06-03 04:00:00', 'Rokon', 'Sahjalal', '12', 'D5667 দেশে', '#নয়াদিল্লি: দেশে করোনা সংক্রমণে আশার খবর। বেশ কয়েকদিন ধরে লাগাতার কমতে থাকা সংক্রমণ অব্যাহত থাকল শনিবারও। গত ২৪ ঘণ্টায় দেশে নতুন করে করোনাভাইরাসে (India Coronavirus Update) আক্রান্ত হয়েছেন ১.১৪ লক্ষ মানুষ। একদিনে মৃত্যু হয়েছে ২,৬৬৭ জনের। কেন্দ্রীয় স্বাস্থ্যমন্ত্রক সূত্রে খবর, এখনও পর্যন্ত দেশে মোট করোনা আক্রান্তের সংখ্যা ২.৮৮ কোটি। দেশে করোনায় মৃত্যু হয়েছে ৩.৪৬ লক্ষ মানুষের। শনিবার প্রায় ২০ লক্ষ মানুষের করোনা পরীক্ষা করা হয়েছে। এই নিয়ে দেশে এখনও পর্যন্ত করোনা পরীক্ষা হয়েছে ৩৬,৪৭,৪৬,৫২২ জনের', 12.56, 4500, 'ahmed-50000 | Forkan-300000', '01919774996', 500000, 56520, 5000, 20833.333333333336, 34000, 1618553.3333333333, '#নয়াদিল্লি: দেশে করোনা সংক্রমণে আশার খবর। বেশ কয়েকদিন ধরে লাগাতার কমতে থাকা সংক্রমণ অব্যাহত থাকল শনিবারও। গত ২৪ ঘণ্টায় দেশে নতুন করে করোনাভাইরাসে (India Coronavirus Update) আক্রান্ত হয়েছেন ১.১৪ লক্ষ মানুষ। একদিনে মৃত্যু হয়েছে ২,৬৬৭ জনের। কেন্দ্রীয় স্বাস্থ্যমন্ত্রক সূত্রে খবর, এখনও পর্যন্ত দেশে মোট করোনা আক্রান্তের সংখ্যা ২.৮৮ কোটি। দেশে করোনায় মৃত্যু হয়েছে ৩.৪৬ লক্ষ মানুষের। শনিবার প্রায় ২০ লক্ষ মানুষের করোনা পরীক্ষা করা হয়েছে। এই নিয়ে দেশে এখনও পর্যন্ত করোনা পরীক্ষা হয়েছে ৩৬,৪৭,৪৬,৫২২ জনের', 120000, 1507200, 1618533, 20.333333333255723, 'দেশে করোনা সংক্রমণে আশার খ', NULL, '2021-06-06 11:56:14', '2021-06-07 13:36:15'),
(11, '2021-06-07 04:00:00', 'Ali Akbar', 'Masum Billah', '19', '3436', '313', 12.5, 5000, 'Ahmmad Ali', '01712869532', 2375000, 62500, 5000, 62500, 56000, 2556000, 'Jomir Mullo Puratai Dewa Hoiche. Ahammad Ali sir Ar loan Porishod kora hoini.', 190000, 2375000, 2375000, 181000, '686', NULL, '2021-06-06 14:44:50', '2021-06-07 13:23:06');

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

--
-- Table structure for table `members`
--

CREATE TABLE `members` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `hus_father` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nationality` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `birthday` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mother` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `profession` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `religion` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `present_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `permanent_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `picture` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `signature_image` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `serial_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reference_id` int(10) UNSIGNED NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `members`
--

INSERT INTO `members` (`id`, `name`, `hus_father`, `nationality`, `birthday`, `mother`, `profession`, `religion`, `present_address`, `permanent_address`, `mobile`, `nid`, `email`, `created_at`, `updated_at`, `picture`, `signature_image`, `serial_id`, `reference_id`, `password`) VALUES
(44, 'Harry Potter', 'Potter', 'American', '2021-06-21', 'Potter', 'Wizard', 'christian', 'Hogwarts', 'Hogwarts', '55876685765', '45353535352', 'harry@gmail.com', '2021-06-20 13:53:58', '2021-06-20 13:53:58', 'members/KqclcchaP5flZuGI16KEvpW3W96q85AChH0Hixt2.jpeg', 'members/dvI2Uw5o9x2li6IEnhkzVBu01hdRL5RKSCaD4GtG.png', '000001', 29, '123456');

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2020_01_31_143519_create_land_purchases_table', 1),
(4, '2020_01_31_162552_create_members_table', 1),
(5, '2020_01_31_190024_create_baynas_table', 1),
(6, '2020_01_31_192032_create_plots_table', 1),
(7, '2020_02_01_065631_create_banks_table', 1),
(8, '2020_02_01_072110_create_deposits_table', 1),
(9, '2020_02_01_082138_add_picture_to_member_table', 1),
(10, '2020_02_01_103646_create_references_table', 1),
(11, '2020_02_01_174219_create_nominees_table', 1),
(12, '2020_02_02_151623_add_role_to_table_users', 1),
(13, '2020_02_02_164945_create_expence_heads_table', 1),
(14, '2020_02_02_165029_create_expences_table', 1),
(15, '2020_02_04_151412_create_sales_table', 1),
(16, '2020_02_04_154015_add_serial_id_to_members_table', 1),
(17, '2020_02_21_045445_create_sub_memebers_table', 1),
(18, '2020_02_21_062807_create_installments_table', 1),
(19, '2020_02_21_080045_add_reference_id_to_members_table', 1),
(20, '2020_02_22_054809_add_amount_to_references_table', 1),
(21, '2020_02_22_061714_create_reference_incomes_table', 1),
(22, '2020_02_22_064256_create_reference_withdraws_table', 1),
(23, '2020_02_25_145851_create_companies_table', 1),
(24, '2020_02_28_153109_create_purchase_installments_table', 1),
(25, '2020_02_28_181508_create_bank_withdraws_table', 1);

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

--
-- Table structure for table `nominees`
--

CREATE TABLE `nominees` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `hus_father` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `religion` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nationality` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `picture` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `member_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `saled_id` int(11) DEFAULT NULL,
  `relation` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `birthday` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `nominees`
--

INSERT INTO `nominees` (`id`, `name`, `hus_father`, `address`, `religion`, `nationality`, `nid`, `picture`, `member_id`, `saled_id`, `relation`, `birthday`, `status`, `created_at`, `updated_at`) VALUES
(13, 'Ron Weasly', 'Weasly', 'Hogwarts', 'christian', 'American', '77777777777', 'nominees/q1yK7C07v3ET2soBIF9cOu0ap9tA2A5rD04dHwXj.jpeg', '44', NULL, 'brother', '2021-06-21', NULL, '2021-06-20 14:14:11', '2021-06-20 14:14:47');

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

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `plots`
--

CREATE TABLE `plots` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `plot_size` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `block` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `block_id` int(11) NOT NULL,
  `road` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `face` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `plots`
--

INSERT INTO `plots` (`id`, `plot_size`, `block`, `block_id`, `road`, `face`, `quantity`, `status`, `created_at`, `updated_at`) VALUES
(20, '10', 'Block A', 15, '5', 'north', '49', 0, '2021-06-20 13:57:21', '2021-06-20 13:58:28');

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

--
-- Table structure for table `purchase_installments`
--

CREATE TABLE `purchase_installments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `land_purchase_id` int(10) UNSIGNED NOT NULL,
  `date` date NOT NULL,
  `amount` double NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `purchase_installments`
--

INSERT INTO `purchase_installments` (`id`, `land_purchase_id`, `date`, `amount`, `created_at`, `updated_at`) VALUES
(5, 7, '2021-05-10', 100, '2021-05-10 12:22:13', '2021-05-10 12:22:13');

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

--
-- Table structure for table `references`
--

CREATE TABLE `references` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `father_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mother_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dob` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `profession` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `present_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `permanent_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `religion` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `signature_image` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `booking_amount` double NOT NULL,
  `installment_amount` double NOT NULL,
  `ekkalin_amount` double NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `references`
--

INSERT INTO `references` (`id`, `name`, `father_name`, `mother_name`, `nid`, `dob`, `email`, `profession`, `present_address`, `permanent_address`, `mobile`, `religion`, `image`, `signature_image`, `status`, `created_at`, `updated_at`, `amount`, `booking_amount`, `installment_amount`, `ekkalin_amount`, `password`) VALUES
(29, 'Tom Riddle', 'Riddle', 'Riddle', '33333333', '2021-06-21', 'tom@gmail.com', 'Wizard', 'Hogwarts', 'Hogwarts', '33333333333333', 'muslim', 'members/hjKd3PvQo01LevRc4IlqsDfzkZgE0mAbkNSeJtHA.jpeg', 'members/LLkwdIy5Rd9Q9aFhXX4n6G7JJYIMqfamtKZGyEyb.jpeg', 0, '2021-06-20 13:50:52', '2021-06-20 13:59:11', NULL, 0, 0, 0, '123456');

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

--
-- Table structure for table `reference_incomes`
--

CREATE TABLE `reference_incomes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `member_id` int(10) UNSIGNED NOT NULL,
  `reference_id` int(10) UNSIGNED NOT NULL,
  `sell_id` int(11) DEFAULT NULL,
  `intall_id` int(11) DEFAULT NULL,
  `paid_amount` double DEFAULT NULL,
  `installment_amount` double DEFAULT NULL,
  `block_id` int(11) NOT NULL,
  `block_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `plot_size` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `face` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `road` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `katha` double NOT NULL,
  `booking_amount` double NOT NULL,
  `installment_per_amount` double NOT NULL,
  `ekkalin_per_amount` double NOT NULL,
  `amount` double DEFAULT NULL,
  `rest_amount` double DEFAULT NULL,
  `status` int(11) NOT NULL,
  `status_d` int(11) DEFAULT NULL,
  `isDelete` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `reference_incomes`
--

INSERT INTO `reference_incomes` (`id`, `member_id`, `reference_id`, `sell_id`, `intall_id`, `paid_amount`, `installment_amount`, `block_id`, `block_name`, `plot_size`, `face`, `road`, `katha`, `booking_amount`, `installment_per_amount`, `ekkalin_per_amount`, `amount`, `rest_amount`, `status`, `status_d`, `isDelete`, `created_at`, `updated_at`) VALUES
(271, 44, 29, 107, 167, NULL, 9000, 15, 'Block A', '10', 'north', '5', 5, 100000, 20, 40, 1800, 1800, 3, NULL, 0, '2021-06-20 14:11:14', '2021-06-20 14:11:14'),
(270, 44, 29, 107, NULL, 60000, 93700, 15, 'Block A', '10', 'north', '5', 5, 100000, 20, 40, 500000, 500000, 2, NULL, 0, '2021-06-20 13:58:28', '2021-06-20 13:58:28');

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

--
-- Table structure for table `reference_withdraws`
--

CREATE TABLE `reference_withdraws` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `reference_id` int(10) UNSIGNED NOT NULL,
  `member_id` int(11) DEFAULT NULL,
  `income_id` int(11) NOT NULL,
  `sell_id` int(11) DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sales`
--

CREATE TABLE `sales` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `plot_id` int(10) UNSIGNED NOT NULL,
  `plot_no` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rate_per` double DEFAULT NULL,
  `total_rate` double DEFAULT NULL,
  `block_id` int(11) DEFAULT NULL,
  `member_id` int(10) UNSIGNED NOT NULL,
  `nominee_id` int(11) DEFAULT NULL,
  `serial_id` int(11) DEFAULT NULL,
  `installment` int(11) DEFAULT NULL,
  `installment_amount` double DEFAULT NULL,
  `due_amount` double DEFAULT NULL,
  `paid` double DEFAULT NULL,
  `discount` double DEFAULT NULL,
  `date` date DEFAULT NULL,
  `remark` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sale_no` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `money_rec` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `reference_id` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sales`
--

INSERT INTO `sales` (`id`, `plot_id`, `plot_no`, `rate_per`, `total_rate`, `block_id`, `member_id`, `nominee_id`, `serial_id`, `installment`, `installment_amount`, `due_amount`, `paid`, `discount`, `date`, `remark`, `sale_no`, `status`, `money_rec`, `created_at`, `updated_at`, `reference_id`) VALUES
(107, 20, '121212', 100000, 1000000, 15, 44, 13, 1, 10, 93700, 937000, 60000, 3000, '2021-06-21', 'Due', 1, 0, '4545', '2021-06-20 13:58:28', '2021-06-20 14:14:47', 29);

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

--
-- Table structure for table `sale_details`
--

CREATE TABLE `sale_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `sales_id` int(10) UNSIGNED NOT NULL,
  `refference_id` int(11) NOT NULL,
  `refference_name` text NOT NULL,
  `plot_id` int(10) UNSIGNED NOT NULL,
  `member_id` int(10) UNSIGNED NOT NULL,
  `installment` int(11) DEFAULT NULL,
  `installment_amount` double DEFAULT NULL,
  `due_amount` double DEFAULT NULL,
  `total_rate` double DEFAULT NULL,
  `paid` double DEFAULT NULL,
  `discount` int(11) DEFAULT NULL,
  `date` date NOT NULL,
  `company_log` double UNSIGNED DEFAULT NULL,
  `refference_log` double UNSIGNED DEFAULT NULL,
  `booking_amount` double DEFAULT NULL,
  `install_amount` double DEFAULT NULL,
  `ekkalin_amount` double DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `sale_details`
--

INSERT INTO `sale_details` (`id`, `sales_id`, `refference_id`, `refference_name`, `plot_id`, `member_id`, `installment`, `installment_amount`, `due_amount`, `total_rate`, `paid`, `discount`, `date`, `company_log`, `refference_log`, `booking_amount`, `install_amount`, `ekkalin_amount`, `status`, `created_at`, `updated_at`) VALUES
(111, 107, 29, 'Tom Riddle', 20, 44, 9, 93700, 931000, 1000000, 69000, 3000, '2021-06-21', 69000, NULL, 100000, 20, 40, NULL, '2021-06-20 13:58:28', '2021-06-20 14:11:14');

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

--
-- Table structure for table `sub_memebers`
--

CREATE TABLE `sub_memebers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `member_id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `hus_father` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nationality` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `birthday` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mother` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `profession` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `religion` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `present_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `permanent_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `picture` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `serial_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `role` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'user'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `password`, `remember_token`, `created_at`, `updated_at`, `role`) VALUES
(2, 'Ahmed Ali', 'ahmed@gmail.com', '$2y$10$fRsqK12OuxD4d6sSeGo4tOK72PnfDoA6UqNKSs0TfvdzreqPr2r8y', NULL, '2020-12-07 06:57:11', '2020-12-07 06:57:11', 'user'),
(3, 'Mohammed Ali', 'dreamgreencity@gmail.com', '$2y$10$amB6wUk2iBRu2o.NsY59PuyfDtcisjy0WqYzp3N8iv7bZ6cx0UtHe', NULL, '2020-12-12 13:36:08', '2020-12-12 13:36:08', 'user'),
(4, 'Nizam', 'nizamlata1982@gmail.com', '$2y$10$Pb5LkqBMKfr/5nWkxwlgruJGsQUMUs1ve/lo./A4ThCG0zSoUxKla', NULL, '2021-01-14 13:27:06', '2021-01-14 13:27:06', 'user'),
(5, 'Rahat', 'mdrahat@gmail.com', '$2y$10$winlzMKkUV6icA4jKh3KQeX92ic1gJ5WGHA8VGWoMsUXiCoZf18QG', NULL, '2021-05-25 13:04:13', '2021-05-25 13:04:13', 'user');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `accounts`
--
ALTER TABLE `accounts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=108;

--
-- AUTO_INCREMENT for table `banks`
--
ALTER TABLE `banks`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `bank_withdraws`
--
ALTER TABLE `bank_withdraws`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `baynas`
--
ALTER TABLE `baynas`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `blocks`
--
ALTER TABLE `blocks`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `booking_forms`
--
ALTER TABLE `booking_forms`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `commision_plans`
--
ALTER TABLE `commision_plans`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;

--
-- AUTO_INCREMENT for table `companies`
--
ALTER TABLE `companies`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `custom_installments`
--
ALTER TABLE `custom_installments`
  MODIFY `id` bigint(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `demo_installments`
--
ALTER TABLE `demo_installments`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;

--
-- AUTO_INCREMENT for table `deposits`
--
ALTER TABLE `deposits`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `expences`
--
ALTER TABLE `expences`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `expence_heads`
--
ALTER TABLE `expence_heads`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `incomes`
--
ALTER TABLE `incomes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `income_heads`
--
ALTER TABLE `income_heads`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `installments`
--
ALTER TABLE `installments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=168;

--
-- AUTO_INCREMENT for table `land_purchases`
--
ALTER TABLE `land_purchases`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `members`
--
ALTER TABLE `members`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45;

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

--
-- AUTO_INCREMENT for table `nominees`
--
ALTER TABLE `nominees`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `plots`
--
ALTER TABLE `plots`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `purchase_installments`
--
ALTER TABLE `purchase_installments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `references`
--
ALTER TABLE `references`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `reference_incomes`
--
ALTER TABLE `reference_incomes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=272;

--
-- AUTO_INCREMENT for table `reference_withdraws`
--
ALTER TABLE `reference_withdraws`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=85;

--
-- AUTO_INCREMENT for table `sales`
--
ALTER TABLE `sales`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=108;

--
-- AUTO_INCREMENT for table `sale_details`
--
ALTER TABLE `sale_details`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=112;

--
-- AUTO_INCREMENT for table `sub_memebers`
--
ALTER TABLE `sub_memebers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;