Falko-API/db/schema.rb at 14604af0bec96a3d70d7df697743c06215c2cc6c · falko-org/Falko-API · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
# This file is auto-generated from the current state of the database. Instead
# of editing this file, please use the migrations feature of Active Record to
# incrementally modify your database, and then regenerate this schema definition.
#
# Note that this schema.rb definition is the authoritative source for your
# database schema. If you need to create the application database on another
# system, you should be using db:schema:load, not running all the migrations
# from scratch. The latter is a flawed and unsustainable approach (the more migrations
# you'll amass, the slower it'll run and the greater likelihood for issues).
#
# It's strongly recommended that you check this file into your version control system.

ActiveRecord::Schema.define(version: 20191013155716) do

  # These are extensions that must be enabled in order to support this database
  enable_extension "plpgsql"

  create_table "grades", force: :cascade do |t|
    t.float "weight_burndown"
    t.float "weight_velocity"
    t.float "weight_debts"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.bigint "project_id"
    t.index ["project_id"], name: "index_grades_on_project_id"
  end

  create_table "projects", force: :cascade do |t|
    t.string "name"
    t.text "description"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.bigint "user_id"
    t.string "github_slug"
    t.boolean "is_project_from_github"
    t.boolean "is_scoring"
    t.index ["user_id"], name: "index_projects_on_user_id"
  end

  create_table "releases", force: :cascade do |t|
    t.string "name"
    t.text "description"
    t.integer "amount_of_sprints"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.bigint "project_id"
    t.date "initial_date"
    t.date "final_date"
    t.index ["project_id"], name: "index_releases_on_project_id"
  end

  create_table "retrospectives", force: :cascade do |t|
    t.text "sprint_report"
    t.text "positive_points", default: [], array: true
    t.text "negative_points", default: [], array: true
    t.text "improvements", default: [], array: true
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.bigint "sprint_id"
    t.index ["sprint_id"], name: "index_retrospectives_on_sprint_id"
  end

  create_table "revisions", force: :cascade do |t|
    t.text "done_report", array: true
    t.text "undone_report", array: true
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.bigint "sprint_id"
    t.index ["sprint_id"], name: "index_revisions_on_sprint_id"
  end

  create_table "sprints", force: :cascade do |t|
    t.string "name"
    t.text "description"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.bigint "release_id"
    t.date "initial_date"
    t.date "final_date"
    t.index ["release_id"], name: "index_sprints_on_release_id"
  end

  create_table "stories", force: :cascade do |t|
    t.string "name"
    t.text "description"
    t.string "assign"
    t.string "pipeline"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.bigint "sprint_id"
    t.date "initial_date"
    t.date "final_date"
    t.integer "story_points"
    t.string "issue_number"
    t.integer "issue_id"
    t.index ["sprint_id"], name: "index_stories_on_sprint_id"
  end

  create_table "users", force: :cascade do |t|
    t.string "name"
    t.string "email"
    t.string "password_digest"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.string "access_token"
    t.string "reset_password_token"
    t.datetime "reset_password_sent_at"
    t.boolean "confirmation_token", default: false
  end

  add_foreign_key "grades", "projects"
  add_foreign_key "projects", "users"
  add_foreign_key "releases", "projects"
  add_foreign_key "retrospectives", "sprints"
  add_foreign_key "revisions", "sprints"
  add_foreign_key "sprints", "releases"
  add_foreign_key "stories", "sprints"
end