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)