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

id

VARCHAR(25)

NOT NULL

(primary key)

The ID associated with this collective scenario instance.

scenario_name

WVARCHAR(255)

NULL

The name of the scenario.

modification_time

NUMERIC(19)

NULL

The last time the scenario was modified.

segment_name

WVARCHAR(255)

NULL

The name of the scenario segment.

creator_id

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.

state

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

id

VARCHAR(25)

NOT NULL

(primary key)

The ID associated with this individual scenario instance.

scenario_name

WVARCHAR(255)

NULL

The name of the scenario.

modification_time

NUMERIC(19)

NULL

The last time the scenario was modified.

segment_name

WVARCHAR(255)

NULL

The name of the scenario segment.

creator_id

VARCHAR(25)

NULL

The ID associated with the scenario that created this individual scenario instance.

state

VARCHAR(16)

NULL

The state of this individual scenario instance in the scenario state machine.

user_id

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

id

VARCHAR(25)

NOT NULL

(primary key)

The ID associated with the individual scenario instance. References dss_ind_scenario (id).

tag

WVARCHAR(25)

NOT NULL

(primary key)

The name of the scenario variable.

context_str

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

id

VARCHAR(25)

NOT NULL

(primary key)

The ID associated with the individual scenario instance. References dss_ind_scenario (id).

tag

WVARCHAR(25)

NOT NULL

(primary key)

The name of the scenario variable.

context_bool

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

id

VARCHAR(25)

NOT NULL

(primary key)

The ID associated with the individual scenario instance. References dss_ind_scenario (id).

tag

WVARCHAR(25)

NOT NULL

(primary key)

The name of the scenario variable.

context_long

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

id

VARCHAR(25)

NOT NULL

(primary key)

The ID associated with the individual scenario instance. References dss_ind_scenario (id).

tag

WVARCHAR(25)

NOT NULL

(primary key)

The name of the scenario variable.

context_dbl

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

id

VARCHAR(25)

NOT NULL

(primary key)

The ID associated with the individual scenario instance. References dss_ind_scenario (id).

tag

WVARCHAR(25)

NOT NULL

(primary key)

The name of the scenario variable.

context_date

TIMESTAMP

NULL

The date value of the scenario variable.

 
loading table of contents...