Schema Patterns
- Use
uuidprimary keys for portability - Mark sensitive columns
masked: true - Use
textfor FTS andvectorfor embeddings - For geoshapes, store bounding boxes
{ minX, minY, maxX, maxY }in ajsoncolumn to enable R‑Tree
uuid primary keys for portabilitymasked: truetext for FTS and vector for embeddings{ minX, minY, maxX, maxY } in a json column to enable R‑Tree