ㅇㅇㅇ
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