<p>Currently <b>hierarchies</b> are slapped onto the relations in the database. This is not really efficient.</p>

<p><b>Value list order</b>: The ordering should by stored in the NM_* tables</p>

<p><br>
see Forum thread <a href="https://forum.team-mediaportal.com/threads/mp-2-648-optimize-database-structure.136542/">https://forum.team-mediaportal.com/threads/mp-2-648-optimize-database-structure.136542/&lt;/a&gt;&nbsp;&lt;/p>