These tables are used by the Scenarios module to allow changes to be made to a running scenario without losing the status of any users progressing through it.

dss_scen_mig_info

This table stores migration information for each user progressing though a given scenario.

Column

Data Type

Constraint

Description

id
(primary key)

VARCHAR(25)

NOT NULL

The unique identifier of the scenario.

scenario_info_id

VARCHAR(25)

NOT NULL

References dss_scenario_info(id)

scenario_name

VARCHAR(255)

NULL

The user-specified scenario name.

modification_time

NUMERIC(19)

NULL

The time the scenario was changed in the ACC.

psm_version

INTEGER

NULL

The version number of the state machine.

sdl

LONG VARBINARY

NULL

The SDL file for the scenario being migrated.

migration_status

INTEGER

NULL

Indicates whether the scenario migration is in progress (1) or complete (2).

dss_scen_mig_info_seg

This table is stores information about scenario segments being migrated.

Column

Data Type

Constraint

Description

id
(primary key)

VARCHAR(25)

NOT NULL

The unique identifier of the scenario. References dss_scen_mig_info(id).

idx
(primary key)

INTEGER

NOT NULL

An index used to order the segment names.

segment_name

VARCHAR(255)

NULL

The user-specified segment name

dss_migration

This table is used to store information about a pending scenario migration operation that changes the modification time of all the individual scenario instances associated with an old version of a scenario (indicated by the old modification time).

Column

Data Type

Constraint

Description

id
(primary key)

VARCHAR(25)

NOT NULL

The unique identifier of the scenario.

scenario_name

WVARCHAR(255)

NULL

The user-specified scenario name.

old_mod_time

NUMERIC(19)

NULL

The modification time from which the scenario is being migrated.

new_mod_time

NUMERIC(19)

NULL

The modification time to which the scenario is being migrated.

dss_mig_seg_name

This table is used to store information about scenario segments whose modification time is being migrated.

Column

Data Type

Constraint

Description

id
(primary key)

VARCHAR(25)

NOT NULL

The unique identifier of the scenario. References dss_migration(id).

idx
(primary key)

INTEGER

NOT NULL

An index used to order the segment names.

segment_name

VARCHAR(255)

NULL

The user-specified segment name.


Copyright © 1997, 2013 Oracle and/or its affiliates. All rights reserved. Legal Notices