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