dss_coll_scenario
This table contains information about collective scenario instances. A collective scenario instance maintains the state of any scenario segment that applies to all users (in other words, any that are not specific to individual users). When the Scenarios module begins to execute a scenario segment, it creates a single collective scenario instance, called the root instance, to handle the execution. It may create other collective instances later during execution of that segment, for example to handle recurrent timer events such as a scenario element that occurs every Monday at 2 PM.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(25) | NOT NULL |
(primary key) | The ID associated with this collective scenario instance. | |
| WVARCHAR(255) | NULL |
The name of the scenario. | ||
| NUMERIC(19) | NULL |
The last time the scenario was modified. | ||
| WVARCHAR(255) | NULL |
The name of the scenario segment. | ||
| VARCHAR(25) | NULL |
The unique identifier for the scenario instance that created this collective scenario instance. This value is null if this is the root instance. | ||
| VARCHAR(16) | NULL |
The state of this collective scenario instance in the scenario state machine. |
dss_ind_scenario
This table contains information about individual scenario instances. Each scenario instance maintains the state associated with a particular scenario segment that is currently processing a user. Individual scenario instances are formed from collective scenario instances, typically when user-specific events occur, for example when a user visits a particular page.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(25) | NOT NULL |
(primary key) | The ID associated with this individual scenario instance. | |
| WVARCHAR(255) | NULL |
The name of the scenario. | ||
| NUMERIC(19) | NULL |
The last time the scenario was modified. | ||
| WVARCHAR(255) | NULL |
The name of the scenario segment. | ||
| VARCHAR(25) | NULL |
The ID associated with the scenario that created this individual scenario instance. | ||
| VARCHAR(16) | NULL |
The state of this individual scenario instance in the scenario state machine. | ||
| VARCHAR(25) | NOT NULL |
The ID associated with the user to whom this scenario instance belongs. |
dss_scenario_strs
This table contains a map of any String variables that have been set for a given scenario instance.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(25) | NOT NULL |
(primary key) | The ID associated with the individual scenario instance. References | |
| WVARCHAR(25) | NOT NULL |
(primary key) | The name of the scenario variable. | |
| VARCHAR(255) | NULL |
The string value of the scenario variable. |
dss_scenario_bools
This table contains a map of any Boolean scenario variables that have been set for a given scenario instance.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(25) | NOT NULL |
(primary key) | The ID associated with the individual scenario instance. References | |
| WVARCHAR(25) | NOT NULL |
(primary key) | The name of the scenario variable. | |
| NUMERIC(1) | NULL |
The Boolean value of the scenario variable. |
dss_scenario_longs
This table contains a map of any Long scenario variables that have been set for a given scenario instance.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(25) | NOT NULL |
(primary key) | The ID associated with the individual scenario instance. References | |
| WVARCHAR(25) | NOT NULL |
(primary key) | The name of the scenario variable. | |
| NUMERIC(19) | NULL |
The long value of the scenario variable. |
dss_scenario_dbls
This table contains a map of any Double scenario variables that have been set for a given scenario instance.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(25) | NOT NULL |
(primary key) | The ID associated with the individual scenario instance. References | |
| WVARCHAR(25) | NOT NULL |
(primary key) | The name of the scenario variable. | |
| NUMERIC(15, 4) | NULL |
The double value of the scenario variable. |
dss_scenario_dates
This table contains a map of any Date scenario variables that have been set for a given scenario instance.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(25) | NOT NULL |
(primary key) | The ID associated with the individual scenario instance. References | |
| WVARCHAR(25) | NOT NULL |
(primary key) | The name of the scenario variable. | |
| TIMESTAMP | NULL |
The date value of the scenario variable. |