- clone the project on your local.
- Execute
npm installon the same path as of your root directory of the downloaded project - Create a
.envfile in the root directory and add the following environment variable- 'PORT=3000'
- Inside the
src/configfolder create a new fileconfig.jsonand then add the following piece of json :
{
"development": {
"username": "root",
"password": "123456",
"database": "Flight_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
-
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 airports belongs to a city.
-
One airport can have many flights, but a flight can belong to one airport.
Relationship -> City has many airports and Airport belongs to a city (one to many)