BLOG LV2, 3

Tables (3)

Comment (Untitled2)

  • id (Key) — Long — Primary key — NOT NULL
  • postid (id) — Long — Foreign key → Post.id — NOT NULL
  • text (Field) — String — NOT NULL
  • username (Field2) — String — NOT NULL

Post

  • id — Long — Primary key — NOT NULL
  • userid (id2) — Long — Foreign key → User.userid — NOT NULL
  • title — String — NOT NULL
  • content — String — NOT NULL
  • createAt (Field4) — LocalDateTime — NOT NULL
  • modifiedAt (Field) — LocalDateTime — NOT NULL
  • username (Field2) — String — NOT NULL

User (Untitled)

  • userid (id) — Long — Primary key — NOT NULL
  • username (Field) — String — NOT NULL
  • password (Field2) — String — NOT NULL