Vinay Kannan wrote:
I am getting stuck at the DB structuring part for this. 1) I can have all the different types of workouts entered into the DB with the number of days / sessions thats included in a particular package. 2) and then when a member pays the fees eg: for 3 months (12 sessions) so have 12 entries made into the DB and then map with the members attendance and what he has done on that day. But was wondering if this is an efficient way to do it, over a period of time, there would be 1000s of members, who would be going to the gym for decent period of time. so eg: 1000 member attend the gym for 1 year (365), that makes the total entries in the DB to be 1000s x 365 just for a year!
With a relational database anything is possible ( you don't say which one but that really only affects fine detail and bells and whistles ).
You are going to have a table with members, one record for each. These will have the basics like when their next payment is due, or how many sessions per week ...
I would also imagine a database of 'facilities' a bit like room booking so you don't perhaps have more members booked in than you can cope with? In the absence of that you would at least have list of available activities?
A client visit would then be a combination of pre-booked or 'open' activities. So a table with a list of date/time/member_id/activity.
History would be a matter of just how long you want to maintain the information. My own systems manage activities relating to callers visiting an office, and we maintain history back many years, but if a 'caller(member)' has not been attending in the previous 2 years then their history is deleted. Actually it will still be maintained in backup files, but that is not directly accessible. Legally, the 'Data protection Act' comes into play here in the UK, but we have sites with over a million visits recorded over the past approaching 20 years, and the system still works as fast as when it was first installed :)
( I use Firebird but any of the options will handle your level of activity ) -- Lester Caine - G8HFL ----------------------------- Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
