4 ms·
--- USER TABLE --- | USER_ID | | USERNAME | | NB_FOLLOWERS | | TWEETS -> List of TWEET_ID's | | FOLLOWING -> List of USER_ID's | | FOLLOWED_BY -> List of
by bsvalley 9y ago
--- USER TABLE ---
| USER_ID |
| USERNAME |
| NB_FOLLOWERS |
| TWEETS -> List of TWEET_ID's |
| FOLLOWING -> List of USER_ID's |
| FOLLOWED_BY -> List of USER_ID's |
etc.
NB_FOLLOWERS, FOLLOWING and FOLLOWED_BY are updated when a USER follows/unfollows another USER.