I have a ContactInfo Table :
ContactInfo(
ID int IDENTITY(1,1) NOT NULL, --PK
ContactValue varchar(100) NOT NULL,
ContactType smallint] NOT NULL
)
In my model multiple entities/tables would need to have a list of
ContactInfo entries.
Example:
Employee has 3 contact infos: 1 email and 2 phone numbers. I would
then have a ContactInfo with ContactType = 2(email), and 2 ContactInfo
with Type = 1(phone).
Now the question is how to link this Entity to the different users? It
looks like inheritance with only a difference in foreign keys. Does
adding an FK to every user Table make sense / good design?
Also, how do we represent such a thing in the domain model? Do we
create duplicate classes for every use? EmployeeContactInfo,
ClientContactInfo, etc... How do we map those?
I know those are a lot of questions but I think the idea is clear
enough, thanks for the help in advance.
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en.
