CREATE TABLE "tbl_products" (
  "product_id" NUMBER(25) PRIMARY KEY,
  "p_name" VARCHAR(25),
  "p_sell_price" NUMBER(10) NOT NULL,
  "branch_id" NUMBER(2) NOT NULL,
  "storage_id" NUMBER(2),
  "company_id" NUMBER(15),
  "prdctType_id" NUMBER(25)NO NULL,
  "barcode_id" NUMBER(25),
  "buy_price" NUMBER(10) NOT NULL,
  "min_price" NUMBER(10)
);

\\ I changed the name of (prdct_id)


CREATE TABLE "tbl_customer" (
  "customer_id" NUMBER(25) NOT NULL,
  "c_FullName" VARCHAR(40) NOT NULL,
  "c_address" VARCHAR(25),
  "c_phone" VARCHAR(15) PRIMARY KEY,
  "c_id_number" NUMBER(25) NOT NULL,
  "c_job" VARCHAR(25),
  "debt_id" NUMBER(25),
  "pshtgiri" VARCHAR(100)
);

CREATE TABLE "tbl_branchs" (
  "branch_id" NUMBER(2) PRIMARY KEY,
  "b_address" VARCHAR(45) NOT NULL,
  "b_phoneNum" VARCHAR(15)
);

CREATE TABLE "tbl_orderDetail" (
  "order_id" NUMBER(25) PRIMARY KEY,
  "company_id" NUMBER(25),
  "product_id" NUMBER(25)
);

CREATE TABLE "tbl_order" (
  "order_id" NUMBER(25) PRIMARY KEY,
  "order_date" DATE NOT NULL,
  "product_id" NUMBER(25) NOT NULL,
  "quantity" NUMBER(10) NOT NULL
);

CREATE TABLE "tbl_company" (
  "company_id" NUMBER(25) PRIMARY KEY,
  "company_name" VARCHAR(25) NOT NULL
);

CREATE TABLE "tbl_installment" (
  "i_id" NUMBER(25) PRIMARY KEY,
  "i_all_amount" NUMBER(10) NOT NULL,
  "product_id" NUMBER(25) NOT NULL,
  "branch_id" NUMBER(2) NOT NULL,
  "customer_id" NUMBER(25),
  "remaining_amount" NUMBER(25),
  "prepay" NUMBER(10) NOT NULL,
  "first_date" DATE,
  "n_of_times" NUMBER(2),
  "remaining_n" NUMBER(2)
);

CREATE TABLE "tbl_wasl" (
  "wasl_id" NUMBER(25) PRIMARY KEY,
  "wasl_date" DARE NOT NULL,
  "employee_id" NUMBER(10) NOT NULL,
  "wasl_amount" NUMBER(25) NOT NULL,
  "product_id" NUMBER(25) NOT NULL,
  "branch_id" NUMBER(2) NOT NULL,
  "customer_id" NUMBER(25),
  "paid_iqd" NUMBER(25),
  "paid_usd" NUMBER(25),
  "i_id" NUMBER(25),
  "product_quantity" NUMBER(5),
  "discount" FLOAT(25),
  "dolar_price" NUMBER(10),
  "cashier" NUMBER(25) NOT NULL
);

CREATE TABLE "tbl_container" (
  "container_id" NUMBER(25) PRIMARY KEY,
  "container_price" NUMBER(25) NOT NULL,
  "product_id" NUMBER(25),
  "budget_id" NUMBER(25)
);

CREATE TABLE "tbl_dolar" (
  "dolar_price" NUMBER(10) PRIMARY KEY,
  "date" DATE NOT NULL
);

CREATE TABLE "tbl_barcode" (
  "barcode_id" NUMBER(25) PRIMARY KEY,
  "product_id" NUMBER(25),
  "storage_id" NUMBER(2)
);

CREATE TABLE "tbl_debt" (
  "debt_id" NUMBER(25) PRIMARY KEY,
  "debt_amount" NUMBER(25) NOT NULL,
  "order_id" NUMBER(25) NOT NULL,
  "branch_id" NUMBER(2) NOT NULL,
  "company_id" NUMBER(25) NOT NULL,
  "payment_id" NUMBER(25)
);