web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Apps
Answered

Standard tables

(0) ShareShare
ReportReport
Posted on by 307

I've been trying to find some kind of explanation as to the design and intended use/function of the included tables...

 

I'd rather not reinvent the wheel, and absent any better explanation than what I have found, I'll be OK. It's just that someone put all this effort into these standard tables I would expect to find a resource explaining the intended function(s)

 

EG:

In my original DB schema I had a table for a COMPANY, and companies have LOCATIONS, locations have an ADDRESS and a PHONE number. A CONTACT is tied to a LOCATION, and might have an additional ADDRESS or PHONE... you get the idea. Well there is a standard ACCOUNT table, but no LOCATION table, so I decided to just use another ACCOUNT, and add a field to relate them. As I look through the default tables I'd just like to find a resource that covers them from a conceptual perspective, not just the field details etc. I find, for example, here: https://learn.microsoft.com/en-us/common-data-model/schema/core/applicationcommon/foundationcommon/crmcommon/projectcommon/contact

 

If there isn't anything better OK, just hoping there is. 

Categories:
I have the same question (0)
  • Verified answer
    Pstork1 Profile Picture
    69,129 Most Valuable Professional on at

    Microsoft uses the Common Data Model tables in several different applications, so there isn't really one easy diagram that shows what all the tables are for. But this may help.  There is a navigator that will show you graphically how the tables are related in different applications. You can find a link to it and an explanation here: Table schemas in Common Data Model - Dynamics 365 Customer Insights | Microsoft Learn

  • STS1SS Profile Picture
    307 on at

    This is great... I'm not sure I can do any better than this, thanks for the reply

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 536

#2
WarrenBelz Profile Picture

WarrenBelz 426 Most Valuable Professional

#3
Haque Profile Picture

Haque 305

Last 30 days Overall leaderboard