I am building an app where users will work independently to complete as many cards as possible. Each user will see one card at a time and will have the ability to filter cards based on various attributes, as well as view completed and non-completed cards.

My requirements are:

• A database to store cards and user information.
• Users can filter cards by different attributes.
• Users can see cards categorized by completed vs. non-completed status.

As I can not efficiently filter by “not-in” in firestore I think that is best to use a different architecture. I plan to use Firebase for user management and other functionalities. Given these requirements, what would be the best database architecture to use with Firebase?

Specifically:

• How should I structure my data to efficiently handle user-specific
  card completion status?
• What would be the best way to implement filtering and querying for
  cards?
• Are there any Firebase features or best practices I should leverage
  for this use case?

Any guidance or examples would be greatly appreciated!