|
Posted by --CELKO-- on 03/14/07 18:03
Your entire approach is wrong. Google up the EAV (entity-attribute-
value) design flaw. Your data element names are absurd. Consider
"DocumentTypePropertyId" in which you have things like "type" and "id"
mixed together. A data element by definition can be either a type or
an identifier, but never both. You are cramming mixed data into
single columns -- the magical "Briteny Spears, Squids and Automobiles"
of newbies who never bothered with a single book to tell about First
Normal Form.
This is so bad that no newsgroup can do your job for you. Get help
and start over before you hurt someone.
Navigation:
[Reply to this message]
|