Table sem5.dbo.LOG_CONFIG
Keeps logs settings for switching log tables

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
LOG_TYPE int 4
TABLE_LIST varchar 250 The name of the tables to switch logs
THRESHOLD int 4 ((10000)) Threshold of the log count
EXPIRATION int 4 ((60)) Expiration date of the logs
CURRENT_TABLE varchar 60 Current log table name
CURRENT_ROWS int 4 Current log count in the log table
SWITCH_TIME bigint 8  √  null Last log switch time
RESERVED_INT1 int 4  √  null
RESERVED_INT2 int 4  √  null
RESERVED_BIGINT1 bigint 8  √  null
RESERVED_BIGINT2 bigint 8  √  null
RESERVED_CHAR1 char 32  √  null
RESERVED_CHAR2 char 32  √  null
RESERVED_VARCHAR1 nvarchar 520  √  null
RESERVED_BINARY varbinary 2000  √  null

Analyzed at Mon Oct 29 12:07 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
LOG_TYPE Primary key Asc PK_LOG_CONFIG