소공
테이블 (5)
Issue
- Key (issueId) — 기본 키 — NOT NULL
- Key (projectId) — 외래 키 → Untitled.Key — NOT NULL
- Field (title)
- Field2 (description)
- Key (reporter) — 외래 키 → Untitled.Key — NOT NULL
- Field4 (reported date)
- Key (assignee) — 외래 키 → Untitled.Key — NOT NULL
- Key (fixer) — 외래 키 → Untitled.Key — NOT NULL
- Field3 (priority)
- Field (status)
- Field (closed_date)
Untitled (Comment)
- Key (commentId) — 기본 키 — NOT NULL
- Key (projectId) — 외래 키 → Issue.Key — NOT NULL
- Key (issueId) — 외래 키 → Issue.Key — NOT NULL
- Key (userId) — 외래 키 → Untitled.Key — NOT NULL
- Field (content)
- Field2 (date)
Untitled (User)
- Key (userId) — 기본 키 — NOT NULL
- Field (username)
- Field (password)
Untitled (Project)
- Key (projectId) — 기본 키 — NOT NULL
- Field (title)
- Field (description)
- Field (date)
- Field (status)
Untitled (Project-User Role)
- Key (projectId) — 외래 키 → Untitled.Key — NOT NULL
- Key (userId) — 외래 키 → Untitled.Key — NOT NULL
- Field (role)
- Field (date)