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.

[Back to original message]