Ringover
Explore the interactive ERD
Table & Field Reference
group_user
| Column | Type | Keys |
|---|---|---|
group_id | Unknown | PKFK |
user_id | Unknown | PKFK |
orders | Unknown | |
ring_duration | Unknown |
groups
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
color | Unknown | |
is_jumper | Unknown | |
name | Unknown | |
total_users_count | Unknown |
ivr
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
color | Unknown | |
name | Unknown |
call_survey
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
call_id | Unknown | FK |
channel_id | Unknown | |
name | Unknown | |
value | Unknown |
profile
| Column | Type | Keys |
|---|---|---|
profile_id | Unknown | PK |
name | Unknown |
call_tag
| Column | Type | Keys |
|---|---|---|
call_id | Unknown | PKFK |
id | Unknown | PKFK |
team_id | Unknown | PKFK |
user_id | Unknown | PKFK |
call
| Column | Type | Keys |
|---|---|---|
call_id | Unknown | PK |
team_id | Unknown | PKFK |
user_id | Unknown | PKFK |
call_user_id | Unknown | FK |
conference_id | Unknown | FK |
contact_id | Unknown | FK |
ivr_id | Unknown | FK |
amd | Unknown | |
answered_time | Unknown | |
cdr_id | Unknown | |
channel_id | Unknown | |
contact_number | Unknown | |
direction | Unknown | |
end_time | Unknown | |
fax | Unknown | |
from_number | Unknown | |
incall_duration | Unknown | |
is_archived | Unknown | |
last_state | Unknown | |
note | Unknown | |
record | Unknown | |
scenario_id | Unknown | |
scenario_name | Unknown | |
star | Unknown | |
start_time | Unknown | |
to_number | Unknown | |
total_duration | Unknown | |
type | Unknown | |
voicemail | Unknown |
ivr_scenario
| Column | Type | Keys |
|---|---|---|
ivr_id | Unknown | PK |
scenario_id | Unknown | PK |
id | Unknown | FK |
color | Unknown | |
is_default | Unknown | |
name | Unknown | |
scenario_type | Unknown |
conversation_member
| Column | Type | Keys |
|---|---|---|
conversation_user_id | Unknown | PK |
conversation_id | Unknown | PKFK |
contact_id | Unknown | FK |
coversation_id | Unknown | FK |
group_id | Unknown | FK |
ivr_id | Unknown | FK |
number_raw | Unknown | FK |
user_id | Unknown | FK |
alphanumeric | Unknown | |
is_administrator | Unknown | |
picture | Unknown | |
table_name | String |
conversation_star
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
conversation_id | Unknown | PKFK |
team_id | Unknown | PKFK |
user_id | Unknown | PKFK |
star | Unknown |
conversation_tag
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
conversation_id | Unknown | PKFK |
team_id | Unknown | PKFK |
user_id | Unknown | PKFK |
tags | Unknown |
conversation
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
team_id | Unknown | PK |
user_id | Unknown | PK |
last_message_id | Unknown | FK |
adminrules_can_invite | Unknown | |
adminrules_can_join | Unknown | |
adminrules_can_kick | Unknown | |
adminrules_can_leave | Unknown | |
adminrules_can_view_history | Unknown | |
can_thread_in | Unknown | |
creation_date | Unknown | |
favorite | Unknown | |
is_archived | Unknown | |
is_commented_by | Unknown | |
is_mms_write | Unknown | |
is_sms_write | Unknown | |
name | Unknown | |
purpose | Unknown | |
total_messages_count | Unknown | |
type | Unknown | |
unread_comment | Unknown | |
unread_messages_count | Unknown | |
update_date | Unknown | |
user_list | Json |
number
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
conference_id | Unknown | FK |
ivr_id | Unknown | FK |
user_id | Unknown | FK |
format_country | Unknown | |
format_country_code | Unknown | |
format_e_164_format | Unknown | |
format_international | Unknown | |
format_international_alt | Unknown | |
format_is_short_code | Unknown | |
format_national | Unknown | |
format_national_alt | Unknown | |
format_raw | Unknown | |
format_rfc_3966_format | Unknown | |
is_callable | Unknown | |
is_sms | Unknown | |
is_sms_write | Unknown | |
label | Unknown | |
type | Unknown |
user_snooze_log_list
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
team_id | Unknown | PKFK |
user_id | Unknown | PKFK |
comment | Unknown | |
creation_date | Unknown | |
end_date | Unknown | |
label | Unknown | |
label_en | Unknown | |
label_es | Unknown | |
label_fr | Unknown | |
name | Unknown | |
state | Unknown |
user_snooze_log
| Column | Type | Keys |
|---|---|---|
team_id | Unknown | PKFK |
user_id | Unknown | PKFK |
transcription
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
call_id | Unknown | FK |
team_id | Unknown | FK |
user_id | Unknown | FK |
creation_date | Unknown | |
provider | Unknown | |
standard_id | Unknown | |
transcription_cdn_path | Unknown | |
transcription_status | Unknown |
conversation_message_list
| Column | Type | Keys |
|---|---|---|
message_id | Unknown | PK |
conversation_id | Unknown | PKFK |
conference_id | Unknown | FK |
contact_id | Unknown | FK |
conversation_user_id | Unknown | FK |
number_raw | Unknown | FK |
team_id | Unknown | FK |
user_id | Unknown | FK |
archive_date | Unknown | |
buffer | Unknown | |
creation_date | Unknown | |
direction | Unknown | |
is_archived | Unknown | |
is_failed | Unknown | |
mdr_uuid | Unknown | |
nb_fragment | Unknown | |
thread_buffer_section | Unknown | |
thread_conversation_id_linked | Unknown | |
thread_conversation_sms_id_linked | Unknown | |
thread_nb_response | Unknown | |
thread_thread_uuid | Unknown | |
total_plan | Unknown | |
total_price | Unknown | |
update_date | Unknown |
conversation_message
| Column | Type | Keys |
|---|---|---|
conversation_id | Unknown | PKFK |
team_id | Unknown | PKFK |
user_id | Unknown | PKFK |
creation_date | Unknown | |
is_archived | Unknown | |
is_sms_write | Unknown | |
name | Unknown | |
purpose | Unknown | |
type | Unknown | |
unread_messages_count | Unknown | |
update_date | Unknown |
user_planning_time_range
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
user_id | Unknown | PKFK |
day | Unknown | |
ends | Unknown | |
start | Unknown |
user_planning
| Column | Type | Keys |
|---|---|---|
user_id | Unknown | PKFK |
team_id | Unknown | FK |
is_planning | Unknown | |
is_snooze | Unknown | |
planning_enable | Unknown | |
tz_identifier | Unknown | |
tz_now | Unknown |
blacklist
| Column | Type | Keys |
|---|---|---|
number | Unknown | PKFK |
team_id | Unknown | PKFK |
user_id | Unknown | PKFK |
comment | Unknown | |
direction | Unknown |
team_number
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
team_id | Unknown | PKFK |
team_ivr
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
team_id | Unknown | PKFK |
team_tag
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
team_id | Unknown | PKFK |
team_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
team_id | Unknown | PKFK |
team_conference
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
team_id | Unknown | PKFK |
name | Unknown |
team
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown |
users
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
team_id | Unknown | FK |
color | Unknown | |
company | Unknown | |
concat_name | Unknown | |
email | Unknown | |
first_name | Unknown | |
initial | Unknown | |
last_name | Unknown | |
picture | Unknown |
contact_number
| Column | Type | Keys |
|---|---|---|
contact_id | Unknown | PKFK |
id | Unknown | PKFK |
team_id | Unknown | PKFK |
user_id | Unknown | PKFK |
team_id | Unknown | FK |
user_id | Unknown | FK |
contact
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
team_id | Unknown | PK |
user_id | Unknown | PK |
team_id | Unknown | FK |
user_id | Unknown | FK |
color | Unknown | |
company | Unknown | |
concat_name | Unknown | |
creation_date | Unknown | |
first_name | Unknown | |
im_owner | Unknown | |
initial | Unknown | |
is_shared | Unknown | |
last_name | Unknown | |
profile_picture | Unknown | |
social_data | Unknown | |
social_profile_url | Unknown | |
social_service | Unknown | |
social_service_id | Unknown |
tags
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
color | Unknown | |
creation_date | Unknown | |
description | Unknown | |
name | Unknown |