QUERYID (PK)

Numeric identifier for the query.

QUERYREV (PK)

Revision number for the query.

QUERYSTATE

Query state:

0 - Candidate
1 - Opened
2 - Answered
3 - Closed
4 - Deleted

QUERYSTATETIME

Time the query was changed to the state.

QUERYUSERID

Numeric identifier of user who made the state change.

QUERYTEXT

Text associated with the state change.

QSTATEORDER

Query change ordinal 1..n (ordered by QUERYREV).

PREVQUERYSTATE

Previous query state (NULL if first revision).

PREVQUERYSTATETIME

Time the state was previously changed (NULL if first revision).

PREVQUERYUSERID

User who made the previous state change (NULL if first revision).

PREVQUERYTEXT

Previous query text (NULL if first revision).

NEXTQUERYSTATE

Next query state (NULL if current revision).

NEXTQUERYSTATETIME

Time the query was changed to the next state (NULL if current revision).

NEXTQUERYUSERID

User who made the next state change (NULL if current revision).

NEXTQUERYTEXT

Next query text (NULL if current revision).

CREATEDBYUSERID

User ID of the user whose action resulted in the given view row being created.

CREATEDBYDATETIME

Date and time when the view row was created.

MODIFIEDBYUSERID

User ID of the user whose action resulted in the most recent change to data in the given view row.

MODIFIEDDATETIME

Date and time when the data in the view row was most recently updated.