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