Hi,
I want to define a schema for a realtime aircraft tracking website. Each thirty seconds, a upsert query insert a new flight or push new positions to an existing flight.
- For the first image, I am wondering if there is any issue with storing data in a document of list for the ‘positions’ field or should I store them in a list of document ? I don’t use query on the ‘positions’ field.
- For the second image, after inserting new flights, a second query with lookup is used to add their flight schedule id as foreign key. Is it possible to perform this lookup in the upsert or I must use this second query with aggregate for the lookup ?
