SHARE
TWEET

Untitled

a guest Dec 8th, 2019 64 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