SHARE
TWEET

Untitled

a guest Dec 8th, 2019 79 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE "tbl_products" (
  2.   "product_id" <type>,
  3.   "p_name" <type>,
  4.   "p_sell_price" <type>,
  5.   "branch_id" <type>,
  6.   "storage_id" <type>,
  7.   "company_id" <type>,
  8.   "prdct_id" <type>,
  9.   "barcode_id" <type>,
  10.   "buy_price" <type>,
  11.   "min_price" <type>
  12. );
  13.  
  14. CREATE TABLE "tbl_customer" (
  15.   "customer_id" <type>,
  16.   "c_FullName" <type>,
  17.   "c_address" <type>,
  18.   "c_phone" <type>,
  19.   "c_id_number" <type>,
  20.   "c_job" <type>,
  21.   "debt_id" <type>,
  22.   "pshtgiri" <type>
  23. );
  24.  
  25. CREATE TABLE "tbl_branchs" (
  26.   "branch_id" <type>,
  27.   "b_address" <type>,
  28.   "b_phoneNum" <type>
  29. );
  30.  
  31. CREATE TABLE "tbl_orderDetail" (
  32.   "order_id" <type>,
  33.   "company_id" <type>,
  34.   "product_id" <type>
  35. );
  36.  
  37. CREATE TABLE "tbl_order" (
  38.   "order_id" <type>,
  39.   "order_date" <type>,
  40.   "product_id" <type>,
  41.   "quantity" <type>
  42. );
  43.  
  44. CREATE TABLE "tbl_company" (
  45.   "company_id" <type>,
  46.   "company_name" <type>
  47. );
  48.  
  49. CREATE TABLE "tbl_installment" (
  50.   "i_id" <type>,
  51.   "i_all_amount" <type>,
  52.   "product_id" <type>,
  53.   "branch_id" <type>,
  54.   "customer_id" <type>,
  55.   "remaining_amount" <type>,
  56.   "prepay" <type>,
  57.   "first_date" <type>,
  58.   "n_of_times" <type>,
  59.   "remaining_n" <type>
  60. );
  61.  
  62. CREATE TABLE "tbl_wasl" (
  63.   "wasl_id" <type>,
  64.   "wasl_date" <type>,
  65.   "employee_id" <type>,
  66.   "wasl_amount" <type>,
  67.   "product_id" <type>,
  68.   "branch_id" <type>,
  69.   "customer_id" <type>,
  70.   "paid_iqd" <type>,
  71.   "paid_usd" <type>,
  72.   "i_id" <type>,
  73.   "product_quantity" <type>,
  74.   "discount" <type>,
  75.   "dolar_price" <type>,
  76.   "cashier" <type>
  77. );
  78.  
  79. CREATE TABLE "tbl_container" (
  80.   "container_id" <type>,
  81.   "container_price" <type>,
  82.   "product_id" <type>,
  83.   "budget_id" <type>
  84. );
  85.  
  86. CREATE TABLE "tbl_dolar" (
  87.   "dolar_price" <type>,
  88.   "date" <type>
  89. );
  90.  
  91. CREATE TABLE "tbl_barcode" (
  92.   "barcode_id" <type>,
  93.   "product_id" <type>,
  94.   "storage_id" <type>
  95. );
  96.  
  97. CREATE TABLE "tbl_debt" (
  98.   "debt_id" <type>,
  99.   "debt_amount" <type>,
  100.   "order_id" <type>,
  101.   "branch_id" <type>,
  102.   "company_id" <type>,
  103.   "payment_id" <type>
  104. );
  105.  
  106. CREATE TABLE "tbl_install_dates" (
  107.   "i_id" <type>,
  108.   "date_payed" <type>,
  109.   "amount_payed" <type>,
  110.   "remaining_amount" <type>
  111. );
  112.  
  113. CREATE TABLE "tbl_budget" (
  114.   "budget_id" <type>,
  115.   "b_amount" <type>
  116. );
  117.  
  118. CREATE TABLE "tbl_storage" (
  119.   "storage_id" <type>,
  120.   "s_address" <type>
  121. );
  122.  
  123. CREATE TABLE "tbl_prdctType" (
  124.   "prdct_id" <type>,
  125.   "productType" <type>
  126. );
  127.  
  128. CREATE TABLE "tbl_position" (
  129.   "position_id" <type>,
  130.   "p_name" <type>
  131. );
  132.  
  133. CREATE TABLE "tbl_employee" (
  134.   "employee_id" <type>,
  135.   "e_FullName" <type>,
  136.   "e_address" <type>,
  137.   "e_phone" <type>,
  138.   "position_id" <type>,
  139.   "branch_id" <type>,
  140.   "username" <type>,
  141.   "password" <type>,
  142.   "user_type" <type>,
  143.   "stauts" <type>
  144. );
  145.  
  146. CREATE TABLE "tbl_paymentMethod" (
  147.   "payment_id" <type>,
  148.   "method" <type>
  149. );
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top