Sswaroop

Hi All, I'm trying to find metrics related to Reactions - How many reactions for each post/comment & Top 10 posts/comments with max number of reactions of a particular type. I'm trying to understand how I can connect relations to posts/comments in the Mysql database. I could only find Core_Reactions which has the list of all the reactions. How can I tie this to posts/comments? Also, in the Forums_Forums table what does the fields skin_id and parent_id represents?

Hi All, We are using a self hosted install for Invision platform. After we installed the software, When I looked at the tables through phpmyadmin, I do not see any foreign keys on the tables. I saw that all the tables are running on InnoDB. Do I have to create the foreign keys manually myself. Are these not defined by default? Is there any available document that shows how the tables are linked to each other?

I will verify if there is a separate instance for community with my hosting company. We are a self hosted customer.

Thank you @bfarber. The ideas here was to see if there's any data definition document. I just used some general cases to help understand the question better. We are still in the design phase now. Once we develop the exact questions I will post them with more information.

Thank you so much Paul. I don't have access to source code. I'll check with my hosting company. Thanks for advising on the reporting instance as well.

Hi all, I'm totally new to invision and need help understand the data storage and connection options. We are using Forums and pages from Invision line of products. Our hosting company loads the invision data into MYSQL database on AWS. There are nearly 100 tables. We use powerBI as a reporting tool for our org. We want to connect our powerBI with the invision data for reporting. Below are some of the reporting use cases: Top 10 posts as per comments/reactions/voteups Trending last month/year Top 10 active users I need to understand which tables holds the required data for analysis. I have created a support ticket but didn't receive any helpful output. Is there any document/article that describes the tables and data that is held in them and also is there any ERD that shows how the tables are connected together.