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