homework3
Tables (5)
Comment
- id (comment_id) — Long — Primary key — NOT NULL
- member (member_id) — Long — Foreign key → Member.id — NOT NULL
- posting (posting_id) — Long — Foreign key → Posting.id — NOT NULL
- content — String
- likeCount (like_count) — Integer
CommentLikes (comment_likes)
- id (comment_likes_id) — Long — Primary key — NOT NULL
- id (comment_id) — Long — Foreign key → Comment.id — NOT NULL
- id (member_id) — Long — Foreign key → Member.id — NOT NULL
- status — int
Member (Untitled)
- id (member_id) — Long — Primary key — NOT NULL
- username — String
- password — String
Posting
- id (posting_id) — Long — Primary key — NOT NULL
- title — String
- content — String
- Field
- member (member_id) — Long — Foreign key → Member.id — NOT NULL
- likeCount (like_count) — Integer
PostingLikes (posting_likes)
- id (posting_likes_id) — Long — Primary key — NOT NULL
- id (member_id) — Long — Foreign key → Member.id — NOT NULL
- id (posting_id) — Long — Foreign key → Posting.id — NOT NULL
- status — int