Pylon Support Platform
Explore the interactive ERD
Table & Field Reference
issue_tag
| Column | Type | Keys |
|---|---|---|
tags | Unknown | PK |
issue_id | Unknown | PKFK |
issue_csat_response
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
issue_id | Unknown | PKFK |
comment | Unknown | |
score | Unknown |
issue_external_issue
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
issue_id | Unknown | PKFK |
external_id | Unknown | |
link | Unknown | |
source | Unknown |
issue_active_time_by_user
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
issue_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
type | Unknown |
team_user
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
team_id | Unknown | PKFK |
user_ids | Unknown | FK |
team
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown |
message
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
issue_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
name | Unknown |
issue_thread
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
issue_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
source | Unknown |
account_tag
| Column | Type | Keys |
|---|---|---|
tags | Unknown | PK |
account_id | Unknown | PKFK |
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_** |