title
Tables (7)
Comments (댓글)
- comment_id (댓글 id) — UUID — Primary key — NOT NULL
- user_id (유저 id) — UUID — Foreign key → Users.user_id — NOT NULL
- issue_id (이슈 id) — UUID — Foreign key → Issues.issue_id — NOT NULL
- content (내용) — TEXT
- file (첨부 파일) — TEXT
- isClosed (닫힘 여부) — Boolean
- createdAt (작성 일자) — DATETIME
- updatedAt (수정 일자) — DATETIME
- emoji (반응) — STATUS
Issues (이슈)
- issue_id (이슈 id) — UUID — Primary key — NOT NULL
- user_id (유저 id) — UUID — Foreign key → Users.user_id — NOT NULL
- title (제목) — TEXT
- createdAt (생성 일자) — DATETIME
- updatedAt (수정 일자) — DATETIME
- milestone_id (마일스톤 id) — UUID — Foreign key → milestone.milestone_id — NOT NULL
Users (회원)
- user_id (유저 id) — UUID — Primary key — NOT NULL
- created_at (가입 일자) — DATETIME
- account_id (아이디) — VARCHAR
- password (비밀번호) — VARCHAR
- profile (프로필 사진) — TEXT
issue_labels (이슈에 달린 레이블)
- issue_label_id (pk) — Primary key — NOT NULL
- label_id (레이블 id) — UUID — Foreign key → label.label_id — NOT NULL
- issue_id (이슈 id) — UUID — Foreign key → Issues.issue_id — NOT NULL
label (레이블)
- label_id (레이블 id) — UUID — Primary key — NOT NULL
- name (이름) — VARCHAR
- description (설명) — TEXT
- background_color (16진수 배경 색상) — VARCHAR
manager (담당자)
- manager_id (담당자 id) — UUID — Primary key — NOT NULL
- user_id (유저 id) — UUID — Foreign key → Users.user_id — NOT NULL
- issue_id (이슈 id) — UUID — Foreign key → Issues.issue_id — NOT NULL
milestone (마일스톤)
- milestone_id (마일스톤 id) — UUID — Primary key — NOT NULL
- name (이름) — VARCHAR
- description (설명) — TEXT
- completedAt (완료 일정) — DATETIME
- isClosed (닫힘 여부) — Boolean