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