PageRenderTime 47ms CodeModel.GetById 18ms RepoModel.GetById 1ms app.codeStats 0ms

/db/schema.rb

https://gitlab.com/VoroninNick/radok
Ruby | 356 lines | 307 code | 37 blank | 12 comment | 0 complexity | 3e4ca34cf35f881e580a9dfb0911a30f MD5 | raw file
  1. # encoding: UTF-8
  2. # This file is auto-generated from the current state of the database. Instead
  3. # of editing this file, please use the migrations feature of Active Record to
  4. # incrementally modify your database, and then regenerate this schema definition.
  5. #
  6. # Note that this schema.rb definition is the authoritative source for your
  7. # database schema. If you need to create the application database on another
  8. # system, you should be using db:schema:load, not running all the migrations
  9. # from scratch. The latter is a flawed and unsustainable approach (the more migrations
  10. # you'll amass, the slower it'll run and the greater likelihood for issues).
  11. #
  12. # It's strongly recommended that you check this file into your version control system.
  13. ActiveRecord::Schema.define(version: 20151111152912) do
  14. create_table "assets", force: :cascade do |t|
  15. t.integer "assetable_id"
  16. t.string "assetable_type"
  17. t.string "assetable_field_name"
  18. t.string "data_file_name"
  19. t.string "data_content_type"
  20. t.integer "data_file_size"
  21. t.datetime "data_updated_at"
  22. t.string "data_alt"
  23. t.datetime "created_at", null: false
  24. t.datetime "updated_at", null: false
  25. end
  26. create_table "banners", force: :cascade do |t|
  27. t.integer "page_id"
  28. t.string "title"
  29. t.string "description"
  30. t.string "background_image_file_name"
  31. t.string "background_image_content_type"
  32. t.integer "background_image_file_size"
  33. t.datetime "background_image_updated_at"
  34. t.string "button_label"
  35. t.string "button_url"
  36. t.datetime "created_at", null: false
  37. t.datetime "updated_at", null: false
  38. t.string "title_html_tag"
  39. end
  40. create_table "ckeditor_assets", force: :cascade do |t|
  41. t.string "data_file_name", null: false
  42. t.string "data_content_type"
  43. t.integer "data_file_size"
  44. t.integer "assetable_id"
  45. t.string "assetable_type", limit: 30
  46. t.string "type", limit: 30
  47. t.integer "width"
  48. t.integer "height"
  49. t.datetime "created_at"
  50. t.datetime "updated_at"
  51. end
  52. add_index "ckeditor_assets", ["assetable_type", "assetable_id"], name: "idx_ckeditor_assetable"
  53. add_index "ckeditor_assets", ["assetable_type", "type", "assetable_id"], name: "idx_ckeditor_assetable_type"
  54. create_table "contact_feedbacks", force: :cascade do |t|
  55. t.string "name"
  56. t.string "email"
  57. t.string "subject"
  58. t.text "description"
  59. t.datetime "created_at", null: false
  60. t.datetime "updated_at", null: false
  61. end
  62. create_table "contact_requests", force: :cascade do |t|
  63. t.string "subject"
  64. t.string "name"
  65. t.string "email"
  66. t.text "description"
  67. t.datetime "created_at", null: false
  68. t.datetime "updated_at", null: false
  69. end
  70. create_table "faq_articles", force: :cascade do |t|
  71. t.boolean "published"
  72. t.string "name"
  73. t.text "content"
  74. t.datetime "created_at", null: false
  75. t.datetime "updated_at", null: false
  76. t.string "url_fragment"
  77. end
  78. create_table "faq_requests", force: :cascade do |t|
  79. t.string "name"
  80. t.string "email"
  81. t.string "subject"
  82. t.text "description"
  83. t.datetime "created_at", null: false
  84. t.datetime "updated_at", null: false
  85. end
  86. create_table "form_configs", force: :cascade do |t|
  87. t.string "type"
  88. t.text "email_receivers"
  89. t.datetime "created_at", null: false
  90. t.datetime "updated_at", null: false
  91. end
  92. create_table "html_blocks", force: :cascade do |t|
  93. t.text "content"
  94. t.integer "attachable_id"
  95. t.string "attachable_type"
  96. t.string "attachable_field_name"
  97. t.string "key"
  98. end
  99. create_table "leaders", force: :cascade do |t|
  100. t.string "image_file_name"
  101. t.string "image_content_type"
  102. t.integer "image_file_size"
  103. t.datetime "image_updated_at"
  104. t.string "name"
  105. t.string "position"
  106. t.datetime "created_at", null: false
  107. t.datetime "updated_at", null: false
  108. end
  109. create_table "meta_data", force: :cascade do |t|
  110. t.string "page_type"
  111. t.integer "page_id"
  112. t.string "head_title"
  113. t.text "keywords"
  114. t.text "description"
  115. t.datetime "created_at", null: false
  116. t.datetime "updated_at", null: false
  117. end
  118. create_table "pages", force: :cascade do |t|
  119. t.string "type"
  120. t.string "name"
  121. t.text "content"
  122. t.string "url"
  123. t.datetime "created_at", null: false
  124. t.datetime "updated_at", null: false
  125. end
  126. create_table "schedule_call_requests", force: :cascade do |t|
  127. t.string "phone"
  128. t.string "name"
  129. t.text "description"
  130. t.datetime "created_at", null: false
  131. t.datetime "updated_at", null: false
  132. end
  133. create_table "simple_wizard_tests", force: :cascade do |t|
  134. t.string "tot__type_of_test"
  135. t.string "top__type_of_product"
  136. t.text "ps__platforms"
  137. t.string "ps__hours"
  138. t.string "pi__project_name"
  139. t.string "pi__project_version"
  140. t.text "pi__project_languages"
  141. t.text "pi__report_languages"
  142. t.string "tp__type_of_testing"
  143. t.text "tp__exploratory_instructions"
  144. t.string "tp__test_case_attachment_file_name"
  145. t.string "tp__test_case_attachment_content_type"
  146. t.integer "tp__test_case_attachment_file_size"
  147. t.datetime "tp__test_case_attachment_updated_at"
  148. t.string "pa__access_instructions_url"
  149. t.string "pa__access_instructions_attachment_file_name"
  150. t.string "pa__access_instructions_attachment_content_type"
  151. t.integer "pa__access_instructions_attachment_file_size"
  152. t.datetime "pa__access_instructions_attachment_updated_at"
  153. t.string "pa__access_user_name"
  154. t.string "pa__access_password"
  155. t.boolean "pa__need_authorization"
  156. t.text "pa__comment"
  157. t.datetime "created_at", null: false
  158. t.datetime "updated_at", null: false
  159. t.text "state"
  160. end
  161. create_table "sitemap_elements", force: :cascade do |t|
  162. t.string "page_type"
  163. t.integer "page_id"
  164. t.boolean "display_on_sitemap"
  165. t.string "changefreq"
  166. t.float "priority"
  167. t.datetime "created_at", null: false
  168. t.datetime "updated_at", null: false
  169. end
  170. create_table "users", force: :cascade do |t|
  171. t.string "encrypted_password", default: "", null: false
  172. t.string "reset_password_token"
  173. t.datetime "reset_password_sent_at"
  174. t.datetime "remember_created_at"
  175. t.integer "sign_in_count", default: 0, null: false
  176. t.datetime "current_sign_in_at"
  177. t.datetime "last_sign_in_at"
  178. t.string "current_sign_in_ip"
  179. t.string "last_sign_in_ip"
  180. t.string "confirmation_token"
  181. t.datetime "confirmed_at"
  182. t.datetime "confirmation_sent_at"
  183. t.string "unconfirmed_email"
  184. t.string "first_name"
  185. t.string "last_name"
  186. t.string "country"
  187. t.string "city"
  188. t.integer "zip_code"
  189. t.string "company_url"
  190. t.string "username"
  191. t.string "image"
  192. t.string "email"
  193. t.string "billing_cardholder_name"
  194. t.string "billing_address"
  195. t.string "billing_card_number"
  196. t.string "billing_cvv_number"
  197. t.string "full_name"
  198. t.boolean "subscribed"
  199. t.string "phone"
  200. t.string "avatar_file_name"
  201. t.string "avatar_content_type"
  202. t.integer "avatar_file_size"
  203. t.datetime "avatar_updated_at"
  204. t.datetime "created_at"
  205. t.datetime "updated_at"
  206. t.string "role"
  207. t.string "provider"
  208. t.string "uid"
  209. end
  210. add_index "users", ["confirmation_token"], name: "index_users_on_confirmation_token", unique: true
  211. add_index "users", ["email"], name: "index_users_on_email"
  212. add_index "users", ["reset_password_token"], name: "index_users_on_reset_password_token", unique: true
  213. create_table "wizard_devices", force: :cascade do |t|
  214. t.integer "manufacturer_id"
  215. t.string "model"
  216. t.string "os"
  217. t.integer "screen_pixel_width"
  218. t.integer "screen_pixel_height"
  219. t.datetime "created_at", null: false
  220. t.datetime "updated_at", null: false
  221. end
  222. add_index "wizard_devices", ["manufacturer_id"], name: "index_wizard_devices_on_manufacturer_id"
  223. create_table "wizard_manufacturers", force: :cascade do |t|
  224. t.string "name"
  225. t.datetime "created_at", null: false
  226. t.datetime "updated_at", null: false
  227. end
  228. create_table "wizard_platforms", force: :cascade do |t|
  229. t.string "name"
  230. t.integer "testers_count"
  231. t.string "ancestry"
  232. t.datetime "created_at", null: false
  233. t.datetime "updated_at", null: false
  234. t.integer "position"
  235. t.string "avatar_file_name"
  236. t.string "avatar_content_type"
  237. t.integer "avatar_file_size"
  238. t.datetime "avatar_updated_at"
  239. end
  240. create_table "wizard_platforms_product_types", id: false, force: :cascade do |t|
  241. t.integer "platform_id"
  242. t.integer "product_type_id"
  243. end
  244. add_index "wizard_platforms_product_types", ["platform_id", "product_type_id"], name: "index_unique_platforms_product_types", unique: true
  245. create_table "wizard_product_types", force: :cascade do |t|
  246. t.string "name"
  247. t.string "image_file_name"
  248. t.string "image_content_type"
  249. t.integer "image_file_size"
  250. t.datetime "image_updated_at"
  251. t.datetime "created_at", null: false
  252. t.datetime "updated_at", null: false
  253. end
  254. create_table "wizard_project_languages", force: :cascade do |t|
  255. t.string "name"
  256. t.datetime "created_at", null: false
  257. t.datetime "updated_at", null: false
  258. end
  259. create_table "wizard_report_languages", force: :cascade do |t|
  260. t.string "name"
  261. t.datetime "created_at", null: false
  262. t.datetime "updated_at", null: false
  263. end
  264. create_table "wizard_test_platforms", id: false, force: :cascade do |t|
  265. t.integer "platform_id", null: false
  266. t.integer "test_id", null: false
  267. t.integer "testers_count"
  268. t.datetime "created_at", null: false
  269. t.datetime "updated_at", null: false
  270. end
  271. add_index "wizard_test_platforms", ["test_id", "platform_id"], name: "index_wizard_test_platform_unique_bindings", unique: true
  272. create_table "wizard_test_project_languages", force: :cascade do |t|
  273. t.integer "test_id"
  274. t.integer "project_language_id"
  275. end
  276. add_index "wizard_test_project_languages", ["project_language_id"], name: "index_wizard_test_project_languages_on_project_language_id"
  277. add_index "wizard_test_project_languages", ["test_id"], name: "index_wizard_test_project_languages_on_test_id"
  278. create_table "wizard_test_report_languages", force: :cascade do |t|
  279. t.integer "test_id"
  280. t.integer "report_language_id"
  281. end
  282. add_index "wizard_test_report_languages", ["report_language_id"], name: "index_wizard_test_report_languages_on_report_language_id"
  283. add_index "wizard_test_report_languages", ["test_id"], name: "index_wizard_test_report_languages_on_test_id"
  284. create_table "wizard_test_types", force: :cascade do |t|
  285. t.string "name"
  286. t.string "image_file_name"
  287. t.string "image_content_type"
  288. t.integer "image_file_size"
  289. t.datetime "image_updated_at"
  290. t.datetime "created_at", null: false
  291. t.datetime "updated_at", null: false
  292. end
  293. create_table "wizard_tests", force: :cascade do |t|
  294. t.string "state"
  295. t.float "percent_completed"
  296. t.integer "hours_per_tester"
  297. t.string "project_name"
  298. t.string "project_version"
  299. t.string "methodology_type"
  300. t.text "exploratory_description"
  301. t.string "project_url"
  302. t.boolean "authentication_required"
  303. t.string "auth_login"
  304. t.string "auth_password"
  305. t.text "comment"
  306. t.datetime "created_at", null: false
  307. t.datetime "updated_at", null: false
  308. t.integer "product_type_id"
  309. t.integer "test_type_id"
  310. t.integer "user_id"
  311. t.integer "active_step_number"
  312. t.integer "proceeded_steps_count"
  313. t.datetime "completed_at"
  314. t.datetime "tested_at"
  315. t.datetime "expected_tested_at"
  316. t.boolean "successful"
  317. t.integer "current_step_id"
  318. end
  319. end