Simulation

Tables for simulation personas, scenarios, unit tests, and runs.

Simulation Personas Table

Table Name: simulation_personas Description: Simulated user personas for testing

Schema

Column	Type	Description
_id	string	Persona identifier
created_at	timestamp	Creation timestamp
creator_user_id	string	Creator user ID
deleted_at	timestamp	Deletion timestamp
deleted_by_user_id	string	User who deleted the scenario
is_deleted	boolean	Deletion status
latest_version_background	string	Latest persona background
name	string	Persona name
org_id	string	Organization identifier
region_name	string	Deployment region
role	string	Persona role
tags	json	Associated tags
updated_at	timestamp	Last update timestamp
updated_by_user_id	string	Last updater user ID

Query Example

SELECT 
  name,
  role,
  latest_version_background,
  tags
FROM simulation_personas
WHERE is_deleted = false;

Simulation Persona Versions Table

Table Name: simulation_persona_versions Description: Version history for simulation personas

Schema

Column	Type	Description
_id	string	Version identifier
background	string	Persona background
created_at	timestamp	Creation timestamp
org_id	string	Organization identifier
preferred_language	string	Preferred language
region_name	string	Deployment region
simulation_persona_id	string	Parent persona ID
timezone	string	Persona timezone
updated_at	timestamp	Last update timestamp
version	integer	Version number

Query Example

SELECT 
  simulation_persona_id,
  version,
  background,
  preferred_language
FROM simulation_persona_versions
ORDER BY version DESC;

Simulation Scenarios Table

Table Name: simulation_scenarios Description: Test scenario configurations

Schema

Column	Type	Description
_id	string	Scenario identifier
created_at	timestamp	Creation timestamp
creator_user_id	string	Creator user ID
deleted_at	timestamp	Deletion timestamp
deleted_by_user_id	string	User who deleted the scenario
is_deleted	boolean	Deletion status
latest_version_instructions	string	Latest instructions
latest_version_objective	string	Latest objective
name	string	Scenario name
org_id	string	Organization identifier
region_name	string	Deployment region
tags	json	Associated tags
updated_at	timestamp	Last update timestamp
updated_by_user_id	string	Last updater user ID

Query Example

SELECT 
  name,
  latest_version_objective,
  latest_version_instructions,
  tags
FROM simulation_scenarios
WHERE is_deleted = false;

Simulation Scenario Versions Table

Table Name: simulation_scenario_versions Description: Version history for simulation scenarios

Schema

Column	Type	Description
_id	string	Version identifier
created_at	timestamp	Creation timestamp
initial_message_config	json	Initial message configuration
instructions	string	Scenario instructions
objective	string	Scenario objective
org_id	string	Organization identifier
region_name	string	Deployment region
simulation_scenario_id	string	Parent scenario ID
updated_at	timestamp	Last update timestamp
version	integer	Version number

Query Example

SELECT 
  simulation_scenario_id,
  version,
  objective,
  instructions
FROM simulation_scenario_versions
ORDER BY version DESC;

Simulation Unit Tests Table

Table Name: simulation_unit_tests Description: Unit test configurations for conversation simulations

Schema

Column	Type	Description
_id	string	Unit test identifier
created_at	timestamp	Creation timestamp
creator_user_id	string	Creator user ID
description	string	Test description
is_deleted	boolean	Deletion status
max_interactions	integer	Maximum interactions
name	string	Test name
org_id	string	Organization identifier
persona_id	string	Associated persona ID
region_name	string	Deployment region
scenario_id	string	Associated scenario ID
service_id	string	Associated service ID
service_version_set_name	string	Version set name
success_criterions	json	Success criteria
tags	json	Associated tags
updated_at	timestamp	Last update timestamp
updated_by_user_id	string	Last updater user ID

Query Example

SELECT 
  name,
  description,
  service_id,
  persona_id,
  scenario_id,
  success_criterions
FROM simulation_unit_tests
WHERE is_deleted = false;

Simulation Unit Test Sets Table

Table Name: simulation_unit_test_sets Description: Collections of related unit tests

Schema

Column	Type	Description
_id	string	Test set identifier
created_at	timestamp	Creation timestamp
creator_user_id	string	Creator user ID
description	string	Test set description
is_deleted	boolean	Deletion status
last_triggered_run_id	string	Last run ID
name	string	Test set name
org_id	string	Organization identifier
region_name	string	Deployment region
tags	json	Associated tags
unit_test_runs	json	Test run history
updated_at	timestamp	Last update timestamp
updated_by_user_id	string	Last updater user ID

Query Example

SELECT 
  name,
  description,
  last_triggered_run_id,
  unit_test_runs
FROM simulation_unit_test_sets
WHERE is_deleted = false;

Simulation Unit Test Set Runs Table

Table Name: simulation_unit_test_set_runs Description: Execution results for unit test sets

Schema

Column	Type	Description
_id	string	Run identifier
artifacts_generated	json	Generated artifacts
created_at	timestamp	Creation timestamp
creator_user_id	string	Creator user ID
errored	boolean	Error status
failed_metrics	json	Failed metric details
org_id	string	Organization identifier
region_name	string	Deployment region
simulation_unit_test_set_id	string	Parent test set ID
unit_test_run_results	json	Test execution results
unit_test_run_specs	json	Test specifications
updated_at	timestamp	Last update timestamp

Query Example

SELECT 
  simulation_unit_test_set_id,
  errored,
  failed_metrics,
  unit_test_run_results,
  created_at
FROM simulation_unit_test_set_runs
ORDER BY created_at DESC;