Adding an incremental key

  1. Click the gear icon in the AnySQL Modeler.
  2. Click ADD INCREMENTAL KEY.
    A new blank line is created.
  3. Select Object and Column from the drop-down list.
  4. Click + to add the related child column.
  5. Specify this information:
    • A time offset value and a unit, to use the Time Offset option.

      When no value is specified, the Time Offset option is not used.

    • For data types stored without time zone information, a drop-down list is enabled in the Time Zone column. Select the time zone in which the date time values are stored in the source database.
  6. Click UPDATE to return to the modeler screen.