Subtable

subtable to be ported recursively, as it has a foreign-key reference to the parent source table

Ingredient Family: portSubtablesIngredients

Outline Display: Source table? {{sourceTable}}
Source table’s foreign-key column? {{sparent}}
Destination table? {{destinationTable}}
Destination table’s foreign-key column? {{dparent}}
How to port this subtable? {{columns}}

Local scope

Names introduced within this component’s knobs:

• sourceTable – table chosen from the app’s schema (via sourceTable knob)
• destinationTable – table chosen from the app’s schema (via destinationTable knob)

Settings

Required

• sourceTable : table
  source subtable, which must have a foreign key pointing to the parent source table

• sparent : column of sourceTable (type filter: any type)
  source column, a foreign-key reference to the parent source table

• destinationTable : table
  destination subtable, which must have a foreign key pointing to the parent destination table

• dparent : column of destinationTable (type filter: any type)
  destination column, a foreign-key reference to the parent destination table

• columns : ingredient slot of portIngredients(sourceTable, destinationTable) (many, until destinationTable is filled)
  Data-Porting Column Handling