project
Tables (5)
Comment (comment)
- comment_id (Key) — Long — Primary key — NOT NULL
- post_id (Key2) — Long — Foreign key → POST.post_id — NOT NULL
- member_id (Key22) — Foreign key → POST.member_id — NOT NULL
- member_id (Field) — Long
- content (Field2) — String
- createdAt (Field4) — String
- modifiedAt (Field5) — String
- like_count (Field6) — Integer
Comment_like
- comment_like_id (Key) — Long — Primary key — NOT NULL
- comment_id (Key2) — Long — Foreign key → Comment.comment_id — NOT NULL
- post_id (Key22) — Long — Foreign key → Comment.post_id — NOT NULL
- member_id (Key222) — Foreign key → Comment.member_id — NOT NULL
- comment_id (Field2) — Long
- member_id (Field3)
Member
- member_id (Key) — Primary key — NOT NULL
- nickname (Field) — String
- password (Field2) — int
- username (Field3) — String
POST
- post_id (Key) — Long — Primary key — NOT NULL
- member_id (Key2) — Foreign key → Member.member_id — NOT NULL
- member_id (Field2) — long
- title (Field3) — String
- imageUrl (Field4) — String
- createdAt (Field5) — String
- modifiedAt (Field6) — String
- comment_id (Field7) — Long
- like_count (Field8) — Integer
Post_like
- post_like_id (Key) — Long — Primary key — NOT NULL
- post_id (Key2) — Long — Foreign key → POST.post_id — NOT NULL
- member_id (Key22) — Foreign key → POST.member_id — NOT NULL
- post_id (Field2) — Long
- member_id (Field3) — Long