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