| execution_id | Unique execution of a test | Primary Key, Foreign Key | ✓ | nvarchar(100) | VARCHAR2(100) | varchar(100) | VARCHAR(100) | VARCHAR(100) |
| node_id | Unique ID for an item in a test, e.g., a Step, a Scenario, a Feature, etc. | Primary Key | ✓ | nvarchar(255) | VARCHAR2(255) | varchar(255) | VARCHAR(255) | VARCHAR(255) |
| parent_node_id | The immediate parent of this node. E.g., the ID of the Scenario to which a Step belongs | | | nvarchar(255) | VARCHAR2(255) | varchar(255) | VARCHAR(255) | VARCHAR(255) |
| sending_node_id | The Feature, Playlist, or Group which is the ancestor of this node. This is primarily for sorting data in Group Tests. | | ✓ | nvarchar(255) | VARCHAR2(255) | varchar(255) | VARCHAR(255) | VARCHAR(255) |
| node_sequence | Used for sorting sequence of nodes within a Feature | | ✓ | int | int | int(11) | int | int |
| node_type | Indicates whether a node is a Playlist, Group Test, Group, Feature, Scenario, Step Block, or Step | | ✓ | nvarchar(100) | VARCHAR2(100) | varchar(100) | VARCHAR(100) | VARCHAR(100) |
| block_type | If the node is a Step Block, is this a Background, After Scenario, top level Scenario, inner Sceanrio, or a group of steps that are part of a conditional statement | | | nvarchar(100) | VARCHAR2(100) | varchar(100) | VARCHAR(100) | VARCHAR(100) |
| name | The name of the Feature, Scenario, Step, etc. | | | text | VARCHAR2(1000) | text | VARCHAR2(1000) | VARCHAR |
| status | Started, Pass, Fail, True, False, Stopped, or Restarted | | ✓ | nvarchar(100) | VARCHAR2(100) | varchar(100) | VARCHAR(100) | VARCHAR(100) |
| message | Any return value provided by a Step | | | text | VARCHAR2(1000) | text | VARCHAR2(1000) | VARCHAR |
| error_message | Any error message provided by a false or failure | | | text | VARCHAR2(1000) | text | VARCHAR2(1000) | VARCHAR |
| file_uri | The location of the file that produced this node | | | text | VARCHAR2(1000) | text | VARCHAR2(1000) | VARCHAR |
| start_line | The first line that produced this node in the Feature file for the Step, Scenario, etc. | | | int | int | int(11) | int | int |
| end_line | The last line that produced this node in the Feature file for the Step, Scenario, etc., | | | int | int | int(11) | int | int |
| data_file_path | For a Group Test, the CSV file that provided the worker data | | | text | VARCHAR2(1000) | text | VARCHAR2(1000) | VARCHAR |
| worker_name | The worker name (if this node is a Feature which represents a worker in a group) | | | text | VARCHAR2(1000) | text | VARCHAR2(1000) | VARCHAR |
| tags | If this node is a Scenario, any tags | | | text | VARCHAR2(1000) | text | VARCHAR2(1000) | VARCHAR |
| step_id | If this node is a Step, the step ID, which can be found in the step guide | | | nvarchar(100) | VARCHAR2(100) | varchar(100) | VARCHAR(100) | VARCHAR(100) |
| delay_start_time | If this node is a Step with a non-zero step delay, this field will be the time at which the delay began | | | datetime2(7) | timestamp(6) | datetime(3) | TIMESTAMP | TIMESTAMP |
| start_time | The time at which execution of the node began | | ✓ | datetime2(7) | timestamp(6) | datetime(3) | TIMESTAMP | TIMESTAMP |
| end_time | The time at which execution of this node finished | | | datetime2(7) | timestamp(6) | datetime(3) | TIMESTAMP | TIMESTAMP |