tickets

34 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
TicketID INT 10 √ null
projects.TicketID Implied ConstraintR
ticketdata.TicketID Implied ConstraintR
timers.TicketID Implied ConstraintR
timeslips.TicketID Implied ConstraintR
v_tickets.TicketID Implied ConstraintR
v_time.TicketID Implied ConstraintR
ClientID INT 10 0
ProjectID INT 10 0
projects.ProjectID Implied ConstraintR
ComputerID INT 10 0
Status INT 10 1
Subject VARCHAR 255 null
Time INT 10 0
Priority INT 10 10
ticketpriority.Priority Implied ConstraintR
UserID INT 10 0
DueDate DATETIME 19 √ null
StartedDate DATETIME 19 null
ContactDate DATETIME 19 null
UpdateDate DATETIME 19 null
RequestorEmail VARCHAR 100 null
CCEmail VARCHAR 255 null
Level INT 10 null
Category INT 10 null
LocationID INT 10 null
ExternalID INT 10 null
MonitorId INT 10 null
monitortemplates.MonitorID Implied ConstraintR
GroupId INT 10 null
MobileDeviceId INT 10 null
GUID VARCHAR 100 null
DeviceID INT 10 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc TicketID
ClientID Performance Asc ClientID
ComputerID Performance Asc ComputerID
DeviceID Performance Asc DeviceID
ExternalID Performance Asc ExternalID
Priority Performance Asc Priority
StartedDate Performance Asc StartedDate
Status Performance Asc Status
UpdateDate Performance Asc UpdateDate
UserID Performance Asc UserID

Relationships

Close relationships within degrees of separation