[Version2] T-cono
Tables (7)
comment (댓글)
- comment_id (식별자) — int — Primary key — NOT NULL
- post_id (글 식별자) — bigint — Foreign key → post.post_id — NOT NULL
- content (댓글 내용) — text
- created_at (생성날짜) — date
- updated_at (수정날짜) — date
- is_deleted (삭제 여부) — boolean
hashTag (해시태그)
- hashtag_id (식별자) — int — Primary key — NOT NULL
- content (이름) — varchar
like (좋아요)
- like_id (식별자) — int — Primary key — NOT NULL
- post_id (글 식별자) — int — Foreign key → post.post_id — NOT NULL
- idp_id (사용자 식별자) — int
manager (관리자)
- idp_id (idp 식별자) — int — Primary key — NOT NULL
- type (권한) — varchar
post (게시글)
- post_id (식별자) — int — Primary key — NOT NULL
- idp_id (작성자) — int
- title (글 제목) — varchar
- content (글 내용) — text
- imageUrl (이미지) — json
- view (조회수) — int
- created_at (등록 일자) — date
- updated_at (수정 일자) — date
- deleted_at (삭제 일자) — date
- likeCount (좋아요 수) — int
post_hashTag (포스트_해시태그)
- post_hashTag_id (식별자) — int — Primary key — NOT NULL
- post_id (글 식별자) — int — Foreign key → post.post_id — NOT NULL
- hashtag_id (해시태그 식별자) — int — Foreign key → hashTag.hashtag_id — NOT NULL
reply (대댓글)
- reply_id (식별자) — int — Primary key — NOT NULL
- comment_id (댓글 식별자) — int — Foreign key → comment.comment_id — NOT NULL
- content (대댓글 내용) — text
- created_at (생성날짜) — date
- updated_at (수정날짜) — date