Skip to content

Latest commit

 

History

History
68 lines (50 loc) · 1.49 KB

README.md

File metadata and controls

68 lines (50 loc) · 1.49 KB
Raw

Welcome to Flights Service

Project Setup

  • Clone the project on your local machine
  • Execute npm install on the same path as of your root directory of the downloadedd project
  • Create a .env file in the root directory and add the following environment variable
    • 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_PASSWD>",
    "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 execute npx sequlize db:migrate

DB Design

Airplane Table

  • id
  • model_number
  • capacity

Airport Table

  • id
  • Name
  • City_id
  • address

Flights Table

  • id
  • departure_city_id
  • destination_city_id
  • airplane_id
  • departure
  • arrival
  • Flight_number
  • Airport_id

City

  • id

  • name

  • A flight belongs to an airplane but one airplane can be used in multiple flights

  • A cith 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

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

Relationship -> City has many airports and Airports belongs to a city (one to many)