To make it easier to understand the correlation between each table and view, we have prepared an ER diagram that shows the relationship between each table.
Image Change

※ Clicking on the image will take you to an external site (DrawSQL) where you can zoom in or out of the figure.