catissue_query_audit_logs

20 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
QUERY_ID BIGINT 19 √ null
catissue_saved_queries.IDENTIFIER FK_QAUDIT_LOG_QID_QUERIES_IDR
RUN_BY BIGINT 19 null
catissue_user.IDENTIFIER FK_QAUDIT_LOG_RUN_BY_USERS_IDR
TIME_OF_EXEC TIMESTAMP 19 CURRENT_TIMESTAMP
TIME_TO_FINISH INT 10 null
RUN_TYPE VARCHAR 16 null
RECORD_COUNT BIGINT 19 √ null
QUERY_SQL TEXT 65535 null
AQL TEXT 65535 √ null
IP_ADDRESS VARCHAR 255 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_QAUDIT_LOG_QID_QUERIES_ID Performance Asc QUERY_ID
FK_QAUDIT_LOG_RUN_BY_USERS_ID Performance Asc RUN_BY

Relationships

Close relationships within degrees of separation