Table sem5.dbo.BINARY_FILE
Keeps all binary files

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  √  null Checksum of XML content
CONTENT image 2147483647  √  null XML content of the schema object
DELETED tinyint 1 The deleted flag of the schema object:
1 = Deleted
0 = Not Deleted
ID char 32
OWNER char 32  √  null GUID of the owner. It only applies to private object
TIME_STAMP bigint 8 Time that the record was modified; used to resolve merge conflict
TYPE varchar 256  √  null Type name of the schema object
USN bigint 8 Update serial number; used by replication
DOMAIN_ID char 32  √  null GUID of the domain to which the binary file belongs
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_BINARY_FILE
USN Performance Asc I_BINARY_FILE_USN