smartflow

Tables (3)

conversations

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

messages

  • id — BIGINT — Primary key — NOT NULL
  • conversation_id — BIGINT — Foreign key → conversations.id — NOT NULL
  • role — ENUM('USER','ASSISTANT') — NOT NULL
  • content — LONGTEXT — NOT NULL
  • mcp_tools_used — JSON
  • created_at — DATETIME — NOT NULL

users

  • id — BIGINT — Primary key — NOT NULL
  • google_id — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • profile_image_url — VARCHAR(500)
  • google_access_token — TEXT
  • google_refresh_token — TEXT
  • google_token_expires_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL