- clone the project on your local
- Execute
npm install
on the same path as of your root directory of the downloaded project - create a
.env
file in the root directory and add the following requirement variablePORT= 3000
- Inside the
src/config
folder create a new fileconfig.json
and then add the following piece of json
{
"development": {
"username": <YOUR_DB_LOGIN_NAME>,
"password": <YOUR_DB_PASSWORD>,
"database": "Flights_Search_DB_DEV",
"host": "127.0.0.1",
"dialect": "mysql"
},
}
- Once you've added your db config as listed above, go to your src folder from your terminal and execute
npx sequelize db:create
and then execute
npx sequelize db:migrate
- Airplance table
- Flight
- Airport
- City
- A flight belongs to an airplane but one airplane can be used in multiple flights
- A city has many airports but one airport belongs to a city
- One airport can have many flights , but a flights belongs to one airport
Relationship -> City has many airport and Airports belongs to a city(One to many relation)