在3台轨道上相关

Question

我必须创建第三个表，并用第二个表进行了安装。

1st table: Schema
2nd table: Entity 
3rd table: Fields

它们之间的关系是：

Schema(id) ===>  Entity
Entity(id) ===> Fields

我已经创建了表格和视图直到实体，但不知道如何为

具有值的字段创建表：

"clientId"
"name"
"description"
"mnemonic"
"columnType"
"display"
"fallbackId"
"conceptDisplay"
"businessName"

帮助我创建模型和视图以显示与实体相关的所有fiels：

我尝试了一些东西像这样：

entity.rb =＆gt;型号

class Entity < ApplicationRecord
  belongs_to :schema
  has_many :fields, dependent: :destroy
end

field.rb =＆gt;模型

class Field < ApplicationRecord
  belongs_to :entity
end

schema.rb =＆gt; 字段的模型

class Schema < ApplicationRecord
  has_many :entities, dependent: :destroy
   has_many :fields, through: :entities

  validates :name, presence: true, uniqueness: true
  validates :schemaId, presence: true, uniqueness: true
end

控制器：

class FieldsController < ApplicationController
  def index
    @field = Schema.find_by(id: params[:id]).fields
  end
end

实体的视图，我必须创建link_to以显示该实体的所有字段

<div class="content">
  <ul>
  <% @entities.each do |data| %>
    <li>
      <%= data.clientId %>
      <%= link_to data.name, fields_index_path(id: data.id) %>
      <%= data.description %>
      <%= data.mnemonic %>
    </li>

  <% end %>
</ul>
</div>

Answer 1

您需要创建这些迁移：

  def change
    create_table :schemas do |t|
      # here all your necessary fields for schema
      t.timestamps
    end
  end

  def change
    create_table :entities do |t|
      t.references :schema, null: false, foreign_key: true
      # here all your necessary fields for entity
      t.timestamps
    end
  end

def change
  create_table :fields do |t|
    t.references :entity, null: false, foreign_key: true
    # here all your necessary fields for field
    t.timestamps
  end
end

并将所有必要的关联添加到模型中

# schema.rb
class Schema < ApplicationRecord
  has_many :entities
  has_many :fields, through: :entities
end

# entiry.rb
class Entity < ApplicationRecord
  belongs_to :schema
  has_many :fields
end

# field.rb
class Field < ApplicationRecord
  belongs_to :entiry
end

获取所有字段 for schema通过eNTITY在yout Controller中

# fields_controller.rb
class FieldsController < ApplicationController
  def index
    @fields = Schema.find_by(id: params[:id]).fields
  end
end

，并呈现所有链接到您的字段中的视图

# views/fields/index.html.erb
<% @fields.each do |field| %>
  <%= link_to field.name, field_path(field) %>
<% end %>

，并向您的路由添加必要的资源

# configs/routes
resources :schemas
resources :fields