데이터베이스 실습
테이블 (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