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 business_id
and action_name_id
.
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.