Saturday, January 19, 2008

Should the company number be a foreign key?

I see the CO_NUMBER:INT(7) in quite a few tables:
  • companies
  • co_billings
  • company_fees
  • company_gen_fees
  • customers
  • customer_payments (ap_co_number)
  • notepads

It seems like this should be a foreign key, pointing to a primary key in the companies table.

Does this seem right?

1 comment:

Brent said...

This might be ok, if it was a 1-1 relationship, but it doesn't quite seem like that is the case.