• sumlin,

    Doesn't your technique still violate 1NF? You are representing different entity types in a single column. How is this any better or less complex than maintaining individual lookup tables? Again, your schema may look simplified, but your life down the road will only be more complex.

    --
    Adam Machanic
    whoisactive