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