과제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