# Xray schema ERD

Table and field reference for the Fivetran Xray connector.

## Table & Field Reference

### status_detail

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| color | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| object | Unknown |  |

### test_step_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| test_step_id | Unknown | PK, FK |
| filename | Unknown |  |

### test_step

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| test_id | Unknown | PK, FK |
| action | Unknown |  |
| data | Unknown |  |
| result | Unknown |  |
| custom_** |  |  |

### test

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assignee_account_id | Unknown |  |
| assignee_account_type | Unknown |  |
| assignee_active | Unknown |  |
| assignee_display_name | Unknown |  |
| assignee_pixel_16_16 | Unknown |  |
| assignee_pixel_24_24 | Unknown |  |
| assignee_pixel_32_32 | Unknown |  |
| assignee_pixel_48_48 | Unknown |  |
| assignee_self | Unknown |  |
| assignee_time_zone | Unknown |  |
| kind | Unknown |  |
| name | Unknown |  |
| reporter_account_id | Unknown |  |
| reporter_account_type | Unknown |  |
| reporter_active | Unknown |  |
| reporter_display_name | Unknown |  |
| reporter_pixel_16_16 | Unknown |  |
| reporter_pixel_24_24 | Unknown |  |
| reporter_pixel_32_32 | Unknown |  |
| reporter_pixel_48_48 | Unknown |  |
| reporter_self | Unknown |  |
| reporter_time_zone | Unknown |  |

### pre_condition

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assignee_account_id | Unknown | FK |
| reporter_account_id | Unknown | FK |
| assignee_account_type | Unknown |  |
| assignee_active | Unknown |  |
| assignee_display_name | Unknown |  |
| assignee_pixel_16_16 | Unknown |  |
| assignee_pixel_24_24 | Unknown |  |
| assignee_pixel_32_32 | Unknown |  |
| assignee_pixel_48_48 | Unknown |  |
| assignee_self | Unknown |  |
| assignee_time_zone | Unknown |  |
| definition | Unknown |  |
| kind | Unknown |  |
| name | Unknown |  |
| reporter_account_type | Unknown |  |
| reporter_active | Unknown |  |
| reporter_display_name | Unknown |  |
| reporter_pixel_16_16 | Unknown |  |
| reporter_pixel_24_24 | Unknown |  |
| reporter_pixel_32_32 | Unknown |  |
| reporter_pixel_48_48 | Unknown |  |
| reporter_self | Unknown |  |
| reporter_time_zone | Unknown |  |

### test_plan

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assignee_account_id | Unknown | FK |
| reporter_account_id | Unknown | FK |
| assignee_account_type | Unknown |  |
| assignee_active | Unknown |  |
| assignee_display_name | Unknown |  |
| assignee_pixel_16_16 | Unknown |  |
| assignee_pixel_24_24 | Unknown |  |
| assignee_pixel_32_32 | Unknown |  |
| assignee_pixel_48_48 | Unknown |  |
| assignee_self | Unknown |  |
| assignee_time_zone | Unknown |  |
| reporter_account_type | Unknown |  |
| reporter_active | Unknown |  |
| reporter_display_name | Unknown |  |
| reporter_pixel_16_16 | Unknown |  |
| reporter_pixel_24_24 | Unknown |  |
| reporter_pixel_32_32 | Unknown |  |
| reporter_pixel_48_48 | Unknown |  |
| reporter_self | Unknown |  |
| reporter_time_zone | Unknown |  |

### test_execution

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| assignee_account_id | Unknown | FK |
| reporter_account_id | Unknown | FK |
| assignee_account_type | Unknown |  |
| assignee_active | Unknown |  |
| assignee_display_name | Unknown |  |
| assignee_pixel_16_16 | Unknown |  |
| assignee_pixel_24_24 | Unknown |  |
| assignee_pixel_32_32 | Unknown |  |
| assignee_pixel_48_48 | Unknown |  |
| assignee_self | Unknown |  |
| assignee_time_zone | Unknown |  |
| reporter_account_type | Unknown |  |
| reporter_active | Unknown |  |
| reporter_display_name | Unknown |  |
| reporter_pixel_16_16 | Unknown |  |
| reporter_pixel_24_24 | Unknown |  |
| reporter_pixel_32_32 | Unknown |  |
| reporter_pixel_48_48 | Unknown |  |
| reporter_self | Unknown |  |
| reporter_time_zone | Unknown |  |

### test_run

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| execution_test_id | Unknown | FK |
| status_name | Unknown | FK |
| test_id | Unknown | FK |
| assignee_id | Unknown |  |
| examples | Unknown |  |
| executed_by_id | Unknown |  |
| finished_on | Unknown |  |
| gherkin | Unknown |  |
| last_modified | Unknown |  |
| started_on | Unknown |  |
| status_color | Unknown |  |
| status_description | Unknown |  |

### expanded_test_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| expanded_test_id | Unknown | PK, FK |
| expanded_test_step_index | Unknown | PK, FK |
| filename | Unknown |  |

### expanded_test_step

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| expanded_test_id | Unknown | PK, FK |
| action | Unknown |  |
| called_test_issue_id | Unknown |  |
| data | Unknown |  |
| id | Unknown |  |
| parent_test_issue_id | Unknown |  |
| result | Unknown |  |
| custom_** |  |  |

### expanded_test

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assignee_account_id | Unknown | FK |
| reporter_account_id | Unknown | FK |
| assignee_account_type | Unknown |  |
| assignee_active | Unknown |  |
| assignee_display_name | Unknown |  |
| assignee_pixel_16_16 | Unknown |  |
| assignee_pixel_24_24 | Unknown |  |
| assignee_pixel_32_32 | Unknown |  |
| assignee_pixel_48_48 | Unknown |  |
| assignee_self | Unknown |  |
| assignee_time_zone | Unknown |  |
| kind | Unknown |  |
| name | Unknown |  |
| reporter_account_type | Unknown |  |
| reporter_active | Unknown |  |
| reporter_display_name | Unknown |  |
| reporter_pixel_16_16 | Unknown |  |
| reporter_pixel_24_24 | Unknown |  |
| reporter_pixel_32_32 | Unknown |  |
| reporter_pixel_48_48 | Unknown |  |
| reporter_self | Unknown |  |
| reporter_time_zone | Unknown |  |
| warnings | Json |  |

### test_set

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assignee_account_id | Unknown | FK |
| reporter_account_id | Unknown | FK |
| assignee_account_type | Unknown |  |
| assignee_active | Unknown |  |
| assignee_display_name | Unknown |  |
| assignee_pixel_16_16 | Unknown |  |
| assignee_pixel_24_24 | Unknown |  |
| assignee_pixel_32_32 | Unknown |  |
| assignee_pixel_48_48 | Unknown |  |
| assignee_self | Unknown |  |
| assignee_time_zone | Unknown |  |
| reporter_account_type | Unknown |  |
| reporter_active | Unknown |  |
| reporter_display_name | Unknown |  |
| reporter_pixel_16_16 | Unknown |  |
| reporter_pixel_24_24 | Unknown |  |
| reporter_pixel_32_32 | Unknown |  |
| reporter_pixel_48_48 | Unknown |  |
| reporter_self | Unknown |  |
| reporter_time_zone | Unknown |  |

## Relationships

- test_step_attachment(test_step_id) → test_step(id)
- test_step(test_id) → test(id)
- pre_condition(reporter_account_id) → test(reporter_account_id)
- pre_condition(assignee_account_id) → test(assignee_account_id)
- test_plan(reporter_account_id) → test(reporter_account_id)
- test_plan(assignee_account_id) → test(assignee_account_id)
- test_execution(id) → test_plan(id)
- test_execution(reporter_account_id) → test(reporter_account_id)
- test_execution(assignee_account_id) → test(assignee_account_id)
- test_run(test_id) → test(id)
- test_run(execution_test_id) → expanded_test(id)
- test_run(status_name) → status_detail(name)
- expanded_test_attachment(expanded_test_step_index) → expanded_test_step(index)
- expanded_test_attachment(expanded_test_id) → expanded_test_step(expanded_test_id)
- expanded_test_step(expanded_test_id) → expanded_test(id)
- expanded_test(reporter_account_id) → test(reporter_account_id)
- expanded_test(assignee_account_id) → test(assignee_account_id)
- test_set(reporter_account_id) → test(reporter_account_id)
- test_set(assignee_account_id) → test(assignee_account_id)