rocket

Tables (3)

conversations

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

messages

  • id — BIGINT — Primary key — NOT NULL
  • conversation_id — BIGINT — Foreign key → conversations.id — NOT NULL
  • role — ENUM — NOT NULL
  • content — TEXT — NOT NULL
  • createdAt (created_at) — DATETIME(6) — NOT NULL
  • updatedAt — DATETIME(6)

users

  • id — BIGINT — Primary key — NOT NULL
  • apiKey — VARCHAR(128) — NOT NULL
  • apiKeyEnc — TEXT
  • createdAt (created_at) — DATETIME(6) — NOT NULL
  • updatedAt (updated_at) — DATETIME(6) — NOT NULL