What data should be stored in the database?

[Bizz]

Hello. For example, in a matching application, there are tables for swipes, matches, conversations, and messages. Let's say a user has blocked another user. Should the data for matches, conversations, and messages between these users be deleted, or should an 'is_active' field be added and set to false? Is it necessary to keep this data in the database? If so, how can it be stored in a more optimized and space-efficient way?