Field Types Reference

int id              // An auto-incrementing primary key
int age             // A field for storing age values
int product_count   // A field for tracking quantity

text description    // A text field for storing descriptions
text user_bio      // A text field for user biographies
text address       // A text field for storing addresses

bool is_active     // A boolean field for active status
bool is_verified   // A boolean field for verification status
bool has_premium   // A boolean field for premium features

timestamp created_at      // Timestamp for record creation
timestamp last_login     // Timestamp for user's last login
timestamp expires_at     // Timestamp for expiration date

decimal price           // A decimal field for prices
decimal temperature    // A decimal field for temperature values
decimal gpa            // A decimal field for grade point average

enum status {          // An enum field for status options
  values = ["pending", "active", "completed"]
}
enum role {           // An enum field for user roles
  values = ["admin", "user", "guest"]
}
enum size {           // An enum field for size options
  values = ["small", "medium", "large"]
}

uuid session_id      // A UUID field for session identification
uuid device_id       // A UUID field for device identification
uuid token           // A UUID field for unique tokens

object settings {     // An object field for user settings
  schema = {
    theme: "string",
    notifications: "boolean"
  }
}
object address {      // An object field for address details
  schema = {
    street: "string",
    city: "string",
    zip: "string"
  }
}

json metadata       // A JSON field for flexible metadata storage
json preferences    // A JSON field for user preferences
json custom_data    // A JSON field for arbitrary data

vector embedding     // A vector field for ML embeddings
vector coordinates  // A vector field for spatial coordinates
vector features     // A vector field for feature vectors

date birth_date     // A date field for birthdays
date start_date    // A date field for event start
date due_date      // A date field for task deadlines

email user_email    // An email field for user contact
email support_email // An email field for support contact
email backup_email  // An email field for backup contact

password user_password {     // A password field for user authentication
  sensitive = true
}
password api_key {          // A password field for API authentication
  sensitive = true
}

image profile_pic   // An image field for profile pictures
image banner       // An image field for banner images
image thumbnail    // An image field for thumbnail images

video tutorial      // A video field for tutorial content
video promo        // A video field for promotional content
video recording    // A video field for recorded content

audio podcast      // An audio field for podcast episodes
audio message     // An audio field for voice messages
audio music       // An audio field for music tracks

attachment document    // An attachment field for documents
attachment resume     // An attachment field for resumes
attachment contract   // An attachment field for contracts

geo_point location     // A geo point field for single locations
geo_point store       // A geo point field for store location
geo_point checkpoint  // A geo point field for route checkpoints

geo_point_collection locations    // A collection of location points
geo_point_collection waypoints   // Multiple waypoints for a route
geo_point_collection hotspots    // Multiple points of interest

geo_path route        // A path field for route tracking
geo_path trail       // A path field for hiking trails
geo_path boundary    // A path field for boundary lines

geo_path_collection routes      // Multiple routes collection
geo_path_collection boundaries // Multiple boundary lines
geo_path_collection networks   // Network of paths

geo_polygon area        // A polygon field for area definition
geo_polygon territory   // A polygon field for territory bounds
geo_polygon zone        // A polygon field for zone definition

geo_polygon_collection regions    // Multiple region polygons
geo_polygon_collection districts  // Multiple district areas
geo_polygon_collection zones      // Multiple zone definitions