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?
