Table users - facilities fields

lemonsoftwarero wrote on Friday, May 30, 2008:

Hello,

I’ve noticed that in users table there are
facility
and
facility_id

The old style is with ‘facility’ name which obvious is not quite ok, but with two fields in the same table for facility, things are becoming really messy.

What is a logic behind this? Is a transition to a (normal) facility_id only?

sunsetsystems wrote on Friday, May 30, 2008:

Yes, the idea is to transition to referencing facilities only by their ID.  Using the name as the key is just dumb.

Feel free to clean this up!

Rod
www.sunsetsystems.com