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