[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