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>
);