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

START TRANSACTION;



--
-- Database: `erealestate`
--

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

--
-- Table structure for table `actual_receiveds`
--

CREATE TABLE `actual_receiveds` (
  `id` int(10) UNSIGNED NOT NULL,
  `sells_id` bigint(20) UNSIGNED NOT NULL,
  `term` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `received_amount` bigint(20) NOT NULL,
  `adjustment` bigint(20) DEFAULT NULL,
  `actual_amount` bigint(20) NOT NULL,
  `date_of_collection` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `made_of_payment` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cheque_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `bank_cashes`
--

CREATE TABLE `bank_cashes` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `account_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bank_cashes`
--

INSERT INTO `bank_cashes` (`id`, `name`, `account_number`, `description`, `created_by`, `updated_by`, `deleted_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Cash', NULL, 'This is Cash of our company', NULL, NULL, NULL, '2020-05-18 14:30:41', '2020-05-18 14:30:41', NULL);

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

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

CREATE TABLE `branches` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `location` longtext COLLATE utf8mb4_unicode_ci,
  `address` longtext COLLATE utf8mb4_unicode_ci,
  `facing` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `building_height` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `land_area` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `launching_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hand_over_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `create_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `update_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `delete_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `branches`
--

INSERT INTO `branches` (`id`, `name`, `location`, `address`, `facing`, `building_height`, `land_area`, `launching_date`, `hand_over_date`, `description`, `create_by`, `update_by`, `delete_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Head Office', 'Nikunja-2,Khilkhet Dhaka-1229 Bangladesh', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-05-18 14:30:41', '2020-05-18 14:30:41', NULL);

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

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

CREATE TABLE `customers` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `father_or_husband_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mailing_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `employees` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `position` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `department` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `income_expense_groups`
--

CREATE TABLE `income_expense_groups` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` bigint(20) NOT NULL,
  `created_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `income_expense_heads`
--

CREATE TABLE `income_expense_heads` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `unit` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `income_expense_type_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `income_expense_group_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` tinyint(4) NOT NULL,
  `created_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `income_expense_types`
--

CREATE TABLE `income_expense_types` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` bigint(20) NOT NULL,
  `created_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `income_expense_types`
--

INSERT INTO `income_expense_types` (`id`, `name`, `code`, `created_by`, `updated_by`, `deleted_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Inventories', 101, 'E-Accounts system', NULL, NULL, '2020-05-18 14:30:41', '2020-05-18 14:30:41', NULL),
(2, 'Direct Material', 102, 'E-Accounts system', NULL, NULL, '2020-05-18 14:30:41', '2020-05-18 14:30:41', NULL),
(3, 'Advance, Deposit & Receivables', 103, 'E-Accounts system', NULL, NULL, '2020-05-18 14:30:41', '2020-05-18 14:30:41', NULL),
(4, 'Direct Labour', 104, 'E-Accounts system', NULL, NULL, '2020-05-18 14:30:41', '2020-05-18 14:30:41', NULL),
(5, 'Revenue', 105, 'E-Accounts system', NULL, NULL, '2020-05-18 14:30:41', '2020-05-18 14:30:41', NULL),
(6, 'Indirect Income', 106, 'E-Accounts system', NULL, NULL, '2020-05-18 14:30:41', '2020-05-18 14:30:41', NULL),
(7, 'Account Payable', 107, 'E-Accounts system', NULL, NULL, '2020-05-18 14:30:41', '2020-05-18 14:30:41', NULL),
(8, 'Paid Up Capital', 108, 'E-Accounts system', NULL, NULL, '2020-05-18 14:30:41', '2020-05-18 14:30:41', NULL),
(9, 'Long Term Loan', 109, 'E-Accounts system', NULL, NULL, '2020-05-18 14:30:41', '2020-05-18 14:30:41', NULL),
(10, 'Short Term Loan', 110, 'E-Accounts system', NULL, NULL, '2020-05-18 14:30:41', '2020-05-18 14:30:41', NULL),
(11, 'Other Payable', 111, 'E-Accounts system', NULL, NULL, '2020-05-18 14:30:41', '2020-05-18 14:30:41', NULL),
(12, 'Advance Against Sales', 112, 'E-Accounts system', NULL, NULL, '2020-05-18 14:30:41', '2020-05-18 14:30:41', NULL),
(13, 'Share Money Deposit', 113, 'E-Accounts system', NULL, NULL, '2020-05-18 14:30:41', '2020-05-18 14:30:41', NULL),
(14, 'Other Direct Expenses', 114, 'E-Accounts system', NULL, NULL, '2020-05-18 14:30:41', '2020-05-18 14:30:41', NULL),
(15, 'Other Expense', 115, 'E-Accounts system', NULL, NULL, '2020-05-18 14:30:41', '2020-05-18 14:30:41', NULL),
(16, 'Administrative Expense', 116, 'E-Accounts system', NULL, NULL, '2020-05-18 14:30:41', '2020-05-18 14:30:41', NULL),
(17, 'Financial Expense', 117, 'E-Accounts system', NULL, NULL, '2020-05-18 14:30:41', '2020-05-18 14:30:41', NULL),
(18, 'Provision & Tax Paid', 118, 'E-Accounts system', NULL, NULL, '2020-05-18 14:30:41', '2020-05-18 14:30:41', NULL),
(19, 'Property, Plant & Equipment', 119, 'E-Accounts system', NULL, NULL, '2020-05-18 14:30:41', '2020-05-18 14:30:41', NULL),
(20, 'Advance Receive from Investor', 120, 'E-Accounts system', NULL, NULL, '2020-05-18 14:30:41', '2020-05-18 14:30:41', NULL),
(21, 'Preliminary Expense', 121, 'E-Accounts system', NULL, NULL, '2020-05-18 14:30:41', '2020-05-18 14:30:41', NULL),
(22, 'Dividend', 122, 'E-Accounts system', NULL, NULL, '2020-05-18 14:30:41', '2020-05-18 14:30:41', NULL);

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2019_03_17_115307_create_profiles_table', 1),
(4, '2019_03_27_160236_create_settings_table', 1),
(5, '2019_11_11_051203_create_role_manages_table', 1),
(6, '2019_11_21_044659_create_branches_table', 1),
(7, '2019_11_22_063449_create_income_expense_types_table', 1),
(8, '2019_11_22_102644_create_income_expense_heads_table', 1),
(9, '2019_11_23_182134_create_bank_cashes_table', 1),
(10, '2019_11_24_062835_create_transactions_table', 1),
(11, '2019_12_10_121535_transaction_income_expense_head_ids_view', 1),
(12, '2019_12_11_001831_transaction_bank_cash_view', 1),
(13, '2019_12_11_151917_transaction_branch_view', 1),
(14, '2019_12_22_123713_create_income_expense_groups_table', 1),
(15, '2020_03_18_002132_create_customers_table', 1),
(16, '2020_03_20_115000_create_products_table', 1),
(17, '2020_03_24_172001_create_vendors_table', 1),
(18, '2020_03_24_190851_create_sells_table', 1),
(19, '2020_03_24_191408_create_employees_table', 1),
(20, '2020_03_29_091941_create_schedule_receivables_table', 1),
(21, '2020_03_29_092418_create_actual_receiveds_table', 1),
(22, '2020_04_03_093647_create_purchase_requisitions_table', 1),
(23, '2020_04_10_111047_create_purchase_orders_table', 1);

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` int(10) UNSIGNED NOT NULL,
  `branch_id` bigint(20) UNSIGNED NOT NULL,
  `product_unique_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `flat_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `floor_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `flat_size` bigint(20) NOT NULL,
  `unite_price` bigint(20) NOT NULL,
  `total_flat_price` bigint(20) NOT NULL,
  `car_parking_charge` bigint(20) DEFAULT NULL,
  `utility_charge` bigint(20) DEFAULT NULL,
  `additional_work_charge` bigint(20) DEFAULT NULL,
  `other_charge` bigint(20) DEFAULT NULL,
  `discount_or_deduction` bigint(20) DEFAULT NULL,
  `refund_additional_work_charge` bigint(20) DEFAULT NULL,
  `net_sells_price` bigint(20) NOT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product_img` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `profiles`
--

CREATE TABLE `profiles` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `first_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gender` int(11) DEFAULT NULL,
  `designation` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `NID` bigint(20) UNSIGNED DEFAULT NULL,
  `permanent_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `present_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `avatar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `education` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `profiles`
--

INSERT INTO `profiles` (`id`, `user_id`, `first_name`, `last_name`, `gender`, `designation`, `phone_number`, `NID`, `permanent_address`, `present_address`, `avatar`, `education`, `description`, `created_at`, `updated_at`) VALUES
(1, 1, 'Super', 'Admin', 1, 'PHP Developer', '+8801738578683', 199412478654477, 'PS: Raygonj, District: Sirajgonj', 'Dhaka,Bangladesh', 'upload/avatar/avatar.png', 'B.S. in Computer Science from the University of Primeasia University', '', '2020-05-18 14:30:41', '2020-05-18 14:30:41');

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

--
-- Table structure for table `purchase_orders`
--

CREATE TABLE `purchase_orders` (
  `id` int(10) UNSIGNED NOT NULL,
  `branch_id` bigint(20) UNSIGNED NOT NULL,
  `requisition_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `purchase_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vendor_id` bigint(20) UNSIGNED NOT NULL,
  `media_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `issuing_date` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_of_delevery` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contract_person_1` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contract_person_2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` longtext COLLATE utf8mb4_unicode_ci,
  `subject` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `message_body` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `item` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `totalAmount` bigint(20) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `purchase_requisitions`
--

CREATE TABLE `purchase_requisitions` (
  `id` int(10) UNSIGNED NOT NULL,
  `branch_id` bigint(20) UNSIGNED NOT NULL,
  `employee_id` bigint(20) UNSIGNED NOT NULL,
  `amount` bigint(20) NOT NULL,
  `purpose` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `requisition_date` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `required_date` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `comment` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contract_person` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `item` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `requisition_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `role_manages`
--

CREATE TABLE `role_manages` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `create_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `update_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `delete_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_manages`
--

INSERT INTO `role_manages` (`id`, `name`, `content`, `create_by`, `update_by`, `delete_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Super Admin', '{\"User\":[\"User \",1,1,1,1,1,1,1,1,1],\"RoleManager\":[\"Role Manager\",1,1,1,1,1,1,1,1,1],\"Settings\":[\"Settings\",1,1,1,1,1,1,1,1,1],\"Project\":[\"Project\",1,1,1,1,1,1,1,1,1],\"Product\":[\"Product\",1,1,1,1,1,1,1,1,1],\"Sell\":[\"Sell\",1,1,1,1,1,1,1,1,1],\"PurchaseRequisition\":[\"Purchase Requisition\",1,1,1,1,1,1,1,1,1],\"PurchaseRQNConfirm\":[\"Purchase RQN Confirm\",1,1,1,1,1,1,1,1,1],\"PurchaseOrder\":[\"Purchase Order\",1,1,1,1,1,1,1,1,1],\"Vendor\":[\"Vendor\",1,1,1,1,1,1,1,1,1],\"Employee\":[\"Employee\",1,1,1,1,1,1,1,1,1],\"Customer\":[\"Customer\",1,1,1,1,1,1,1,1,1],\"LedgerType\":[\"Ledger Type\",1,1,1,1,1,1,1,1,1],\"LedgerGroup\":[\"Ledger Group\",1,1,1,1,1,1,1,1,1],\"LedgerName\":[\"Ledger Name\",1,1,1,1,1,1,1,1,1],\"BankCash\":[\"Bank Cash\",1,1,1,1,1,1,1,1,1],\"InitialIncomeExpenseHeadBalance\":[\"Initial Income Expense Head Balance\",1,1,1,1,1,1,1,1,1],\"InitialBankCashBalance\":[\"Initial Bank Cash Balance\",1,1,1,1,1,1,1,1,1],\"DrVoucher\":[\"Dr Voucher\",1,1,1,1,1,1,1,1,1],\"CrVoucher\":[\"Cr Voucher\",1,1,1,1,1,1,1,1,1],\"JnlVoucher\":[\"Jnl Voucher\",1,1,1,1,1,1,1,1,1],\"ContraVoucher\":[\"Contra Voucher\",1,1,1,1,1,1,1,1,1],\"Ledger\":[\"Ledger\",1,1,1,1,1,1,1,1,1],\"TrialBalance\":[\"Trial Balance\",1,1,1,1,1,1,1,1,1],\"CostOfRevenue\":[\"Cost Of Revenue\",1,1,1,1,1,1,1,1,1],\"ProfitOrLossAccount\":[\"Profit Or Loss Account\",1,1,1,1,1,1,1,1,1],\"RetainedEarning\":[\"Retained Earning\",1,1,1,1,1,1,1,1,1],\"FixedAssetsSchedule\":[\"Fixed Assets Schedule\",1,1,1,1,1,1,1,1,1],\"StatementOfFinancialPosition\":[\"Statement Of Financial Position\",1,1,1,1,1,1,1,1,1],\"CashFlow\":[\"Cash Flow\",1,1,1,1,1,1,1,1,1],\"ReceiveAndPayment\":[\"Receive And Payment\",1,1,1,1,1,1,1,1,1],\"Notes\":[\"Notes\",1,1,1,1,1,1,1,1,1],\"PurchaseReport\":[\"PurchaseReport\",1,1,1,1,1,1,1,1,1],\"SellsReport\":[\"Sells Report\",1,1,1,1,1,1,1,1,1],\"GeneralBranch\":[\"General Branch Report\",1,1,1,1,1,1,1,1,1],\"GeneralLedger\":[\"General Ledger Report\",1,1,1,1,1,1,1,1,1],\"GeneralBankCash\":[\"General Bank Cash Report\",1,1,1,1,1,1,1,1,1],\"GeneralVoucher\":[\"General Voucher Report\",1,1,1,1,1,1,1,1,1]}', 'superadmin@eaccount.xyz', NULL, NULL, '2020-05-18 14:30:41', '2020-05-18 14:30:41', NULL);

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

--
-- Table structure for table `schedule_receivables`
--

CREATE TABLE `schedule_receivables` (
  `id` int(10) UNSIGNED NOT NULL,
  `sells_id` bigint(20) UNSIGNED NOT NULL,
  `term` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payable_amount` bigint(20) NOT NULL,
  `schedule_date` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sells`
--

CREATE TABLE `sells` (
  `id` int(10) UNSIGNED NOT NULL,
  `customer_id` bigint(20) UNSIGNED NOT NULL,
  `branch_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `employee_id` bigint(20) UNSIGNED NOT NULL,
  `sells_date` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(10) UNSIGNED NOT NULL,
  `settings_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `settings_name`, `content`, `created_at`, `updated_at`) VALUES
(1, 'General Settings', '{\"company_name\":\"PT RUMAH INDAH\",\"contract_person\":\"+8801738578683\",\"email\":\"admin@gmail.com\",\"phone\":\"0212345678\",\"address_1\":\"RT.005\\/RW.010, Medan Satria Kecamatan Medan Satria Kota Bks Jawa Barat\",\"address_2\":null,\"city\":\"Bekasi\",\"state\":\"Jawa Barat\",\"zip_code\":\"6700\",\"company_logo\":\"upload\\/company-logo\\/e.png\"}', '2020-05-18 14:30:41', '2022-12-16 06:27:57'),
(2, 'System Settings', '{\"date_format\":\"d-m-Y\",\"timezone\":\"Asia\\/Jakarta\",\"currency_code\":\"IDR\",\"currency_symbol\":\"Rp\",\"is_code\":\"symbol\",\"currency_position\":\"Suffix\",\"fixed_asset_schedule_starting_date\":\"2000-01-01\"}', '2020-05-18 14:30:41', '2022-12-13 02:32:42');

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

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

CREATE TABLE `transactions` (
  `id` int(10) UNSIGNED NOT NULL,
  `voucher_no` bigint(20) UNSIGNED NOT NULL,
  `branch_id` bigint(20) UNSIGNED DEFAULT NULL,
  `cheque_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `income_expense_head_id` bigint(20) UNSIGNED DEFAULT NULL,
  `bank_cash_id` bigint(20) UNSIGNED DEFAULT NULL,
  `voucher_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `voucher_date` date NOT NULL,
  `dr` bigint(20) DEFAULT NULL,
  `cr` bigint(20) DEFAULT NULL,
  `particulars` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Stand-in structure for view `transaction_bank_cash_view`
-- (See below for the actual view)
--
CREATE TABLE `transaction_bank_cash_view` (
`bank_cash_id` bigint(20) unsigned
,`name` varchar(191)
);

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

--
-- Stand-in structure for view `transaction_branch_view`
-- (See below for the actual view)
--
CREATE TABLE `transaction_branch_view` (
`branch_id` bigint(20) unsigned
,`name` varchar(191)
);

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

--
-- Stand-in structure for view `transaction_income_expense_head_ids_view`
-- (See below for the actual view)
--
CREATE TABLE `transaction_income_expense_head_ids_view` (
`income_expense_head_id` bigint(20) unsigned
,`income_expense_head_name` varchar(191)
,`type` tinyint(4)
);

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

--
-- Table structure for table `vendors`
--

CREATE TABLE `vendors` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mailing_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `website` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Structure for view `transaction_bank_cash_view`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `transaction_bank_cash_view`  AS SELECT DISTINCT `transactions`.`bank_cash_id` AS `bank_cash_id`, `bank_cashes`.`name` AS `name` FROM (`transactions` join `bank_cashes` on((`transactions`.`bank_cash_id` = `bank_cashes`.`id`))) WHERE ((`transactions`.`bank_cash_id` is not null) AND isnull(`transactions`.`deleted_at`)) ORDER BY `transactions`.`bank_cash_id` ASC ;

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

--
-- Structure for view `transaction_branch_view`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `transaction_branch_view`  AS SELECT DISTINCT `transactions`.`branch_id` AS `branch_id`, `branches`.`name` AS `name` FROM (`transactions` join `branches` on((`transactions`.`branch_id` = `branches`.`id`))) WHERE ((`transactions`.`branch_id` is not null) AND isnull(`transactions`.`deleted_at`)) ORDER BY `transactions`.`branch_id` ASC ;

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

--
-- Structure for view `transaction_income_expense_head_ids_view`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `transaction_income_expense_head_ids_view`  AS SELECT DISTINCT `transactions`.`income_expense_head_id` AS `income_expense_head_id`, `income_expense_heads`.`name` AS `income_expense_head_name`, `income_expense_heads`.`type` AS `type` FROM (`transactions` join `income_expense_heads` on((`transactions`.`income_expense_head_id` = `income_expense_heads`.`id`))) WHERE ((`transactions`.`income_expense_head_id` is not null) AND isnull(`transactions`.`deleted_at`)) ORDER BY `transactions`.`income_expense_head_id` ASC ;

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `bank_cashes`
--
ALTER TABLE `bank_cashes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `bank_cashes_name_unique` (`name`);

--
-- Indexes for table `branches`
--
ALTER TABLE `branches`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `branches_name_unique` (`name`);

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

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

--
-- Indexes for table `income_expense_groups`
--
ALTER TABLE `income_expense_groups`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `income_expense_groups_name_unique` (`name`),
  ADD UNIQUE KEY `income_expense_groups_code_unique` (`code`);

--
-- Indexes for table `income_expense_heads`
--
ALTER TABLE `income_expense_heads`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `income_expense_heads_name_unique` (`name`);

--
-- Indexes for table `income_expense_types`
--
ALTER TABLE `income_expense_types`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `income_expense_types_name_unique` (`name`),
  ADD UNIQUE KEY `income_expense_types_code_unique` (`code`);

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

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `products_product_unique_id_unique` (`product_unique_id`);

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

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

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

--
-- Indexes for table `role_manages`
--
ALTER TABLE `role_manages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `role_manages_name_unique` (`name`);

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `actual_receiveds`
--
ALTER TABLE `actual_receiveds`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

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

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

--
-- AUTO_INCREMENT for table `customers`
--
ALTER TABLE `customers`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `employees`
--
ALTER TABLE `employees`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `income_expense_groups`
--
ALTER TABLE `income_expense_groups`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `income_expense_heads`
--
ALTER TABLE `income_expense_heads`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

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

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

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `purchase_orders`
--
ALTER TABLE `purchase_orders`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `purchase_requisitions`
--
ALTER TABLE `purchase_requisitions`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `schedule_receivables`
--
ALTER TABLE `schedule_receivables`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sells`
--
ALTER TABLE `sells`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `vendors`
--
ALTER TABLE `vendors`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;

