If you want to delete workstations, have you considered one of:
1) wait until you've purged any transactions referencing the workstation
2) set columns that reference the workstation to null or a placeholder workstation
3) add support for a deleted flag on actor.workstation
Investigation of options for deletion of workstation objects might be a matter for another ticket.
Payments aren't the only place where there's a FK relationship actor.workstation(id). :-)
I'd like to see us store the workstation ID.
If you want to delete workstations, have you considered one of:
1) wait until you've purged any transactions referencing the workstation
2) set columns that reference the workstation to null or a placeholder workstation
3) add support for a deleted flag on actor.workstation
Investigation of options for deletion of workstation objects might be a matter for another ticket.
Payments aren't the only place where there's a FK relationship actor.workstati on(id). :-)