I’m extracting some data from a database generated by SQLite export.
One thing that is not clear to me is the order of events etc. In Gramps you can move e.g. events for a person up or down to get a specific order. In the exported database there will be corresponding rows in the “link” table from “person” to “event_ref” but I don’t see any column related to the order.
A database normally doesn’t have a “default row order”. However it seems like SQLite has a “hidden” column named “rowid”. So maybe the rows in the links table are added in the same order as in Gramps and sorting by rowid will result in the correct order?
Can anyone confirm that or tell me if there is another way to get the correct sort order?