CREATE TABLE `tbl_products` (
  `product_id` <type>,
  `p_name` <type>,
  `p_sell_price` <type>,
  `branch_id` <type>,
  `storage_id` <type>,
  `company_id` <type>,
  `prdct_id` <type>,
  `barcode_id` <type>,
  `buy_price` <type>,
  `min_price` <type>
);

CREATE TABLE `tbl_customer` (
  `customer_id` <type>,
  `c_FullName` <type>,
  `c_address` <type>,
  `c_phone` <type>,
  `c_id_number` <type>,
  `c_job` <type>,
  `debt_id` <type>,
  `pshtgiri` <type>
);

CREATE TABLE `tbl_branchs` (
  `branch_id` <type>,
  `b_address` <type>,
  `b_phoneNum` <type>
);

CREATE TABLE `tbl_orderDetail` (
  `order_id` <type>,
  `company_id` <type>,
  `product_id` <type>
);

CREATE TABLE `tbl_order` (
  `order_id` <type>,
  `order_date` <type>,
  `product_id` <type>,
  `quantity` <type>
);

CREATE TABLE `tbl_company` (
  `company_id` <type>,
  `company_name` <type>
);

CREATE TABLE `tbl_installment` (
  `i_id` <type>,
  `i_all_amount` <type>,
  `product_id` <type>,
  `branch_id` <type>,
  `customer_id` <type>,
  `remaining_amount` <type>,
  `prepay` <type>,
  `first_date` <type>,
  `n_of_times` <type>,
  `remaining_n` <type>
);

CREATE TABLE `tbl_wasl` (
  `wasl_id` <type>,
  `wasl_date` <type>,
  `employee_id` <type>,
  `wasl_amount` <type>,
  `product_id` <type>,
  `branch_id` <type>,
  `customer_id` <type>,
  `paid_iqd` <type>,
  `paid_usd` <type>,
  `i_id` <type>,
  `product_quantity` <type>,
  `discount` <type>,
  `dolar_price` <type>,
  `cashier` <type>
);

CREATE TABLE `tbl_container` (
  `container_id` <type>,
  `container_price` <type>,
  `product_id` <type>,
  `budget_id` <type>
);

CREATE TABLE `tbl_dolar` (
  `dolar_price` <type>,
  `date` <type>
);

CREATE TABLE `tbl_barcode` (
  `barcode_id` <type>,
  `product_id` <type>,
  `storage_id` <type>
);

CREATE TABLE `tbl_debt` (
  `debt_id` <type>,
  `debt_amount` <type>,
  `order_id` <type>,
  `branch_id` <type>,
  `company_id` <type>,
  `payment_id` <type>
);

CREATE TABLE `tbl_install_dates` (
  `i_id` <type>,
  `date_payed` <type>,
  `amount_payed` <type>,
  `remaining_amount` <type>
);

CREATE TABLE `tbl_budget` (
  `budget_id` <type>,
  `b_amount` <type>
);

CREATE TABLE `tbl_storage` (
  `storage_id` <type>,
  `s_address` <type>
);

CREATE TABLE `tbl_prdctType` (
  `prdct_id` <type>,
  `productType` <type>
);

CREATE TABLE `tbl_position` (
  `position_id` <type>,
  `p_name` <type>
);

CREATE TABLE `tbl_employee` (
  `employee_id` <type>,
  `e_FullName` <type>,
  `e_address` <type>,
  `e_phone` <type>,
  `position_id` <type>,
  `branch_id` <type>,
  `username` <type>,
  `password` <type>,
  `user_type` <type>,
  `stauts` <type>
);

CREATE TABLE `tbl_paymentMethod` (
  `payment_id` <type>,
  `method` <type>
);