프로젝트 대시보드

테이블 (3)

Link (link)

  • Link Id (link_id) — int — 기본 키 — NOT NULL
  • Project Id (project_id) — int — 외래 키 → Project.Project Id — NOT NULL
  • Link Type (link_type) — ENUM
  • URL (url) — VARCHAR(1080)
  • Title (title) — VARCHAR(270)
  • Creator (creator) — VARCHAR(50)
  • Created Date (created_date) — Datetime
  • Updated Date (updated_date) — Datetime

Project (project)

  • Project Id (project_id) — int — 기본 키 — NOT NULL
  • Project Name (project_name) — VARCHAR(255)
  • Project Start Date (project_start_date) — Datetime
  • Project End Date (project_end_date) — Datetime
  • Created Date (created_date) — Datetime
  • Updated Date (updated_date) — Datetime

Sprint (sprint)

  • Sprint Id (sprint_id) — int — 기본 키 — NOT NULL
  • Project Id (project_id) — int — 외래 키 → Project.Project Id — NOT NULL
  • Sprint Name (sprint_name) — VARCHAR(270)
  • Sprint Start Date (sprint_start_date) — Datetime
  • Sprint End Date (sprint_end_date) — Datetime
  • Created Date (created_date) — Datetime
  • Updated Date (updated_date) — Datetime