...
- A Parent table starts the Unarchive process. Based on its criteria, an archive table is checked for existence and data presence.
- Generate query statements to copy the intended data from the archive back to the live table.
- Generate query statements to update association tables telling the linked records the archived data has moved.
- If the Archive table has Dependents, the Unarchive process extends to them as well (and so on if any of them have Dependents).
- Generate query statements to drop the Archive table if it has no data after the Unarchive is complete.
...
Note: Some processes only delete the archived data because it is being regenerated in the live table, and eventually re-archived. The deletion/table-drop is to avoid data duplication from the old version of the data to the new.
What Gets Archived?
There are two initial implementations for Archives: Call Details, and Bill Details.
...
Go to Admin > Billing > Bill Generation, which will show you the Bills grid. When you select a bill and choose "View Bill" from the Grid Toolbar, the Bill view will open in a new tab as it always has. In the background, the system determines the Table locations of the bill data you selected, and displays it as usual.