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