프로젝트 대시보드
테이블 (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