I'm working on an application which would mimic the Twitter Lists functionality in which someone can follow someone else. Each user can also create objects which can be followed by users. The Twitter Lists functionality is the best example of the functionality I am wanting to create.
What would this database model look like? I was planning to use Parse.com, but would be open to any representation of the domain model.
Edit: I'll try to add to why I'm asking. Right now I have this structure (only showing the relevant relationship fields):
User - username - activities : Relation<Activity> Activity - name - owner : Pointer<User> - followers : Relation<User> Follow - from : Pointer<User> - to : Pointer<User> Subscription - from : Pointer<User> - to : Pointer<Activity> ActivityPost - activity : Pointer<Activity> - from : Pointer<User> - to : Relation<User>
I read through the Parse Anypic tutorial found here: Anypic tutorial. They did something strange to me by combining three relationships into a single table. This makes me think I've perhaps gone overboard with my join tables.