But if it references Salespeople, and also routinely references general employee data about the SalesPeople, should I have 2 foreign keys defined? (one to each) ••• Quote Report F ...

For the first migration scripts I've tentatively skipped the surrogate keys from the insert/select, and thus PG generates new ids automatically. This works, of course, but when migrating foreign ...

Retaining an infinitude of Foreign Keys may cause future performance bottlenecks as transactional volume will get a performance hit by maintaining all those foreign keys and the indexes behind them.