README.md

Welcome to Flights Service

Project Setup

• 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 environment variables
  • PORT = 3000
• Inside the src/config folder, create a new file config.json and then add the following piece of json

{
  "development": {
    "username": <YOUR _DB_LOGIN_NAME>,
    "password": "YOUR_DB_PASSWORD",
    "database": "Flight_Search_DB_DEV",
    "host": "127.0.0.1",
    "dialect": "mysql"
  }
}

-Once you've added you db config as listed above, go to the src folder from your terminal and execute 'npx sequelize db: create'

`npx sequelize db:migrate`

##DB Design

• 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 ariport belongs to a city

• One airport can have many flights, but a flight belongs to one ariport

##Tables

City -> id, name, created_at, updated_at

Airport -> id, name, address, city_id, created_at, updated_at

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