左外部結合を使用する例

例で使用する様々な表:

• ticket

  ticketNo LONG
  confNo STRING
  PRIMARY KEY(ticketNo)

• ticket.bagInfo

  id LONG
  tagNum LONG
  routing STRING
  lastActionCode STRING
  lastActionDesc STRING
  lastSeenStation STRING,
  lastSeenTimeGmt TIMESTAMP(4)
  bagArrivalDate TIMESTAMP(4)
  PRIMARY KEY(id)

• ticket.bagInfo.flightLegs

  flightNo STRING
  flightDate TIMESTAMP(4)
  fltRouteSrc STRING
  fltRouteDest STRING
  estimatedArrival TIMESTAMP(4),
  actions JSON
  PRIMARY KEY(flightNo)

• ticket.passengerInfo

  contactPhone STRING
  fullName STRING
  gender STRING
  PRIMARY KEY(contactPhone)

• SQLの例
• 問合せAPIの例