issueAssignment
Tables (6)
Comment
- CommentID — INT — Primary key
- UserID — INT — Foreign key → Users.UserID
- TicketID — INT — Foreign key → Ticket.TicketID
- content — TEXT — EX
- TimeStamp — DATETIME
Member
- MemberID — INT — Primary key — NOT NULL
- ProjectID — INT — Foreign key → Project.ProjectID
- UserID — INT — Foreign key → Users.UserID
- Role — ENUM('ProjectLeader', 'Developer', 'Tester')
Milestone
- MilestoneID — INT — Primary key
- Name — VARCHAR(255) — NOT NULL
- StartDate — DATE
- DueDate — DATE
- Description — TEXT
Project
- ProjectID — INT — Primary key
- Name — VARCHAR(255) — NOT NULL
- Description — TEXT
- StartDate — DATE
- EndDate — DATE
Ticket
- TicketID — INT — Primary key
- MilestoneID — INT — Foreign key → Milestone.MilestoneID
- ReporterID — INT — Foreign key → Users.UserID
- DeveloperID — INT — Foreign key → Users.UserID
- ProjectID — INT — Foreign key → Project.ProjectID
- Status — ENUM('New', 'Assigned', 'Closed', 'Reopened') — NOT NULL
- Priority — ENUM('Blocker', 'Critical', 'Major', 'Minor', 'Trivial')
- CreatedTime — DATETIME
- ModifiedTime — DATETIME
- Component — ENUM(''UIComponent, 'DataAcessComponent', 'SecurityComponent')
- Description — TEXT
- Title — TEXT
Users (User)
- UserID — INT — Primary key
- Username — VARCHAR(255) — NOT NULL
- Password — VARCHAR(255) — NOT NULL
- Email — VARCHAR(255)
- isAdmin — boolean