Sendgrid schema

40 tables · 5 joins

About the connector Start free

40 tables

Loading diagram…

legacy_campaign

legacy_list_recipient

legacy_segment

legacy_segment_recipient

template

alert

8

id

string

created_at

date

email_to

string

frequency

string

percentage

long

type

string

updated_at

date

_weld_synced

date

block

5

email

string

created

date

reason

string

status

string

_weld_synced

date

bounce

5

email

string

created

date

reason

string

status

string

_weld_synced

date

browser_stat

6

date

date

name

string

type

string

clicks

long

unique_clicks

long

_weld_synced

date

client_stat

6

date

date

name

string

type

string

opens

long

unique_opens

long

_weld_synced

date

contact

20

id

string

email

string

first_name

string

last_name

string

address_line_1

string

address_line_2

string

city

string

state_province_region

string

country

string

contact_list

4

id

string

name

string

contact_count

long

_weld_synced

date

device_stat

6

date

date

name

string

type

string

opens

long

unique_opens

long

_weld_synced

date

event_webhook_setting

17

id

string

friendly_name

string

url

string

enabled

boolean

group_resubscribe

boolean

delivered

boolean

group_unsubscribe

boolean

spam_report

boolean

bounce

boolean

geo_stat

8

date

date

name

string

type

string

clicks

long

opens

long

unique_clicks

long

unique_opens

long

_weld_synced

date

global_unsubscribe

3

email

string

created

date

_weld_synced

date

group_suppression

3

group_id

string

email

string

_weld_synced

date

inbound_parse_setting

5

hostname

string

url

string

spam_check

boolean

send_raw

boolean

_weld_synced

date

invalid_email

4

email

string

created

date

reason

string

_weld_synced

date

ip_address

7

ip

string

pools

string

whitelabeled

boolean

start_date

date

subusers

string

rdns

string

_weld_synced

date

legacy_campaign

12

id

string

sender_id

string

title

string

subject

string

suppression_group_id

string

custom_unsubscribe_url

string

ip_pool

string

html_content

string

plain_content

string

editor

string

status

string

_weld_synced

date

legacy_campaign_list

4

campaign_id

string

list_id

string

index

int

_weld_synced

date

legacy_campaign_segment

4

segment_id

string

campaign_id

string

index

int

_weld_synced

date

legacy_campaign_category

4

campaign_id

string

category

string

index

int

_weld_synced

date

legacy_category

2

category

string

_weld_synced

date

legacy_category_stat

20

date

date

name

string

type

string

blocks

long

bounce_drops

long

bounces

long

clicks

long

deferred

long

legacy_list

4

id

string

name

string

recipient_count

long

_weld_synced

date

legacy_list_recipient

11

id

string

list_id

string

email

string

first_name

string

last_name

string

created_at

date

updated_at

date

last_clicked

date

last_opened

date

last_emailed

date

_weld_synced

date

legacy_list_recipient_custom_field

8

id

string

recipient_id

string

list_id

string

index

int

name

string

type

string

value

string

_weld_synced

date

legacy_segment

5

id

string

name

string

list_id

string

recipient_count

long

_weld_synced

date

legacy_segment_condition

7

segment_id

string

index

int

field

string

value

string

operator

string

and_or

string

_weld_synced

date

legacy_segment_recipient

11

id

string

segment_id

string

email

string

first_name

string

last_name

string

created_at

date

updated_at

date

last_clicked

date

last_opened

date

last_emailed

date

_weld_synced

date

legacy_segment_recipient_custom_field

8

id

string

segment_id

string

recipient_id

string

index

int

name

string

type

string

value

string

_weld_synced

date

mailbox_provider_stat

14

date

date

name

string

type

string

blocks

long

bounces

long

clicks

long

deferred

long

delivered

long

message

9

msg_id

string

from_email

string

to_email

string

subject

string

status

string

opens_count

long

clicks_count

long

last_event_time

date

_weld_synced

date

segment

9

id

string

name

string

parent_list_id

string

contacts_count

long

status

string

created_at

date

updated_at

date

sample_updated_at

date

_weld_synced

date

sender

17

id

string

nickname

string

from_email

string

from_name

string

reply_to_email

string

reply_to_name

string

address

string

address_2

string

city

string

single_send

10

id

string

name

string

status

string

categories

string

abtest

string

is_abtest

boolean

send_at

date

created_at

date

updated_at

date

_weld_synced

date

spam_report

4

email

string

created

date

ip

string

_weld_synced

date

stat

18

date

date

blocks

long

bounce_drops

long

bounces

long

clicks

long

deferred

long

delivered

long

invalid_emails

long

subuser

5

id

string

username

string

email

string

disabled

boolean

_weld_synced

date

subuser_stat

20

date

date

name

string

type

string

blocks

long

bounce_drops

long

bounces

long

clicks

long

deferred

long

template

5

id

string

name

string

generation

string

updated_at

date

_weld_synced

date

template_version

10

id

string

template_id

string

name

string

subject

string

active

int

generate_plain_content

boolean

editor

string

thumbnail_url

string

updated_at

date

_weld_synced

date

unsubscribe_group

7

id

string

name

string

description

string

last_email_sent_at

date

is_default

boolean

unsubscribes

string

_weld_synced

date