Integrating a Postgres Database with Express API project:

Create two database tables,

Express API project will need to be modified to connect to the Postgres Database using pg

React app logLog In Endpoint will accept credentials from React app, read the credentials from the database, and compare.

Return $200$ and return the primary key of the user account if comparison check passes.

Return $400$ if no user account exists.

Return $401$ if comparison check fails.

Registration Endpoint will accept data from React app, insert new record into the user$\_$accounts table

Return $201$ and return the primary key of the newly created user account.

Return $409$ if that username already has a user account.

Account Endpoint POST will accept data from React app, including the primary key of the user making this update, insert new record into the user$\_$account$\_$details table

Return $200$ and return the newly created data entry.

Account Endpoint GET will accept user primary key, read user$\_$account$\_$details from the database

Return $200$ and return all the data from the user$\_$account$\_$details record for that user

Return $204$ if there is no data in the user$\_$account$\_$details for that user

Account Endpoint PUT will accept user primary key, read user$\_$account$\_$details from the database, update existing record of the user$\_$account$\_$details table

Return $200$ and return all the data from the user$\_$account$\_$details record for that user

Return $404$ if no existing record is found for that user primary keyic will need to be updated to know which endpoint to hit as well as handle any errors from Express

Must be mobile responseness