softwareEng

Tables (13)

Analyze (Analysis)

  • IssueID (Key) — INT — Foreign key → Issue.IssueID — NOT NULL
  • ProjectID (Key2) — INT — Foreign key → IssueManagementSystem.ProjectID — NOT NULL
  • Statistics (Field) — CHAR

Assigned (Assign)

  • IssueID (Key) — INT — Foreign key → Issue.IssueID — NOT NULL
  • AccountID (Key2) — INT — Foreign key → UserAccount.AccountID — NOT NULL

Comments (Comment)

  • IssueID (Key) — INT — Foreign key → Issue.IssueID — NOT NULL
  • Date (Field) — DATE
  • CommentDescription (Field2) — CHAR

Fixes (Fix)

  • AccountID (Key) — INT — Foreign key → UserAccount.AccountID — NOT NULL
  • IssueID (Key2) — INT — Foreign key → Issue.IssueID — NOT NULL

Issue

  • IssueID (Key) — INT — Primary key — NOT NULL
  • ProjectID (Key2) — INT — Foreign key → Project.ProjectID — NOT NULL
  • IssueTitle (Field) — CHAR
  • IssueDescription (Field2) — CHAR
  • IssueState (Field8) — CHAR
  • IssueReportDate (Field4) — DATE
  • IssuePriority (Field7) — CHAR
  • Reporter (Field3) — INT
  • Fixer (Field5) — INT
  • Assignee (Field6) — INT

IssueManagementSystem (IMS)

  • ProjectID (Key) — INT — Primary key — NOT NULL
  • UserAccount (Field) — INT

Manages (Management)

  • AccountID (Key) — INT — Foreign key → UserAccount.AccountID — NOT NULL
  • IssueID (Key2) — INT — Foreign key → Issue.IssueID — NOT NULL

Participate (Participants)

  • AccountID (Key) — INT — Foreign key → UserAccount.AccountID — NOT NULL
  • ProjectID (Key2) — INT — Foreign key → Project.ProjectID — NOT NULL

Project

  • ProjectID (Key2) — INT — Foreign key → IssueManagementSystem.ProjectID — NOT NULL
  • ProjectDescription (Field2) — CHAR

Register

  • AccountID (Key) — INT — Foreign key → UserAccount.AccountID — NOT NULL
  • ProjectID (Key2) — INT — Foreign key → IssueManagementSystem.ProjectID — NOT NULL

Report

  • AccountID (Key) — INT — Foreign key → UserAccount.AccountID — NOT NULL
  • IssueID (Key2) — INT — Foreign key → Issue.IssueID — NOT NULL

Search

  • ProjectID (Key) — INT — Foreign key → IssueManagementSystem.ProjectID — NOT NULL
  • IssueID (Key2) — INT — Foreign key → Issue.IssueID — NOT NULL

UserAccount

  • AccountID (Key) — INT — Primary key — NOT NULL
  • UserType (Field) — CHAR