This repository includes files with plain SQL that can be used to recreate a database:
- schema.sql to create all tables.
- π About the Project
- π» Getting Started
- π₯ Authors
- π Future Features
- π€ Contributing
- βοΈ Show your support
- π Acknowledgements
- β FAQ
- π License
a relational database to create the data structure for a vet clinic.
[MEDICAL_DB] is a relational database to create the data structure for a vet clinic. tables:
- patients,
- medical_histories,
- treatment,
- invoices,
- invoice_items,
- medical_histories_treatment
π Built With SQL
Database
- [CREATE_TABLE]
- Team
- Zainab Alzubair - Robert Okoe Alabi
To get a local copy up and running follow these simple example steps.
-Reach to following Github URL:
https://github.com/Zainab-Alzubair/medical-db
-Copy the URL.
-In Visual Studio Code βTerminalβ change the current working directory to the location where you want the cloned directory.
-Type git clone in the terminal, paste the URL you copied earlier, and press βenterβ to create your local clone.
$ git clone {https://github.com/Zainab-Alzubair/medical-db}
- npm install
- run command
npm run build
npm start
In order to run this project you need:
- Basic knowledge of Git, GitHub &Gitflow.
- Basic knowledge of SQL sql.
- Basic knowledge of VS Code or any other code-editors.
Clone this repository to your desired folder:
_cd PATH_
_git clonehttps://github.com/Zainab-Alzubair/medical-db
π€ Zainab Alzubair
- GitHub: @Zainab-Alzubair
- LinkedIn: @Zainab-Alzubair
π€ Robert Okoe Alabi
- GitHub: @Robert Okoe Alabi
- LinkedIn: @Robert O Alabi
- Create new tables based on digrames
Contributions, issues, and feature requests are welcome!
Feel free to check the issues page.
Give a βοΈ if you like this project!
- Thanks to Microverse for giving this opportunity to learn ...
- Code Reviewers & Coding Partners.
- Hat tip to anyone whose code was used.
How to connect to the DB using psql?
Run "\c db_name"
This project is MIT licensed.