Database Schema

Description of issue or problem I’m having:

I’m trying to manually query the database and I can’t seem to find the relationship between the discussions in the production stage to the submission. In MySQL tables, how can I connect the items from the ‘notes’ table to the ‘submission’ specifically to submission_id

Steps I took leading up to the issue:

Manual inspection of the database

Application Version - e.g., OJS 3.1.2:

OJS 3.3.0

Additional information, such as screenshots and error log messages if applicable:

I need to connect these discussions to a submission via MySQL queries