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)