erd

Tables (5)

comments (댓글 테이블)

  • comment_ID (Key) — varchar(50) — Primary key — NOT NULL
  • comments_user_ID_fk (Key2) — varchar(20) — Foreign key → USER.user_ID — NOT NULL
  • comment_contents (댓글 내용) — TEXT
  • comment_time (시간) — time
  • comment_recommentTotal (댓글 개수) — INT

USER (유저 테이블)

  • user_ID (Key) — varchar(20) — Primary key — NOT NULL
  • user_name (유저 이름) — varchar(50)

comments_emogi (댓글별 반응)

  • comments_emogi_comment_ID_fk (Key) — varchar(50) — Foreign key → comments.comment_ID — NOT NULL
  • comment_Imoge (이모지 종류) — varchar(20)
  • counts (이모지 개수) — int

recomments (대댓글)

  • recomment_ID (Key) — varchar(50) — Primary key — NOT NULL
  • recomments_comment_ID_fk (Key2) — varchar(50) — Foreign key → comments.comment_ID — NOT NULL
  • recomments_user_ID_fk (유저 이름) — varchar(20) — Foreign key → USER.user_ID — NOT NULL
  • recomment_content (대댓글 내용) — TEXT
  • recommnet_time (대댓글 시간) — time

recomments_emogi (대댓글별 반응)

  • recomments_emogi_comment_ID_fk (Key) — varchar(50) — Foreign key → recomments.recomment_ID — NOT NULL
  • recomment_emogi (이모지 종류) — varchar(20)
  • counts (이모지 개수) — int