DevTerview ERD

테이블 (23)

게시글 (posts)

  • post_id — SERIAL — 기본 키 — NOT NULL
  • post_user_id — INT — 외래 키 → 사용자.user_id — NOT NULL
  • job_id — INT — 외래 키 → 직무.job_id — NOT NULL
  • company_id — SERIAL — 외래 키 → 기업.company_id — NOT NULL
  • content — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • s3_image_url — VARCHAR(255)
  • post_type — VARCHAR(255)

기업 (companies)

  • company_id — SERIAL — 기본 키 — NOT NULL
  • company_name — VARCHAR(255)
  • location — VARCHAR(255)
  • industry — VARCHAR(255)

기업 구독 (company_subscribes)

  • company_subscribe_id — SERIAL — 기본 키 — NOT NULL
  • user_id — SERIAL — 외래 키 → 사용자.user_id — NOT NULL
  • company_id — SERIAL — 외래 키 → 기업.company_id — NOT NULL
  • created_at — TIMESTAMP

답변 (answers)

  • answer_id — SERIAL — 기본 키 — NOT NULL
  • question_id — SERIAL — 외래 키 → 질문.question_id — NOT NULL
  • answer_text — TEXT
  • s3_audio_url — VARCHAR(255)
  • s3_video_url — VARCHAR(255)
  • answer_type — VARCHAR(50)
  • created_at — TIMESTAMP — NOT NULL

답변 평가 (answer_feedbacks)

  • answer_feedback_id — SERIAL — 기본 키 — NOT NULL
  • answer_id — SERIAL — 외래 키 → 답변.answer_id — NOT NULL
  • final_score — INT
  • feedback_text — TEXT
  • created_at — TIMESTAMP — NOT NULL

답변 평가 점수 (answer_feedback_scores)

  • evaluation_criteria_id — INT — 외래 키 → 평가 기준.evaluation_criteria_id — NOT NULL
  • answer_feedback_id — SERIAL — 외래 키 → 답변 평가.answer_feedback_id — NOT NULL
  • score — INT

댓글 (comments)

  • comment_id — SERIAL — 기본 키 — NOT NULL
  • post_id — INT — 외래 키 → 게시글.post_id — NOT NULL
  • comment_user_id — INT — 외래 키 → 사용자.user_id — NOT NULL
  • content — TEXT
  • created_at — TIMESTAMP — NOT NULL

면접 (interviews)

  • interview_id — SERIAL — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → 사용자.user_id — NOT NULL
  • resume_id — INT — 외래 키 → 이력서.resume_id — NOT NULL
  • cover_letter_id — INT — 외래 키 → 자소서.cover_letter_id — NOT NULL
  • portfolio_id — INT — 외래 키 → 포트폴리오.portfolio_id — NOT NULL
  • job_id — INT — 외래 키 → 직무.job_id — NOT NULL
  • interview_status — VARCHAR(255)
  • interview_type — VARCHAR(255)
  • interview_method — VARCHAR(255)
  • interview_mode — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

면접 평가 (interview_feedbacks)

  • interview_feedback_id — SERIAL — 기본 키 — NOT NULL
  • interview_id — INT — 외래 키 → 면접.interview_id — NOT NULL
  • final_score — INT
  • feedback_text — TEXT
  • created_at — TIMESTAMP — NOT NULL

면접 평가 점수 (interview_feedback_scores)

  • evaluation_criteria_id — INT — 외래 키 → 평가 기준.evaluation_criteria_id — NOT NULL
  • interview_feedback_id — SERIAL — 외래 키 → 면접 평가.interview_feedback_id — NOT NULL
  • score — INT

북마크 (bookmarks)

  • bookmark_id — SERIAL — 기본 키 — NOT NULL
  • post_id — INT — 외래 키 → 게시글.post_id — NOT NULL
  • bookmark_user_id — INT — 외래 키 → 사용자.user_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

사용자 (users)

  • user_id — SERIAL — 기본 키 — NOT NULL
  • job_id — INT — 외래 키 → 직무.job_id — NOT NULL
  • auth_id — VARCHAR(255)
  • email — VARCHAR(255)
  • name — VARCHAR(255)
  • nickname — VARCHAR(255)
  • profile_image — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • leaved — BOOLEAN
  • gender — VARCHAR(255)
  • birthdate — DATE

이력서 (resumes)

  • resume_id — SERIAL — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → 사용자.user_id — NOT NULL
  • file_name — VARCHAR(255)
  • s3_file_url — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL

이용권 (tickets)

  • ticket_id — SERIAL — 기본 키 — NOT NULL
  • user_id — SERIAL — 외래 키 → 사용자.user_id — NOT NULL
  • ticket_name — VARCHAR(255)
  • points_used — INT
  • is_active — BOOLEAN
  • created_at — TIMESTAMP

자소서 (cover_letters)

  • cover_letter_id — SERIAL — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → 사용자.user_id — NOT NULL
  • file_name — VARCHAR(255)
  • s3_file_url — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL

직무 (jobs)

  • job_id — SERIAL — 기본 키 — NOT NULL
  • job_name — VARCHAR(255)
  • job_description — TEXT

직무 구독 (job_subscribes)

  • job_subscribe_id — SERIAL — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → 사용자.user_id — NOT NULL
  • job_id — INT — 외래 키 → 직무.job_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

질문 (questions)

  • question_id — SERIAL — 기본 키 — NOT NULL
  • interview_id — INT — 외래 키 → 면접.interview_id — NOT NULL
  • question_text — TEXT
  • key_terms — JSONB
  • model_answer — TEXT
  • question_intent — TEXT
  • s3_audio_url — VARCHAR(255)
  • s3_video_url — VARCHAR(255)
  • question_type — VARCHAR(50)
  • created_at — TIMESTAMP — NOT NULL

쿠폰 (coupons)

  • coupon_id — SERIAL — 기본 키 — NOT NULL
  • user_id — SERIAL — 외래 키 → 사용자.user_id — NOT NULL
  • coupon_name — VARCHAR(255)
  • points — INT
  • is_used — BOOLEAN
  • created_at — TIMESTAMP
  • used_at — TIMESTAMP
  • expires_at — TIMESTAMP

평가 기준 (evaluation_criteria)

  • evaluation_criteria_id — SERIAL — 기본 키 — NOT NULL
  • evaluation_criteria_name — VARCHAR(255)
  • max_score — INT
  • weight — DOUBLE
  • created_at — TIMESTAMP — NOT NULL

평가 후기 (feedback_reviews)

  • feedback_review_id — SERIAL — 기본 키 — NOT NULL
  • user_id — SERIAL — 외래 키 → 사용자.user_id — NOT NULL
  • interview_feedback_id — SERIAL — 외래 키 → 면접 평가.interview_feedback_id — NOT NULL
  • feedback_review_text — TEXT
  • points_given — BOOLEAN
  • created_at — TIMESTAMP

포인트 기록 (point_transactions)

  • point_transaction_id — SERIAL — 기본 키 — NOT NULL
  • user_id — SERIAL — 외래 키 → 사용자.user_id — NOT NULL
  • point_transaction_type — VARCHAR(255)
  • points — INT
  • description — VARCHAR(255)
  • created_at — TIMESTAMP

포트폴리오 (portfolios)

  • portfolio_id — SERIAL — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → 사용자.user_id — NOT NULL
  • file_name — VARCHAR(255)
  • s3_file_url — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL