Investigation: String IDs to foreign keys

[TanyaStere42]

Feature description and context

We're getting into the heavy standardization work. Having consistent foreign keys references will go a long way to standardizing calls against various objects. But it's going to take some digging to figure out everything that needs to be fixed

Feature sign-off requirements

List of objects that need to be standardized so tech debt tickets can be made for it