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.

schema.rb 2.6KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162
  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_10_133939) do
  13. # These are extensions that must be enabled in order to support this database
  14. enable_extension "plpgsql"
  15. create_table "activities", force: :cascade do |t|
  16. t.string "name", null: false
  17. t.string "client"
  18. t.string "description"
  19. t.bigint "author_id", null: false
  20. t.datetime "created_at", precision: 6, null: false
  21. t.datetime "updated_at", precision: 6, null: false
  22. t.index ["author_id"], name: "index_activities_on_author_id"
  23. t.index ["name"], name: "index_activities_on_name"
  24. end
  25. create_table "joined_user_activities", force: :cascade do |t|
  26. t.bigint "user_id"
  27. t.bigint "activity_id"
  28. t.datetime "created_at", precision: 6, null: false
  29. t.datetime "updated_at", precision: 6, null: false
  30. t.index ["activity_id"], name: "index_joined_user_activities_on_activity_id"
  31. t.index ["user_id"], name: "index_joined_user_activities_on_user_id"
  32. end
  33. create_table "tasks", force: :cascade do |t|
  34. t.string "name", null: false
  35. t.text "description"
  36. t.integer "duration"
  37. t.bigint "activity_id", null: false
  38. t.bigint "user_id", null: false
  39. t.datetime "created_at", precision: 6, null: false
  40. t.datetime "updated_at", precision: 6, null: false
  41. t.index ["activity_id"], name: "index_tasks_on_activity_id"
  42. t.index ["name"], name: "index_tasks_on_name"
  43. t.index ["user_id"], name: "index_tasks_on_user_id"
  44. end
  45. create_table "users", force: :cascade do |t|
  46. t.string "email", null: false
  47. t.string "username", null: false
  48. t.string "password_digest"
  49. t.boolean "admin", default: false
  50. t.datetime "created_at", precision: 6, null: false
  51. t.datetime "updated_at", precision: 6, null: false
  52. t.index ["email"], name: "index_users_on_email", unique: true
  53. t.index ["username"], name: "index_users_on_username", unique: true
  54. end
  55. end