how to have an array of foreign keys (one to many relationship)?
I have these 2 tables setup:
room:
-id
groups:
-id
-members (I want to make this an array of foreign keys pointing to users table)
A room can have multiple groups. and a group can have multiple users.
room:
-id
groups:
-id
-members (I want to make this an array of foreign keys pointing to users table)
A room can have multiple groups. and a group can have multiple users.
