The id should be an auto-incrementing primary key. Also, column names should be lower cased using an underscore to separate words, i.e. first_name You should also consider adding "created_at" and "updated_at" datetime fields to handle timestamps.
Table names should be pluralized. On May 21, 11:20 am, Mk 27 <[email protected]> wrote: > If I am going to build a sql database for use in rails (rather than > building it in rails), is there anything I need to know beyond using an > id column in every table? Does the id need to be the "primary key"? > -- > Posted viahttp://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
