Hello,
After installing ASP.NET APP Zero I was able to pull in all of the tables created in the TCReportingServiceDb database. I pulled in all the tables into a new Database Diagram and noticed about one third of the tables had no referential integrity. Is there a complete diagram available?
Thanks, Will
5 Answer(s)
-
0
hi
can you give us more information with Table names and related record?
-
0
Hello,
Attached is a diagram of the current set of tables in the TCReportingServiceDb database. Are there plans to complete the references from primary keys to the foreign keys?
Thanks, Will
-
0
Hi @tcon,
We haven't add reference to user because user entity is abstract. If you can share a few specific examples, we will consider them one by one.
Thanks.
-
0
For example, can you confirm the relationship between dbo.AbpOrganizationUnits, dbo.AbpUserOrganizationUnits and dbo.AbpUsers? Per the data model diagram, there are no defined relationships between these tables but looking at the table fields, we are assuming there is a PK / FK relationship based on AbpOrganizationUnits.Id to AbpUserOrganizationUnits.OrganizationUnitId and then AbpUserOrganizationUnits.UserId to AbpUsers.Id.
-
0
Hi,
UserOrganizationUnit entity is defined in ABP framework, see <a class="postlink" href="https://github.com/aspnetboilerplate/aspnetboilerplate/blob/dev/src/Abp.Zero.Common/Authorization/Users/UserOrganizationUnit.cs">https://github.com/aspnetboilerplate/as ... ionUnit.cs</a>
Also AbpUser entity is abstract and if we add a reference to it on UserOrganizationUnit entity, we must make it abstract as well and we don't want to do this.
You can extend related entities in your project and add needed references as you like (<a class="postlink" href="https://aspnetzero.com/Documents/Extending-Existing-Entities">https://aspnetzero.com/Documents/Extend ... g-Entities</a>).
Thanks.
