Fivetran documentation

Search the docs

/

Notion

Explore the interactive ERD

Table & Field Reference

block

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`last_edited_by`	String	FK
`page_id`	String	FK
`parent_id`	String	FK
`created_time`	Instant
`depth`	Int
`has_children`	Boolean
`in_trash`	Boolean
`last_edited_time`	Instant
`ordinal`	Int
`parent_type`	String
`payload_raw`	Json
`plain_text`	String
`type`	String

page_comment

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`page_id`	String	FK
`created_time`	Instant
`discussion_id`	String
`last_edited_time`	Instant

database_data_source

Column	Type	Keys
`database_id`	String	PKFK
`id`	String	PKFK
`name`	String

database_title

Column	Type	Keys
`index`	Unknown	PK
`database_id`	String	PKFK
`annotations_bold`	Boolean
`annotations_code`	Boolean
`annotations_color`	String
`annotations_italic`	Boolean
`annotations_strikethrough`	Boolean
`annotations_underline`	Boolean
`equation_expression`	String
`href`	String
`mention`	Json
`plain_text`	String
`text_content`	String
`text_link_url`	String
`type`	String

database

Column	Type	Keys
`id`	String	PK
`data_source_id`	String	PKFK
`created_by`	String	FK
`last_edited_by`	String	FK
`parent_block_id`	String	FK
`parent_database_id`	String	FK
`parent_page_id`	String	FK
`cover`	Json
`created_time`	Instant
`description`	Json
`icon`	Json
`in_trash`	Boolean
`is_inline`	Boolean
`is_locked`	Boolean
`last_edited_time`	Instant
`object`	String
`parent_type`	String
`public_url`	String
`url`	String
`workspace`	Boolean

block_comment

Column	Type	Keys
`id`	String	PK
`block_id`	String	PKFK
`created_by`	String	FK
`page_id`	String	FK
`created_time`	Instant
`discussion_id`	String
`last_edited_time`	Instant

users

Column	Type	Keys
`id`	String	PK
`bot_user_id`	String	FK
`avatar_url`	String
`bot_owner_type`	String
`bot_workspace_id`	String
`email`	String
`name`	String
`type`	String

data_source_title

Column	Type	Keys
`index`	Unknown	PK
`data_source_id`	String	PKFK
`annotations_bold`	Boolean
`annotations_code`	Boolean
`annotations_color`	String
`annotations_italic`	Boolean
`annotations_strikethrough`	Boolean
`annotations_underline`	Boolean
`equation_expression`	String
`href`	String
`mention`	Json
`plain_text`	String
`text_content`	String
`text_link_url`	String
`type`	String

data_source_description

Column	Type	Keys
`index`	Unknown	PK
`data_source_id`	String	PKFK
`annotations_bold`	Boolean
`annotations_code`	Boolean
`annotations_color`	String
`annotations_italic`	Boolean
`annotations_strikethrough`	Boolean
`annotations_underline`	Boolean
`equation_expression`	String
`href`	String
`mention`	Json
`plain_text`	String
`text_content`	String
`text_link_url`	String
`type`	String

data_source_property

Column	Type	Keys
`id`	String	PK
`data_source_id`	String	PKFK
`description`	Json
`name`	String
`type`	String
`value`	Json

data_source

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`last_edited_by`	String	FK
`parent_block_id`	String	FK
`parent_database_id`	String	FK
`parent_page_id`	String	FK
`cover`	Json
`created_time`	Instant
`icon`	Json
`in_trash`	Boolean
`is_archived`	Boolean
`is_inline`	Boolean
`last_edited_time`	Instant
`object`	String
`parent_type`	String
`public_url`	String
`url`	String
`workspace`	Boolean

page_property

Column	Type	Keys
`id`	String	PK
`page_id`	String	PKFK
`name`	String
`type`	String
`value`	Json

page

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`last_edited_by`	String	FK
`parent_block_id`	String	FK
`parent_database_id`	String	FK
`parent_page_id`	String	FK
`cover`	Unknown
`created_time`	Instant
`description`	Json
`icon`	Unknown
`in_trash`	Boolean
`is_archived`	Boolean
`is_inline`	Boolean
`is_locked`	Boolean
`last_edited_time`	Instant
`object`	Unknown
`parent_type`	String
`public_url`	String
`url`	String
`workspace`	String
`custom_`