Today'sHouse

Tables (5)

Bookmark (CopyOfUntitled3)

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

Comment (CopyOfUntitled2)

  • commentId (Key) — Long — Primary key — NOT NULL
  • postId (Key2) — Long — Foreign key → Post.postId — NOT NULL
  • comment (Field) — String
  • commentHeartCnt (Field4) — int
  • createdAt (Field2) — LocalDateTime
  • modifiedAt (Field3) — LocalDateTime

Heart (CopyOfCopyOfUntitled2)

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

Post (CopyOfUntitled)

  • postId (Key) — Long — Primary key — NOT NULL
  • userId (Key2) — Long — Foreign key → Users.userId — NOT NULL
  • size (Field) — Int
  • type (Field2) — String
  • style (Field3) — String
  • area (Field4) — String
  • imageFile (Field5) — MultipartFile
  • content (Field6) — String
  • heartCnt (Field7) — int
  • bookmarkCnt (Field8) — int
  • commentCnt (Field9) — int
  • viewCnt (Field10) — int

Users (Untitled)

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