How to implement "list of favorites" in java & android?

Question

Java

Good day!
I decided to write a small application in java to improve my skills. I would like to find an answer to the following question. There is a sqlite database with a list of information. Information can be added to the "list of favorites". How exactly to implement this list so that the data can be loaded the next time the application is opened and that the data is not lost when the application is updated? How and where to store this information?
Possible ideas -
1) Create an ArrayList and add the id of this information, serialize and write to a separate file.
2) Create a column isSelected (bool) and each time load from the database (then, in theory, the application should also write information to the database). And how then will it affect updates (the database will also be updated)
3) Create a separate table in the database
Thanks in advance for the information.
PS for example, in this source: https://stackoverflow.com/questions/7957319/how-to... it is recommended to create a separate table in the database

Answer 1

Separate table using FOREIGN KEY (ON DELETE CASCADE) Details here, keyword search