Many to many is almost always the right call. I've used an array on occasion when I knew we wouldn't be querying by it and didn't want the extra overhead. You c

Many to many is almost always the right call. I've used an array on occasion when I knew we wouldn't be querying by it and didn't want the extra overhead. You can always extract it to a many to many later if needed.