Tech stack:

MySQL database (phpmyadmin), Next TS + React TS, Node JS + Express JS, tailwind

Connecting users with projects with many to many relationship

In policy of this project, users can have many project and many projects can have many members therefore I used many to many relationship

Creating account and entering account

When user wanna create a new account, for each new account web-app creates unique hash-key that is using in future as identity of this person and based on this hash-key session created

This schema may help you underestand:

Functionality

After creating a new account, or enter to exist one, page of projects will appear:

Here you can create a new project:

Invite members, cooperate and deal with problems together:

Getting Started

Use XAMPP to create local server and start local MySQL database. Open app and turn on Apache and MySQL buttons:

Open PhpMyAdmin with your browser to see the result.

Importing database to PhpMyAdmin:

Download sql file from database-sql-file folder and import it

Run the development server:

npm run dev
# or
yarn dev
# or
pnpm dev

Open http://localhost:3000 with your browser to see the result.