I have an app which allows business to have its own workspace. And all activities, triggered by user, will be stored as audit log. Each audit log will have
In this app, user can view all audit logs and filter by action name. So user pass busines_id and action_name_id to get all action that user wants to see.
Currently, type of foreign key (action_name_id) is integer. However, in order to improve code readability, I would like to use string as a foreign key. My question here is that are there any drawbacks using foreign key as string when user try to query?
Thank you in advance.