Assign unique ID (with subtables)

IngredientportIngredients

Set column to a unique ID, also recursively figuring out how to port subtables with foreign-key references to the source table

Ingredient Family: portIngredients

Outline Display: Destination column? {{destinationColumn}}
How to handle subtables? {{subtables}}

Local scope

The parent slot binds these (look up the slot in the parent to see how):

  • $sourceTable – The source table
  • $destinationTable – The destination table

Settings

Required

  • sourceColumn : column of $sourceTable (type filter: exactly text; required, non-nullable)
    source column, targeted as a foreign key from all of the subtables

  • destinationColumn : column of $destinationTable (type filter: exactly text; required, non-nullable)
    destination column

Optional