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