Customer.io

Explore the interactive ERD

Table & Field Reference

snippet

Column	Type	Keys
`name`	String	PK
`updated_at`	Instant
`value`	String

broadcast_tag

Column	Type	Keys
`tag`	String	PK
`broadcast_id`	Long	PKFK

broadcast

Column	Type	Keys
`id`	Long	PK
`active`	Boolean
`created`	Instant
`deduplicate_id`	String
`first_started`	Instant
`name`	String
`state`	String
`type`	String
`updated`	Instant

newsletter_recipient_segment

Column	Type	Keys
`newsletter_id`	Long	PKFK
`segment_id`	Long	PKFK

newsletter_tag

Column	Type	Keys
`tag`	String	PK
`newsletter_id`	Long	PKFK

Column	Type	Keys
`id`	Long	PK
`created`	Instant
`deduplicate_id`	String
`name`	String
`sent_at`	Instant
`subject`	String
`type`	String
`updated`	Instant

transactional_message

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`description`	String
`hide_message_body`	Boolean
`link_tracking`	Boolean
`name`	String
`open_tracking`	Boolean
`queue_drafts`	Boolean
`send_to_unsubscribed`	Boolean
`updated_at`	Instant

campaign_action

Column	Type	Keys
`id`	Long	PK
`campaign_id`	Long	PKFK
`parent_action_id`	Long	FK
`bcc`	String
`body`	String
`created`	Instant
`deduplicate_id`	String
`fake_bcc`	Boolean
`from`	String
`from_id`	Long
`language`	String
`layout`	String
`method`	String
`name`	String
`preheader_text`	String
`preprocessor`	String
`recipient`	String
`reply_to`	String
`reply_to_id`	Long
`sending_state`	String
`subject`	String
`type`	String
`updated`	Instant
`url`	String

segment_dependency_campaign

Column	Type	Keys
`campaign_id`	Long	PKFK
`segment_id`	Long	PKFK

segment_dependency_sent_newsletter

Column	Type	Keys
`newsletter_id`	Long	PKFK
`segment_id`	Long	PKFK

segment_dependency_draft_newsletter

Column	Type	Keys
`newsletter_id`	Long	PKFK
`segment_id`	Long	PKFK

segment_tag

Column	Type	Keys
`tag`	String	PK
`segment_id`	Long	PKFK

segment

Column	Type	Keys
`id`	Long	PK
`deduplicate_id`	String
`description`	String
`name`	String
`progress`	Long
`state`	String
`type`	String

message

Column	Type	Keys
`id`	String	PK
`broadcast_id`	Long	FK
`campaign_id`	Long	FK
`content_id`	Long	FK
`customer_cio_id`	String	FK
`newsletter_id`	Long	FK
`action_id`	Long
`created`	Instant
`deduplicate_id`	String
`failure_message`	String
`forgotten`	Boolean
`metrics_bounced`	Instant
`metrics_clicked`	Instant
`metrics_converted`	Instant
`metrics_created`	Instant
`metrics_delivered`	Instant
`metrics_drafted`	Instant
`metrics_dropped`	Instant
`metrics_failed`	Instant
`metrics_human_clicked`	Long
`metrics_human_opened`	Long
`metrics_opened`	Instant
`metrics_prefetch_clicked`	Long
`metrics_prefetch_opened`	Long
`metrics_sent`	Instant
`metrics_spammed`	Instant
`metrics_undeliverable`	Instant
`metrics_unsubscribed`	Instant
`recipient`	String
`subject`	String
`type`	String

broadcast_action

Column	Type	Keys
`id`	Long	PK
`broadcast_id`	Long	PKFK
`bcc`	String
`body`	String
`created`	Instant
`deduplicate_id`	String
`fake_bcc`	Boolean
`from`	String
`from_id`	Long
`language`	String
`layout`	String
`name`	String
`preheader_text`	String
`preprocessor`	String
`recipient`	String
`reply_to`	String
`reply_to_id`	Long
`sending_state`	String
`subject`	String
`type`	String
`updated`	Instant

newsletter_variant

Column	Type	Keys
`id`	Long	PK
`newsletter_id`	Long	PKFK
`bcc`	String
`body`	String
`created`	Instant
`deduplicate_id`	String
`fake_bcc`	Boolean
`from`	String
`from_id`	Long
`language`	String
`layout`	String
`name`	String
`preheader_text`	String
`preprocessor`	String
`recipient`	String
`reply_to`	String
`reply_to_id`	Long
`subject`	String
`type`	String
`updated`	Instant

collection_schema

Column	Type	Keys
`schema`	String	PK
`collection_id`	Long	PKFK

collection

Column	Type	Keys
`id`	Long	PK
`bytes`	Long
`created_at`	Instant
`name`	String
`rows`	Long
`updated_at`	Instant

segment_member

Column	Type	Keys
`customer_cio_id`	String	PKFK
`segment_id`	Long	PKFK

sender_identity_campaign

Column	Type	Keys
`campaign_id`	Long	PKFK
`sender_id`	Long	PKFK

sender_identity_sent_newsletter

Column	Type	Keys
`newsletter_id`	Long	PKFK
`sender_id`	Long	PKFK

sender_identity_draft_newsletter

Column	Type	Keys
`newsletter_id`	Long	PKFK
`sender_id`	Long	PKFK

sender_identity

Column	Type	Keys
`id`	Long	PK
`address`	String
`auto_generated`	Boolean
`deduplicate_id`	String
`email`	String
`name`	String
`template_type`	String

campaign_filter_segment

Column	Type	Keys
`campaign_id`	Long	PKFK
`segment_id`	Long	PKFK

campaign_trigger_segment

Column	Type	Keys
`campaign_id`	Long	PKFK
`segment_id`	Long	PKFK

campaign_tag

Column	Type	Keys
`tag`	String	PK
`campaign_id`	Long	PKFK

campaign

Column	Type	Keys
`id`	Long	PK
`active`	Boolean
`created`	Instant
`created_by`	String
`deduplicate_id`	String
`first_started`	Instant
`name`	String
`state`	String
`updated`	Instant

customer

Column	Type	Keys
`cio_id`	String	PK
`id`	String

in_app_message_event

Column	Type	Keys
`id`	String	PK
`broadcast_id`	Long	FK
`campaign_id`	Long	FK
`content_id`	Long	FK
`customer_cio_id`	String	FK
`customer_id`	String	FK
`newsletter_id`	Long	FK
`action_id`	Long
`content`	String
`delivery_id`	String
`failure_message`	String
`href`	String
`journey_id`	String
`link_id`	Long
`metric`	String
`object_type`	String
`parent_action_id`	Long
`recipient`	String
`timestamp`	Instant
`trigger_id`	Long

webhook_event

Column	Type	Keys
`id`	String	PK
`broadcast_id`	Long	FK
`campaign_id`	Long	FK
`content_id`	Long	FK
`customer_cio_id`	String	FK
`customer_id`	String	FK
`newsletter_id`	Long	FK
`action_id`	Long
`content`	String
`delivery_id`	String
`failure_message`	String
`href`	String
`journey_id`	String
`link_id`	Long
`metric`	String
`object_type`	String
`parent_action_id`	Long
`recipient`	String
`timestamp`	Instant
`trigger_id`	Long

slack_event

Column	Type	Keys
`id`	String	PK
`broadcast_id`	Long	FK
`campaign_id`	Long	FK
`content_id`	Long	FK
`customer_cio_id`	String	FK
`customer_id`	String	FK
`newsletter_id`	Long	FK
`action_id`	Long
`content`	String
`delivery_id`	String
`failure_message`	String
`href`	String
`journey_id`	String
`link_id`	Long
`metric`	String
`object_type`	String
`parent_action_id`	Long
`recipient`	String
`timestamp`	Instant
`trigger_id`	Long

sms_event

Column	Type	Keys
`id`	String	PK
`broadcast_id`	Long	FK
`campaign_id`	Long	FK
`content_id`	Long	FK
`customer_cio_id`	String	FK
`customer_id`	String	FK
`newsletter_id`	Long	FK
`action_id`	Long
`content`	String
`delivery_id`	String
`failure_message`	String
`href`	String
`journey_id`	String
`link_id`	Long
`metric`	String
`object_type`	String
`parent_action_id`	Long
`recipient`	String
`timestamp`	Instant
`trigger_id`	Long

push_notification_event_recipient

Column	Type	Keys
`device_id`	String	PK
`event_id`	String	PKFK

push_notification_event

Column	Type	Keys
`id`	String	PK
`broadcast_id`	Long	FK
`campaign_id`	Long	FK
`content_id`	Long	FK
`customer_cio_id`	String	FK
`customer_id`	String	FK
`newsletter_id`	Long	FK
`action_id`	Long
`content`	String
`delivery_id`	String
`failure_message`	String
`href`	String
`journey_id`	String
`link_id`	Long
`metric`	String
`object_type`	String
`parent_action_id`	Long
`timestamp`	Instant
`trigger_id`	Long

email_event

Column	Type	Keys
`id`	String	PK
`broadcast_id`	Long	FK
`campaign_id`	Long	FK
`content_id`	Long	FK
`customer_cio_id`	String	FK
`customer_id`	String	FK
`newsletter_id`	Long	FK
`transactional_message_id`	Long	FK
`action_id`	Long
`content`	String
`delivery_id`	String
`failure_message`	String
`href`	String
`journey_id`	String
`link_id`	Long
`metric`	String
`object_type`	String
`parent_action_id`	Long
`recipient`	String
`subject`	String
`timestamp`	Instant
`trigger_id`	Long

customer_event

Column	Type	Keys
`id`	String	PK
`customer_cio_id`	String	FK
`customer_id`	String	FK
`metric`	String
`object_type`	String
`timestamp`	Instant