Input types

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

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"]
}

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

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

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

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

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

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

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