Hi all,
i have a database that stores application related issues (This screen doesn't work, etc.). Each issue can be visited several times, and each time the status can be changed and notes can be added.
The way i currently have it set up, there is one table that keeps the Issue information: ID, title, client, etc....all things that will never change. I also keep the most recent Status, Release Number, and Assigned To information (all things that can change when an administrator edits the issue). I have a second table that keeps an archive of all notes, stati, release numbers, and assigned to information, as well as the most current information. This is where the redundancy comes in...the current Status, Release Number, and Assigned To info are stored in 2 seperate tables. I do this so as not to have to call the second table and search for the most recent entry just to get 3 fields (it can be gotten from the first table, along with the other info).
In this case, is the redundancy warranted? Did this even make any sense?
thanks for making it this far...
-Phil
i have a database that stores application related issues (This screen doesn't work, etc.). Each issue can be visited several times, and each time the status can be changed and notes can be added.
The way i currently have it set up, there is one table that keeps the Issue information: ID, title, client, etc....all things that will never change. I also keep the most recent Status, Release Number, and Assigned To information (all things that can change when an administrator edits the issue). I have a second table that keeps an archive of all notes, stati, release numbers, and assigned to information, as well as the most current information. This is where the redundancy comes in...the current Status, Release Number, and Assigned To info are stored in 2 seperate tables. I do this so as not to have to call the second table and search for the most recent entry just to get 3 fields (it can be gotten from the first table, along with the other info).
In this case, is the redundancy warranted? Did this even make any sense?
thanks for making it this far...
-Phil