erd

Tables (20)

Certifications

  • certification_id — bigint
  • profile_id — bigint — Foreign key → Talent_profiles.profile_id — NOT NULL
  • name — varchar(100) — NOT NULL
  • issuer — varchar(100) — 발급기관
  • issue_date — date — 취득일

Company_inquiries (Untitled3)

  • inquiry_id (Field) — PK
  • company_name (Field2)
  • contact_person (Field3)
  • email (Field4)
  • content (Field5)

Company_inquiries

  • inquiry_id — bigint
  • user_id — bigint — Foreign key
  • company_name — varchar(100) — NOT NULL
  • contact_person — varchar(50)
  • department — varchar(50) — NOT NULL
  • position — varchar(50) — NOT NULL — 직책 추가
  • email — varchar(255) — NOT NULL
  • phone_number — varchar(20) — NOT NULL
  • content — text — NOT NULL
  • privacy_policy_agreed — boolean — NOT NULL — 개인정보처리방침 동의 여부 추가
  • created_at — timestamp — NOT NULL

Educations

  • education_id — bigint
  • profile_id — bigint — Foreign key → Talent_profiles.profile_id — NOT NULL
  • school_name — varchar(100) — NOT NULL
  • major — varchar(100)
  • status — varchar(20) — 재학, 졸업, 수료
  • description — text — 주요 활동

Experiences

  • experience_id — bigint
  • name — varchar(50) — NOT NULL

Job_categories

  • job_category_id — bigint
  • name — varchar(50) — NOT NULL — 예: 개발, 디자인

Languages

  • language_id — bigint
  • profile_id — bigint — Foreign key → Talent_profiles.profile_id — NOT NULL
  • language_name — varchar(50) — NOT NULL
  • level — varchar(20) — 어학 수준

Profile_experiences

  • profile_id — bigint — Foreign key → Talent_profiles.profile_id — NOT NULL
  • experience_id — bigint — Foreign key → Experiences.experience_id — NOT NULL

Profile_job_categories

  • profile_id — bigint — Foreign key → Talent_profiles.profile_id — NOT NULL
  • job_category_id — bigint — Foreign key → Job_categories.job_category_id — NOT NULL

Profile_links

  • link_id — bigint
  • profile_id — bigint — Foreign key → Talent_profiles.profile_id — NOT NULL
  • url — text — NOT NULL — URL 주소 또는 포트폴리오 PDF 파일의 스토리지 경로
  • type — varchar(20) — NOT NULL — 링크의 종류를 구분. 예: 'LINK' (일반 링크), 'PORTFOLIO' (포트폴리오 PDF)

Profile_tendencies

  • profile_id — bigint — Foreign key → Talent_profiles.profile_id — NOT NULL
  • tendency_id — bigint — Foreign key → Tendencies.tendency_id — NOT NULL

Roles

  • role_id — bigint
  • code — varchar(50) — NOT NULL
  • name — varchar(50) — NOT NULL

Roles (Untitled)

  • role_id (Field) — PK
  • name (Field2)

Talent_profiles

  • profile_id — bigint
  • user_id — bigint — Foreign key — NOT NULL
  • name — varchar(50) — NOT NULL
  • introduction — text
  • storage_url — text
  • likelion_code — varchar(100) — NOT NULL — 멋사 수료생 인증 코드 / 체크 표시하면 not null처리하여 진행
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

Talent_profiles (Untitled4)

  • profile_id (Field) — PK
  • user_id (Field2)
  • name (Field3)
  • introduction (Field4)
  • education (Field5)
  • skills (Field6)

Tendencies

  • tendency_id — bigint
  • category — varchar(50) — NOT NULL
  • name — varchar(50) — NOT NULL

User_roles

  • user_id — bigint — Foreign key — NOT NULL
  • role_id — bigint — Foreign key → Roles.role_id — NOT NULL

User_roles (Untitled2)

  • user_id (Field) — FK
  • role_id (Field2) — FK

Users

  • User_id (회원 고유 식별자) — PK
  • email (로그인 id)
  • password (비밀번호)
  • phone_number (전화번호)

Work_experiences

  • experience_id — bigint
  • profile_id — bigint — Foreign key → Talent_profiles.profile_id — NOT NULL
  • company_name — varchar(100) — NOT NULL
  • department — varchar(50)
  • position — varchar(50)
  • start_date — date
  • end_date — date
  • description — text — 주요 성과 및 담당 업무