# Pylon Support Platform schema ERD

Table and field reference for the Fivetran Pylon Support Platform connector.

## Table & Field Reference

### issue_tag

| Column | Type | Keys |
| --- | --- | --- |
| tags | Unknown | PK |
| issue_id | Unknown | PK, FK |

### issue_csat_response

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| issue_id | Unknown | PK, FK |
| comment | Unknown |  |
| score | Unknown |  |

### issue_external_issue

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| issue_id | Unknown | PK, FK |
| external_id | Unknown |  |
| link | Unknown |  |
| source | Unknown |  |

### issue_active_time_by_user

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| issue_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| active_time_seconds | Unknown |  |
| business_hours_active_time_seconds | Unknown |  |

### issue_team_sla

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| issue_id | Unknown | PK, FK |
| team_id | Unknown | FK |
| first_response_breach_time | Unknown |  |
| first_response_business_hours_seconds | Unknown |  |
| first_response_seconds | Unknown |  |
| first_response_time | Unknown |  |
| resolution_breach_time | Unknown |  |
| resolution_business_hours_seconds | Unknown |  |
| resolution_seconds | Unknown |  |
| resolution_time | Unknown |  |

### issue

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Json | FK |
| assignee_id | Json | FK |
| parent_issue_group_id | Unknown | FK |
| slack_channel_id | Unknown | FK |
| team_id | Unknown | FK |
| author_unverified | Unknown |  |
| body_html | Unknown |  |
| business_hours_first_response_seconds | Unknown |  |
| business_hours_resolution_seconds | Unknown |  |
| business_hours_time_in_status_seconds | Json |  |
| child_issues | Json |  |
| created_at | Instant |  |
| customer_portal_visible | Unknown |  |
| first_response_time | Unknown |  |
| latest_message_time | Unknown |  |
| number | Unknown |  |
| number_of_touches | Unknown |  |
| requester_id | Json |  |
| resolution_time | Unknown |  |
| slack_message_ts | Unknown |  |
| slack_workspace_id | Unknown |  |
| snoozed_until_time | Unknown |  |
| source | Unknown |  |
| state | Unknown |  |
| time_in_status_seconds | Json |  |
| title | Unknown |  |
| type | Unknown |  |
| updated_at | Instant |  |
| custom_** |  |  |

### issue_follower

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| issue_id | Unknown | PK, FK |
| type | Unknown |  |

### team_user

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| team_id | Unknown | PK, FK |
| user_ids | Unknown | FK |

### team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |

### message

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| issue_id | Unknown | PK, FK |
| author_contact_id | Unknown | FK |
| author_user_id | Unknown | FK |
| author_name | Unknown |  |
| is_private | Unknown |  |
| message_html | Unknown |  |
| source | Unknown |  |
| thread_id | Unknown |  |
| timestamps | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| emails | Json |  |
| name | Unknown |  |
| role_id | Unknown |  |
| status | Unknown |  |

### tags

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| object_type | Unknown |  |
| value | Unknown |  |

### ticket_form_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| ticket_form_id | Unknown | PK, FK |
| description_html | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |

### ticket_form

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| description_html | Unknown |  |
| is_public | Unknown |  |
| name | Unknown |  |

### user_role

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| name | Unknown |  |

### issue_thread

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| issue_id | Unknown | PK, FK |
| channel_id | Unknown | FK |
| name | Unknown |  |
| source | Unknown |  |
| thread_id | Unknown |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Json | FK |
| avatar_url | Unknown |  |
| email | Unknown |  |
| emails | Json |  |
| name | Unknown |  |
| portal_role | Unknown |  |
| custom_** |  |  |

### knowledge_base_supported_language

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| knowledge_base_id | Unknown | PK, FK |
| supported_language | Unknown |  |

### knowledge_base

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| default_language | Unknown |  |
| title | Unknown |  |

### account_channel

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | PK, FK |
| source | Unknown |  |

### account_tag

| Column | Type | Keys |
| --- | --- | --- |
| tags | Unknown | PK |
| account_id | Unknown | PK, FK |

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| domains | Json |  |
| latest_customer_activity_time | Unknown |  |
| name | Unknown |  |
| owner | Json |  |
| primary_domain | Unknown |  |
| type | Unknown |  |
| custom_** |  |  |

## Relationships

- issue_tag(issue_id) → issue(id)
- issue_csat_response(issue_id) → issue(id)
- issue_external_issue(issue_id) → issue(id)
- issue_active_time_by_user(user_id) → users(id)
- issue_active_time_by_user(issue_id) → issue(id)
- issue_team_sla(team_id) → team(id)
- issue_team_sla(issue_id) → issue(id)
- issue(team_id) → team(id)
- issue(parent_issue_group_id) → issue(id)
- issue(assignee_id) → users(id)
- issue(account_id) → account(id)
- issue(slack_channel_id) → account_channel(id)
- issue_follower(issue_id) → issue(id)
- team_user(user_ids) → users(id)
- team_user(team_id) → team(id)
- message(author_contact_id) → contact(id)
- message(author_user_id) → users(id)
- message(issue_id) → issue(id)
- ticket_form_field(ticket_form_id) → ticket_form(id)
- user_role(id) → users(role_id)
- issue_thread(channel_id) → account_channel(id)
- issue_thread(issue_id) → issue(id)
- contact(account_id) → account(id)
- knowledge_base_supported_language(knowledge_base_id) → knowledge_base(id)
- account_channel(account_id) → account(id)
- account_tag(account_id) → account(id)