Design Issue

[nvishnu]

I have a design question

Customer A has a contact table coulmns like below
tblContact (for CustomerA)
ContactID
CustomerID (fk from tblCustomer
ContactFirstName
ContactLastName

while customer B may need an extra contact info like Age. Another customer
may have DOB.
tblContact (for CustomerB)
ContactID
CustomerID (fk from tblCustomer
ContactFirstName
ContactLastName
DOB

The number of fields for contact field may vary from
customer to customer. Assume that each client has different database (we
dont need to customerid as foreign key. Whats the best design in this case.
I have thought of 2 cases 1. Add the dynamic fields to the same table 2.
have a seperate table call table extension and append the fields in that
table with a foreign key in the Contact table.

Does anyone know how ERP packages achieve this.

Thanks for suggestion.

Navin

 

[Duane Hookom]

Please check one of your earlier threads on basically the same question.