# Split schema ERD

Table and field reference for the Fivetran Split connector.

## Table & Field Reference

### groups

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| description | String |  |
| name | String |  |

### environment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| workspace_id | String | FK |
| name | String |  |
| production | Boolean |  |

### change_request_comment

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| change_request_id | String | FK |
| comment | String |  |
| role | String |  |
| time_stamp | Instant |  |
| users | String |  |

### change_request

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| rollout_status_id | String | FK |
| split_id | Unknown | FK |
| approvers | Json |  |
| operation_type | String |  |
| segment | String |  |
| split_open_change_request_id | String |  |
| split_split_id | String |  |
| status | String |  |
| title | String |  |

### resource_permission_view

| Column | Type | Keys |
| --- | --- | --- |
| user_id | String | PK, FK |
| workspace_restriction_resource_id | String | PK, FK |

### workspace_restriction

| Column | Type | Keys |
| --- | --- | --- |
| resource_id | String | PK, FK |
| id | String |  |
| view | Boolean |  |

### traffic_type

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| workspace_id | String | FK |
| display_attribute_id | String |  |
| name | String |  |

### split_tag

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| split_id | String | PK, FK |

### split

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| rollout_status_id | String | FK |
| traffic_type_id | String | FK |
| workspace_id | String | FK |
| creation_time | Instant |  |
| description | String |  |
| name | String |  |
| rollout_status_timestamp | String |  |

### rollout_status

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| workspace_id | String | FK |
| description | String |  |
| name | String |  |

### split_definition_treatment

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| split_definition_environment_environment_id | String | FK |
| split_definition_environment_split_id | String | FK |
| configurations | String |  |
| description | String |  |
| key | Json |  |
| name | String |  |
| segment | Json |  |

### split_definition_rule

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| split_definition_environment_environment_id | String | FK |
| split_definition_environment_split_id | String | FK |
| size | Int |  |
| treatment | String |  |

### split_definition_rule_bucket

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| environment_id | String | PK, FK |
| split_id | String | PK, FK |
| size | Int |  |
| treatment | String |  |

### split_definition_rule_condition

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| split_definition_environment_environment_id | String | FK |
| split_definition_environment_split_id | String | FK |
| combiner | String |  |
| matchers | Json |  |

### split_definition_environment

| Column | Type | Keys |
| --- | --- | --- |
| environment_id | String | PK, FK |
| split_id | String | PK, FK |
| traffic_type_id | String | FK |
| workspace_id | String | FK |
| baseline_treatment | String |  |
| change_number | Double |  |
| creation_time | Instant |  |
| default_treatment | String |  |
| killed | String |  |
| last_update_time | Instant |  |
| traffic_allocation | Int |  |

### workspace

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| name | String |  |
| requires_title_and_comments | Boolean |  |

### attribute_suggested_value

| Column | Type | Keys |
| --- | --- | --- |
| suggested_value | String | PK |
| attribute_id | String | PK, FK |

### attribute

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| traffic_type_id | String | FK |
| workspace_id | String | FK |
| data_type | String |  |
| display_name | String |  |
| is_searchable | String |  |
| organization_id | String |  |
| set_description | String |  |

### segment_tag

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| segment_name | String | PK, FK |

### segment

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| workspace_id | String | PK, FK |
| traffic_type_id | String | FK |
| creation_time | Instant |  |
| description | String |  |

### segment_environment

| Column | Type | Keys |
| --- | --- | --- |
| environment_id | String | PK, FK |
| segment_name | String | PK, FK |
| workspace_id | String | PK, FK |
| traffic_type_id | String | FK |
| creation_time | Instant |  |

### segment_key_environment

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| environment_id | String | FK |
| segment_environment_segment_name | String | FK |
| key | String |  |

### user_group

| Column | Type | Keys |
| --- | --- | --- |
| group_id | String | PK, FK |
| users_id | String | PK, FK |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| email | String |  |
| name | String |  |
| status | String |  |
| two_factor_authentication | Boolean |  |
| type | String |  |

## Relationships

- environment(workspace_id) → workspace(id)
- change_request_comment(change_request_id) → change_request(id)
- change_request(rollout_status_id) → rollout_status(id)
- change_request(split_id) → split_definition_environment(split_id)
- resource_permission_view(user_id) → users(id)
- resource_permission_view(workspace_restriction_resource_id) → workspace_restriction(resource_id)
- workspace_restriction(resource_id) → workspace(id)
- traffic_type(workspace_id) → workspace(id)
- split_tag(split_id) → split(id)
- split(rollout_status_id) → rollout_status(id)
- split(traffic_type_id) → traffic_type(id)
- split(workspace_id) → workspace(id)
- rollout_status(workspace_id) → workspace(id)
- split_definition_treatment(split_definition_environment_split_id) → split_definition_environment(split_id)
- split_definition_treatment(split_definition_environment_environment_id) → split_definition_environment(environment_id)
- split_definition_rule(split_definition_environment_split_id) → split_definition_environment(split_id)
- split_definition_rule(split_definition_environment_environment_id) → split_definition_environment(environment_id)
- split_definition_rule_bucket(split_id) → split_definition_environment(split_id)
- split_definition_rule_bucket(environment_id) → split_definition_environment(environment_id)
- split_definition_rule_condition(split_definition_environment_split_id) → split_definition_environment(split_id)
- split_definition_rule_condition(split_definition_environment_environment_id) → split_definition_environment(environment_id)
- split_definition_environment(traffic_type_id) → traffic_type(id)
- split_definition_environment(split_id) → split(id)
- split_definition_environment(workspace_id) → workspace(id)
- split_definition_environment(environment_id) → environment(id)
- attribute_suggested_value(attribute_id) → attribute(id)
- attribute(traffic_type_id) → traffic_type(id)
- attribute(workspace_id) → workspace(id)
- segment_tag(segment_name) → segment(name)
- segment(traffic_type_id) → traffic_type(id)
- segment(workspace_id) → workspace(id)
- segment_environment(segment_name) → segment(name)
- segment_environment(traffic_type_id) → traffic_type(id)
- segment_environment(environment_id) → environment(id)
- segment_environment(workspace_id) → workspace(id)
- segment_key_environment(environment_id) → environment(id)
- segment_key_environment(segment_environment_segment_name) → segment_environment(segment_name)
- user_group(group_id) → groups(id)
- user_group(users_id) → users(id)