소공

테이블 (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)