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