Database Schema - kimi-zou/capstone-make-a-wish GitHub Wiki

Overall Database Schema

Table - Relationships

• Status Codes:   0 - Pending   1 - Accepted   2 - Declined

• User IDs:   user_one_id < user_two_id

Table - EntityTypes

• Define Entity Types with seed data:

Entity Type ID	Entity	Notification description
1	Friend	Creating a friend request.
2	Friend	Accepting a friend request.
...	...	...

Table - NotificationObjects

• Entity ID:   Based on Entity Type, fetch entity from Users/Relationships/Wishes Table. entity_id will be the id of that table.