Copper

Explore the interactive ERD

Table & Field Reference

account

Column	Type	Keys
`id`	Unknown	PK
`name`	Unknown
`primary_timezone`	Unknown
`setting_enable_lead`	Unknown
`setting_team_permissions_enabled`	Unknown

custom_field_definition_available_on

Column	Type	Keys
`index`	Unknown	PK
`custom_field_definition_id`	Unknown	PKFK
`available_on`	Unknown

custom_field_definition_option

Column	Type	Keys
`id`	Unknown	PK
`custom_field_definition_id`	Unknown	FK
`name`	Unknown
`rank`	Unknown

custom_field_definition

Column	Type	Keys
`id`	Unknown	PK
`currency`	Unknown
`data_type`	Unknown
`is_filterable`	Unknown
`name`	Unknown

contact_type

Column	Type	Keys
`id`	Unknown	PK
`name`	Unknown

custom_activity_type

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	FK
`icon_type`	Unknown
`is_default_task_type`	Unknown
`is_disabled`	Unknown
`is_interaction`	Unknown
`name`	Unknown

pipeline

Column	Type	Keys
`id`	Unknown	PK
`name`	Unknown

task_tag

Column	Type	Keys
`index`	Unknown	PK
`task_id`	Unknown	PKFK
`tags`	Unknown

task

Column	Type	Keys
`id`	Unknown	PK
`assignee_id`	Unknown	FK
`custom_activity_type_id`	Unknown	FK
`opportunity_id`	Json	FK
`project_id`	Json	FK
`completed_date`	Unknown
`custom_field`	Json
`date_created`	Unknown
`date_modified`	Unknown
`detail`	Unknown
`due_date`	Unknown
`name`	Unknown
`priority`	Unknown
`related_resource_id`	Unknown
`related_resource_type`	Unknown
`reminder_date`	Unknown
`status`	Unknown

pipeline_stage

Column	Type	Keys
`id`	Unknown	PK
`pipeline_id`	Unknown	PKFK
`name`	Unknown
`win_probability`	Unknown

project_tag

Column	Type	Keys
`index`	Unknown	PK
`project_id`	Unknown	PKFK
`tags`	Unknown

project_custom_field

Column	Type	Keys
`custom_field_definition_id`	Unknown	PKFK
`project_id`	Unknown	PKFK
`value`	Json

project

Column	Type	Keys
`id`	Unknown	PK
`assignee_id`	Unknown	FK
`date_created`	Unknown
`date_modified`	Unknown
`detail`	Unknown
`name`	Unknown
`related_resource_id`	Unknown
`related_resource_type`	Unknown
`status`	Unknown

opportunity_loss_reason

Column	Type	Keys
`id`	Unknown	PK
`name`	Unknown

company_phone_number

Column	Type	Keys
`index`	Unknown	PK
`company_id`	Unknown	PKFK
`category`	Unknown
`number`	Unknown

company_social

Column	Type	Keys
`index`	Unknown	PK
`company_id`	Unknown	PKFK
`category`	Unknown
`url`	Unknown

company_website

Column	Type	Keys
`index`	Unknown	PK
`company_id`	Unknown	PKFK
`category`	Unknown
`url`	Unknown

company_tag

Column	Type	Keys
`index`	Unknown	PK
`company_id`	Unknown	PKFK
`tags`	Unknown

company_custom_field

Column	Type	Keys
`company_id`	Unknown	PKFK
`custom_field_definition_id`	Unknown	PKFK
`value`	Unknown

company

Column	Type	Keys
`id`	Unknown	PK
`assignee_id`	Unknown	FK
`contact_type_id`	Unknown	FK
`age`	Unknown
`city`	Unknown
`country`	Unknown
`date_created`	Unknown
`date_modified`	Instant
`detail`	Unknown
`email_domain`	Unknown
`followed`	Unknown
`interaction_count`	Unknown
`name`	Unknown
`postal_code`	Unknown
`state`	Unknown
`street`	Unknown

customer_source

Column	Type	Keys
`id`	Unknown	PK
`name`	Unknown

people_phone_number

Column	Type	Keys
`index`	Unknown	PK
`people_id`	Unknown	PKFK
`category`	Unknown
`number`	Unknown

people_social

Column	Type	Keys
`index`	Unknown	PK
`people_id`	Unknown	PKFK
`category`	Unknown
`url`	Unknown

people_email

Column	Type	Keys
`index`	Unknown	PK
`people_id`	Unknown	PKFK
`category`	Unknown
`email`	Unknown

people_tag

Column	Type	Keys
`index`	Unknown	PK
`people_id`	Unknown	PKFK
`tags`	Unknown

people_website

Column	Type	Keys
`index`	Unknown	PK
`people_id`	Unknown	PKFK
`category`	Unknown
`url`	Unknown

people_custom_field

Column	Type	Keys
`custom_field_definition_id`	Unknown	PKFK
`people_id`	Unknown	PKFK
`value`	Json

people

Column	Type	Keys
`id`	Unknown	PK
`assignee_id`	Unknown	FK
`company_id`	Unknown	FK
`contact_type_id`	Unknown	FK
`opportunity_id`	Json	FK
`city`	Unknown
`company_name`	Unknown
`country`	Unknown
`date_created`	Unknown
`date_last_contacted`	Unknown
`date_lead_created`	Unknown
`date_modified`	Instant
`detail`	Unknown
`first_name`	Unknown
`interaction_count`	Unknown
`last_name`	Unknown
`leads_converted_from`	Json
`middle_name`	Unknown
`name`	Unknown
`postal_code`	Unknown
`prefix`	Unknown
`state`	Unknown
`street`	Unknown
`suffix`	Unknown
`title`	Unknown

users_group

Column	Type	Keys
`id`	Unknown	PK
`users_id`	Unknown	PKFK
`name`	Unknown

users

Column	Type	Keys
`id`	Unknown	PK
`email`	Unknown
`name`	Unknown

opportunity_tag

Column	Type	Keys
`index`	Unknown	PK
`opportunity_id`	Unknown	PKFK
`tags`	Unknown

opportunity_custom_field

Column	Type	Keys
`custom_field_definition_id`	Unknown	PKFK
`opportunity_id`	Unknown	PKFK
`value`	Json

opportunity

Column	Type	Keys
`id`	Unknown	PK
`assignee_id`	Unknown	FK
`company_id`	Unknown	FK
`customer_source_id`	Unknown	FK
`loss_reason_id`	Unknown	FK
`pipeline_id`	Unknown	FK
`pipeline_stage_id`	Unknown	FK
`primary_contact_id`	Unknown	FK
`close_date`	Unknown
`company_name`	Unknown
`converted_unit`	Unknown
`converted_value`	Unknown
`date_created`	Unknown
`date_last_contacted`	Unknown
`date_lead_created`	Unknown
`date_modified`	Unknown
`date_stage_changed`	Unknown
`detail`	Unknown
`interaction_count`	Unknown
`leads_converted_from`	Json
`monetary_unit`	Unknown
`monetary_value`	Unknown
`name`	Unknown
`priority`	Unknown
`status`	Unknown
`win_probability`	Unknown

activity

Column	Type	Keys
`id`	Unknown	PK
`parent_id`	Unknown	FK
`user_id`	Unknown	FK
`activity_date`	Unknown
`date_created`	Unknown
`date_modified`	Unknown
`detail`	Unknown
`new_value`	Unknown
`old_value`	Unknown
`parent_type`	Unknown
`type_category`	Unknown
`type_id`	Unknown

lead_phone_number

Column	Type	Keys
`index`	Unknown	PK
`lead_id`	Unknown	PKFK
`category`	Unknown
`number`	Unknown

lead_social

Column	Type	Keys
`index`	Unknown	PK
`lead_id`	Unknown	PKFK
`category`	Unknown
`url`	Unknown

lead_tag

Column	Type	Keys
`index`	Unknown	PK
`lead_id`	Unknown	PKFK
`tags`	Unknown

lead_website

Column	Type	Keys
`index`	Unknown	PK
`lead_id`	Unknown	PKFK
`category`	Unknown
`url`	Unknown

lead_custom_field

Column	Type	Keys
`custom_field_definition_id`	Unknown	PKFK
`lead_id`	Unknown	PKFK
`value`	Json

lead

Column	Type	Keys
`id`	Unknown	PK
`assignee_id`	Unknown	FK
`company_id`	Unknown	FK
`contact_type_id`	Unknown	FK
`customer_source_id`	Json	FK
`city`	Unknown
`converted_at`	Unknown
`converted_contact_id`	Unknown
`converted_opportunity_id`	Unknown
`country`	Unknown
`date_created`	Unknown
`date_last_contacted`	Unknown
`date_modified`	Unknown
`detail`	Json
`email`	Unknown
`email_category`	Unknown
`first_name`	Unknown
`interaction_count`	Unknown
`last_name`	Unknown
`middle_name`	Unknown
`monetary_value`	Unknown
`name`	Unknown
`postal_code`	Unknown
`prefix`	Unknown
`state`	Unknown
`status`	Unknown
`status_id`	Unknown
`street`	Unknown
`suffix`	Unknown
`title`	Unknown