Table sem5.dbo.SYSTEM_STATE
Keeps administrator and site health status information

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
CHECKSUM char 32 Checksum of XML content
CONTENT image 2147483647 XML content of the schema object
DELETED tinyint 1 tinyint, NOT NULL
ID char 32
OWNER char 32  √  null GUID of the corresponding schema object
TIME_STAMP bigint 8 Time that the record was modified; used to resolve merge conflict
TYPE varchar 256 Type name of the schema object
USN bigint 8 Update serial number; used by replication
DOMAIN_ID char 32  √  null GUID of the domain that the state object
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
ID Primary key Asc PK_SYSTEM_STATE
USN Performance Asc I_SYSTEM_STATE_USN