PR: Potential Radar

Tables (23)

EmailVerification (이메일 인증 테이블)

  • id (아이디) — SERIAL — Primary key — NOT NULL
  • email (이메일) — Varchar — NOT NULL — UNIQUE
  • code (인증번호) — INTEGER — NOT NULL — 6자리 인증코드
  • created_at (생성일자) — TIMESTAMP — NOT NULL

Like (좋아요)

  • like_id (id) — Primary key — NOT NULL
  • user_id (회원 ID2) — BIGSERIAL — Foreign key → User.user_id — NOT NULL
  • target_type — VARCHAR(20)
  • target_id — INTEGER
  • created_at — TIMESTAMP

MemberReview (멤버리뷰)

  • id — BIDINT — Primary key — NOT NULL
  • reviewer_id (회훵ID) — BIGSERIAL — Primary key — NOT NULL
  • user_id (회원 ID) — BIGSERIAL — Foreign key → User.user_id — NOT NULL
  • project_id (프로젝트 ID) — SERIAL — Foreign key → ProjectRecruitment.project_id — NOT NULL
  • score (평점) — INT — NOT NULL
  • created_at (작성일) — TIMESTAMP — NOT NULL
  • comment (코멘트) — TEXT

Notification (알림)

  • notification_id (id) — Primary key — NOT NULL
  • sender_id (보내는 사람) — BIGSERIAL — Foreign key → User.user_id — NOT NULL
  • receiver_id (받는 사람) — BIGSERIAL — Foreign key → User.user_id — NOT NULL
  • type (알림 유형) — NOT NULL
  • priorityYn (중요도) — NOT NULL
  • url (페이지주소) — NOT NULL
  • content (알림내용) — NOT NULL
  • delYn (삭제여부) — NOT NULL
  • created_at (생성시간) — NOT NULL

ProjecTechPart (모집글-기술파트)

  • id — INTEGER — Primary key — NOT NULL
  • project_id (프로젝트 ID) — SERIAL — Foreign key → ProjectRecruitment.project_id — NOT NULL
  • id (기술 파트 ID) — BIGINT — Foreign key → TechPart.tech_part_id — NOT NULL

ProjectApplication (프로젝트 지원)

  • id — BIDINT — Primary key — NOT NULL
  • user_id (회원 ID) — BIGSERIAL — Foreign key → User.user_id — NOT NULL
  • project_id (프로젝트 ID) — SERIAL — Foreign key → ProjectRecruitment.project_id — NOT NULL
  • description (지원내용) — TEXT
  • status (상태) — ENUM — NOT NULL — WAITING, ACCEPTED, REJECTED
  • created_at (작성일) — TIMESTAMP — NOT NULL

ProjectCard (프로젝트 카드)

  • id — INTEGER — Primary key
  • proejct_member_id (프로젝트멤버ID) — INTEGER — Foreign key → ProjectMember.id
  • thumnail (썸네일) — VARCHAR(200)
  • content (컨텐츠) — TEXT — NOT NULL
  • title (타이틀) — NOT NULL
  • sub_title (서브타이틀)
  • created_at (작성일) — NOT NULL

ProjectCardTechStack (프로젝트 카드 기술스택)

  • id — INTEGER — Primary key — NOT NULL
  • stack_id (기술스택 ID) — BIGINT — Foreign key → TechStack.stack_id — NOT NULL
  • project_card_id (프로젝트카드ID) — INTEGER — Foreign key → ProjectCard.id

ProjectComment (댓글/비밀댓글/대댓글)

  • id — INTEGER — Primary key
  • user_id (팀리더 ID) — BIGSERIAL — Foreign key → ProjectRecruitment.user_id — NOT NULL
  • project_id (프로젝트 ID) — SERIAL — Foreign key → ProjectRecruitment.project_id — NOT NULL
  • content — TEXT
  • is_private — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • parent_id — Self-FK

ProjectMember (프로젝트 멤버)

  • id — INTEGER — Primary key
  • project_id (프로젝트 ID) — SERIAL — Foreign key → ProjectRecruitment.project_id — NOT NULL
  • user_id (회원 ID2) — BIGSERIAL — Foreign key → User.user_id — NOT NULL

ProjectRecruitment (프로젝트)

  • project_id (프로젝트 ID) — SERIAL — Primary key — NOT NULL
  • user_id (팀리더 ID) — BIGSERIAL — Foreign key → User.user_id — NOT NULL
  • title (프로젝트 제목) — VARCHAR — NOT NULL
  • description (프로젝트 설명) — TEXT — NOT NULL
  • recurit_deadline (모집 마감일) — DATE — NOT NULL
  • start_date (프로젝트 시작 예정일) — DATE — NOT NULL
  • end_date (프로젝트 종료 예정일) — DATE — NOT NULL
  • status (진행상황) — ENUM — NOT NULL — RECRUITING, IN_PROGRESS, COMPLETED 등
  • view_count (조회수) — INTEGER — NOT NULL
  • created_at (가입일) — TIMESTAMP — NOT NULL
  • updated_at (수정일) — TIMESTAMP — NOT NULL
  • recruitcount (모집인원) — Integer — NOT NULL

ProjectTechStack (모집글-기술스택)

  • project_tech_stack_id (id) — INTEGER — Primary key — NOT NULL
  • project_id (프로젝트 ID) — SERIAL — Foreign key → ProjectRecruitment.project_id — NOT NULL
  • user_id (팀리더 ID) — BIGSERIAL — Foreign key → ProjectRecruitment.user_id — NOT NULL

RecommendationFeedback (추천 피드백)

  • feedback_id (피드백 ID) — SERIAL — Primary key — NOT NULL
  • user_id (피드백 제공 사용자 ID) — BIGSERIAL — Foreign key → User.user_id — NOT NULL
  • recommendation_history_id (추천 이력 ID) — SERIAL — Foreign key → RecommendationHistory.recommendation_history_id — NOT NULL
  • feedback_action (피드백 액) — ENUM — LIKE / DISLIKE
  • created_at (생성일) — TIMESTAMP — NOT NULL
  • updated_at (수정일) — TIMESTAMP — NOT NULL

RecommendationHistory (추천 이력 저장)

  • recommendation_history_id (추천 이력 ID) — SERIAL — Primary key — NOT NULL
  • user_id (추천 받은 사용자 ID) — BIGSERIAL — Foreign key → UserProfile.user_id — NOT NULL — pk, ref: > User.user_id, note: "공유 PK 1:1 (FK to User)"
  • recommended_project_id (추천된 프로젝트 ID) — SERIAL — Foreign key → ProjectRecruitment.project_id — NOT NULL
  • recommended_user_id (추천된 사용자 ID) — BIGSERIAL — Foreign key → ProjectRecruitment.user_id — NOT NULL
  • recommendation_type (추천 타입) — ENUM — NOT NULL — PROJECT / MEMBER
  • project_context_id (팀원 추천 프로젝트) — SERIAL — NOT NULL
  • match_score (AI가 계산한 매칭 점수) — FLOAT — NOT NULL
  • model_version (추천 생성 모델 버전) — VARCHAR — NOT NULL
  • is_clicked (추천 항목 클릭 여부) — BOOLEAN — NOT NULL
  • is_acted (지원/좋아요 등 여부) — BOOLEAN — NOT NULL
  • created_at (생성일) — TIMESTAMP — NOT NULL

TeamInvitation (팀 초대)

  • invitation_id (팀 초대 ID) — SERIAL — Primary key — NOT NULL
  • project_id (프로젝트 ID) — SERIAL — Foreign key → ProjectRecruitment.project_id — NOT NULL
  • inviter_id (팀리더 ID | 초대하는 사람) — BIGSERIAL — Foreign key → ProjectRecruitment.user_id — NOT NULL
  • invitee_id (회원 ID | 초대받는 사람) — BIGSERIAL — Foreign key → User.user_id — NOT NULL
  • status (초대 상태) — VARCHAR(20) — NOT NULL — PENDING, ACCEPTED, REJECTED
  • message (초대 메시지) — TEXT — NOT NULL
  • responded_at (응답 시간) — TIMESTAMP — NOT NULL

TechPart (기술파트)

  • tech_part_id (기술 파트 ID) — BIGINT — Primary key — NOT NULL
  • name (BACKEND, FRONTEND, DEVOPS 등) — VARCHAR — NOT NULL

TechStack (기술스택목록)

  • stack_id (기술스택 ID) — BIGINT — Primary key — NOT NULL
  • name (예: Java, Vue, Docker 등) — VARCHAR — NOT NULL

User (회원)

  • user_id (회원 ID) — BIGSERIAL — Foreign key → UserProfile.user_id — NOT NULL
  • email (이메일) — VARCHAR — NOT NULL — 일반/소셜 공통
  • password (비밀번호) — VARCHAR — 소셜 로그인시 NULL
  • nickname (닉네임) — CITEXT — NOT NULL
  • provider (로그인 방식) — ENUM — NOT NULL — EMAIL, GOOGLE, KAKAO
  • provider_user_id (소셜 로그인 제공 ID) — VARCHAR
  • created_at (가입일) — TIMESTAMP — NOT NULL
  • updated_at (수정일) — TIMESTAMP — NOT NULL
  • profile_image (프로필이미지) — TEXT

UserEducation (교육이력)

  • education_id (교육 ID) — BIGSERIAL — Primary key — NOT NULL
  • user_id (회원 ID) — BIGSERIAL — Foreign key → UserProfile.user_id — NOT NULL — pk, ref: > User.user_id, note: "공유 PK 1:1 (FK to User)"
  • institution (기관이름) — VARCHAR — NOT NULL
  • program (전공, 과정) — VARCHAR
  • start_date (입사일) — DATE — NOT NULL
  • end_date (퇴사일) — DATE
  • is_current (진행여부) — BOOLEAN — NOT NULL
  • created_at (생성일) — TIMESTAMP — NOT NULL
  • updated_at (수정일) — TIMESTAMP — NOT NULL

UserExperience (경력)

  • experience_id (경력 ID) — BIGSERIAL — Primary key — NOT NULL
  • user_id (회원 ID) — BIGSERIAL — Foreign key → UserProfile.user_id — NOT NULL — pk, ref: > User.user_id, note: "공유 PK 1:1 (FK to User)"
  • company_name (회사이름) — VARCHAR — NOT NULL
  • department (부서, 직책) — VARCHAR
  • start_date (입사일) — DATE — NOT NULL
  • end_date (퇴사일) — DATE
  • is_current (재직여부) — BOOLEAN — NOT NULL
  • summary (소개) — VARCHAR
  • created_at (생성일) — TIMESTAMP — NOT NULL
  • updated_at (수정일) — TIMESTAMP — NOT NULL

UserProfile (회원 상세 프로필)

  • user_id (회원 ID) — BIGSERIAL — Primary key — NOT NULL — pk, ref: > User.user_id, note: "공유 PK 1:1 (FK to User)"
  • tech_part_id (기술 파트 ID) — BIGINT — Foreign key → TechPart.tech_part_id — NOT NULL — FRONTEND, BACKEND, FULLSTACK, MOBILE, DEVOPS, DATA, AI_ML, DESIGN, PM, QM, ETC
  • bio (자기소개) — VARCHAR
  • phone (연락처) — VARCHAR
  • github_url (깃허브주소) — VARCHAR
  • linkedin_url (링크드인주소) — VARCHAR
  • website_url (웹사이트주소) — VARCHAR
  • is_portfolio_open (포트폴리오공개여부) — BOOLEAN — NOT NULL
  • is_contact_open (연락처공개여부) — BOOLEAN — NOT NULL
  • is_search_open (검색허용여부) — BOOLEAN — NOT NULL
  • reputation_score (평판점수) — DECIMAL(5,2) — NOT NULL
  • review_count (받은 리뷰수) — INT — NOT NULL
  • experience_range (경력기간) — ENUM — NOT NULL — FRESHER (신입) , LT_1( 1년미만). Y1_3( 1~3년), Y3_5(3~5년), Y5_10( 5~10년), GE_10( 10년이상)
  • job_title (직책) — VARCHAR

UserTechStack (회원 보유 기술 + 숙련도)

  • user_tech_stack_id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (회원 ID2) — BIGSERIAL — Foreign key → UserProfile.user_id — NOT NULL — pk, ref: > User.user_id, note: "공유 PK 1:1 (FK to User)"
  • stack_id (기술스택 ID) — BIGINT — Foreign key → TechStack.stack_id — NOT NULL
  • skill_level (숙련도) — TINYINT — 1~5

projectAttachment (파일업로드)

  • project_attachment_id (파일업로드 _id) — BIGINT — Primary key — NOT NULL — Auto-Increment
  • project_id (프로젝트 ID2) — SERIAL — Foreign key → ProjectRecruitment.project_id — NOT NULL
  • name (파일제목) — varchar(255) — NOT NULL
  • text (내용) — TEXT — NOT NULL
  • size (파일크기) — BIGINT — NOT NULL
  • url (S3 URL 저장용) — TEXT — NOT NULL