llm entity

Tables (4)

ChatHistory (Untitled3)

  • id (Key) — int — Primary key — NOT NULL
  • conversationId (Key2) — int — Foreign key → Conversation.id — NOT NULL
  • userId (Field) — int
  • message (Field2) — TEXT
  • sender (Field3) — ENUM('user','assistant')
  • createdAt (Field4) — DATETIME

Conversation (Untitled)

  • id (Key) — int — Primary key — NOT NULL
  • userId (Key2) — int — Foreign key → User.id — NOT NULL
  • situation (Field2) — String
  • startedAt (Field3) — DATETIME
  • endedAt (Field4) — DATETIME

Correction (Untitled4)

  • id (Key) — int — Primary key — NOT NULL
  • chathistoryId (Key2) — int — Foreign key → ChatHistory.id — NOT NULL
  • correction (Field2) — TEXT
  • createdAt (Field3) — DATETIME

User (Untitled2)

  • id (Key) — int — Primary key — NOT NULL
  • userId — varchar(255)
  • name (Field) — varchar(255)
  • password (Field2) — varchar(255)
  • email (Field3) — varchar(255)
  • createdAt (Field4) — DATETIME
  • updatedAt (Field5) — DATETIME