How to use composite key as foreign key in another table?

I have a room table which has composite keys (creator_id, editor_id) as primary keys and I want to point them from another table called message but there's no option for designating composite keys for foreign key relation. What's the practical way of doing this? Do I need to create a new column in room table with unique id?
CleanShot_2022-09-02_at_14.36.482x.png
Was this page helpful?