community

Tables (5)

Comment (Untitled4)

  • id (Key) — int — Primary key — NOT NULL
  • author (Key2) — Long — Foreign key → User.id — NOT NULL
  • post (Key3) — int — Foreign key → Post.postId — NOT NULL
  • content (Field) — varchar
  • likeCounter (Field2) — int

Like (Untitled5)

  • id (Key) — int — Primary key — NOT NULL
  • targetId (Field) — int
  • userId (Field2) — int
  • targetType (Field3) — varchar

Post (Untitled3)

  • postId (Key) — int — Primary key — NOT NULL
  • author (Key2) — Long — Foreign key → User.id — NOT NULL
  • content (Field) — varchar
  • publicationState (Field2) — varchar
  • likeCounter (Field3) — int

User (Untitled)

  • id (Key) — Long — Primary key — NOT NULL
  • name (Field) — varchar
  • profileImage (Field2) — varchar
  • followerCount (Field3) — int
  • followingCount (Field4) — int

community_user_relation (Untitled2)

  • followingUserId (Key) — int — Primary key — NOT NULL
  • followerUserId (Key2) — int — Primary key — NOT NULL