데이터베이스 과제_금융설계_ERD
테이블 (8)
[Answers] (CopyOf.)
- AnswerID (PK) (Key) — 기본 키 — NOT NULL
- AnswerText (Field2)
- CreationDate (Field3)
- QuestionID (PK) (Key2) — 외래 키 → [Questions].QuestionID (PK) — NOT NULL
[DocumentEmbeddings] (CopyOfCopyOfCopyOf.2)
- EmbeddingID (PK) (Key) — 기본 키 — NOT NULL
- EmbeddingVector (Field2)
- Dimension (Field3)
- EmbeddingType (Field4)
- CreationDate (Field5)
- DocumentID (PK) (Key2) — 외래 키 → [Documents].DocumentID (PK) — NOT NULL
[Documents] (CopyOfCopyOf.2)
- DocumentID (PK) (Key) — 기본 키 — NOT NULL
- Title (Field)
- Content(FK) (Field2)
- Source (Field3)
- CreationDate (Field4)
- LastUpdated (Field5)
[ModelPerformance] (CopyOfCopyOfCopyOfCopyOfCopyOf.2)
- PerformanceID (PK) (Key) — 기본 키 — NOT NULL
- ModelVersion (Field)
- Accuracy (Field2)
- Loss (Field3)
- EvaluationDate (Field4)
[ModelTrainingData] (CopyOfCopyOfCopyOfCopyOf.2)
- DataID (PK) (Key) — 기본 키 — NOT NULL
- UsageFlag (Field4)
- QuestionID (PK) (Key2) — 외래 키 → [Questions].QuestionID (PK) — NOT NULL
- AnswerID (PK) (Key3) — 외래 키 → [Answers].AnswerID (PK) — NOT NULL
- DocumentID (PK) (Key4) — 외래 키 → [Documents].DocumentID (PK) — NOT NULL
[Questions] (.)
- QuestionID (PK) (Key) — 기본 키 — NOT NULL
- QuestionText (Field2)
- CreationDate (Field3)
- UserID (PK) (Key2) — 외래 키 → [Users].UserID (PK) — NOT NULL
[UserFeedback] (CopyOf.2)
- FeedbackID (PK) (Key) — 기본 키 — NOT NULL
- Rating (Field3)
- Comments (Field4)
- AnswerID (PK) (Key2) — 외래 키 → [Answers].AnswerID (PK) — NOT NULL
- UserID (PK) (Key3) — 외래 키 → [Users].UserID (PK) — NOT NULL
[Users] (Untitled)
- UserID (PK) (Key) — 기본 키 — NOT NULL
- Username (Field)
- Email (Field2)
- PasswordHash (Field3)
- UserLevel (Field4)
- CreationDate (Field5)
- LastLogin (Field6)