JOBHUB

Tables (35)

applications

  • id — bigint — Primary key — NOT NULL — 지원 ê³ ìœ ID
  • applied_at — datetime(6) — NOT NULL — 지원 일시
  • posting_id — bigint — Foreign key → job_postings.id — NOT NULL — ê³µê³ ID
  • resume_id — bigint — Foreign key → resumes.id — NOT NULL — 지원에 사용된 ì´ë ¥ì„œ ID
  • user_id — bigint — Foreign key → users.id — NOT NULL — 지원자 ID
  • viewed_at — datetime(6) — 열람 일시
  • status — enum('APPLIED', 'HIRED', 'INTERVIEW_REQUEST', 'OFFERED', 'REJECTED', 'VIEWED') — NOT NULL — 지원 상태

community_posts

  • id — bigint — Primary key — NOT NULL — 게시글 PK
  • content — text — 게시글 ë‚´ìš©
  • created_at — datetime(6) — NOT NULL — 생성일
  • title — varchar(200) — NOT NULL — 게시글 ì œëª©
  • updated_at — datetime(6) — NOT NULL — ìˆ˜ì •ì¼
  • view_count — int — NOT NULL — 조회수
  • user_id — bigint — Foreign key → users.id — NOT NULL — 작성자 FK (users.id)

community_posts_comments

  • id — bigint — Primary key — NOT NULL — 댓글 PK
  • content — text — NOT NULL — 댓글 ë‚´ìš©
  • created_at — datetime(6) — NOT NULL — 작성일
  • updated_at — datetime(6) — NOT NULL — ìˆ˜ì •ì¼
  • post_id — bigint — Foreign key → community_posts.id — NOT NULL — 게시글 FK
  • user_id — bigint — Foreign key → users.id — NOT NULL — 작성자 FK

companies

  • id — bigint — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL — 회사명
  • business_number — varchar(255) — NOT NULL
  • industry_id — bigint — Foreign key → industries.id
  • company_size_id — int — Foreign key → company_sizes.id — 회사 규모
  • founded_year — smallint — 설립년도
  • is_verified — tinyint(1) — NOT NULL — 인증 여부
  • active_job_count — int — 현재 진행중인 ì±„ìš©ê³µê³ ìˆ˜
  • avg_rating — decimal(2, 1) — í‰ê· í‰ì  (1.0 ~ 5.0)
  • owner_id — bigint — Foreign key → users.id — 기업 ì†Œìœ ìž (Users 테이블의 COMPANY 타입 회원)

company_bookmarks

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → users.id — NOT NULL
  • company_id — bigint — Foreign key → companies.id — NOT NULL
  • created_at — timestamp

company_details

  • company_id — bigint — Foreign key → companies.id — NOT NULL
  • website_url — varchar(255)
  • benefits — json
  • culture — text
  • description — text
  • logo_url — text
  • mission — text

company_sizes

  • id — int — Primary key — NOT NULL — 회사 규모 ID
  • label — varchar(100) — NOT NULL — 규모 이름
  • min_employees — int — 최소 직원 수
  • max_employees — int — 최대 직원 수

faqs

  • id — bigint — Primary key — NOT NULL
  • category — varchar(50) — NOT NULL
  • question — varchar(255) — NOT NULL
  • answer — text — NOT NULL
  • created_at — timestamp — NOT NULL

group_chat_members

  • id — bigint — Primary key — NOT NULL — 참여자 PK
  • joined_at — datetime(6) — NOT NULL — 입장 시각
  • room_id — bigint — Foreign key → group_chat_rooms.id — NOT NULL — 그룹 채팅방 FK
  • user_id — bigint — Foreign key → users.id — NOT NULL — 참여자 FK

group_chat_messages

  • id — bigint — Primary key — NOT NULL — 메시지 PK
  • room_id — bigint — Foreign key → group_chat_rooms.id — NOT NULL — 채팅방 FK
  • sender_id — bigint — Foreign key → users.id — NOT NULL — 보낸 사람 FK
  • sent_at — datetime(6) — NOT NULL — ì „ì†¡ 시각
  • message — text — NOT NULL — 메시지 ë‚´ìš©

group_chat_rooms

  • id — bigint — Primary key — NOT NULL — 그룹 채팅방 PK
  • created_at — datetime(6) — NOT NULL — 생성일
  • created_by — bigint — Foreign key → users.id — NOT NULL — 생성자 FK
  • room_name — varchar(255) — 채팅방 이름

industries

  • id — bigint — Primary key — NOT NULL
  • name — varchar(255)

interview_reviews

  • id — bigint — Primary key — NOT NULL — ë©´ì ‘ 후기 PK
  • interview_date — date — ë©´ì ‘ ë‚ ì§œ
  • created_at — datetime(6) — NOT NULL — 작성일
  • job_posting_id — bigint — Foreign key → job_postings.id — ê³µê³ FK
  • updated_at — datetime(6) — NOT NULL — ìˆ˜ì •ì¼
  • user_id — bigint — Foreign key → users.id — NOT NULL — 작성자 FK
  • interview_type — varchar(100) — ë©´ì ‘ ìœ í˜•
  • interviewers — varchar(100) — ë©´ì ‘ 인원
  • difficulty — enum('쉬움', '보통', 'ì–´ë ¤ì›€') — 난이도
  • process_text — text — ì§„í–‰ 방식
  • question_tags — text — 질문 ìœ í˜• ë°°ì—´
  • question_text — text — 질문 ë‚´ìš©
  • result — enum('불합격', '합격') — ê²°ê³¼
  • review_text — text — 기타 후기
  • tip_text — text — 팁 및 특이사항

job_categories

  • id — int — Primary key — NOT NULL — 직무 코드
  • level — smallint — NOT NULL
  • parent_id — int — Foreign key → job_categories.id — 상위 직무 분류
  • name — varchar(100) — NOT NULL — 직무명

job_posting_categories

  • id — bigint — Primary key — NOT NULL — PK
  • created_at — datetime(6) — NOT NULL — 생성일시
  • is_primary — tinyint(1) — NOT NULL — 주 직무 여부
  • category_id — int — Foreign key → job_categories.id — NOT NULL — 직무 ì¹´í…Œê³ ë¦¬ ID (FK)
  • posting_id — bigint — Foreign key → job_postings.id — NOT NULL — ì±„ìš©ê³µê³ ID (FK)

job_posting_conditions

  • posting_id — bigint — Foreign key → job_postings.id — NOT NULL
  • max_experience_years — smallint — 최대 ê²½ë ¥ 년수
  • max_salary — int — 최대 급여
  • min_experience_years — smallint — NOT NULL — 최소 ê²½ë ¥ 년수
  • min_salary — int — 최소 급여
  • etc — varchar(255) — NOT NULL — 우대사항
  • work_schedule — varchar(255) — NOT NULL
  • education_level — enum('ANY', 'COLLEGE', 'HIGH_SCHOOL', 'MASTER', 'PHD', 'UNIVERSITY') — NOT NULL — í•™ë ¥ 요구사항
  • employment_type — enum('CONTRACT', 'FREELANCE', 'FULL_TIME', 'INTERN', 'PART_TIME') — NOT NULL — ê³ ìš© 형태
  • experience_level — enum('ENTRY', 'EXECUTIVE', 'JUNIOR', 'LEAD', 'MID', 'SENIOR') — NOT NULL
  • salary_type — enum('ANNUAL', 'HOURLY', 'MONTHLY', 'NEGOTIABLE', 'UNDISCLOSED') — NOT NULL — 급여 ìœ í˜•

job_posting_likes

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → users.id — NOT NULL
  • job_posting_id — bigint — Foreign key → job_postings.id — NOT NULL
  • created_at — timestamp

job_posting_locations

  • id — bigint — Primary key — NOT NULL — PK
  • created_at — datetime(6) — NOT NULL — 생성일시
  • is_primary — tinyint(1) — NOT NULL — 주 근무지 여부
  • posting_id — bigint — Foreign key → job_postings.id — NOT NULL — ì±„ìš©ê³µê³ ID (FK)
  • region_id — int — Foreign key → regions.id — NOT NULL — 지역 ID (FK)

job_postings

  • id — bigint — Primary key — NOT NULL — ê³µê³ ê³ ìœ ID
  • company_id — bigint — Foreign key → companies.id — NOT NULL — 회사 ID
  • title — varchar(255) — NOT NULL — ê³µê³ ì œëª©
  • status — enum('DRAFT', 'OPEN', 'CLOSED', 'EXPIRED') — NOT NULL — ê³µê³ ìƒíƒœ (DRAFT/OPEN/CLOSED/EXPIRED)
  • close_type — enum('DEADLINE', 'UNTIL_FILLED', 'CONTINUOUS', 'PERIODIC') — NOT NULL — 마감 ìœ í˜•
  • is_remote — tinyint(1) — NOT NULL — 재택근무 가능 여부
  • view_count — int — NOT NULL — 조회수
  • application_count — int — NOT NULL — 지원자수
  • open_date — timestamp — ê³µê³ ì‹œìž‘ì¼ì‹œ
  • close_date — timestamp — ê³µê³ ë§ˆê°ì¼ì‹œ
  • created_by — bigint — Foreign key → users.id — NOT NULL — 작성자 ID
  • created_at — datetime — NOT NULL — 작성일시
  • updated_at — datetime — NOT NULL — 업데이트 일시
  • search_text — text — 통합 검색을 위한 텍스트 (ì œëª©+회사명+직무명)
  • description — mediumtext — ê³µê³ ë³¸ë¬¸

one_to_one_chat_rooms

  • id — bigint — Primary key — NOT NULL — 1:1 채팅방 PK
  • created_at — datetime(6) — NOT NULL — 생성일
  • sent_at — datetime(6) — NOT NULL — ì „ì†¡ 시각
  • user_id — bigint — Foreign key → users.id — NOT NULL — ìœ ì €(users.id)
  • message — text — NOT NULL — 채팅 메시지
  • room_key — varchar(100) — NOT NULL — 채팅방 식별자
  • companies_id — bigint — Foreign key → companies.id — NOT NULL — 기업 (companies.id)

regions

  • id — int — Primary key — NOT NULL
  • level — smallint — NOT NULL — 계층 ë ˆë²¨ (1=시도, 2=시군구)
  • parent_id — int — Foreign key → regions.id
  • name — varchar(100) — NOT NULL

resume_activities

  • id — bigint — Primary key — NOT NULL — í™œë™ê²½ë ¥ ID
  • resume_id — bigint — Foreign key → resumes.id — NOT NULL — ì´ë ¥ì„œ ID
  • activity_name — varchar(255) — NOT NULL — 활동명
  • organization — varchar(255) — 활동 기관/단체
  • role — varchar(255) — ì—­í•
  • start_date — date — 시작일
  • end_date — date — 종료일
  • description — tinytext — 활동 설명

resume_awards

  • id — bigint — Primary key — NOT NULL — ìˆ˜ìƒê²½ë ¥ ID
  • resume_id — bigint — Foreign key → resumes.id — NOT NULL — ì´ë ¥ì„œ ID
  • award_name — varchar(255) — NOT NULL — 수상명
  • organization — varchar(255) — NOT NULL — 수여기관
  • award_date — date — NOT NULL — 수상일
  • description — text — 수상 설명

resume_certifications

  • id — bigint — Primary key — NOT NULL — 자격증 ID
  • resume_id — bigint — Foreign key → resumes.id — NOT NULL — ì´ë ¥ì„œ ID
  • certification_name — varchar(255) — NOT NULL — 자격증명
  • issuing_organization — varchar(255) — NOT NULL — 발급기관
  • issue_date — date — NOT NULL — 취득일
  • expiry_date — date — 만료일
  • certification_number — varchar(100) — 자격증 번호

resume_educations

  • id — bigint — Primary key — NOT NULL — í•™ë ¥ ID
  • resume_id — bigint — Foreign key → resumes.id — NOT NULL — ì´ë ¥ì„œ ID
  • school_name — varchar(255) — NOT NULL — 학교명
  • school_type — varchar(50) — 학교구분
  • major — varchar(255) — ì „ê³µ
  • minor — varchar(255) — ë¶€ì „ê³µ
  • degree — varchar(100) — 학위
  • admission_date — date — 입학일
  • graduation_date — date — 졸업일
  • graduation_status — varchar(50) — 졸업상태
  • gpa — decimal(3, 2) — í•™ì 
  • max_gpa — decimal(3, 2) — ìµœëŒ€í•™ì 

resume_experiences

  • id — bigint — Primary key — NOT NULL — ê²½ë ¥ ID
  • resume_id — bigint — Foreign key → resumes.id — NOT NULL — ì´ë ¥ì„œ ID
  • company_name — varchar(255) — NOT NULL — 회사명
  • company_id — bigint — Foreign key → companies.id — 회사 ID (매칭된 경우)
  • position — varchar(255) — NOT NULL — 직책/직급
  • employment_type — enum('FULL_TIME', 'PART_TIME', 'CONTRACT', 'INTERN', 'FREELANCE') — ê³ ìš©í˜•íƒœ
  • start_date — date — NOT NULL — 입사일
  • end_date — date — 퇴사일
  • is_current — tinyint(1) — NOT NULL — 재직중 여부
  • description — text — 업무 설명
  • achievements — text — 주요 성과

resume_languages

  • id — bigint — Primary key — NOT NULL — ì–´í•™ëŠ¥ë ¥ ID
  • resume_id — bigint — Foreign key → resumes.id — NOT NULL — ì´ë ¥ì„œ ID
  • language — varchar(100) — NOT NULL — 언어
  • proficiency_level — varchar(50) — ìˆ™ë ¨ë„
  • test_name — varchar(100) — 어학시험명
  • test_score — varchar(50) — ì‹œí—˜ì ìˆ˜
  • test_date — date — 응시일

resume_portfolios

  • id — bigint — Primary key — NOT NULL — 포트폴리오 ID
  • resume_id — bigint — Foreign key → resumes.id — NOT NULL — ì´ë ¥ì„œ ID
  • title — varchar(255) — NOT NULL — 포트폴리오 ì œëª©
  • url — varchar(255) — NOT NULL — 포트폴리오 URL
  • description — text — 설명
  • portfolio_type — varchar(50) — 포트폴리오 ìœ í˜•

resume_projects

  • id — bigint — Primary key — NOT NULL — í”„ë¡œì íŠ¸ ID
  • resume_id — bigint — Foreign key → resumes.id — NOT NULL — ì´ë ¥ì„œ ID
  • project_name — varchar(255) — NOT NULL — í”„ë¡œì íŠ¸ëª…
  • organization — varchar(255) — 수행 기관/회사
  • role — varchar(255) — ì—­í•
  • start_date — date — 시작일
  • end_date — date — 종료일
  • is_ongoing — tinyint(1) — NOT NULL — 진행중 여부
  • project_url — varchar(255) — í”„ë¡œì íŠ¸ URL
  • description — text — í”„ë¡œì íŠ¸ 설명
  • tech_stack — json — 사용 ê¸°ìˆ ìŠ¤íƒ

resumes

  • id — bigint — Primary key — NOT NULL — ì´ë ¥ì„œ ê³ ìœ ID
  • user_id — bigint — Foreign key → users.id — NOT NULL — 사용자 ID
  • title — varchar(255) — NOT NULL — ì´ë ¥ì„œ ì œëª©
  • is_primary — tinyint(1) — NOT NULL — 대표 ì´ë ¥ì„œ 여부
  • is_public — tinyint(1) — NOT NULL — 공개 여부
  • completion_rate — smallint — NOT NULL — 완성도 (%)
  • created_at — datetime(6) — NOT NULL — 생성일시
  • status — varchar(20) — NOT NULL — ì´ë ¥ì„œ 상태 (작성 중, 작성 완료)
  • updated_at — datetime(6) — NOT NULL — ìˆ˜ì •ì¼ì‹œ

search_keywords

  • id — bigint — Primary key — NOT NULL
  • is_trending — bit(1) — NOT NULL — 급상승 키워드 여부
  • keyword — varchar(100) — NOT NULL — 검색 키워드
  • last_searched_at — datetime(6) — 마지막 검색 시간
  • search_count — bigint — NOT NULL — 검색 횟수

skill_categories

  • id — int — Primary key — NOT NULL
  • name — varchar(255)

skills

  • id — int — Primary key — NOT NULL — ê¸°ìˆ ID
  • category_id — int
  • is_verified — bit(1) — NOT NULL — 검증 여부
  • name — varchar(100) — NOT NULL

user_profiles

  • user_id — bigint — Foreign key → users.id — NOT NULL
  • birth_year — smallint
  • location_region_id — int — Foreign key → regions.id
  • name — varchar(100) — NOT NULL
  • headline — varchar(255)
  • phone — varchar(255)
  • profile_image_url — longtext
  • summary — longtext
  • birth_date — date

users

  • id — bigint — Primary key — NOT NULL — 사용자 ê³ ìœ ID
  • email — varchar(255) — NOT NULL — 이메일 (로그인 ID)
  • password_hash — varchar(255) — NOT NULL — 비밀번호 해시
  • user_type — enum('USER', 'COMPANY', 'ADMIN') — NOT NULL
  • is_active — tinyint(1) — NOT NULL — 활성 상태
  • last_login_at — timestamp — 마지막 로그인 일시
  • created_at — timestamp — NOT NULL — 생성일시
  • email_verfied_at — datetime(6)