Search code examples
identityserver4

Is there a good article/document describing how IdentityServer4 data tables and columns work together?


I have successfully setup IdentityServer by following quickstart samples. But what I am still unclear is how the IdentityServer data tables and columns work. I have about 30 tables created along the way (some of those are ASP.Net Core Identity related tables) and they work fine. But the IdentityServer online doc doesn't seem to contain a good detailed description about how they work together. Can someone point me to some good resource explaining the internal work? enter image description here


Solution

  • Most of the columns and tables maps directly 1-1 with the configuration objects in IdentityServer. Including the Client and the Resource types. However, as some of the types are pretty complex, they are normalized across several tables. You can also look at the source of the IdentityServer storage library to see how the database is mapped to those objects.