IssueTracker

Tables (6)

Comment

  • ID (댓글 ID) — Integer — Primary key — NOT NULL
  • createdBy_ID (유저 ID) — UUID — Foreign key → User.ID — NOT NULL
  • issue_ID (이슈ID2) — Integer — Foreign key → Issue.ID — NOT NULL
  • content (내용) — String(500)
  • createdAt (생성시간) — Timestamp

Issue

  • ID (이슈ID) — Integer — Primary key — NOT NULL
  • createdBy_ID (유저 ID) — UUID — Foreign key → User.ID — NOT NULL
  • title (제목) — String(200)
  • content (내용) — String(2000)
  • createdAt (생성시간) — Timestamp

Issue_Label

  • issue_ID (이슈ID) — Interger — Foreign key → Issue.ID — NOT NULL
  • label_ID (라벨 ID) — Integer — Foreign key → Label.ID — NOT NULL

Issue_Template

  • ID (템플릿 D) — String(100) — Primary key — NOT NULL
  • createdBy_ID (유저 ID) — UUID — Foreign key → User.ID — NOT NULL
  • title (제목) — String(200)
  • name (템플릿 이름) — String(200)
  • content (내용) — String(2000)

Label

  • ID (Key) — Integer — Primary key — NOT NULL
  • name (이름) — String(20)
  • description (설명) — String(200)
  • color (색생 키) — Integer

User (USER)

  • ID (유저 ID) — UUID — Primary key — NOT NULL
  • username (유저 닉네임) — String
  • password (비밀번호) — String