I’m looking to add a new table to the wp db for a project I’m working on. Without going into too much detail, I’m allowing users to submit a form that performs an off site search, returning the results back to that specific user. The searches and results will be stored (hopefully) within a new database table.
But, I need to make sure each search and result set are given to the user that generated them. I was initially thinking of just adding new columns to the wp_user table, but after reading around, updating WordPress could potentially cause that data to get lost.
So, my question is: Is there a way to link the data stored in one table to the user ID of the person that made it? Would it be as simple as just adding an ID field and wp will know what I’m on about?