EmotionDiary

Tables (4)

Untitled (emotion)

  • Key (emotion_id) — Primary key — NOT NULL
  • Field3 (is_active)
  • Field (name)
  • Field2 (category)
  • Field (image)
  • Field (synced)

Untitled (diary)

  • Key (diary_id) — Primary key — NOT NULL
  • Field (date)
  • Field (satisfaction)

Untitled (summary)

  • Key (summary_id) — Primary key — NOT NULL
  • Field (start_date)
  • Field (end_date)
  • Field (result)
  • Field (created_time)
  • Field (synced)

Untitled (diary_card)

  • Key (diary_card_id) — Primary key — NOT NULL
  • Key (diary_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (created_time)
  • Field2 (updated_time)
  • Field (emotion_name)
  • Field (content)
  • Field (synced)