Monday.com

Explore the interactive ERD

Table & Field Reference

workspace_owner_subscriber

Column	Type	Keys
`user_id`	Long	PKFK
`workspace_id`	Long	PKFK

workspace_user_subscriber

Column	Type	Keys
`user_id`	Long	PKFK
`workspace_id`	Long	PKFK

workspace_team_subscriber

Column	Type	Keys
`team_id`	Long	PKFK
`workspace_id`	Long	PKFK

workspace

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`description`	String
`kind`	String
`name`	String
`state`	String

asset

Column	Type	Keys
`id`	String	PK
`updates_id`	String	PKFK
`uploaded_by_id`	Long	FK
`created_at`	Instant
`file_extension`	String
`file_size`	Long
`name`	String
`public_url`	String
`url`	String
`url_thumbnail`	String

reply

Column	Type	Keys
`id`	String	PK
`update_id`	String	PKFK
`creator_id`	String	FK
`body`	String
`created_at`	Unknown
`text_body`	String
`updated_at`	Instant

updates

Column	Type	Keys
`id`	String	PK
`creator_id`	String	FK
`item_id`	String	FK
`body`	String
`created_at`	Instant
`text_body`	String
`updated_at`	Instant

activity_log

Column	Type	Keys
`id`	String	PK
`board_id`	String	PKFK
`user_id`	String	FK
`account_id`	String
`created_at`	String
`data`	String
`entity`	String
`event`	String

column_value_tag

Column	Type	Keys
`board_id`	String	PKFK
`column_value_id`	String	PKFK
`id`	Unknown	PKFK
`item_id`	String	PKFK

column_value_item_id

Column	Type	Keys
`board_id`	String	PKFK
`column_value_id`	String	PKFK
`id`	Unknown	PKFK
`item_id`	String	PKFK

column_value_mirror_item

Column	Type	Keys
`board_id`	String	PKFK
`column_value_id`	String	PKFK
`id`	Unknown	PKFK
`item_id`	String	PKFK

time_tracking_history

Column	Type	Keys
`id`	Unknown	PK
`board_id`	String	PKFK
`column_value_id`	String	PKFK
`item_id`	String	PKFK
`ended_user_id`	Unknown	FK
`started_user_id`	Unknown	FK
`created_at`	Unknown
`ended_at`	Unknown
`manually_entered_end_date`	Unknown
`manually_entered_end_time`	Unknown
`manually_entered_start_date`	Unknown
`manually_entered_start_time`	Unknown
`started_at`	Unknown
`status`	Unknown
`updated_at`	Unknown

person_team

Column	Type	Keys
`id`	Unknown	PK
`board_id`	String	PKFK
`column_value_id`	String	PKFK
`item_id`	String	PKFK
`kind`	Unknown

column_value

Column	Type	Keys
`id`	String	PK
`board_id`	String	PKFK
`item_id`	String	PKFK
`checked`	Unknown
`date`	Unknown
`direction`	Unknown
`display_value`	Unknown
`duration`	Unknown
`from_date`	Unknown
`hour`	Unknown
`icon`	Unknown
`index`	Unknown
`is_done`	Unknown
`label`	Unknown
`label_style_border`	Unknown
`label_style_color`	Unknown
`minute`	Unknown
`number`	Unknown
`rating`	Unknown
`running`	Unknown
`started_at`	Unknown
`symbol`	Unknown
`text`	String
`time`	Unknown
`to_date`	Unknown
`update_id`	Unknown
`updated_at`	Unknown
`value`	String
`visualization_type`	Unknown

item_subscriber

Column	Type	Keys
`board_id`	String	PKFK
`id`	Long	PKFK
`item_id`	String	PKFK

item

Column	Type	Keys
`id`	String	PK
`board_id`	String	PKFK
`creator_id`	String	FK
`group_id`	String	FK
`parent_item_id`	String	FK
`created_at`	Instant
`email`	String
`name`	String
`state`	String
`updated_at`	Instant

team_user

Column	Type	Keys
`team_id`	Long	PKFK
`user_id`	Long	PKFK

team

Column	Type	Keys
`id`	Long	PK
`name`	String
`picture_url`	String

users

Column	Type	Keys
`id`	Long	PK
`account_id`	Long
`birthday`	String
`country_code`	String
`created_at`	Instant
`current_language`	String
`email`	String
`enabled`	Boolean
`encrypt_api_token`	String
`is_admin`	Boolean
`is_guest`	Boolean
`is_pending`	Boolean
`is_verified`	Boolean
`is_view_only`	Boolean
`join_date`	Unknown
`location`	String
`mobile_phone`	String
`name`	String
`phone`	String
`photo_original`	String
`photo_small`	String
`photo_thumb`	String
`photo_thumb_small`	String
`photo_tiny`	String
`time_zone_identifier`	String
`title`	String
`url`	String
`utc_hours_diff`	Long

board_view

Column	Type	Keys
`id`	String	PK
`board_id`	String	FK
`name`	String
`settings_str`	String
`type`	String

columns

Column	Type	Keys
`board_id`	String	PKFK
`id`	String	PKFK
`archived`	Boolean
`description`	String
`settings_str`	String
`title`	String
`type`	String
`width`	Long

groups

Column	Type	Keys
`id`	String	PK
`board_id`	String	PKFK
`archived`	String
`color`	String
`deleted`	Boolean
`position`	String
`title`	String

board_owner

Column	Type	Keys
`board_id`	String	PKFK
`user_id`	Long	PKFK

board_subscriber

Column	Type	Keys
`board_id`	String	PKFK
`user_id`	Long	PKFK

board_tag

Column	Type	Keys
`board_id`	String	PKFK
`tag_id`	Long	PKFK

board_update

Column	Type	Keys
`board_id`	String	PKFK
`id`	String	PKFK

board

Column	Type	Keys
`id`	String	PK
`owner_id`	Long	FK
`top_group_id`	String	FK
`workspace_id`	Long	FK
`board_folder_id`	String
`board_kind`	String
`description`	String
`hierarchy_type`	String
`name`	String
`permission`	String
`state`	String
`type`	String
`updated_at`	Instant

Monday.com

Explore the interactive ERD

Table & Field Reference

workspace_owner_subscriber

workspace_user_subscriber

workspace_team_subscriber

workspace

asset

reply

updates

activity_log

column_value_tag

column_value_item_id

column_value_mirror_item

time_tracking_history

person_team

column_value

item_subscriber

item

team_user

team

users

tags

board_view

columns

groups

board_owner

board_subscriber

board_tag

board_update

board