Xc

Tables (5)

Comment (Untitled3)

  • Key — Primary key — NOT NULL
  • userId (Key2) — User — Foreign key → Users.userId — NOT NULL
  • postId (Key3) — Post — Foreign key → Post.postId — NOT NULL
  • comment (Field) — String

Post (Untitled)

  • postId (Key) — Long — Primary key — NOT NULL
  • userId (Key2) — User — Foreign key → Users.userId — NOT NULL
  • title (Field) — String
  • content (Field2) — String
  • imageUrl (Field3) — String
  • likeCnt (Field4) — Long
  • likeState (Field5)
  • commentList (Field6) — List<Comment>

PostLike (Untitled4)

  • Key — Primary key — NOT NULL
  • userId (Key2) — Long — Foreign key → Users.userId — NOT NULL
  • postId (Key3) — Long — Foreign key → Post.postId — NOT NULL

Users (Untitled2)

  • userId (Key) — Long — Primary key — NOT NULL
  • username (Field) — String
  • password (Field2) — String
  • profileUrl (Field3) — String
  • introducrion (Field4) — String

follow (Untitled5)

  • followId (Key) — Long — Primary key — NOT NULL
  • from (Field) — User
  • to (Field2) — User