# attributes
<table>
    <thead>
        <tr>
            <th>Column Name</th>
            <th>Data Type</th>
            <th>Nullity</th>
            <th>Default value</th>
            <th>Description</th>
        </tr>
    </thead>
    <tbody>
        <tr>
            <th><code>attributeId</code></th>
            <td>Text</td>
            <td>Non-null</td>
            <td>&nbsp;</td>
            <td>Unique Id of the attribute (e.g. <code>qhC1vzU4nwSE</code>), can also have a special unique ID for&nbsp;<a class="reference-link" href="#root/r11Bh3uxFGRj">Special notes</a>&nbsp;(e.g. <code>_lbToday_liconClass</code>).</td>
        </tr>
        <tr>
            <th><code>noteId</code></th>
            <td>Text</td>
            <td>Non-null</td>
            <td>&nbsp;</td>
            <td>The ID of the <a href="notes.md">note</a> this atttribute belongs to</td>
        </tr>
        <tr>
            <th><code>type</code></th>
            <td>Text</td>
            <td>Non-null</td>
            <td>&nbsp;</td>
            <td>The type of attribute (<code>label</code> or <code>relation</code>).</td>
        </tr>
        <tr>
            <th><code>name</code></th>
            <td>Text</td>
            <td>Non-null</td>
            <td>&nbsp;</td>
            <td>The name/key of the attribute.</td>
        </tr>
        <tr>
            <th><code>value</code></th>
            <td>Text</td>
            <td>Non-null</td>
            <td><code>""</code></td>
            <td><ul><li>For <code>label</code> attributes, a free-form value of the attribute.</li><li>For <code>relation</code> attributes, the ID of the <a href="notes.md">note</a> the relation is pointing to.</li></ul></td>
        </tr>
        <tr>
            <th><code>position</code></th>
            <td>Integer</td>
            <td>Non-null</td>
            <td>0</td>
            <td>The position of the attribute compared to the other attributes. Some predefined attributes such as <code>originalFileName</code> have a value of 1000.</td>
        </tr>
        <tr>
            <th><code>utcDateModified</code></th>
            <td>Text</td>
            <td>Non-null</td>
            <td>&nbsp;</td>
            <td>Modification date in UTC format (e.g. <code>2023-11-08 16:43:44.204Z</code>)</td>
        </tr>
        <tr>
            <th><code>isDeleted</code></th>
            <td>Integer</td>
            <td>Non-null</td>
            <td>&nbsp;</td>
            <td><code>1</code> if the entity is <a href="../../../Concepts/Deleted%20notes.md">deleted</a>, <code>0</code> otherwise.</td>
        </tr>
        <tr>
            <th><code>deleteId</code></th>
            <td>Text</td>
            <td>Nullable</td>
            <td><code>null</code></td>
            <td>&nbsp;</td>
        </tr>
        <tr>
            <th><code>isInheritable</code></th>
            <td>Integer</td>
            <td>Nullable</td>
            <td>0</td>
            <td>&nbsp;</td>
        </tr>
    </tbody>
</table>