tenryu

<p>業務でテーブル設計をする際、真偽値カラムのデータ型はbooleanとintどちらにすべきか悩んだ</p>


<p><img src="https://storage.googleapis.com/zenn-user-upload/fb377674479e-20230419.png" alt loading="lazy" class="md-img"></p>
<p>「tinyint(1)が一般的！boolean の方がわかりやすいかもだけど、ストレージとメモリの量が増加するよ！」とのこと</p>


<p>Laravelのマイグレーションでbooleanを指定すると、内部的にtinyint(1)になっているらしく、trueやfalseがinsertできないっぽい<br style="display:none">
<span class="embed-block zenn-embedded zenn-embedded-card"><iframe id="zenn-embedded__da43901781ca4" src="https://embed.zenn.studio/card#zenn-embedded__da43901781ca4" data-content="https%3A%2F%2Fbiz.addisteria.com%2Flaravel_boolean_tinyint%2F" frameborder="0" scrolling="no" loading="lazy"></iframe></span><a href="https://biz.addisteria.com/laravel_boolean_tinyint/" style="display:none" target="_blank" rel="nofollow noopener noreferrer">https://biz.addisteria.com/laravel_boolean_tinyint/</a></p>


<p>そもそもMySQLが内部的にbooleanをtinyint(1)にしているらしい<br style="display:none">
<span class="embed-block zenn-embedded zenn-embedded-card"><iframe id="zenn-embedded__6a99445a7752f" src="https://embed.zenn.studio/card#zenn-embedded__6a99445a7752f" data-content="https%3A%2F%2Fstyle.potepan.com%2Farticles%2F19228.html" frameborder="0" scrolling="no" loading="lazy"></iframe></span><a href="https://style.potepan.com/articles/19228.html" style="display:none" target="_blank" rel="nofollow noopener noreferrer">https://style.potepan.com/articles/19228.html</a></p>
