# Welcome to flight Service

## Project Setup
- clone the project on your local
- Execute `npm install` on the same path as of your root directory of the cloned 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": "root",
            "password": null,
            "database": "Flights_Search_DB_DEV",
            "host": "127.0.0.1",
            "dialect": "mysql"      
        },
        }
    ```

- Once you have added your db config s listed above, go to the src folder from you terminal and execute `npx sequelize db:create`

- 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 sequelize db:migrate ```




## Folder Structure of the Project

-src/
    index.js
    models/
    controllers/
    middlewares/
    services/
    utils/
    config/
    repository/
    migrations/
    seeders/

-tests/ [later]

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 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 Airport belongs to a city (one to many)