Database Structure
Posted: 17 Jan 2010, 17:21
I am in two minds.
In most companies there will be three types of contact.
Employees
Vendors
Customers
in a database what is best best practice:
each type of contact its own table, or all contact in a single table with fields containing check boxes to denote which type of contact a contact belongs to ?
In certain circumstances a contact maybe a vendor and a customer or a customer and an employee. my thinking is to combine all types of contacts to one table as this will eliminate the need for duplicate data.
In most companies there will be three types of contact.
Employees
Vendors
Customers
in a database what is best best practice:
each type of contact its own table, or all contact in a single table with fields containing check boxes to denote which type of contact a contact belongs to ?
In certain circumstances a contact maybe a vendor and a customer or a customer and an employee. my thinking is to combine all types of contacts to one table as this will eliminate the need for duplicate data.