Developer Documentation Library > Interviewer - Server > Administration and maintenance > Databases > Quota database > QUOTA_CompleteHistory table
 
QUOTA_CompleteHistory table
This table holds information about which quotas have completed.
Definition
CREATE TABLE QUOTA_CompleteHistory (
  Instance_ID    int(4)       NOT NULL
  Quota_ID       int(4)       NOT NULL
  InstanceCount  int(4)       NOT NULL
  Tstmp          datetime(8)  NOT NULL DEFAULT (getdate())
  PendResult     int(4)       NOT NULL
)
Columns
Instance_ID
The interview’s program ID.
Quota_ID
The foreign key to the QUOTA_Quota table.
InstanceCount
The count that the program has for the current quota.
Tstmp
A timestamp.
PendResult
The interview’s pending result.
See also
Quota database