moodcloud

Tables (7)

comments

  • id — INT — Primary key — NOT NULL
  • diary_id — INT — Foreign key → diaries.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.uid — NOT NULL
  • content — TEXT — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • INDEX — `diary_id`
  • INDEX — `user_id`

diaries

  • id — INT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.uid — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — TEXT — NOT NULL
  • is_public — TINYINT(1) — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • suggested_emotion_id — VARCHAR(30) — Foreign key → emotions.id
  • INDEX — `user_id`
  • INDEX — `suggested_emotion_id`

diary_emotions

  • id — INT — Primary key — NOT NULL
  • diary_id — INT — Foreign key → diaries.id
  • user_id — BIGINT — Foreign key → users.uid — NOT NULL
  • userEmotion — VARCHAR(255) — Foreign key → emotions.id — NOT NULL
  • selectEmotion — VARCHAR(255) — Foreign key → emotions.id
  • date — DATE — NOT NULL
  • INDEX — `diary_id`
  • INDEX — `user_id`
  • INDEX — `userEmotion`
  • INDEX — `selectEmotion`

diary_imgs

  • id — INT — Primary key — NOT NULL
  • diary_id — INT — Foreign key → diaries.id — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL
  • INDEX — `diary_id`

emotions

  • id — VARCHAR(30) — Primary key — NOT NULL
  • color — VARCHAR(20)
  • name — VARCHAR(20) — NOT NULL
  • emoji — VARCHAR(20) — NOT NULL

follows

  • id — INT — Primary key — NOT NULL
  • follower_id — BIGINT — Foreign key → users.uid — NOT NULL
  • following_id — BIGINT — Foreign key → users.uid — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • INDEX — `following_id`

users

  • uid — BIGINT — Primary key — NOT NULL
  • nick_name — VARCHAR(30) — NOT NULL
  • profile_image — VARCHAR(255)
  • bio — VARCHAR(300)
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL