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