Trekker
Tables (10)
Job
- id — BIGINT
- name — ENUM('PM・서비스 기획자', 'UI/UX 디자이너', '프론트엔드 개발자', '백엔드 개발자') — NOT NULL
Onboarding
- user_id — BIGINT
- is_completed — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Project
- id — BIGINT
- user_id — BIGINT — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- start_date — DATE — NOT NULL
- end_date — DATE
- is_completed — BOOLEAN
- type — ENUM('개인', '팀') — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Report
- id — BIGINT
- user_id — BIGINT — NOT NULL
- month — DATE — NOT NULL
- weekly_completion — JSON
- monthly_completion — JSON
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Retrospective
- id — BIGINT
- task_id — BIGINT — NOT NULL
- content — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
RetrospectiveSkill
- id — BIGINT
- retrospective_id — BIGINT — NOT NULL
- skill_id — BIGINT — NOT NULL
- type — ENUM('소프트', '하드') — NOT NULL
Skill
- id — BIGINT
- name — VARCHAR(255) — NOT NULL
SocialProvider
- id — BIGINT
- name — ENUM('Kakao', 'Google') — NOT NULL
Task
- id — BIGINT
- project_id — BIGINT — NOT NULL
- name — VARCHAR(255) — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE
- is_completed — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
User
- Key — Primary key — NOT NULL
- id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255)
- social_provider_id — BIGINT
- role — ENUM('회원', '관리자')
- name — VARCHAR(255) — NOT NULL
- job_id — BIGINT
- profile_image — VARCHAR(255)
- portfolio_image — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP