chatapi

Tables (3)

conversation

  • ID (id) — LONG — Primary key — NOT NULL
  • userId — LONG — Foreign key — NOT NULL
  • last_summarized_message_id — LONG — Foreign key
  • title — VARCHAR(255) — NOT NULL
  • summary — TEXT
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

message

  • ID (id) — LONG — Primary key — NOT NULL
  • conversationId — LONG — Foreign key — NOT NULL
  • role — ENUM — NOT NULL
  • content — TEXT — NOT NULL
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

users

  • ID (id) — LONG — Primary key — NOT NULL
  • apiKey — VARCHAR(128) — NOT NULL
  • apiKeyEnc — TEXT — NOT NULL
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP