welcome to Flights Service

Project Setup

• clone the project on your local
• Execute npm install on hte same path as of your directory of the downloaded project
• Create a .env file in the root directory and add the following enviornment 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_USERNAME",
    "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 excute npx sequelize db:create

##DB Design

• Airplane Table

• Flight

• Airport

• City

• A flight belongs to an airplane but one airplane can be useb 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

Tables

City -> id , name , created_at , updated_at

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

  RelationShip -> City has many aiports and Airpot belongs to a city (one to many[1:N])