Nodejs meets mysql in a RESTful way to manage customer tasks assigned to personnel
Fullstack app built in MySQL, Express, ReactJS and NodeJS. Backend is REST api. Uses these technologies to build a web platform where authenticated company personnel get to view their customer care tasks.
Create a mySQL database and start it.
Clone and cd into that directory. You will run yarn install twice. Run first yarn install here for backend.
For frontend, cd into client directory and run the second yarn install.
Fill out your .env as necessary. See .env.example file.
Note: your backend host port no. should align with the proxy entry in package.json.
Run migrations and seeds.
Note: tables are created in the plural to best leverage npx, sequelize and api consistency adopted.
Run both servers simultaneously. You may run concurrently with one command. Inspect package.json
Use REST query samples in restexamples.txt after setup.
Make sure to register or signin as a personnel to access the customer care tasks.
CRUD actions or views may be enabled if the user is admin[personnel_type_id=3].
Screenshots in PR.
Visit hosted frontend app here.
Visit hosted backend rest api here.
This app is protected by MIT licence.