NESTED TABLESを使用する例

例で使用する様々な表:
  • 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)