h_clientstats

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ClientID INT 10 null
ClosedTickets INT 10 null
NewTickets INT 10 null
OpenTickets INT 10 null
AVGClose INT 10 null
TimeEnties INT 10 null
TotalTime INT 10 null
StatDate TIMESTAMP 19 CURRENT_TIMESTAMP

Indexes

Constraint Name Type Sort Column(s)
ClientID Must be unique Asc/Asc ClientID + StatDate

Diagram producer might be missing

No diagrams were produced please see application output for any errors