Protocol Designer

Design your data protocol to auto-generate database, API, validation, and UI components.

Add Field

Current Fields:

Protocol Preview

Untitled Protocol

Type: user

Variant: standard

Architecture: Single Table (Unified)

Fields: 0

Generated Schema

{
  "table": "items",
  "columns": [
    "id VARCHAR(36) PRIMARY KEY",
    "type VARCHAR(50) NOT NULL",
    "status VARCHAR(20) DEFAULT \"active\"",
    "variant VARCHAR(50)",
    "details JSON",
    "created_at DATETIME DEFAULT CURRENT_TIMESTAMP",
    "updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP",
    "created_by VARCHAR(36)",
    "updated_by VARCHAR(36)"
  ]
}

Database Schema (Single Table)

Table: items (unified table for all entity types)

Base columns:

  • id (UUID PRIMARY KEY)
  • type VARCHAR(50) = 'user'
  • status VARCHAR(20) DEFAULT 'active'
  • variant VARCHAR(50)
  • details JSON
  • created_at TIMESTAMP
  • updated_at TIMESTAMP
  • created_by VARCHAR(255)
  • updated_by VARCHAR(255)

Type-specific columns (prefixed with 'user_'):

    Query Example:

    api.com/query/user?tags=name=value