A web application for managing Veterinary Clinic

• Manage animals profiles, along with their owners

• Manage user profiles like administrators, health technicians, attendants, teachers, and students

• Each user having different access rights

• Animal request workflow based on granted permissions

• backend - contains back end source code
• docs - various documentation on the project
• frontend - contains front end source code
• images - contains images for README file
• sql - contains MySQL database scripts

• JDK version 11.0.11 or above
• Maven version 3.6.3 or above
• MySQL server version 8.0.26 or above
• Node version 16.13.1 or above

1. Clone the repository on your machine

2. Start the MySQL server on your local machine. If you are accessing the MySQL server over a network, edit the property spring.datasource.url in the file application.properties and replace localhost with the server IP address.

3. Connect to your MySQL server using an admin user like root.

4. Run the below scripts on the MySQL server in the given order using root. These scripts will create a schema vetdb, a user vetapp with password vetpassword, create all necessary tables and load them with some dummy data.

   1. 01_init.sql
   2. 02_tables.sql
   3. 03_views.sql
   4. 04_dummy_data.sql

5. To run the backend, navigate to the directory backend. Running the below command will get the backend server running.

   $ mvn clean spring-boot:run

6. To run the frontend, navigate to the directory frontend. Running the below command will get the react server running and launch your default browser.

   $ npm install
   $ npm start

7. Once you are done with the application, you may remove all the data from your MySQL server using 10_purge.sql.

• Bhavyai Gupta
• Michael Lee
• Sarang Kumar