Table sem5.dbo.HISTORY
Keeps data snapshots used in reporting

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
HISTORY_IDX char 32
HISTORYCONFIG_IDX char 32 ('') Pointer to historyconfig table
EVENT_DATETIME bigint 8 ((0)) Snapshot time in GMT
STAT_TYPE varchar 64 ('') What kind of data; hard-coded English key **See Snapshot data format worksheet for details **
TARGET nvarchar 512 ('') Data **See Snapshot data format worksheet for details **
STATISTIC nvarchar 512 ('') Summary statistic **See Snapshot data format worksheet for details **

Analyzed at Mon Oct 29 12:07 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
HISTORY_IDX Primary key Asc PK_HISTORY