Content and tools

LTI Links data set: columns, keys and joins

Primary key: LtiLinkId 31 columns

Checked against D2L on October 31, 2026

Columns

Column	Type	Size	Key
`LtiLinkId`	`bigint`	`8`	PK
`OrgUnitId`	`int`	`4`	FK
`Title`	`nvarchar`	`200`
`LinkType`	`int`	`4`
`LTIVersion`	`varchar`	`12`
`Url`	`nvarchar`	`2000`
`Description`	`nvarchar`	`1000`
`IsVisible`	`bit`	`1`
`SendTCInfo`	`bit`	`1`
`SendContextInfo`	`bit`	`1`
`SendCourseInfo`	`bit`	`1`
`SendOrgUnitInfo`	`bit`	`1`
`SendUserId`	`bit`	`1`
`SendUserName`	`bit`	`1`
`SendUserEmail`	`bit`	`1`
`SendLinkTitle`	`bit`	`1`
`SendLinkDescription`	`bit`	`1`
`SendD2LUserName`	`bit`	`1`
`SendD2LOrgDefinedId`	`bit`	`1`
`SendD2LOrgRoleId`	`bit`	`1`
`SendBrightspaceUserId`	`bit`	`1`
`Anonymous`	`bit`	`1`
`Shared`	`bit`	`1`
`UseToolProviderSecuritySettings`	`bit`	`1`
`LastModifiedDate`	`datetime2`	`8`
`OuAvailabilitySetId`	`bigint`	`8`
`LastModifiedBy`	`int`	`4`	FK
`IsDeleted`	`bit`	`1`
`CreatedDate`	`datetime2`	`8`
`DeploymentId`	`uniqueidentifier`	`36`	FK
`LinkSubType`	`int`	`4`

None

DeploymentId: Marked as a foreign key by D2L, without a stated target data set.