트레이드 도메인 테이블 설계2
테이블 (27)
ai_answers
- id — VARCHAR(36) — 기본 키 — NOT NULL
- post_id — VARCHAR(36) — 외래 키 → posts.id — NOT NULL
- content — TEXT — NOT NULL
- is_adopted — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
ai_questions
- id — VARCHAR(36) — 기본 키 — NOT NULL
- post_id — VARCHAR(36) — 외래 키 → posts.id — NOT NULL
- original_title — VARCHAR(500) — NOT NULL
- refined_title — VARCHAR(500) — NOT NULL
- refined_content — TEXT
- suggestions — TEXT
- created_at — TIMESTAMP — NOT NULL
answer_likes
- id — VARCHAR(36) — 기본 키 — NOT NULL
- answer_id — VARCHAR(36) — 외래 키 → answers.id — NOT NULL
- user_id — VARCHAR(36) — 외래 키 → users.id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
answers
- id — VARCHAR(36) — 기본 키 — NOT NULL
- post_id — VARCHAR(36) — 외래 키 → posts.id — NOT NULL
- user_id — VARCHAR(36) — 외래 키 → users.id — NOT NULL
- content — TEXT — NOT NULL
- is_adopted — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
badges
- id — VARCHAR(50) — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — VARCHAR(255)
- sort_order — INTEGER — NOT NULL
- created_at — TIMESTAMP — NOT NULL
comments
- id — VARCHAR(36) — 기본 키 — NOT NULL
- answer_id — VARCHAR(36) — 외래 키 → answers.id — NOT NULL
- user_id — VARCHAR(36) — 외래 키 → users.id — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
content_sources
- id — VARCHAR(36) — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- url — VARCHAR(500) — NOT NULL
- collect_method — VARCHAR(20) — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
content_tags
- id — VARCHAR(36) — 기본 키 — NOT NULL
- content_id — VARCHAR(36) — 외래 키 → contents.id — NOT NULL
- tag_id — VARCHAR(36) — 외래 키 → tags.id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
contents
- id — VARCHAR(36) — 기본 키 — NOT NULL
- source_id — VARCHAR(36) — 외래 키 → content_sources.id — NOT NULL
- title — VARCHAR(500) — NOT NULL
- author — VARCHAR(100)
- canonical_url — VARCHAR(1000) — NOT NULL
- preview — TEXT
- thumbnail_url — TEXT
- is_original_visible — BOOLEAN — NOT NULL
- license_type — VARCHAR(50)
- original_content — TEXT
- published_at — TIMESTAMP
- is_available — BOOLEAN — NOT NULL
- takedown_requested_at — TIMESTAMP
- score — INTEGER
- view_count — INTEGER
- is_answered — BOOLEAN
- question_content — TEXT
- accepted_answer — TEXT
- top_answers — TEXT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
email_verifications
- id — VARCHAR(36) — 기본 키 — NOT NULL
- email — VARCHAR(255) — NOT NULL
- is_verified — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
history
- id — VARCHAR(36) — 기본 키 — NOT NULL
- user_id — VARCHAR(36) — 외래 키 → users.id — NOT NULL
- action_type — VARCHAR(50) — NOT NULL
- content_id — VARCHAR(36) — 외래 키 → contents.id
- post_id — VARCHAR(36) — 외래 키 → posts.id
- answer_id — VARCHAR(36) — 외래 키 → answers.id
- created_at — TIMESTAMP — NOT NULL
likes
- id — VARCHAR(36) — 기본 키 — NOT NULL
- user_id — VARCHAR(36) — 외래 키 → users.id — NOT NULL
- content_id — VARCHAR(36) — 외래 키 → contents.id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
point_logs
- id — VARCHAR(36) — 기본 키 — NOT NULL
- user_id — VARCHAR(36) — 외래 키 → users.id — NOT NULL
- action — VARCHAR(50) — NOT NULL
- points — INTEGER — NOT NULL
- reference_id — VARCHAR(36)
- earned_at — TIMESTAMP — NOT NULL
post_likes
- id — VARCHAR(36) — 기본 키 — NOT NULL
- post_id — VARCHAR(36) — 외래 키 → posts.id — NOT NULL
- user_id — VARCHAR(36) — 외래 키 → users.id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
posts
- id — VARCHAR(36) — 기본 키 — NOT NULL
- user_id — VARCHAR(36) — 외래 키 → users.id — NOT NULL
- title — VARCHAR(500) — NOT NULL
- content — TEXT — NOT NULL
- level — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
quiz_attempts
- id — VARCHAR(36) — 기본 키 — NOT NULL
- user_id — VARCHAR(36) — 외래 키 → users.id — NOT NULL
- content_id — VARCHAR(36) — 외래 키 → contents.id — NOT NULL
- level — VARCHAR(20) — NOT NULL
- score — INTEGER — NOT NULL
- total_questions — INTEGER — NOT NULL
- passed — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
refresh_tokens
- id — VARCHAR(36) — 기본 키 — NOT NULL
- user_id — VARCHAR(36) — 외래 키 → users.id — NOT NULL
- token — VARCHAR(500) — NOT NULL
- expires_at — TIMESTAMP — NOT NULL
- created_at — TIMESTAMP — NOT NULL
report_activities
- id — VARCHAR(36) — 기본 키 — NOT NULL
- report_id — VARCHAR(36) — 외래 키 → weekly_reports.id — NOT NULL
- contents_read — INTEGER — NOT NULL
- questions_created — INTEGER — NOT NULL
- scraps_count — INTEGER — NOT NULL
- top_tags — TEXT
- prev_week_comparison — TEXT
- daily_activities — TEXT
- tag_activities — TEXT
- created_at — TIMESTAMP — NOT NULL
scraps
- id — VARCHAR(36) — 기본 키 — NOT NULL
- user_id — VARCHAR(36) — 외래 키 → users.id — NOT NULL
- content_id — VARCHAR(36) — 외래 키 → contents.id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
similar_questions
- id — VARCHAR(36) — 기본 키 — NOT NULL
- post_id — VARCHAR(36) — 외래 키 → posts.id — NOT NULL
- similar_id — VARCHAR(36) — 외래 키 → posts.id — NOT NULL
- score — REAL — NOT NULL
- created_at — TIMESTAMP — NOT NULL
social_accounts
- id — VARCHAR(36) — 기본 키 — NOT NULL
- user_id — VARCHAR(36) — 외래 키 → users.id — NOT NULL
- provider — VARCHAR(20) — NOT NULL
- provider_id — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
tags
- id — VARCHAR(36) — 기본 키 — NOT NULL
- name — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
user_badges
- id — VARCHAR(36) — 기본 키 — NOT NULL
- user_id — VARCHAR(36) — 외래 키 → users.id — NOT NULL
- badge_id — VARCHAR(50) — 외래 키 → badges.id — NOT NULL
- acquired_at — TIMESTAMP — NOT NULL
user_consents
- id — VARCHAR(36) — 기본 키 — NOT NULL
- user_id — VARCHAR(36) — 외래 키 → users.id — NOT NULL
- consent_type — VARCHAR(30) — NOT NULL
- agreed_at — TIMESTAMP — NOT NULL
user_tags
- id — VARCHAR(36) — 기본 키 — NOT NULL
- user_id — VARCHAR(36) — 외래 키 → users.id — NOT NULL
- tag_id — VARCHAR(36) — 외래 키 → tags.id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
users
- id — VARCHAR(36) — 기본 키 — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255)
- nickname — VARCHAR(50) — NOT NULL
- profile_image — VARCHAR(500)
- job — VARCHAR(50) — NOT NULL
- level — VARCHAR(20) — NOT NULL
- total_points — INTEGER — NOT NULL
- is_active — BOOLEAN — NOT NULL
- is_email_verified — BOOLEAN — NOT NULL
- deleted_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
weekly_reports
- id — VARCHAR(36) — 기본 키 — NOT NULL
- user_id — VARCHAR(36) — 외래 키 → users.id — NOT NULL
- week_start — DATE — NOT NULL
- week_end — DATE — NOT NULL
- share_token — VARCHAR(100)
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL