Forum Stats

  • 3,767,923 Users
  • 2,252,730 Discussions
  • 7,874,380 Comments

Discussions

Reporting Schema

jflack
jflack Member Posts: 1,516 Bronze Trophy

Is there a database diagram for the SDDM Reporting Repository?  I'm having trouble finding the relationships, and there don't seem to be many FKs defined.

My immediate problem is finding the intersection table between DMRS_ENTITIES and DMRS_MODEL_SUBVIEWS - I want to list the entities by subview.

But generally, it would help me to write some custom reports in SQL Developer, it I knew what tables to join.

Best Answer

Answers

This discussion has been closed.