realworld

Tables (6)

Article (Untitled4)

  • id (PK) — int — Primary key — NOT NULL
  • slug (Field) — String
  • title (Field2) — String
  • description (Field3) — String
  • body (Field4) — String
  • createdAt (Field5) — DateTime
  • updatedAt (Field6) — DateTime
  • authorId (FK) — int — Foreign key → User.id — NOT NULL

Comment (Untitled3)

  • id (Key) — int — Primary key — NOT NULL
  • body (Field) — String
  • createdAt (Field2) — DateTime
  • updatedAt (Field3) — DateTime
  • articleId (FK) — int — Foreign key → Article.id — NOT NULL
  • authorId (Key2) — int — Foreign key → User.id — NOT NULL

Favorites (Untitled5)

  • userId (Key) — int — Foreign key → User.id — NOT NULL
  • articledId (PK) — int — Foreign key → Article.id — NOT NULL

Tag (Untitled2)

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

Untitled6

  • articleId (PK) — int — Foreign key → Article.id — NOT NULL
  • tagId (Key) — int — Foreign key → Tag.id — NOT NULL

User (Untitled)

  • id (Key) — int — Primary key — NOT NULL
  • email (Field) — String — NOT NULL
  • username (Field2) — String — NOT NULL
  • password (Field3) — String — NOT NULL
  • image (Field4) — String
  • bio (Field5) — String