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 |
---|---|---|
| VARCHAR(25) | NOT NULL |
(primary key) | The unique identifier of the scenario. | |
| VARCHAR(25) | NOT NULL |
References | ||
| VARCHAR(255) | NULL |
The user-specified scenario name. | ||
| NUMERIC(19) | NULL |
The time the scenario was changed in the ACC. | ||
| INTEGER | NULL |
The version number of the state machine. | ||
| LONG VARBINARY | NULL |
The SDL file for the scenario being migrated. | ||
| 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 |
---|---|---|
| VARCHAR(25) | NOT NULL |
(primary key) | The unique identifier of the scenario. References | |
| INTEGER | NOT NULL |
(primary key) | An index used to order the segment names. | |
| 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 |
---|---|---|
| VARCHAR(25) | NOT NULL |
(primary key) | The unique identifier of the scenario. | |
| WVARCHAR(255) | NULL |
The user-specified scenario name. | ||
| NUMERIC(19) | NULL |
The modification time from which the scenario is being migrated. | ||
| 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 |
---|---|---|
| VARCHAR(25) | NOT NULL |
(primary key) | The unique identifier of the scenario. References | |
| INTEGER | NOT NULL |
(primary key) | An index used to order the segment names. | |
| VARCHAR(255) | NULL |
The user-specified segment name. |