API de comptabilité horaire.
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970
  1. # This file is auto-generated from the current state of the database. Instead
  2. # of editing this file, please use the migrations feature of Active Record to
  3. # incrementally modify your database, and then regenerate this schema definition.
  4. #
  5. # This file is the source Rails uses to define your schema when running `bin/rails
  6. # db:schema:load`. When creating a new database, `bin/rails db:schema:load` tends to
  7. # be faster and is potentially less error prone than running all of your
  8. # migrations from scratch. Old migrations may fail to apply correctly if those
  9. # migrations use external dependencies or application code.
  10. #
  11. # It's strongly recommended that you check this file into your version control system.
  12. ActiveRecord::Schema.define(version: 2021_05_11_212634) do
  13. create_table "activities", force: :cascade do |t|
  14. t.string "name", null: false
  15. t.string "client"
  16. t.string "description"
  17. t.integer "author_id", null: false
  18. t.datetime "created_at", precision: 6, null: false
  19. t.datetime "updated_at", precision: 6, null: false
  20. t.index ["author_id"], name: "index_activities_on_author_id"
  21. t.index ["name"], name: "index_activities_on_name"
  22. end
  23. create_table "joined_user_activities", force: :cascade do |t|
  24. t.integer "user_id"
  25. t.integer "activity_id"
  26. t.datetime "created_at", precision: 6, null: false
  27. t.datetime "updated_at", precision: 6, null: false
  28. t.index ["activity_id"], name: "index_joined_user_activities_on_activity_id"
  29. t.index ["user_id"], name: "index_joined_user_activities_on_user_id"
  30. end
  31. create_table "records", force: :cascade do |t|
  32. t.integer "duration", null: false
  33. t.integer "user_id", null: false
  34. t.integer "task_id", null: false
  35. t.boolean "is_handled", default: false
  36. t.integer "handled_by_id"
  37. t.datetime "created_at", precision: 6, null: false
  38. t.datetime "updated_at", precision: 6, null: false
  39. t.index ["handled_by_id"], name: "index_records_on_handled_by_id"
  40. t.index ["task_id"], name: "index_records_on_task_id"
  41. t.index ["user_id"], name: "index_records_on_user_id"
  42. end
  43. create_table "tasks", force: :cascade do |t|
  44. t.string "name", null: false
  45. t.text "description"
  46. t.integer "activity_id", null: false
  47. t.integer "user_id", null: false
  48. t.datetime "created_at", precision: 6, null: false
  49. t.datetime "updated_at", precision: 6, null: false
  50. t.index ["activity_id"], name: "index_tasks_on_activity_id"
  51. t.index ["name"], name: "index_tasks_on_name"
  52. t.index ["user_id"], name: "index_tasks_on_user_id"
  53. end
  54. create_table "users", force: :cascade do |t|
  55. t.string "email", null: false
  56. t.string "username", null: false
  57. t.string "password_digest"
  58. t.datetime "created_at", precision: 6, null: false
  59. t.datetime "updated_at", precision: 6, null: false
  60. t.index ["email"], name: "index_users_on_email", unique: true
  61. t.index ["username"], name: "index_users_on_username", unique: true
  62. end
  63. end