hellodb.io
MODELS · 26
/
62 refs · 199 fields
workspace
9
PK
id
uuid
FK
owner_user_id
uuid
name
varchar
domain
varchar
plan
enum
icon_url
text
member_count
int
created_at
timestamp
deleted_at
timestamp?
user
9
PK
id
uuid
email
varchar
display_name
varchar
real_name
varchar
avatar_url
text
timezone
varchar
presence
enum
created_at
timestamp
deactivated_at
timestamp?
workspace_member
7
PK
id
uuid
FK
workspace_id
uuid
FK
user_id
uuid
role
enum
title
varchar?
status
enum
joined_at
timestamp
user_group
9
PK
id
uuid
FK
workspace_id
uuid
FK
created_by_user_id
uuid
handle
varchar
name
varchar
description
text
is_default_for_new_members
boolean
created_at
timestamp
deleted_at
timestamp?
user_group_member
5
PK
id
uuid
FK
user_group_id
uuid
FK
user_id
uuid
FK
added_by_user_id
uuid
added_at
timestamp
channel
10
PK
id
uuid
FK
workspace_id
uuid
FK
created_by_user_id
uuid
name
varchar
topic
text
purpose
text
visibility
enum
is_archived
boolean
member_count
int
created_at
timestamp
channel_member
8
PK
id
uuid
FK
channel_id
uuid
FK
user_id
uuid
FK
last_read_message_id
uuid?
role
enum
notification_preference
enum
is_muted
boolean
joined_at
timestamp
dm_conversation
7
PK
id
uuid
FK
workspace_id
uuid
kind
enum
participant_count
int
is_archived
boolean
last_message_at
timestamp?
created_at
timestamp
dm_participant
6
PK
id
uuid
FK
dm_conversation_id
uuid
FK
user_id
uuid
is_muted
boolean
last_read_at
timestamp?
joined_at
timestamp
message
10
PK
id
uuid
FK
channel_id
uuid?
FK
dm_conversation_id
uuid?
FK
parent_message_id
uuid?
FK
user_id
uuid?
FK
bot_id
uuid?
text
text
blocks
jsonb
edited_at
timestamp?
posted_at
timestamp
thread
7
PK
id
uuid
FK
root_message_id
uuid
FK
channel_id
uuid
reply_count
int
participant_count
int
is_broadcast
boolean
last_reply_at
timestamp?
reaction
6
PK
id
uuid
FK
message_id
uuid
FK
user_id
uuid
FK
custom_emoji_id
uuid?
emoji_name
varchar
reacted_at
timestamp
mention
7
PK
id
uuid
FK
message_id
uuid
FK
mentioned_user_id
uuid?
FK
user_group_id
uuid?
kind
enum
is_read
boolean
created_at
timestamp
pin
5
PK
id
uuid
FK
channel_id
uuid
FK
message_id
uuid
FK
pinned_by_user_id
uuid
created_at
timestamp
file
10
PK
id
uuid
FK
workspace_id
uuid
FK
uploaded_by_user_id
uuid
name
varchar
mimetype
varchar
size_bytes
bigint
storage_url
text
is_external
boolean
created_at
timestamp
deleted_at
timestamp?
file_share
7
PK
id
uuid
FK
file_id
uuid
FK
channel_id
uuid?
FK
dm_conversation_id
uuid?
FK
message_id
uuid?
FK
shared_by_user_id
uuid
shared_at
timestamp
app
7
PK
id
uuid
name
varchar
developer_name
varchar
description
text
requested_scopes
jsonb
is_directory_listed
boolean
created_at
timestamp
app_installation
8
PK
id
uuid
FK
app_id
uuid
FK
workspace_id
uuid
FK
installed_by_user_id
uuid
FK
bot_id
uuid?
granted_scopes
jsonb
status
enum
installed_at
timestamp
bot
7
PK
id
uuid
FK
app_id
uuid?
FK
workspace_id
uuid
display_name
varchar
icon_url
text
is_workflow_bot
boolean
created_at
timestamp
slash_command
7
PK
id
uuid
FK
app_installation_id
uuid
command
varchar
description
text
request_url
text
usage_hint
varchar?
is_enabled
boolean
webhook
8
PK
id
uuid
FK
app_installation_id
uuid
FK
channel_id
uuid?
target_url
text
secret_hash
varchar
event_types
jsonb
is_active
boolean
last_delivery_at
timestamp?
workflow
9
PK
id
uuid
FK
workspace_id
uuid
FK
created_by_user_id
uuid
FK
channel_id
uuid?
name
varchar
trigger_type
enum
definition
jsonb
is_published
boolean
run_count
int
saved_item
7
PK
id
uuid
FK
user_id
uuid
FK
message_id
uuid?
FK
file_id
uuid?
state
enum
due_at
timestamp?
saved_at
timestamp
reminder
8
PK
id
uuid
FK
user_id
uuid
FK
created_by_user_id
uuid
FK
message_id
uuid?
text
text
recurrence
enum
status
enum
remind_at
timestamp
custom_emoji
7
PK
id
uuid
FK
workspace_id
uuid
FK
created_by_user_id
uuid
FK
alias_for_emoji_id
uuid?
name
varchar
image_url
text
created_at
timestamp
audit_log_entry
9
PK
id
uuid
FK
workspace_id
uuid
FK
actor_user_id
uuid?
action
varchar
entity_type
enum
entity_id
uuid
context
jsonb
ip_address
varchar
occurred_at
timestamp
110%
Opening Slack