Table sem5.dbo.IDENTITY_MAP
Keeps mapping of object ID and its name

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
ID char 32
NAME nvarchar 4000  √  null Name of the object
TYPE varchar 256  √  null Object Type Name
DOMAIN_ID char 32  √  null GUID of the domain
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
DELETED tinyint 1  √  null Deleted row; 0 = Not Deleted, 1 = Deleted

Analyzed at Mon Oct 29 12:07 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc PK_IDENTITY_MAP
ID Performance Asc I_IDENTITY_MAP_ID_PLUS
TYPE Performance Asc I_IDENTITY_MAP_TYPE_PLUS
TYPE + ID Performance Asc/Asc I_IDENTITY_MAP_TYPE_PLUS1