質問編集履歴

本日210810を最終更新日とし、タイトルに反映。

2021/08/11 03:45

投稿

kaoru-drosera

スコア23

test CHANGED Viewed

	@@ -1 +1 @@
1	- unknown attribute 'XXX' for XXX. で必要ないはず/存在するはずのカラムが要求される(更新: 210810)
1	+ unknown attribute 'XXX' for XXX. で必要ないはず/存在するはずのカラムが要求される(最終更新: 210810)

test CHANGED Viewed

File without changes

冒頭に「効果音ラボ」と「KLANG」のリンクを追加。

2021/08/11 03:44

投稿

kaoru-drosera

スコア23

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -16,6 +16,16 @@
+効果音ラボ 効果音ポン出し
+https://soundeffect-lab.info/pon/app.html
+KLANG
+http://m-tank.info/common/klang

テーブルの表にseboard_idを忘れていたので更新。

2021/08/11 03:29

投稿

kaoru-drosera

スコア23

test CHANGED Viewed

	@@ -1 +1 @@
1	- unknown attribute 'XXX' for XXX. で必要ないはずのカラムが要求される(更新: 210810)
1	+ unknown attribute 'XXX' for XXX. で必要ないはず/存在するはずのカラムが要求される(更新: 210810)

test CHANGED Viewed

@@ -90,6 +90,8 @@
 |ユーザーid|user_id|bigint|
+|ボタンごとの設定のid|seboard_id|bigint|
 |効果音(をDBに保存する際)の名前|sename|string|
 |効果音の音源データ|sedata|(binary)string|

回答者maisumakunの名前を追加。

2021/08/09 18:05

投稿

kaoru-drosera

スコア23

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -186,7 +186,9 @@
 #####(更新: 210810)
-ご回答ありがとうございます。
+maisumakun様、ご回答ありがとうございます。
 sefileに、seboard_idを追加いたしました。
@@ -448,6 +450,8 @@
 ##### /db/schema.rb(更新：210810)
+sefileに、カラム「**seboard_id**」を追加いたしました。
 ```ruby
 (略)

回答があった通りに修正したところ新しい問題が発生。更新として追記した。

2021/08/09 17:50

投稿

kaoru-drosera

スコア23

test CHANGED Viewed

	@@ -1 +1 @@
1	- unknown attribute 'XXX' for XXX. で必要ないはずのカラムが要求される(仮)
1	+ unknown attribute 'XXX' for XXX. で必要ないはずのカラムが要求される(更新: 210810)

test CHANGED Viewed

@@ -170,7 +170,7 @@
-# 詰まっている箇所
+# 詰まっている箇所(更新:210810)
@@ -184,6 +184,28 @@
+#####(更新: 210810)
+ご回答ありがとうございます。
+sefileに、seboard_idを追加いたしました。
+しかしその結果、以下のようなエラーが出ています。
+![イメージ説明](83a0e96166c65d4d5d22907775529bf6.png)
+「sefile_id」、要するにSefileクラスでは存在するはずのクラスがない、ということになると思われます。
+Sefileもクラスである以上、idが存在しないとは考えにくいです。
+今の所、こればかりは不可解です。
 # 現在のコード
@@ -208,435 +230,349 @@
+  has_one :sefile, :through => :seboards#, foreign_key: 'sefile_id'
+  accepts_nested_attributes_for :sefile
+  # バリデーション(予定)
+end
+```
+###### /app/controllers/sampler_controller.rb
+```ruby
+class SamplerController < ApplicationController
+  before_action :authenticate_user!
+  # 投稿を一覧形式にする(予定)
+  def seindex
+    @samplers = Sampler.all
+  end
+  def save
+    @sampler = Sampler.find_or_initialize_by(sampler_name: params[:sampler_name])
+  end
+  def submit
+    @sampler = Sampler.find_or_initialize_by(sampler_name: params[:sampler_name])
+    # sampler_sefile = Sampler.seboard.sefile.find_or_initialize_by(sename: params[:sename], sedata: params[:sedata])
+    unless @sampler.persisted?
+      @sampler = Sampler.new(sampler_params)
+      @sampler.user_id = current_user.id
+      unless @sampler.save
+        flash[:danger] = "保存に失敗しました"
+      else
+        flash[:success] = "保存しました"
+      end
+    else
+      @sampler = Sampler.update_attrbutes!(update_sampler_params)
+      # @sampler.save
+      unless @sampler.save
+        flash[:danger] = "更新に失敗しました"
+      else
+        flash[:success] = "更新しました"
+      end
+    end
+    redirect_to root_path
+  end
+  def show
+    @sampler = Sampler.find(params[:id])
+  end
+  private
+  def sampler_params
+    params.require(:sampler).permit(:sampler_name, seboards_attributes: [:position, :btncolor, :volume, :loopable, sefile_attributes: [:sename, :sedata]])
+  end
+  def update_sampler_params
+    params.require(:sampler).permit(:sampler_name, seboards_attributes: [:position, :btncolor, :volume, :loopable, sefile_attributes: [:sename, :sedata, :id]])
+  end
+end
+```
+##### /app/views/sampler/_save.html.erb
+```html
+ # 字数制限につき一時的に削除　申し訳ありません
+```
+##### /app/models/seboard.rb
+```ruby
+class Seboard < ApplicationRecord
+  belongs_to :sampler
+  has_one :sefile#, class_name: "Sefile", foreign_key: 'id'
+  # ↑
-  # has_many :sefiles
+  # has_many :sefiles にするとうまくいった。
+  # この調子だと下の式のものやviewとcontrollerに点在するsefileの設定も複数形にするといいのだろうが、こちらを単数形にしたい。
+  accepts_nested_attributes_for :sefile
   # accepts_nested_attributes_for :sefiles
-  has_one :sefile, :through => :seboards#, foreign_key: 'sefile_id'
-  accepts_nested_attributes_for :sefile
-  # バリデーション(予定)
 end
 ```
-###### /app/controllers/sampler_controller.rb
+##### /app/models/sefile.rb(更新：210810)
 ```ruby
-class SamplerController < ApplicationController
+class Sefile < ApplicationRecord
+  belongs_to :user, class_name: "User", foreign_key: 'user_id'
-  before_action :authenticate_user!
+  belongs_to :seboard, optional: true
-  # 投稿を一覧形式にする(予定)
-  def seindex
-    @samplers = Sampler.all
-  end
-  def save
-    @sampler = Sampler.find_or_initialize_by(sampler_name: params[:sampler_name])
-  end
-  def submit
-    @sampler = Sampler.find_or_initialize_by(sampler_name: params[:sampler_name])
-    # sampler_sefile = Sampler.seboard.sefile.find_or_initialize_by(sename: params[:sename], sedata: params[:sedata])
-    unless @sampler.persisted?
-      @sampler = Sampler.new(sampler_params)
+  mount_uploader :sedata, SeUploader
-      @sampler.user_id = current_user.id
-      unless @sampler.save
-        flash[:danger] = "保存に失敗しました"
-      else
-        flash[:success] = "保存しました"
-      end
-    else
-      @sampler = Sampler.update_attrbutes!(update_sampler_params)
-      # @sampler.save
+  # バリデーションはこれ以降に
-      unless @sampler.save
-        flash[:danger] = "更新に失敗しました"
-      else
-        flash[:success] = "更新しました"
-      end
-    end
-    redirect_to root_path
-  end
-  def show
-    @sampler = Sampler.find(params[:id])
-  end
-  private
-  def sampler_params
-    params.require(:sampler).permit(:sampler_name, seboards_attributes: [:position, :btncolor, :volume, :loopable, sefile_attributes: [:sename, :sedata]])
-  end
-  def update_sampler_params
-    params.require(:sampler).permit(:sampler_name, seboards_attributes: [:position, :btncolor, :volume, :loopable, sefile_attributes: [:sename, :sedata, :id]])
-  end
 end
-```
-##### /app/views/sampler/_save.html.erb
-```html
-  <%= form_with model: @sampler do |sp| %>
-    <%= fields_for :seboards do |sb| %>
-      <%= fields_for :sefile do |sf| %>
-  <!-- 上段 -->
-  <div id="bg-q" class="case-btn-q case-btn" onclick="play(soundQ, loopQ, loopValue_q); btnColorInit(btnColorQ, bg_Q)">
-    <p>Q</p>
-    <%= sb.hidden_field :position,:name=>"sampler[seboards_attributes][1][position]", :value => "1" %>
-    <%= sb.range_field :volume, :name=>"sampler[seboards_attributes][1][volume]", :onchange=>"volumeInit(soundQ, volumeQ, volumeValue_q)", :id=>"vol-q", :value=>50, :min=>1, :max=>99 %>
-    <div class="radio-field_q">
-      <%= sb.radio_button :btncoler, "1", :name=>"sampler[seboards_attributes][1][btncolor]", checked: true, :class=>"red" %>
-      <%= sb.radio_button :btncoler, "2", :name=>"sampler[seboards_attributes][1][btncolor]", :class=>"blue" %>
-      <%= sb.radio_button :btncoler, "3", :name=>"sampler[seboards_attributes][1][btncolor]", :class=>"white" %>
-    </div><!--  .radio-field_q -->
-    <%= sb.check_box "loopable", :name=>"sampler[seboards_attributes][1][loopable]", :onclick=>"loopInit(soundQ, loopQ, loopValue_q)", :id=>"loopable_q", :checked_value =>true, :unchecked_value=>false %>
-      <%= sf.file_field :sedata, :name=>"sampler[seboards_attributes][1][sefile_attributes][sedata]", :id=>"selectFile_q", :onclick=>"readFile(soundQ, form_fileQ)" %>
-      <%= sf.text_field :sename, :name=>"sampler[seboards_attributes][1][sefile_attributes][sename]" %>
-  </div><!--  .case-btn-d -->
-  <div id="bg-w" class="case-btn-w case-btn" onclick="play(soundW, loopW, loopValue_w); btnColorInit(btnColorW, bg_W)">
-    <p>W</p>
-      (字数制限につき略)
-      <%= sf.text_field :sename, :name=>"sampler[seboards_attributes][2][sefile_attributes][sename]" %>
-  </div><!--  .case-btn-d -->
-  <%= sp.submit "保存する" %>
-  <% end %>
-```
-##### /app/models/seboard.rb
+```
+##### /db/schema.rb(更新：210810)
 ```ruby
+(略)
+ActiveRecord::Schema.define(version: 2021_08_09_172009) do
+  # These are extensions that must be enabled in order to support this database
+  enable_extension "plpgsql"
+  create_table "samplers", force: :cascade do |t|
+    t.bigint "user_id", null: false
+    t.string "sampler_name"
+    t.datetime "created_at", precision: 6, null: false
+    t.datetime "updated_at", precision: 6, null: false
+    t.index ["user_id"], name: "index_samplers_on_user_id"
+  end
+  create_table "seboards", force: :cascade do |t|
+    t.bigint "sampler_id", null: false
+    t.bigint "sefile_id"
-class Seboard < ApplicationRecord
+    t.integer "position"
+    t.integer "btncolor"
+    t.integer "volume"
-  belongs_to :sampler
+    t.boolean "loopable"
+    t.datetime "created_at", precision: 6, null: false
+    t.datetime "updated_at", precision: 6, null: false
+    t.index ["sampler_id"], name: "index_seboards_on_sampler_id"
+    t.index ["sefile_id"], name: "index_seboards_on_sefile_id"
+  end
-  has_one :sefile#, class_name: "Sefile", foreign_key: 'id'
+  create_table "sefiles", force: :cascade do |t|
-  # ↑
+    t.bigint "user_id", null: false
-  # has_many :sefiles にするとうまくいった。
+    t.string "sename"
+    t.string "sedata"
+    t.datetime "created_at", precision: 6, null: false
+    t.datetime "updated_at", precision: 6, null: false
+    t.bigint "seboard_id"
+    t.index ["seboard_id"], name: "index_sefiles_on_seboard_id"
-  # この調子だと下の式のものやviewとcontrollerに点在するsefileの設定も複数形にするといいのだろうが、こちらを単数形にしたい。
+    t.index ["user_id"], name: "index_sefiles_on_user_id"
+  end
-  accepts_nested_attributes_for :sefile
+  create_table "users", force: :cascade do |t|
+    t.string "user_name"
+    t.datetime "created_at", precision: 6, null: false
+    t.datetime "updated_at", precision: 6, null: false
+    t.string "password_digest"
+    t.string "email", default: "", null: false
+    t.string "encrypted_password", default: "", null: false
+    t.string "reset_password_token"
+    t.datetime "reset_password_sent_at"
+    t.datetime "remember_created_at"
+    t.index ["email"], name: "index_users_on_email", unique: true
+    t.index ["reset_password_token"], name: "index_users_on_reset_password_token", unique: true
+  end
+  add_foreign_key "samplers", "users"
+  add_foreign_key "seboards", "samplers"
-  # accepts_nested_attributes_for :sefiles
+  add_foreign_key "seboards", "sefiles"
+  add_foreign_key "sefiles", "users"
 end
-```
+```
-##### /app/models/sefile.rb
-```ruby
-class Sefile < ApplicationRecord
-  belongs_to :user, class_name: "User", foreign_key: 'user_id'
-  # belongs_to :samplers, through: :seboards
-  belongs_to :seboard#, class_name: "Seboard", foreign_key: 'seboard_id'
-  mount_uploader :sedata, SeUploader
-  # バリデーションはこれ以降に
-end
-```
-##### /db/schema.rb
-```ruby
-# 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.
-#
-# This file is the source Rails uses to define your schema when running `bin/rails
-# db:schema:load`. When creating a new database, `bin/rails db:schema:load` tends to
-# be faster and is potentially less error prone than running all of your
-# migrations from scratch. Old migrations may fail to apply correctly if those
-# migrations use external dependencies or application code.
-#
-# It's strongly recommended that you check this file into your version control system.
-ActiveRecord::Schema.define(version: 2021_08_08_075948) do
-  # These are extensions that must be enabled in order to support this database
-  enable_extension "plpgsql"
-  create_table "samplers", force: :cascade do |t|
-    t.bigint "user_id", null: false
-    t.string "sampler_name"
-    t.datetime "created_at", precision: 6, null: false
-    t.datetime "updated_at", precision: 6, null: false
-    t.index ["user_id"], name: "index_samplers_on_user_id"
-  end
-  create_table "seboards", force: :cascade do |t|
-    t.bigint "sampler_id", null: false
-    t.bigint "sefile_id", null: false
-    t.integer "position"
-    t.integer "btncolor"
-    t.integer "volume"
-    t.boolean "loopable"
-    t.datetime "created_at", precision: 6, null: false
-    t.datetime "updated_at", precision: 6, null: false
-    t.index ["sampler_id"], name: "index_seboards_on_sampler_id"
-    t.index ["sefile_id"], name: "index_seboards_on_sefile_id"
-  end
-  create_table "sefiles", force: :cascade do |t|
-    t.bigint "user_id", null: false
-    t.string "sename"
-    t.binary "sedata"
-    t.datetime "created_at", precision: 6, null: false
-    t.datetime "updated_at", precision: 6, null: false
-    t.index ["user_id"], name: "index_sefiles_on_user_id"
-  end
-  create_table "users", force: :cascade do |t|
-    t.string "user_name"
-    t.datetime "created_at", precision: 6, null: false
-    t.datetime "updated_at", precision: 6, null: false
-    t.string "password_digest"
-    t.string "email", default: "", null: false
-    t.string "encrypted_password", default: "", null: false
-    t.string "reset_password_token"
-    t.datetime "reset_password_sent_at"
-    t.datetime "remember_created_at"
-    t.index ["email"], name: "index_users_on_email", unique: true
-    t.index ["reset_password_token"], name: "index_users_on_reset_password_token", unique: true
-  end
-  add_foreign_key "samplers", "users"
-  add_foreign_key "seboards", "samplers"
-  add_foreign_key "seboards", "sefiles"
-  add_foreign_key "sefiles", "users"
-end
-```
-# 試したこと

「/app/views/sampler/_save.html.erb」のコードがまるっと抜けていたので足しました。

2021/08/09 17:47

投稿

kaoru-drosera

スコア23

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -364,67 +364,265 @@
 ##### /app/views/sampler/_save.html.erb
+```html
+  <%= form_with model: @sampler do |sp| %>
+    <%= fields_for :seboards do |sb| %>
+      <%= fields_for :sefile do |sf| %>
+  <!-- 上段 -->
+  <div id="bg-q" class="case-btn-q case-btn" onclick="play(soundQ, loopQ, loopValue_q); btnColorInit(btnColorQ, bg_Q)">
+    <p>Q</p>
+    <%= sb.hidden_field :position,:name=>"sampler[seboards_attributes][1][position]", :value => "1" %>
+    <%= sb.range_field :volume, :name=>"sampler[seboards_attributes][1][volume]", :onchange=>"volumeInit(soundQ, volumeQ, volumeValue_q)", :id=>"vol-q", :value=>50, :min=>1, :max=>99 %>
+    <div class="radio-field_q">
+      <%= sb.radio_button :btncoler, "1", :name=>"sampler[seboards_attributes][1][btncolor]", checked: true, :class=>"red" %>
+      <%= sb.radio_button :btncoler, "2", :name=>"sampler[seboards_attributes][1][btncolor]", :class=>"blue" %>
+      <%= sb.radio_button :btncoler, "3", :name=>"sampler[seboards_attributes][1][btncolor]", :class=>"white" %>
+    </div><!--  .radio-field_q -->
+    <%= sb.check_box "loopable", :name=>"sampler[seboards_attributes][1][loopable]", :onclick=>"loopInit(soundQ, loopQ, loopValue_q)", :id=>"loopable_q", :checked_value =>true, :unchecked_value=>false %>
+      <%= sf.file_field :sedata, :name=>"sampler[seboards_attributes][1][sefile_attributes][sedata]", :id=>"selectFile_q", :onclick=>"readFile(soundQ, form_fileQ)" %>
+      <%= sf.text_field :sename, :name=>"sampler[seboards_attributes][1][sefile_attributes][sename]" %>
+  </div><!--  .case-btn-d -->
+  <div id="bg-w" class="case-btn-w case-btn" onclick="play(soundW, loopW, loopValue_w); btnColorInit(btnColorW, bg_W)">
+    <p>W</p>
+      (字数制限につき略)
+      <%= sf.text_field :sename, :name=>"sampler[seboards_attributes][2][sefile_attributes][sename]" %>
+  </div><!--  .case-btn-d -->
+  <%= sp.submit "保存する" %>
+  <% end %>
+```
+##### /app/models/seboard.rb
 ```ruby
+class Seboard < ApplicationRecord
+  belongs_to :sampler
+  has_one :sefile#, class_name: "Sefile", foreign_key: 'id'
+  # ↑
+  # has_many :sefiles にするとうまくいった。
+  # この調子だと下の式のものやviewとcontrollerに点在するsefileの設定も複数形にするといいのだろうが、こちらを単数形にしたい。
+  accepts_nested_attributes_for :sefile
+  # accepts_nested_attributes_for :sefiles
+end
-```
+```
-##### /app/models/seboard.rb
+##### /app/models/sefile.rb
 ```ruby
-class Seboard < ApplicationRecord
+class Sefile < ApplicationRecord
-  belongs_to :sampler
-  has_one :sefile#, class_name: "Sefile", foreign_key: 'id'
+  belongs_to :user, class_name: "User", foreign_key: 'user_id'
-  # ↑
-  # has_many :sefiles にするとうまくいった。
-  # この調子だと下の式のものやviewとcontrollerに点在するsefileの設定も複数形にするといいのだろうが、こちらを単数形にしたい。
-  accepts_nested_attributes_for :sefile
-  # accepts_nested_attributes_for :sefiles
+  # belongs_to :samplers, through: :seboards
+  belongs_to :seboard#, class_name: "Seboard", foreign_key: 'seboard_id'
+  mount_uploader :sedata, SeUploader
+  # バリデーションはこれ以降に
 end
-```
+```
-##### /app/models/sefile.rb
+##### /db/schema.rb
 ```ruby
+# 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.
+#
+# This file is the source Rails uses to define your schema when running `bin/rails
+# db:schema:load`. When creating a new database, `bin/rails db:schema:load` tends to
+# be faster and is potentially less error prone than running all of your
+# migrations from scratch. Old migrations may fail to apply correctly if those
+# migrations use external dependencies or application code.
+#
+# It's strongly recommended that you check this file into your version control system.
+ActiveRecord::Schema.define(version: 2021_08_08_075948) do
+  # These are extensions that must be enabled in order to support this database
+  enable_extension "plpgsql"
+  create_table "samplers", force: :cascade do |t|
+    t.bigint "user_id", null: false
-class Sefile < ApplicationRecord
+    t.string "sampler_name"
+    t.datetime "created_at", precision: 6, null: false
+    t.datetime "updated_at", precision: 6, null: false
-  belongs_to :user, class_name: "User", foreign_key: 'user_id'
+    t.index ["user_id"], name: "index_samplers_on_user_id"
+  end
+  create_table "seboards", force: :cascade do |t|
-  # belongs_to :samplers, through: :seboards
+    t.bigint "sampler_id", null: false
+    t.bigint "sefile_id", null: false
+    t.integer "position"
+    t.integer "btncolor"
+    t.integer "volume"
+    t.boolean "loopable"
+    t.datetime "created_at", precision: 6, null: false
+    t.datetime "updated_at", precision: 6, null: false
+    t.index ["sampler_id"], name: "index_seboards_on_sampler_id"
-  belongs_to :seboard#, class_name: "Seboard", foreign_key: 'seboard_id'
+    t.index ["sefile_id"], name: "index_seboards_on_sefile_id"
+  end
+  create_table "sefiles", force: :cascade do |t|
-  mount_uploader :sedata, SeUploader
+    t.bigint "user_id", null: false
-  # バリデーションはこれ以降に
+    t.string "sename"
+    t.binary "sedata"
+    t.datetime "created_at", precision: 6, null: false
+    t.datetime "updated_at", precision: 6, null: false
+    t.index ["user_id"], name: "index_sefiles_on_user_id"
+  end
+  create_table "users", force: :cascade do |t|
+    t.string "user_name"
+    t.datetime "created_at", precision: 6, null: false
+    t.datetime "updated_at", precision: 6, null: false
+    t.string "password_digest"
+    t.string "email", default: "", null: false
+    t.string "encrypted_password", default: "", null: false
+    t.string "reset_password_token"
+    t.datetime "reset_password_sent_at"
+    t.datetime "remember_created_at"
+    t.index ["email"], name: "index_users_on_email", unique: true
+    t.index ["reset_password_token"], name: "index_users_on_reset_password_token", unique: true
+  end
+  add_foreign_key "samplers", "users"
+  add_foreign_key "seboards", "samplers"
+  add_foreign_key "seboards", "sefiles"
+  add_foreign_key "sefiles", "users"
 end
@@ -434,148 +632,6 @@
-##### /db/schema.rb
-```ruby
-# 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.
-#
-# This file is the source Rails uses to define your schema when running `bin/rails
-# db:schema:load`. When creating a new database, `bin/rails db:schema:load` tends to
-# be faster and is potentially less error prone than running all of your
-# migrations from scratch. Old migrations may fail to apply correctly if those
-# migrations use external dependencies or application code.
-#
-# It's strongly recommended that you check this file into your version control system.
-ActiveRecord::Schema.define(version: 2021_08_08_075948) do
-  # These are extensions that must be enabled in order to support this database
-  enable_extension "plpgsql"
-  create_table "samplers", force: :cascade do |t|
-    t.bigint "user_id", null: false
-    t.string "sampler_name"
-    t.datetime "created_at", precision: 6, null: false
-    t.datetime "updated_at", precision: 6, null: false
-    t.index ["user_id"], name: "index_samplers_on_user_id"
-  end
-  create_table "seboards", force: :cascade do |t|
-    t.bigint "sampler_id", null: false
-    t.bigint "sefile_id", null: false
-    t.integer "position"
-    t.integer "btncolor"
-    t.integer "volume"
-    t.boolean "loopable"
-    t.datetime "created_at", precision: 6, null: false
-    t.datetime "updated_at", precision: 6, null: false
-    t.index ["sampler_id"], name: "index_seboards_on_sampler_id"
-    t.index ["sefile_id"], name: "index_seboards_on_sefile_id"
-  end
-  create_table "sefiles", force: :cascade do |t|
-    t.bigint "user_id", null: false
-    t.string "sename"
-    t.binary "sedata"
-    t.datetime "created_at", precision: 6, null: false
-    t.datetime "updated_at", precision: 6, null: false
-    t.index ["user_id"], name: "index_sefiles_on_user_id"
-  end
-  create_table "users", force: :cascade do |t|
-    t.string "user_name"
-    t.datetime "created_at", precision: 6, null: false
-    t.datetime "updated_at", precision: 6, null: false
-    t.string "password_digest"
-    t.string "email", default: "", null: false
-    t.string "encrypted_password", default: "", null: false
-    t.string "reset_password_token"
-    t.datetime "reset_password_sent_at"
-    t.datetime "remember_created_at"
-    t.index ["email"], name: "index_users_on_email", unique: true
-    t.index ["reset_password_token"], name: "index_users_on_reset_password_token", unique: true
-  end
-  add_foreign_key "samplers", "users"
-  add_foreign_key "seboards", "samplers"
-  add_foreign_key "seboards", "sefiles"
-  add_foreign_key "sefiles", "users"
-end
-```