Bandi
Tables (6)
AllDiary (CopyOfDiary)
- user_id — INT — Foreign key → User.user_id — NOT NULL
- diary_id — INT
- title — VARCHAR(255)
- content — TEXT — NOT NULL
- emotion — LIST
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- reaction — LIST
Mail
- user_id — INT — Foreign key → User.user_id — NOT NULL
- mail_id — INT
- content — TEXT
- date — TIMESTAMP
MyDiary (Diary)
- user_id — INT — Foreign key → User.user_id — NOT NULL
- diary_id — INT
- title — VARCHAR(255)
- content — TEXT — NOT NULL
- emotion — LIST
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- reaction — LIST
Settings
- user_id — INT
- bgmOn (bgmON) — BOOLEAN
- notificationOn — BOOLEAN
- notificationTime — TIME
User
- user_id — INT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50)
- social_login_provider — ENUM('google', 'apple')
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- bgmOn — BOOLEAN
- notificationOn — BOOLEAN
- notificationTime — TIME
userChatCollection
- user_id — INT — Foreign key → User.user_id — NOT NULL
- message — TEXT
- messenger — INT
- messageType — INT
- messageTime — TIMESTAMP