ISTAPRO03-NEW.md

ISTAPRO03-B

Jacob Duenke
March 18, 2019

Tables:

• Users
• Employees
• NewTickets
• OpenTickets
• CompletedTickets

Users

• UserID
• UserName
• Email
• TicketNumber

Employees

• EmpID
• EmpName
• TicketNumber

NewTickets

• TicketNumber
• SubmitDate
• UserID
• Platform
• Issue

OpenTickets

• TicketNumber
• SubmitDate
• OpenDate
• EmpID
• UserID
• Platform
• Issue

CompletedTickets

• TicketNumber
• SubmitDate
• OpenDate
• CloseDate
• EmpID
• UserID
• Platform
• Issue
• Resolution