Behavior of restoring archived records when the table structure changed


Details

What is the behavior of restoring archived records in the situation where the table structure has been changed since archiving? For example, new fields have been added, some fields have been removed after the data was archived, and types of some fields have been changed after archiving?

 

---- Answer-----
The behavior would be that when any changes happen on the main table, the same changes done on the main table will be replicated over to the archive tables as well and archive the records accordingly.

For example, if a <table> has a new field added, the same field will be added to the ar_<table> also, and archive the new records with the new field records too.