Naming Standards - Database - HL Vanilla Community
<main> <article class="userContent"> <p>The original database naming standard in Vanilla was <code class="code codeInline" spellcheck="false" tabindex="0">CapitalCase</code>. This was inline with coding standards implemented at the beginning of the project. However, Vanilla has moved on. Following the events of The Casening, where most of the project was updated to <code class="code codeInline" spellcheck="false" tabindex="0">camelCase</code>, <strong>new</strong> database tables will share the same style used by most of Vanilla’s codebase. Existing tables will remain in <code class="code codeInline" spellcheck="false" tabindex="0">CapitalCase</code>, as will all their columns, new or existing.</p><p>Vanilla’s API request and response standards require <code class="code codeInline" spellcheck="false" tabindex="0">camelCase</code>. Having database tables that are at odds with this requirement means additional transformations of every request and response. Moving forward, these types of transformations will be unnecessary and not used for new resources, since they will adhere to the same naming standard.</p><h2 data-id="1.-overview">1. Overview</h2><ul><li>Database tables MUST be named in <code class="code codeInline" spellcheck="false" tabindex="0">camelCase</code>.</li><li>Database columns MUST be named in <code class="code codeInline" spellcheck="false" tabindex="0">camelCase</code>.</li></ul><p><br></p> </article> </main>