Final Project

Tables (10)

Untitled (COUNTRY)

  • Key (cID) — int(3) — Primary key — NOT NULL
  • Field (cName) — char(30)
  • Field (continent) — char(30)
  • Field (cCode) — char(3)

Untitled (CORONA)

  • Key (ID) — int(3) — Primary key — NOT NULL
  • Field (regulation) — text
  • Field (date) — date
  • Field
  • Key (cID) — int(3) — Foreign key → Untitled.Key — NOT NULL
  • Key (mID) — char(15) — Foreign key → Untitled.Key — NOT NULL

Untitled (CITY)

  • Key (cityID) — int(3) — Primary key — NOT NULL
  • Field (cName) — char(3)
  • Field (airportCode) — char(10)
  • Key (cID) — int(3) — Foreign key → Untitled.Key — NOT NULL

Untitled (DEPARTURE_AIRPORT)

  • Key (daID) — int(5) — Primary key — NOT NULL
  • Field (aName) — char(100)
  • Key (cityID) — int(3) — Foreign key → Untitled.Key — NOT NULL

Untitled (ARRIVAL_AIRPORT)

  • Key (aaID) — int(5) — Primary key — NOT NULL
  • Field (aName) — char(100)
  • Key (cityID) — int(3) — Foreign key → Untitled.Key — NOT NULL

Untitled (FLIGHT)

  • Key (fID) — int(4) — Primary key — NOT NULL
  • Field (fType) — char(10)
  • Field (atime) — time
  • Field (dtime) — time
  • Field (date) — date
  • Key (daID) — int(5) — Foreign key → Untitled.Key — NOT NULL
  • Key (aaID) — int(5) — Foreign key → Untitled.Key — NOT NULL
  • Key (aID2) — int(3) — Foreign key → Untitled.Key — NOT NULL

Untitled (EXPERIENCE)

  • Key (eID) — int(3) — Primary key — NOT NULL
  • Field (cName) — char(10)
  • Field (date) — date
  • Field (content) — text
  • Key (mID) — char(15) — Foreign key → Untitled.Key — NOT NULL

Untitled (MANAGER)

  • Key (mID) — char(15) — Primary key — NOT NULL
  • Field (password) — char(15)
  • Field (mName) — char(30)
  • Field (email) — char(50)
  • Field (register) — time

Untitled (PASSENGER)

  • Key (pID) — int(3) — Primary key — NOT NULL
  • Field (pName) — char(30)
  • Field (pBdate) — int(8)
  • Field (pVaccine) — char(1)
  • Key (cID) — int(3) — Foreign key → Untitled.Key — NOT NULL

Untitled (AIRLINE)

  • Key (aID) — int(3) — Primary key — NOT NULL
  • Field (aName) — char(30)
  • Field (aCountry) — char(30)