Forum Discussion
Unable to get Primary Keys in the tables
I am not able to get primary key in EmailDelivered , EmailOpened , EmailSent , FormSubmitted , FormVisited , WebsiteVisited .
Below is the reference of one of the Table nad other tables are also present in this :
https://learn.microsoft.com/en-us/common-data-model/schema/core/applicationcommon/foundationcommon/crmcommon/solutions/customerinsightsjourneys/emaildelivered
Could you please help me in finding primary key in these tables.
Have you ever faced this issue? what should you suggest in this case.
1 Reply
- ThomasKingIron Contributor
Many of these tables are external or system tables that do not have a primary key defined in the traditional sense. For example, in the EmailDelivered and similar tables, the combination of fields (like message ID, timestamp, recipient, etc.) often serve as a composite key, but there may not be a single explicit primary key column.