Table sem5.dbo.BASIC_METADATA
Keeps policy and various server settings

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 Deleted flag; 0 = Not deleted, 1 = Deleted
ID char 32
OWNER char 32  √  null GUID of the owner. It only applies to a private 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 object belong to.
SemRootConfig and SemSite do not have DOMAIN_ID
REF_ID varchar 32  √  null Object reference ID
NAME nvarchar 4000  √  null Object name
DESCRIPTION nvarchar 4096  √  null Object description
LAST_MODIFY_TIME bigint 8  √  null Last modify 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
DISABLED tinyint 1  √  null Indicate the policy is disabled or not

Analyzed at Mon Oct 29 12:07 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc PK_BASIC_METADATA
ID + CHECKSUM + DELETED + DOMAIN_ID Performance Asc/Asc/Asc/Asc I_BASIC_METADATA_ID_CHECKSUM
OWNER Performance Asc I_BASIC_METADATA_OWNER
TYPE + DELETED Performance Asc/Asc I_BASIC_METADATA_TYPE_DEL
USN Performance Asc I_BASIC_METADATA_USN