user and status table definition and relation

rubyonrails-talk
1

Hi

    I have models user and user_status An user always elongs to a particular status at any time Status table has predefined values like "pending","approved" etc My question is what should be the table structure and relation between these models? I am trying like putting status_id in users table And the relation is

user belongs_to user_status

   If so user_status has_one user Is this correct?Please guide me

Tom

2

2.7 Choosing Between belongs_to and has_one If you want to set up a 1–1 relationship between two models, you’ll need to add belongs_to to one, and has_one to the other. How do you know which is which?

The distinction is in where you place the foreign key (it goes on the table for the class declaring the belongs_to association), but you should give some thought to the actual meaning of the data as well. The has_one relationship says that one of something is yours – that is, that something points back to you. For example, it makes more sense to say that a supplier owns an account than that an account owns a supplier. This suggests that the correct relationships are like this:

class Supplier < ActiveRecord::Base   has_one :account end

class Account < ActiveRecord::Base   belongs_to :supplier end The corresponding migration might look like this:

class CreateSuppliers < ActiveRecord::Migration   def self.up     create_table :suppliers do |t|       t.string :name       t.timestamps     end

    create_table :accounts do |t|       t.integer :supplier_id       t.string :account_number       t.timestamps     end   end

  def self.down     drop_table :accounts     drop_table :suppliers   end end

I just pasted from The wonderful rails guides:http:// guides.rubyonrails.org/association_basics.html

hope it helps,

Lake

3

Hi

I have models user and user\_status An user always elongs to a

particular status at any time Status table has predefined values like "pending","approved" etc My question is what should be the table structure and relation between these models? I am trying like putting status_id in users table And the relation is

user belongs_to user_status

If so then your table should be called user_statuses and the column should be user_status_id.

If so user_status has_one user Is this correct?Please guide me

No - since for a given status there are potentially many users in that status (so it's a has_many)

Fred

4

Hi Frederick

    Thanks for your reply. So what i understood is, tables are users and user_statuses .And users table has a column user_status_id Also the relation is

user belongs_to user_status user_status has_many users

        Is this right?

Tom