morae

Tables (9)

daily_question

  • id — BIGSERIAL
  • question_date — DATE — NOT NULL
  • question_text — TEXT — NOT NULL — 질문
  • question_type — question_type_enum — NOT NULL — normal/milestone
  • interest_id — INT — 관심주제
  • created_at — TIMESTAMPTZ — NOT NULL

diary_analysis

  • id — BIGSERIAL
  • diary_entry_id — BIGINT — NOT NULL
  • emotions — JSONB
  • keywords — JSONB — 키워드
  • sentiment_score — DOUBLE — 감정
  • color_code — VARCHAR(7) — 캘린더
  • analyzed_at — TIMESTAMPTZ — NOT NULL

diary_entry

  • id — BIGSERIAL
  • user_id — BIGINT — NOT NULL
  • question_id — BIGINT — NOT NULL
  • entry_date — DATE — NOT NULL
  • content — TEXT — NOT NULL — 일기
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL — 삭제

friendship

  • id — BIGSERIAL
  • user_id — BIGINT — NOT NULL
  • friend_id — BIGINT — NOT NULL — 친구
  • status — friendship_status_enum — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

interest

  • id — SERIAL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT — 설명

notification_setting

  • id — BIGSERIAL
  • user_id — BIGINT — NOT NULL
  • question_time — TIME
  • push_enabled — BOOLEAN — NOT NULL — 푸시
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

periodic_analysis

  • id — BIGSERIAL
  • user_id — BIGINT — NOT NULL
  • period_type — period_type_enum — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • emotion_trends — JSONB
  • keyword_trends — JSONB
  • comparison_data — JSONB
  • similar_region — JSONB
  • contour_data — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL

user

  • id — BIGSERIAL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — 비밀번호
  • nickname — VARCHAR(50) — 닉네임
  • provider — VARCHAR(50) — OAuth
  • provider_id — VARCHAR(100) — OAuth
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • is_active — BOOLEAN — NOT NULL — 활성

user_interest

  • id — BIGSERIAL
  • user_id — BIGINT — NOT NULL
  • interest_id — INT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL