hellodb.io
MODELS · 7
/
13 refs · 49 fields
organization
6
PK
_id
objectid
name
varchar
subdomain
varchar
plan
enum
business_hours
object
created_at
timestamp
{ }
business_hours
object
timezone
varchar
opens_at
varchar
closes_at
varchar
workdays
varchar[]
customer
6
PK
_id
objectid
FK
organization_id
objectid
email
varchar
full_name
varchar
profile
object
created_at
timestamp
{ }
profile
object
phone
varchar
company
varchar
timezone
varchar
locale
varchar
team
4
PK
_id
objectid
FK
organization_id
objectid
name
varchar
inbox_email
varchar
sla_policy
7
PK
_id
objectid
FK
organization_id
objectid
name
varchar
priority
enum
version
int
is_active
boolean
targets
object
{ }
targets
object
first_response_mins
int
next_response_mins
int
resolution_mins
int
business_hours_only
boolean
agent
7
PK
_id
objectid
FK
organization_id
objectid
FK
team_id
objectid
email
varchar
display_name
varchar
role
enum
is_available
boolean
macro
5
PK
_id
objectid
FK
organization_id
objectid
title
varchar
body
text
actions
object[]
{ }
actions
object[]
field
varchar
operation
enum
value
varchar
ticket
14
PK
_id
objectid
FK
organization_id
objectid
FK
customer_id
objectid
FK
team_id
objectid?
FK
assignee_id
objectid?
subject
varchar
status
enum
priority
enum
channel
enum
tags
varchar[]
sla
object
messages
object[]
opened_at
timestamp
solved_at
timestamp?
{ }
sla
object
policy_id
objectid
policy_name
varchar
policy_version
int
first_response_mins
int
resolution_mins
int
respond_by
timestamp
resolve_by
timestamp
is_breached
boolean
{ }
messages
object[]
seq
int
author_type
enum
author_agent_id
objectid?
author_name
varchar
body
text
is_public
boolean
macro_id
objectid?
sent_at
timestamp
{}
attachments
object[]
{ }
attachments
object[]
filename
varchar
url
varchar
bytes
bigint
110%
Opening Support Desk