Dwitter

Tables (6)

Comments (댓글)

  • id (ID) — INT — Primary key — NOT NULL — AUTO_INCREMENT
  • tweetId (댓글 수신 트윗) — INT — Foreign key → Tweets.id — NOT NULL — ON DELETE CASCADE
  • userId (댓글 작성자) — INT — Foreign key → Users.id — NOT NULL — ON DELETE CASCADE
  • comment (내용) — TEXT — NOT NULL — -
  • good (좋아요 수) — INT — NOT NULL — -
  • createdAt (생성일) — DATETIME — NOT NULL — -
  • updatedAt (수정일) — DATETIME — NOT NULL — -

Good Comments (댓글 좋아요)

  • commentId (추천받은 댓글) — INT — Foreign key → Comments.id — NOT NULL — ON DELETE CASCADE
  • userId (추천자) — INT — Foreign key → Users.id — NOT NULL — ON DELETE CASCADE

Good Tweets (트윗 좋아요)

  • tweetId (추천받은 트윗) — INT — Foreign key → Tweets.id — NOT NULL — ON DELETE CASCADE
  • userId (추천자) — INT — Foreign key → Users.id — NOT NULL — ON DELETE CASCADE

Replies (답글)

  • commentId (ID) — INT — Foreign key → Comments.id — NOT NULL — ON DELETE CASCADE
  • username (수신 닉네임) — VARCHAR(45) — Foreign key → Users.id — NOT NULL — ON DELETE NO ACTION ON UPDATE CASCADE

Tweets (글)

  • id (ID) — INT — Primary key — NOT NULL — AUTO_INCREMENT
  • userId (트윗 작성자) — INT — Foreign key → Users.id — NOT NULL — ON DELETE CASCADE
  • text (내용) — TEXT — -
  • video (비디오 URL) — TEXT — -
  • image (이미지 URL) — TEXT — -
  • good (좋아요 수) — INT — NOT NULL — -
  • createdAt (생성일) — DATETIME — NOT NULL — -
  • updatedAt (수정일) — DATETIME — NOT NULL — -

Users (사용자)

  • id (ID) — INT — Primary key — NOT NULL — AUTO_INCREMENT
  • username (닉네임) — VARCHAR(45) — NOT NULL — -
  • password (비밀번호) — VARCHAR(128) — -
  • email (이메일) — VARCHAR(128) — NOT NULL — -
  • name (이름) — VARCHAR(128) — NOT NULL — -
  • socialLogin (소셜 로그인) — TINYINT(1) — NOT NULL — -
  • url (프로필 이미지) — TEXT — -