Social Stream Base database schema
Social Stream Base's database schema is made up of the following blocks:
- Actors: common table for any social entity, such as, users, groups, institutions. Actor
- Subjects (Actors subytpes): Social Stream Base provides two social entities: User and Group
- Social Network: all the links between actors in the social network. Contact, Relation and Tie
- Actor profile: every social entity has a picture (Avatar) and profile attributes
- Activity Object: common table for all the content types that can be shared between actors. ActivityAction gathers relationships between social entities and contents, such as who is the author, likes and watching. Besides, ActivityProperty gathers relations between contents, such as threads.
- Objects (Activity Object subtypes). Social Stream Base provides Post and Comment, besides Actors. Other Social Stream's components provide more. See Social Stream Database schema.
- Activities Timeline: the log of activities that appears in home page and profile page. It is made up of Activities
- Visibility: Controls who can see activities in the timeline, and contents
- Mailboxer: the Mailboxer provides with support for notifications and private messages
- acts-as-taggable-on: the acts-as-taggable-on gem provides with support for tagging content (Activity Objects)
