During the big PR that added the signup form, we left a few corners of the database a bit out of sorts. This PR fixes those up.
Removes now-unused columns for street and apt from the people table since they moved to the homes table. The signup form was already putting the data in the homes table.
Updates the relation fields in person_animals to be bigint values vs. int so they match the types of their related tables. Also adds foreign key constraints on them like the other tables in the database.
Adds relevant foreign key constraints to the people_roles table.
During the big PR that added the signup form, we left a few corners of the database a bit out of sorts. This PR fixes those up.
streetandaptfrom thepeopletable since they moved to thehomestable. The signup form was already putting the data in thehomestable.person_animalsto bebigintvalues vs.intso they match the types of their related tables. Also adds foreign key constraints on them like the other tables in the database.people_rolestable.