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)