데이터베이스 과제_금융설계_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)