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