To My DB/user peeps!

Hi.

Looking at creating underlying tech to have my own user/viral/referralID growth process.

In looking over different CRMs, it's obvious they're overly comple, so I'm looking to "strip" down what the function(s) would be that would suffice. Right now, tbl issues + func/actions would be a useful start. I've listed some of the attributes/fields Im thinking of, as well as the user actions/funcs that would be used to impact the data.

If you have anything to offer/cmment on, hit me up!

thanks

userTBL
fields:
userFirst
userLast
userID (unique)
userEmail (unique)
city
state
college
year
major
dept

(and some other misc fields related to project)
If you have any other fields let me know

referralIDTbl
userID (unique)
referralID (unique)

parentChildTBL (to link the parentReferralID to the childID
parentID
childID
parentReferralID

user funcs/actions::
user joins system/project
user joins waitlist
user wants to refer other users to achieve prize/reward
user wants to track the number of users that have
been sent invite emails
user wants to track users who've replied (sent back)
invite emails with parentReferralID
etc...