과제2
테이블 (9)
Characters
- CharacterID — NUMBER
- CharacterName — VARCHAR2(50) — NOT NULL
- UserID — NUMBER — NOT NULL
- ClassID — NUMBER — NOT NULL
- ServerID — NUMBER — NOT NULL
- Level — NUMBER
- ItemLevel — NUMBER
- CreationDate — DATE
- LastUpdateDate — DATE
Classes
- ClassID — NUMBER
- ClassName — VARCHAR2(50) — NOT NULL
- ClassType — VARCHAR2(20)
- Description — VARCHAR2(255)
Equipment
- EquipmentID — NUMBER
- CharacterID — NUMBER — NOT NULL
- SlotType — VARCHAR2(20) — NOT NULL
- ItemName — VARCHAR2(100)
- Quality — NUMBER
- EnhancementLevel — NUMBER
- EngravingInfo — VARCHAR2(500)
- EquipmentDate — DATE
Favorites
- FavoriteID — NUMBER
- UserID — NUMBER — NOT NULL
- CharacterID — NUMBER — NOT NULL
- AddedDate — DATE
GeneratedResults
- ResultID — NUMBER
- QueryID — NUMBER — NOT NULL
- GeneratedAnswer — CLOB — NOT NULL
- RelatedCharacterID — NUMBER
- GeneratedDate — DATE
- Rating — NUMBER
RAGQueries
- QueryID — NUMBER
- UserID — NUMBER — NOT NULL
- QueryText — CLOB — NOT NULL
- QueryDate — DATE
SearchHistory
- SearchID — NUMBER
- UserID — NUMBER — NOT NULL
- SearchKeyword — VARCHAR2(200) — NOT NULL
- SearchType — VARCHAR2(50)
- SearchDate — DATE
Servers
- ServerID — NUMBER
- ServerName — VARCHAR2(50) — NOT NULL
- Region — VARCHAR2(20) — NOT NULL
Users
- UserID — NUMBER
- Nickname — VARCHAR2(50) — NOT NULL
- Email — VARCHAR2(100) — NOT NULL
- Password — VARCHAR2(255) — NOT NULL
- RegistrationDate — DATE
- LastLoginDate — DATE