REVThing

Tables (7)

Untitled (article_like)

  • Key (id) — bigint(20) — Primary key — NOT NULL
  • id (user_id) — uuid — Foreign key → user.id — NOT NULL
  • Key (article_id) — bigint(20) — Foreign key → article.Key — NOT NULL

Untitled (follow)

  • Key (id) — bigint(20) — Primary key — NOT NULL
  • id (user_id) — uuid — Foreign key → user.id — NOT NULL
  • id (following_id) — uuid — Foreign key → user.id — NOT NULL

Untitled (auth_token)

  • Key (id) — uuid — Primary key — NOT NULL
  • id (auth_id) — uuid — Foreign key → user.id — NOT NULL
  • Field (refresh_token) — varchar(255) — NOT NULL

article (review)

  • Key (id) — bigint(20) — Primary key — NOT NULL
  • Field (create_date) — timestamp — NOT NULL
  • Field (update_date) — timestamp — NOT NULL
  • Field (max_id) — bigint(20) — NOT NULL
  • id (author_id) — uuid — Foreign key → user.id — NOT NULL
  • Field (title) — varchar(255) — NOT NULL
  • Field (content) — longtext — NOT NULL
  • Field (view_count) — bigint(20) — NOT NULL
  • Field (like_count) — bigint(20) — NOT NULL
  • Field (publish_date) — timestamp — NOT NULL
  • Field (is_temp) — bit(1) — NOT NULL
  • Field (selected) — bit(1) — NOT NULL

article_sequence

  • id (user_id) — uuid — Foreign key → user.id — NOT NULL
  • Field (max_article_id) — bigint(20) — NOT NULL

avatar (user_profile)

  • id (user_id) — uuid — Foreign key → user.id — NOT NULL
  • Field (last_update_date) — timestamp — NOT NULL
  • Field (description) — varchar(255)
  • Field (avatar) — varchar(255) — NOT NULL

user

  • id — uuid — Primary key — NOT NULL
  • create_date — timestamp — NOT NULL
  • Field (update_date) — timestamp — NOT NULL
  • Field (email) — varchar(255) — NOT NULL
  • Field (password) — varchar(255)
  • username — varchar(15)
  • Field (provider) — varchat(20)