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