UAM

Tables (6)

Aircraft

  • aircraftIdx (Key) — LONG — Primary key — NOT NULL
  • mechanicalManagerIdx (Key2) — LONG — Foreign key → Manager.managerIdx — NOT NULL
  • pilotIdx (Key3) — LONG — Foreign key → Manager.managerIdx — NOT NULL
  • groupIdx (Key6) — LONG — Foreign key → Group.groupIdx — NOT NULL
  • routeIdx (Key5) — LONG — Foreign key → Route.routeIdx — NOT NULL
  • battery (Field) — FLOAT — NOT NULL
  • manufacturingCompany (Field2) — VARCHAR(300) — NOT NULL
  • reservation (Field3) — BOOLEAN — NOT NULL
  • onGoing (Field6) — BOOLEAN — NOT NULL
  • status (Field5) — LONG — NOT NULL

Group

  • groupIdx (Key) — LONG — Primary key — NOT NULL
  • userIdx (Key2) — LONG — Foreign key → User.userIdx — NOT NULL
  • load (Field) — FLOAT — NOT NULL

Manager

  • managerIdx (Key) — LONG — Primary key — NOT NULL
  • department (Field) — VARCHAR(100) — NOT NULL
  • class (Field2) — VARCHAR(100) — NOT NULL

Route

  • routeIdx (Key) — LONG — Primary key — NOT NULL
  • departVertiportIdx (Key2) — LONG — Foreign key → Vertiport.vertiportIdx — NOT NULL
  • arriveVertiportIdx (Key4) — LONG — Foreign key → Vertiport.vertiportIdx — NOT NULL
  • name (Field) — VARCHAR(200) — NOT NULL
  • distance (Field2) — FLOAT — NOT NULL
  • price (Field3) — FLOAT — NOT NULL
  • estimatedTime (Field4) — LONG — NOT NULL
  • status (Field5) — LONG — NOT NULL

User

  • userIdx (Key) — LONG — Primary key — NOT NULL
  • name (Field) — VARCHAR(30) — NOT NULL
  • age (Field2) — INT — NOT NULL
  • phone (Field3) — VARCHAR(20) — NOT NULL
  • id (Field4) — VARCHAR(30) — NOT NULL
  • password (Field5) — VARCHAR(5000) — NOT NULL
  • image (Field9) — TEXT — NOT NULL
  • createAt (Field6) — DATETIME — NOT NULL
  • updateAt (Field7) — DATETIME — NOT NULL
  • status (Field8) — LONG — NOT NULL

Vertiport

  • vertiportIdx (Key) — LONG — Primary key — NOT NULL
  • managerIdx (Key2) — LONG — Foreign key → Manager.managerIdx — NOT NULL
  • location (Field) — TEXT — NOT NULL
  • type (Field2) — LONG — NOT NULL
  • capacity (Field3) — LONG — NOT NULL
  • available (Field4) — BOOLEAN — NOT NULL
  • createAt (Field5) — DATETIME — NOT NULL