- clonethe 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 environment variablePORT=3000
- Inside the
src/config
folder create a new fileconfig.json
and then add the following piece of json
{
"development": {
"username": "<YOUR-DB-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 the src folder from your terminal and execute
npx sequelize db: create
and then executenpx sequelize db:migrate
-
Airplane 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 flight belongs to one Airport.
Relationship โ City has many airports and Airport belongs to a city (one to many)
npx sequelize model:generate -name Airport -attributes
name:String, address:String, cityId: integer