emolog

Tables (4)

diary (diary(localDB or hasedContent))

  • diaryId — Primary key — NOT NULL
  • Author — Foreign key → emologUser.userId — NOT NULL
  • content — BigText
  • createdAt — Date
  • updatedAt — Date
  • emoType — string
  • gptResStatus — enum

emologUser

  • userId — Primary key — NOT NULL
  • email — string
  • snsType — string
  • name — string
  • diaryPw — string

gptRes

  • gptId — Primary key — NOT NULL
  • diaryId — Foreign key → diary.diaryId — NOT NULL
  • content (conrtent)
  • createdAt — Date

userSetting

  • id — Primary key — NOT NULL
  • userId — Foreign key → emologUser.userId — NOT NULL
  • writtingTime (writtingTime(local push)) — string
  • pushYn — char
  • gptStyle — enum