shujinko
Tables (6)
Diary
- did (Key) — BIGINT — Primary key — NOT NULL
- uid (Key2) — VARCHAR(40) — Foreign key → User.uid — NOT NULL
- rawDiary (Field) — TEXT
- rephrasedDiary (Field2) — TEXT
- createdAt (Field3) — DATETIME
- summary (Field4) — TEXT
Emotion
- id (Key) — BIGINT — Primary key — NOT NULL
- emotion (Field) — CARCHAR(20)
User
- uid (Key) — VARCHAR(40) — Primary key — NOT NULL
- email (Field) — VARCHAR(255)
- name (Field2) — VARCHAR(20)
- photoUrl (Field3) — VARCHAR(50)
- LocalDateTime (Field4) — DATETIME
diary_emotion
- did (Key) — BIGINT — Foreign key → Diary.did — NOT NULL
- id (Key2) — BIGINT — Foreign key → Emotion.id — NOT NULL
- score (Field) — FLOAT
diary_keyword
- did (Key) — BIGINT — Foreign key → Diary.did — NOT NULL
- id (Key2) — BIGINT — Foreign key → keyword.id — NOT NULL
keyword
- id (Key) — BIGINT — Primary key — NOT NULL
- keyword (Field) — VARCHAR(30)