quot;VAR&quot;)

# Add records
f.set(&quot;order_001&quot;, 1001, &quot;customer_id&quot;)
f.set(&quot;order_001&quot;, 299.99, &quot;amount&quot;)
f.set(&quot;order_001&quot;, &quot;pending&quot;, &quot;status&quot;)
</code></pre></div>
<h3 id="column-store-pattern-analytical">Column Store Pattern (Analytical)</h3>
<div class="highlight"><pre><span></span><code># Create column store database
f.mk(&quot;sales_analytics&quot;, &quot;COL&quot;)
f.cd(&quot;sales_analytics&quot;)

# Define schema
f.mkfield(&quo