Base solution for your next web application
Open Closed

Database Diagram #3895


User avatar
0
tcon created

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)
  • User Avatar
    0
    alper created
    Support Team

    hi

    can you give us more information with Table names and related record?

  • User Avatar
    0
    tcon created

    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

  • User Avatar
    0
    ismcagdas created
    Support Team

    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.

  • User Avatar
    0
    tcon created

    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.

  • User Avatar
    0
    ismcagdas created
    Support Team

    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.