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

START TRANSACTION;



--
-- Database: `sbma_sbma`
--

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

--
-- Table structure for table `account_expenses`
--

CREATE TABLE `account_expenses` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `entry_date` datetime DEFAULT NULL,
  `voucher_no` varchar(50) DEFAULT NULL,
  `debit_account_head` int DEFAULT NULL,
  `debit_amount` decimal(30,2) DEFAULT NULL,
  `credit_account_head` int DEFAULT NULL,
  `credit_amount` decimal(30,2) DEFAULT NULL,
  `debit_total_amount` decimal(20,2) DEFAULT NULL,
  `credit_total_amount` decimal(20,2) DEFAULT NULL,
  `remarks` text,
  `credit_remarks` varchar(255) DEFAULT NULL,
  `debit_remarks` varchar(255) DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL,
  `payment_mode` int DEFAULT NULL,
  `main_under` varchar(255) DEFAULT NULL,
  `opening_balance` int DEFAULT NULL,
  `account_number` int DEFAULT NULL,
  `receipt_passbook_mode` varchar(255) NOT NULL DEFAULT 'expenses'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `account_groups`
--

CREATE TABLE `account_groups` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `group_name` varchar(150) NOT NULL,
  `under` varchar(155) NOT NULL,
  `remarks` text,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL,
  `main_under` varchar(255) DEFAULT NULL,
  `main_status` int DEFAULT NULL,
  `cant_delete` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `account_heads`
--

CREATE TABLE `account_heads` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `group_id` int DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `amount` int DEFAULT NULL,
  `collection_type` varchar(255) DEFAULT NULL,
  `account_number` int DEFAULT NULL,
  `remarks` text,
  `bank_account_number` varchar(45) DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL,
  `cant_delete` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `advance_receipts`
--

CREATE TABLE `advance_receipts` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `employee_id` int NOT NULL,
  `customer_id` int NOT NULL,
  `enrollment_id` int DEFAULT NULL,
  `employee_branch_id` int DEFAULT NULL,
  `receipt_date` date DEFAULT NULL,
  `receipt_no` varchar(45) DEFAULT NULL,
  `offline_receipt_no` varchar(50) DEFAULT NULL,
  `receipt_amount` decimal(30,0) DEFAULT NULL,
  `payment_type_id` int DEFAULT NULL,
  `debit_to` varchar(200) DEFAULT NULL,
  `cheque_no` varchar(45) DEFAULT NULL,
  `cheque_date` timestamp NULL DEFAULT NULL,
  `cheque_return_amount` decimal(30,4) DEFAULT NULL,
  `cheque_clear_return_date` date DEFAULT NULL,
  `cheque_debit_to` int DEFAULT NULL,
  `bank_name_id` int DEFAULT NULL,
  `branch_name` varchar(150) DEFAULT NULL,
  `transaction_no` int DEFAULT NULL,
  `transaction_date` date DEFAULT NULL,
  `receipt_mode` varchar(50) DEFAULT NULL,
  `receipt_time` time DEFAULT NULL,
  `recpt_excess_no` varchar(50) DEFAULT NULL,
  `printed` int DEFAULT NULL,
  `remarks` text,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL,
  `receipt_passbook_mode` varchar(30) DEFAULT 'advance',
  `transfer_from_enrollment_id` int DEFAULT NULL,
  `installment_no` varchar(255) DEFAULT NULL,
  `penalty` int DEFAULT NULL,
  `bonus` int DEFAULT NULL,
  `group_id` int DEFAULT NULL,
  `received_amount` decimal(30,0) DEFAULT NULL,
  `accounts_date` timestamp NULL DEFAULT NULL,
  `ticket_no` int DEFAULT NULL,
  `cancel_dividend_amount` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `agent_commission_payments`
--

CREATE TABLE `agent_commission_payments` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `employee_agent_id` int NOT NULL,
  `customer_id` int NOT NULL,
  `group_id` int NOT NULL,
  `commission_no` varchar(45) NOT NULL,
  `ticket_no` varchar(50) NOT NULL,
  `enrollment_id` int NOT NULL,
  `payment_date` date NOT NULL,
  `paid_amount` decimal(30,4) NOT NULL,
  `customer_commission_amount` decimal(30,4) NOT NULL,
  `payment_type_id` int NOT NULL,
  `debit_to` varchar(200) NOT NULL,
  `cheque_no` varchar(45) NOT NULL,
  `cheque_date` date NOT NULL,
  `cheque_return_amount` decimal(30,4) NOT NULL,
  `cheque_clear_return_date` date NOT NULL,
  `cheque_debit_to` int NOT NULL,
  `bank_name_id` int NOT NULL,
  `branch_name` varchar(200) NOT NULL,
  `transaction_no` varchar(200) NOT NULL,
  `transaction_date` date NOT NULL,
  `remarks` text NOT NULL,
  `created_by` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text NOT NULL,
  `status` tinyint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `agent_incentive_payments`
--

CREATE TABLE `agent_incentive_payments` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `employee_agent_id` int NOT NULL,
  `group_id` int NOT NULL,
  `customer_id` int NOT NULL,
  `enrollment_id` int NOT NULL,
  `agent_type_id` int NOT NULL,
  `commission_no` varchar(45) NOT NULL,
  `ticket_no` varchar(50) NOT NULL,
  `payment_date` date NOT NULL,
  `paid_amount` decimal(30,4) NOT NULL,
  `customer_incentive_amount` decimal(30,4) NOT NULL,
  `payment_type_id` int NOT NULL,
  `debit_to` varchar(200) NOT NULL,
  `cheque_no` varchar(45) NOT NULL,
  `cheque_date` date NOT NULL,
  `cheque_return_amount` decimal(30,4) NOT NULL,
  `cheque_clear_return_date` date NOT NULL,
  `cheque_debit_to` int NOT NULL,
  `bank_name_id` int NOT NULL,
  `branch_name` varchar(200) NOT NULL,
  `transaction_no` varchar(200) NOT NULL,
  `transaction_date` date NOT NULL,
  `remarks` text NOT NULL,
  `created_by` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text NOT NULL,
  `status` tinyint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `approval_notifications`
--

CREATE TABLE `approval_notifications` (
  `id` int NOT NULL,
  `auction_name` varchar(15) NOT NULL,
  `auction_name_d` varchar(150) NOT NULL,
  `approval_from` tinyint NOT NULL,
  `login_user_id` int NOT NULL,
  `mapped_by` varchar(150) NOT NULL,
  `mapped_on` date NOT NULL,
  `created_by` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text NOT NULL,
  `status` tinyint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `asset_details`
--

CREATE TABLE `asset_details` (
  `id` int NOT NULL,
  `document_id` int NOT NULL,
  `customer_id` int NOT NULL,
  `asset_name` varchar(200) DEFAULT NULL,
  `asset_path` varchar(200) DEFAULT NULL,
  `asset_value` decimal(30,4) DEFAULT NULL,
  `return_date` datetime DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` varchar(200) DEFAULT NULL,
  `status` int DEFAULT NULL COMMENT '1=received,2=returned,3=canceled'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `attendance`
--

CREATE TABLE `attendance` (
  `Id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `employee_id` int NOT NULL,
  `attendence_date` datetime NOT NULL,
  `attendence_time` varchar(50) NOT NULL,
  `latitude` varchar(50) NOT NULL,
  `longitude` varchar(50) NOT NULL,
  `attendence_id` int NOT NULL,
  `status` tinyint NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` int NOT NULL,
  `updated_at` datetime NOT NULL,
  `updated_by` int NOT NULL,
  `remarks` text NOT NULL,
  `deleted_by` int NOT NULL,
  `deleted_at` datetime NOT NULL,
  `deletion_remark` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `attendence_type`
--

CREATE TABLE `attendence_type` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `attendence_type_name` varchar(100) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` int NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deletion_remark` text NOT NULL,
  `status` tinyint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `auction_on_holidays`
--

CREATE TABLE `auction_on_holidays` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `holiday_date` date NOT NULL,
  `event_name` text,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `bank_details`
--

CREATE TABLE `bank_details` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `bank_name` varchar(100) NOT NULL,
  `account_number` varchar(45) DEFAULT NULL,
  `ifsc_code` varchar(45) DEFAULT NULL,
  `bank_code` varchar(45) DEFAULT NULL,
  `bank_branch_name` varchar(45) DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `before_enrol_receipts`
--

CREATE TABLE `before_enrol_receipts` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `customer_id` int NOT NULL,
  `employee_id` int NOT NULL,
  `receipt_no` varchar(255) DEFAULT NULL,
  `received_date` date DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `payment_type_id` int DEFAULT NULL,
  `debit_to` varchar(200) DEFAULT NULL,
  `cheque_no` varchar(200) DEFAULT NULL,
  `cheque_date` date DEFAULT NULL,
  `cheque_clear_return_date` date DEFAULT NULL,
  `cheque_return_amount` decimal(10,4) DEFAULT NULL,
  `cheque_debit_to` int DEFAULT NULL,
  `bank_id` int DEFAULT NULL,
  `bank_branch_name` varchar(200) DEFAULT NULL,
  `transaction_date` date DEFAULT NULL,
  `transaction_no` varchar(200) DEFAULT NULL,
  `remarks` text,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL,
  `receipt_passbook_mode` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `bidding_commission_details`
--

CREATE TABLE `bidding_commission_details` (
  `id` int NOT NULL,
  `bid_id` int DEFAULT NULL,
  `customer_id` int DEFAULT NULL,
  `enrollment_id` int DEFAULT NULL,
  `auction_date` date DEFAULT NULL,
  `collection_type` varchar(100) DEFAULT NULL,
  `amount` decimal(30,2) DEFAULT NULL,
  `status` tinyint DEFAULT '1',
  `deleted_at` varchar(30) DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `receipt_passbook_mode` varchar(30) DEFAULT 'bidding_commission',
  `is_enable` int NOT NULL,
  `payment_type_id` int NOT NULL,
  `cheque_no` varchar(30) NOT NULL,
  `transaction_no` varchar(30) NOT NULL,
  `receipt_no` varchar(30) NOT NULL,
  `penalty` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `bidding_details`
--

CREATE TABLE `bidding_details` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `group_id` int NOT NULL,
  `installment_no` int NOT NULL,
  `customer_id` int NOT NULL,
  `enrollment_id` int DEFAULT NULL,
  `chit_value` decimal(30,2) DEFAULT NULL,
  `bidding_amount` decimal(30,2) DEFAULT NULL COMMENT '1)Register – bidding editable, 2) Non_Register – bidding editable, 3) Slab_Register - bidding readonly 4) Slab_Non_Register – bidding readonly, 5) Profit -  bidding editable',
  `commission_amount` decimal(30,2) DEFAULT NULL,
  `cgst` decimal(30,2) DEFAULT NULL,
  `sgst` decimal(30,2) DEFAULT NULL,
  `igst` decimal(30,2) DEFAULT NULL,
  `gst` decimal(30,2) DEFAULT NULL,
  `total_deduction` decimal(30,2) DEFAULT NULL,
  `pending_due_amount` decimal(30,2) DEFAULT NULL,
  `total_release_amount` decimal(30,2) DEFAULT NULL,
  `customer_released` decimal(30,2) DEFAULT NULL,
  `pending_release` decimal(30,2) DEFAULT NULL,
  `divident_amount` decimal(30,2) DEFAULT NULL,
  `installment_amount` decimal(30,2) DEFAULT NULL,
  `profit_amount` decimal(30,2) DEFAULT NULL,
  `current_installment_amount` decimal(30,2) DEFAULT NULL,
  `auction_date` date DEFAULT NULL,
  `next_auction_date` date DEFAULT NULL,
  `auction_type` varchar(45) DEFAULT NULL COMMENT '1)	Register – No Auction type 2)	Non_Register – duplicate, normal 3)	Slab_Register - No Auction type 4)	Slab_Non_Register – slab,duplicate 5)	Profit - profit,profit_normal,profit_duplicate',
  `payment_generated_on` date DEFAULT NULL,
  `remark` varchar(45) DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint NOT NULL DEFAULT '0',
  `is_original` int NOT NULL DEFAULT '0',
  `receipt_passbook_mode` varchar(30) NOT NULL DEFAULT 'divident',
  `ticket_type` decimal(30,2) NOT NULL DEFAULT '0.00',
  `transaction_no` int NOT NULL,
  `cheque_no` int NOT NULL,
  `receipt_no` varchar(255) NOT NULL,
  `payment_type_id` int NOT NULL,
  `profit_divident` int NOT NULL,
  `penalty` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `bidding_logs`
--

CREATE TABLE `bidding_logs` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `group_id` int NOT NULL,
  `installment_no` int NOT NULL,
  `customer_id` int NOT NULL,
  `enrollment_id` int NOT NULL,
  `amount` decimal(30,2) NOT NULL,
  `created_by` int NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_by` int NOT NULL,
  `updated_at` datetime(6) DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` datetime(6) DEFAULT NULL,
  `status` tinyint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `branches`
--

CREATE TABLE `branches` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `head_office_id` int NOT NULL,
  `branch_name` varchar(100) NOT NULL,
  `start_date` timestamp NULL DEFAULT NULL,
  `branch_code` varchar(45) DEFAULT NULL,
  `state_id` int DEFAULT NULL,
  `district_id` int DEFAULT NULL,
  `city_id` int DEFAULT NULL,
  `pincode` varchar(8) DEFAULT NULL,
  `branch_wise_penalty` int DEFAULT NULL,
  `bonus` int DEFAULT NULL,
  `email_id` varchar(100) DEFAULT NULL,
  `phone_no` varchar(20) DEFAULT NULL,
  `mobile_no` varchar(20) DEFAULT NULL,
  `address_line_1` text,
  `address_line_2` text,
  `landmark` text,
  `prize_subscriber_penalty` int DEFAULT NULL,
  `non_prize_subscriber_penalty` int DEFAULT NULL,
  `bonus_days` int DEFAULT NULL,
  `penalty_days` int DEFAULT NULL,
  `business_agent_target` int DEFAULT NULL,
  `branch_fd_total_months` int DEFAULT NULL,
  `remarks` text,
  `agent_incentive_percent` int DEFAULT NULL,
  `agent_commission_percent` int DEFAULT NULL,
  `customer_incentive_percentage` decimal(30,4) DEFAULT NULL,
  `cgst_percent` decimal(30,4) DEFAULT NULL,
  `sgst_percent` decimal(30,4) DEFAULT NULL,
  `gst_percent` decimal(30,4) DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `case_names`
--

CREATE TABLE `case_names` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `case_name` varchar(255) NOT NULL,
  `remarks` varchar(255) DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `cash_settlements`
--

CREATE TABLE `cash_settlements` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `employee_id` int NOT NULL,
  `settlement_date` date NOT NULL,
  `total_amount` decimal(30,4) NOT NULL,
  `amt_1` decimal(30,4) NOT NULL,
  `amt_2` decimal(30,4) NOT NULL,
  `amt_5` decimal(30,4) NOT NULL,
  `amt_10` decimal(30,4) NOT NULL,
  `amt_20` decimal(30,4) NOT NULL,
  `amt_50` decimal(30,4) NOT NULL,
  `amt_100` decimal(30,4) NOT NULL,
  `amt_200` decimal(30,4) NOT NULL,
  `amt_500` decimal(30,4) NOT NULL,
  `amt_1000` decimal(30,4) NOT NULL,
  `amt_2000` decimal(30,4) NOT NULL,
  `received_amount` decimal(30,4) NOT NULL,
  `collection_employee` int NOT NULL,
  `settlement_mode` varchar(50) NOT NULL,
  `remarks` text NOT NULL,
  `created_by` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text NOT NULL,
  `status` tinyint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `charge_types`
--

CREATE TABLE `charge_types` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `charge_name` varchar(250) NOT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `chit_pledges`
--

CREATE TABLE `chit_pledges` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `customer_id` int NOT NULL,
  `enrollment_id` int DEFAULT NULL,
  `pledge_customer_id` int DEFAULT NULL,
  `pledge_enrollment_id` int DEFAULT NULL,
  `pledge_date` date DEFAULT NULL,
  `unpledge_date` date DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `remarks` int DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `cities`
--

CREATE TABLE `cities` (
  `id` int NOT NULL,
  `state_id` int DEFAULT NULL,
  `district_id` int NOT NULL,
  `city_name` varchar(50) NOT NULL,
  `pincode` varchar(8) NOT NULL,
  `created_by` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `collection_areas`
--

CREATE TABLE `collection_areas` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `collection_area` varchar(100) NOT NULL,
  `area_pincode` varchar(8) DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `collection_area_mappings`
--

CREATE TABLE `collection_area_mappings` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `employee_id` int NOT NULL,
  `collection_area_id` text NOT NULL,
  `remarks` text,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `collection_remarks`
--

CREATE TABLE `collection_remarks` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `remark_name` text NOT NULL,
  `created_by` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text NOT NULL,
  `status` tinyint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `commitment_auctions`
--

CREATE TABLE `commitment_auctions` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `customer_id` int NOT NULL,
  `enrollment_id` int NOT NULL,
  `auction_date` date NOT NULL,
  `installment_no` int NOT NULL,
  `due_amount` decimal(30,4) DEFAULT NULL,
  `installment_amount` decimal(30,4) DEFAULT NULL,
  `remarks` text,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` int NOT NULL,
  `tenant_id` int DEFAULT NULL,
  `country_name` varchar(100) NOT NULL,
  `remarks` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` (`id`, `tenant_id`, `country_name`, `remarks`, `created_at`, `created_by`, `updated_at`, `updated_by`, `deleted_by`, `deleted_at`, `deletion_remark`, `status`) VALUES
(1, 13, 'INDIA', '0', '2020-12-07 18:25:04', 0, '2020-12-07 18:25:04', 0, NULL, NULL, '', 1),
(2, NULL, 'USA', '0', '2021-11-07 15:26:22', NULL, '2022-04-19 13:34:33', NULL, 1, '2022-04-19 13:34:33', '0', 1),
(3, NULL, 'Singapore', '0', '2021-11-07 15:26:43', NULL, '2022-04-19 13:34:38', NULL, 1, '2022-04-19 13:34:38', '0', 1),
(4, NULL, 'Malaysia', '0', '2021-11-07 15:27:09', NULL, '2022-04-19 13:34:44', NULL, 1, '2022-04-19 13:34:44', '0', 1),
(5, NULL, 'Thailand', '0', '2021-11-07 15:27:28', NULL, '2022-04-19 13:34:49', NULL, 1, '2022-04-19 13:34:49', '0', 1),
(6, NULL, 'Dubai', '0', '2021-11-07 15:27:53', NULL, '2022-04-19 13:34:52', NULL, 1, '2022-04-19 13:34:52', '0', 1);

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

--
-- Table structure for table `customer_bank_details`
--

CREATE TABLE `customer_bank_details` (
  `id` int NOT NULL,
  `customer_bank_name` varchar(150) NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `status` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `designations`
--

CREATE TABLE `designations` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `designation_name` varchar(100) NOT NULL,
  `code` varchar(45) DEFAULT NULL,
  `remarks` text,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `devices`
--

CREATE TABLE `devices` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `device_name` varchar(200) DEFAULT NULL,
  `android_id` text NOT NULL,
  `verification_status` tinyint DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `districts`
--

CREATE TABLE `districts` (
  `id` int NOT NULL,
  `state_id` int NOT NULL,
  `district_name` varchar(100) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `districts`
--

INSERT INTO `districts` (`id`, `state_id`, `district_name`, `created_at`, `created_by`, `updated_at`, `updated_by`, `deleted_by`, `deleted_at`, `deletion_remark`, `status`) VALUES
(1, 2, 'Bagalkot', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(3, 2, 'Belagavi', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(4, 2, 'Vijayapura', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(5, 2, 'Dharwad', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(6, 2, 'Gadag', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(7, 2, 'Haveri', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(8, 2, 'Uttara Kannada', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(9, 2, 'Ramanagara', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(10, 2, 'Chikkaballapur', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(11, 2, 'Chitradurga', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(12, 2, 'Davanagere', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(13, 2, 'Kolar', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(14, 2, 'Shivamogga', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(15, 2, 'Tumakuru', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(16, 2, 'Ballari', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(17, 2, 'Bidar', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(18, 2, 'Kalaburagi', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(19, 2, 'Koppal', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(20, 2, 'Raichur', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(21, 2, 'Yadgir', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(22, 2, 'Chamarajanagar', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(23, 2, 'Chikkamagaluru', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(24, 2, 'Dakshina Kannada', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(25, 2, 'Hassan', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(26, 2, 'Kodagu', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(27, 2, 'Mandya', '2019-04-19 23:44:23', 0, '2021-11-18 15:06:56', 0, 1, '2021-11-18 15:06:56', '0', 1),
(28, 2, 'Mysuru', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(29, 2, 'Udupi', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(30, 1, 'Chennai', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(31, 1, 'Vellore', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(32, 1, 'Tiruvannamalai', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(33, 1, 'Cuddalore', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(34, 1, 'Villuppuram', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(35, 1, 'Kancheepuram', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(36, 1, 'Tiruvallur', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(37, 1, 'Kallakurichi', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(38, 1, 'Chengalpattu', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(39, 1, 'Tirupathur', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(40, 1, 'Ranipettai', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(41, 1, 'Thanjavur', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(42, 1, 'Tiruchirappalli', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(43, 1, 'Nagapattinam', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(44, 1, 'Tiruvarur', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(45, 1, 'Perambalur', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(46, 1, 'Ariyalur', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(47, 1, 'Coimbatore', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(48, 1, 'Nilgiris', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(49, 1, 'Salem', '2019-04-19 23:44:23', 0, '2020-12-30 15:19:04', 1, NULL, NULL, '', 1),
(50, 1, 'Dharmapuri', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(51, 1, 'Erode', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(52, 1, 'Karur', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(53, 1, 'Namakkal', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(54, 1, 'Krishnagiri', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(55, 1, 'Tiruppur', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(56, 1, 'Kanyakumari', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(57, 1, 'Madurai', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(58, 1, 'Ramanathapuram', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(59, 1, 'Tirunelveli', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(60, 1, 'Pudukkottai', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(61, 1, 'Virudhunagar', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(62, 1, 'Sivagangai', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(63, 1, 'Dindigul', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(64, 1, 'Thoothukudi', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(65, 1, 'Theni', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(66, 1, 'Tenkasi', '2019-04-19 23:44:23', 0, '2021-05-27 18:19:49', 1, NULL, NULL, '', 1),
(67, 3, 'Alappuzha', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(68, 3, 'Ernakulam', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(69, 3, 'Idukki', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(70, 3, 'Kannur', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(71, 3, 'Kasaragod', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(72, 3, 'Kollam', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(73, 3, 'Kottayam', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(74, 3, 'Kozhikode', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(75, 3, 'Malappuram', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(76, 3, 'Palakkad', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(77, 3, 'Pathanamthitta', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(78, 3, 'Thiruvananthapuram', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(79, 3, 'Thrissur', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(80, 3, 'Wayanad', '2019-04-19 23:44:23', 0, '2019-04-19 23:44:23', 0, NULL, NULL, '', 1),
(85, 2, 'KRISHNA', '2020-11-09 14:47:26', 26, '2020-11-09 14:47:26', 0, NULL, NULL, '', 1),
(86, 2, 'GUNTUR', '2020-11-09 14:47:42', 26, '2020-11-09 14:47:42', 0, NULL, NULL, '', 1),
(87, 1, 'TIRUPUR', '2020-12-07 18:27:09', 55, '2020-12-07 18:27:09', 0, NULL, NULL, '', 1),
(88, 1, 'CUDDALORE', '2020-12-31 16:28:07', 1, '2020-12-31 16:32:33', 1, NULL, NULL, '', 1),
(89, 1, 'Chennai', '2021-02-09 16:05:41', 1, '2021-10-24 09:42:41', 1, NULL, NULL, '', 1),
(97, 2, 'Bangalore', '2021-07-15 10:45:17', 1, '2021-07-15 10:45:17', 0, NULL, NULL, '', 1),
(99, 6, 'Mysore', '2021-10-23 14:10:06', 1, '2021-11-03 10:58:36', 1, NULL, NULL, NULL, 1),
(100, 6, 'Bagalkot', '2021-11-02 11:21:15', 1, '2021-11-02 11:21:15', NULL, NULL, NULL, NULL, 1),
(101, 6, 'Belagavi', '2021-11-02 11:21:47', 1, '2021-11-02 11:21:47', NULL, NULL, NULL, NULL, 1),
(102, 6, 'Bellary', '2021-11-02 11:22:01', 1, '2021-11-02 11:22:01', NULL, NULL, NULL, NULL, 1),
(103, 6, 'Bidar', '2021-11-02 11:22:15', 1, '2021-11-02 11:22:15', NULL, NULL, NULL, NULL, 1),
(104, 6, 'Vijayapura', '2021-11-02 11:22:28', 1, '2021-11-02 11:22:28', NULL, NULL, NULL, NULL, 1),
(105, 6, 'Chamarajanagar', '2021-11-02 11:22:39', 1, '2021-11-02 11:22:39', NULL, NULL, NULL, NULL, 1),
(106, 6, 'Chikballapur', '2021-11-02 11:22:54', 1, '2021-11-02 11:22:54', NULL, NULL, NULL, NULL, 1),
(107, 6, 'Chikmagalur', '2021-11-02 11:23:09', 1, '2021-11-02 11:23:09', NULL, NULL, NULL, NULL, 1),
(108, 6, 'Chitradurga', '2021-11-02 11:23:19', 1, '2021-11-02 11:23:19', NULL, NULL, NULL, NULL, 1),
(109, 6, 'Dakshina Kannada', '2021-11-02 11:23:29', 1, '2021-11-02 11:23:29', NULL, NULL, NULL, NULL, 1),
(110, 6, 'Davanagere', '2021-11-02 11:23:38', 1, '2021-11-02 11:23:38', NULL, NULL, NULL, NULL, 1),
(111, 6, 'Dharwad', '2021-11-02 11:23:48', 1, '2021-11-02 11:23:48', NULL, NULL, NULL, NULL, 1),
(112, 6, 'Gadag', '2021-11-02 11:23:58', 1, '2021-11-02 11:23:58', NULL, NULL, NULL, NULL, 1),
(113, 6, 'Gulbarga', '2021-11-02 11:24:08', 1, '2021-11-02 11:24:08', NULL, NULL, NULL, NULL, 1),
(114, 6, 'Hassan', '2021-11-02 11:24:18', 1, '2021-11-02 11:24:18', NULL, NULL, NULL, NULL, 1),
(115, 6, 'Haveri', '2021-11-02 11:24:28', 1, '2021-11-02 11:24:28', NULL, NULL, NULL, NULL, 1),
(116, 6, 'Kodagu', '2021-11-02 11:24:39', 1, '2021-11-02 11:24:39', NULL, NULL, NULL, NULL, 1),
(117, 6, 'Kolar', '2021-11-02 11:24:53', 1, '2021-11-02 11:24:53', NULL, NULL, NULL, NULL, 1),
(118, 6, 'Koppal', '2021-11-02 11:25:02', 1, '2021-11-02 11:25:02', NULL, NULL, NULL, NULL, 1),
(119, 6, 'Mandya', '2021-11-02 11:25:13', 1, '2021-11-02 11:25:39', 1, NULL, NULL, NULL, 1),
(120, 6, 'Raichur', '2021-11-02 11:26:21', 1, '2021-11-02 11:26:21', NULL, NULL, NULL, NULL, 1),
(121, 6, 'Ramanagara', '2021-11-02 11:52:02', 1, '2021-11-02 11:52:02', NULL, NULL, NULL, NULL, 1),
(122, 6, 'Shimoga', '2021-11-02 11:52:19', 1, '2021-11-02 11:52:19', NULL, NULL, NULL, NULL, 1),
(123, 6, 'Tumkur', '2021-11-02 11:52:33', 1, '2021-11-02 11:52:33', NULL, NULL, NULL, NULL, 1),
(124, 6, 'Udupi', '2021-11-02 11:54:23', 1, '2021-11-02 11:54:23', NULL, NULL, NULL, NULL, 1),
(125, 6, 'Uttara Kannada', '2021-11-02 11:54:39', 1, '2021-11-02 11:54:39', NULL, NULL, NULL, NULL, 1),
(126, 6, 'Vijayanagara', '2021-11-02 11:55:00', 1, '2021-11-02 11:55:00', NULL, NULL, NULL, NULL, 1),
(127, 6, 'Yadgir', '2021-11-02 11:55:10', 1, '2021-11-02 11:55:10', NULL, NULL, NULL, NULL, 1),
(128, 6, 'Bangalore', '2021-11-03 10:57:59', 1, '2021-11-03 10:57:59', NULL, NULL, NULL, NULL, 1),
(129, 6, 'Mysuru (Mysore)', '2021-11-07 15:06:32', 1, '2021-11-07 15:06:32', NULL, NULL, NULL, NULL, 1),
(130, 6, 'Ramanagara', '2021-11-17 13:54:20', 1, '2021-11-17 13:54:20', NULL, NULL, NULL, NULL, 1),
(131, 6, 'Ramanagara', '2021-11-17 13:58:02', 1, '2021-11-17 13:58:02', NULL, NULL, NULL, NULL, 1),
(132, 7, 'KANNUR', '2022-02-15 09:46:43', 1, '2022-02-15 09:46:43', NULL, NULL, NULL, NULL, 1),
(133, 7, 'KASARAGOD', '2022-02-15 09:46:53', 1, '2022-02-15 09:46:53', NULL, NULL, NULL, NULL, 1),
(134, 7, 'PALAKKAD', '2022-02-16 09:46:32', 1, '2022-02-16 09:46:32', NULL, NULL, NULL, NULL, 1),
(135, 8, 'Chennai', '2022-04-19 13:35:51', 1, '2022-06-14 15:41:17', 1, NULL, NULL, NULL, 1);

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

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

CREATE TABLE `documents` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `customer_id` int NOT NULL,
  `enrollment_id` int NOT NULL,
  `collected_employee_id` int DEFAULT NULL,
  `collect_date` date DEFAULT NULL,
  `return_document_date` date DEFAULT NULL,
  `guarantor_id` int DEFAULT NULL,
  `remark` varchar(45) DEFAULT NULL,
  `collected_from` tinyint DEFAULT NULL COMMENT '1=customer, 2=guarantor',
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `document_details`
--

CREATE TABLE `document_details` (
  `id` int NOT NULL,
  `document_id` int NOT NULL,
  `customer_id` int NOT NULL,
  `document_no` varchar(200) DEFAULT NULL,
  `document_path` varchar(200) DEFAULT NULL,
  `document_type` varchar(255) DEFAULT NULL COMMENT '1=pan card, 2=aadhar card, 3=ration card',
  `return_date` datetime DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `deletion_remark` varchar(200) DEFAULT NULL,
  `status` int DEFAULT NULL COMMENT '1=received,2=returned,3=canceled'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `dynamic_menus`
--

CREATE TABLE `dynamic_menus` (
  `id` int UNSIGNED NOT NULL,
  `tenant_id` int NOT NULL,
  `menu_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon_class` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `page_type` int NOT NULL COMMENT '1-crud, 2-report, 3-dashboard, 4- menu head',
  `router_link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `has_submenu` tinyint NOT NULL COMMENT '0=no, 1=yes',
  `tab_type` tinyint(1) NOT NULL COMMENT '1=self, 2=blank',
  `parent_menu_id` int NOT NULL,
  `sort_order` int NOT NULL,
  `created_by` int NOT NULL,
  `updated_by` int NOT NULL,
  `deleted_by` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `dynamic_menus`
--

INSERT INTO `dynamic_menus` (`id`, `tenant_id`, `menu_title`, `icon_class`, `page_type`, `router_link`, `has_submenu`, `tab_type`, `parent_menu_id`, `sort_order`, `created_by`, `updated_by`, `deleted_by`, `created_at`, `updated_at`, `deleted_at`, `deletion_remark`, `status`) VALUES
(1, 1, 'Dashboard', 'ion ion-md-medkit', 3, 'dashboard', 0, 1, 0, 1, 1, 1, 0, '2019-06-11 05:34:32', '2019-06-12 10:08:23', NULL, '', 1),
(2, 1, 'Masters', '', 4, '#', 1, 1, 0, 0, 1, 1, 0, '2019-06-11 05:37:04', '2019-06-11 05:43:11', NULL, '', 1),
(3, 1, 'Employee', '', 1, 'view-employee', 0, 1, 34, 0, 1, 1, 0, '2019-06-11 05:37:23', '2019-06-11 05:40:53', NULL, '', 1),
(4, 1, 'Guarantor', '', 1, 'view-guarantor', 0, 1, 28, 0, 1, 0, 0, '2019-06-11 05:41:25', '2019-06-11 05:41:25', NULL, '', 1),
(5, 1, 'Customer', '', 1, 'view-customer', 0, 1, 28, 0, 1, 1, 0, '2019-06-11 05:41:52', '2019-06-12 10:15:48', NULL, '', 1),
(6, 1, 'Head Office', '', 1, 'view-head-office', 0, 1, 2, 0, 1, 1, 0, '2019-06-11 05:42:23', '2019-06-12 10:16:40', NULL, '', 1),
(7, 1, 'Branch', '', 1, 'view-branch', 0, 1, 2, 0, 1, 1, 0, '2019-06-11 05:42:46', '2019-06-12 10:17:14', NULL, '', 1),
(8, 1, 'Scheme', '', 1, 'view-scheme', 0, 1, 2, 0, 1, 1, 0, '2019-06-11 05:43:34', '2019-06-12 10:17:41', NULL, '', 1),
(9, 1, 'Group', '', 1, 'view-group', 0, 1, 2, 0, 1, 1, 0, '2019-06-11 05:43:59', '2019-06-12 10:18:19', NULL, '', 1),
(10, 1, 'Collection Area', '', 1, 'view-collection-area', 0, 1, 2, 0, 1, 1, 0, '2019-06-11 13:33:53', '2019-06-12 10:18:49', NULL, '', 1),
(11, 1, 'Role', '', 1, 'view-role', 0, 1, 2, 0, 1, 0, 0, '2019-06-12 10:19:27', '2019-06-12 10:19:27', NULL, '', 1),
(12, 1, 'Designation', '', 1, 'view-designation', 0, 1, 2, 0, 1, 0, 0, '2019-06-12 10:19:50', '2019-06-12 10:19:50', NULL, '', 1),
(13, 1, 'Charges Type', '', 1, 'view-charges-type', 0, 1, 2, 0, 1, 0, 0, '2019-06-12 10:20:16', '2019-06-12 10:20:16', NULL, '', 1),
(14, 1, 'Relationship', '', 1, 'view-relationship', 0, 1, 2, 0, 1, 0, 0, '2019-06-12 10:20:41', '2019-06-12 10:20:41', NULL, '', 1),
(15, 1, 'City', '', 1, 'view-city', 0, 1, 2, 0, 1, 0, 0, '2019-06-12 10:21:19', '2019-06-12 10:21:19', NULL, '', 1),
(16, 0, 'Auction On Holidays', '', 1, 'view-auction-on-holidays', 0, 1, 2, 0, 1, 0, 0, '2019-06-12 10:25:04', '2019-06-12 10:25:04', NULL, '', 1),
(17, 0, 'Bank Detail', '', 1, 'view-bank-details', 0, 1, 2, 0, 1, 0, 0, '2019-06-12 10:25:47', '2019-06-12 10:25:47', NULL, '', 1),
(18, 0, 'Petty Cash Type', '', 1, 'view-petty-cash-expense-type', 0, 1, 2, 0, 1, 0, 0, '2019-06-12 10:27:15', '2019-06-12 10:27:15', NULL, '', 1),
(19, 0, 'Slabs', '', 4, '#', 0, 1, 2, 0, 1, 0, 0, '2019-06-12 10:27:55', '2019-06-12 10:27:55', NULL, '', 1),
(20, 0, 'Due Slab', '', 1, 'view-due-slab', 0, 1, 19, 0, 1, 0, 0, '2019-06-12 10:28:49', '2019-06-12 10:28:49', NULL, '', 1),
(21, 0, 'Penalty Slab', '', 1, 'view-penalty-slab', 0, 1, 19, 0, 1, 0, 0, '2019-06-12 10:29:54', '2019-06-12 10:29:54', NULL, '', 1),
(22, 0, 'Bonus Slab', '', 1, 'view-bonus-slab', 0, 1, 19, 0, 1, 0, 0, '2019-06-12 10:30:27', '2019-06-12 10:30:27', NULL, '', 1),
(23, 0, 'Interest Slab', '', 1, 'view-interest-slab', 0, 1, 19, 0, 1, 0, 0, '2019-06-12 10:31:06', '2019-06-12 10:31:06', NULL, '', 1),
(24, 0, 'Payment Slab', '', 1, 'view-payment-slab', 0, 1, 19, 0, 1, 0, 0, '2019-06-12 10:31:35', '2019-06-12 10:31:35', NULL, '', 1),
(25, 0, 'Accounts', '', 4, '#', 1, 1, 0, 0, 1, 0, 0, '2019-06-12 10:32:40', '2019-06-12 10:32:40', NULL, '', 1),
(26, 0, 'Petty Cash Expenses', '', 1, 'view-petty-cash-expense', 0, 1, 62, 0, 1, 0, 0, '2019-06-12 10:33:18', '2019-06-12 10:33:18', NULL, '', 1),
(27, 0, 'Petty Cash Income', '', 1, 'view-petty-cash-income', 0, 1, 62, 0, 1, 0, 0, '2019-06-12 10:33:54', '2019-06-12 10:33:54', NULL, '', 1),
(28, 0, 'Subscriber Management', '', 4, '#', 1, 1, 0, 0, 1, 0, 0, '2019-06-12 10:34:26', '2019-06-12 10:34:26', NULL, '', 1),
(29, 0, 'Customer Enrollment', '', 1, 'view-customer-enrollment', 0, 1, 28, 0, 1, 0, 0, '2019-06-12 10:35:02', '2019-06-12 10:35:02', NULL, '', 1),
(30, 0, 'Auction Detail', '', 1, 'view-auction', 0, 1, 28, 0, 1, 0, 0, '2019-06-12 10:35:27', '2019-06-12 10:35:27', NULL, '', 1),
(31, 0, 'Receipt Detail', '', 1, 'add-receipt', 0, 1, 37, 0, 1, 0, 0, '2019-06-12 10:36:39', '2019-06-12 10:36:39', NULL, '', 1),
(32, 0, 'Commitment Chit Detail', '', 1, 'view-commitment-chit', 0, 1, 28, 0, 1, 0, 0, '2019-06-12 10:37:29', '2019-06-12 10:37:29', NULL, '', 1),
(33, 0, 'Enrol Refund Amount Detail', '', 1, 'view-enrol-refund-amount', 0, 1, 37, 0, 1, 0, 0, '2019-06-12 10:37:59', '2019-06-12 10:37:59', NULL, '', 1),
(34, 0, 'Employee Management', '', 4, '#', 1, 1, 0, 0, 1, 1, 0, '2019-06-12 10:38:25', '2019-06-12 10:39:01', NULL, '', 1),
(35, 0, 'Employee Attendance', '', 1, 'view-employee-attendance', 0, 1, 34, 0, 1, 0, 0, '2019-06-12 10:38:55', '2019-06-12 10:38:55', NULL, '', 1),
(36, 0, 'Employee Login', '', 1, 'view-employee-login', 0, 1, 34, 0, 1, 0, 0, '2019-06-12 10:39:22', '2019-06-12 10:39:22', NULL, '', 1),
(37, 0, 'Transaction Management', '', 4, '#', 1, 1, 0, 0, 1, 0, 0, '2019-06-12 10:40:02', '2019-06-12 10:40:02', NULL, '', 1),
(38, 0, 'Documents', '', 1, 'view-documents', 0, 1, 28, 0, 1, 0, 0, '2019-06-12 10:40:22', '2019-06-12 10:40:22', NULL, '', 1),
(39, 0, 'Commission Payment', '', 1, 'view-commission-payment', 0, 1, 28, 0, 1, 0, 0, '2019-06-12 10:40:41', '2019-06-12 10:40:41', NULL, '', 1),
(40, 0, 'Lead Management', '', 4, '#', 1, 1, 1, 0, 1, 0, 0, '2019-06-12 10:41:03', '2019-06-12 10:41:03', NULL, '', 0),
(41, 0, 'Leads', '', 1, 'view-lead-management', 0, 1, 28, 0, 1, 0, 0, '2019-06-12 10:41:30', '2019-06-12 10:41:30', NULL, '', 1),
(42, 0, 'Reports', '', 4, '#', 1, 1, 0, 0, 1, 0, 0, '2019-06-12 10:41:49', '2019-06-12 10:41:49', NULL, '', 1),
(43, 0, 'Outstanding Report', '', 4, '#', 0, 1, 42, 0, 1, 0, 0, '2019-06-12 10:42:25', '2019-06-12 10:42:25', NULL, '', 1),
(44, 0, 'Groupwise Outstanding Report', '', 2, 'groupwise-outstanding-report', 0, 1, 43, 0, 1, 0, 0, '2019-06-12 10:43:07', '2019-06-12 10:43:07', NULL, '', 1),
(45, 0, 'Payment Report', '', 4, '#', 0, 1, 42, 0, 1, 0, 0, '2019-06-12 10:43:35', '2019-06-12 10:43:35', NULL, '', 1),
(46, 0, 'Prized Money Pending Report', '', 2, 'prized-money-pending-report', 0, 1, 65, 0, 1, 0, 0, '2019-06-12 10:44:14', '2019-06-12 10:44:14', NULL, '', 1),
(47, 0, 'Prized Money Released Report', '', 2, 'prized-money-released-report', 0, 1, 65, 0, 1, 0, 0, '2019-06-12 10:44:41', '2019-06-12 10:44:41', NULL, '', 1),
(48, 0, 'Enrollment Report', '', 2, '#', 0, 1, 42, 0, 1, 0, 0, '2019-06-12 10:45:15', '2019-06-12 10:45:15', NULL, '', 1),
(49, 0, 'Vacant Report', '', 2, 'vacant-report', 0, 1, 48, 0, 1, 0, 0, '2019-06-12 10:45:41', '2019-06-12 10:45:41', NULL, '', 1),
(50, 0, 'Auction Report', '', 2, '#', 0, 1, 42, 0, 1, 1, 0, '2019-06-12 10:46:06', '2019-06-12 10:46:13', NULL, '', 1),
(51, 0, 'Receipt Report', '', 2, 'receipt-report', 0, 1, 66, 0, 1, 0, 0, '2019-06-12 10:46:39', '2019-06-12 10:46:39', NULL, '', 1),
(52, 0, 'Menu Management', '', 1, 'view-dynamic-menus', 0, 1, 0, 0, 1, 0, 0, '2019-06-12 10:47:39', '2019-06-12 10:47:39', NULL, '', 1),
(53, 0, 'Security Permissions', '', 1, 'add-permission', 0, 1, 0, 0, 1, 0, 0, '2019-06-12 10:48:08', '2019-08-02 13:45:08', NULL, '', 1),
(54, 1, 'Tenant', '', 1, 'view-tenant', 0, 1, 2, 0, 1, 1, 0, '2019-06-11 05:42:23', '2019-06-12 10:16:40', NULL, '', 1),
(55, 0, 'Collection Area Mapping', '', 1, 'view-collection-area-mapping', 0, 1, 34, 0, 1, 1, 0, '2019-06-11 05:42:23', '2019-06-12 10:16:40', NULL, '', 1),
(56, 0, 'Commitment Payment Detail', '', 1, 'view-commitment-payment', 0, 1, 28, 0, 1, 1, 0, '2019-06-11 05:42:23', '2019-06-12 10:16:40', NULL, '', 1),
(57, 0, 'Commitment Receipt', '', 1, 'add-commitment-receipt', 0, 1, 37, 0, 1, 0, 0, '2019-06-12 10:40:22', '2019-06-12 10:40:22', NULL, '', 1),
(58, 0, 'Advance Receipt', '', 1, 'add-advanced-receipt', 0, 1, 37, 0, 1, 0, 0, '2019-06-12 10:40:22', '2019-06-12 10:40:22', NULL, '', 1),
(59, 0, 'BidPayment Adjustments', '', 1, 'add-bidpayment-adjustment', 0, 1, 37, 0, 1, 0, 0, '2019-06-12 10:40:22', '2019-06-12 10:40:22', NULL, '', 1),
(60, 0, 'Other Receipt Charges', '', 1, 'view-other-receipt-charges', 0, 1, 37, 0, 1, 0, 0, '2019-06-12 10:40:22', '2019-06-12 10:40:22', NULL, '', 1),
(61, 0, 'Customer Ledger', '', 1, 'customer-ledger', 0, 1, 37, 0, 1, 0, 0, '2019-06-12 10:40:22', '2019-06-12 10:40:22', NULL, '', 1),
(62, 0, 'Other Transactions', '', 4, '#', 1, 1, 0, 0, 1, 0, 0, '2019-06-12 10:40:02', '2019-06-12 10:40:02', NULL, '', 1),
(63, 0, 'Payment Refund Report', '', 2, 'payment-refund-report', 0, 1, 48, 0, 1, 0, 0, '2019-06-12 10:45:41', '2019-06-12 10:45:41', NULL, '', 1),
(64, 0, 'Auction Report', '', 2, 'auction-report', 0, 1, 50, 0, 1, 0, 0, '2019-06-12 10:45:41', '2019-06-12 10:45:41', NULL, '', 1),
(65, 0, 'Payment Report', '', 2, '#', 0, 1, 42, 0, 1, 1, 0, '2019-06-12 10:46:06', '2019-06-12 10:46:13', NULL, '', 1),
(66, 0, 'Transaction Report', '', 2, '#', 0, 1, 42, 0, 1, 1, 0, '2019-06-12 10:46:06', '2019-06-12 10:46:13', NULL, '', 1),
(67, 0, 'Accounts Report', '', 2, '#', 0, 1, 42, 0, 1, 1, 0, '2019-06-12 10:46:06', '2019-06-12 10:46:13', NULL, '', 1),
(68, 0, 'Business Development Report', '', 2, '#', 0, 1, 42, 0, 1, 1, 0, '2019-06-12 10:46:06', '2019-06-12 10:46:13', NULL, '', 1),
(69, 0, 'Enrollment Report', '', 2, 'enrollment-report', 0, 1, 48, 0, 1, 0, 0, '2019-06-12 10:43:07', '2019-06-12 10:43:07', NULL, '', 1),
(70, 0, 'Commitment Payment Report', '', 2, 'commitment-payment-report', 0, 1, 65, 0, 1, 0, 0, '2019-06-12 10:44:14', '2019-06-12 10:44:14', NULL, '', 1),
(71, 0, 'Commitment Pending Report', '', 2, 'commitment-pending-report', 0, 1, 65, 0, 1, 0, 0, '2019-06-12 10:44:14', '2019-06-12 10:44:14', NULL, '', 1),
(72, 0, 'Advance Receipt Report', '', 2, 'advanced-receipt-report', 0, 1, 66, 0, 1, 0, 0, '2019-06-12 10:46:39', '2019-06-12 10:46:39', NULL, '', 1),
(73, 0, 'Available Advance Report', '', 2, 'available-advance-amount-report', 0, 1, 66, 0, 1, 0, 0, '2019-06-12 10:46:39', '2019-06-12 10:46:39', NULL, '', 1),
(74, 0, 'Other Receipt Charges Report', '', 2, 'other-receipt-charges-report', 0, 1, 66, 0, 1, 0, 0, '2019-06-12 10:46:39', '2019-06-12 10:46:39', NULL, '', 1),
(75, 0, 'Day Closing Report', '', 2, 'day-closing-report', 0, 1, 67, 0, 1, 0, 0, '2019-06-12 10:46:39', '2019-06-12 10:46:39', NULL, '', 1),
(76, 0, 'Accounts Report', '', 2, 'accounts-report', 0, 1, 67, 0, 1, 0, 0, '2019-06-12 10:46:39', '2019-06-12 10:46:39', NULL, '', 1),
(77, 0, 'Business Agent Report', '', 2, 'business-agent-report', 0, 1, 68, 0, 1, 0, 0, '2019-06-12 10:46:39', '2019-06-12 10:46:39', NULL, '', 1),
(78, 0, 'Commission Pending Report', '', 2, 'commission-pending-report', 0, 1, 68, 0, 1, 0, 0, '2019-06-12 10:46:39', '2019-06-12 10:46:39', NULL, '', 1),
(79, 0, 'Commission Payment Report', '', 3, 'commission-payment-report', 0, 1, 25, 22, 1, 7, 0, '2019-06-12 10:46:39', '2019-10-01 18:27:05', NULL, '', 1),
(80, 0, 'Collection Activity', '', 1, 'view-feed-back', 0, 1, 28, 0, 7, 0, 0, '2019-10-10 10:35:19', '2019-10-10 10:35:19', NULL, '', 1),
(81, 0, 'Commitment Customer Outstanding', '', 2, 'commitmentcustomer-outstanding-report', 0, 1, 43, 0, 7, 0, 0, '2019-10-10 10:52:22', '2019-10-10 10:52:22', NULL, '', 1),
(82, 0, 'Commitment Receipt Report', '', 2, 'commitment-receipt-report', 0, 1, 66, 0, 7, 0, 0, '2019-10-10 11:41:11', '2019-10-10 11:41:11', NULL, '', 1),
(83, 0, 'Loan Report', '', 2, '#', 0, 1, 42, 0, 7, 0, 0, '2019-10-10 12:53:07', '2019-10-10 12:53:07', NULL, '', 1),
(84, 0, 'Loan Report', '', 2, 'loan-receipt-report', 0, 1, 83, 0, 7, 0, 0, '2019-10-10 12:55:34', '2019-10-10 12:55:34', NULL, '', 1),
(85, 0, 'Loan Management', '', 4, '#', 1, 1, 0, 0, 7, 0, 0, '2019-10-11 05:35:29', '2019-10-11 05:35:29', NULL, '', 1),
(86, 0, 'Loan Details', '', 1, 'view-loan', 0, 1, 85, 0, 7, 0, 0, '2019-10-11 05:41:22', '2019-10-11 05:41:22', NULL, '', 1),
(87, 0, 'Loan Receipt', '', 1, 'add-loan-receipt', 0, 1, 85, 0, 7, 0, 0, '2019-10-11 05:44:14', '2019-10-11 05:44:14', NULL, '', 1),
(88, 0, 'Log Monitoring Report', '', 4, '#', 0, 1, 42, 0, 7, 0, 0, '2019-10-11 07:39:01', '2019-10-11 07:39:01', NULL, '', 1),
(89, 0, 'Log Monitoring Report', '', 2, 'log-monitoring-report', 0, 1, 42, 0, 7, 0, 0, '2019-10-11 07:41:42', '2019-10-11 07:41:42', NULL, '', 1),
(90, 0, 'Source Type', '', 1, 'view-source-type', 0, 1, 2, 0, 7, 0, 0, '2019-10-29 05:11:04', '2019-10-29 05:11:04', NULL, '', 1),
(91, 0, 'Loan customer Report', '', 2, 'loan-customer-report', 0, 1, 42, 0, 7, 0, 0, '2019-10-29 05:17:34', '2019-10-29 05:17:34', NULL, '', 1),
(92, 0, 'Employeewise Outstanding', '', 2, 'employeewise-outstanding-report', 0, 1, 42, 0, 7, 0, 0, '2019-10-29 05:18:46', '2019-10-29 05:18:46', NULL, '', 1),
(93, 0, 'Loan Customerwise Outstanding', '', 2, 'loan-customerwise-outstanding-report', 0, 1, 42, 0, 7, 0, 0, '2019-10-29 05:19:31', '2019-10-29 05:19:31', NULL, '', 1),
(94, 0, 'Loan Day Closing Report', '', 2, 'loan-day-closing-report', 0, 1, 42, 0, 7, 0, 0, '2019-10-29 05:20:25', '2019-10-29 05:20:25', NULL, '', 1),
(95, 0, 'Lead Report', '', 2, 'lead-management-report', 0, 1, 42, 0, 7, 0, 0, '2019-10-29 05:25:50', '2019-10-29 05:25:50', NULL, '', 1),
(96, 0, 'Employee Incentive', '', 1, 'incentive-pending-report', 0, 1, 37, 0, 7, 0, 0, '2019-10-29 06:08:10', '2019-10-29 06:08:10', NULL, '', 1),
(97, 0, 'Employee Incentive Pending Report', '', 2, 'incentive-pending-report', 0, 1, 42, 0, 7, 0, 0, '2019-10-29 06:09:11', '2019-10-29 06:09:11', NULL, '', 1),
(98, 0, 'Employee Incentive payment Report', '', 2, 'incentive-payment-report', 0, 1, 42, 0, 7, 0, 0, '2019-10-29 06:09:50', '2019-10-29 06:09:50', NULL, '', 1),
(99, 0, 'Commission Profit Report', '', 2, 'commission-profit-report', 0, 1, 50, 0, 7, 0, 0, '2019-11-01 09:24:08', '2019-11-01 09:24:08', NULL, '', 1),
(100, 0, 'Loan Customer Document', '', 1, 'view-loan-customer-document', 0, 1, 85, 0, 7, 0, 0, '2019-11-01 09:24:46', '2019-11-01 09:24:46', NULL, '', 1),
(101, 0, 'Employee Salary', '', 1, 'employee-salary', 0, 1, 34, 0, 7, 0, 0, '2019-12-12 11:11:11', '2019-12-12 11:11:11', NULL, '', 1),
(102, 0, 'Account Group', '', 1, 'view-accounting-group', 0, 1, 2, 0, 7, 0, 0, '2019-12-12 11:14:39', '2019-12-12 11:14:39', NULL, '', 1),
(103, 0, 'Account Head', '', 1, 'view-accounting-head', 0, 1, 2, 0, 7, 0, 0, '2019-12-12 11:15:38', '2019-12-12 11:15:38', NULL, '', 1),
(104, 0, 'Expense Income', '', 1, 'add-expenses-income', 0, 1, 37, 0, 7, 0, 0, '2019-12-12 11:16:51', '2019-12-12 11:16:51', NULL, '', 1),
(105, 0, 'Expense Income Report', '', 2, 'add-expenses-income-report', 0, 1, 42, 0, 7, 0, 0, '2019-12-12 11:18:21', '2019-12-12 11:18:21', NULL, '', 1),
(106, 0, 'Trial Balance', '', 2, 'trial-balance', 0, 1, 42, 0, 7, 1, 0, '2019-12-12 11:20:39', '2021-07-26 13:23:24', NULL, '', 1),
(107, 0, 'Balance Sheet', '', 2, 'balance-sheet-report', 0, 1, 42, 0, 7, 1, 0, '2019-12-12 11:22:29', '2021-08-02 11:49:59', NULL, '', 1),
(108, 0, 'Profit Loss', '', 2, 'profit-loss-report', 0, 1, 42, 0, 7, 0, 0, '2019-12-12 11:21:32', '2019-12-12 11:21:32', NULL, '', 1),
(109, 0, 'Commitment Enroll Refund', '', 1, 'add-commitment-enrol', 0, 1, 37, 0, 7, 7, 0, '2019-12-12 11:24:42', '2019-12-12 11:25:17', NULL, '', 1),
(110, 0, 'Bidding Form', '', 1, 'bidding-form', 0, 1, 2, 0, 7, 7, 0, '2019-12-12 11:24:42', '2019-12-12 11:25:17', NULL, '', 1),
(111, 0, 'Bidding Customer', '', 1, '#', 0, 1, 0, 0, 7, 7, 0, '2019-12-12 11:24:42', '2019-12-12 11:25:17', NULL, '', 1);

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

--
-- Table structure for table `employees`
--

CREATE TABLE `employees` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `employee_type` tinyint(1) DEFAULT NULL COMMENT '1 employee ,2 business agent',
  `saluation` varchar(45) DEFAULT NULL,
  `first_name` varchar(45) NOT NULL,
  `last_name` varchar(45) DEFAULT NULL,
  `gender` tinyint NOT NULL COMMENT '1-Male,2-Female',
  `dob` date DEFAULT NULL,
  `photo` longtext,
  `collection_agent` tinyint DEFAULT NULL,
  `phone_no` varchar(20) DEFAULT NULL,
  `mobile_no` varchar(20) DEFAULT NULL,
  `email` varchar(150) DEFAULT NULL,
  `adhar_card` varchar(100) DEFAULT NULL,
  `driving_license` varchar(100) DEFAULT NULL,
  `pan_no` varchar(100) DEFAULT NULL,
  `ration_card_no` varchar(100) DEFAULT NULL,
  `father_name` varchar(45) DEFAULT NULL,
  `spouse_name` varchar(45) DEFAULT NULL,
  `door_no` varchar(45) DEFAULT NULL,
  `building_name` text,
  `address_line_1` text,
  `address_line_2` text,
  `landmark` text,
  `state_id` int DEFAULT NULL,
  `district_id` int DEFAULT NULL,
  `city_id` int DEFAULT NULL,
  `pincode` varchar(8) DEFAULT NULL,
  `communication_door_no` varchar(45) DEFAULT NULL,
  `communication_building_name` varchar(45) DEFAULT NULL,
  `communication_address_line_1` varchar(45) DEFAULT NULL,
  `communication_address_line_2` varchar(45) DEFAULT NULL,
  `communication_land_mark` varchar(45) DEFAULT NULL,
  `communication_state_id` int DEFAULT NULL,
  `communication_district_id` int DEFAULT NULL,
  `communication_city_id` int DEFAULT NULL,
  `communication_pincode` varchar(255) DEFAULT NULL,
  `designation_id` int DEFAULT NULL,
  `role_id` int DEFAULT NULL,
  `pf` varchar(100) DEFAULT NULL,
  `esi` varchar(45) DEFAULT NULL,
  `blood_group` varchar(45) DEFAULT NULL,
  `qualification` varchar(45) DEFAULT NULL,
  `previous_company_details` varchar(255) DEFAULT NULL,
  `joining_date` date DEFAULT NULL,
  `experience` varchar(45) DEFAULT NULL,
  `verification_on_call_by` varchar(45) DEFAULT NULL,
  `last_month_salary` varchar(45) DEFAULT NULL,
  `holder_name` varchar(45) DEFAULT NULL,
  `bank_id` int DEFAULT NULL,
  `account_no` varchar(45) DEFAULT NULL,
  `ifsc_code` varchar(45) DEFAULT NULL,
  `target` int DEFAULT NULL,
  `salary` decimal(30,4) DEFAULT NULL,
  `collection_area_id` tinyint DEFAULT NULL,
  `commission` decimal(30,4) DEFAULT NULL,
  `incentive` decimal(30,4) DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `employee_attendances`
--

CREATE TABLE `employee_attendances` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `employee_id` int NOT NULL,
  `att_date` date DEFAULT NULL,
  `attendance_type` tinyint(1) DEFAULT NULL COMMENT '0-Absent,1-Present',
  `leave_type` tinyint(1) DEFAULT NULL COMMENT '1-Paid,2-Unpaid',
  `afternoon_session` tinyint(1) DEFAULT NULL COMMENT 'leave on Afternoon Session',
  `forenoon_session` tinyint(1) DEFAULT NULL COMMENT 'leave on Forenoon Session',
  `remarks` text,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL,
  `latitude` varchar(150) DEFAULT NULL,
  `longitude` varchar(150) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `employee_monthly_salary_details`
--

CREATE TABLE `employee_monthly_salary_details` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `employee_id` int NOT NULL,
  `working_days` varchar(30) NOT NULL,
  `month_year` varchar(50) DEFAULT NULL,
  `salary` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `remarks` varchar(300) DEFAULT NULL,
  `status` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `employee_payrolls`
--

CREATE TABLE `employee_payrolls` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `employee_id` int NOT NULL,
  `actual_working_days` int NOT NULL,
  `employee_working_days` int NOT NULL,
  `monthly_salary` decimal(30,4) NOT NULL,
  `salary_status` tinyint NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deletion_remark` text NOT NULL,
  `status` tinyint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `employee_salaries`
--

CREATE TABLE `employee_salaries` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `employee_id` int NOT NULL,
  `salary_date` date NOT NULL,
  `salary_amount` decimal(30,4) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `family_codes`
--

CREATE TABLE `family_codes` (
  `id` int NOT NULL,
  `family_code` varchar(100) NOT NULL,
  `status` tinyint DEFAULT '1',
  `tenant_id` int NOT NULL DEFAULT '1',
  `branch_id` int NOT NULL DEFAULT '1',
  `remarks` varchar(30) DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `field_investigations`
--

CREATE TABLE `field_investigations` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `customer_id` int NOT NULL,
  `employee_id` int NOT NULL,
  `investigation_date` date NOT NULL,
  `investigation_mode` varchar(50) NOT NULL,
  `verified_type` varchar(50) NOT NULL,
  `comments` text NOT NULL,
  `verification_file` varchar(255) NOT NULL,
  `type_of_row` varchar(100) NOT NULL,
  `reference_id` varchar(150) NOT NULL,
  `reference_type` varchar(150) NOT NULL,
  `created_by` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text NOT NULL,
  `status` tinyint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `file_names`
--

CREATE TABLE `file_names` (
  `id` int NOT NULL,
  `tenant_id` int DEFAULT NULL,
  `parent_id` int DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `file_name` varchar(100) DEFAULT NULL,
  `menu_order` int DEFAULT NULL,
  `level` varchar(45) DEFAULT NULL,
  `icon` longtext,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `followups`
--

CREATE TABLE `followups` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `lead_management_id` int DEFAULT NULL,
  `employee_id` int DEFAULT NULL,
  `followup_date` date DEFAULT NULL,
  `remarks` text,
  `next_followup_date` date DEFAULT NULL,
  `followup_status_type_id` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `followup_status_types`
--

CREATE TABLE `followup_status_types` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `followup_status_name` varchar(100) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `followup_status_types`
--

INSERT INTO `followup_status_types` (`id`, `tenant_id`, `followup_status_name`, `created_at`, `created_by`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`, `deletion_remark`, `status`) VALUES
(1, 1, 'Won', '2019-05-15 06:30:43', 0, NULL, NULL, NULL, NULL, '', 1),
(2, 1, 'In Followup', '2019-05-18 11:16:40', 0, NULL, NULL, NULL, NULL, '', 1),
(3, 1, 'Drop', '2019-05-15 06:30:50', 0, NULL, NULL, NULL, NULL, '', 1);

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

--
-- Table structure for table `groups`
--

CREATE TABLE `groups` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `group_type` tinyint NOT NULL COMMENT '1=Register,2=Non_Register,3=Slab_Register,4=Slab_Non_Register,5=Profit,6=2nd_due',
  `group_name` varchar(100) NOT NULL,
  `scheme_id` int NOT NULL,
  `auction_date` varchar(5) NOT NULL,
  `auction_time` varchar(10) NOT NULL,
  `starting_date` date NOT NULL,
  `termination_date` date DEFAULT NULL,
  `first_due_date` date DEFAULT NULL,
  `commission_percent` decimal(30,4) NOT NULL,
  `fd_number` varchar(45) NOT NULL,
  `total_fd` decimal(30,4) NOT NULL,
  `company_fd` decimal(30,4) NOT NULL,
  `rate_of_interest` decimal(30,4) NOT NULL,
  `fd_rate` decimal(30,4) NOT NULL,
  `fd_date` date DEFAULT NULL,
  `maturity_amount` decimal(30,4) NOT NULL,
  `fd_bank_id` int NOT NULL,
  `fd_branch` varchar(150) NOT NULL,
  `pso_number` varchar(100) NOT NULL,
  `pso_date` date DEFAULT NULL,
  `blaw_number` varchar(150) NOT NULL,
  `blaw_date` date DEFAULT NULL,
  `cheque_no` varchar(50) NOT NULL,
  `company_chit` int NOT NULL,
  `group_base_penalty` decimal(30,4) NOT NULL COMMENT 'percentage',
  `group_base_bonus` decimal(30,4) NOT NULL COMMENT 'percentage',
  `group_base_interest` decimal(30,4) DEFAULT NULL COMMENT 'percentage',
  `group_base_dividend_cancel_days` int DEFAULT NULL,
  `group_penalty_days` int DEFAULT NULL,
  `group_bonus_days` int DEFAULT NULL,
  `group_base_incentive_percentage` decimal(30,4) DEFAULT NULL,
  `fd_renewal_date` timestamp NULL DEFAULT NULL,
  `commit_date` timestamp NULL DEFAULT NULL,
  `is_filled` tinyint DEFAULT NULL COMMENT '0=yes,1=no',
  `group_status` tinyint DEFAULT NULL COMMENT '0=non_closed,1=closed',
  `group_pending_ticket` decimal(10,2) DEFAULT NULL COMMENT 'vacant_count',
  `is_first_auction_complete` tinyint DEFAULT NULL COMMENT '0=yes,1=no',
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `group_bidding_details`
--

CREATE TABLE `group_bidding_details` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `group_id` int NOT NULL,
  `installment_no` int DEFAULT NULL,
  `status` tinyint DEFAULT NULL COMMENT '1= complete, 2= progress, 3=yet to start',
  `submit_enable` int NOT NULL,
  `progress` tinyint DEFAULT '0' COMMENT '1= enable, 2= disable',
  `created_by` int DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `guarantor_relations`
--

CREATE TABLE `guarantor_relations` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `customer_id` int NOT NULL,
  `enrollment_id` int DEFAULT NULL,
  `guarantor_id` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `head_offices`
--

CREATE TABLE `head_offices` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `head_name` varchar(100) NOT NULL,
  `head_code` varchar(45) DEFAULT NULL,
  `mobile_no` varchar(20) DEFAULT NULL,
  `phone_no` varchar(20) DEFAULT NULL,
  `email_id` varchar(100) NOT NULL,
  `address_line_1` text,
  `address_line_2` text,
  `landmark` text,
  `state_id` int NOT NULL DEFAULT '0',
  `district_id` int NOT NULL DEFAULT '0',
  `city_id` int NOT NULL DEFAULT '0',
  `pincode` varchar(8) NOT NULL DEFAULT '0',
  `remarks` text,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by` int NOT NULL DEFAULT '0',
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int NOT NULL DEFAULT '0',
  `deleted_by` int NOT NULL DEFAULT '0',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `head_offices`
--

INSERT INTO `head_offices` (`id`, `tenant_id`, `head_name`, `head_code`, `mobile_no`, `phone_no`, `email_id`, `address_line_1`, `address_line_2`, `landmark`, `state_id`, `district_id`, `city_id`, `pincode`, `remarks`, `created_at`, `created_by`, `updated_at`, `updated_by`, `deleted_by`, `deleted_at`, `deletion_remark`, `status`) VALUES
(1, 37, 'SBMA CHIT FUNDS PRIVATE LIMITED-MALUMICHAMPATTI (HO)', 'HO-00001', '9790489096', '0', 'Info@sbma.in', 'No.2/516C,CPV Complex,Thiruvalluvar Nagar,', 'Malumichampatti', 'Near,Win Supermarket', 8, 0, 0, '0', '0', '2022-07-12 12:58:20', 1, '2022-07-12 12:58:20', 0, 0, NULL, NULL, 1);

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

--
-- Table structure for table `hierarchies`
--

CREATE TABLE `hierarchies` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `under_id` int NOT NULL,
  `name` varchar(200) NOT NULL,
  `email` varchar(150) NOT NULL,
  `level_id` int NOT NULL,
  `level_value` varchar(200) NOT NULL,
  `remarks` text NOT NULL,
  `created_by` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text NOT NULL,
  `status` tinyint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `interest_messages`
--

CREATE TABLE `interest_messages` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `customer_id` int NOT NULL,
  `scheme_id` int NOT NULL,
  `group_id` int NOT NULL,
  `remarks` text NOT NULL,
  `interested_date` varchar(50) NOT NULL,
  `for_notification` int NOT NULL COMMENT '0=N_shown,1=shown',
  `action` int NOT NULL COMMENT '0=N_Read,1=Read',
  `created_by` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_by` int NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text NOT NULL,
  `status` tinyint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `lawyers`
--

CREATE TABLE `lawyers` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `lawyer_name` varchar(255) NOT NULL,
  `lawyer_percentage` varchar(255) NOT NULL,
  `mobile_no` varchar(255) NOT NULL,
  `remarks` varchar(255) DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `loan_asset_details`
--

CREATE TABLE `loan_asset_details` (
  `id` int NOT NULL,
  `loan_document_id` int NOT NULL,
  `customer_id` int NOT NULL,
  `asset_name` varchar(200) NOT NULL,
  `asset_path` varchar(200) NOT NULL,
  `asset_value` decimal(30,4) NOT NULL,
  `return_date` datetime NOT NULL,
  `created_by` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` varchar(200) NOT NULL,
  `status` int NOT NULL COMMENT '1=received,2=returned,3=canceled'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `loan_details`
--

CREATE TABLE `loan_details` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `customer_id` int NOT NULL,
  `collect_employee_id` int NOT NULL,
  `loan_type` int NOT NULL COMMENT '1-Balance,2-Loan',
  `reference_grp` varchar(250) NOT NULL,
  `loan_amount` decimal(30,0) NOT NULL,
  `paid_amount` decimal(30,4) NOT NULL,
  `pending_amount` decimal(30,4) NOT NULL,
  `emi_months` int NOT NULL,
  `loan_date` date NOT NULL,
  `interest_percentage` decimal(30,4) NOT NULL,
  `completion_date` date NOT NULL,
  `interest_type` int NOT NULL COMMENT '1-Fixed,2-Daily,3-Monthly',
  `interest_amount` decimal(30,4) NOT NULL,
  `payment_type_id` int NOT NULL,
  `debit_to` varchar(250) NOT NULL,
  `cheque_no` varchar(50) NOT NULL,
  `cheque_date` date NOT NULL,
  `cheque_return_amount` decimal(30,4) NOT NULL,
  `cheque_clear_return_date` date NOT NULL,
  `cheque_debit_to` varchar(250) NOT NULL,
  `bank_name_id` int NOT NULL,
  `bank_branch_name` varchar(200) NOT NULL,
  `transaction_no` varchar(50) NOT NULL,
  `transaction_date` date NOT NULL,
  `remarks` text NOT NULL,
  `created_by` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text NOT NULL,
  `status` tinyint NOT NULL COMMENT '0-Deleted,1-Active,2-Closed'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `loan_documents`
--

CREATE TABLE `loan_documents` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `customer_id` int NOT NULL,
  `enrollment_id` int NOT NULL,
  `collected_employee_id` int NOT NULL,
  `collect_date` date NOT NULL,
  `return_document_date` date NOT NULL,
  `guarantor_id` int NOT NULL,
  `remark` varchar(45) NOT NULL,
  `collected_from` tinyint NOT NULL COMMENT '1=customer, 2=guarantor',
  `created_by` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text NOT NULL,
  `status` tinyint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `loan_document_details`
--

CREATE TABLE `loan_document_details` (
  `id` int NOT NULL,
  `loan_document_id` int NOT NULL,
  `customer_id` int NOT NULL,
  `document_no` varchar(200) NOT NULL,
  `document_path` varchar(200) NOT NULL,
  `document_type` int NOT NULL COMMENT '1=pan card, 2=aadhar card, 3=ration card',
  `return_date` datetime NOT NULL,
  `created_by` int NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_by` int NOT NULL,
  `updated_at` datetime NOT NULL,
  `deleted_by` int NOT NULL,
  `deleted_at` datetime NOT NULL,
  `deletion_remark` varchar(200) NOT NULL,
  `status` int NOT NULL COMMENT '1=received,2=returned,3=canceled'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `loan_receipts`
--

CREATE TABLE `loan_receipts` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `customer_id` int NOT NULL,
  `employee_id` int NOT NULL,
  `loan_id` int NOT NULL,
  `reference_grp` varchar(250) NOT NULL,
  `receipt_date` date NOT NULL,
  `offline` varchar(10) NOT NULL,
  `receipt_no` varchar(45) NOT NULL,
  `amount` decimal(30,4) NOT NULL,
  `interest_amount` decimal(30,4) NOT NULL,
  `payment_type_id` int NOT NULL,
  `debit_to` varchar(250) NOT NULL,
  `cheque_no` varchar(50) NOT NULL,
  `cheque_date` date NOT NULL,
  `cheque_return_amount` decimal(30,4) NOT NULL,
  `cheque_clear_return_date` date NOT NULL,
  `cheque_debit_to` varchar(150) NOT NULL,
  `bank_name_id` int NOT NULL,
  `bank_branch_name` varchar(50) NOT NULL,
  `transaction_no` int NOT NULL,
  `transaction_date` date NOT NULL,
  `transaction_bill` varchar(45) NOT NULL,
  `transaction_book` varchar(45) NOT NULL,
  `receipt_mode` varchar(50) NOT NULL,
  `remarks` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by` int NOT NULL,
  `updated_by` int NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text NOT NULL,
  `status` tinyint NOT NULL COMMENT '0=inactive, 1= active, 2=pending, 3=return'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `log_monitoring_tables`
--

CREATE TABLE `log_monitoring_tables` (
  `id` int NOT NULL,
  `module_name` varchar(200) NOT NULL,
  `table_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by` int NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int NOT NULL,
  `deletion_remarks` text NOT NULL,
  `status` tinyint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `message_logs`
--

CREATE TABLE `message_logs` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `group_id` int NOT NULL,
  `installment_no` int DEFAULT NULL,
  `message` varchar(100) DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `status` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `minutes_of_auctions`
--

CREATE TABLE `minutes_of_auctions` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `group_id` int NOT NULL,
  `installment_no` int NOT NULL,
  `customer_id` int NOT NULL,
  `enrollment_id` int NOT NULL,
  `chit_value` decimal(30,4) NOT NULL,
  `bidding_amount` decimal(30,4) NOT NULL COMMENT '1)Register – bidding editable, 2) Non_Register – bidding editable, 3) Slab_Register - bidding readonly 4) Slab_Non_Register – bidding readonly, 5) Profit -  bidding editable',
  `commission_amount` decimal(30,4) NOT NULL,
  `cgst` decimal(30,4) DEFAULT NULL,
  `sgst` decimal(30,4) DEFAULT NULL,
  `igst` decimal(30,4) DEFAULT NULL,
  `gst` decimal(30,4) DEFAULT NULL,
  `total_deduction` decimal(30,4) DEFAULT NULL,
  `pending_due_amount` decimal(30,4) DEFAULT NULL,
  `total_release_amount` decimal(30,4) DEFAULT NULL,
  `customer_released` decimal(30,4) DEFAULT NULL,
  `pending_release` decimal(30,4) DEFAULT NULL,
  `divident_amount` decimal(30,4) DEFAULT NULL,
  `installment_amount` decimal(30,4) DEFAULT NULL,
  `profit_amount` decimal(30,4) DEFAULT NULL,
  `current_installment_amount` decimal(30,4) DEFAULT NULL,
  `auction_date` date DEFAULT NULL,
  `next_auction_date` date DEFAULT NULL,
  `auction_type` varchar(45) DEFAULT NULL COMMENT '1)	Register – No Auction type 2)	Non_Register – duplicate, normal 3)	Slab_Register - No Auction type 4)	Slab_Non_Register – slab,duplicate 5)	Profit - profit,profit_normal,profit_duplicate',
  `payment_generated_on` date DEFAULT NULL,
  `remark` varchar(45) DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `cust_id` int NOT NULL,
  `enrol_id` int NOT NULL,
  `approval_type` varchar(100) NOT NULL,
  `approval_id` int NOT NULL,
  `employee_id` int NOT NULL,
  `approved_on` date NOT NULL,
  `approved_by_for_notification` int NOT NULL,
  `created_by` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text NOT NULL,
  `status` tinyint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `other_charges`
--

CREATE TABLE `other_charges` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `customer_id` int NOT NULL,
  `enrollment_id` int NOT NULL,
  `employee_id` int NOT NULL,
  `received_date` date NOT NULL,
  `charge_type_id` int DEFAULT NULL,
  `amount` decimal(10,0) DEFAULT NULL,
  `payment_type_id` int DEFAULT NULL,
  `debit_to` varchar(200) DEFAULT NULL,
  `cheque_no` varchar(200) DEFAULT NULL,
  `cheque_date` date DEFAULT NULL,
  `cheque_clear_return_date` date DEFAULT NULL,
  `cheque_return_amount` decimal(30,4) DEFAULT NULL,
  `cheque_debit_to` int DEFAULT NULL,
  `bank_id` int DEFAULT NULL,
  `bank_branch_name` varchar(200) DEFAULT NULL,
  `transaction_date` date DEFAULT NULL,
  `transaction_no` varchar(200) DEFAULT NULL,
  `remarks` text,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

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

CREATE TABLE `payments` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `group_id` int NOT NULL,
  `bidding_id` int DEFAULT NULL,
  `customer_id` int DEFAULT NULL,
  `enrollment_id` int DEFAULT NULL,
  `payment_date` date DEFAULT NULL,
  `employee_id` int DEFAULT NULL,
  `payment_for` tinyint(1) DEFAULT NULL COMMENT '1 = bidding amount, 2 = advance bidding amount, 3 = chit return, 4 = advance return amount, 5 = chit amount transfer, 6 = advance amount transfer, 7 = commitment payment',
  `payment_type_id` int DEFAULT NULL,
  `total_amount` decimal(30,2) DEFAULT NULL,
  `bank_id` int DEFAULT NULL,
  `bank_branch_name` varchar(45) DEFAULT NULL,
  `cheque_no` varchar(45) DEFAULT NULL,
  `cheque_date` date DEFAULT NULL,
  `cheque_status` varchar(45) DEFAULT NULL,
  `cheque_clear_return_date` date DEFAULT NULL,
  `cheque_return_amount` decimal(30,2) DEFAULT NULL,
  `cheque_debit_to` int DEFAULT NULL,
  `transaction_no` varchar(100) DEFAULT NULL,
  `transaction_date` timestamp NULL DEFAULT NULL,
  `cancel_penalty_amount` decimal(30,2) DEFAULT NULL,
  `debit_to` varchar(100) DEFAULT NULL,
  `remarks` text,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL,
  `transfer_customer_id` int DEFAULT NULL,
  `transfer_enrollment_id` int DEFAULT NULL,
  `receipt_passbook_mode` varchar(30) DEFAULT 'payment',
  `receipt_no` varchar(255) NOT NULL,
  `penalty` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `payment_minutes`
--

CREATE TABLE `payment_minutes` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `group_id` int NOT NULL,
  `bidding_id` int NOT NULL,
  `customer_id` int NOT NULL,
  `enrollment_id` int NOT NULL,
  `payment_date` date NOT NULL,
  `employee_id` int NOT NULL,
  `payment_for` tinyint(1) NOT NULL COMMENT '1 = bidding amount, 2 = advance bidding amount, 3 = chit return, 4 = advance return amount, 5 = chit amount transfer, 6 = advance amount transfer, 7 = commitment payment',
  `payment_type_id` int NOT NULL,
  `total_amount` decimal(30,4) NOT NULL,
  `bank_id` int NOT NULL,
  `bank_branch_name` varchar(45) NOT NULL,
  `cheque_no` varchar(45) NOT NULL,
  `cheque_date` date NOT NULL,
  `cheque_status` varchar(45) NOT NULL,
  `cheque_clear_return_date` date NOT NULL,
  `cheque_return_amount` decimal(30,4) NOT NULL,
  `cheque_debit_to` int NOT NULL,
  `transaction_no` varchar(100) NOT NULL,
  `transaction_date` date NOT NULL,
  `cancel_penalty_amount` decimal(30,4) NOT NULL,
  `debit_to` varchar(100) NOT NULL,
  `remarks` text NOT NULL,
  `created_by` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text NOT NULL,
  `status` tinyint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `payment_types`
--

CREATE TABLE `payment_types` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `payment_name` varchar(100) DEFAULT NULL,
  `remarks` text,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `payment_types`
--

INSERT INTO `payment_types` (`id`, `tenant_id`, `payment_name`, `remarks`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted_by`, `deleted_at`, `deletion_remark`, `status`) VALUES
(1, 1, 'Cash', '', 1, NULL, 1, NULL, NULL, NULL, '', 1),
(2, 1, 'Cheque', '', 1, NULL, 1, NULL, NULL, NULL, '', 1),
(3, 1, 'D.D', '', 1, NULL, 1, NULL, NULL, NULL, '', 1),
(4, 1, 'RTGS/NEFT', '', 1, NULL, 1, NULL, NULL, NULL, '', 1),
(5, 1, 'Card', '', 1, '2019-05-29 00:00:00', 1, '2019-05-29 00:00:00', NULL, NULL, '', 1),
(6, 1, 'B.P.Adjustment', '', 1, NULL, 1, NULL, NULL, NULL, '', 1),
(7, 1, 'Advanced Adjustments', '', 1, NULL, 1, NULL, NULL, NULL, '', 1);

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

--
-- Table structure for table `petty_cash_expenses`
--

CREATE TABLE `petty_cash_expenses` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `avaliable_cash` decimal(30,4) NOT NULL,
  `employee_id` int NOT NULL,
  `expenses_date` date NOT NULL,
  `expenses_amount` decimal(30,4) NOT NULL,
  `expenses_type_id` int NOT NULL,
  `payment_type_id` int NOT NULL,
  `debit_to` varchar(200) NOT NULL,
  `cheque_no` varchar(200) NOT NULL,
  `cheque_date` date NOT NULL,
  `cheque_clear_return_date` date NOT NULL,
  `cheque_return_amount` decimal(30,4) NOT NULL,
  `cheque_debit_to` int NOT NULL,
  `bank_id` int NOT NULL,
  `bank_branch_name` varchar(200) NOT NULL,
  `transaction_date` date NOT NULL,
  `transaction_no` varchar(200) NOT NULL,
  `remarks` text NOT NULL,
  `created_by` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text NOT NULL,
  `status` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `petty_cash_expense_types`
--

CREATE TABLE `petty_cash_expense_types` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `expenses_type` varchar(150) NOT NULL,
  `remarks` text,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `petty_cash_incomes`
--

CREATE TABLE `petty_cash_incomes` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `available_cash` decimal(30,4) DEFAULT NULL,
  `received_date` date DEFAULT NULL,
  `amount_received` decimal(30,4) DEFAULT NULL,
  `payment_type_id` int DEFAULT NULL,
  `debit_to` varchar(200) DEFAULT NULL,
  `cheque_no` varchar(200) DEFAULT NULL,
  `cheque_date` date DEFAULT NULL,
  `cheque_clear_return_date` date DEFAULT NULL,
  `cheque_return_amount` decimal(30,4) DEFAULT NULL,
  `cheque_debit_to` int DEFAULT NULL,
  `bank_id` int DEFAULT NULL,
  `bank_branch_name` varchar(200) DEFAULT NULL,
  `transaction_date` date DEFAULT NULL,
  `transaction_no` varchar(200) DEFAULT NULL,
  `remarks` text,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `receipts`
--

CREATE TABLE `receipts` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `other_branch` tinyint(1) NOT NULL COMMENT '1= other branch',
  `customer_id` int NOT NULL,
  `enrollment_id` int NOT NULL,
  `group_id` int NOT NULL,
  `ticket_no` varchar(50) NOT NULL,
  `employee_id` int NOT NULL,
  `employee_branch_id` int DEFAULT NULL,
  `receipt_no` varchar(45) DEFAULT NULL,
  `offline_receipt_no` varchar(45) DEFAULT NULL,
  `adjust_id` int DEFAULT NULL,
  `amount` decimal(30,0) DEFAULT NULL,
  `receipt_date` date DEFAULT NULL,
  `type_of_collection` varchar(45) DEFAULT NULL,
  `payment_type_id` int DEFAULT NULL,
  `debit_to` varchar(200) DEFAULT NULL,
  `cheque_no` varchar(45) DEFAULT NULL,
  `cheque_date` timestamp NULL DEFAULT NULL,
  `cheque_return_amount` decimal(30,2) DEFAULT NULL,
  `cheque_clear_return_date` date DEFAULT NULL,
  `cheque_debit_to` int DEFAULT NULL,
  `bank_name_id` int DEFAULT NULL,
  `branch_name` varchar(150) DEFAULT NULL,
  `transaction_no` int DEFAULT NULL,
  `transaction_date` date DEFAULT NULL,
  `transaction_bill` varchar(45) DEFAULT NULL,
  `transaction_book` varchar(45) DEFAULT NULL,
  `neft_adjust_id` int DEFAULT NULL,
  `receipt_mode` varchar(45) DEFAULT NULL,
  `receipt_time` time DEFAULT NULL,
  `accounts_date` timestamp NULL DEFAULT NULL,
  `printed` int DEFAULT NULL,
  `auction_id` int DEFAULT NULL,
  `installment_no` varchar(200) DEFAULT NULL,
  `pending_days` int DEFAULT NULL,
  `penalty` decimal(30,0) DEFAULT NULL,
  `bonus` decimal(30,0) DEFAULT NULL,
  `discount` decimal(30,0) DEFAULT NULL,
  `received_amount` decimal(30,0) DEFAULT NULL,
  `cancel_dividend_amount` decimal(30,0) DEFAULT NULL,
  `advance_available` int DEFAULT NULL COMMENT '0-No, 1-Yes',
  `remarks` text,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL COMMENT '0=inactive, 1= active, 2=pending, 3=return',
  `receipt_passbook_mode` varchar(30) DEFAULT 'rcpt',
  `submit_to_bank` int DEFAULT NULL,
  `balance_advance_amount` decimal(30,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `receipts_1`
--

CREATE TABLE `receipts_1` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `other_branch` tinyint(1) NOT NULL COMMENT '1= other branch',
  `customer_id` int NOT NULL,
  `enrollment_id` int NOT NULL,
  `group_id` int NOT NULL,
  `ticket_no` varchar(50) NOT NULL,
  `employee_id` int NOT NULL,
  `employee_branch_id` int NOT NULL,
  `receipt_no` varchar(45) NOT NULL,
  `offline_receipt_no` varchar(45) NOT NULL,
  `adjust_id` int NOT NULL,
  `amount` decimal(30,4) NOT NULL,
  `receipt_date` date NOT NULL,
  `type_of_collection` varchar(45) NOT NULL,
  `payment_type_id` int NOT NULL,
  `debit_to` varchar(200) NOT NULL,
  `cheque_no` varchar(45) NOT NULL,
  `cheque_date` date NOT NULL,
  `cheque_return_amount` decimal(30,4) NOT NULL,
  `cheque_clear_return_date` date NOT NULL,
  `cheque_debit_to` int NOT NULL,
  `bank_name_id` int NOT NULL,
  `branch_name` varchar(150) NOT NULL,
  `transaction_no` int NOT NULL,
  `transaction_date` date NOT NULL,
  `transaction_bill` varchar(45) NOT NULL,
  `transaction_book` varchar(45) NOT NULL,
  `neft_adjust_id` int NOT NULL,
  `receipt_mode` varchar(45) NOT NULL,
  `receipt_time` time NOT NULL,
  `accounts_date` date NOT NULL,
  `printed` int NOT NULL,
  `auction_id` int NOT NULL,
  `installment_no` varchar(200) NOT NULL,
  `pending_days` int NOT NULL,
  `penalty` decimal(30,4) NOT NULL,
  `bonus` decimal(30,4) NOT NULL,
  `discount` decimal(30,4) NOT NULL,
  `received_amount` decimal(30,4) NOT NULL,
  `cancel_dividend_amount` decimal(30,4) NOT NULL,
  `advance_available` int NOT NULL COMMENT '0-No, 1-Yes',
  `remarks` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by` int NOT NULL,
  `updated_by` int NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text NOT NULL,
  `status` tinyint NOT NULL COMMENT '0=inactive, 1= active, 2=pending, 3=return'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `receipts_2`
--

CREATE TABLE `receipts_2` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `other_branch` tinyint(1) NOT NULL COMMENT '1= other branch',
  `customer_id` int NOT NULL,
  `enrollment_id` int NOT NULL,
  `group_id` int NOT NULL,
  `ticket_no` varchar(50) NOT NULL,
  `employee_id` int NOT NULL,
  `employee_branch_id` int NOT NULL,
  `receipt_no` varchar(45) NOT NULL,
  `offline_receipt_no` varchar(45) NOT NULL,
  `adjust_id` int NOT NULL,
  `amount` decimal(30,4) NOT NULL,
  `receipt_date` date NOT NULL,
  `type_of_collection` varchar(45) NOT NULL,
  `payment_type_id` int NOT NULL,
  `debit_to` varchar(200) NOT NULL,
  `cheque_no` varchar(45) NOT NULL,
  `cheque_date` date NOT NULL,
  `cheque_return_amount` decimal(30,4) NOT NULL,
  `cheque_clear_return_date` date NOT NULL,
  `bank_name_id` int NOT NULL,
  `branch_name` varchar(150) NOT NULL,
  `transaction_no` int NOT NULL,
  `transaction_date` date NOT NULL,
  `transaction_bill` varchar(45) NOT NULL,
  `transaction_book` varchar(45) NOT NULL,
  `neft_adjust_id` int NOT NULL,
  `receipt_mode` varchar(45) NOT NULL,
  `receipt_time` time NOT NULL,
  `accounts_date` date NOT NULL,
  `printed` int NOT NULL,
  `auction_id` int NOT NULL,
  `installment_no` varchar(200) NOT NULL,
  `pending_days` int NOT NULL,
  `penalty` decimal(30,4) NOT NULL,
  `bonus` decimal(30,4) NOT NULL,
  `discount` decimal(30,4) NOT NULL,
  `received_amount` decimal(30,4) NOT NULL,
  `remarks` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by` int NOT NULL,
  `updated_by` int NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text NOT NULL,
  `status` tinyint NOT NULL COMMENT '0=inactive, 1= active, 2=pending'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `relationships`
--

CREATE TABLE `relationships` (
  `id` int NOT NULL,
  `tenant_id` int DEFAULT NULL,
  `relationship_name` varchar(150) DEFAULT NULL,
  `gender` varchar(45) DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `remarks`
--

CREATE TABLE `remarks` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `customer_id` int NOT NULL,
  `employee_id` int NOT NULL,
  `remark_id` int NOT NULL,
  `remark_date` date NOT NULL,
  `remark_time` time NOT NULL,
  `next_followup_date` date NOT NULL,
  `followup_status` tinyint NOT NULL COMMENT '	1-Completed, 2- Pending',
  `created_by` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text NOT NULL,
  `status` tinyint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

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

CREATE TABLE `roles` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `role_name` varchar(100) DEFAULT NULL,
  `role_code` varchar(45) DEFAULT NULL,
  `role_type_id` int DEFAULT NULL,
  `remarks` text,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `role_permissions`
--

CREATE TABLE `role_permissions` (
  `id` int UNSIGNED NOT NULL,
  `tenant_id` int NOT NULL,
  `role_id` int NOT NULL,
  `role_access` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '1=1dd,2=edit,3=view,4=delete',
  `created_by` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deletion_remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL COMMENT '0=inactive, 1=active'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `role_types`
--

CREATE TABLE `role_types` (
  `id` int NOT NULL,
  `role_type_name` varchar(100) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text NOT NULL,
  `status` tinyint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `role_types`
--

INSERT INTO `role_types` (`id`, `role_type_name`, `created_at`, `updated_at`, `deleted_at`, `deletion_remark`, `status`) VALUES
(1, 'Admin', '2019-05-02 13:00:09', NULL, NULL, '', 0),
(2, 'Collection_Agent', '2019-05-02 13:00:09', NULL, NULL, '', 0),
(3, 'Business_Agent', '2019-05-02 13:00:09', NULL, NULL, '', 0),
(4, 'Employee', '2019-05-02 13:00:09', NULL, NULL, '', 0),
(5, 'Superadmin', '2019-05-02 13:00:09', NULL, NULL, '', 0);

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

--
-- Table structure for table `schemes`
--

CREATE TABLE `schemes` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL DEFAULT '0',
  `chit_value` decimal(30,2) NOT NULL,
  `no_of_months` int NOT NULL,
  `members` int DEFAULT NULL,
  `register_fees` int DEFAULT NULL,
  `enrollment_fees` int DEFAULT NULL,
  `chit_letter` varchar(10) DEFAULT NULL,
  `short_term` varchar(50) DEFAULT NULL,
  `monthly_due` decimal(30,2) DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `schemes`
--

INSERT INTO `schemes` (`id`, `tenant_id`, `branch_id`, `chit_value`, `no_of_months`, `members`, `register_fees`, `enrollment_fees`, `chit_letter`, `short_term`, `monthly_due`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted_by`, `deleted_at`, `deletion_remark`, `status`) VALUES
(1, 37, 0, 50000.00, 20, 20, 200, 0, 'UNDIYAL', '0', 2500.00, 1, '2022-07-12 12:59:52', NULL, '2022-07-12 12:59:52', NULL, NULL, NULL, 1);

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

--
-- Table structure for table `slab_bonuses`
--

CREATE TABLE `slab_bonuses` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `scheme_id` int NOT NULL,
  `level1_from` int DEFAULT NULL,
  `level1_to` int DEFAULT NULL,
  `level_1_percentage` decimal(5,4) DEFAULT NULL,
  `level2_from` int DEFAULT NULL,
  `level2_to` int DEFAULT NULL,
  `level_2_percentage` decimal(5,4) DEFAULT NULL,
  `level3_from` int DEFAULT NULL,
  `level3_to` int DEFAULT NULL,
  `level_3_percentage` decimal(5,4) DEFAULT NULL,
  `level4_from` int DEFAULT NULL,
  `level4_to` int DEFAULT NULL,
  `level_4_percentage` decimal(5,4) DEFAULT NULL,
  `level5_from` int DEFAULT NULL,
  `level5_to` int DEFAULT NULL,
  `level_5_percentage` decimal(5,4) DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_by` int DEFAULT NULL,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `slab_dues`
--

CREATE TABLE `slab_dues` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `schemes_id` int NOT NULL,
  `slab_name` varchar(100) NOT NULL,
  `due_1` decimal(30,4) NOT NULL,
  `due_2` decimal(30,4) NOT NULL,
  `due_3` decimal(30,4) NOT NULL,
  `due_4` decimal(30,4) NOT NULL,
  `due_5` decimal(30,4) NOT NULL,
  `due_6` decimal(30,4) NOT NULL,
  `due_7` decimal(30,4) NOT NULL,
  `due_8` decimal(30,4) NOT NULL,
  `due_9` decimal(30,4) NOT NULL,
  `due_10` decimal(30,4) NOT NULL,
  `due_11` decimal(30,4) NOT NULL,
  `due_12` decimal(30,4) NOT NULL,
  `due_13` decimal(30,4) NOT NULL,
  `due_14` decimal(30,4) NOT NULL,
  `due_15` decimal(30,4) NOT NULL,
  `due_16` decimal(30,4) NOT NULL,
  `due_17` decimal(30,4) NOT NULL,
  `due_18` decimal(30,4) NOT NULL,
  `due_19` decimal(30,4) NOT NULL,
  `due_20` decimal(30,4) NOT NULL,
  `due_21` decimal(30,4) NOT NULL,
  `due_22` decimal(30,4) NOT NULL,
  `due_23` decimal(30,4) NOT NULL,
  `due_24` decimal(30,4) NOT NULL,
  `due_25` decimal(30,4) NOT NULL,
  `due_26` decimal(30,4) NOT NULL,
  `due_27` decimal(30,4) NOT NULL,
  `due_28` decimal(30,4) NOT NULL,
  `due_29` decimal(30,4) NOT NULL,
  `due_30` decimal(30,4) NOT NULL,
  `due_31` decimal(30,4) NOT NULL,
  `due_32` decimal(30,4) NOT NULL,
  `due_33` decimal(30,4) NOT NULL,
  `due_34` decimal(30,4) NOT NULL,
  `due_35` decimal(30,4) NOT NULL,
  `due_36` decimal(30,4) NOT NULL,
  `due_37` decimal(30,4) NOT NULL,
  `due_38` decimal(30,4) NOT NULL,
  `due_39` decimal(30,4) NOT NULL,
  `due_40` decimal(30,4) NOT NULL,
  `due_41` decimal(30,4) NOT NULL,
  `due_42` decimal(30,4) NOT NULL,
  `due_43` decimal(30,4) NOT NULL,
  `due_44` decimal(30,4) NOT NULL,
  `due_45` decimal(30,4) NOT NULL,
  `due_46` decimal(30,4) NOT NULL,
  `due_47` decimal(30,4) NOT NULL,
  `due_48` decimal(30,4) NOT NULL,
  `due_49` decimal(30,4) NOT NULL,
  `due_50` decimal(30,4) NOT NULL,
  `created_by` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `slab_interests`
--

CREATE TABLE `slab_interests` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `scheme_id` int DEFAULT NULL,
  `level1_from` int DEFAULT NULL,
  `level1_to` int DEFAULT NULL,
  `level_1_percentage` decimal(5,4) DEFAULT NULL,
  `level2_from` int DEFAULT NULL,
  `level2_to` int DEFAULT NULL,
  `level_2_percentage` decimal(5,4) DEFAULT NULL,
  `level3_from` int DEFAULT NULL,
  `level3_to` int DEFAULT NULL,
  `level_3_percentage` decimal(5,4) DEFAULT NULL,
  `level4_from` int DEFAULT NULL,
  `level4_to` int DEFAULT NULL,
  `level_4_percentage` decimal(5,4) DEFAULT NULL,
  `level5_from` int DEFAULT NULL,
  `level5_to` int DEFAULT NULL,
  `level_5_percentage` decimal(5,4) DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` int DEFAULT NULL,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_by` int DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `slab_payments`
--

CREATE TABLE `slab_payments` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `slab_id` int NOT NULL,
  `schemes_id` int NOT NULL,
  `payment_1` decimal(30,4) NOT NULL,
  `payment_2` decimal(30,4) NOT NULL,
  `payment_3` decimal(30,4) NOT NULL,
  `payment_4` decimal(30,4) NOT NULL,
  `payment_5` decimal(30,4) NOT NULL,
  `payment_6` decimal(30,4) NOT NULL,
  `payment_7` decimal(30,4) NOT NULL,
  `payment_8` decimal(30,4) NOT NULL,
  `payment_9` decimal(30,4) NOT NULL,
  `payment_10` decimal(30,4) NOT NULL,
  `payment_11` decimal(30,4) NOT NULL,
  `payment_12` decimal(30,4) NOT NULL,
  `payment_13` decimal(30,4) NOT NULL,
  `payment_14` decimal(30,4) NOT NULL,
  `payment_15` decimal(30,4) NOT NULL,
  `payment_16` decimal(30,4) NOT NULL,
  `payment_17` decimal(30,4) NOT NULL,
  `payment_18` decimal(30,4) NOT NULL,
  `payment_19` decimal(30,4) NOT NULL,
  `payment_20` decimal(30,4) NOT NULL,
  `payment_21` decimal(30,4) NOT NULL,
  `payment_22` decimal(30,4) NOT NULL,
  `payment_23` decimal(30,4) NOT NULL,
  `payment_24` decimal(30,4) NOT NULL,
  `payment_25` decimal(30,4) NOT NULL,
  `payment_26` decimal(30,4) NOT NULL,
  `payment_27` decimal(30,4) NOT NULL,
  `payment_28` decimal(30,4) NOT NULL,
  `payment_29` decimal(30,4) NOT NULL,
  `payment_30` decimal(30,4) NOT NULL,
  `payment_31` decimal(30,4) NOT NULL,
  `payment_32` decimal(30,4) NOT NULL,
  `payment_33` decimal(30,4) NOT NULL,
  `payment_34` decimal(30,4) NOT NULL,
  `payment_35` decimal(30,4) NOT NULL,
  `payment_36` decimal(30,4) NOT NULL,
  `payment_37` decimal(30,4) NOT NULL,
  `payment_38` decimal(30,4) NOT NULL,
  `payment_39` decimal(30,4) NOT NULL,
  `payment_40` decimal(30,4) NOT NULL,
  `payment_41` decimal(30,4) NOT NULL,
  `payment_42` decimal(30,4) NOT NULL,
  `payment_43` decimal(30,4) NOT NULL,
  `payment_44` decimal(30,4) NOT NULL,
  `payment_45` decimal(30,4) NOT NULL,
  `payment_46` decimal(30,4) NOT NULL,
  `payment_47` decimal(30,4) NOT NULL,
  `payment_48` decimal(30,4) NOT NULL,
  `payment_49` decimal(30,4) NOT NULL,
  `payment_50` decimal(30,4) NOT NULL,
  `created_by` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `slab_penalties`
--

CREATE TABLE `slab_penalties` (
  `id` int NOT NULL,
  `tenant_id` int DEFAULT NULL,
  `branch_id` int DEFAULT NULL,
  `scheme_id` int DEFAULT NULL,
  `level1_from` int DEFAULT NULL,
  `level1_to` int DEFAULT NULL,
  `level_1_percentage` decimal(5,4) DEFAULT NULL,
  `level2_from` int DEFAULT NULL,
  `level2_to` int DEFAULT NULL,
  `level_2_percentage` decimal(5,4) DEFAULT NULL,
  `level3_from` int DEFAULT NULL,
  `level3_to` int DEFAULT NULL,
  `level_3_percentage` decimal(5,4) DEFAULT NULL,
  `level4_from` int DEFAULT NULL,
  `level4_to` int DEFAULT NULL,
  `level_4_percentage` decimal(5,4) DEFAULT NULL,
  `level5_from` int DEFAULT NULL,
  `level5_to` int DEFAULT NULL,
  `level_5_percentage` decimal(5,4) DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `sms`
--

CREATE TABLE `sms` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `template_name` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `created_by` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `status` tinyint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `source_types`
--

CREATE TABLE `source_types` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `source_type_name` varchar(255) NOT NULL,
  `remarks` text,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `states`
--

CREATE TABLE `states` (
  `id` int NOT NULL,
  `country_id` int NOT NULL,
  `state_name` varchar(100) NOT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `states`
--

INSERT INTO `states` (`id`, `country_id`, `state_name`, `created_by`, `created_at`, `updated_by`, `updated_at`, `deleted_by`, `deleted_at`, `deletion_remark`, `status`) VALUES
(1, 1, 'TAMIL NADU', 0, '2019-04-16 04:35:52', 0, '2021-11-10 16:55:46', 1, '2021-11-10 16:55:46', '0', 1),
(2, 1, 'ANDHRA PRADESH', 0, '2019-04-16 04:43:09', 26, '2021-02-22 18:15:39', 1, '2021-02-22 18:15:39', '0', 1),
(3, 1, 'Kerala', 0, '2019-04-16 04:43:09', 0, '2021-02-22 18:15:43', 1, '2021-02-22 18:15:43', '0', 1),
(4, 1, 'karnataka', 1, '2021-04-01 17:24:07', 0, '2021-04-01 17:25:05', 1, '2021-04-01 17:25:05', 'first letter is  have to add  capital letter like Karnataka', 1),
(5, 1, 'Maharasthra', 1, '2021-04-01 17:26:10', 0, '2021-11-10 16:55:42', 1, '2021-11-10 16:55:42', '0', 1),
(6, 1, 'KARNATAKA', 1, '2021-10-23 14:05:55', NULL, '2022-04-19 13:35:06', 1, '2022-04-19 13:35:06', '0', 1),
(7, 1, 'KERALA', 1, '2022-02-15 09:46:29', NULL, '2022-04-19 13:35:01', 1, '2022-04-19 13:35:01', '0', 1),
(8, 1, 'Tamilnadu', 1, '2022-04-19 13:35:23', NULL, '2022-04-19 13:35:23', NULL, NULL, NULL, 1),
(9, 1, 'Kerala', 48, '2022-04-19 18:07:03', NULL, '2022-04-19 18:07:03', NULL, NULL, NULL, 1);

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

--
-- Table structure for table `suite_fillings`
--

CREATE TABLE `suite_fillings` (
  `id` int NOT NULL,
  `tenent_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `group_id` int NOT NULL,
  `customer_id` int NOT NULL,
  `ticket_no` int NOT NULL,
  `enroll_id` int NOT NULL,
  `lawyer_id` int NOT NULL,
  `lawyer_fee` float NOT NULL,
  `case_stage` int NOT NULL,
  `chit_amount` double NOT NULL,
  `group_status` int NOT NULL COMMENT '0-active,1-closed',
  `case_expence` float NOT NULL,
  `case_status` int NOT NULL COMMENT '0-active,1-closed',
  `remarks` varchar(250) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` int NOT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remarks` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `suite_filling_timelines`
--

CREATE TABLE `suite_filling_timelines` (
  `id` int NOT NULL,
  `s_id` int NOT NULL,
  `t_lawyer_id` int NOT NULL,
  `t_lawyer_fee` double NOT NULL,
  `t_case_stage` int NOT NULL,
  `t_case_expense` double NOT NULL,
  `t_remarks` varchar(250) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` int NOT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `unknown_transactions`
--

CREATE TABLE `unknown_transactions` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `employee_id` int NOT NULL,
  `received_date` date DEFAULT NULL,
  `amount_received` decimal(30,4) DEFAULT NULL,
  `payment_type_id` int DEFAULT NULL,
  `debit_to` varchar(200) DEFAULT NULL,
  `cheque_no` varchar(200) DEFAULT NULL,
  `cheque_date` date DEFAULT NULL,
  `cheque_clear_return_date` date DEFAULT NULL,
  `cheque_return_amount` decimal(30,4) DEFAULT NULL,
  `cheque_debit_to` int DEFAULT NULL,
  `bank_id` int DEFAULT NULL,
  `bank_branch_name` varchar(200) DEFAULT NULL,
  `transaction_date` date DEFAULT NULL,
  `transaction_no` varchar(200) DEFAULT NULL,
  `remarks` text,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `update_branches`
--

CREATE TABLE `update_branches` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `head_office_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `branch_name` varchar(100) NOT NULL,
  `start_date` timestamp NULL DEFAULT NULL,
  `branch_code` varchar(45) DEFAULT NULL,
  `edit_date` date DEFAULT NULL,
  `state_id` int DEFAULT NULL,
  `district_id` int DEFAULT NULL,
  `city_id` int DEFAULT NULL,
  `pincode` varchar(8) DEFAULT NULL,
  `branch_wise_penalty` int DEFAULT NULL,
  `bonus` int DEFAULT NULL,
  `email_id` varchar(100) DEFAULT NULL,
  `phone_no` varchar(20) DEFAULT NULL,
  `mobile_no` varchar(20) DEFAULT NULL,
  `address_line_1` text,
  `address_line_2` text,
  `landmark` text,
  `prize_subscriber_penalty` int DEFAULT NULL,
  `non_prize_subscriber_penalty` int DEFAULT NULL,
  `bonus_days` int DEFAULT NULL,
  `penalty_days` int DEFAULT NULL,
  `business_agent_target` int DEFAULT NULL,
  `branch_fd_total_months` int DEFAULT NULL,
  `remarks` text,
  `agent_incentive_percent` int DEFAULT NULL,
  `agent_commission_percent` int DEFAULT NULL,
  `customer_incentive_percentage` decimal(30,4) DEFAULT NULL,
  `cgst_percent` decimal(30,4) DEFAULT NULL,
  `sgst_percent` decimal(30,4) DEFAULT NULL,
  `gst_percent` decimal(30,4) DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `update_groups`
--

CREATE TABLE `update_groups` (
  `id` int NOT NULL,
  `tenant_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `group_type` tinyint NOT NULL COMMENT '1=Register,2=Non_Register,3=Slab_Register,4=Slab_Non_Register,5=Profit,6=2nd_due',
  `group_name` varchar(100) NOT NULL,
  `scheme_id` int NOT NULL DEFAULT '0',
  `edit_date` date NOT NULL,
  `group_id` int NOT NULL,
  `auction_date` varchar(5) NOT NULL,
  `auction_time` varchar(10) NOT NULL,
  `starting_date` date DEFAULT NULL,
  `first_due_date` varchar(15) DEFAULT NULL,
  `commission_percent` decimal(30,4) NOT NULL,
  `fd_number` varchar(45) NOT NULL,
  `total_fd` decimal(30,4) NOT NULL,
  `company_fd` decimal(30,4) NOT NULL,
  `rate_of_interest` decimal(30,4) NOT NULL,
  `fd_rate` decimal(30,4) NOT NULL,
  `fd_date` varchar(15) DEFAULT NULL,
  `maturity_amount` decimal(30,4) NOT NULL,
  `fd_bank_id` int NOT NULL,
  `fd_branch` varchar(150) NOT NULL,
  `pso_number` varchar(100) NOT NULL,
  `pso_date` varchar(15) DEFAULT NULL,
  `blaw_number` varchar(150) NOT NULL,
  `blaw_date` varchar(15) DEFAULT NULL,
  `cheque_no` varchar(50) NOT NULL,
  `company_chit` int NOT NULL,
  `group_base_penalty` decimal(30,4) NOT NULL COMMENT 'percentage',
  `group_base_bonus` decimal(30,4) NOT NULL COMMENT 'percentage',
  `group_base_interest` decimal(30,4) DEFAULT NULL COMMENT 'percentage',
  `group_base_dividend_cancel_days` int DEFAULT NULL,
  `group_penalty_days` int DEFAULT NULL,
  `group_bonus_days` int DEFAULT NULL,
  `group_base_incentive_percentage` decimal(30,4) DEFAULT NULL,
  `fd_renewal_date` varchar(15) DEFAULT NULL,
  `commit_date` varchar(15) DEFAULT NULL,
  `is_filled` tinyint DEFAULT NULL COMMENT '0=yes,1=no',
  `group_status` tinyint DEFAULT NULL COMMENT '0=non_closed,1=closed',
  `group_pending_ticket` decimal(10,2) DEFAULT NULL COMMENT 'vacant_count',
  `is_first_auction_complete` tinyint DEFAULT NULL COMMENT '0=yes,1=no',
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deletion_remark` text,
  `status` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

--
-- Indexes for table `attendance`
--
ALTER TABLE `attendance`
  ADD PRIMARY KEY (`Id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `account_expenses`
--
ALTER TABLE `account_expenses`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `account_groups`
--
ALTER TABLE `account_groups`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `account_heads`
--
ALTER TABLE `account_heads`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `advance_receipts`
--
ALTER TABLE `advance_receipts`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `agent_commission_payments`
--
ALTER TABLE `agent_commission_payments`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `agent_incentive_payments`
--
ALTER TABLE `agent_incentive_payments`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `approval_notifications`
--
ALTER TABLE `approval_notifications`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `asset_details`
--
ALTER TABLE `asset_details`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `attendance`
--
ALTER TABLE `attendance`
  MODIFY `Id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `attendence_type`
--
ALTER TABLE `attendence_type`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `auction_on_holidays`
--
ALTER TABLE `auction_on_holidays`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bank_details`
--
ALTER TABLE `bank_details`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `before_enrol_receipts`
--
ALTER TABLE `before_enrol_receipts`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bidding_commission_details`
--
ALTER TABLE `bidding_commission_details`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bidding_details`
--
ALTER TABLE `bidding_details`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bidding_logs`
--
ALTER TABLE `bidding_logs`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `branches`
--
ALTER TABLE `branches`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `case_names`
--
ALTER TABLE `case_names`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cash_settlements`
--
ALTER TABLE `cash_settlements`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `charge_types`
--
ALTER TABLE `charge_types`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `chit_pledges`
--
ALTER TABLE `chit_pledges`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cities`
--
ALTER TABLE `cities`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `collection_areas`
--
ALTER TABLE `collection_areas`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `collection_area_mappings`
--
ALTER TABLE `collection_area_mappings`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `collection_remarks`
--
ALTER TABLE `collection_remarks`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `commitment_auctions`
--
ALTER TABLE `commitment_auctions`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `countries`
--
ALTER TABLE `countries`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `customer_bank_details`
--
ALTER TABLE `customer_bank_details`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `designations`
--
ALTER TABLE `designations`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `devices`
--
ALTER TABLE `devices`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `districts`
--
ALTER TABLE `districts`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=136;

--
-- AUTO_INCREMENT for table `documents`
--
ALTER TABLE `documents`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `document_details`
--
ALTER TABLE `document_details`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `dynamic_menus`
--
ALTER TABLE `dynamic_menus`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=112;

--
-- AUTO_INCREMENT for table `employees`
--
ALTER TABLE `employees`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `employee_attendances`
--
ALTER TABLE `employee_attendances`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `employee_monthly_salary_details`
--
ALTER TABLE `employee_monthly_salary_details`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `employee_payrolls`
--
ALTER TABLE `employee_payrolls`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `employee_salaries`
--
ALTER TABLE `employee_salaries`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `family_codes`
--
ALTER TABLE `family_codes`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `field_investigations`
--
ALTER TABLE `field_investigations`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `file_names`
--
ALTER TABLE `file_names`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `followups`
--
ALTER TABLE `followups`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `followup_status_types`
--
ALTER TABLE `followup_status_types`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `groups`
--
ALTER TABLE `groups`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `group_bidding_details`
--
ALTER TABLE `group_bidding_details`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `guarantor_relations`
--
ALTER TABLE `guarantor_relations`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `head_offices`
--
ALTER TABLE `head_offices`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `hierarchies`
--
ALTER TABLE `hierarchies`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `interest_messages`
--
ALTER TABLE `interest_messages`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lawyers`
--
ALTER TABLE `lawyers`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `loan_asset_details`
--
ALTER TABLE `loan_asset_details`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `loan_details`
--
ALTER TABLE `loan_details`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `loan_documents`
--
ALTER TABLE `loan_documents`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `loan_document_details`
--
ALTER TABLE `loan_document_details`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `loan_receipts`
--
ALTER TABLE `loan_receipts`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `log_monitoring_tables`
--
ALTER TABLE `log_monitoring_tables`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `message_logs`
--
ALTER TABLE `message_logs`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `minutes_of_auctions`
--
ALTER TABLE `minutes_of_auctions`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `other_charges`
--
ALTER TABLE `other_charges`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `payments`
--
ALTER TABLE `payments`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `payment_minutes`
--
ALTER TABLE `payment_minutes`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `payment_types`
--
ALTER TABLE `payment_types`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `petty_cash_expenses`
--
ALTER TABLE `petty_cash_expenses`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `petty_cash_expense_types`
--
ALTER TABLE `petty_cash_expense_types`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `petty_cash_incomes`
--
ALTER TABLE `petty_cash_incomes`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `receipts`
--
ALTER TABLE `receipts`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `receipts_1`
--
ALTER TABLE `receipts_1`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `receipts_2`
--
ALTER TABLE `receipts_2`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `relationships`
--
ALTER TABLE `relationships`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `remarks`
--
ALTER TABLE `remarks`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `role_permissions`
--
ALTER TABLE `role_permissions`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `role_types`
--
ALTER TABLE `role_types`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `schemes`
--
ALTER TABLE `schemes`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `slab_bonuses`
--
ALTER TABLE `slab_bonuses`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `slab_dues`
--
ALTER TABLE `slab_dues`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `slab_interests`
--
ALTER TABLE `slab_interests`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `slab_payments`
--
ALTER TABLE `slab_payments`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `slab_penalties`
--
ALTER TABLE `slab_penalties`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sms`
--
ALTER TABLE `sms`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `source_types`
--
ALTER TABLE `source_types`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `states`
--
ALTER TABLE `states`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `suite_fillings`
--
ALTER TABLE `suite_fillings`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `suite_filling_timelines`
--
ALTER TABLE `suite_filling_timelines`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `unknown_transactions`
--
ALTER TABLE `unknown_transactions`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `update_branches`
--
ALTER TABLE `update_branches`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `update_groups`
--
ALTER TABLE `update_groups`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;
COMMIT;

