Productboard

Explore the interactive ERD

Table & Field Reference

member_activity

Column	Type	Keys
`date`	Unknown	PK
`member_id`	String	PKFK
`active_flag`	Unknown
`board_created_count`	Unknown
`board_opened_count`	Unknown
`column_board_created_count`	Unknown
`column_board_opened_count`	Unknown
`component_created_count`	Unknown
`document_board_created_count`	Unknown
`document_board_opened_count`	Unknown
`feature_created_count`	Unknown
`grid_board_created_count`	Unknown
`grid_board_opened_count`	Unknown
`insight_created_count`	Unknown
`insights_board_created_count`	Unknown
`insights_board_opened_count`	Unknown
`note_created_count`	Unknown
`note_state_changed_count`	Unknown
`product_created_count`	Unknown
`subfeature_created_count`	Unknown
`timeline_board_created_count`	Unknown
`timeline_board_opened_count`	Unknown

plugin_integration

Column	Type	Keys
`id`	String	PK
`created_at`	Unknown
`initial_state_label`	String
`integration_status`	String
`name`	String
`type`	String

release_relationship

Column	Type	Keys
`release_id`	String	PKFK
`target_id`	String	PKFK
`target_type`	String
`type`	String

release_custom_field

Column	Type	Keys
`id`	Unknown	PK
`release_id`	String	PKFK
`value`	Json

release

Column	Type	Keys
`id`	String	PK
`archived`	Unknown
`created_at`	Unknown
`description`	String
`end_date`	Unknown
`granularity`	Unknown
`name`	String
`owner_id`	String
`owner_name`	String
`start_date`	Unknown
`state`	String
`status_id`	String
`updated_at`	Unknown
`work_progress_id`	String
`work_progress_name`	String

jira_integration_connection

Column	Type	Keys
`id`	String	PK
`jira_integration_id`	String	PKFK
`issue_id`	String
`issue_key`	String

conversation_note_relationship

Column	Type	Keys
`conversation_note_id`	Unknown	PKFK
`target_id`	String	PKFK
`target_type`	String
`type`	String

conversation_note_content

Column	Type	Keys
`index`	Unknown	PK
`conversation_note_id`	Unknown	PKFK
`author_name`	String
`author_type`	String
`content`	String
`external_id`	String
`id`	String
`time_stamp`	Unknown

conversation_note_tag

Column	Type	Keys
`index`	Unknown	PK
`conversation_note_id`	Unknown	PKFK
`name`	Unknown

conversation_note

Column	Type	Keys
`id`	Unknown	PK
`archived`	Unknown
`created_at`	Unknown
`created_by_email`	Unknown
`created_by_id`	Unknown
`html`	Unknown
`metadata_source_record_id`	Unknown
`metadata_source_system`	Unknown
`metadata_source_url`	Unknown
`name`	Unknown
`owner_email`	String
`owner_id`	String
`processed`	Unknown
`updated_at`	Unknown

release_group_relationship

Column	Type	Keys
`release_group_id`	String	PKFK
`target_id`	String	PKFK
`target_type`	String
`type`	String

release_group_custom_field

Column	Type	Keys
`id`	Unknown	PK
`release_group_id`	String	PKFK
`value`	Json

release_group

Column	Type	Keys
`id`	String	PK
`archived`	Unknown
`created_at`	Unknown
`description`	String
`name`	String
`updated_at`	Unknown

objective_relationship

Column	Type	Keys
`objective_id`	String	PKFK
`target_id`	String	PKFK
`target_type`	String
`type`	String

objective_custom_field

Column	Type	Keys
`id`	Unknown	PK
`objective_id`	String	PKFK
`value`	Json

objective

Column	Type	Keys
`id`	String	PK
`archived`	Unknown
`created_at`	Unknown
`description`	String
`effort`	Unknown
`end_date`	Unknown
`granularity`	String
`health_comment`	String
`health_created_by_email`	String
`health_created_by_id`	String
`health_id`	String
`health_last_updated_at`	Unknown
`health_mode`	String
`health_previous_status`	String
`health_status`	String
`html`	String
`name`	String
`owner_email`	String
`owner_id`	String
`start_date`	Unknown
`state`	String
`status_id`	String
`updated_at`	Unknown
`work_progress_mode`	String
`work_progress_value`	Unknown

feature_relationship

Column	Type	Keys
`feature_id`	String	PKFK
`target_id`	String	PKFK
`target_type`	String
`type`	String

feature_tag

Column	Type	Keys
`index`	Unknown	PK
`feature_id`	String	PKFK
`name`	Unknown

feature_team

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

feature_custom_field

Column	Type	Keys
`id`	Unknown	PK
`feature_id`	String	PKFK
`value`	Json

feature

Column	Type	Keys
`id`	String	PK
`archived`	Unknown
`created_at`	Unknown
`description`	String
`effort`	Unknown
`end_date`	Unknown
`granularity`	String
`health_comment`	String
`health_created_by_email`	String
`health_created_by_id`	String
`health_id`	String
`health_last_updated_at`	Unknown
`health_mode`	String
`health_previous_status`	String
`health_status`	String
`html`	String
`name`	String
`owner_email`	String
`owner_id`	String
`start_date`	Unknown
`status`	String
`status_id`	String
`updated_at`	Unknown
`work_progress_mode`	String
`work_progress_value`	Unknown

company_custom_field

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	PKFK
`value`	Json

company

Column	Type	Keys
`id`	Unknown	PK
`archived`	Unknown
`created_at`	Unknown
`description`	Unknown
`domain`	Unknown
`html`	String
`name`	Unknown
`owner_email`	String
`owner_id`	String
`updated_at`	Unknown

plugin_integration_connection

Column	Type	Keys
`id`	String	PK
`plugin_integration_id`	String	PKFK
`fields_connection_color`	String
`fields_connection_hover_label`	String
`fields_connection_label`	String
`fields_connection_state`	String
`fields_connection_target_url`	String
`fields_connection_tooltip`	String

text_note_relationship

Column	Type	Keys
`target_id`	String	PKFK
`text_note_id`	Unknown	PKFK
`target_type`	String
`type`	String

text_note_tag

Column	Type	Keys
`index`	Unknown	PK
`text_note_id`	Unknown	PKFK
`name`	Unknown

text_note

Column	Type	Keys
`id`	Unknown	PK
`archived`	Unknown
`content`	Unknown
`created_at`	Unknown
`created_by_email`	Unknown
`created_by_id`	Unknown
`html`	Unknown
`metadata_source_record_id`	Unknown
`metadata_source_system`	Unknown
`metadata_source_url`	Unknown
`name`	Unknown
`owner_email`	String
`owner_id`	String
`processed`	Unknown
`updated_at`	Unknown

product_relationship

Column	Type	Keys
`product_id`	String	PKFK
`target_id`	String	PKFK
`target_type`	String
`type`	String

product_tag

Column	Type	Keys
`index`	Unknown	PK
`product_id`	String	PKFK
`name`	Unknown

product_team

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

product_custom_field

Column	Type	Keys
`id`	Unknown	PK
`product_id`	String	PKFK
`value`	Json

product

Column	Type	Keys
`id`	String	PK
`created_at`	Unknown
`description`	String
`effort`	Unknown
`html`	String
`name`	String
`owner_email`	String
`owner_id`	String
`updated_at`	Unknown

jira_integration

Column	Type	Keys
`id`	String	PK
`created_at`	Unknown
`integration_status`	String
`name`	String

team

Column	Type	Keys
`id`	String	PK
`avatar_url`	String
`created_at`	Unknown
`description`	String
`handle`	String
`name`	String
`updated_at`	Unknown

users_team

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

users

Column	Type	Keys
`id`	String	PK
`created_at`	Unknown
`disabled`	Unknown
`email`	String
`invitation_pending`	Unknown
`name`	String
`role`	String
`updated_at`	Unknown
`username`	String

component_relationship

Column	Type	Keys
`component_id`	String	PKFK
`target_id`	String	PKFK
`target_type`	String
`type`	String

component_tag

Column	Type	Keys
`index`	Unknown	PK
`component_id`	String	PKFK
`name`	Unknown

component_custom_field

Column	Type	Keys
`id`	Unknown	PK
`component_id`	String	PKFK
`value`	Json

component

Column	Type	Keys
`id`	String	PK
`archived`	Unknown
`created_at`	Unknown
`description`	String
`html`	String
`name`	String
`owner_email`	Unknown
`owner_id`	String
`updated_at`	Unknown

opportunity_note_relationship

Column	Type	Keys
`opportunity_note_id`	Unknown	PKFK
`target_id`	String	PKFK
`target_type`	String
`type`	String

opportunity_note_tag

Column	Type	Keys
`index`	Unknown	PK
`opportunity_note_id`	Unknown	PKFK
`name`	Unknown

opportunity_note

Column	Type	Keys
`id`	Unknown	PK
`archived`	Unknown
`created_at`	Unknown
`created_by_email`	Unknown
`created_by_id`	Unknown
`html`	Unknown
`metadata_source_record_id`	Unknown
`metadata_source_system`	Unknown
`metadata_source_url`	Unknown
`name`	Unknown
`owner_email`	String
`owner_id`	String
`processed`	Unknown
`updated_at`	Unknown