Advertisement
Guest User

Untitled

a guest
May 29th, 2017
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.50 KB | None | 0 0
  1. users:
  2. columns:
  3. id:
  4. primary: true
  5. notnull: true
  6. autoincrement: true
  7. name:
  8. surname:
  9. username:
  10. password:
  11. birthdate:
  12. type: date
  13. gender:
  14. type: string(10)
  15. email:
  16. type: string(50)
  17. registrationDate:
  18. lastaccessDate:
  19. activation:
  20. dogs_id:
  21. teams_id:
  22. published:
  23. type: integer(11)
  24. relations:
  25. dogs:
  26. local: dogs_id
  27. foreign: id
  28. teams:
  29. local: teams_id
  30. foreign: id
  31. dogs:
  32. columns:
  33. id:
  34. primary: true
  35. autoincrement: true
  36. name:
  37. birthdate:
  38. type: date
  39. gender:
  40. type: string(10)
  41. photo:
  42. description:
  43. breeds_id:
  44. gallery_id:
  45. relations:
  46. breeds:
  47. local: breeds_id
  48. foreign: id
  49. gallery:
  50. local: gallery_id
  51. foreign: id
  52. breeds:
  53. columns:
  54. id:
  55. primary: true
  56. autoincrement: true
  57. name:
  58. photo:
  59. columns:
  60. id:
  61. primary: true
  62. autoincrement: true
  63. photo:
  64. thumbs:
  65. description:
  66. gallery_id:
  67. relations:
  68. gallery:
  69. local: gallery_id
  70. foreign: id
  71. gallery:
  72. columns:
  73. id:
  74. primary: true
  75. autoincrement: true
  76. name:
  77. description:
  78. teams:
  79. columns:
  80. id:
  81. primary: true
  82. type: integer(11)
  83. notnull: true
  84. autoincrement: true
  85. logo:
  86. type: string(50)
  87. name:
  88. type: string(100)
  89. description:
  90. type: string
  91. url:
  92. type: string(100)
  93. country:
  94. type: string(50)
  95. flag_code:
  96. type: string(10)
  97. teammanager:
  98. type: string(50)
  99. ordering:
  100. default: 1
  101. type: integer(11)
  102. published:
  103. type: integer(11)
  104.  
  105.  
  106. types:
  107. columns:
  108. id:
  109. primary: true
  110. type: integer(11)
  111. autoincrement: true
  112. name:
  113. type: string(50)
  114. description:
  115. type: string(100)
  116. published:
  117. type: integer(11)
  118. classes:
  119. columns:
  120. id:
  121. primary: true
  122. type: integer(11)
  123. autoincrement: true
  124. name:
  125. type: string(50)
  126. description:
  127. type: string(250)
  128. ordering:
  129. default: 1
  130. type: integer(11)
  131. published:
  132. type: integer(11)
  133. races:
  134. columns:
  135. id:
  136. primary: true
  137. type: integer
  138. autoincrement: true
  139. seasons_id:
  140. type: integer(11)
  141. date:
  142. type: date
  143. location:
  144. type: string(50)
  145. name:
  146. type: string(50)
  147. description:
  148. type: string(200)
  149. elements:
  150. type: integer(11)
  151. timelimit:
  152. type: time
  153. published:
  154. type: integer(11)
  155. image:
  156. type: string(100)
  157. relations:
  158. seasons:
  159. local: seasons_id
  160. foreign: id
  161. seasons:
  162. columns:
  163. id:
  164. primary: true
  165. type: integer(11)
  166. autoincrement: true
  167. name:
  168. type: string(50)
  169. description:
  170. type: string(255)
  171. ordering:
  172. type: integer(11)
  173. published:
  174. type: integer(11)
  175. results:
  176. columns:
  177. id:
  178. primary: true
  179. type: integer
  180. autoincrement: true
  181. dogs_id:
  182. type: integer
  183. races_id:
  184. type: integer
  185. classes_id:
  186. types_id:
  187. result:
  188. points:
  189. penality:
  190. comment:
  191. published:
  192. type: integer(11)
  193. relations:
  194. dogs:
  195. local: dogs_id
  196. foreign: id
  197. races:
  198. local: races_id
  199. foreign: id
  200. types:
  201. local: types_id
  202. foreign: id
  203. classes:
  204. local: classes_id
  205. foreign: id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement