Page 1 of 2 12 LastLast
Results 1 to 15 of 18
  1. #1
    Join Date
    Sep 2007
    Posts
    1

    Unanswered: A lil help with DB design

    I have a table to store members. For each member, I have flags like manager, verified, etc. How should I be storing the flags? As individual columns in the same table and using bit datatype or creating a new table called MemberStatus and creating 1 row for each flag?

    Thanx in advance.

    Premal.

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    One table.
    George
    Home | Blog

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    no flags, no bit data

    just more to interprete
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Option 1. Flags, bits.
    1 = true, 0 = false. Not much to interpret.
    If it's not practically useful, then it's practically useless.

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

  5. #5
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    1 = true, 0 = false, Null = unknown
    George
    Home | Blog

  6. #6
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    1 = true
    0 = false
    6 = not sure
    9 = not applicable
    NULL = unknown
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  7. #7
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    10 = drop dead gorgeous.
    If it's not practically useful, then it's practically useless.

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

  8. #8
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    7 = very fluffy.

    -PatP

  9. #9
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    to properly account for shades of gray, you should use a decimal.

    .983 = high degree of truthiness
    .015 = minor fib, won't hurt anyone

  10. #10
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    "truthiness" heh

    somebody is a big fan of TheDailyWTF

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  11. #11
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    nah, i got it from Colbert. He invented that word.

  12. #12
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by georgev
    1 = true, 0 = false, Null = unknown

    Null does not mean unknown, it means the absence of any value, or non existence
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  13. #13
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    ah, i see, thanks brett

    but ontologically speaking, "absence of any value, or non existence" includes unknown

    it also includes not applicable, out of range, optional, forgot, maybe, and WTF!
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  14. #14
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by r937
    ah, i see, thanks brett

    but ontologically speaking, "absence of any value, or non existence" includes unknown

    it also includes not applicable, out of range, optional, forgot, maybe, and WTF!

    Ummm no, unkown mean there's a quanity, but who knows.

    Null means there's not even the understanding of any quantity

    And I like the words you keep throwing out there

    But shouldn't it be anti-ontologically

    http://www.allwords.com/word-ontologically.html
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  15. #15
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Ooh! NULL FIGHT! NULL FIGHT!
    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
  •