Table sem5.dbo.SEM_COMPLIANCE_CRITERIA_2 Generated by
SchemaSpy
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
CRITERIA_IDX char 32
AGENT_SECURITY_LOG_IDX char 32
ACTION varchar 64 ('')
RULE_NAME nvarchar 512 ('')
RULE_TYPE varchar 64 ('')
CRITERIA varchar 256 ('')
TARGET nvarchar 512 ('')
RESULT varchar 64 ('')
ERROR varchar 128 ('')
DESCRIPTION nvarchar 512 ('')
USN bigint 8 ((1))
TIME_STAMP bigint 8 ((0))
DELETED tinyint 1 ((0))

Analyzed at Mon Oct 29 12:07 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
CRITERIA_IDX Primary key Asc PK_SEM_COMPLIANCE_CRITERIA_2
AGENT_SECURITY_LOG_IDX + DELETED + CRITERIA + TARGET + RESULT Performance Asc/Asc/Asc/Asc/Asc I_SEM_COMPLIANCE_2_LOG_IDX_PLUS