Junction Table or bit field?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • aas4mis
    New Member
    • Jan 2008
    • 97

    Junction Table or bit field?

    I'm curious on the best way to start my IT Inventory database.

    a few key bullet points
    1 - need to be able to tell where a piece of equipment is at any given time.
    2 - need to be able to recall previous repairs and resolutions
    3 - don't want to have to search all records for 'active' repairs

    Part of my concern is whether to use a junction table for active repairs, or to use a bit field on my repair log table. Attached erd is not final, just a quick layout.

    Any thoughts on my layout would be appreciated.
    Thanks!
    Attached Files
  • ck9663
    Recognized Expert Specialist
    • Jun 2007
    • 2878

    #2
    The attachment is too blurred to understand. Try posting some sample data of your tables and tell us what you are trying to do and what you have done so far...

    ~~ CK

    Comment

    Working...