Then I delete the corresponding folder instance because it was lost a long time ago
What does happen?
History shows this entry without the corresponding instance.
What do you expect to happen instead?
History should continue to show the entry with barcode id and folder name.
Potential solution
Separate Archive from the rest of the db. Denormalize things. Normalization is for keeping updates simple, but this is more a log and therefore could get its own table structure.
How does this problem happen?
What does happen?
History shows this entry without the corresponding instance.
What do you expect to happen instead?
History should continue to show the entry with barcode id and folder name.
Potential solution
Separate Archive from the rest of the db. Denormalize things. Normalization is for keeping updates simple, but this is more a log and therefore could get its own table structure.