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!
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!
Comment