Posted by sephent on 03/14/07 18:17

On Mar 14, 1:03 pm, "--CELKO--" <jcelko...@earthlink.net> wrote:
> 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.


I will agree with you about the design. However, I didn't create it
(nor am I in a position to fix it). Blame the good folks at Altec for
the design or lack of (this is their DocLink).

I'm just the poor slob who has to deal with it.

[Back to original message]