Developer Documentation Library > Interviewer - Server > Administration and maintenance > Databases > Quota database > QUOTA_QuotaCount table
 
QUOTA_QuotaCount table
This table holds the latest counts for all quotas in the system. The counts are incremented by 1 each time a quota is pended.
Definition
CREATE TABLE QUOTA_QuotaCount (
  Quota_ID       int(4)  NOT NULL
  PendCount      int(4)  NOT NULL DEFAULT (0)
  CompleteCount  int(4)  NOT NULL DEFAULT (0)
  RollbackCount  int(4)  NOT NULL DEFAULT (0)
)
Columns
Quota_ID
The foreign key to the QUOTA_Quota table.
PendCount
The number of interviews pending for this quota.
CompleteCount
The number of completed interviews for this quota.
RollbackCount
The number of interviews that have been rolled back for this quota.
See also
Quota database