Great post. After being out in production for a little while, some
courts have requested extra types of staff, so it worked out pretty
easily to just add another row to my stafftype table. They have also
requested two staff of the same type for one court, because both staff
members work the same position part time. A request by my boss has
been made already to extend this data store to applications outside of
the website. They want to use the staff part of it to be a centralized
store for employee phone numbers and etc...so pretty much the rule of
exactly only 6 types of staff for each court has been thrown out the
window. The new rule is, you have any type of staff available to you,
you pick and choose what you want. The above changes are exactly what
I was expected to a certain degree, and it will be/was easy to pull
them off, without having to hack and write an obscure work around.
If I had kept this all in one table I would have been screwed.
Thanks for your time and post,
Matt
Received on Tue Apr 04 2006 - 21:51:53 CEST