How to avoid table duplication in MySQL
<p>I don't know much about MySQL, and I'm in the following situation:</p>

<ul>
<li>An <em>Artist</em> table, with an id and a string</li>
<li>A <em>Level</em> table, with an id and a string</li>
<li>A <em>Style</em> table, with an id and a string</li>
</ul>

<p>Then, I have 3 tables that are completely identical :</p>

<ul>
<li>A <em>Fill</em> table, with some custom fields + referencing the 3 tables above</li>
<li>A <em>Beat</em> table, with some custom fields + referencing the 3 tables above</li>
<li>A <em>Sheet</em> table, with some custom fields + referencing the 3 tables above</li>
</ul>

<p>The only difference between those 3 last tables is that they won't be treated the same way on the front-end part (one category for each kind).</p>

<p>Thus, I was wondering if there's any better solution that just having 3 completly identical tables in MySQL. I thought about doing a <em>"pivot"</em> table with 3 boolean columns (is_beat, is_fill and is_sheet that would be mutually exclusive), yet I have no idea if it's the right way to do it.</p>