Management API based on Animal Grooming, implementing CRUD operations built with TypeScript, it ensures strong type safety and data validation using Zod. The project utilizing Express.js for Web Framework and Prisma ORM with MySQL for Database.
- docs -> Documentation of endpoint for this project
- prisma -> Contains starting point for database relation
- src -> Source code of this project
- Typescript
- Express.js
- MySQL & Prisma
-
Clone the repository:
git clone https://github.com/egrizq/typescript.git
-
Install dependencies:
npm install
-
Configure the database:
CREATE DATABASE animal;npx prisma migrate dev --name animal
-
Run the application:
npm run build npm run start
-
Open your POSTMAN and use http://localhost:8080 to access the endpoint.
Admin table
| Name | Type | Key |
|---|---|---|
| username | varchar(100) | id |
| password | varchar(100) | |
| varchar(100) |
User table
| Name | Type | Key |
|---|---|---|
| user_id | int | id(autoincrement) |
| owner | varchar(100) | unique |
| phone | varchar(100) | |
| address | varchar(100) |
Animal table
| Name | Type | Key |
|---|---|---|
| animal_id | int | id(autoincrement) |
| name | varchar(100) | |
| age | varchar(10) | |
| color | varchar(10) | |
| kind | varchar(10) | |
| user_id | Int | FK -> User |
Grooming table
| Name | Type | Key |
|---|---|---|
| id | int | id(autoincrement) |
| owner | varchar(100) | unique |
| name | varchar(100) | |
| groomingType | varchar(100) | |
| date | varchar(100) | |
| queue | int | |
| user_id | int | FK -> User |
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent