uam
Tables (3)
flightScheduleTable (CopyOfCopyOfUntitled)
- fno — Integer — Primary key — NOT NULL
- airlineCode — String
- departure — String
- departureTime — DateTime
- arrivalTime — DateTime
- arrival — String
- flightNo — String
infoTable (Untitled)
- ino — Integer — Primary key — NOT NULL
- name — String
- birthday — DateTime
- tel — String
- imageUrl — String
reservationTable (CopyOfUntitled)
- rno — Integer — Primary key — NOT NULL
- ino (ino2) — Integer — Foreign key → infoTable.ino — NOT NULL
- fno — Integer — Foreign key → flightScheduleTable.fno — NOT NULL
- pnr — String
- departure — String
- departureTime — DateTime
- arrival — String
- arrivalTime — DateTime