myblog

Tables (4)

Comment (Untitled3)

  • CommentId (Key) — Long — Primary key — NOT NULL
  • PostId (Key3) — Long — Foreign key → Post.PostId — NOT NULL
  • MemberId (Key22) — Long — Foreign key → Post.MemberId — NOT NULL
  • Content (Field) — Long
  • CommentHaertCount (Field2) — Long
  • ParentId (Key2) — Long — Foreign key → Comment.CommentId — NOT NULL

Heart (Untitled4)

  • HeartId (Key) — Long — Primary key — NOT NULL
  • MemberId (Key22) — Long — Foreign key → Post.MemberId — NOT NULL
  • PostId (Key2) — Long — Foreign key → Post.PostId — NOT NULL
  • CommentId (Key3) — Long — Foreign key → Comment.CommentId — NOT NULL
  • PostOrComment (Field) — PostOrComment

Member (Untitled)

  • Id (Key) — Long — Primary key — NOT NULL
  • MemberId (Field3) — String
  • Nickname (Field) — Stirng
  • Password (Field2) — String
  • Gender (Field4) — Enum

Post (Untitled2)

  • PostId (Key) — Long — Primary key — NOT NULL
  • MemberId (Key2) — Long — Foreign key → Member.Id — NOT NULL
  • Title (Field) — String
  • Content (Field2) — String
  • PostHeartCount (Field3) — Long