search

TradecraftIT / mobile-app-controller

Backend, web services, and database for FanMobi
0 stars 0 forks source link

User <--> Artist Connect Actions #12

Open tonyalletag opened 9 years ago

tonyalletag commented 9 years ago

The current format of the email mentioned below is: Subject: A FanMobi gift from Body: The body provided by the artist in their profile Send an email to the user (if the user provides their email address) containing the gift message (if the artist provides a gift message). Create/break a relationship between the user object (as defined by unique email address) and the artist object in the database upon connect/disconnect. This will allow the artist to quickly see how many users are following them as well as allow them access to the email addresses of those users if we go down that path.

woot4moo commented 9 years ago

So this seems to be that there will be two types of users: Users and Artists Would it also be true that a User can be an Artist?

tonyalletag commented 9 years ago

Yes lets do roles and allow users to have multiple roles Possible Roles: Fan Artist Host (Or Venue Host) Admin

woot4moo commented 9 years ago

So I am thinking this for the User_Roles table:

Name Role
a@a.com Fan
a@a.com Artist

and this as the "standard" graph representation in MySQL ( connections ):

Start_Node Destination_Node
a@a.com b@b.com
a@a.com c@c.com

http://java.dzone.com/articles/mysql-vs-neo4j-large-scale