MVP 2

Tables (16)

answers

  • id — BIGINT — Primary key — NOT NULL
  • question_id — BIGINT — Foreign key → questions.id — NOT NULL
  • author_id — BIGINT — Foreign key → users.id — NOT NULL
  • content — TEXT — NOT NULL
  • is_adopted — BOOLEAN — NOT NULL
  • like_count — INT — NOT NULL
  • is_anonymous — BOOLEAN — NOT NULL — 멤버십 게시판 글에 한해 익명 작성 가능
  • deleted_at — DATETIME — soft delete
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

attachments

  • id — BIGINT — Primary key — NOT NULL
  • target_type — VARCHAR(20) — NOT NULL — QUESTION, ANSWER
  • target_id — BIGINT — NOT NULL — target_type에 따라 questions.id 또는 answers.id를 가리키는 다형 참조 (FK 미설정)
  • uploader_id — BIGINT — NOT NULL — JPA 연관관계 없이 Long 컬럼으로만 저장됨
  • original_filename — VARCHAR(255) — NOT NULL
  • stored_filename — VARCHAR(100) — NOT NULL
  • content_type — VARCHAR(100) — NOT NULL
  • file_size — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

chat_messages

  • id — BIGINT — Primary key — NOT NULL
  • chat_room_id — BIGINT — Foreign key → chat_rooms.id — NOT NULL
  • sender_id — BIGINT — Foreign key → users.id — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

chat_rooms

  • id — BIGINT — Primary key — NOT NULL
  • question_id — BIGINT — Foreign key → questions.id — NOT NULL — 커리어상담 유형 질문에 대해 개설됨
  • answerer_id — BIGINT — Foreign key → users.id — NOT NULL — 답변자(채팅을 건 사람). 질문자는 question.author로 알 수 있어 별도 컬럼 없음
  • status — VARCHAR(20) — NOT NULL — PENDING, ACTIVE, ADOPTED, CLOSED
  • questioner_read_at — DATETIME — 질문자가 마지막으로 읽은 시각, NULL이면 미열람
  • answerer_read_at — DATETIME — 답변자가 마지막으로 읽은 시각, NULL이면 미열람
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

code_comments

  • id — BIGINT — Primary key — NOT NULL
  • question_id — BIGINT — Foreign key → questions.id — NOT NULL
  • author_id — BIGINT — Foreign key → users.id — NOT NULL
  • line_number — INT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

likes

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • target_type — VARCHAR(20) — NOT NULL — QUESTION, ANSWER
  • target_id — BIGINT — NOT NULL — target_type에 따라 questions.id 또는 answers.id를 가리키는 다형 참조 (FK 미설정)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

notifications

  • id — BIGINT — Primary key — NOT NULL
  • recipient_id — BIGINT — Foreign key → users.id — NOT NULL
  • type — VARCHAR(20) — NOT NULL — NEW_ANSWER, ANSWER_ADOPTED, NEW_CHAT_ROOM, CHAT_ACCEPTED, CHAT_ADOPTED
  • message — VARCHAR(200) — NOT NULL
  • link — VARCHAR(200) — NOT NULL — 알림 클릭 시 이동할 프론트 라우트 경로 (예: /questions/12)
  • is_read — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

orders

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • plan_type — VARCHAR(20) — NOT NULL — PREMIUM
  • amount — BIGINT — NOT NULL
  • currency — VARCHAR(10) — NOT NULL
  • status — VARCHAR(20) — NOT NULL — PENDING, PAID, CANCELLED
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

payments

  • id — BIGINT — Primary key — NOT NULL
  • order_id — BIGINT — Foreign key → orders.id — NOT NULL
  • payment_id — VARCHAR(50) — NOT NULL — PortOne paymentId
  • status — VARCHAR(20) — NOT NULL — READY, PAID, FAILED, CANCELLED
  • paid_at — DATETIME
  • cancelled_at — DATETIME
  • cancel_reason — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

question_tags

  • id — BIGINT — Primary key — NOT NULL
  • question_id — BIGINT — Foreign key → questions.id — NOT NULL
  • tag_id — BIGINT — Foreign key → tags.id — NOT NULL
  • sort_order — INT — NOT NULL

questions

  • id — BIGINT — Primary key — NOT NULL
  • author_id — BIGINT — Foreign key → users.id — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — TEXT — NOT NULL
  • view_count — INT — NOT NULL
  • like_count — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL — OPEN, RESOLVED, DELETED
  • is_premium — BOOLEAN — NOT NULL — 멤버십(구독자 전용) 게시판 여부
  • is_anonymous — BOOLEAN — NOT NULL — 멤버십 게시판 글에 한해 익명 작성 가능
  • type — VARCHAR(20) — NOT NULL — GENERAL, CODE_REVIEW, CAREER_CONSULT. 네이티브 enum 대신 varchar로 고정(정수 인덱스 저장 방지)
  • type_locked — BOOLEAN — NOT NULL — 커리어상담 채팅이 한 번이라도 개설되면 true로 고정, 이후 유형 변경 불가
  • summary — TEXT — AI 요약 결과 캐시
  • deleted_at — DATETIME — soft delete
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

reports

  • id — BIGINT — Primary key — NOT NULL
  • reporter_id — BIGINT — Foreign key → users.id — NOT NULL
  • target_type — VARCHAR(20) — NOT NULL — QUESTION, ANSWER
  • target_id — BIGINT — NOT NULL — target_type에 따라 questions.id 또는 answers.id를 가리키는 다형 참조 (FK 미설정)
  • target_user_id — BIGINT — NOT NULL — 신고 대상 작성자 (JPA 연관관계 없이 Long 컬럼으로만 저장됨)
  • reason — TEXT — NOT NULL
  • status — VARCHAR(20) — NOT NULL — PENDING, RESOLVED, REJECTED
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

subscriptions

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL — 유저당 1개 (1:1)
  • plan_type — VARCHAR(20) — NOT NULL — PREMIUM
  • started_at — DATETIME — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • status — VARCHAR(20) — NOT NULL — ACTIVE, EXPIRED, CANCELLED
  • billing_key — VARCHAR(255) — PortOne 정기결제용 빌링키
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

tags

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

users

  • id — BIGINT — Primary key — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL — 소셜 로그인 회원도 임의 비밀번호를 암호화해 저장
  • nickname — VARCHAR(30) — NOT NULL
  • email — VARCHAR(100)
  • role — VARCHAR(20) — NOT NULL — USER, ADMIN
  • status — VARCHAR(20) — NOT NULL — ACTIVE, WITHDRAWN, SUSPENDED
  • provider — VARCHAR(20) — NOT NULL — LOCAL, GITHUB, GOOGLE
  • provider_id — VARCHAR(50) — 소셜 로그인 제공자가 발급한 고유 식별자 (LOCAL 회원은 NULL)
  • reputation — INT — NOT NULL
  • is_expert — BOOLEAN — NOT NULL — 전문가 인증 여부
  • expert_requested — BOOLEAN — NOT NULL — 전문가 인증 신청 후 관리자 승인 대기 중
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

webhook_events

  • id — BIGINT — Primary key — NOT NULL
  • webhook_id — VARCHAR(100) — NOT NULL — PortOne webhook-id 헤더값, 중복 처리 방지용
  • event_type — VARCHAR(50) — NOT NULL
  • payment_id — VARCHAR(50) — PortOne paymentId
  • status — VARCHAR(20) — NOT NULL — RECEIVED, PROCESSED, IGNORED
  • raw_payload — VARCHAR(2000)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL