Repair Table Structure Question

jwcoleman87

Well-known member
Joined
Oct 4, 2014
Messages
124
Programming Experience
Beginner
Currently I'm debating the necessity of these two tables here:
Capture.PNG

TTRepair holds a single instance of a repair as it is in real time, whereas TTRepairHistory holds a line by line history of that same repair (which includes its present state). In other words, as a TTRepair object is interacted with and modified and changed, TTRepairHistory records those changes line by line. I keep asking myself this question: Do I really need TTRepair if TTRepairHistory already has the data for that repair? Further I question, if both are necessary, what are these tables missing that really causes them to be unique, because as the properties are laid out now, they are almost identical.
 
Back
Top