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