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