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
  
14ActiveRecord::Schema.define(version: 20161229084919) do
  
15
  
16  create_table "comments", force: :cascade do |t|
  
17    t.text     "content"
  
18    t.integer  "mission_id"
  
19    t.datetime "created_at", null: false
  
20    t.datetime "updated_at", null: false
  
21    t.integer  "user_id"
  
22  end
  
23
  
24  add_index "comments", ["mission_id"], name: "index_comments_on_mission_id"
  
25
  
26  create_table "missions", force: :cascade do |t|
  
27    t.string   "name"
  
28    t.datetime "deadline"
  
29    t.integer  "priority"
  
30    t.integer  "status"
  
31    t.datetime "created_at", null: false
  
32    t.datetime "updated_at", null: false
  
33    t.string   "content"
  
34    t.integer  "project_id"
  
35  end
  
36
  
37  create_table "missions_users", id: false, force: :cascade do |t|
  
38    t.integer "mission_id"
  
39    t.integer "user_id"
  
40  end
  
41
  
42  create_table "notes", force: :cascade do |t|
  
43    t.string   "content"
  
44    t.integer  "user_id"
  
45    t.datetime "created_at", null: false
  
46    t.datetime "updated_at", null: false
  
47    t.integer  "project_id"
  
48    t.integer  "category"
  
49  end
  
50
  
51  add_index "notes", ["user_id"], name: "index_notes_on_user_id"
  
52
  
53  create_table "projects", force: :cascade do |t|
  
54    t.string   "name"
  
55    t.string   "content"
  
56    t.datetime "created_at", null: false
  
57    t.datetime "updated_at", null: false
  
58  end
  
59
  
60  create_table "projects_users", id: false, force: :cascade do |t|
  
61    t.integer "project_id"
  
62    t.integer "user_id"
  
63  end
  
64
  
65  create_table "shares", force: :cascade do |t|
  
66    t.string   "content"
  
67    t.datetime "created_at", null: false
  
68    t.datetime "updated_at", null: false
  
69    t.integer  "project_id"
  
70    t.integer  "user_id"
  
71  end
  
72
  
73  create_table "users", force: :cascade do |t|
  
74    t.string   "name"
  
75    t.string   "password_digest"
  
76    t.string   "email"
  
77    t.datetime "created_at",      null: false
  
78    t.datetime "updated_at",      null: false
  
79    t.string   "phone"
  
80  end
  
81
  
82end