This should be `resource_client_id_name_key` and `['client_id', 'name']`. The parent id constraint should always come first in a multi-column index. SQL indexes left to right, so having the client_id first will reuse the existing client_id foreign key index.