realworld

Tables (7)

article (Untitled3)

  • id (Key) — Long — Primary key — NOT NULL
  • slug (Field) — String
  • title (Field2) — String
  • description (Field3) — String
  • body (Field4) — String
  • createdAt (Field5) — TimeStamp
  • updatedAt (Field6) — TimeStamp
  • favoritesCount (Field7) — long

article_tag (Untitled6)

  • id (Key3) — Primary key — NOT NULL
  • article_id (Key) — Long — Foreign key → article.id — NOT NULL
  • tag_id (Key2) — Long — Foreign key → tag.id — NOT NULL

comment (Untitled7)

  • id (Key) — Long — Primary key — NOT NULL
  • body (Field) — String
  • createdAt (Field4) — TimeStamp
  • updatedAt (Field2) — TimeStamp
  • user_id (Key2) — Long — Foreign key → user.id — NOT NULL
  • article_id (Key3) — Long — Foreign key → article.id — NOT NULL

favorite_article (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → user.id — NOT NULL
  • article_id (Key3) — Long — Foreign key → article.id — NOT NULL

follow (Untitled2)

  • id (Key3) — Primary key — NOT NULL
  • follower_id (Key) — Long — Foreign key → user.id — NOT NULL
  • following_id (Key2) — Long — Foreign key → user.id — NOT NULL

tag (Untitled5)

  • id (Key) — Long — Primary key — NOT NULL
  • name (Field) — String

user (Untitled)

  • id (Key) — Long — Primary key — NOT NULL
  • email (Field) — String
  • username (Field2) — String
  • bio (Field3) — String
  • image (Field4) — String
  • createdAt (Field5) — TimeStamp
  • updatedAt (Field6) — TimeStamp