Data Types (Repository.Item Schema)
[This content is no longer valid. For the latest information on "M", "Quadrant", SQL Server Modeling Services, and the Repository, see the Model Citizen blog.]
The Repository.Item schema contains the following data types (UDTs).
Types
| Type | System type | Description |
|---|---|---|
int |
An integer that uniquely identifies a Modeling Services Folder within a single instance of the Modeling Services database. |
|
nvarchar(50) |
A unicode string for a Modeling Services Folder name, having a maximum length of 100 characters. |
|
varbinary(85) |
A binary security identifier (SID) of a principal. |
|
nvarchar(517) |
A name of a removal policy used with lifetime services. |
|
uniqueidentifier |
A GUID that represents an operation, such as read or update, in the Modeling Services database. |
|
sql_variant |
A value of a secured resource. |
|
bigint |
An integer that uniquely identifies a secured resource in the Modeling Services database. |
|
uniqueidentifier |
A GUID that represents the kind of a secured resource. |
|
bigint |
An integer that uniquely identifies a permission for a given resource. |
|
sql_variant |
A value of a security claim. |
|
bigint |
An integer that uniquely identifies a security claim. |
|
uniqueidentifier |
A GUID that represents the kind of security claim. |
|
smallint |
An integer identifier for a database session (a SQL Server SPID). |
|
varbinary(85) |
A Windows security identifier (SID). |