English 中文(简体)
如何管理铁路中的非专用主要钥匙?
原标题:How to manage non-autoincrement primary key in Rails?

我有许多局势,在使用铁路时,我想有一个非固定的主要钥匙。

例:我与A和B有一对一的关系,描述了A中的一些具体特征,因此,没有A就不存在。 因此,我们有:

A has one B
B belongs to A

自然思维将具有B.A_id作为主要关键。 因此,我尝试了在移民中的create_table b, :id=>falleset_first_key :a_id in B s model,但并没有在数据库中创造实际的主要钥匙。 我也希望它们(以及外国钥匙),因为数据库将不仅用于这一铁路。

If I create primary keys with execute they don t land in schema.rb, which hurts. Now I m thinking about a workaround: I can live without PK constraint as long as there s unique constraint for that column, so I can use Rails add_index in the migration which seems more elegant.

任何建议?

最佳回答

A StackOverflow的类似问题表明试图做像:

create_table(:b, :id => false) do |t|
  t.integer :a_id, :options =>  PRIMARY KEY 
end
问题回答

暂无回答




相关问题
rails collection_select vs. select

collection_select and select Rails helpers: Which one should I use? I can t see a difference in both ways. Both helpers take a collection and generates options tags inside a select tag. Is there a ...

SSL slowness in EC2

We ve deployed our rails app to EC2. In our setup, we have two proxies on small instances behind round-robin DNS. These run nginx load balancers for a dynamically growing and shrinking farm of web ...

Auth-code with A-Za-z0-9 to use in an URL parameter

As part of a web application I need an auth-code to pass as a URL parameter. I am currently using (in Rails) : Digest::SHA1.hexdigest((object_id + rand(255)).to_s) Which provides long strings like : ...

RubyCAS-Client question: Rails

I ve installed RubyCAS-Client version 2.1.0 as a plugin within a rails app. It s working, but I d like to remove the ?ticket= in the url. Is this possible?

activerecord has_many :through find with one sql call

I have a these 3 models: class User < ActiveRecord::Base has_many :permissions, :dependent => :destroy has_many :roles, :through => :permissions end class Permission < ActiveRecord::...

Ordering a hash to xml: Rails

I m building an xml document from a hash. The xml attributes need to be in order. How can this be accomplished? hash.to_xml

Text Editor for Ruby-on-Rails

guys which text editor is good for Rubyonrails? i m using Windows and i was using E-Texteditor but its not free n its expired now can anyone plese tell me any free texteditor? n which one is best an ...

How to get SQL queries for each user where env is production

I’m developing an application dedicated to generate statistical reports, I would like that user after saving their stat report they save sql queries too. To do that I wrote the following module: ...

热门标签