API tools faq
paste
Guest User

Untitled

a guest
May 22nd, 2018
96
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 3.60 KB | None | 0 0
raw download clone embed print report
  1.  
  2. <?php
  3.  
  4. // start with this
  5. Array
  6. (
  7.     [one-to-one] => Array
  8.         (
  9.         )
  10.  
  11.     [many-to-one] => Array
  12.         (
  13.             [0] => Array
  14.                 (
  15.                     [table] => users
  16.                     [column] => courier_id
  17.                     [related_table] => couriers
  18.                     [related_column] => id
  19.                 )
  20.        
  21.             [1] => Array
  22.                 (
  23.                     [table] => users
  24.                     [column] => wholesaler_id
  25.                     [related_table] => wholesalers
  26.                     [related_column] => id
  27.                 )
  28.        
  29.         )
  30.  
  31.     [one-to-many] => Array
  32.         (
  33.             [0] => Array
  34.                 (
  35.                     [table] => users
  36.                     [column] => id
  37.                     [related_table] => box_event_logs
  38.                     [related_column] => user_id
  39.                     [on_delete] => no_action
  40.                     [on_update] => no_action
  41.                 )
  42.        
  43.             [1] => Array
  44.                 (
  45.                     [table] => users
  46.                     [column] => id
  47.                     [related_table] => boxes
  48.                     [related_column] => user_id
  49.                     [on_delete] => no_action
  50.                     [on_update] => no_action
  51.                 )
  52.        
  53.             [2] => Array
  54.                 (
  55.                     [table] => users
  56.                     [column] => id
  57.                     [related_table] => orders
  58.                     [related_column] => user_id
  59.                     [on_delete] => no_action
  60.                     [on_update] => no_action
  61.                 )
  62.        
  63.         )
  64.  
  65.     [many-to-many] => Array
  66.         (
  67.             [0] => Array
  68.                 (
  69.                     [table] => users
  70.                     [column] => id
  71.                     [related_table] => products
  72.                     [related_column] => id
  73.                     [join_table] => users_free_products
  74.                     [join_column] => user_id
  75.                     [join_related_column] => product_id
  76.                     [on_update] => cascade
  77.                     [on_delete] => cascade
  78.                 )
  79.        
  80.         )
  81.  
  82. )
  83.  
  84. //Converted to this
  85.  
  86. Array
  87. (
  88.  
  89.     [0] => Array
  90.         (
  91.             [table] => users
  92.             [column] => courier_id
  93.             [related_table] => couriers
  94.             [related_column] => id
  95.             [relationship_type] => [many-to-one]
  96.         )
  97.  
  98.     [1] => Array
  99.         (
  100.             [table] => users
  101.             [column] => wholesaler_id
  102.             [related_table] => wholesalers
  103.             [related_column] => id
  104.             [relationship_type] => [many-to-one]
  105.         )
  106.     [2] => Array
  107.         (
  108.             [table] => users
  109.             [column] => id
  110.             [related_table] => box_event_logs
  111.             [related_column] => user_id
  112.             [on_delete] => no_action
  113.             [on_update] => no_action
  114.             [relationship_type] => [one-to-many]
  115.         )
  116.  
  117.     [3] => Array
  118.         (
  119.             [table] => users
  120.             [column] => id
  121.             [related_table] => boxes
  122.             [related_column] => user_id
  123.             [on_delete] => no_action
  124.             [on_update] => no_action
  125.             [relationship_type] => [one-to-many]
  126.         )
  127.  
  128.     [4] => Array
  129.         (
  130.             [table] => users
  131.             [column] => id
  132.             [related_table] => orders
  133.             [related_column] => user_id
  134.             [on_delete] => no_action
  135.             [on_update] => no_action
  136.             [relationship_type] => [one-to-many]
  137.         )
  138.  
  139.  
  140.  
  141.  
  142.     [5] => Array
  143.         (
  144.             [table] => users
  145.             [column] => id
  146.             [related_table] => products
  147.             [related_column] => id
  148.             [join_table] => users_free_products
  149.             [join_column] => user_id
  150.             [join_related_column] => product_id
  151.             [on_update] => cascade
  152.             [on_delete] => cascade
  153.             [many-to-many] => [one-to-many]
  154.         )
  155.  
  156.  
  157.  
  158. )
Add Comment
Please, Sign In to add comment
Public Pastes
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
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!