I have a process that retires one barcode and creates a new one. I have a central barcode table that I want to represent on a diagram as two aliases - Retired and Current. This will be accompanied by events table indicating if the barcode is being retired because of a retirement, transfer or upgrade event.
I think the best way to represent this is to clone the barcode table twice, rename and set the table to not generate SQL and link to the events table. Does that sound right, or is there another way?
Customer support service by UserEcho