Results 1 to 3 of 3

Thread: Types tables?

  1. #1
    Join Date
    Jun 2005
    Posts
    4

    Unanswered: Types tables?

    I am in the process of re-writing our in-house app.

    The current structure has about 40 tables that end in "Types", such as RopeTypes, OrderTypes, ShippingTypes, CustomerTypes, etc.

    My question is, do I keep the structure how is has been with all these tables, or should I create a "Types" table that contains some kind of a key that designates that this record is one of X types? What would I call such a table?

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    This is a heinously bad idea, and it is called a One True Lookup Table. Please stay with your present design of distinct lookup tables for types!

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    "There is no such thing as a Lookup Table." --blindman
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •