Thsi is my first question


#1

Hi Everyone,

Just been thinking and working on some problem in Supply Chain and came
across a situation. This is like this using single table inheritance I
have a single table called company and the active record are like this:

class Company < ActiveRecord::Base

class Vendor < Company
class Customer < Company
class Office < Company

Then there is another class called Region which is

class Region < ActiveRecord::Base

now there is many to many relationship between Vendor and Region and
there is many to many relationship between Office < Region and also in
Customer.

Now can I use vendor_id , customer_id and office_id as foreign key or
can only use company_id since the table for company is only 1 with
primary key id.

Thanks for help
Vikrant