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

START TRANSACTION;



--
-- Database: `resort`
--

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

--
-- Table structure for table `account_table`
--

CREATE TABLE `account_table` (
  `account_id` int(11) NOT NULL,
  `inv_no` varchar(50) DEFAULT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `contractor_id` int(11) DEFAULT NULL,
  `employee_id` int(11) DEFAULT NULL,
  `landowner_id` int(11) DEFAULT NULL,
  `broker_id` int(11) DEFAULT NULL,
  `give_type` varchar(50) DEFAULT NULL,
  `project_id` int(11) DEFAULT NULL,
  `flat_no` varchar(20) DEFAULT NULL,
  `cat_id` int(11) DEFAULT NULL,
  `reference_name` varchar(100) DEFAULT NULL,
  `payment_date` varchar(15) DEFAULT NULL,
  `mr_no` int(11) DEFAULT NULL,
  `cheque_id` int(11) DEFAULT NULL,
  `customer_cheque_no` varchar(20) DEFAULT NULL,
  `cheque_date` varchar(15) DEFAULT NULL,
  `bank_id` tinyint(4) DEFAULT NULL,
  `bank_name2` varchar(250) DEFAULT NULL,
  `branch_name` varchar(50) DEFAULT NULL,
  `pay_amount` decimal(11,2) DEFAULT NULL,
  `description` varchar(300) DEFAULT NULL,
  `remarks` varchar(500) DEFAULT NULL,
  `unit_price` int(11) DEFAULT NULL,
  `days` smallint(6) DEFAULT NULL,
  `payment_type` enum('R','P') DEFAULT NULL,
  `con_type_payment` varchar(50) NOT NULL DEFAULT 'Normal',
  `cheque_type` varchar(15) NOT NULL DEFAULT 'NEW' COMMENT 'NEW, USED',
  `installment_no` varchar(50) DEFAULT NULL,
  `cheque_no` varchar(20) DEFAULT NULL,
  `employee_name` varchar(500) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `account_table`
--

INSERT INTO `account_table` (`account_id`, `inv_no`, `customer_id`, `supplier_id`, `contractor_id`, `employee_id`, `landowner_id`, `broker_id`, `give_type`, `project_id`, `flat_no`, `cat_id`, `reference_name`, `payment_date`, `mr_no`, `cheque_id`, `customer_cheque_no`, `cheque_date`, `bank_id`, `bank_name2`, `branch_name`, `pay_amount`, `description`, `remarks`, `unit_price`, `days`, `payment_type`, `con_type_payment`, `cheque_type`, `installment_no`, `cheque_no`, `employee_name`, `user_id`) VALUES
(1, 'HLR#1', 8, NULL, NULL, NULL, NULL, NULL, 'CASH', 1, NULL, NULL, NULL, '2024-03-27', 0, NULL, NULL, NULL, NULL, NULL, NULL, '45000.00', 'Booking Money', 'Cash Received Md', NULL, NULL, 'R', 'Normal', 'NEW', '1', NULL, NULL, 1),
(2, 'HLR#2', 10, NULL, NULL, NULL, NULL, NULL, 'CASH', 1, NULL, NULL, NULL, '2024-04-06', 0, NULL, NULL, NULL, NULL, NULL, NULL, '30000.00', 'Downpayment', 'Cash Received By Md', NULL, NULL, 'R', 'Normal', 'NEW', 'Downpayment', NULL, NULL, 1),
(3, 'HLR#3', 6, NULL, NULL, NULL, NULL, NULL, 'BANK TRANSFER', 1, NULL, NULL, NULL, '2024-04-16', 0, NULL, NULL, NULL, NULL, 'Uttara Bank Ltd', NULL, '3000.00', 'Installment', 'Joarshara branch', NULL, NULL, 'R', 'Normal', 'NEW', '1', NULL, NULL, 1),
(4, 'HLR#4', 14, NULL, NULL, NULL, NULL, NULL, 'BANK DEPOSIT', 1, NULL, NULL, NULL, '2024-04-24', 0, NULL, NULL, NULL, NULL, NULL, NULL, '3000.00', 'Installment', 'Deposit Bank in uttara', NULL, NULL, 'R', 'Normal', 'NEW', '1', NULL, NULL, 1),
(5, 'HLR#5', 15, NULL, NULL, NULL, NULL, NULL, 'CASH', 1, NULL, NULL, NULL, '2024-04-27', 0, NULL, NULL, NULL, NULL, NULL, NULL, '50000.00', 'Downpayment', 'Cash Received Md', NULL, NULL, 'R', 'Normal', 'NEW', 'Downpayment', NULL, NULL, 1),
(6, 'HLR#6', 16, NULL, NULL, NULL, NULL, NULL, 'CASH', 1, NULL, NULL, NULL, '2024-04-27', 0, NULL, NULL, NULL, NULL, NULL, NULL, '50000.00', 'Downpayment', 'Csh Received Md', NULL, NULL, 'R', 'Normal', 'NEW', 'Downpayment', NULL, NULL, 1),
(7, 'HLR#7', 12, NULL, NULL, NULL, NULL, NULL, 'CASH', 1, NULL, NULL, NULL, '2024-04-28', 0, NULL, NULL, NULL, NULL, NULL, NULL, '20000.00', 'Booking Money', 'Cash Received md', NULL, NULL, 'R', 'Normal', 'NEW', '2', NULL, NULL, 1),
(8, 'HLR#8', 18, NULL, NULL, NULL, NULL, NULL, 'BANK DEPOSIT', 1, NULL, NULL, NULL, '2024-04-30', 0, NULL, NULL, NULL, NULL, NULL, NULL, '80000.00', 'Downpayment', 'Uttara Bank Ltd', NULL, NULL, 'R', 'Normal', 'NEW', 'Downpayment', NULL, NULL, 1),
(9, 'HLE#1', NULL, NULL, NULL, NULL, NULL, NULL, 'CASH', NULL, NULL, 1, '4745', '2024-04-30', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '4800.00', 'Comission', NULL, NULL, NULL, 'P', 'Normal', 'NEW', NULL, NULL, 'Nasrin', 1),
(10, 'HLR#9', 20, NULL, NULL, NULL, NULL, NULL, 'CASH', 1, NULL, NULL, NULL, '2024-05-05', 0, NULL, NULL, NULL, NULL, NULL, NULL, '10000.00', 'Downpayment', 'Cash Received', NULL, NULL, 'R', 'Normal', 'NEW', 'Downpayment', NULL, NULL, 1),
(11, 'HLR#10', 9, NULL, NULL, NULL, NULL, NULL, 'CASH', 1, NULL, NULL, NULL, '2024-05-05', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2000.00', 'Installment', 'Cash Received Md', NULL, NULL, 'R', 'Normal', 'NEW', '1', NULL, NULL, 1),
(12, 'HLR#11', 21, NULL, NULL, NULL, NULL, NULL, 'CASH', 1, NULL, NULL, NULL, '2024-05-05', 0, NULL, NULL, NULL, NULL, NULL, NULL, '95000.00', 'Downpayment', 'Cash received', NULL, NULL, 'R', 'Normal', 'NEW', 'Downpayment', NULL, NULL, 1),
(13, 'HLR#12', 22, NULL, NULL, NULL, NULL, NULL, 'CHEQUE', 1, NULL, NULL, NULL, '2024-05-07', 0, NULL, '8208332', '07/05/2024', NULL, 'Trust Bank Ltd', 'Madibdhi', '30000.00', 'Downpayment', 'Received', NULL, NULL, 'R', 'Normal', '0', 'Downpayment', NULL, NULL, 1),
(14, 'HLR#13', 19, NULL, NULL, NULL, NULL, NULL, 'CASH', 1, NULL, NULL, NULL, '2024-05-08', 0, NULL, NULL, NULL, NULL, NULL, NULL, '50000.00', 'Downpayment', 'Cash cheque', NULL, NULL, 'R', 'Normal', 'NEW', 'Downpayment', NULL, NULL, 1),
(15, 'HLR#14', 24, NULL, NULL, NULL, NULL, NULL, 'CASH', 1, NULL, NULL, NULL, '2024-05-10', 0, NULL, NULL, NULL, NULL, NULL, NULL, '5000.00', 'Installment', 'Cash Received MD', NULL, NULL, 'R', 'Normal', 'NEW', '1', NULL, NULL, 1);

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

--
-- Table structure for table `agreement_info`
--

CREATE TABLE `agreement_info` (
  `agreement_id` int(11) NOT NULL,
  `title_name` varchar(250) NOT NULL,
  `description` varchar(600) DEFAULT NULL,
  `file_name` varchar(250) DEFAULT NULL,
  `date` varchar(15) NOT NULL,
  `expire_date` varchar(20) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  `create_date` varchar(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `assetbuy`
--

CREATE TABLE `assetbuy` (
  `buy_id` int(11) NOT NULL,
  `buy_type` varchar(20) NOT NULL,
  `project_id` int(11) DEFAULT NULL,
  `purpose_name` varchar(250) DEFAULT NULL,
  `equipment_name` varchar(200) DEFAULT NULL,
  `buy_date` varchar(20) NOT NULL,
  `equipment_qty` int(11) DEFAULT NULL,
  `equipment_price` decimal(11,2) NOT NULL,
  `description` varchar(250) DEFAULT NULL,
  `give_type` varchar(20) DEFAULT NULL,
  `bank_id` int(11) DEFAULT NULL,
  `branch_name` varchar(100) DEFAULT NULL,
  `cheque_id` int(11) DEFAULT NULL,
  `cheque_date` varchar(20) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `asset_information`
--

CREATE TABLE `asset_information` (
  `asset_id` int(11) NOT NULL,
  `asset_type` enum('Office','Project') DEFAULT NULL,
  `project_id` int(11) DEFAULT NULL,
  `asset_name` varchar(200) DEFAULT NULL,
  `buy_date` varchar(15) DEFAULT NULL,
  `quantity` smallint(6) DEFAULT NULL,
  `price` decimal(11,2) DEFAULT NULL,
  `description` varchar(500) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `bank_information`
--

CREATE TABLE `bank_information` (
  `bank_id` tinyint(4) NOT NULL,
  `bank_name` varchar(200) DEFAULT NULL,
  `account_no` varchar(30) DEFAULT NULL,
  `account_name` varchar(50) DEFAULT NULL,
  `branch_name` varchar(50) DEFAULT NULL,
  `create_date` varchar(20) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `broker_information`
--

CREATE TABLE `broker_information` (
  `broker_id` int(11) NOT NULL,
  `broker_name` varchar(50) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `mobile_no` varchar(15) DEFAULT NULL,
  `email_id` varchar(50) DEFAULT NULL,
  `photo` varchar(150) DEFAULT NULL,
  `signature` varchar(100) DEFAULT NULL,
  `nid_no` varchar(25) DEFAULT NULL,
  `create_date` varchar(20) DEFAULT NULL,
  `project_id` int(11) NOT NULL,
  `broker_type` varchar(200) DEFAULT NULL,
  `pay_amount` decimal(11,2) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `broker_information`
--

INSERT INTO `broker_information` (`broker_id`, `broker_name`, `address`, `mobile_no`, `email_id`, `photo`, `signature`, `nid_no`, `create_date`, `project_id`, `broker_type`, `pay_amount`, `user_id`) VALUES
(1, 'Md', 'Barua', '01931313130', '', NULL, NULL, '5554764216', NULL, 1, '0', '0.00', 1),
(2, 'SM SHAMIM MIA', 'Barua', '01833833985', '', NULL, NULL, '0', NULL, 1, '0', '113600.00', 1),
(3, 'SM Nazim', 'Barua', '01833073662', '', NULL, NULL, '0', NULL, 1, '0', '103200.00', 1),
(4, 'Md.Mehedi Hasan', 'Jalokathi', '01321175544', '0', NULL, NULL, '0', NULL, 1, '0', '0.00', 1),
(5, 'Nasrin Akter Munni', 'barua', '01321175548', '', NULL, NULL, '0', NULL, 1, '0', '0.00', 1),
(6, 'Rokonuzzaman Nannu', 'Dhaka', '0', '', NULL, NULL, '', NULL, 1, '0', '0.00', 1),
(7, 'Md Sirajul Islam', 'Dhaka', '01321175547', '', NULL, NULL, '', NULL, 1, '0', '0.00', 1);

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

--
-- Table structure for table `broker_information_detail`
--

CREATE TABLE `broker_information_detail` (
  `id` int(11) NOT NULL,
  `broker_id` int(11) NOT NULL,
  `project_id` int(11) NOT NULL,
  `sele_type` varchar(50) DEFAULT NULL,
  `description` varchar(250) DEFAULT NULL,
  `amount` decimal(11,2) DEFAULT NULL,
  `create_date` varchar(20) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `broker_information_detail`
--

INSERT INTO `broker_information_detail` (`id`, `broker_id`, `project_id`, `sele_type`, `description`, `amount`, `create_date`, `user_id`) VALUES
(1, 3, 1, 'PLOT', 'File No-11', '34400.00', NULL, 1),
(2, 2, 1, 'PLOT', 'File No-8,9,10', '70400.00', NULL, 1),
(3, 3, 1, 'PLOT', 'File no-12,13', '68800.00', NULL, 1),
(4, 2, 1, 'PLOT', 'Commission File-14', '11200.00', NULL, 1),
(5, 2, 1, 'PLOT', 'File -20', '32000.00', NULL, 1);

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

--
-- Table structure for table `budget_cost`
--

CREATE TABLE `budget_cost` (
  `budget_cost_id` int(11) NOT NULL,
  `budget_cost_type` enum('Office','Project') DEFAULT NULL,
  `project_id` int(11) DEFAULT NULL,
  `name` varchar(200) DEFAULT NULL,
  `bc_date` varchar(15) DEFAULT NULL,
  `quantity` smallint(6) DEFAULT NULL,
  `budget_price` decimal(11,2) DEFAULT NULL,
  `actual_price` decimal(11,2) DEFAULT NULL,
  `description` varchar(500) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `cash_register`
--

CREATE TABLE `cash_register` (
  `register_id` int(11) NOT NULL,
  `register_no` varchar(30) NOT NULL,
  `register_date` varchar(15) NOT NULL,
  `purpose_id` tinyint(4) NOT NULL,
  `note` varchar(250) DEFAULT NULL,
  `total_amount` decimal(11,2) NOT NULL DEFAULT 0.00,
  `user_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `cash_register_detail`
--

CREATE TABLE `cash_register_detail` (
  `register_detail_id` int(11) NOT NULL,
  `register_id` int(11) NOT NULL,
  `description` varchar(150) NOT NULL,
  `amount` decimal(11,2) NOT NULL DEFAULT 0.00,
  `remark` varchar(200) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `cheque_book`
--

CREATE TABLE `cheque_book` (
  `cheque_id` int(11) NOT NULL,
  `bank_id` tinyint(4) NOT NULL,
  `book_no` tinyint(4) NOT NULL,
  `cheque_no` int(11) NOT NULL,
  `counts` tinyint(4) NOT NULL,
  `cheque_status` tinyint(4) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `company_info`
--

CREATE TABLE `company_info` (
  `id` bigint(20) NOT NULL,
  `company_name` varchar(50) DEFAULT NULL,
  `short_name` varchar(10) NOT NULL,
  `email_address` varchar(50) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `website` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `date_format` varchar(20) DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `create_date` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `company_info`
--

INSERT INTO `company_info` (`id`, `company_name`, `short_name`, `email_address`, `phone`, `website`, `address`, `date_format`, `logo`, `create_date`) VALUES
(1, 'Hadi Hotel and Resorts Ltd', 'HHRL', 'info@hadihotel.com', '01321175559', 'www.hadihotel.com', 'Bagan Bari,Barua,Khilkhet,Dhaka-1229', 'dd/mm/yyyy', 'hadihotel.jpg', '2017-12-25');

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

--
-- Table structure for table `contractor_detail`
--

CREATE TABLE `contractor_detail` (
  `contractor_detail_id` int(11) NOT NULL,
  `contractor_id` int(11) DEFAULT NULL,
  `cproduct_id` int(11) DEFAULT NULL,
  `project_id` int(11) DEFAULT NULL,
  `payment_amount` decimal(11,2) DEFAULT NULL,
  `comments` varchar(350) DEFAULT NULL,
  `bill_no` varchar(50) NOT NULL,
  `bill_date` varchar(15) NOT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `contractor_information`
--

CREATE TABLE `contractor_information` (
  `contractor_id` int(11) NOT NULL,
  `contractor_name` varchar(50) NOT NULL,
  `prop_name` varchar(100) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `mobile_no` varchar(15) DEFAULT NULL,
  `email_id` varchar(50) DEFAULT NULL,
  `photo` varchar(150) DEFAULT NULL,
  `signature` varchar(100) DEFAULT NULL,
  `contractor_type` varchar(100) DEFAULT NULL,
  `nid_no` varchar(25) DEFAULT NULL,
  `create_date` varchar(20) DEFAULT NULL,
  `contact_policy` varchar(500) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `contractor_product`
--

CREATE TABLE `contractor_product` (
  `cproduct_id` int(11) NOT NULL,
  `cproduct_name` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `customer_additional_cost`
--

CREATE TABLE `customer_additional_cost` (
  `id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `cost` int(11) NOT NULL,
  `detail` varchar(250) NOT NULL,
  `create_date` varchar(20) NOT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `customer_flat`
--

CREATE TABLE `customer_flat` (
  `id` int(11) NOT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `flat_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `customer_flat`
--

INSERT INTO `customer_flat` (`id`, `customer_id`, `flat_id`, `user_id`) VALUES
(1, 1, 1, 1),
(2, 2, 2, 1),
(5, 3, 3, 1),
(14, 5, 5, 1),
(15, 4, 4, 1),
(16, 6, 6, 1),
(22, 7, 7, 1),
(24, 8, 8, 1),
(25, 9, 9, 1),
(26, 10, 10, 1),
(29, 12, 12, 1),
(30, 11, 11, 1),
(32, 13, 13, 1),
(35, 14, 14, 1),
(36, 15, 15, 1),
(37, 16, 16, 1),
(39, 17, 17, 1),
(41, 18, 18, 1),
(44, 20, 20, 1),
(50, 19, 19, 1),
(52, 21, 21, 1),
(53, 22, 22, 1),
(54, 23, 23, 1),
(55, 24, 24, 1),
(57, 25, 25, 1);

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

--
-- Table structure for table `customer_information`
--

CREATE TABLE `customer_information` (
  `customer_id` int(11) NOT NULL,
  `broker_id` int(11) DEFAULT 0,
  `gender` varchar(20) NOT NULL DEFAULT 'Male',
  `customer_name` varchar(50) DEFAULT NULL,
  `booking_type` varchar(50) NOT NULL DEFAULT 'Single',
  `other_name` varchar(600) DEFAULT NULL,
  `customer_no` varchar(20) NOT NULL,
  `file_no` varchar(50) DEFAULT NULL,
  `nominee` varchar(200) NOT NULL,
  `date_of_birth` varchar(20) DEFAULT NULL,
  `father_name` varchar(100) DEFAULT NULL,
  `mother_name` varchar(100) DEFAULT NULL,
  `occupation` varchar(100) DEFAULT NULL,
  `nominee_relation` varchar(200) DEFAULT NULL,
  `customer_type` enum('Regular','Default') NOT NULL DEFAULT 'Regular',
  `address` varchar(200) DEFAULT NULL,
  `mobile_no` varchar(15) DEFAULT NULL,
  `email_id` varchar(50) DEFAULT NULL,
  `photo` varchar(150) DEFAULT NULL,
  `signature` varchar(100) DEFAULT NULL,
  `reference_by` varchar(100) DEFAULT NULL,
  `nid_no` varchar(25) DEFAULT NULL,
  `booking_date` varchar(20) NOT NULL,
  `create_date` varchar(20) DEFAULT NULL,
  `late_payment_policy` varchar(500) DEFAULT NULL,
  `project_id` int(11) DEFAULT NULL,
  `flat_no` varchar(50) DEFAULT NULL,
  `total_value` decimal(14,2) DEFAULT NULL,
  `down_payment` decimal(11,2) NOT NULL DEFAULT 0.00,
  `return_value` decimal(11,2) DEFAULT NULL,
  `return_parcent` int(11) NOT NULL DEFAULT 0,
  `tatal_installment` smallint(6) DEFAULT NULL,
  `installment_date` smallint(6) DEFAULT NULL,
  `installment_start_date` varchar(20) DEFAULT NULL,
  `installment_value` decimal(10,2) DEFAULT NULL,
  `share_number` tinyint(4) NOT NULL DEFAULT 1,
  `mouza_name` varchar(50) DEFAULT NULL,
  `attachment` varchar(200) DEFAULT NULL,
  `note` varchar(1500) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `customer_information`
--

INSERT INTO `customer_information` (`customer_id`, `broker_id`, `gender`, `customer_name`, `booking_type`, `other_name`, `customer_no`, `file_no`, `nominee`, `date_of_birth`, `father_name`, `mother_name`, `occupation`, `nominee_relation`, `customer_type`, `address`, `mobile_no`, `email_id`, `photo`, `signature`, `reference_by`, `nid_no`, `booking_date`, `create_date`, `late_payment_policy`, `project_id`, `flat_no`, `total_value`, `down_payment`, `return_value`, `return_parcent`, `tatal_installment`, `installment_date`, `installment_start_date`, `installment_value`, `share_number`, `mouza_name`, `attachment`, `note`, `user_id`) VALUES
(1, 1, 'Male', 'Hadi misron Mills', 'Single', NULL, '001', 'F-1', 'Juthi Akter', '1994-11-27', 'Fazlul haque', 'Rina Akter', 'Business', 'Wife', 'Regular', 'Bagan Bari,Barua,Khilkhet Dhaka-1229', '01931313130', '', NULL, NULL, 'Md', '5554764216', '2024-03-24', NULL, 'No', 1, NULL, '400000.00', '80000.00', NULL, 90, 36, 1, '', '9000.00', 1, NULL, NULL, ' No', 1),
(2, 1, 'Female', 'Evana Haque Mousumi', 'Single', NULL, '002', 'F-2', 'Nazim Mia', '1990-12-02', 'S.S Monzurul Haque', 'Ayesha Haque', 'Job', 'Husbend', 'Regular', 'Barua(Grameen Bank)Khilkhet Dhaka', '01858585781', '', NULL, NULL, 'Md', '5554764216', '2024-03-24', NULL, 'No', 1, NULL, '360000.00', '0.00', NULL, 90, 36, 10, '2024-05-01', '10000.00', 1, NULL, NULL, ' No', 1),
(3, 1, 'Male', 'Md.Rokonuzzaman', 'Single', NULL, '003', 'F-3', 'Afrin Akter', '1976-07-07', 'Md.Samsuddin Biswas', 'Rabaya khatun', 'Job', 'Wife', 'Regular', 'Bahaldanga,Tama Pangsa', '01935113497', '', NULL, NULL, 'Md', '00', '2024-03-27', NULL, 'No', 1, NULL, '360000.00', '0.00', NULL, 90, 36, 10, '2024-05-01', '10000.00', 1, NULL, NULL, ' pacage-02', 1),
(4, 1, 'Male', 'Md.Mehede Hasan Gazi', 'Single', NULL, '004', 'F-4', 'Md.Shahudul Islam Gazi', '1993-12-27', 'Md.Shahidul Islam Gazi', 'Mst.Mala Begum', 'Job', 'Father', 'Regular', 'Jhalokathi', '01741465643', '', NULL, NULL, 'Md', '4195268976', '2024-03-27', NULL, 'no', 1, NULL, '120000.00', '0.00', NULL, 0, 24, 10, '2024-05-01', '5000.00', 1, NULL, NULL, ' Pacage-1', 1),
(5, 1, 'Male', 'Affanul Haque Chowdhury', 'Single', NULL, '005', 'F-5', 'Rahnum Chowdhury', '1997-11-28', 'Ashraful Haque Chowdhury', 'Rahnum Chowdhury', 'Job', 'Mother', 'Regular', 'Shatgoan,Bijoynagar,Bramonbaria', '01612377442', '', NULL, NULL, 'Md', '6455561511', '2024-03-27', NULL, 'no', 1, NULL, '360000.00', '0.00', NULL, 90, 36, 10, '2024-05-01', '10000.00', 1, NULL, NULL, ' Pacage-2', 1),
(6, 1, 'Male', 'Limon   Ahmed', 'Single', NULL, '006', 'F-6', 'Fahima Haque', '1998-10-31', 'Md.Pervez', 'Lipi Akter', 'Job', 'wife', 'Regular', 'Kaliakur,gazipur', '01966001119', '', NULL, NULL, 'Md', '6454225514', '2024-03-27', NULL, 'no', 1, NULL, '120000.00', '0.00', NULL, 0, 24, 10, '2024-03-27', '5000.00', 1, NULL, NULL, ' Pacage-1', 1),
(7, 1, 'Female', 'Ashmumu Anwar Anika', 'Single', NULL, '007', 'F-7', 'Shamim Mia,SM Ayash', '2000-03-14', 'Md.Anwar Hossain', 'Parvin Akter Nisha', 'Housewife', 'Husbend,Son', 'Regular', 'Barua,Khilkhet,Dhaka-1229', '01833833985', '', NULL, NULL, 'Md', '9582627650', '2024-03-27', NULL, 'No', 1, NULL, '360000.00', '0.00', NULL, 90, 36, 10, '2024-05-01', '10000.00', 1, NULL, NULL, ' Pacage-2', 1),
(8, 2, 'Male', 'Abdur Rahman Sobuj', 'Single', NULL, '008', 'F-8', 'Hosna Akter', '2024-03-27', 'Md.Enayet Ullah', 'Rashada Begum', 'Business', 'Wife', 'Regular', 'Maghua nangalkoat,Comilla-3583', '01791901631', '', NULL, NULL, 'Shamim', '2831249392', '2024-03-27', NULL, 'no', 1, NULL, '360000.00', '45000.00', NULL, 0, 36, 10, '2024-05-01', '8750.00', 1, NULL, NULL, ' Pacage-2 ', 1),
(9, 2, 'Male', 'Abu Jafor', 'Single', NULL, '009', 'F-9', 'Wife', '1992-01-01', 'Late Delowar Hossain', 'Late Farida Begum', 'Job', 'Wife', 'Regular', 'JessoreSM', '01735860553', '', NULL, NULL, 'SM SHAMIM MIA', '00', '2024-04-01', NULL, 'No', 1, NULL, '120000.00', '0.00', NULL, 0, 36, 10, '2024-05-10', '3333.00', 1, NULL, NULL, ' Package-1', 1),
(10, 2, 'Male', 'Masum Ali Bapary', 'Single', NULL, '010', 'F-10', 'Wife', '2024-04-06', 'Hussain Ali Bapary', 'Saytun Nesa', 'Business', 'Wife', 'Regular', 'Barua,Uttarpara,Barua,Khilkhet,Dhaka-1229', '01717407999', '', NULL, NULL, 'Sm Shamim Mia', '7789228694', '2024-04-06', NULL, 'No', 1, NULL, '400000.00', '30000.00', NULL, 90, 36, 10, '2024-05-10', '10278.00', 1, NULL, NULL, ' Package -2(Diamond)', 1),
(11, 3, 'Male', 'Pobon Chandro Daas', 'Single', NULL, '011', 'F-11', 'Sompod', '1975-12-31', 'Robindro Chondro Daas', 'Kanon Bala', 'Business', 'Son', 'Regular', 'Barua(Grameen Bank mor)Khilkhet Dhaka -1229', '01705782747', '', NULL, NULL, '', '7783578144', '2024-04-22', NULL, 'No', 1, NULL, '430000.00', '20000.00', NULL, 90, 36, 10, '2024-05-10', '11389.00', 1, NULL, NULL, ' Package-2  ', 1),
(12, 3, 'Male', 'Wasef Hasan', 'Single', NULL, '012', 'F-12', 'Nazmul Hasan Bhuiyan', '2007-11-30', 'Nazmul Hasan Bhuiyan', 'Azima Khatun Nadira', 'Student', 'Father', 'Regular', 'H-316,Road-21,New Dohs Mohakhali,Dhaka Cantorment', '01886480295', '', NULL, NULL, 'Nazim', '000000', '2024-04-22', NULL, 'no', 1, NULL, '430000.00', '20000.00', NULL, 90, 36, 10, '2024-05-10', '11389.00', 1, NULL, NULL, ' Package-2', 1),
(13, 3, 'Male', 'Emran Husain', 'Single', NULL, '013', 'F-13', 'Abdul Jabbar Dewan', '1993-12-12', 'Abdul Jabbar Dewan', 'Gul Akter', 'Business', 'Father', 'Regular', 'H-427,Vill-Barua,Longonipara', '01924900435', '', NULL, NULL, 'Nazim', '7794376199', '2024-04-22', NULL, 'no', 1, NULL, '430000.00', '20000.00', NULL, 0, 36, 10, '2024-05-10', '11389.00', 1, NULL, NULL, ' Package-2 ', 1),
(14, 2, 'Male', 'Habil Hasan', 'Single', NULL, '014', 'F-14', 'Morsheda begum', '2002-03-11', 'Jahangir Badsha', 'Mst.Morsheda Begum', 'Business', 'Mother', 'Regular', 'Tatultola,Namapara,Joarshara,Khilkhet Dhaka', '01869617774', '', NULL, NULL, 'Shamim', '5564017928', '2024-04-24', NULL, 'no', 1, NULL, '140000.00', '0.00', NULL, 90, 24, 1, '2024-04-20', '3000.00', 1, NULL, NULL, ' Package-1   ', 1),
(15, 1, 'Male', 'Tasfiq Ahmed', 'Single', NULL, '015', 'F-15', 'Ummy Qulsum', '2007-09-09', 'Md.Tofial Ahmed', 'Ummay Qulsum', 'Student', 'Mother', 'Regular', 'Azampur,Dhakshinkhan,Dhaka', '01727266396', '', NULL, NULL, 'Md', '2007269255001162', '2024-04-27', NULL, 'No', 1, NULL, '400000.00', '50000.00', NULL, 90, 36, 10, '2024-05-10', '9722.00', 1, NULL, NULL, ' Package-2', 1),
(16, 1, 'Male', 'Tanzim Ahmed', 'Single', NULL, '016', 'F-16', 'Ummy Qulsum', '2024-04-27', 'Md.Tofail Ahmed', 'Ummy qulsum', 'Job', 'Mother', 'Regular', 'Azampur Uttarkhan Dhaka-1230', '01727266396', '', NULL, NULL, 'Md', '1033049147', '2024-04-27', NULL, 'No', 1, NULL, '400000.00', '50000.00', NULL, 0, 36, 10, '2024-05-20', '9722.00', 1, NULL, NULL, ' Package-2', 1),
(17, 4, 'Male', 'Md.Mamunur Rashed', 'Single', NULL, '017', 'F-17', 'Mitu', '2024-04-29', 'Md.harunur Rashid', 'Mst.Shahana Rashid', 'Business', 'Wife', 'Regular', 'H-40,Road-15,Rupnagar,PO-Mirpur-1216 Dhaka', '+1(204)3332414', '', NULL, NULL, '', '5519700743', '2024-04-29', NULL, 'No', 1, NULL, '400000.00', '0.00', NULL, 0, 36, 10, '2024-04-29', '11111.00', 1, NULL, NULL, ' Pacakage-2 ', 1),
(18, 5, 'Male', 'Mohbur  Rahman', 'Single', NULL, '018', 'F-18', 'Akhi Akter', '2024-04-29', 'Abdul Mannan', 'Maleka', 'Business', 'Wife', 'Regular', '481,Kawlar Maddha Para,Dhakshinkhan-1229', '01972020201', '', NULL, NULL, 'munni', '0', '2024-04-29', NULL, 'no', 1, NULL, '400000.00', '80000.00', NULL, 90, 36, 1, '2024-05-10', '8889.00', 1, NULL, NULL, ' Package-2 Diamond ', 1),
(19, 6, 'Male', 'Md.Mojibur Rahman', 'Single', NULL, '019', 'F-19', 'Most.Akter Naher', '1962-06-12', 'Mahtab Uddin Sheikh', 'Rabeya Khatun', 'Business', 'Wife', 'Regular', 'H-397,New Eskaton Regal Apartment Flat-603,Dhaka', '01711612387', '', NULL, NULL, 'Nannu', '6874619577', '2024-05-04', NULL, 'No', 1, NULL, '360000.00', '0.00', NULL, 0, 36, 1, '2024-09-10', '10000.00', 1, NULL, NULL, ' Diamond.Package-2  ', 1),
(20, 2, 'Male', 'Md.Yousuf Ali', 'Single', NULL, '020', 'F-20', 'Khaleda Akter', '2024-05-05', 'Md.Abu Sayed', 'Jahanara Begum', 'Job', 'Wife', 'Regular', 'Dhamalcor,Dhaka Cantorment', '01719984673', '', NULL, NULL, 'Shamim Mia', '9551614762', '2024-05-05', NULL, 'No', 1, NULL, '400000.00', '10000.00', NULL, 0, 36, 10, '2024-06-10', '10833.00', 1, NULL, NULL, ' Package-2', 1),
(21, 2, 'Male', 'Md.Mizanur Rahman', 'Single', NULL, '021', 'F-21', 'Umme Salma', '2024-05-05', 'Hossain Ahammod', 'Salaha Khatun', 'Business', 'Wife', 'Regular', 'Dhaka', '01676381170', '', NULL, NULL, 'Shamim Mia', '5522935906', '2024-05-05', NULL, 'No', 1, NULL, '400000.00', '95000.00', NULL, 90, 36, 10, '2024-07-10', '8472.00', 1, NULL, NULL, ' Package-2 ', 1),
(22, 7, 'Male', 'Md.Rafiqul Islam', 'Single', NULL, '022', 'F-22', 'Tania Begum', '2024-05-07', 'Mohhamod Ali', 'Mst.Sufia Begum', 'Business', 'Wife', 'Regular', 'Khuksabari,Enayetpur,Sirajgong', '01713718237', '', NULL, NULL, 'Sirajul Islam', '2365989405', '2024-05-07', NULL, 'No', 1, NULL, '140000.00', '30000.00', NULL, 90, 24, 1, '', '4583.00', 1, NULL, NULL, '  Package -1 Gold   ', 1),
(23, 3, 'Male', 'Md.Nazmul Hasan Mithun', 'Single', NULL, '023', 'F-23', 'Kazi Farhana Sony', '2024-05-07', 'Md.Abdul Jalil', 'Fatema Akter', 'Business', 'Wife', 'Regular', '297/1East Nakalpara,Tejgaon Dhaka', '01711083093', '', NULL, NULL, 'SM NAZIM', '19902699501000053', '2024-05-07', NULL, 'No', 1, NULL, '400000.00', '0.00', NULL, 0, 36, 10, '2024-06-10', '10000.00', 1, NULL, NULL, ' Package-2   ', 1),
(24, 4, 'Female', 'Rani Begum', 'Single', NULL, '024', 'F-24', 'Rahim,Rihad,Rifat', '1986-03-22', 'SM Sultan', 'Rabeya Khatun', 'Job', 'Son', 'Regular', 'Pailot Pokolpo,Post-Gulsan,Dhaka north City', '01719783722', '', NULL, NULL, 'Mahadi', '5976100957', '2024-05-10', NULL, 'No', 1, NULL, '800000.00', '0.00', NULL, 90, 36, 10, '2024-06-10', '22222.00', 1, NULL, NULL, ' Package-2 Diamond Share-6  ', 1),
(25, 7, 'Male', 'Nazmus Shakib', 'Single', NULL, '025', 'F-25', 'Shikha Khatun', '1992-08-04', 'Md. Fazlul Haque', 'Rokeya Parvin', 'Job', 'Wife', 'Regular', '11/BRoad-99 Gulshan-2', '01719801717', '', NULL, NULL, 'Md Sirajul islam', '19925017950000329', '2024-05-10', NULL, 'No', 1, NULL, '130000.00', '10000.00', NULL, 90, 24, 10, '2024-06-10', '5000.00', 1, NULL, NULL, ' Package-1 ', 1);

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

--
-- Table structure for table `dag_info`
--

CREATE TABLE `dag_info` (
  `dag_id` int(11) NOT NULL,
  `cs_no` varchar(50) NOT NULL,
  `rs_no` varchar(250) DEFAULT NULL,
  `city_no` varchar(20) DEFAULT NULL,
  `land_qty` varchar(20) DEFAULT NULL,
  `mouza_name` varchar(50) DEFAULT NULL,
  `description` varchar(6000) DEFAULT NULL,
  `create_date` varchar(20) NOT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `director_share`
--

CREATE TABLE `director_share` (
  `share_id` int(11) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `share_name` varchar(100) NOT NULL,
  `share_quantity` int(11) NOT NULL,
  `share_amount` decimal(10,2) NOT NULL,
  `share_date` varchar(15) NOT NULL,
  `share_duration` smallint(6) NOT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `employee_information`
--

CREATE TABLE `employee_information` (
  `employee_id` int(11) NOT NULL,
  `employee_name` varchar(50) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `mobile_no` varchar(15) DEFAULT NULL,
  `email_id` varchar(50) DEFAULT NULL,
  `photo` varchar(150) DEFAULT NULL,
  `signature` varchar(100) DEFAULT NULL,
  `nid_no` varchar(25) DEFAULT NULL,
  `joining_date` varchar(15) NOT NULL,
  `create_date` varchar(20) DEFAULT NULL,
  `company_policy` varchar(500) DEFAULT NULL,
  `post_id` int(11) DEFAULT NULL,
  `salary` decimal(11,2) DEFAULT NULL,
  `bonus_percentage` smallint(3) DEFAULT NULL,
  `c_sim_use` enum('YES','NO') DEFAULT NULL,
  `sim_mob_no` varchar(20) DEFAULT NULL,
  `father_name` varchar(100) DEFAULT NULL,
  `mother_name` varchar(100) DEFAULT NULL,
  `reference_by` varchar(100) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `employee_loan`
--

CREATE TABLE `employee_loan` (
  `loan_id` int(11) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `loan_name` varchar(150) NOT NULL,
  `loan_date` varchar(15) NOT NULL,
  `loan_amount` decimal(11,2) NOT NULL,
  `ad_type` varchar(20) NOT NULL,
  `ad_amount` decimal(11,2) NOT NULL,
  `give_type` varchar(20) DEFAULT NULL,
  `bank_id` int(11) NOT NULL,
  `branch_name` varchar(100) NOT NULL,
  `cheque_id` int(11) NOT NULL,
  `cheque_date` varchar(20) NOT NULL,
  `note` varchar(200) NOT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `employee_loan_ad`
--

CREATE TABLE `employee_loan_ad` (
  `loan_ad_id` int(11) NOT NULL,
  `loan_id` int(11) NOT NULL,
  `ad_date` varchar(20) NOT NULL,
  `cheque` varchar(20) NOT NULL,
  `bank_name` varchar(150) DEFAULT NULL,
  `branch_name` varchar(100) DEFAULT NULL,
  `paid_amount` decimal(11,2) NOT NULL,
  `ad_month` varchar(15) NOT NULL,
  `remarks` varchar(150) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `employee_salary`
--

CREATE TABLE `employee_salary` (
  `emp_salary_id` int(11) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `pay_amount` decimal(11,2) NOT NULL,
  `deposit_amount` decimal(11,2) NOT NULL,
  `give_type` varchar(20) DEFAULT NULL,
  `bank_id` int(11) NOT NULL,
  `cheque_id` int(11) NOT NULL,
  `branch_name` varchar(100) NOT NULL,
  `cheque_date` varchar(20) NOT NULL,
  `pay_month` varchar(30) NOT NULL,
  `create_date` varchar(20) NOT NULL,
  `pay_year` int(11) NOT NULL,
  `pay_month_date` varchar(15) NOT NULL,
  `remarks` varchar(100) DEFAULT NULL,
  `category` enum('1','2') NOT NULL COMMENT '1=Director,2=Employee',
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `expense_category`
--

CREATE TABLE `expense_category` (
  `cat_id` int(11) NOT NULL,
  `cat_name` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `expense_category`
--

INSERT INTO `expense_category` (`cat_id`, `cat_name`) VALUES
(1, 'Share repesentive Comission');

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

--
-- Table structure for table `flat_info`
--

CREATE TABLE `flat_info` (
  `flat_id` int(11) NOT NULL,
  `project_id` int(11) NOT NULL,
  `flat_no` varchar(50) NOT NULL,
  `flat_size` varchar(250) DEFAULT NULL,
  `road_no` varchar(20) DEFAULT NULL,
  `block_no` varchar(20) DEFAULT NULL,
  `area` varchar(150) DEFAULT NULL,
  `flat_description` varchar(6000) DEFAULT NULL,
  `create_date` varchar(20) NOT NULL,
  `user_id` int(11) NOT NULL,
  `customer_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `flat_info`
--

INSERT INTO `flat_info` (`flat_id`, `project_id`, `flat_no`, `flat_size`, `road_no`, `block_no`, `area`, `flat_description`, `create_date`, `user_id`, `customer_id`) VALUES
(1, 1, 'P0001', NULL, NULL, NULL, 'The Palligram Resort', 'Sells', '', 1, NULL),
(2, 1, 'P0002', NULL, NULL, NULL, 'The Palligram Resort', 'Sells', '', 1, NULL),
(3, 1, 'P0003', NULL, NULL, NULL, 'The Palligram Resort', 'Sells', '', 1, NULL),
(4, 1, 'P0004', NULL, NULL, NULL, 'The Palligram Resort', 'Sells', '', 1, NULL),
(5, 1, 'P0005', NULL, NULL, NULL, 'The Palligram Resort', 'sells', '', 1, NULL),
(6, 1, 'P0006', NULL, NULL, NULL, 'The Palligram Resort', 'Sells', '', 1, NULL),
(7, 1, 'P0007', NULL, NULL, NULL, 'The Palligram Resort', 'Sells', '', 1, NULL),
(8, 1, 'P0008', NULL, NULL, NULL, 'The Palligram Resort', 'sells', '', 1, NULL),
(9, 1, 'P0009', NULL, NULL, NULL, 'The Palligram Resort', 'Sells', '', 1, NULL),
(10, 1, 'P0010', NULL, NULL, NULL, 'The Palligram Resort', 'Sells', '', 1, NULL),
(11, 1, 'P0011', NULL, NULL, NULL, 'The Palligram Resort', 'Sells', '', 1, NULL),
(12, 1, 'P0012', NULL, NULL, NULL, 'The Palligram Resort', 'Sells', '', 1, NULL),
(13, 1, 'P0013', NULL, NULL, NULL, 'The Palligram Resort', 'Sells', '', 1, NULL),
(14, 1, 'P0014', NULL, NULL, NULL, 'The Palligram Resort', 'Sells', '', 1, NULL),
(15, 1, 'P0015', NULL, NULL, NULL, 'The Palligram Resort', 'Sells', '', 1, NULL),
(16, 1, 'P0016', NULL, NULL, NULL, 'The Palligram Resort', 'Sells', '', 1, NULL),
(17, 1, 'P0017', NULL, NULL, NULL, 'The Palligram Resort', 'Sells', '', 1, NULL),
(18, 1, 'P0018', NULL, NULL, NULL, 'The Palligram Resort', 'Sells', '', 1, NULL),
(19, 1, 'P0019', NULL, NULL, NULL, 'The Palligram Resort', 'Sells', '', 1, NULL),
(20, 1, 'P0020', NULL, NULL, NULL, 'The Palligram Resort', 'Sells', '', 1, NULL),
(21, 1, 'P0021', NULL, NULL, NULL, 'The palligram Resort', 'Sales', '', 1, NULL),
(22, 1, 'P0022', NULL, NULL, NULL, 'The Polligram Resort', 'Sales', '', 1, NULL),
(23, 1, 'P0023', NULL, NULL, NULL, 'The Polligram Resort', 'Sales', '', 1, NULL),
(24, 1, 'P0024', NULL, NULL, NULL, 'The Polligram Resort', 'Sales', '', 1, NULL),
(25, 1, 'P0025', NULL, NULL, NULL, 'The Polligram Resort', 'Sales', '', 1, NULL),
(26, 1, 'P0026', NULL, NULL, NULL, 'The Polligram Resort', 'Sales', '', 1, NULL),
(27, 1, 'P0027', NULL, NULL, NULL, 'The Polligram Resort', 'Sales', '', 1, NULL),
(28, 1, 'P0028', NULL, NULL, NULL, 'The Polligram Resort', 'Sales', '', 1, NULL),
(29, 1, 'P0029', NULL, NULL, NULL, 'The Polligram Resort', 'Sales', '', 1, NULL),
(30, 1, 'P0030', NULL, NULL, NULL, 'The Polligram Resort', 'Sales', '', 1, NULL),
(31, 1, 'P0031', NULL, NULL, NULL, 'The Polligram Resort', 'Sales', '', 1, NULL),
(32, 1, 'P0032', NULL, NULL, NULL, 'The Polligram Resort', 'Sales', '', 1, NULL),
(33, 1, 'P0033', NULL, NULL, NULL, 'The Polligram Resort', 'Sales', '', 1, NULL),
(34, 1, 'P0034', NULL, NULL, NULL, 'The Polligram Resort', 'Sales', '', 1, NULL),
(35, 1, 'P0035', NULL, NULL, NULL, 'The Polligram Resort', 'Sales', '', 1, NULL),
(36, 1, 'P0036', NULL, NULL, NULL, 'The Polligram Resort', 'Sales', '', 1, NULL),
(37, 1, 'P0037', NULL, NULL, NULL, 'The Polligram Resort', 'Sales', '', 1, NULL),
(38, 1, 'P0038', NULL, NULL, NULL, 'The Polligram Resort', 'Sales', '', 1, NULL),
(39, 1, 'P0039', NULL, NULL, NULL, 'The Polligram Resort', 'Sales', '', 1, NULL),
(40, 1, 'P0040', NULL, NULL, NULL, 'The Polligram Resort', 'Sales', '', 1, NULL),
(41, 1, 'P0041', NULL, NULL, NULL, 'The palligram resort', 'For sales', '', 1, NULL),
(42, 1, 'P0042', NULL, NULL, NULL, 'The palligram resort', 'For sales', '', 1, NULL),
(43, 1, 'P0043', NULL, NULL, NULL, 'The palligram resort', 'For sales', '', 1, NULL),
(44, 1, 'P0044', NULL, NULL, NULL, 'The palligram resort', 'For sales', '', 1, NULL),
(45, 1, 'P0045', NULL, NULL, NULL, 'The palligram resort', 'For sales', '', 1, NULL),
(46, 1, 'P0046', NULL, NULL, NULL, 'The palligram resort', 'For sales', '', 1, NULL),
(47, 1, 'P0047', NULL, NULL, NULL, 'The palligram resort', 'For sales', '', 1, NULL),
(48, 1, 'P0048', NULL, NULL, NULL, 'The palligram resort', 'For sales', '', 1, NULL),
(49, 1, 'P0049', NULL, NULL, NULL, 'The palligram resort', 'For sales', '', 1, NULL),
(50, 1, 'P0050', NULL, NULL, NULL, 'The palligram resort', 'For sales', '', 1, NULL);

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

--
-- Table structure for table `landowner_detail`
--

CREATE TABLE `landowner_detail` (
  `land_id` int(11) NOT NULL,
  `project_id` int(11) NOT NULL,
  `land_size` varchar(200) NOT NULL,
  `payment_amount` decimal(11,2) NOT NULL,
  `deed_date` varchar(20) NOT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `landowner_information`
--

CREATE TABLE `landowner_information` (
  `landowner_id` int(11) NOT NULL,
  `project_id` int(11) NOT NULL,
  `owner_id` int(11) NOT NULL DEFAULT 1,
  `broker_id` int(11) DEFAULT NULL,
  `landowner_name` varchar(50) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `mobile_no` varchar(15) DEFAULT NULL,
  `email_id` varchar(50) DEFAULT NULL,
  `land_qty` varchar(20) DEFAULT NULL,
  `cs_no` varchar(20) DEFAULT NULL,
  `rs_no` varchar(20) DEFAULT NULL,
  `city_no` varchar(20) DEFAULT NULL,
  `mouza_name` varchar(50) DEFAULT NULL,
  `photo` varchar(150) DEFAULT NULL,
  `signature` varchar(100) DEFAULT NULL,
  `nid_no` varchar(25) DEFAULT NULL,
  `create_date` varchar(20) DEFAULT NULL,
  `land_value` decimal(11,2) DEFAULT NULL,
  `purchase_status` varchar(50) NOT NULL DEFAULT 'ONGOING',
  `land_id` int(11) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `land_purchase`
--

CREATE TABLE `land_purchase` (
  `id` int(11) NOT NULL,
  `landowner_id` int(11) DEFAULT NULL,
  `dag_id` int(11) DEFAULT NULL,
  `land_qty` decimal(11,2) DEFAULT NULL,
  `city_no` varchar(50) DEFAULT NULL,
  `cs_no` varchar(50) DEFAULT NULL,
  `rs_no` varchar(50) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `marketing_list`
--

CREATE TABLE `marketing_list` (
  `marketing_id` int(11) NOT NULL,
  `customer_name` varchar(120) NOT NULL,
  `address` varchar(250) NOT NULL,
  `phone_no` varchar(30) NOT NULL,
  `date` varchar(20) NOT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `mouza_info`
--

CREATE TABLE `mouza_info` (
  `mouza_id` int(11) NOT NULL,
  `mouza_name` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `oldassetsell`
--

CREATE TABLE `oldassetsell` (
  `assetsell_id` int(11) NOT NULL,
  `sell_type` varchar(20) NOT NULL,
  `project_id` int(11) DEFAULT NULL,
  `asset_name` varchar(150) NOT NULL,
  `sell_date` varchar(20) NOT NULL,
  `quantity` smallint(6) NOT NULL,
  `total_price` decimal(8,2) NOT NULL,
  `description` varchar(250) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `org_info`
--

CREATE TABLE `org_info` (
  `org_id` tinyint(4) NOT NULL,
  `org_name` varchar(120) NOT NULL,
  `phone_no` varchar(20) DEFAULT NULL,
  `email` varchar(30) DEFAULT NULL,
  `address` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `org_info`
--

INSERT INTO `org_info` (`org_id`, `org_name`, `phone_no`, `email`, `address`) VALUES
(1, 'iNTECH PROPERTIES LTD', '01725888', 'opex@gmail.com', 'USA');

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

--
-- Table structure for table `post`
--

CREATE TABLE `post` (
  `post_id` smallint(6) NOT NULL,
  `post_name` varchar(100) NOT NULL,
  `post_lavel` enum('Director','Employee') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `post`
--

INSERT INTO `post` (`post_id`, `post_name`, `post_lavel`) VALUES
(2, 'Manager', 'Employee'),
(4, 'Asst. Manager', 'Employee'),
(5, 'Chairman', 'Director'),
(6, 'Vice Chairman', 'Director'),
(7, 'Manging Director', 'Director'),
(8, 'Director', 'Director'),
(9, 'Office Peon', 'Employee'),
(10, 'Security Guard', 'Employee'),
(11, 'Project Engineer', 'Employee'),
(12, 'Assistent Project Engineer', 'Employee'),
(13, 'Project Supervisor', 'Employee'),
(14, 'Excutive Officer', 'Employee'),
(15, 'Chairman', 'Director'),
(16, 'Director of Project', 'Director'),
(17, 'Director of Project', 'Employee'),
(18, 'Director of Operation', 'Employee'),
(19, 'Account Officer', 'Director');

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

--
-- Table structure for table `project_information`
--

CREATE TABLE `project_information` (
  `project_id` int(11) NOT NULL,
  `project_name` varchar(200) DEFAULT NULL,
  `project_address` varchar(250) DEFAULT NULL,
  `total_flat_des` varchar(500) DEFAULT NULL,
  `sale_des` varchar(200) DEFAULT NULL,
  `project_deed_date` varchar(20) DEFAULT NULL,
  `project_start_date` varchar(20) DEFAULT NULL,
  `hand_over_date` varchar(20) DEFAULT NULL,
  `project_status` varchar(20) DEFAULT NULL,
  `create_date` varchar(20) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `project_information`
--

INSERT INTO `project_information` (`project_id`, `project_name`, `project_address`, `total_flat_des`, `sale_des`, `project_deed_date`, `project_start_date`, `hand_over_date`, `project_status`, `create_date`, `user_id`) VALUES
(1, 'The Palligram Resort', 'Kaligong Gazipur', '5000', 'Share sells', '24/03/2024', '01/01/2025', '01/01/2029', 'On Going', NULL, 1);

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

--
-- Table structure for table `register_deposit_money`
--

CREATE TABLE `register_deposit_money` (
  `deposit_id` int(11) NOT NULL,
  `purpose_id` int(11) NOT NULL,
  `deposit_date` varchar(15) NOT NULL,
  `amount` decimal(11,2) NOT NULL DEFAULT 0.00,
  `note` varchar(250) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `requisition_detail`
--

CREATE TABLE `requisition_detail` (
  `detail_id` int(11) NOT NULL,
  `req_id` int(11) NOT NULL,
  `req_name` varchar(200) NOT NULL,
  `quantity` varchar(80) NOT NULL,
  `remark` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `requisition_information`
--

CREATE TABLE `requisition_information` (
  `req_id` int(11) NOT NULL,
  `req_type` enum('Office','Project') DEFAULT NULL,
  `project_id` int(11) DEFAULT NULL,
  `item_name` varchar(200) DEFAULT NULL,
  `req_date` varchar(15) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `salary_table`
--

CREATE TABLE `salary_table` (
  `salary_id` int(11) NOT NULL,
  `employee_id` tinyint(4) DEFAULT NULL,
  `salary` decimal(11,2) DEFAULT NULL,
  `year` int(11) DEFAULT NULL,
  `change_date` varchar(15) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `share_adjaustment`
--

CREATE TABLE `share_adjaustment` (
  `share_ad_id` int(11) NOT NULL,
  `share_id` int(11) NOT NULL,
  `ad_date` varchar(15) NOT NULL,
  `mr_no` int(11) NOT NULL,
  `pay_amount` decimal(11,2) NOT NULL,
  `cheque_no` varchar(20) DEFAULT NULL,
  `bank_id` varchar(11) DEFAULT NULL,
  `branch_name` varchar(120) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `supplier_detail`
--

CREATE TABLE `supplier_detail` (
  `supplier_detail_id` int(11) NOT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `sproduct_id` int(11) DEFAULT NULL,
  `project_id` int(11) DEFAULT NULL,
  `unit_price` decimal(11,2) NOT NULL,
  `quantity` float NOT NULL,
  `payment_amount` decimal(11,2) DEFAULT NULL,
  `mr_no` varchar(30) DEFAULT NULL,
  `purchase_date` varchar(20) NOT NULL,
  `comments` varchar(350) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `supplier_information`
--

CREATE TABLE `supplier_information` (
  `supplier_id` int(11) NOT NULL,
  `supplier_name` varchar(50) NOT NULL,
  `prop_name` varchar(100) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `mobile_no` varchar(15) DEFAULT NULL,
  `email_id` varchar(50) DEFAULT NULL,
  `photo` varchar(150) DEFAULT NULL,
  `signature` varchar(100) DEFAULT NULL,
  `reference_by` varchar(100) DEFAULT NULL,
  `nid_no` varchar(25) DEFAULT NULL,
  `create_date` varchar(20) DEFAULT NULL,
  `supply_policy` varchar(500) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `supplier_product`
--

CREATE TABLE `supplier_product` (
  `sproduct_id` int(11) NOT NULL,
  `sproduct_name` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `sys_menu`
--

CREATE TABLE `sys_menu` (
  `menu_id` int(11) NOT NULL,
  `menu_label` varchar(100) NOT NULL,
  `link` varchar(100) NOT NULL DEFAULT '#',
  `icon` varchar(100) NOT NULL DEFAULT 'fa fa-external-link-square',
  `parent` int(11) NOT NULL DEFAULT 0,
  `sort` int(11) NOT NULL,
  `head_office` tinyint(4) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;



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

--
-- Table structure for table `sys_user_role`
--

CREATE TABLE `sys_user_role` (
  `user_role_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `menu_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `sys_user_role`
--

INSERT INTO `sys_user_role` (`user_role_id`, `user_id`, `menu_id`) VALUES
(48, 5, 1),
(49, 5, 6),
(50, 5, 7),
(51, 5, 8),
(52, 5, 9),
(53, 5, 10),
(54, 5, 11),
(55, 5, 12),
(56, 5, 13),
(57, 5, 14),
(58, 5, 15),
(59, 5, 62),
(60, 5, 63),
(61, 5, 64),
(62, 5, 65),
(63, 5, 66),
(64, 5, 67),
(65, 5, 68),
(125, 6, 1),
(126, 6, 5),
(127, 6, 11),
(128, 6, 12),
(129, 6, 13),
(130, 6, 14),
(131, 6, 15),
(132, 6, 16),
(133, 6, 17),
(134, 6, 18),
(135, 6, 19),
(136, 6, 20),
(137, 6, 22),
(138, 6, 62),
(139, 6, 63),
(140, 6, 64),
(141, 6, 65),
(142, 6, 66),
(143, 6, 67),
(144, 6, 68),
(657, 1, 1),
(658, 1, 2),
(659, 1, 3),
(660, 1, 4),
(661, 1, 6),
(662, 1, 7),
(663, 1, 8),
(664, 1, 9),
(665, 1, 10),
(666, 1, 11),
(667, 1, 12),
(668, 1, 13),
(669, 1, 14),
(670, 1, 15),
(671, 1, 16),
(672, 1, 17),
(673, 1, 18),
(674, 1, 19),
(675, 1, 20),
(676, 1, 21),
(677, 1, 23),
(678, 1, 24),
(679, 1, 25),
(680, 1, 26),
(681, 1, 27),
(682, 1, 28),
(683, 1, 29),
(684, 1, 30),
(685, 1, 31),
(686, 1, 32),
(687, 1, 35),
(688, 1, 33),
(689, 1, 34),
(690, 1, 36),
(691, 1, 37),
(692, 1, 47),
(693, 1, 38),
(694, 1, 39),
(695, 1, 40),
(696, 1, 41),
(697, 1, 42),
(698, 1, 43),
(699, 1, 44),
(700, 1, 45),
(701, 1, 46),
(702, 1, 48),
(703, 1, 49),
(704, 1, 50),
(705, 1, 51),
(706, 1, 52),
(707, 1, 53),
(708, 1, 54),
(709, 1, 55),
(710, 1, 56),
(711, 1, 57),
(712, 1, 58),
(713, 1, 59),
(714, 1, 60),
(715, 1, 61),
(716, 1, 73),
(717, 1, 76),
(718, 1, 80),
(719, 1, 82),
(720, 1, 62),
(721, 1, 63),
(722, 1, 64),
(723, 1, 65),
(724, 1, 66),
(725, 1, 67),
(726, 1, 75),
(727, 1, 77),
(728, 1, 81),
(729, 1, 69),
(730, 1, 70),
(731, 1, 71),
(732, 1, 74),
(733, 1, 72),
(734, 1, 78),
(735, 1, 5),
(736, 1, 79),
(737, 1, 83),
(738, 1, 84),
(946, 2, 1),
(947, 2, 6),
(948, 2, 7),
(949, 2, 8),
(950, 2, 9),
(951, 2, 10),
(952, 2, 11),
(953, 2, 12),
(954, 2, 13),
(955, 2, 14),
(956, 2, 15),
(957, 2, 24),
(958, 2, 25),
(959, 2, 26),
(960, 2, 27),
(961, 2, 28),
(962, 2, 29),
(963, 2, 30),
(964, 2, 31),
(965, 2, 32),
(966, 2, 35),
(967, 2, 38),
(968, 2, 80),
(969, 2, 88),
(970, 2, 89),
(971, 2, 90),
(972, 2, 91),
(973, 2, 62),
(974, 2, 63),
(975, 2, 64),
(976, 2, 65),
(977, 2, 66),
(978, 2, 67),
(979, 2, 75),
(980, 2, 77),
(981, 2, 81),
(982, 2, 72),
(983, 2, 78),
(984, 2, 5),
(985, 2, 79),
(986, 2, 83),
(993, 4, 1),
(994, 4, 2),
(995, 4, 3),
(996, 4, 4),
(997, 4, 6),
(998, 4, 7),
(999, 4, 8),
(1000, 4, 9),
(1001, 4, 10),
(1002, 4, 11),
(1003, 4, 12),
(1004, 4, 13),
(1005, 4, 14),
(1006, 4, 15),
(1007, 4, 16),
(1008, 4, 17),
(1009, 4, 18),
(1010, 4, 19),
(1011, 4, 20),
(1012, 4, 21),
(1013, 4, 23),
(1014, 4, 24),
(1015, 4, 25),
(1016, 4, 26),
(1017, 4, 27),
(1018, 4, 28),
(1019, 4, 29),
(1020, 4, 30),
(1021, 4, 31),
(1022, 4, 32),
(1023, 4, 35),
(1024, 4, 33),
(1025, 4, 34),
(1026, 4, 36),
(1027, 4, 37),
(1028, 4, 47),
(1029, 4, 38),
(1030, 4, 43),
(1031, 4, 62),
(1032, 4, 63),
(1033, 4, 64),
(1034, 4, 65),
(1035, 4, 66),
(1036, 4, 67),
(1037, 4, 72),
(1038, 4, 78),
(1039, 4, 5),
(1040, 3, 1);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `account_table`
--
ALTER TABLE `account_table`
  ADD PRIMARY KEY (`account_id`);

--
-- Indexes for table `agreement_info`
--
ALTER TABLE `agreement_info`
  ADD PRIMARY KEY (`agreement_id`);

--
-- Indexes for table `assetbuy`
--
ALTER TABLE `assetbuy`
  ADD PRIMARY KEY (`buy_id`);

--
-- Indexes for table `asset_information`
--
ALTER TABLE `asset_information`
  ADD PRIMARY KEY (`asset_id`);

--
-- Indexes for table `bank_information`
--
ALTER TABLE `bank_information`
  ADD PRIMARY KEY (`bank_id`);

--
-- Indexes for table `broker_information`
--
ALTER TABLE `broker_information`
  ADD PRIMARY KEY (`broker_id`);

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

--
-- Indexes for table `budget_cost`
--
ALTER TABLE `budget_cost`
  ADD PRIMARY KEY (`budget_cost_id`);

--
-- Indexes for table `cash_register`
--
ALTER TABLE `cash_register`
  ADD PRIMARY KEY (`register_id`);

--
-- Indexes for table `cash_register_detail`
--
ALTER TABLE `cash_register_detail`
  ADD PRIMARY KEY (`register_detail_id`);

--
-- Indexes for table `cheque_book`
--
ALTER TABLE `cheque_book`
  ADD PRIMARY KEY (`cheque_id`);

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

--
-- Indexes for table `contractor_detail`
--
ALTER TABLE `contractor_detail`
  ADD PRIMARY KEY (`contractor_detail_id`);

--
-- Indexes for table `contractor_information`
--
ALTER TABLE `contractor_information`
  ADD PRIMARY KEY (`contractor_id`);

--
-- Indexes for table `contractor_product`
--
ALTER TABLE `contractor_product`
  ADD PRIMARY KEY (`cproduct_id`);

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

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

--
-- Indexes for table `customer_information`
--
ALTER TABLE `customer_information`
  ADD PRIMARY KEY (`customer_id`),
  ADD KEY `fk_customer_information_project_id` (`project_id`);

--
-- Indexes for table `dag_info`
--
ALTER TABLE `dag_info`
  ADD PRIMARY KEY (`dag_id`);

--
-- Indexes for table `director_share`
--
ALTER TABLE `director_share`
  ADD PRIMARY KEY (`share_id`),
  ADD UNIQUE KEY `employee_id` (`employee_id`);

--
-- Indexes for table `employee_information`
--
ALTER TABLE `employee_information`
  ADD PRIMARY KEY (`employee_id`);

--
-- Indexes for table `employee_loan`
--
ALTER TABLE `employee_loan`
  ADD PRIMARY KEY (`loan_id`);

--
-- Indexes for table `employee_loan_ad`
--
ALTER TABLE `employee_loan_ad`
  ADD PRIMARY KEY (`loan_ad_id`);

--
-- Indexes for table `employee_salary`
--
ALTER TABLE `employee_salary`
  ADD PRIMARY KEY (`emp_salary_id`);

--
-- Indexes for table `expense_category`
--
ALTER TABLE `expense_category`
  ADD PRIMARY KEY (`cat_id`);

--
-- Indexes for table `flat_info`
--
ALTER TABLE `flat_info`
  ADD PRIMARY KEY (`flat_id`);

--
-- Indexes for table `landowner_detail`
--
ALTER TABLE `landowner_detail`
  ADD PRIMARY KEY (`land_id`);

--
-- Indexes for table `landowner_information`
--
ALTER TABLE `landowner_information`
  ADD PRIMARY KEY (`landowner_id`);

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

--
-- Indexes for table `marketing_list`
--
ALTER TABLE `marketing_list`
  ADD PRIMARY KEY (`marketing_id`);

--
-- Indexes for table `mouza_info`
--
ALTER TABLE `mouza_info`
  ADD PRIMARY KEY (`mouza_id`);

--
-- Indexes for table `oldassetsell`
--
ALTER TABLE `oldassetsell`
  ADD PRIMARY KEY (`assetsell_id`);

--
-- Indexes for table `org_info`
--
ALTER TABLE `org_info`
  ADD PRIMARY KEY (`org_id`);

--
-- Indexes for table `post`
--
ALTER TABLE `post`
  ADD PRIMARY KEY (`post_id`);

--
-- Indexes for table `project_information`
--
ALTER TABLE `project_information`
  ADD PRIMARY KEY (`project_id`);

--
-- Indexes for table `register_deposit_money`
--
ALTER TABLE `register_deposit_money`
  ADD PRIMARY KEY (`deposit_id`);

--
-- Indexes for table `requisition_detail`
--
ALTER TABLE `requisition_detail`
  ADD PRIMARY KEY (`detail_id`);

--
-- Indexes for table `requisition_information`
--
ALTER TABLE `requisition_information`
  ADD PRIMARY KEY (`req_id`);

--
-- Indexes for table `salary_table`
--
ALTER TABLE `salary_table`
  ADD PRIMARY KEY (`salary_id`);

--
-- Indexes for table `share_adjaustment`
--
ALTER TABLE `share_adjaustment`
  ADD PRIMARY KEY (`share_ad_id`);

--
-- Indexes for table `supplier_detail`
--
ALTER TABLE `supplier_detail`
  ADD PRIMARY KEY (`supplier_detail_id`);

--
-- Indexes for table `supplier_information`
--
ALTER TABLE `supplier_information`
  ADD PRIMARY KEY (`supplier_id`);

--
-- Indexes for table `supplier_product`
--
ALTER TABLE `supplier_product`
  ADD PRIMARY KEY (`sproduct_id`);

--
-- Indexes for table `sys_menu`
--
ALTER TABLE `sys_menu`
  ADD PRIMARY KEY (`menu_id`);

--
-- Indexes for table `sys_user_role`
--
ALTER TABLE `sys_user_role`
  ADD PRIMARY KEY (`user_role_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

--
-- AUTO_INCREMENT for table `agreement_info`
--
ALTER TABLE `agreement_info`
  MODIFY `agreement_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `assetbuy`
--
ALTER TABLE `assetbuy`
  MODIFY `buy_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `asset_information`
--
ALTER TABLE `asset_information`
  MODIFY `asset_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bank_information`
--
ALTER TABLE `bank_information`
  MODIFY `bank_id` tinyint(4) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `broker_information`
--
ALTER TABLE `broker_information`
  MODIFY `broker_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

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

--
-- AUTO_INCREMENT for table `budget_cost`
--
ALTER TABLE `budget_cost`
  MODIFY `budget_cost_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cash_register`
--
ALTER TABLE `cash_register`
  MODIFY `register_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cash_register_detail`
--
ALTER TABLE `cash_register_detail`
  MODIFY `register_detail_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cheque_book`
--
ALTER TABLE `cheque_book`
  MODIFY `cheque_id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `contractor_detail`
--
ALTER TABLE `contractor_detail`
  MODIFY `contractor_detail_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `contractor_information`
--
ALTER TABLE `contractor_information`
  MODIFY `contractor_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `contractor_product`
--
ALTER TABLE `contractor_product`
  MODIFY `cproduct_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `customer_additional_cost`
--
ALTER TABLE `customer_additional_cost`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `customer_information`
--
ALTER TABLE `customer_information`
  MODIFY `customer_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `dag_info`
--
ALTER TABLE `dag_info`
  MODIFY `dag_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `director_share`
--
ALTER TABLE `director_share`
  MODIFY `share_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `employee_information`
--
ALTER TABLE `employee_information`
  MODIFY `employee_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `employee_loan`
--
ALTER TABLE `employee_loan`
  MODIFY `loan_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `employee_loan_ad`
--
ALTER TABLE `employee_loan_ad`
  MODIFY `loan_ad_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `employee_salary`
--
ALTER TABLE `employee_salary`
  MODIFY `emp_salary_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `expense_category`
--
ALTER TABLE `expense_category`
  MODIFY `cat_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `flat_info`
--
ALTER TABLE `flat_info`
  MODIFY `flat_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51;

--
-- AUTO_INCREMENT for table `landowner_detail`
--
ALTER TABLE `landowner_detail`
  MODIFY `land_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `landowner_information`
--
ALTER TABLE `landowner_information`
  MODIFY `landowner_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `land_purchase`
--
ALTER TABLE `land_purchase`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `marketing_list`
--
ALTER TABLE `marketing_list`
  MODIFY `marketing_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mouza_info`
--
ALTER TABLE `mouza_info`
  MODIFY `mouza_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `oldassetsell`
--
ALTER TABLE `oldassetsell`
  MODIFY `assetsell_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `org_info`
--
ALTER TABLE `org_info`
  MODIFY `org_id` tinyint(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `post`
--
ALTER TABLE `post`
  MODIFY `post_id` smallint(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `project_information`
--
ALTER TABLE `project_information`
  MODIFY `project_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `register_deposit_money`
--
ALTER TABLE `register_deposit_money`
  MODIFY `deposit_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `requisition_detail`
--
ALTER TABLE `requisition_detail`
  MODIFY `detail_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `requisition_information`
--
ALTER TABLE `requisition_information`
  MODIFY `req_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `salary_table`
--
ALTER TABLE `salary_table`
  MODIFY `salary_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `share_adjaustment`
--
ALTER TABLE `share_adjaustment`
  MODIFY `share_ad_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `supplier_detail`
--
ALTER TABLE `supplier_detail`
  MODIFY `supplier_detail_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `supplier_information`
--
ALTER TABLE `supplier_information`
  MODIFY `supplier_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `supplier_product`
--
ALTER TABLE `supplier_product`
  MODIFY `sproduct_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sys_menu`
--
ALTER TABLE `sys_menu`
  MODIFY `menu_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=94;

--
-- AUTO_INCREMENT for table `sys_user_role`
--
ALTER TABLE `sys_user_role`
  MODIFY `user_role_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1041;
COMMIT;

