Sentiment Diary

Tables (3)

Diary

  • Diary_Key (Key) — VARCHAR — Primary key — NOT NULL
  • UserId (Key2) — VARCHAR — Foreign key → User.UserId — NOT NULL
  • title (Field9) — varchar
  • content (Field) — text
  • image (Field2) — image
  • created_at (Field3) — datetime
  • realdate (Field4) — date
  • positive (Field5) — float
  • negative (Field6) — float
  • Emoji (Field7) — image
  • advice (Field8) — text

Profile

  • ProfileId (Key) — VARCHAR — Primary key — NOT NULL
  • UserId (Key2) — VARCHAR — Foreign key → User.UserId — NOT NULL
  • Image (Field) — image
  • Description (Field2) — text

User (Account)

  • UserId (Key) — VARCHAR — Primary key — NOT NULL
  • Password (Field) — VARCHAR
  • Email (Field2) — Email