Javi510348
commented
7 months ago A new table was created called "form" in which it will link the user with a pet and with a form. The table will be composed with some columns:
-
f_id - Primary Key
-
user_id (Foreign Key) - It will store the primary key of users table. It will link a user to the form.
-
pet_id (Foreign key) - It will store the primary key of pets table. It will link a pet to the form.
-
created_at - It will store the date and time in which the form was created.
-
status - It will store the current status of the form. The status could appear as approved,denied or pending.
If you have any suggestion or question, please let me know.
A new table needs to be added to the database in which a user will be linked to a pet after completing the form required for adoption. This table will be linking specifically the user id and the pets id by using them as foreign keys in the database. This doesn't mean that the user will adopt the pet once the from is completed, it needs to go trough a process before confirming the adoption
Also, the table will have an additional value in which it will be a boolean value that will indicate the status of the form. If it appears as "approved", the user will officially adopt the pet. The status of "pending" indicates that the form still hasn't been processed. Finally, the status of "denied" will indicate that the user can't adopt the pet.
Deadline: 10/04/2024