Hello DB gurus,
Does anyone know how to approach the situation where a record's status (in this case "is_in_recording" for example) depends on multiple records in another table?
I have a "files" table and it has a boolean "is_in_recording" which if set to TRUE means the file is used in a recording somewhere and should not be deleted. (see screenshot below)
The file could be used in 0 to many recordings though, and I don't know how to represent that best in the model...