ERD

테이블 (14)

answer

  • answerId — BIGINT — 기본 키 — NOT NULL
  • content — TEXT — NOT NULL
  • aiScore — INT
  • isPublic — TINYINT(1)
  • createDate — DATETIME — NOT NULL
  • modifyDate — DATETIME — NOT NULL
  • userId — BIGINT — 외래 키 → 사용자.userId — NOT NULL — FK → users.userId
  • questionId — BIGINT — 외래 키 → question.questionId — NOT NULL — FK → question.questionId

comment

  • commentId — BIGINT — 기본 키 — NOT NULL
  • content — TEXT — NOT NULL
  • createDate — DATETIME — NOT NULL
  • modifyDate — DATETIME — NOT NULL
  • userId — BIGINT — 외래 키 → 사용자.userId — NOT NULL — FK → users.userId
  • postId — BIGINT — 외래 키 → post.postId — NOT NULL — FK → post.postId

feedback

  • feedbackId — BIGINT — 기본 키 — NOT NULL
  • feedbackContent — TEXT — NOT NULL
  • feedbackScore — INT — NOT NULL
  • resumeId — BIGINT — 외래 키 → resume.resumeId — NOT NULL — FK → resume.resumeId
  • userId — BIGINT — 외래 키 → 사용자.userId — NOT NULL — FK → users.userId

payment

  • paymentId — BIGINT — 기본 키 — NOT NULL
  • tossOrderId — VARCHAR(100) — NOT NULL
  • tossPaymentKey — VARCHAR(100) — NOT NULL
  • tossPaymentMethod — VARCHAR(50) — NOT NULL
  • tossPaymentStatus — ENUM('REQUESTED', 'DONE', 'CANCELED') — NOT NULL
  • requestedAt — DATETIME — NOT NULL
  • approvedAt — DATETIME — NOT NULL
  • totalAmount — INT — NOT NULL
  • userId — BIGINT — 외래 키 → 사용자.userId — NOT NULL — FK → users.userId

post

  • postId — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • introduction — TEXT — NOT NULL
  • content — TEXT — NOT NULL
  • deadline — DATETIME — NOT NULL
  • createDate — DATETIME — NOT NULL
  • modifyDate — DATETIME — NOT NULL
  • status — ENUM('ING', 'CLOSED') — NOT NULL — 진행 중, 마감
  • pinStatus — ENUM('PINNED', 'NOT_PINNED') — NOT NULL
  • recruitCount — INT — NOT NULL
  • userId — BIGINT — 외래 키 → 사용자.userId — NOT NULL — FK → users.userId

qna

  • qnaId — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • createDate — DATETIME — NOT NULL
  • modifyDate — DATETIME
  • userId — BIGINT — 외래 키 → 사용자.userId — NOT NULL — FK → users.userId
  • categoryType — ENUM('ACCOUNT', 'PAYMENT', 'SYSTEM', 'RECRUITMENT', 'SUGGESTION', 'OTHER') — NOT NULL
  • answer — TEXT
  • isAnswered — TINYINT(1)

question

  • questionId — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • isApproved — TINYINT(1)
  • score — INT
  • createDate — DATETIME — NOT NULL
  • modifyDate — DATETIME
  • userId — BIGINT — 외래 키 → 사용자.userId — NOT NULL — FK → users.userId
  • categoryType — ENUM('NETWORK', 'OS', 'DATABASE', 'DATA_STRUCTURE', 'ALGORITHM') — NOT NULL

ranking

  • rankingId — BIGINT — 기본 키 — NOT NULL
  • rankValue — INT
  • tier — ENUM('BRONZE', 'SILVER', 'GOLD', 'PLATINUM', 'DIAMOND', 'MASTER', 'RUBY', 'UNRATED')
  • totalScore — INT
  • userId — BIGINT — 외래 키 → 사용자.userId — NOT NULL — FK → users.userId

resume

  • resumeId — BIGINT — 기본 키 — NOT NULL
  • content — TEXT
  • skill — VARCHAR(500)
  • activity — TEXT
  • certification — TEXT
  • career — TEXT
  • portfolioUrl — VARCHAR(255)
  • userId — BIGINT — 외래 키 → 사용자.userId — NOT NULL — FK → users.userId

review

  • reviewId — BIGINT — 기본 키 — NOT NULL
  • aiReviewContent — TEXT
  • resumeId — BIGINT — 외래 키 → resume.resumeId — NOT NULL — FK → resume.resumeId
  • userId — BIGINT — 외래 키 → 사용자.userId — NOT NULL — FK → users.userId

subscription

  • subscriptionId — BIGINT — 기본 키 — NOT NULL
  • type — ENUM('BASIC', 'PREMIUM') — NOT NULL
  • status — TINYINT(1) — NOT NULL
  • startDate — DATE — NOT NULL
  • endDate — DATE — NOT NULL
  • questionLimit — INT — NOT NULL
  • paymentId — BIGINT — 외래 키 → payment.paymentId — NOT NULL — FK → payment.paymentId
  • userId — BIGINT — 외래 키 → 사용자.userId — NOT NULL — FK → users.userId

userQuestion

  • userQuestionId — BIGINT — 기본 키 — NOT NULL
  • aiScore — INT
  • questionId — BIGINT — 외래 키 → question.questionId — NOT NULL — FK → question.questionId
  • userId — BIGINT — 외래 키 → 사용자.userId — NOT NULL — FK → users.userId

verificationCode

  • verificationCodeId — BIGINT — 기본 키 — NOT NULL
  • code — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • expiresAt — DATETIME — NOT NULL
  • verified — TINYINT(1) — NOT NULL

사용자 (users)

  • userId — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • role — ENUM('ADMIN', 'USER') — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • age — INT — NOT NULL
  • github — VARCHAR(255)
  • image — VARCHAR(255)
  • createDate — DATETIME — NOT NULL
  • modifyDate — DATETIME — NOT NULL
  • accountStatus — ENUM('ACTIVE','SUSPENDED','DEACTIVATED','BANNED') — NOT NULL