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)