Hi, everyone.
Does anyone have the ER diagram of the database from MR?
I want to know in which tables are stored the companies, users and reports.
Thank you all.
*This post is locked for comments
Hi Ehecatl,
There are no known documentations about the MR table structure, not that I'm aware of and I already scoured the internet for it... You'll most likely have to figure it out on your own.. However, there aren't that many tables like in GP (about 150 only), and the names are pretty self explanatory.
The company table is called [ControlCompany], the users are stored in [SecurityUser] & [SecurityPrincipal]. The reports are stored in [ControlReport], but the difficulty is to track down all the relationships between the tables, as there is no table diagram and many tables have key fields that link together thru an ID Field... so it's very difficult to make the link.
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
