The table below describes the options you could implement to accomplish the objectives described in the previous section:
Option
Description
1
Use a Python hard-coded value per configuration. This would be used as a "channel" key for every table.
Every row in the table would specify which channel the data came from. The tables in the database would act as staging tables and database triggers or procedures would then move the data to separate tables.
2
Use separate databases for each system. This is a very simple solution and would be easy to implement.