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