데이터베이스 실습

테이블 (6)

Diaries

  • Key (DiaryID) — NUMBER — 기본 키 — NOT NULL
  • Field2 (Content) — CLOB
  • Field (WriteDate) — DATE
  • Field2 (EmotionSummary) — VARCHAR(255)
  • Key (UserID) — NUMBER — 외래 키 → Users.Key — NOT NULL

Emotions

  • Key (EmotionID) — NUMBER — 기본 키 — NOT NULL
  • Field2 (EmotionType) — VARCHAR(500)
  • Field3 (Intensity) — NUMBER(3,2)
  • Key (DiaryID) — NUMBER — 외래 키 → Diaries.Key — NOT NULL

Feedback

  • Key (FeedbackID) — NUMBER — 기본 키 — NOT NULL
  • Field2 (Rating) — NUMBER(1)
  • Field3 (FeedbackText) — VARCHAR2(500)
  • Field4 (FeedbackDate) — DATE
  • Key (AdviceID) — NUMBER — 외래 키 → GeneratedAdvice.Key — NOT NULL

GeneratedAdvice

  • Key (AdviceID) — NUMBER — 기본 키 — NOT NULL
  • Field2 (AdviceText) — CLOB
  • Field3 (GeneratedDate) — DATE
  • Key (QuestionID) — NUMBER — 외래 키 → Questions.Key — NOT NULL

Questions

  • Key (QuestionID) — NUMBER — 기본 키 — NOT NULL
  • Field2 (QuestionText) — VARCHAR(500)
  • Field3 (AskDate) — DATE
  • Key (UserID) — NUMBER — 외래 키 → Users.Key — NOT NULL

Users

  • Key (UserID) — Number — 기본 키 — NOT NULL
  • Field (Name) — VARCHAR2(100)
  • Field2 (Email) — VARCHAR2(100)
  • Field (Password) — VARCHAR2(100)
  • Field2 (RegistrationDate) — DATE