When data modeling I usually need the unique together constraint. For example: In multiple tenants system, a person with an email can be user of one or more tenant in that system. Email in this case can not be unique themself, it need to combine with the tenant_id (aka unique together) to satisfy that condition. {width=365 height=416}