first erd
Tables (8)
Untitled (Anime)
- Key (animeID) — INT — Primary key — NOT NULL
- Field (joinDate) — DATE
- Field2 (updateDate) — DATE
- Field (title) — VARCHAR
- Field (story) — TEXT
- Field (studio) — VARCHAR
- Field (genre) — VARCHAR
- Field (airDate) — DATE
- Field (seriesInfo) — VARCHAR
- Key (reviewID) — INT — Foreign key → Untitled.Key — NOT NULL
Untitled (WatchList)
- Key (watchListID) — INT — Primary key — NOT NULL
- Field (joinDate) — DATE
- Field (updateDate) — DATE
- Field (userID) — INT
- Field (animeID) — INT
- Field (status) — ENUM
- Field (currentEpisode) — INT
- Key (userID2) — INT — Foreign key → User.Key — NOT NULL
- Key (animeID2) — INT — Foreign key → Untitled.Key — NOT NULL
Untitled (Review)
- Key (reviewID) — INT — Primary key — NOT NULL
- Field (joinDate) — DATE
- Field2 (updateDate) — DATE
- Field (userID) — INT
- Field (animeID) — INT
- Field2 (episodeID) — INT
- Field3 (content) — TEXT
- Field4 (rating) — INT
- Field3 (isPublic) — BOOLEAN
- Field (isSpoiler) — BOOLEAN
- Key (userID2) — INT — Foreign key → User.Key — NOT NULL
- Key (episodeID2) — INT — Foreign key → Untitled.Key — NOT NULL
Untitled (Tag)
- Key (tagID) — INT — Primary key — NOT NULL
- Field (joinDate) — DATE
- Field (updateDate) — DATE
- Field (tagName) — VARCHAR
- Key (animeID) — INT — Foreign key → Untitled.Key — NOT NULL
Untitled (Cast)
- Key (castID) — INT — Primary key — NOT NULL
- Field (joinDate) — DATE
- Field (updateDate) — DATE
- Field (name) — VARCHAR
- Field (role) — VARCHAR
- Key (animeID) — INT — Foreign key → Untitled.Key — NOT NULL
Untitled (OST)
- Key (musicID) — INT — Primary key — NOT NULL
- Field (joinDate) — DATE
- Field2 (updateDate) — DATE
- Field (title) — VARCHAR
- Field2 (artist) — VARCHAR
- Field (releaseDate) — DATE
- Key (animeID) — INT — Foreign key → Untitled.Key — NOT NULL
Untitled (Episode)
- Key (episodeID) — INT — Primary key — NOT NULL
- Field (joinDate) — DATE
- Field (updateDate) — DATE
- Field (title) — VARCHAR
- Field (episodeNumber) — INT
- Field (airDate) — DATE
- Key (animeID) — INT — Foreign key → Untitled.Key — NOT NULL
User (UserID)
- Key (userID) — INT — Primary key — NOT NULL
- Field2 (joinDate) — DATE
- Field (updateDate) — DATE
- Field (nickname) — VARCHAR
- Field (email) — VARCHAR
- Field2 (password) — VARCHAR
- Field (isWatchPublic) — BOOLEAN
- Field (isReviewPublic) — BOOLEAN