Whats the correct model schema for my use case?

Glad to help and good luck!

Let us know if you have further questions, you can also reach-out on our Scylla Users slack - http://slack.scylladb.com/

And for other ways, take a look at this post - Engaging with the ScyllaDB Community