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