Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Delivery ID and broadLog ID

priyankah586599
Level 4
Level 4

Hi,

How is delivery ID different from broadLog ID?

Regards,

Priyanka

1 Accepted Solution
Adhiyan
Correct answer by
Employee
Employee

Hello Priyanka,

Delivery ID - Primary key or Unique identifier of the delivery . A delivery may contain multiple recipients and correspondingly multiple delivery log entries.

BroadLog iD : The primary key for each delivery log sent to recipients.

Eaxmple : Say you have sent an Delivery to 100 recipients . It will have one delivery ID and 100 BroadLog IDs.

Regards,
Adhiyan

View solution in original post

6 Replies
Adhiyan
Correct answer by
Employee
Employee

Hello Priyanka,

Delivery ID - Primary key or Unique identifier of the delivery . A delivery may contain multiple recipients and correspondingly multiple delivery log entries.

BroadLog iD : The primary key for each delivery log sent to recipients.

Eaxmple : Say you have sent an Delivery to 100 recipients . It will have one delivery ID and 100 BroadLog IDs.

Regards,
Adhiyan

View solution in original post

priyankah586599
Level 4
Level 4

Hi Adhiya,

Thank you. Which schema has broadLog ID and tracking details together?

Regards,

Priyanka

Adhiyan
Employee
Employee

Hi Priyanka,

The Schema broadLogRcp has all the details about the BroadLog and this is linked 1:N to TrackingLog . so you can get all the information from here.

1416447_pastedImage_0.png

Regards,
Adhiyan

priyankah586599
Level 4
Level 4

Thanks Adhiyan. I just have one more question may be related or unrelated to this thread. I wanted to know which is the broadLog ID in

1.eventHisto table

2.trackingLogEventHisto table

Regards,

Priyanka

Adhiyan
Employee
Employee

Hello Priyanka,

BroadLog ID is the primary key for the broadLogRcp table . Similarly , for eventHisto the BroadLogId would be the primary key of that table.

In the same way the primary key of trackingLogEventHisto table would be the broadLog ID.

Regards,

Adhiyan