search

FACG4 / nigerian-airlines

MIT License
0 stars 1 forks source link

Define schema tables #11

Open amusameh opened 6 years ago

amusameh commented 6 years ago

Our Db schema includes 3 tables:

  1. The Admin table which is a separate table used to manage the admin login.
  2. The Flights table which contains all the info related to the flights (airline, airport, flight_id, origin, destination, deparure_time, flight_time, gate, aircraft)
  3. The Customers table: first_name, last_name, email, phone, notify_me(boolean)
  4. define the relation between flights and customers tables using sequelize belongsTo method