Hello all. I am in the process of piecing together a software project that I plan to use in the day-to-day operation of my service business.
I'm sure this will be a simple question for someone here.
I will be tracking employees, service tickets, clients, & client IT Assets. I will also be keeping records of all problems/solutions to facilitate solving any future, similar issues.
My question is this,.... some clients are residential, some clients are businesses, and they are billed differently.
Some business clients have multiple contacts (or people) that I want to keep track of as well, especially in cases where we have multiple assets within a single business but each with different contacts.
Should I create a clients table that just holds a client ID, and a boolean value of weather they are a business or not, and then create separate tables for residential contacts, businesses and business contacts,.....
should I create a contacts table and a businesses table and just tie some contacts to a clientID and some to a businessID?
Any help/suggestions would be appreciated.