hellodb.io
MODELS · 25
/
85 refs · 208 fields
workspace
8
PK
_id
objectid
FK
owner_user_id
objectid
name
varchar
domain
varchar?
plan
enum
settings
object
created_at
timestamp
deleted_at
timestamp?
{ }
settings
object
default_member_role
enum
allowed_email_domains
varchar[]
is_public_sharing_enabled
boolean
is_export_enabled
boolean
trash_retention_days
int
user
9
PK
_id
objectid
FK
bot_owner_user_id
objectid?
email
varchar
name
varchar
avatar_url
varchar?
type
enum
preferences
object
created_at
timestamp
last_seen_at
timestamp?
{ }
preferences
object
theme
enum
locale
varchar
timezone
varchar
start_week_on_monday
boolean
{}
notifications
object
{ }
notifications
object
email_digest
boolean
mobile_push
boolean
mention_emails
boolean
digest_frequency
enum
workspace_member
7
PK
_id
objectid
FK
workspace_id
objectid
FK
user_id
objectid
FK
invited_by_user_id
objectid?
role
enum
status
enum
joined_at
timestamp?
teamspace
8
PK
_id
objectid
FK
workspace_id
objectid
FK
parent_teamspace_id
objectid?
FK
created_by_user_id
objectid
name
varchar
access
enum
icon
varchar?
created_at
timestamp
invitation
9
PK
_id
objectid
FK
workspace_id
objectid
FK
invited_by_user_id
objectid
FK
teamspace_id
objectid?
email
varchar
role
enum
token_hash
varchar
status
enum
expires_at
timestamp
page
10
PK
_id
objectid
FK
workspace_id
objectid
FK
teamspace_id
objectid?
FK
parent_page_id
objectid?
FK
database_id
objectid?
FK
created_by_user_id
objectid
FK
last_edited_by_user_id
objectid
properties
object
created_at
timestamp
deleted_at
timestamp?
{ }
properties
object
title
varchar
{}
icon
object
cover_url
varchar?
is_locked
boolean
is_full_width
boolean
word_count
int
{ }
icon
object
type
enum
emoji
varchar?
external_url
varchar?
file_id
objectid?
block
10
PK
_id
objectid
FK
page_id
objectid
FK
parent_block_id
objectid?
FK
created_by_user_id
objectid
type
enum
rich_text
object[]
position
decimal
has_children
boolean
created_at
timestamp
archived_at
timestamp?
{ }
rich_text
object[]
type
enum
plain_text
text
href
varchar?
mention_user_id
objectid?
mention_page_id
objectid?
{}
annotations
object
{ }
annotations
object
bold
boolean
italic
boolean
strikethrough
boolean
underline
boolean
code
boolean
color
enum
page_version
7
PK
_id
objectid
FK
page_id
objectid
FK
edited_by_user_id
objectid
version_number
int
snapshot
object
change_summary
varchar?
created_at
timestamp
{ }
snapshot
object
title
varchar
block_count
int
content_hash
varchar
byte_size
bigint
storage_key
varchar
template
9
PK
_id
objectid
FK
workspace_id
objectid
FK
source_page_id
objectid
FK
created_by_user_id
objectid
name
varchar
category
enum
usage_count
int
is_published
boolean
created_at
timestamp
favourite
6
PK
_id
objectid
FK
user_id
objectid
FK
page_id
objectid?
FK
database_id
objectid?
position
decimal
created_at
timestamp
trash_item
7
PK
_id
objectid
FK
workspace_id
objectid
FK
page_id
objectid?
FK
database_id
objectid?
FK
deleted_by_user_id
objectid
purge_after
timestamp
deleted_at
timestamp
database
9
PK
_id
objectid
FK
workspace_id
objectid
FK
parent_page_id
objectid?
FK
created_by_user_id
objectid
title
varchar
description
text?
is_inline
boolean
created_at
timestamp
deleted_at
timestamp?
database_schema
7
PK
_id
objectid
FK
database_id
objectid
FK
updated_by_user_id
objectid
version
int
properties
object[]
is_current
boolean
created_at
timestamp
{ }
properties
object[]
property_id
varchar
name
varchar
type
enum
is_visible
boolean
{}
config
object
{ }
config
object
{}
options
object[]
number_format
enum?
formula_expression
text?
relation_database_id
objectid?
rollup_property_id
varchar?
{ }
options
object[]
option_id
varchar
name
varchar
color
enum
database_row
9
PK
_id
objectid
FK
database_id
objectid
FK
page_id
objectid
FK
database_schema_id
objectid
FK
created_by_user_id
objectid
values
object[]
created_at
timestamp
updated_at
timestamp
deleted_at
timestamp?
{ }
values
object[]
property_id
varchar
value_type
enum
text_value
text?
number_value
decimal?
date_value
timestamp?
checkbox_value
boolean?
option_ids
varchar[]
person_user_id
objectid?
file_id
objectid?
related_row_id
objectid?
view
9
PK
_id
objectid
FK
database_id
objectid
FK
created_by_user_id
objectid
name
varchar
type
enum
filter
object
sorts
object[]
group_by_property_id
varchar?
created_at
timestamp
{ }
filter
object
operator
enum
{}
conditions
object[]
{ }
conditions
object[]
property_id
varchar
comparator
enum
text_value
varchar?
number_value
decimal?
checkbox_value
boolean?
{ }
sorts
object[]
property_id
varchar
direction
enum
position
int
database_relation
7
PK
_id
objectid
FK
source_database_id
objectid
FK
target_database_id
objectid
source_property_id
varchar
synced_property_name
varchar?
is_dual
boolean
created_at
timestamp
discussion
8
PK
_id
objectid
FK
page_id
objectid
FK
block_id
objectid?
FK
created_by_user_id
objectid
FK
resolved_by_user_id
objectid?
anchor_text
varchar?
is_resolved
boolean
created_at
timestamp
comment
8
PK
_id
objectid
FK
discussion_id
objectid
FK
author_user_id
objectid
FK
parent_comment_id
objectid?
rich_text
object[]
created_at
timestamp
edited_at
timestamp?
deleted_at
timestamp?
{ }
rich_text
object[]
type
enum
plain_text
text
href
varchar?
{}
annotations
object
{ }
annotations
object
bold
boolean
italic
boolean
code
boolean
color
enum
mention
7
PK
_id
objectid
FK
source_block_id
objectid?
FK
source_comment_id
objectid?
FK
mentioned_user_id
objectid?
FK
mentioned_page_id
objectid?
type
enum
created_at
timestamp
notification
8
PK
_id
objectid
FK
recipient_user_id
objectid
FK
workspace_id
objectid
FK
mention_id
objectid?
FK
page_id
objectid?
type
enum
is_read
boolean
created_at
timestamp
permission
10
PK
_id
objectid
FK
workspace_id
objectid
FK
page_id
objectid?
FK
database_id
objectid?
FK
teamspace_id
objectid?
FK
user_id
objectid?
FK
granted_by_user_id
objectid
level
enum
is_inherited
boolean
created_at
timestamp
integration
9
PK
_id
objectid
FK
workspace_id
objectid
FK
owner_user_id
objectid
name
varchar
type
enum
capabilities
varchar[]
redirect_uris
varchar[]
is_approved
boolean
created_at
timestamp
api_token
9
PK
_id
objectid
FK
workspace_id
objectid
FK
integration_id
objectid
FK
created_by_user_id
objectid
token_hash
varchar
scopes
varchar[]
last_used_at
timestamp?
expires_at
timestamp?
revoked_at
timestamp?
audit_log
8
PK
_id
objectid
FK
workspace_id
objectid
FK
actor_user_id
objectid?
FK
api_token_id
objectid?
FK
target_page_id
objectid?
action
enum
context
object
created_at
timestamp
{ }
context
object
ip_address
varchar
user_agent
varchar
surface
enum
{}
location
object
{ }
location
object
country
varchar
region
varchar?
city
varchar?
file
10
PK
_id
objectid
FK
workspace_id
objectid
FK
uploaded_by_user_id
objectid
FK
block_id
objectid?
name
varchar
mime_type
varchar
size_bytes
bigint
storage_key
varchar
url_expires_at
timestamp?
created_at
timestamp
74%
Opening Notion