ERD
Tables (4)
Like (Untitled2)
- Id (Key) — long — Primary key — NOT NULL — autoincrease
- user_id (유저 아이디) — long — Foreign key → User.Id — NOT NULL
- comment_id (댓글 아이디) — long — Foreign key → comment.Id — NOT NULL
Post (user_post)
- Id (Key) — long — Primary key — NOT NULL — autoIncrease
- user_id (key) — long — Foreign key → User.Id — NOT NULL
- title (제목) — varchar — NOT NULL
- content (내용) — longText — NOT NULL
- createdDate (작성일) — date — NOT NULL
User (user_table)
- Id (key) — long — Primary key — NOT NULL — autoIncrease
- email (이메일) — varchar — NOT NULL
- password (비밀번호) — varchar — NOT NULL
comment (Untitled)
- Id (Key) — long — Primary key — NOT NULL — autoIncreease
- post_id (게시글 ID) — long — Foreign key → Post.Id — NOT NULL
- user_email (작성자) — varchar
- content (내용) — longText — NOT NULL
- createAt (작성일) — date — NOT NULL
- like (좋아요) — int