TanToday - Helping Salon Owners, One At A Time, Since 2000! - View Single Post

EliteMike · 31st July 2008, 02:01 PM

are you concerned about orphan records somewhere and things like that?

I work with a very large database that stores alot of the army's planning information. Only time I need to directly access the database would be to make a change to a piece of data that we keep on there that wouldn't be editable in most cases.

I don't know the layout of salon touches db. When you delete a client record, ALL items associated with that client should go with it. Does that happen, I'm not sure. Same goes with products and things like that. Essentially, there should never be a need to go in and do "maintenance". With a relational database, if you don't understand the relationships, you can delete something that is a vital link to other tabels but looks like junk.

31st July 2008, 02:01 PM	#8 (permalink)
EliteMike Hall of Famer Join Date: May 2007 Location: D.C. Posts: 4,492	Re: Help with Salontouch DB Maintenance are you concerned about orphan records somewhere and things like that? I work with a very large database that stores alot of the army's planning information. Only time I need to directly access the database would be to make a change to a piece of data that we keep on there that wouldn't be editable in most cases. I don't know the layout of salon touches db. When you delete a client record, ALL items associated with that client should go with it. Does that happen, I'm not sure. Same goes with products and things like that. Essentially, there should never be a need to go in and do "maintenance". With a relational database, if you don't understand the relationships, you can delete something that is a vital link to other tabels but looks like junk.