qwer
Tables (5)
User (사용자)
- Key — Primary key — NOT NULL
- Field
comment (댓글)
- comment_id (댓글의 id) — Long — Primary key — NOT NULL
- post_id (게시글의 id) — Long — Foreign key → post.post_id — NOT NULL
- Tag_id (태그 id2) — Long — Foreign key → post.Tag_id — NOT NULL
- post_id (게시글의 id2) — Long — Foreign key → post.post_id — NOT NULL
- Key_id (좋아요의 id) — Long — Foreign key → post.Key_id — NOT NULL
- Key — Foreign key → post.Key — NOT NULL
- content (내용) — string
- password (비밀번호) — string
- created_at (생성시간) — time
- update_at (수정시간) — time
like (좋아요)
- post_id (게시글의 id) — Long — Primary key — NOT NULL
- Key_id (좋아요의 id) — Long — Primary key — NOT NULL
- Key — Foreign key → User.Key — NOT NULL
post (게시글)
- post_id (게시글의 id) — Long — Primary key — NOT NULL
- Tag_id (태그 id) — Long — Primary key — NOT NULL
- Tag_id (태그 id2) — Long — Foreign key → tag.Tag_id — NOT NULL
- post_id (게시글의 id2) — Long — Foreign key → like.post_id — NOT NULL
- Key_id (좋아요의 id) — Long — Foreign key → like.Key_id — NOT NULL
- Key — Foreign key → like.Key — NOT NULL
- content (내용) — string
- like (좋아요) — int
- view (조회수) — int
- created_at (생성시간) — time
- password (비밀번호) — string
tag (태그)
- Tag_id (태그 id) — Long — Primary key — NOT NULL
- name (태그의 이름) — string