RaidFinder

Tables (8)

Raids

  • Key (Id) — BIGINT(20) — Primary key — NOT NULL
  • Key (ElementId) — BIGINT(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (Name_JP) — VARCHAR(255) — NOT NULL
  • Field (Name_EN) — VARCHAR(255) — NOT NULL
  • Field (Name_KO) — VARCHAR(255) — NOT NULL
  • Field (Level) — INT(20) — NOT NULL
  • Field (Image) — VARCHAR(255)
  • Field (IsEnable) — BOOLEAN — NOT NULL

Untitled (Tags)

  • Key (Id) — BIGINT(20) — Primary key — NOT NULL
  • Field (Name) — VARCHAR(20) — NOT NULL
  • Field (IsEnable) — BOOLEAN — NOT NULL

Untitled (RaidTags)

  • Key (Id) — BIGINT(20) — Primary key — NOT NULL
  • Key (RaidId) — BIGINT(20) — Foreign key → Raids.Key — NOT NULL
  • Key (TagId) — BIGINT(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (IsEnable) — BOOLEAN — NOT NULL

Untitled (Users)

  • Key (Id) — BIGINT(20) — Primary key — NOT NULL
  • Field (Name) — VARCHAR(255) — NOT NULL
  • Field (AdminLevel) — ENUM(USER,MODERATOR,ADMIN) — NOT NULL
  • Field (IsEnable) — BOOLEAN — NOT NULL

Untitled (Tokens)

  • Key (Id) — BIGINT(20) — Primary key — NOT NULL
  • Key (UserId) — BIGINT(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (Type) — ENUM — NOT NULL
  • Field (Token) — VARCHAR(255) — NOT NULL
  • Field (ExpireAt) — DATETIME — NOT NULL

Untitled (TagAliases)

  • Key (Id) — BIGINT(20) — Primary key — NOT NULL
  • Key (TagId) — BIGINT(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (Alias) — VARCHAR(255) — NOT NULL
  • Field (IsEnable) — BOOLEAN — NOT NULL

Untitled (Categories)

  • Key (Id) — BIGINT(20) — Primary key — NOT NULL
  • Key (TagId) — BIGINT(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (Order) — BIGINT(20) — NOT NULL
  • Field (Difficulty) — BIGINT(20) — NOT NULL
  • Field (IsEnable) — BOOLEAN — NOT NULL

Untitled (Elements)

  • Key (Id) — BIGINT(20) — Primary key — NOT NULL
  • Key (TagId) — BIGINT(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (Image) — VARCHAR(255) — NOT NULL