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