Entity relationships for Snowflake and Braze
These are the list of entity relationships between Snowflake and Braze for each messaging channel.
Relationship tables
ABORT_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
// USERS_MESSAGES_CONTENTCARD_ABORT_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"EXTERNAL_USER_ID",
"DEVICE_ID",
"APP_GROUP_API_ID",
"DISPATCH_ID",
"CAMPAIGN_ID",
"CAMPAIGN_API_ID",
"MESSAGE_VARIATION_API_ID",
"CANVAS_ID",
"CANVAS_API_ID",
"CANVAS_VARIATION_API_ID",
"CANVAS_STEP_API_ID",
"CANVAS_STEP_MESSAGE_VARIATION_API_ID",
"APP_GROUP_ID"
],
"native_keys": [
"TIME",
"GENDER",
"COUNTRY",
"TIMEZONE",
"LANGUAGE",
"ABORT_TYPE",
"ABORT_LOG",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
CLICK_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
// USERS_MESSAGES_CONTENTCARD_CLICK_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"CONTENT_CARD_ID",
"EXTERNAL_USER_ID",
"APP_GROUP_API_ID",
"APP_API_ID",
"DISPATCH_ID",
"CAMPAIGN_ID",
"CAMPAIGN_API_ID",
"MESSAGE_VARIATION_API_ID",
"CANVAS_ID",
"CANVAS_API_ID",
"CANVAS_VARIATION_API_ID",
"CANVAS_STEP_API_ID",
"CANVAS_STEP_MESSAGE_VARIATION_API_ID",
"DEVICE_ID",
"APP_GROUP_ID"
],
"native_keys": [
"TIME",
"GENDER",
"COUNTRY",
"TIMEZONE",
"LANGUAGE",
"SDK_VERSION",
"PLATFORM",
"OS_VERSION",
"DEVICE_MODEL",
"RESOLUTION",
"CARRIER",
"BROWSER",
"AD_ID_TYPE",
"AD_TRACKING_ENABLED",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
DISMISS_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
// USERS_MESSAGES_CONTENTCARD_DISMISS_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"CONTENT_CARD_ID",
"EXTERNAL_USER_ID",
"APP_GROUP_API_ID",
"APP_API_ID",
"DISPATCH_ID",
"CAMPAIGN_ID",
"CAMPAIGN_API_ID",
"MESSAGE_VARIATION_API_ID",
"CANVAS_ID",
"CANVAS_API_ID",
"CANVAS_VARIATION_API_ID",
"CANVAS_STEP_API_ID",
"CANVAS_STEP_MESSAGE_VARIATION_API_ID",
"DEVICE_ID",
"APP_GROUP_ID"
],
"native_keys": [
"TIME",
"GENDER",
"COUNTRY",
"TIMEZONE",
"LANGUAGE",
"SDK_VERSION",
"PLATFORM",
"OS_VERSION",
"DEVICE_MODEL",
"RESOLUTION",
"CARRIER",
"BROWSER",
"AD_ID_TYPE",
"AD_TRACKING_ENABLED",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
IMPRESSION_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
// USERS_MESSAGES_CONTENTCARD_IMPRESSION_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"CONTENT_CARD_ID",
"EXTERNAL_USER_ID",
"APP_GROUP_API_ID",
"APP_API_ID",
"DISPATCH_ID",
"CAMPAIGN_ID",
"CAMPAIGN_API_ID",
"MESSAGE_VARIATION_API_ID",
"CANVAS_ID",
"CANVAS_API_ID",
"CANVAS_VARIATION_API_ID",
"CANVAS_STEP_API_ID",
"CANVAS_STEP_MESSAGE_VARIATION_API_ID",
"DEVICE_ID",
"APP_GROUP_ID"
],
"native_keys": [
"TIME",
"GENDER",
"COUNTRY",
"TIMEZONE",
"LANGUAGE",
"SDK_VERSION",
"PLATFORM",
"OS_VERSION",
"DEVICE_MODEL",
"RESOLUTION",
"CARRIER",
"BROWSER",
"AD_ID_TYPE",
"AD_TRACKING_ENABLED",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
SEND_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
// USERS_MESSAGES_CONTENTCARD_SEND_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"EXTERNAL_USER_ID",
"DEVICE_ID",
"APP_GROUP_API_ID",
"DISPATCH_ID",
"CAMPAIGN_ID",
"CAMPAIGN_API_ID",
"MESSAGE_VARIATION_API_ID",
"CANVAS_ID",
"CANVAS_API_ID",
"CANVAS_VARIATION_API_ID",
"CANVAS_STEP_API_ID",
"CANVAS_STEP_MESSAGE_VARIATION_API_ID",
"CONTENT_CARD_ID",
"APP_GROUP_ID"
],
"native_keys": [
"TIME",
"GENDER",
"COUNTRY",
"TIMEZONE",
"LANGUAGE",
"MESSAGE_EXTRAS",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
Relationship tables
ABORT_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
// USERS_MESSAGES_EMAIL_ABORT_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"EXTERNAL_USER_ID",
"DEVICE_ID",
"APP_GROUP_API_ID",
"DISPATCH_ID",
"CAMPAIGN_ID",
"CAMPAIGN_API_ID",
"MESSAGE_VARIATION_API_ID",
"CANVAS_ID",
"CANVAS_API_ID",
"CANVAS_VARIATION_API_ID",
"CANVAS_STEP_API_ID",
"CANVAS_STEP_MESSAGE_VARIATION_API_ID",
"APP_GROUP_ID"
],
"native_keys": [
"TIME",
"GENDER",
"COUNTRY",
"TIMEZONE",
"LANGUAGE",
"EMAIL_ADDRESS",
"IP_POOL",
"ABORT_TYPE",
"ABORT_LOG",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
BOUNCE_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
// USERS_MESSAGES_EMAIL_BOUNCE_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"EXTERNAL_USER_ID",
"DEVICE_ID",
"APP_GROUP_API_ID",
"DISPATCH_ID",
"CAMPAIGN_ID",
"CAMPAIGN_API_ID",
"MESSAGE_VARIATION_API_ID",
"CANVAS_ID",
"CANVAS_API_ID",
"CANVAS_VARIATION_API_ID",
"CANVAS_STEP_API_ID",
"CANVAS_STEP_MESSAGE_VARIATION_API_ID",
"APP_GROUP_ID"
],
"native_keys": [
"TIME",
"GENDER",
"COUNTRY",
"TIMEZONE",
"LANGUAGE",
"EMAIL_ADDRESS",
"SENDING_IP",
"IP_POOL",
"BOUNCE_REASON",
"ESP",
"FROM_DOMAIN",
"IS_DROP",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
CLICK_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
// USERS_MESSAGES_EMAIL_CLICK_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"EXTERNAL_USER_ID",
"DEVICE_ID",
"APP_GROUP_API_ID",
"DISPATCH_ID",
"CAMPAIGN_ID",
"CAMPAIGN_API_ID",
"MESSAGE_VARIATION_API_ID",
"CANVAS_ID",
"CANVAS_API_ID",
"CANVAS_VARIATION_API_ID",
"CANVAS_STEP_API_ID",
"CANVAS_STEP_MESSAGE_VARIATION_API_ID",
"APP_GROUP_ID"
],
"native_keys": [
"TIME",
"GENDER",
"COUNTRY",
"TIMEZONE",
"LANGUAGE",
"EMAIL_ADDRESS",
"URL",
"USER_AGENT",
"IP_POOL",
"LINK_ALIAS",
"ESP",
"FROM_DOMAIN",
"IS_AMP",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
DELIVERY_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
// USERS_MESSAGES_EMAIL_DELIVERY_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"EXTERNAL_USER_ID",
"DEVICE_ID",
"APP_GROUP_API_ID",
"DISPATCH_ID",
"CAMPAIGN_ID",
"CAMPAIGN_API_ID",
"MESSAGE_VARIATION_API_ID",
"CANVAS_ID",
"CANVAS_API_ID",
"CANVAS_VARIATION_API_ID",
"CANVAS_STEP_API_ID",
"CANVAS_STEP_MESSAGE_VARIATION_API_ID",
"APP_GROUP_ID"
],
"native_keys": [
"TIME",
"GENDER",
"COUNTRY",
"TIMEZONE",
"LANGUAGE",
"EMAIL_ADDRESS",
"SENDING_IP",
"IP_POOL",
"ESP",
"FROM_DOMAIN",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
MARKASSPAM_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
// USERS_MESSAGES_EMAIL_MARKASSPAM_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"EXTERNAL_USER_ID",
"DEVICE_ID",
"APP_GROUP_API_ID",
"DISPATCH_ID",
"CAMPAIGN_ID",
"CAMPAIGN_API_ID",
"MESSAGE_VARIATION_API_ID",
"CANVAS_ID",
"CANVAS_API_ID",
"CANVAS_VARIATION_API_ID",
"CANVAS_STEP_API_ID",
"CANVAS_STEP_MESSAGE_VARIATION_API_ID",
"APP_GROUP_ID"
],
"native_keys": [
"TIME",
"GENDER",
"COUNTRY",
"TIMEZONE",
"LANGUAGE",
"EMAIL_ADDRESS",
"USER_AGENT",
"IP_POOL",
"ESP",
"FROM_DOMAIN",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
OPEN_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
// USERS_MESSAGES_EMAIL_OPEN_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"EXTERNAL_USER_ID",
"DEVICE_ID",
"APP_GROUP_API_ID",
"DISPATCH_ID",
"CAMPAIGN_ID",
"CAMPAIGN_API_ID",
"MESSAGE_VARIATION_API_ID",
"CANVAS_ID",
"CANVAS_API_ID",
"CANVAS_VARIATION_API_ID",
"CANVAS_STEP_API_ID",
"CANVAS_STEP_MESSAGE_VARIATION_API_ID",
"APP_GROUP_ID"
],
"native_keys": [
"TIME",
"GENDER",
"COUNTRY",
"TIMEZONE",
"LANGUAGE",
"EMAIL_ADDRESS",
"USER_AGENT",
"IP_POOL",
"MACHINE_OPEN",
"ESP",
"FROM_DOMAIN",
"IS_AMP",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
SEND_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
// USERS_MESSAGES_EMAIL_SEND_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"EXTERNAL_USER_ID",
"DEVICE_ID",
"APP_GROUP_API_ID",
"DISPATCH_ID",
"CAMPAIGN_ID",
"CAMPAIGN_API_ID",
"MESSAGE_VARIATION_API_ID",
"CANVAS_ID",
"CANVAS_API_ID",
"CANVAS_VARIATION_API_ID",
"CANVAS_STEP_API_ID",
"CANVAS_STEP_MESSAGE_VARIATION_API_ID",
"APP_GROUP_ID"
],
"native_keys": [
"TIME",
"GENDER",
"COUNTRY",
"TIMEZONE",
"LANGUAGE",
"EMAIL_ADDRESS",
"IP_POOL",
"MESSAGE_EXTRAS",
"ESP",
"FROM_DOMAIN",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
SOFTBOUNCE_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
// USERS_MESSAGES_EMAIL_SOFTBOUNCE_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"EXTERNAL_USER_ID",
"DEVICE_ID",
"APP_GROUP_API_ID",
"DISPATCH_ID",
"CAMPAIGN_ID",
"CAMPAIGN_API_ID",
"MESSAGE_VARIATION_API_ID",
"CANVAS_ID",
"CANVAS_API_ID",
"CANVAS_VARIATION_API_ID",
"CANVAS_STEP_API_ID",
"CANVAS_STEP_MESSAGE_VARIATION_API_ID",
"APP_GROUP_ID"
],
"native_keys": [
"TIME",
"GENDER",
"COUNTRY",
"TIMEZONE",
"LANGUAGE",
"EMAIL_ADDRESS",
"SENDING_IP",
"IP_POOL",
"BOUNCE_REASON",
"ESP",
"FROM_DOMAIN",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
UNSUBSCRIBE_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
// USERS_MESSAGES_EMAIL_UNSUBSCRIBE_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"EXTERNAL_USER_ID",
"DEVICE_ID",
"APP_GROUP_API_ID",
"DISPATCH_ID",
"CAMPAIGN_ID",
"CAMPAIGN_API_ID",
"MESSAGE_VARIATION_API_ID",
"CANVAS_ID",
"CANVAS_API_ID",
"CANVAS_VARIATION_API_ID",
"CANVAS_STEP_API_ID",
"CANVAS_STEP_MESSAGE_VARIATION_API_ID",
"APP_GROUP_ID"
],
"native_keys": [
"TIME",
"GENDER",
"COUNTRY",
"TIMEZONE",
"LANGUAGE",
"EMAIL_ADDRESS",
"IP_POOL",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
Relationship tables
IMPRESSION_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
// USERS_MESSAGES_FEATUREFLAG_IMPRESSION_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"APP_API_ID",
"APP_GROUP_API_ID",
"CAMPAIGN_API_ID",
"CAMPAIGN_ID",
"CANVAS_API_ID",
"CANVAS_ID",
"CANVAS_STEP_API_ID",
"CANVAS_STEP_MESSAGE_VARIATION_API_ID",
"CANVAS_VARIATION_API_ID",
"MESSAGE_VARIATION_API_ID",
"EXTERNAL_USER_ID",
"DEVICE_ID",
"USER_ID",
"APP_GROUP_ID"
],
"native_keys": [
"FEATURE_FLAG_ID_NAME",
"TIME",
"GENDER",
"BROWSER",
"CARRIER",
"COUNTRY",
"DEVICE_MODEL",
"LANGUAGE",
"OS_VERSION",
"PLATFORM",
"RESOLUTION",
"SDK_VERSION",
"TIMEZONE",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
Relationship tables
ABORT_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
// USERS_MESSAGES_NEWSFEEDCARD_ABORT_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"EXTERNAL_USER_ID",
"APP_GROUP_API_ID",
"APP_API_ID",
"CARD_API_ID",
"DEVICE_ID",
"APP_GROUP_ID"
],
"native_keys": [
"TIME",
"GENDER",
"COUNTRY",
"TIMEZONE",
"LANGUAGE",
"SDK_VERSION",
"PLATFORM",
"OS_VERSION",
"DEVICE_MODEL",
"RESOLUTION",
"CARRIER",
"BROWSER",
"ABORT_TYPE",
"ABORT_LOG",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
CLICK_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
// USERS_MESSAGES_NEWSFEEDCARD_CLICK_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"EXTERNAL_USER_ID",
"APP_GROUP_API_ID",
"APP_API_ID",
"CARD_API_ID",
"DEVICE_ID",
"APP_GROUP_ID"
],
"native_keys": [
"TIME",
"GENDER",
"COUNTRY",
"TIMEZONE",
"LANGUAGE",
"SDK_VERSION",
"PLATFORM",
"OS_VERSION",
"DEVICE_MODEL",
"RESOLUTION",
"CARRIER",
"BROWSER",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
IMPRESSION_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
// USERS_MESSAGES_NEWSFEEDCARD_IMPRESSION_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"EXTERNAL_USER_ID",
"APP_GROUP_API_ID",
"APP_API_ID",
"CARD_API_ID",
"DEVICE_ID",
"APP_GROUP_ID"
],
"native_keys": [
"TIME",
"GENDER",
"COUNTRY",
"TIMEZONE",
"LANGUAGE",
"SDK_VERSION",
"PLATFORM",
"OS_VERSION",
"DEVICE_MODEL",
"RESOLUTION",
"CARRIER",
"BROWSER",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
Relationship tables
ABORT_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
// USERS_MESSAGES_PUSHNOTIFICATION_ABORT_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"EXTERNAL_USER_ID",
"DEVICE_ID",
"APP_GROUP_API_ID",
"APP_API_ID",
"DISPATCH_ID",
"CAMPAIGN_ID",
"CAMPAIGN_API_ID",
"MESSAGE_VARIATION_API_ID",
"CANVAS_ID",
"CANVAS_API_ID",
"CANVAS_VARIATION_API_ID",
"CANVAS_STEP_API_ID",
"CANVAS_STEP_MESSAGE_VARIATION_API_ID",
"APP_GROUP_ID"
],
"native_keys": [
"TIME",
"GENDER",
"COUNTRY",
"TIMEZONE",
"LANGUAGE",
"PLATFORM",
"ABORT_TYPE",
"ABORT_LOG",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
BOUNCE_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
// USERS_MESSAGES_PUSHNOTIFICATION_BOUNCE_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"EXTERNAL_USER_ID",
"DEVICE_ID",
"APP_GROUP_API_ID",
"APP_API_ID",
"DISPATCH_ID",
"CAMPAIGN_ID",
"CAMPAIGN_API_ID",
"MESSAGE_VARIATION_API_ID",
"CANVAS_ID",
"CANVAS_API_ID",
"CANVAS_VARIATION_API_ID",
"CANVAS_STEP_API_ID",
"CANVAS_STEP_MESSAGE_VARIATION_API_ID",
"APP_GROUP_ID"
],
"native_keys": [
"PUSH_TOKEN",
"TIME",
"GENDER",
"COUNTRY",
"TIMEZONE",
"LANGUAGE",
"PLATFORM",
"AD_ID_TYPE",
"AD_TRACKING_ENABLED",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
INFLUENCEDOPEN_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
// USERS_MESSAGES_PUSHNOTIFICATION_INFLUENCEDOPEN_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"EXTERNAL_USER_ID",
"APP_GROUP_API_ID",
"APP_API_ID",
"DISPATCH_ID",
"CAMPAIGN_ID",
"CAMPAIGN_API_ID",
"MESSAGE_VARIATION_API_ID",
"CANVAS_ID",
"CANVAS_API_ID",
"CANVAS_VARIATION_API_ID",
"CANVAS_STEP_API_ID",
"CANVAS_STEP_MESSAGE_VARIATION_API_ID",
"DEVICE_ID",
"APP_GROUP_ID"
],
"native_keys": [
"TIME",
"GENDER",
"COUNTRY",
"TIMEZONE",
"LANGUAGE",
"SDK_VERSION",
"PLATFORM",
"OS_VERSION",
"DEVICE_MODEL",
"RESOLUTION",
"CARRIER",
"BROWSER",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
IOSFOREGROUND_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
// USERS_MESSAGES_PUSHNOTIFICATION_IOSFOREGROUND_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"EXTERNAL_USER_ID",
"APP_GROUP_API_ID",
"APP_API_ID",
"DISPATCH_ID",
"CAMPAIGN_ID",
"CAMPAIGN_API_ID",
"MESSAGE_VARIATION_API_ID",
"CANVAS_ID",
"CANVAS_API_ID",
"CANVAS_VARIATION_API_ID",
"CANVAS_STEP_API_ID",
"CANVAS_STEP_MESSAGE_VARIATION_API_ID",
"DEVICE_ID",
"APP_GROUP_ID"
],
"native_keys": [
"TIME",
"GENDER",
"COUNTRY",
"TIMEZONE",
"LANGUAGE",
"SDK_VERSION",
"PLATFORM",
"OS_VERSION",
"DEVICE_MODEL",
"RESOLUTION",
"CARRIER",
"BROWSER",
"AD_ID_TYPE",
"AD_TRACKING_ENABLED",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
OPEN_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
// USERS_MESSAGES_PUSHNOTIFICATION_OPEN_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"EXTERNAL_USER_ID",
"APP_GROUP_API_ID",
"APP_API_ID",
"DISPATCH_ID",
"CAMPAIGN_ID",
"CAMPAIGN_API_ID",
"MESSAGE_VARIATION_API_ID",
"CANVAS_ID",
"CANVAS_API_ID",
"CANVAS_VARIATION_API_ID",
"CANVAS_STEP_API_ID",
"CANVAS_STEP_MESSAGE_VARIATION_API_ID",
"DEVICE_ID",
"APP_GROUP_ID"
],
"native_keys": [
"TIME",
"GENDER",
"COUNTRY",
"TIMEZONE",
"LANGUAGE",
"SDK_VERSION",
"PLATFORM",
"OS_VERSION",
"DEVICE_MODEL",
"RESOLUTION",
"CARRIER",
"BROWSER",
"BUTTON_STRING",
"BUTTON_ACTION_TYPE",
"SLIDE_ACTION_TYPE",
"AD_ID_TYPE",
"AD_TRACKING_ENABLED",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
SEND_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
// USERS_MESSAGES_PUSHNOTIFICATION_SEND_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"EXTERNAL_USER_ID",
"DEVICE_ID",
"APP_GROUP_API_ID",
"APP_API_ID",
"DISPATCH_ID",
"CAMPAIGN_ID",
"CAMPAIGN_API_ID",
"MESSAGE_VARIATION_API_ID",
"CANVAS_ID",
"CANVAS_API_ID",
"CANVAS_VARIATION_API_ID",
"CANVAS_STEP_API_ID",
"CANVAS_STEP_MESSAGE_VARIATION_API_ID",
"APP_GROUP_ID"
],
"native_keys": [
"PUSH_TOKEN",
"TIME",
"GENDER",
"COUNTRY",
"TIMEZONE",
"LANGUAGE",
"PLATFORM",
"AD_ID_TYPE",
"AD_TRACKING_ENABLED",
"MESSAGE_EXTRAS",
"IS_SAMPLED",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
Relationship tables
ABORT_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
// USERS_MESSAGES_SMS_ABORT_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"EXTERNAL_USER_ID",
"APP_GROUP_API_ID",
"CAMPAIGN_ID",
"CAMPAIGN_API_ID",
"MESSAGE_VARIATION_API_ID",
"CANVAS_ID",
"CANVAS_API_ID",
"CANVAS_VARIATION_API_ID",
"CANVAS_STEP_API_ID",
"CANVAS_STEP_MESSAGE_VARIATION_API_ID",
"SUBSCRIPTION_GROUP_API_ID",
"APP_GROUP_ID"
],
"native_keys": [
"TIME",
"ABORT_TYPE",
"ABORT_LOG",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
SEND_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
// USERS_MESSAGES_SMS_SEND_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"EXTERNAL_USER_ID",
"DEVICE_ID",
"APP_GROUP_API_ID",
"DISPATCH_ID",
"CAMPAIGN_ID",
"CAMPAIGN_API_ID",
"MESSAGE_VARIATION_API_ID",
"CANVAS_ID",
"CANVAS_API_ID",
"CANVAS_VARIATION_API_ID",
"CANVAS_STEP_API_ID",
"CANVAS_STEP_MESSAGE_VARIATION_API_ID",
"SUBSCRIPTION_GROUP_API_ID",
"APP_GROUP_ID"
],
"native_keys": [
"TIME",
"GENDER",
"COUNTRY",
"TIMEZONE",
"LANGUAGE",
"TO_PHONE_NUMBER",
"CATEGORY",
"MESSAGE_EXTRAS",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
CARRIERSEND_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
// USERS_MESSAGES_SMS_CARRIERSEND_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"EXTERNAL_USER_ID",
"DEVICE_ID",
"APP_GROUP_API_ID",
"DISPATCH_ID",
"CAMPAIGN_ID",
"CAMPAIGN_API_ID",
"MESSAGE_VARIATION_API_ID",
"CANVAS_ID",
"CANVAS_API_ID",
"CANVAS_VARIATION_API_ID",
"CANVAS_STEP_API_ID",
"CANVAS_STEP_MESSAGE_VARIATION_API_ID",
"SUBSCRIPTION_GROUP_API_ID",
"APP_GROUP_ID"
],
"native_keys": [
"TIME",
"GENDER",
"COUNTRY",
"TIMEZONE",
"LANGUAGE",
"TO_PHONE_NUMBER",
"FROM_PHONE_NUMBER",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
DELIVERY_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
// USERS_MESSAGES_SMS_DELIVERY_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"EXTERNAL_USER_ID",
"DEVICE_ID",
"APP_GROUP_API_ID",
"DISPATCH_ID",
"CAMPAIGN_ID",
"CAMPAIGN_API_ID",
"MESSAGE_VARIATION_API_ID",
"CANVAS_ID",
"CANVAS_API_ID",
"CANVAS_VARIATION_API_ID",
"CANVAS_STEP_API_ID",
"CANVAS_STEP_MESSAGE_VARIATION_API_ID",
"SUBSCRIPTION_GROUP_API_ID",
"APP_GROUP_ID"
],
"native_keys": [
"TIME",
"GENDER",
"COUNTRY",
"TIMEZONE",
"LANGUAGE",
"TO_PHONE_NUMBER",
"FROM_PHONE_NUMBER",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
DELIVERYFAILURE_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
// USERS_MESSAGES_SMS_DELIVERYFAILURE_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"EXTERNAL_USER_ID",
"DEVICE_ID",
"APP_GROUP_API_ID",
"DISPATCH_ID",
"CAMPAIGN_ID",
"CAMPAIGN_API_ID",
"MESSAGE_VARIATION_API_ID",
"CANVAS_ID",
"CANVAS_API_ID",
"CANVAS_VARIATION_API_ID",
"CANVAS_STEP_API_ID",
"CANVAS_STEP_MESSAGE_VARIATION_API_ID",
"SUBSCRIPTION_GROUP_API_ID",
"APP_GROUP_ID"
],
"native_keys": [
"TIME",
"GENDER",
"COUNTRY",
"TIMEZONE",
"LANGUAGE",
"TO_PHONE_NUMBER",
"ERROR",
"PROVIDER_ERROR_CODE",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
INBOUNDRECEIVE_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
// USERS_MESSAGES_SMS_INBOUNDRECEIVE_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"EXTERNAL_USER_ID",
"APP_GROUP_API_ID",
"SUBSCRIPTION_GROUP_ID",
"SUBSCRIPTION_GROUP_API_ID",
"CAMPAIGN_ID",
"CAMPAIGN_API_ID",
"MESSAGE_VARIATION_API_ID",
"CANVAS_ID",
"CANVAS_API_ID",
"CANVAS_VARIATION_API_ID",
"CANVAS_STEP_API_ID",
"CANVAS_STEP_MESSAGE_VARIATION_API_ID",
"APP_GROUP_ID"
],
"native_keys": [
"TIME",
"USER_PHONE_NUMBER",
"INBOUND_PHONE_NUMBER",
"ACTION",
"MESSAGE_BODY",
"MEDIA_URLS",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
REJECTION_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
// USERS_MESSAGES_SMS_REJECTION_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"EXTERNAL_USER_ID",
"DEVICE_ID",
"APP_GROUP_API_ID",
"DISPATCH_ID",
"CAMPAIGN_ID",
"CAMPAIGN_API_ID",
"MESSAGE_VARIATION_API_ID",
"CANVAS_ID",
"CANVAS_API_ID",
"CANVAS_VARIATION_API_ID",
"CANVAS_STEP_API_ID",
"CANVAS_STEP_MESSAGE_VARIATION_API_ID",
"SUBSCRIPTION_GROUP_API_ID",
"APP_GROUP_ID"
],
"native_keys": [
"TIME",
"GENDER",
"COUNTRY",
"TIMEZONE",
"LANGUAGE",
"TO_PHONE_NUMBER",
"FROM_PHONE_NUMBER",
"ERROR",
"PROVIDER_ERROR_CODE",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
SHORTLINKCLICK_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
// USERS_MESSAGES_SMS_SHORTLINKCLICK_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"EXTERNAL_USER_ID",
"DEVICE_ID",
"APP_GROUP_API_ID",
"CAMPAIGN_ID",
"CAMPAIGN_API_ID",
"MESSAGE_VARIATION_API_ID",
"CANVAS_ID",
"CANVAS_API_ID",
"CANVAS_VARIATION_API_ID",
"CANVAS_STEP_API_ID",
"CANVAS_STEP_MESSAGE_VARIATION_API_ID",
"APP_GROUP_ID"
],
"native_keys": [
"TIME",
"TIMEZONE",
"URL",
"SHORT_URL",
"USER_AGENT",
"USER_PHONE_NUMBER",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
Relationship tables
ABORT_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
// USERS_MESSAGES_WEBHOOK_ABORT_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"EXTERNAL_USER_ID",
"DEVICE_ID",
"APP_GROUP_API_ID",
"DISPATCH_ID",
"CAMPAIGN_ID",
"CAMPAIGN_API_ID",
"MESSAGE_VARIATION_API_ID",
"CANVAS_ID",
"CANVAS_API_ID",
"CANVAS_VARIATION_API_ID",
"CANVAS_STEP_API_ID",
"CANVAS_STEP_MESSAGE_VARIATION_API_ID",
"APP_GROUP_ID"
],
"native_keys": [
"TIME",
"GENDER",
"COUNTRY",
"TIMEZONE",
"LANGUAGE",
"ABORT_TYPE",
"ABORT_LOG",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
SEND_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
// USERS_MESSAGES_WEBHOOK_SEND_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"EXTERNAL_USER_ID",
"DEVICE_ID",
"APP_GROUP_API_ID",
"DISPATCH_ID",
"CAMPAIGN_ID",
"CAMPAIGN_API_ID",
"MESSAGE_VARIATION_API_ID",
"CANVAS_ID",
"CANVAS_API_ID",
"CANVAS_VARIATION_API_ID",
"CANVAS_STEP_API_ID",
"CANVAS_STEP_MESSAGE_VARIATION_API_ID",
"APP_GROUP_ID"
],
"native_keys": [
"TIME",
"GENDER",
"COUNTRY",
"TIMEZONE",
"LANGUAGE",
"MESSAGE_EXTRAS",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
Relationship tables
ABORT_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
// USERS_MESSAGES_WHATSAPP_ABORT_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"EXTERNAL_USER_ID",
"DEVICE_ID",
"APP_GROUP_API_ID",
"SUBSCRIPTION_GROUP_API_ID",
"CAMPAIGN_ID",
"CAMPAIGN_API_ID",
"MESSAGE_VARIATION_API_ID",
"CANVAS_ID",
"CANVAS_API_ID",
"CANVAS_VARIATION_API_ID",
"CANVAS_STEP_API_ID",
"CANVAS_STEP_MESSAGE_VARIATION_API_ID",
"DISPATCH_ID",
"APP_GROUP_ID"
],
"native_keys": [
"TIME",
"TO_PHONE_NUMBER",
"TIMEZONE",
"ABORT_TYPE",
"ABORT_LOG",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
DELIVERY_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
// USERS_MESSAGES_WHATSAPP_DELIVERY_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"EXTERNAL_USER_ID",
"DEVICE_ID",
"APP_GROUP_API_ID",
"SUBSCRIPTION_GROUP_API_ID",
"CAMPAIGN_ID",
"CAMPAIGN_API_ID",
"MESSAGE_VARIATION_API_ID",
"CANVAS_ID",
"CANVAS_API_ID",
"CANVAS_VARIATION_API_ID",
"CANVAS_STEP_API_ID",
"CANVAS_STEP_MESSAGE_VARIATION_API_ID",
"DISPATCH_ID",
"APP_GROUP_ID"
],
"native_keys": [
"TIME",
"TO_PHONE_NUMBER",
"TIMEZONE",
"FROM_PHONE_NUMBER",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
FAILURE_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
// USERS_MESSAGES_WHATSAPP_FAILURE_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"EXTERNAL_USER_ID",
"DEVICE_ID",
"APP_GROUP_API_ID",
"SUBSCRIPTION_GROUP_API_ID",
"CAMPAIGN_ID",
"CAMPAIGN_API_ID",
"MESSAGE_VARIATION_API_ID",
"CANVAS_ID",
"CANVAS_API_ID",
"CANVAS_VARIATION_API_ID",
"CANVAS_STEP_API_ID",
"CANVAS_STEP_MESSAGE_VARIATION_API_ID",
"DISPATCH_ID",
"APP_GROUP_ID"
],
"native_keys": [
"TIME",
"TO_PHONE_NUMBER",
"TIMEZONE",
"FROM_PHONE_NUMBER",
"PROVIDER_ERROR_CODE",
"PROVIDER_ERROR_TITLE",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
INBOUNDRECEIVE_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
// USERS_MESSAGES_WHATSAPP_INBOUNDRECEIVE_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"EXTERNAL_USER_ID",
"DEVICE_ID",
"APP_GROUP_API_ID",
"SUBSCRIPTION_GROUP_API_ID",
"CAMPAIGN_ID",
"CAMPAIGN_API_ID",
"MESSAGE_VARIATION_API_ID",
"CANVAS_ID",
"CANVAS_API_ID",
"CANVAS_VARIATION_API_ID",
"CANVAS_STEP_API_ID",
"CANVAS_STEP_MESSAGE_VARIATION_API_ID",
"APP_GROUP_ID"
],
"native_keys": [
"TIME",
"USER_PHONE_NUMBER",
"INBOUND_PHONE_NUMBER",
"TIMEZONE",
"MESSAGE_BODY",
"QUICK_REPLY_TEXT",
"MEDIA_URLS",
"ACTION",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
READ_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
// USERS_MESSAGES_WHATSAPP_READ_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"EXTERNAL_USER_ID",
"DEVICE_ID",
"APP_GROUP_API_ID",
"SUBSCRIPTION_GROUP_API_ID",
"CAMPAIGN_ID",
"CAMPAIGN_API_ID",
"MESSAGE_VARIATION_API_ID",
"CANVAS_ID",
"CANVAS_API_ID",
"CANVAS_VARIATION_API_ID",
"CANVAS_STEP_API_ID",
"CANVAS_STEP_MESSAGE_VARIATION_API_ID",
"DISPATCH_ID",
"APP_GROUP_ID"
],
"native_keys": [
"TIME",
"TO_PHONE_NUMBER",
"TIMEZONE",
"FROM_PHONE_NUMBER",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
SEND_SHARED
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
// USERS_MESSAGES_WHATSAPP_SEND_SHARED
{
"primary_key": [
"ID"
],
"foreign_keys": [
"USER_ID",
"EXTERNAL_USER_ID",
"DEVICE_ID",
"APP_GROUP_API_ID",
"SUBSCRIPTION_GROUP_API_ID",
"CAMPAIGN_ID",
"CAMPAIGN_API_ID",
"MESSAGE_VARIATION_API_ID",
"CANVAS_ID",
"CANVAS_API_ID",
"CANVAS_VARIATION_API_ID",
"CANVAS_STEP_API_ID",
"CANVAS_STEP_MESSAGE_VARIATION_API_ID",
"DISPATCH_ID",
"APP_GROUP_ID"
],
"native_keys": [
"TIME",
"TO_PHONE_NUMBER",
"TIMEZONE",
"FROM_PHONE_NUMBER",
"MESSAGE_EXTRAS",
"SF_CREATED_AT",
"AD_ID",
"SEND_ID",
"LINK_ID",
"BUTTON_ID",
"SLIDE_ID"
]
}
Edit this page on GitHub
HOW HELPFUL WAS THIS PAGE?
New Stuff!