realworld

Tables (8)

Copy Of user (CopyOfuser)

  • id — bigint — Primary key — NOT NULL
  • email — varchar(50) — NOT NULL
  • username — varchar(20) — NOT NULL
  • password — varchar(255) — NOT NULL
  • bio — varchar
  • image — varchar
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • deleted_at — DATETIME

article

  • id — bigint — Primary key — NOT NULL
  • author_id — bigint — Foreign key → user.id — NOT NULL
  • slug (sllug) — varchar(50) — NOT NULL
  • title — varchar(50) — NOT NULL
  • description — varchar(255) — NOT NULL
  • body — text — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • deleted_at — DATETIME

article_tag

  • article_id — bigint — Foreign key → article.id — NOT NULL
  • tag_id — bigint — Foreign key → tag.id — NOT NULL

comment

  • id — bigint — Primary key — NOT NULL
  • article_id — bigint — Foreign key → article.id — NOT NULL
  • user_id — bigint — Foreign key → user.id — NOT NULL
  • body — text — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • deleted_at — DATETIME

favorite

  • article_id — bigint — Foreign key → article.id — NOT NULL
  • users_id — bigint — Foreign key → user.id — NOT NULL

follow

  • user_id — bigint — Foreign key → user.id — NOT NULL
  • follow_id — bigint — Foreign key → user.id — NOT NULL

tag

  • id — bigint — Primary key — NOT NULL
  • name — varchar(20) — NOT NULL

user

  • id — bigint — Primary key — NOT NULL
  • email — varchar(50) — NOT NULL
  • username — varchar(20) — NOT NULL
  • password — varchar(255) — NOT NULL
  • bio — varchar
  • image — varchar
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • deleted_at — DATETIME