Adding a virtual unique key constraint in MySQL

Let's say in our system we track owners and their corresponding cats. | id | owner_id | cat_name | is_deleted | |----|----------|------------|------------| | 1 | 100 | Puddy Tat | 0 | | 2 | 101 | Katy Purry | 0 | We...