I have a requirement where I would like to have identical tables in Django. For example MyTableCurrent and MyTableArchive.

The tables should be identical except of the class/table name and the foreign key references.

Is there a way to basically maintain the schema on MyTableCurrent, then under MyTableArchive, I inherit from the base class of MyTableCurrent but override just the foreign key fields to match the corresponding Archive table?