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 ...