ㅇㅇㅇ

Tables (13)

Answer

  • AnswerID — PK, NOT NULL — Primary key — NOT NULL
  • QuestionID — NOT NULL — Foreign key → Question.QuestionID — NOT NULL
  • FieAnswerTextld (AnswerText) — NOT NULL — NOT NULL
  • GeneratedAt — DEFAULT CURRENT_TIMESTAMP — NOT NULL
  • DocumentIDs
  • ModelVersion
  • IsCached — DEFAULT FALSE — NOT NULL

Document

  • DocumentID — PK, NOT NULL — Primary key — NOT NULL
  • Title — NOT NULL — NOT NULL
  • Content — NOT NULL — NOT NULL
  • Source
  • League
  • CreatedAt — NOT NULL

DocumentEmbedding

  • EmbeddingID — PK, NOT NULL — Primary key — NOT NULL
  • DocumentID — NOT NULL — Foreign key → Document.DocumentID — NOT NULL
  • EmbeddingVector — NOT NULL
  • Dimension
  • EmbeddingModel
  • CreatedAt
  • IsOutdated

Feedback

  • FeedbackID — PK, NOT NULL — Primary key — NOT NULL
  • AnswerID — NOT NULL — Foreign key → Answer.AnswerID — NOT NULL
  • UserID — NOT NULL — Foreign key → User.UserID — NOT NULL
  • Rating
  • Type
  • Comment
  • IsManual
  • CreatedAt — NOT NULL

Match (Untitled3)

  • MatchID (Key) — PK, NOT NULL — Primary key — NOT NULL
  • MatchDate (Field) — NOT NULL — NOT NULL
  • HomeScore (Field2)
  • AwayScore (Field3)
  • HomeTeamID (Key2) — NOT NULL — Foreign key → Team.TeamID — NOT NULL
  • AwayTeamID (Key3) — NOT NULL — Foreign key → Team.TeamID — NOT NULL

ModelPerformance

  • PerformanceID — PK, NOT NULL — Primary key — NOT NULL
  • ModelVersion — NOT NULL
  • Accuracy — NOT NULL
  • Loss — NOT NULL
  • EvaluationDate — NOT NULL

ModelTrainingData

  • DataID — PK, NOT NULL — Primary key — NOT NULL
  • QuestionID — NOT NULL — Foreign key → Question.QuestionID — NOT NULL
  • AnswerID — NOT NULL — Foreign key → Answer.AnswerID — NOT NULL
  • DocumentID — NOT NULL — Foreign key → Document.DocumentID — NOT NULL
  • Label
  • UsedForTraining

Player (Untitled2)

  • PlayerID (Key) — PK, NOT NULL — Primary key — NOT NULL
  • TeamID (Key2) — NOT NULL — Foreign key → Team.TeamID — NOT NULL
  • PlayerName (Field) — NOT NULL — NOT NULL
  • Position (Field2)
  • BackNumber (Field3)

PlayerStat (Untitled4)

  • StatID (Key) — PK, NOT NULL — Primary key — NOT NULL
  • MatchID (Key2) — NOT NULL — Foreign key → Match.MatchID — NOT NULL
  • PlayerID (Key3) — NOT NULL — Foreign key → Player.PlayerID — NOT NULL
  • AtBats (Field)
  • Hits (Field2)
  • HomeRuns (Field3)
  • Strikeouts (Field4)

Question

  • QuestionID — PK, NOT NULL — Primary key — NOT NULL
  • UserID — NOT NULL — Foreign key → User.UserID — NOT NULL
  • QuestionText — NOT NULL — NOT NULL
  • QuestionType — NOT NULL
  • ContextTag — NOT NULL
  • CreatedAt — DEFAULT CURRENT_TIMESTAMP
  • ParentQuestionID — Foreign key → Question.QuestionID

SearchHistory (Untitled5)

  • SearchID (Key) — PK, NOT NULL — Primary key — NOT NULL
  • UserID — NOT NULL — Foreign key → User.UserID — NOT NULL
  • SearchTerm (Field) — NOT NULL — NOT NULL
  • SearchDate (Field2) — DEFAULT CURRENT_TIMESTAMP

Team (Untitled)

  • TeamID (Key) — PK, NOT NULL — Primary key — NOT NULL
  • TeamName (Field) — UNIQUE, NOT NULL — NOT NULL
  • HomeCity (Field2)
  • CoachName (Field3)

User

  • UserID — PK, NOT NULL — Primary key — NOT NULL
  • Email — UNIQUE, NOT NULL — NOT NULL
  • Password — NOT NULL — NOT NULL
  • Nickname — NOT NULL — NOT NULL
  • FavoriteTeam
  • FavoritePlayer
  • RegistrationDate — DEFAULT CURRENT_TIMESTAMP — NOT NULL
  • LastLogin