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 — 주요 성과 및 담당 업무