I am designing an web based application using MySQL and Perl. Part of the requirements include a somewhat complex scheduling module, which must accommodate scheduling multiple human and physical resources across multiple facilities. For example, medical patients will be scheduled for one or more pieces of equipment, in one or more rooms, at one or more facilities, by one or more doctors -- per visit.
I would love to review how others have handled such tasks; but, I have reviewed the MySQL archives and googled without success. I am especially interested in the database design, since requirements indicate a need to schedule forward more than one year. I feel that a robust database design will simplify the logic code to make this work optimally. What do you think? -- Best Regards, mds mds resource 877.596.8237 - Dare to fix things before they break . . . - Our capacity for understanding is inversely proportional to how much we think we know. The more I know, the more I know I don't know . . . --
pgp00000.pgp
Description: PGP signature
