> > Rails finds it easier to use foreign keys based on id. Are we talking > about rails or about a person manually searching the database using > their hands and eyes? >
A person manually scanning the database (in a MySQL command prompt). If this was actually a useful table (as opposed to just id|name in the RoleType table) and you were searching from it then I agree, but I'm all for simplest solutions until they need refactoring to support something else (so in this case I'd happily go with the text field until you needed to start having other attributes than just a lookup from id to name). Cheers, Andy -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
