This repository includes files with plain SQL that can be used to recreate a database:
- Use schema.sql to create all tables.
- Use data.sql to populate tables with sample data.
- Check queries.sql for examples of queries that can be run on a newly created database. Important note: this file might include queries that make changes in the database (e.g., remove records). Use them responsibly!
This is a database for a vet clinic. It contains tables for animals, owners, vets, and visits. It also contains a join table for visits and vets.
[Vet Clinic Database] is a Postgresql project to model data for a vet clinic
Database
- Create tables for database
- Populate tables with sample data
- Run relevant queries to fetch data from database
To get a local copy up and running, follow these steps.
Clone this repository to your desired folder:
Example commands:
cd my-folder
git clone git@github.com:MosDevx/Vet-Clinic-DB.git
Install this project with:
Example command:
cd my-project
psql -d vetclinic
vetclinic=# \i '\path\to\folder\schema.sql';
vetclinic=# \i '\path\to\folder\data.sql';
👤 Moses Wamae
- GitHub: @mosdevx
- Twitter: @moseswamae7
- LinkedIn: LinkedIn
- Add Join queries
- Add multiple tables
Contributions, issues, and feature requests are welcome!
Feel free to check the issues page.
If you like this project leave a star!
I would like to thank... God.Always!!
This project is MIT license