Re: Data Model

topmind,

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 - 14:51:53 CDT