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