DowaDream

DowaDream ERD

Tables (8)

Untitled (Review)

  • Key (rid) — INT — Primary key — NOT NULL
  • Field (title) — CHAR
  • Field (content) — LONGTEXT
  • Field (is_public) — TINYINT
  • Field (tag) — CHAR
  • Field (created_at) — DATETIME
  • Field (updated_at) — DATETIME
  • Key (uid) — INT — Foreign key → User.Key — NOT NULL
  • Key (pid) — INT — Foreign key → Untitled.Key — NOT NULL

Untitled (Image)

  • Key (image_id) — INT — Primary key — NOT NULL
  • Field (image) — VARCHAR
  • Key (rid) — INT — Foreign key → Untitled.Key — NOT NULL

Untitled (Comment)

  • Key (cid) — INT — Primary key — NOT NULL
  • Field (content) — LONGTEXT
  • Field (created_at) — DATETIME
  • Field (updated_at) — DATETIME
  • Key (rid) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (uid) — INT — Foreign key → User.Key — NOT NULL

Untitled (Program)

  • Key (pid) — INT — Primary key — NOT NULL

Untitled (User-Pro-CheerUp)

  • Key (uid) — INT — Foreign key → User.Key — NOT NULL
  • Key (pid) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (created_at) — DATETIME

Untitled (User-Pro-Participated)

  • Key (uid) — INT — Foreign key → User.Key — NOT NULL
  • Key (pid) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (created_at) — DATETIME

Untitled (User-Pro-Clipped)

  • Key (uid) — INT — Foreign key → User.Key — NOT NULL
  • Key (pid) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (created_at) — DATETIME

User

  • Key (uid) — INT — Primary key — NOT NULL
  • Field (username) — CHAR
  • Field (email) — CHAR
  • Field (profile_img) — VARCHAR
  • Field (date_joined) — DATETIME
  • Field (fighting) — INT
  • Field (tags) — VARCHAR
  • Field (regions) — VARCHAR