off-record

Tables (9)

diaries

  • diary_id — INT — Primary key
  • user_id — INT — Foreign key — NOT NULL
  • content — TEXT
  • type — VARCHAR(20)
  • created_at — TIMESTAMP

emotion_status

  • status_id — INT — Primary key
  • user_id — INT — Foreign key — NOT NULL
  • diary_id — INT — Foreign key → diaries.diary_id
  • log_id — INT — Foreign key → logs.log_id
  • life_id — INT — Foreign key → life_data.life_id
  • report_id — INT — Foreign key → reports.report_id
  • emotion_score — INT
  • burnout_score — INT
  • color — VARCHAR(20)
  • created_at — TIMESTAMP

feedback

  • feedback_id — INT — Primary key
  • user_id — INT — Foreign key — NOT NULL
  • status_id — INT — Foreign key → emotion_status.status_id — NOT NULL
  • message — TEXT
  • type — VARCHAR(20)
  • created_at — TIMESTAMP

life_data

  • life_id — INT — Primary key
  • user_id — INT — Foreign key — NOT NULL
  • sleep_time — INT
  • steps — INT
  • phone_usage — INT
  • date — DATE

logs

  • log_id — INT — Primary key
  • user_id — INT — Foreign key — NOT NULL
  • score — INT
  • meal — BOOLEAN
  • study_time — INT
  • date — DATE

notifications

  • notification_id — INT — Primary key
  • user_id — INT — Foreign key — NOT NULL
  • report_id — INT — Foreign key → reports.report_id
  • status_id — INT — Foreign key → emotion_status.status_id
  • message — TEXT
  • type — VARCHAR(20)
  • is_read — BOOLEAN
  • created_at — TIMESTAMP

reports

  • report_id — INT — Primary key
  • summary — TEXT
  • type — VARCHAR(20)
  • created_at — TIMESTAMP
  • Key (user_id) — INT — Foreign key → users.Key — NOT NULL

user_responses

  • response_id — INT — Primary key
  • user_id — INT — Foreign key — NOT NULL
  • feedback_id — INT — Foreign key → feedback.feedback_id — NOT NULL
  • question — TEXT
  • answer — TEXT
  • created_at — TIMESTAMP

users

  • Key (user_id) — INT — Primary key — NOT NULL
  • email — VARCHAR(100)
  • password — VARCHAR(100)
  • notification_setting — BOOLEAN