twitter_clone

Tables (10)

follows

  • followerId (Key) — INTEGER — Foreign key → users.id — NOT NULL
  • followingId (Key2) — INTEGER — Foreign key → users.id — NOT NULL
  • createdAt (Field8) — DATE — NOT NULL
  • updatedAt (Field9) — DATE — NOT NULL

hashtags

  • id (Key) — INTEGER — Primary key — NOT NULL
  • tag (Field) — STRING(30) — NOT NULL
  • count (Field2) — INTEGER — NOT NULL
  • createdAt (Field8) — DATE — NOT NULL
  • updatedAt (Field9) — DATE — NOT NULL
  • deletedAt (Field10) — DATE — NOT NULL

images (CopyOfCopyOfUntitled)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • src (Field) — STRING — NOT NULL
  • type (Field2) — STRING(20)
  • createdAt (Field8) — DATE — NOT NULL
  • updatedAt (Field9) — DATE — NOT NULL
  • deletedAt (Field10) — DATE — NOT NULL
  • tweetId (Key2) — INTEGER — Foreign key → tweets.id

likes (CopyOfCopyOfCopyOfUntitled3)

  • userId (Key2) — INTEGER — Foreign key → users.id — NOT NULL
  • tweetId (Key3) — INTEGER — Foreign key → tweets.id — NOT NULL
  • createdAt (Field8) — DATE — NOT NULL
  • updatedAt (Field9) — DATE — NOT NULL

tweethashtags (posthashtag)

  • tweetId (Key) — INTEGER — Foreign key → tweets.id — NOT NULL
  • hashtagId (Key2) — INTEGER — Foreign key → hashtags.id — NOT NULL
  • createdAt (Field8) — DATE — NOT NULL
  • updatedAt (Field9) — DATE — NOT NULL

tweets (posts)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • contents (Field) — STRING(200) — NOT NULL
  • hasImage (Field2) — BOOLEAN — NOT NULL — text or image
  • retweetedCount (Field4) — INTEGER — NOT NULL
  • createdAt (Field8) — DATE — NOT NULL
  • updatedAt (Field9) — DATE — NOT NULL
  • deletedAt (Field10) — DATE
  • userId (Key2) — INTEGER — Foreign key → users.id — 트윗 작성자
  • retweetOriginId (Key3) — INTEGER — Foreign key → tweets.id — 해당 트윗이 리트윗한 원본 트윗
  • quotedOrginId (Key4) — INTEGER — Foreign key → tweets.id — NOT NULL — 해당 트윗이 인용한 원본 트윗
  • commentedOriginId (Key5) — INTEGER — Foreign key → tweets.id — NOT NULL — comment가 달린 트윗

userquotedtweets (CopyOfCopyOfCopyOfCopyOfCopyOfUntitled3)

  • userId (Key2) — INTEGER — Foreign key → users.id — NOT NULL
  • tweetId (Key3) — INTEGER — Foreign key → tweets.id — NOT NULL
  • createdAt (Field8) — DATE — NOT NULL
  • updatedAt (Field9) — DATE — NOT NULL

userretweets (CopyOfCopyOfCopyOfCopyOfUntitled3)

  • userId (Key2) — INTEGER — Foreign key → users.id — NOT NULL
  • tweetId (Key3) — INTEGER — Foreign key → tweets.id — NOT NULL
  • createdAt (Field8) — DATE — NOT NULL
  • updatedAt (Field9) — DATE — NOT NULL

users

  • id (Key) — INTEGER — Primary key — NOT NULL
  • nickname (Field) — STRING(20) — NOT NULL
  • email (Field2) — STRING(30) — NOT NULL
  • password (Field4) — STRING(80) — NOT NULL
  • loginType (Field5) — STRING(10) — NOT NULL — local / facebook / google / kakao
  • selfIntro (Field6) — STRING(100)
  • location (Field7) — STRING(20)
  • avatarURL (Field12) — STRING — NOT NULL
  • createdAt (Field8) — DATE — NOT NULL
  • updatedAt (Field9) — DATE — NOT NULL
  • deletedAt (Field10) — DATE

users (Untitled)

  • id (Key) — INTEGER — Primary key — NOT NULL