ImmedSubscriptions Table

The ImmedSubscriptions table stores alerts that are sent immediately when changes occur.

Warning  Modifying the database schema or database structures is unsupported. Changes that you make to the database contents may be overwritten when you install updates or service packs for Windows SharePoint Services, or when you upgrade an installation to the next product version.

Columns

Column name	Data type	Description
Id	uniqueidentifier	GUID for the alert.
SiteId	uniqueidentifier	GUID for the SharePoint site to which the alert belongs. Found in the Sites table.
WebId	uniqueidentifier	Site collection to which the alert belongs. Found in the Webs table.
ListId	uniqueidentifier	List with which the alert is associated. Found in the Lists tables.
ItemId	int	List item or document to which a user has added an alert.
EventType	int	Event that triggers the alert.
UserId	int	ID of the user who specified the alert. Found in the UserInfo table.
UserEmail	nvarchar	E-mail address of the user.
SiteUrl	nvarchar	URL of the top-level site.
WebUrl	nvarchar	URL of the subsite.
WebTitle	nvarchar	Title of the subsite.
WebLanguage	int	Language ID of the Web site.
WebLocale	int	Locale ID of the Web site.
WebTimeZone	smallint	Number of the time zone.
WebTime24	bit	Time format specifier. Specifies whether the time displayed is in 12-hour or 24-hour format.
WebCalendarType	smallint	Calendar type for non-Gregorian calendars, e.g., Hijiri.
WebAdjustHijriDays	smallint	Lunar calendar information.
ListUrl	nvarchar	URL to the list.
ListTitle	nvarchar	Title of the list.
ListBaseType	int	Base type of a list such as a survey, document library, or events list.
ListServerTemplate	int	List template used for a list.
ItemDocId	uniqueidentifier	ID of the document used for specifying an alert for the document.