Designing a single look up entity
Posted
by
altsyset
on Programmers
See other posts from Programmers
or by altsyset
Published on 2013-10-21T07:44:58Z
Indexed on
2013/10/21
10:14 UTC
Read the original article
Hit count: 183
design
|object-oriented
In almost every application you have this look up entity that provides a dynamic references. This are things like type, category, etc. These entities will always have
id, name, desc
So at first I designed different entities for each look up. Like
education_type, education_level, degree_type....
But on a second thought I decided to have on entity for each of these kinds of entities. But when I am done with the design and check the relation this entity will be referenced by almost all entities in the system and I don't believe that is appropriate. So What is your take on this? Can you give me some clear pros and cons?
© Programmers or respective owner