This PR introduces the 'following' table to our database schema, allowing us to track the relationships where users follow other users. It also includes the insertion of initial dummy data to facilitate immediate testing and interaction with the new table structure. Once all the tables are finalized and the schema is merged into the main branch, I'll add more dummy data.
I was able to run this locally and see the "following" table without issue.
Changes:
Created the 'following' table with the necessary fields: following_id, follower_user_id, following_user_id, and follow_date.
Established constraints to ensure data integrity: each pair of users has a unique follow relationship, and a user cannot follow themselves.
Added indexes on follower_user_id and following_user_id to optimize query performance.
Inserted initial dummy data to set up basic following relationships for immediate use and testing.
Summary:
This PR introduces the 'following' table to our database schema, allowing us to track the relationships where users follow other users. It also includes the insertion of initial dummy data to facilitate immediate testing and interaction with the new table structure. Once all the tables are finalized and the schema is merged into the main branch, I'll add more dummy data.
I was able to run this locally and see the "following" table without issue.
Changes:
following_id,follower_user_id,following_user_id, andfollow_date.follower_user_idandfollowing_user_idto optimize query performance.