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