2 fields unique together

#1

I want to fill table with data that implements many to many relationship. So I can create 2 column with type number and specify the range. But here’s the issue: as all we know 2 foreign keys in mtm should be unique together.

  1. Is there a way I can specify unique together it with mockaroo?
  2. Is there a way I can specify range of generated row instead of fixed number?
#2

You can use two sequences and set the “repeat” and “restart at” fields accordingly:

Or, if you have the actual key values already, you can upload them as datasets, and then use the “Dataset Column” type with a distribution type of “cartesian” on both to create unique combinations.