Welcome Guest, Not a member yet? Register   Sign In
DB design help
#5

this might help. our customers are a mixture of companies and people. A company usually has more than one contact. Our customer table is a list of names with a linked list of contacts each with a statusID of mainContact, accountsContact or otherContact. The statusID is very useful because in many companies, the people who order are not those who handle payments so monthly statements go automatically to the email of the accountsContact. You might find it odd but the address field is in the contacts table alongside the name, email, phone, mobile fields because some companies have multiple delivery addresses. when the mainContact is updated, it updates the corresponding entry in the customers table
Bill
Reply


Messages In This Thread
DB design help - by neuron - 06-07-2019, 07:05 AM
RE: DB design help - by kilishan - 06-07-2019, 07:18 AM
RE: DB design help - by neuron - 06-07-2019, 07:41 AM
RE: DB design help - by albertleao - 06-07-2019, 07:40 AM
RE: DB design help - by badger - 06-07-2019, 08:42 AM
RE: DB design help - by InsiteFX - 06-09-2019, 09:51 AM



Theme © iAndrew 2016 - Forum software by © MyBB