Schemafile

# encoding: utf-8

create_table "comments", options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci", force: :cascade do |t|
  t.integer "user_id", null: false, unsigned: true
  t.integer "daily_report_id", null: false, unsigned: true
  t.string "body", null: false
  t.datetime "created_at", precision: 6, null: false
  t.datetime "updated_at", precision: 6, null: false
  t.index ["daily_report_id"], name: "index_comments_on_daily_report_id"
  t.index ["user_id"], name: "index_comments_on_user_id"
end


create_table "daily_reports", id: :bigint, unsigned: true, force: :cascade, comment: "日報" do |t|
  t.integer "user_id", null: false, unsigned: true
  t.string "title", null: false
  t.text "body", null: false
  t.datetime "updated_at", precision: 6, null: false
  t.datetime "created_at", precision: 6, null: false
  t.index ["user_id"], name: "index_daily_reports_on_user_id"
end

create_table "users", options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci", force: :cascade do |t|
  t.string "email", null: false
  t.string "name", null: false
  t.string "password_digest", null: false
  t.string "auth_token", charset: 'utf8', collation: 'utf8_bin'
  t.datetime "created_at", precision: 6, null: false
  t.datetime "updated_at", precision: 6, null: false
  t.index [:auth_token], unique: true
  t.index [:email], unique: true
end