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