project2

Tables (36)

applications

  • apply_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • posting_id — BIGINT — NOT NULL
  • resume_id — BIGINT — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(120) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • status — ENUM('ACTIVE','REJECTED','HIRED') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

bookmarks

  • book_mark_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • posting_id — BIGINT — NOT NULL
  • status — ENUM('ACTIVE','INACTIVE') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

career

  • career_id — BIGINT
  • resume_id — BIGINT — NOT NULL
  • start_at — CHAR(6)
  • end_at — CHAR(6)
  • company_name — VARCHAR(200)
  • depart_position — VARCHAR(200)
  • tenure — ENUM('FULL','PART','INTERN')
  • now — ENUM('Y','N')
  • status — ENUM('ACTIVE','INACTIVE') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

categories

  • category_id — BIGINT — 카테고리 PK
  • name — VARCHAR(120) — NOT NULL — 카테고리명 / Category name
  • parent_id — BIGINT — 상위 카테고리 / Parent category

company_pictures

  • com_pic_id — BIGINT
  • company_id — BIGINT — NOT NULL
  • picture — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

conversations

  • conversation_id — BIGINT — 대화 스레드 PK
  • context_type — ENUM('REQUEST', 'PROJECT', 'HIRE') — NOT NULL — 컨텍스트
  • context_id — BIGINT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • INDEX — idx_conv_ctx

education

  • education_id — BIGINT
  • resume_id — BIGINT — NOT NULL
  • start_at — CHAR(6) — YYYYMM
  • end_at — CHAR(6) — YYYYMM
  • now — ENUM('Y', 'N')
  • name — VARCHAR(200)
  • major — VARCHAR(200)
  • info — TEXT
  • status — ENUM('ACTIVE', 'INACTIVE') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

etc_items

  • etc_id — BIGINT
  • resume_id — BIGINT — NOT NULL
  • date_ym — CHAR(6)
  • name — VARCHAR(255)
  • detail — TEXT
  • status — ENUM('ACTIVE','INACTIVE') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

favorites

  • favorite_id — BIGINT — 즐겨찾기 PK
  • user_id — BIGINT — NOT NULL — 누가 / by user
  • target_type — ENUM('USER', 'SERVICE', 'PROJECT', 'POSTING') — NOT NULL — 대상 타입
  • target_id — BIGINT — NOT NULL — 대상 ID
  • created_at — TIMESTAMP — NOT NULL
  • INDEX — idx_fav

follows

  • follow_id — BIGINT
  • company_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • status — ENUM('ACTIVE','INACTIVE') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

freelancer_profiles

  • profile_id — BIGINT — 프로필 PK / Profile PK
  • user_id — BIGINT — NOT NULL — users.user_id (1:1)
  • name — VARCHAR(120) — NOT NULL — 프로필명 / Display name
  • introduction — TEXT — 소개 / Introduction
  • region — VARCHAR(100) — 활동 지역 / Region
  • contactable_time — VARCHAR(100) — 연락 가능 시간 / Contactable time
  • number_of_employees — INT — 인원수(팀) / Team size
  • available_distance — INT — 가능 이동거리(km) / Travel distance
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

freelancer_services

  • profile_id — BIGINT — Primary key — NOT NULL
  • service_id — BIGINT — Primary key — NOT NULL

job_groups

  • job_group_id — BIGINT
  • group_name — VARCHAR(50) — NOT NULL
  • status — ENUM('ACTIVE','INACTIVE') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

job_posting_relation

  • job_posting_id — BIGINT
  • job_id — BIGINT — NOT NULL
  • posting_id — BIGINT — NOT NULL
  • status — ENUM('ACTIVE','INACTIVE') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

job_postings

  • posting_id — BIGINT
  • company_id — BIGINT — NOT NULL
  • job_group_id — BIGINT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • main_text — TEXT — NOT NULL
  • deadline — DATE — NOT NULL
  • recommend_money — BIGINT — NOT NULL
  • apply_money — BIGINT — NOT NULL
  • place_full — TEXT — NOT NULL
  • place_1 — VARCHAR(50) — NOT NULL
  • place_2 — VARCHAR(50) — NOT NULL
  • career_years — INT — NOT NULL
  • status — ENUM('ACTIVE','CLOSED') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

jobs

  • job_id — BIGINT
  • job_group_id — BIGINT — NOT NULL
  • job_name — VARCHAR(50) — NOT NULL
  • status — ENUM('ACTIVE','INACTIVE') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

language_scores

  • language_id — BIGINT
  • resume_id — BIGINT — NOT NULL
  • language — VARCHAR(30)
  • test_name — VARCHAR(30)
  • score — VARCHAR(20)
  • test_at — CHAR(8) — YYYYMMDD
  • status — ENUM('ACTIVE', 'INACTIVE') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

likes

  • like_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • posting_id — BIGINT — NOT NULL
  • status — ENUM('ACTIVE','INACTIVE') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

links

  • link_id — BIGINT
  • resume_id — BIGINT — NOT NULL
  • link — TEXT
  • status — ENUM('ACTIVE','INACTIVE') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

messages

  • message_id — BIGINT
  • conversation_id — BIGINT — NOT NULL
  • sender_id — BIGINT — NOT NULL
  • body — TEXT — NOT NULL
  • attachments — JSON
  • created_at — TIMESTAMP — NOT NULL

proposals

  • proposal_id — BIGINT — 제안서 PK
  • project_id — BIGINT — NOT NULL
  • freelancer_id — BIGINT — NOT NULL
  • price — INT
  • eta_days — INT
  • cover_letter — TEXT
  • status — ENUM('PENDING', 'SHORTLISTED', 'REJECTED', 'ACCEPTED') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

quotes

  • quote_id — BIGINT — 견적서 PK
  • request_id — BIGINT — NOT NULL
  • freelancer_id — BIGINT — NOT NULL
  • price — INT — 제안 금액
  • eta_days — INT — 예상 기간(일)
  • message — TEXT — 소개/메시지
  • status — ENUM('PENDING', 'ACCEPTED', 'REJECTED') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

request_answers

  • request_id — BIGINT — Primary key — NOT NULL
  • question_id — BIGINT — Primary key — NOT NULL
  • value — TEXT — NOT NULL — 답변 값

requests

  • request_id — BIGINT — 의뢰 요청서 PK
  • client_id — BIGINT — NOT NULL — 의뢰인 / Client user_id
  • category_id — BIGINT — NOT NULL
  • budget_min — INT
  • budget_max — INT
  • region — VARCHAR(100)
  • status — ENUM('OPEN', 'MATCHING', 'HIRED', 'CLOSED') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • INDEX — idx_req_cat_status

resumes

  • resume_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • resume_title — VARCHAR(100) — NOT NULL
  • introduce — TEXT
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(120) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • resume_status — ENUM('WRITING','COMPLETE') — NOT NULL
  • status — ENUM('ACTIVE','INACTIVE') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

reviews

  • review_id — BIGINT — 리뷰 PK
  • hire_id — BIGINT — NOT NULL
  • reviewer_id — BIGINT — NOT NULL
  • target_id — BIGINT — NOT NULL
  • rating — TINYINT — NOT NULL
  • content — TEXT
  • created_at — TIMESTAMP — NOT NULL

services

  • service_id — BIGINT — 서비스 PK / Service PK
  • category_id — BIGINT — NOT NULL — categories.category_id
  • name — VARCHAR(120) — NOT NULL — 서비스명 / Service name
  • created_at — TIMESTAMP — NOT NULL

skill_posting_relation

  • skill_set_id — BIGINT
  • skill_id — BIGINT — NOT NULL
  • posting_id — BIGINT — NOT NULL
  • status — ENUM('ACTIVE','INACTIVE') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

skill_resume_relation

  • skill_set_id — BIGINT
  • skill_id — BIGINT — NOT NULL
  • resume_id — BIGINT — NOT NULL
  • status — ENUM('ACTIVE','INACTIVE') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

skill_specialty_relation

  • skill_set_id — BIGINT
  • skill_id — BIGINT — NOT NULL
  • specialty_id — BIGINT — NOT NULL
  • status — ENUM('ACTIVE','INACTIVE') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

skills

  • skill_id — BIGINT — 스킬 PK
  • skill_name — VARCHAR(120) — NOT NULL — 스킬명 / Skill name
  • created_at — TIMESTAMP — NOT NULL

specialties

  • specialty_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • job_group — VARCHAR(50)
  • year — INT
  • salary — BIGINT
  • status — ENUM('ACTIVE','INACTIVE') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

tag_company_relation

  • tag_com_id — BIGINT
  • tag_id — BIGINT — NOT NULL
  • company_id — BIGINT — NOT NULL
  • status — ENUM('ACTIVE','INACTIVE') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

tags

  • tag_id — BIGINT
  • tag_name — VARCHAR(50) — NOT NULL
  • status — ENUM('ACTIVE','INACTIVE') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

trade_histories

  • trade_history_id — BIGINT — 거래 이력 PK
  • payment_id — BIGINT — NOT NULL
  • trade_date — TIMESTAMP — NOT NULL — 거래일
  • memo — VARCHAR(255) — 메모

user_skills

  • user_id — BIGINT — Primary key — NOT NULL
  • skill_id — BIGINT — Primary key — NOT NULL