pr2v1
Tables (12)
client_profile
- id — BIGINT — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- client_type — ENUM('INDIVIDUAL', 'TEAM', 'SOLE_PROPRIETOR', 'CORPORATION') — NOT NULL
- slogan — VARCHAR(255) — NOT NULL
partner_advanced_skills
- id — BIGINT — NOT NULL
- partner_profile_id — BIGINT — Foreign key → partner_profile.id — NOT NULL
- skill_id — BIGINT — Foreign key → skill_master.id
- custom_skill_name — VARCHAR(100)
- proficiency_level — ENUM('BEGINNER', 'INTERMEDIATE', 'ADVANCED', 'EXPERT')
- experience_years — ENUM('UNDER_1Y', '1_3Y', '3_5Y', '5+Y')
- created_at — DATETIME — NOT NULL
partner_profile
- id — BIGINT — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- work_category — ENUM('DEVELOP', 'PLANNING', 'DESIGN', 'DISTRIBUTION') — NOT NULL
- job_roles — JSON — NOT NULL
- partner_type — ENUM('INDIVIDUAL', 'TEAM', 'SOLE_PROPRIETOR', 'CORPORATION') — NOT NULL
- preferred_project_type — ENUM('FREELANCE', 'CONTRACT_BASED') — NOT NULL
- work_available_hours — JSON — NOT NULL
- communication_channels — JSON — NOT NULL
- dev_level — ENUM('JUNIOR', 'MIDDLE', 'SENIOR_5_7Y', 'SENIOR_7_10Y', 'LEAD') — NOT NULL
- dev_experience — ENUM('UND_1Y', '1_3Y', '3_5Y', '5_7Y', 'OVER_7Y') — NOT NULL
- work_preference — ENUM('REMOTE', 'ONSITE', 'HYBRID') — NOT NULL
- slogan — VARCHAR(200) — NOT NULL
- salary_hour — INT
- salary_month — INT
- github_url — VARCHAR(500)
- blog_url — VARCHAR(500)
- youtube_url — VARCHAR(500)
- portfolio_file_url — VARCHAR(1000)
- portfolio_file_tag — JSON
- bio_file_url — VARCHAR(1000)
- bio_file_tag — JSON
- hashtags — JSON
- bio — TEXT
- grade — ENUM('SILVER', 'GOLD', 'PLATINUM', 'DIAMOND')
partner_profile_detail
- id — BIGINT — NOT NULL
- partner_profile_id — BIGINT — Foreign key → partner_profile.id — NOT NULL
- show_bio — BOOLEAN
- show_skills — BOOLEAN
- show_experience — BOOLEAN
- show_education — BOOLEAN
- show_certificates — BOOLEAN
- show_awards — BOOLEAN
- show_portfolio — BOOLEAN
- show_evaluations — BOOLEAN
- detailed_bio — TEXT
- core_strengths — TEXT
- experience_json — JSON
- education_json — JSON
- certificates_json — JSON
- awards_json — JSON
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
partner_skill
- id — BIGINT — NOT NULL
- partner_profile_id — BIGINT — Foreign key → partner_profile.id — NOT NULL
- skill_id — BIGINT — Foreign key → skill_master.id — NOT NULL
project_field_mapping
- id — BIGINT — NOT NULL
- project_id — BIGINT — Foreign key → projects.id — NOT NULL
- field_id — INT — Foreign key → project_field_master.id — NOT NULL
project_field_master
- id — INT — NOT NULL
- parent_category — VARCHAR(100) — NOT NULL
- field_name — VARCHAR(100) — NOT NULL
- INDEX — idx_parent
project_recruit_roles
- id — BIGINT — NOT NULL
- project_id — BIGINT — Foreign key → projects.id — NOT NULL
- role_job — VARCHAR(100) — NOT NULL
- experience — VARCHAR(100)
- level — VARCHAR(100)
- salary — VARCHAR(100)
- skills — JSON
- requirement — TEXT
- headcount — INT
project_skill_mapping
- id — BIGINT — NOT NULL
- project_id — BIGINT — Foreign key → projects.id — NOT NULL
- skill_id — BIGINT — Foreign key → skill_master.id — NOT NULL
- INDEX — idx_skill_search
projects
- id — BIGINT — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- project_type — ENUM('OUTSOURCE', 'FULLTIME') — NOT NULL
- title — VARCHAR(255) — NOT NULL
- work_scope — JSON — NOT NULL
- category — JSON — NOT NULL
- outsource_project_type — ENUM('NEW', 'EXISTING')
- ready_status — ENUM('IDEA', 'DOCS', 'DESIGN', 'MAINTENANCE')
- reference_file_url — VARCHAR(1000)
- visibility — ENUM('EVERYONE', 'PARTNER', 'PRIVATE', 'NONE')
- work_style — ENUM('STATION', 'REMOTE', 'HYBRID')
- work_location — VARCHAR(255)
- work_days — ENUM('3', '4', '5', 'NEGOTIABLE')
- work_hours — ENUM('9_6', '10_7', 'FREE', 'NEGOTIABLE')
- contract_months — INT
- monthly_rate — INT
- detail_content — TEXT — NOT NULL
- budget_amount — INT
- is_partner_free — BOOLEAN
- start_date_negotiable — BOOLEAN
- start_date — DATE
- duration_months — INT
- schedule_negotiable — BOOLEAN
- dev_stage — ENUM('IDEA', 'DESIGN', 'DEVELOPMENT', 'TEST', 'MAINTENANCE')
- team_size — ENUM('1', '2_5', '6_10', '11+')
- current_stacks — JSON
- current_status — TEXT
- meeting_type — ENUM('ONLINE', 'OFFLINE', 'BOTH', 'NONE')
- meeting_freq — ENUM('1', '2_3', 'NECESSARY', 'REGULAR')
- meeting_tools — JSON
- deadline — DATE — NOT NULL
- gov_support — BOOLEAN — NOT NULL
- req_tags — JSON
- questions — JSON
- it_exp — BOOLEAN — NOT NULL
- collab_planning — INT
- collab_design — INT
- collab_publishing — INT
- collab_dev — INT
- additional_file_url — VARCHAR(1000)
- additional_comment — TEXT — EXT NUL
- status — ENUM('RECRUITING', 'IN_PROGRESS', 'COMPLETED', 'CANCELLED')
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
skill_master
- id — BIGINT — NOT NULL
- name — VARCHAR(100) — NOT NULL
users
- id — BIGINT — NOT NULL
- email — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- user_type — ENUM('PARTNER', 'CLIENT') — NOT NULL
- interests — TEXT — NOT NULL
- contact_email — VARCHAR(100)
- gender — ENUM('MALE', 'FEMALE', 'OTHER')
- birth_date — DATE
- region — VARCHAR(50)
- tax_email — VARCHAR(100)
- fax_number — VARCHAR(50)
- bank_name — VARCHAR(50)
- bank_account_number — VARCHAR(50)
- bank_account_holder_name — VARCHAR(50)
- profile_image_url — VARCHAR(512)