DotNetNuke 5.6 - table columns

All table columns

parent	column	definition
Affiliates	AffiliateId	int identity NOT NULL
Affiliates	VendorId	int NULL
Affiliates	StartDate	datetime NULL
Affiliates	EndDate	datetime NULL
Affiliates	CPC	float NOT NULL
Affiliates	Clicks	int NOT NULL
Affiliates	CPA	float NOT NULL
Affiliates	Acquisitions	int NOT NULL
AnonymousUsers	UserID	char(36) NOT NULL
AnonymousUsers	PortalID	int NOT NULL
AnonymousUsers	TabID	int NOT NULL
AnonymousUsers	CreationDate	datetime NOT NULL = (getdate())
AnonymousUsers	LastActiveDate	datetime NOT NULL = (getdate())
aspnet_Applications	ApplicationName	nvarchar(256) NOT NULL
aspnet_Applications	LoweredApplicationName	nvarchar(256) NOT NULL
aspnet_Applications	ApplicationId	uniqueidentifier NOT NULL = (newid())
aspnet_Applications	Description	nvarchar(256) NULL
aspnet_Membership	ApplicationId	uniqueidentifier NOT NULL
aspnet_Membership	UserId	uniqueidentifier NOT NULL
aspnet_Membership	Password	nvarchar(128) NOT NULL
aspnet_Membership	PasswordFormat	int NOT NULL = ((0))
aspnet_Membership	PasswordSalt	nvarchar(128) NOT NULL
aspnet_Membership	MobilePIN	nvarchar(16) NULL
aspnet_Membership	Email	nvarchar(256) NULL
aspnet_Membership	LoweredEmail	nvarchar(256) NULL
aspnet_Membership	PasswordQuestion	nvarchar(256) NULL
aspnet_Membership	PasswordAnswer	nvarchar(128) NULL
aspnet_Membership	IsApproved	bit NOT NULL
aspnet_Membership	IsLockedOut	bit NOT NULL
aspnet_Membership	CreateDate	datetime NOT NULL
aspnet_Membership	LastLoginDate	datetime NOT NULL
aspnet_Membership	LastPasswordChangedDate	datetime NOT NULL
aspnet_Membership	LastLockoutDate	datetime NOT NULL
aspnet_Membership	FailedPasswordAttemptCount	int NOT NULL
aspnet_Membership	FailedPasswordAttemptWindowStart	datetime NOT NULL
aspnet_Membership	FailedPasswordAnswerAttemptCount	int NOT NULL
aspnet_Membership	FailedPasswordAnswerAttemptWindowStart	datetime NOT NULL
aspnet_Membership	Comment	ntext NULL
aspnet_Profile	UserId	uniqueidentifier NOT NULL
aspnet_Profile	PropertyNames	ntext NOT NULL
aspnet_Profile	PropertyValuesString	ntext NOT NULL
aspnet_Profile	PropertyValuesBinary	image NOT NULL
aspnet_Profile	LastUpdatedDate	datetime NOT NULL
aspnet_Roles	ApplicationId	uniqueidentifier NOT NULL
aspnet_Roles	RoleId	uniqueidentifier NOT NULL = (newid())
aspnet_Roles	RoleName	nvarchar(256) NOT NULL
aspnet_Roles	LoweredRoleName	nvarchar(256) NOT NULL
aspnet_Roles	Description	nvarchar(256) NULL
aspnet_SchemaVersions	Feature	nvarchar(128) NOT NULL
aspnet_SchemaVersions	CompatibleSchemaVersion	nvarchar(128) NOT NULL
aspnet_SchemaVersions	IsCurrentVersion	bit NOT NULL
aspnet_Users	ApplicationId	uniqueidentifier NOT NULL
aspnet_Users	UserId	uniqueidentifier NOT NULL = (newid())
aspnet_Users	UserName	nvarchar(256) NOT NULL
aspnet_Users	LoweredUserName	nvarchar(256) NOT NULL
aspnet_Users	MobileAlias	nvarchar(16) NULL = (NULL)
aspnet_Users	IsAnonymous	bit NOT NULL = ((0))
aspnet_Users	LastActivityDate	datetime NOT NULL
aspnet_UsersInRoles	UserId	uniqueidentifier NOT NULL
aspnet_UsersInRoles	RoleId	uniqueidentifier NOT NULL
Assemblies	AssemblyID	int identity NOT NULL
Assemblies	PackageID	int NOT NULL
Assemblies	AssemblyName	nvarchar(250) NOT NULL
Assemblies	Version	nvarchar(20) NOT NULL
Authentication	AuthenticationID	int identity NOT NULL
Authentication	PackageID	int NOT NULL = ((-1))
Authentication	AuthenticationType	nvarchar(100) NOT NULL
Authentication	IsEnabled	bit NOT NULL = ((0))
Authentication	SettingsControlSrc	nvarchar(250) NOT NULL
Authentication	LoginControlSrc	nvarchar(250) NOT NULL
Authentication	LogoffControlSrc	nvarchar(250) NOT NULL
Authentication	CreatedByUserID	int NULL
Authentication	CreatedOnDate	datetime NULL
Authentication	LastModifiedByUserID	int NULL
Authentication	LastModifiedOnDate	datetime NULL
Banners	BannerId	int identity NOT NULL
Banners	VendorId	int NOT NULL
Banners	ImageFile	nvarchar(100) NULL
Banners	BannerName	nvarchar(100) NOT NULL
Banners	Impressions	int NOT NULL
Banners	CPM	float NOT NULL
Banners	Views	int NOT NULL = ((0))
Banners	ClickThroughs	int NOT NULL = ((0))
Banners	StartDate	datetime NULL
Banners	EndDate	datetime NULL
Banners	CreatedByUser	nvarchar(100) NOT NULL
Banners	CreatedDate	datetime NOT NULL
Banners	BannerTypeId	int NULL
Banners	Description	nvarchar(2000) NULL
Banners	GroupName	nvarchar(100) NULL
Banners	Criteria	bit NOT NULL = ((1))
Banners	URL	nvarchar(255) NULL
Banners	Width	int NOT NULL = ((0))
Banners	Height	int NOT NULL = ((0))
Classification	ClassificationId	int identity NOT NULL
Classification	ClassificationName	nvarchar(200) NOT NULL
Classification	ParentId	int NULL
ContentItems	ContentItemID	int identity NOT NULL
ContentItems	Content	nvarchar(max) NULL
ContentItems	ContentTypeID	int NOT NULL
ContentItems	TabID	int NOT NULL
ContentItems	ModuleID	int NOT NULL
ContentItems	ContentKey	nvarchar(250) NULL
ContentItems	Indexed	bit NOT NULL = ((0))
ContentItems	CreatedByUserID	int NULL
ContentItems	CreatedOnDate	datetime NULL
ContentItems	LastModifiedByUserID	int NULL
ContentItems	LastModifiedOnDate	datetime NULL
ContentItems_MetaData	ContentItemMetaDataID	int identity NOT NULL
ContentItems_MetaData	ContentItemID	int NOT NULL
ContentItems_MetaData	MetaDataID	int NOT NULL
ContentItems_MetaData	MetaDataValue	nvarchar(max) NULL
ContentItems_Tags	ContentItemTagID	int identity NOT NULL
ContentItems_Tags	ContentItemID	int NOT NULL
ContentItems_Tags	TermID	int NOT NULL
ContentTypes	ContentTypeID	int identity NOT NULL
ContentTypes	ContentType	nvarchar(100) NOT NULL
Dashboard_Controls	DashboardControlID	int identity NOT NULL
Dashboard_Controls	DashboardControlKey	nvarchar(50) NOT NULL
Dashboard_Controls	IsEnabled	bit NOT NULL
Dashboard_Controls	DashboardControlSrc	nvarchar(250) NOT NULL
Dashboard_Controls	DashboardControlLocalResources	nvarchar(250) NOT NULL
Dashboard_Controls	ControllerClass	nvarchar(250) NULL
Dashboard_Controls	ViewOrder	int NOT NULL = ((0))
Dashboard_Controls	PackageID	int NOT NULL = ((-1))
DesktopModulePermission	DesktopModulePermissionID	int identity NOT NULL
DesktopModulePermission	PortalDesktopModuleID	int NOT NULL
DesktopModulePermission	PermissionID	int NOT NULL
DesktopModulePermission	AllowAccess	bit NOT NULL
DesktopModulePermission	RoleID	int NULL
DesktopModulePermission	UserID	int NULL
DesktopModulePermission	CreatedByUserID	int NULL
DesktopModulePermission	CreatedOnDate	datetime NULL
DesktopModulePermission	LastModifiedByUserID	int NULL
DesktopModulePermission	LastModifiedOnDate	datetime NULL
DesktopModules	DesktopModuleID	int identity NOT NULL
DesktopModules	FriendlyName	nvarchar(128) NOT NULL
DesktopModules	Description	nvarchar(2000) NULL
DesktopModules	Version	nvarchar(8) NULL
DesktopModules	IsPremium	bit NOT NULL
DesktopModules	IsAdmin	bit NOT NULL
DesktopModules	BusinessControllerClass	nvarchar(200) NULL
DesktopModules	FolderName	nvarchar(128) NOT NULL
DesktopModules	ModuleName	nvarchar(128) NOT NULL
DesktopModules	SupportedFeatures	int NOT NULL = ((0))
DesktopModules	CompatibleVersions	nvarchar(500) NULL
DesktopModules	Dependencies	nvarchar(400) NULL
DesktopModules	Permissions	nvarchar(400) NULL
DesktopModules	PackageID	int NOT NULL = ((-1))
DesktopModules	CreatedByUserID	int NULL
DesktopModules	CreatedOnDate	datetime NULL
DesktopModules	LastModifiedByUserID	int NULL
DesktopModules	LastModifiedOnDate	datetime NULL
EventLog	LogGUID	varchar(36) NOT NULL
EventLog	LogTypeKey	nvarchar(35) NOT NULL
EventLog	LogConfigID	int NULL
EventLog	LogUserID	int NULL
EventLog	LogUserName	nvarchar(50) NULL
EventLog	LogPortalID	int NULL
EventLog	LogPortalName	nvarchar(100) NULL
EventLog	LogCreateDate	datetime NOT NULL
EventLog	LogServerName	nvarchar(50) NOT NULL
EventLog	LogProperties	ntext NOT NULL
EventLog	LogNotificationPending	bit NULL
EventLog	LogEventID	bigint identity NOT NULL
EventLogConfig	ID	int identity NOT NULL
EventLogConfig	LogTypeKey	nvarchar(35) NULL
EventLogConfig	LogTypePortalID	int NULL
EventLogConfig	LoggingIsActive	bit NOT NULL
EventLogConfig	KeepMostRecent	int NOT NULL
EventLogConfig	EmailNotificationIsActive	bit NOT NULL
EventLogConfig	NotificationThreshold	int NULL
EventLogConfig	NotificationThresholdTime	int NULL
EventLogConfig	NotificationThresholdTimeType	int NULL
EventLogConfig	MailFromAddress	nvarchar(50) NOT NULL
EventLogConfig	MailToAddress	nvarchar(50) NOT NULL
EventLogTypes	LogTypeKey	nvarchar(35) NOT NULL
EventLogTypes	LogTypeFriendlyName	nvarchar(50) NOT NULL
EventLogTypes	LogTypeDescription	nvarchar(128) NOT NULL
EventLogTypes	LogTypeOwner	nvarchar(100) NOT NULL
EventLogTypes	LogTypeCSSClass	nvarchar(40) NOT NULL
EventQueue	EventMessageID	int identity NOT NULL
EventQueue	EventName	nvarchar(100) NOT NULL
EventQueue	Priority	int NOT NULL
EventQueue	ProcessorType	nvarchar(250) NOT NULL
EventQueue	ProcessorCommand	nvarchar(250) NOT NULL
EventQueue	Body	nvarchar(250) NOT NULL
EventQueue	Sender	nvarchar(250) NOT NULL
EventQueue	Subscriber	nvarchar(100) NOT NULL
EventQueue	AuthorizedRoles	nvarchar(250) NOT NULL
EventQueue	ExceptionMessage	nvarchar(250) NOT NULL
EventQueue	SentDate	datetime NOT NULL
EventQueue	ExpirationDate	datetime NOT NULL
EventQueue	Attributes	ntext NOT NULL
EventQueue	IsComplete	bit NOT NULL = ((0))
Files	FileId	int identity NOT NULL
Files	PortalId	int NULL
Files	FileName	nvarchar(100) NOT NULL
Files	Extension	nvarchar(100) NOT NULL
Files	Size	int NOT NULL
Files	Width	int NULL
Files	Height	int NULL
Files	ContentType	nvarchar(200) NOT NULL
Files	Folder	nvarchar(200) NULL
Files	FolderID	int NOT NULL
Files	Content	image NULL
Files	CreatedByUserID	int NULL
Files	CreatedOnDate	datetime NULL
Files	LastModifiedByUserID	int NULL
Files	LastModifiedOnDate	datetime NULL
Files	UniqueId	uniqueidentifier NOT NULL = (newid())
Files	VersionGuid	uniqueidentifier NOT NULL = (newid())
Files	SHA1Hash	varchar(40) NULL
FolderPermission	FolderPermissionID	int identity NOT NULL
FolderPermission	FolderID	int NOT NULL
FolderPermission	PermissionID	int NOT NULL
FolderPermission	AllowAccess	bit NOT NULL
FolderPermission	RoleID	int NULL
FolderPermission	UserID	int NULL
FolderPermission	CreatedByUserID	int NULL
FolderPermission	CreatedOnDate	datetime NULL
FolderPermission	LastModifiedByUserID	int NULL
FolderPermission	LastModifiedOnDate	datetime NULL
Folders	FolderID	int identity NOT NULL
Folders	PortalID	int NULL
Folders	FolderPath	varchar(300) NOT NULL
Folders	StorageLocation	int NOT NULL = ((0))
Folders	IsProtected	bit NOT NULL = ((0))
Folders	IsCached	bit NOT NULL = ((0))
Folders	LastUpdated	datetime NULL
Folders	CreatedByUserID	int NULL
Folders	CreatedOnDate	datetime NULL
Folders	LastModifiedByUserID	int NULL
Folders	LastModifiedOnDate	datetime NULL
Folders	UniqueId	uniqueidentifier NOT NULL = (newid())
Folders	VersionGuid	uniqueidentifier NOT NULL = (newid())
HostSettings	SettingName	nvarchar(50) NOT NULL
HostSettings	SettingValue	nvarchar(256) NOT NULL
HostSettings	SettingIsSecure	bit NOT NULL = ((0))
HostSettings	CreatedByUserID	int NULL
HostSettings	CreatedOnDate	datetime NULL
HostSettings	LastModifiedByUserID	int NULL
HostSettings	LastModifiedOnDate	datetime NULL
HtmlText	ModuleID	int NOT NULL
HtmlText	ItemID	int identity NOT NULL
HtmlText	Content	ntext NULL
HtmlText	Version	int NULL
HtmlText	StateID	int NULL
HtmlText	IsPublished	bit NULL
HtmlText	CreatedByUserID	int NULL
HtmlText	CreatedOnDate	datetime NULL
HtmlText	LastModifiedByUserID	int NULL
HtmlText	LastModifiedOnDate	datetime NULL
HtmlTextLog	HtmlTextLogID	int identity NOT NULL
HtmlTextLog	ItemID	int NOT NULL
HtmlTextLog	StateID	int NOT NULL
HtmlTextLog	Comment	nvarchar(4000) NULL
HtmlTextLog	Approved	bit NOT NULL
HtmlTextLog	CreatedByUserID	int NOT NULL
HtmlTextLog	CreatedOnDate	datetime NOT NULL
HtmlTextUsers	HtmlTextUserID	int identity NOT NULL
HtmlTextUsers	ItemID	int NOT NULL
HtmlTextUsers	StateID	int NOT NULL
HtmlTextUsers	ModuleID	int NOT NULL
HtmlTextUsers	TabID	int NOT NULL
HtmlTextUsers	UserID	int NOT NULL
HtmlTextUsers	CreatedOnDate	datetime NOT NULL
LanguagePacks	LanguagePackID	int identity NOT NULL
LanguagePacks	PackageID	int NOT NULL
LanguagePacks	DependentPackageID	int NOT NULL
LanguagePacks	LanguageID	int NOT NULL
LanguagePacks	CreatedByUserID	int NULL
LanguagePacks	CreatedOnDate	datetime NULL
LanguagePacks	LastModifiedByUserID	int NULL
LanguagePacks	LastModifiedOnDate	datetime NULL
Languages	LanguageID	int identity NOT NULL
Languages	CultureCode	nvarchar(50) NOT NULL
Languages	CultureName	nvarchar(200) NOT NULL
Languages	FallbackCulture	nvarchar(50) NULL
Languages	CreatedByUserID	int NULL
Languages	CreatedOnDate	datetime NULL
Languages	LastModifiedByUserID	int NULL
Languages	LastModifiedOnDate	datetime NULL
Links	ItemID	int identity NOT NULL
Links	ModuleID	int NOT NULL
Links	CreatedDate	datetime NULL
Links	Title	nvarchar(100) NULL
Links	Url	nvarchar(250) NULL
Links	ViewOrder	int NULL
Links	Description	nvarchar(2000) NULL
Links	CreatedByUser	int NOT NULL
Lists	EntryID	int identity NOT NULL
Lists	ListName	nvarchar(50) NOT NULL
Lists	Value	nvarchar(100) NOT NULL
Lists	Text	nvarchar(150) NOT NULL
Lists	ParentID	int NOT NULL = ((0))
Lists	Level	int NOT NULL = ((0))
Lists	SortOrder	int NOT NULL = ((0))
Lists	DefinitionID	int NOT NULL = ((0))
Lists	Description	nvarchar(500) NULL
Lists	PortalID	int NOT NULL = ((-1))
Lists	SystemList	bit NOT NULL = ((0))
Lists	CreatedByUserID	int NULL
Lists	CreatedOnDate	datetime NULL
Lists	LastModifiedByUserID	int NULL
Lists	LastModifiedOnDate	datetime NULL
Messaging_Messages	MessageID	bigint identity NOT NULL
Messaging_Messages	PortalID	int NOT NULL
Messaging_Messages	FromUserID	int NOT NULL
Messaging_Messages	ToUserName	nvarchar(50) NULL
Messaging_Messages	FromUserName	nvarchar(50) NULL
Messaging_Messages	ToUserID	int NULL
Messaging_Messages	ToRoleID	int NULL
Messaging_Messages	Status	tinyint NOT NULL
Messaging_Messages	Subject	nvarchar(max) NULL
Messaging_Messages	Body	nvarchar(max) NULL
Messaging_Messages	Date	datetime NOT NULL
Messaging_Messages	Conversation	uniqueidentifier NOT NULL
Messaging_Messages	ReplyTo	bigint NULL
Messaging_Messages	AllowReply	bit NOT NULL
Messaging_Messages	SkipPortal	bit NOT NULL
Messaging_Messages	EmailSent	bit NOT NULL
Messaging_Messages	EmailSentDate	datetime NULL
Messaging_Messages	EmailSchedulerInstance	uniqueidentifier NULL
MetaData	MetaDataID	int identity NOT NULL
MetaData	MetaDataName	nvarchar(100) NOT NULL
MetaData	MetaDataDescription	nvarchar(2500) NULL
ModuleControls	ModuleControlID	int identity NOT NULL
ModuleControls	ModuleDefID	int NULL
ModuleControls	ControlKey	nvarchar(50) NULL
ModuleControls	ControlTitle	nvarchar(50) NULL
ModuleControls	ControlSrc	nvarchar(256) NULL
ModuleControls	IconFile	nvarchar(100) NULL
ModuleControls	ControlType	int NOT NULL
ModuleControls	ViewOrder	int NULL
ModuleControls	HelpUrl	nvarchar(200) NULL
ModuleControls	SupportsPartialRendering	bit NOT NULL = ((0))
ModuleControls	CreatedByUserID	int NULL
ModuleControls	CreatedOnDate	datetime NULL
ModuleControls	LastModifiedByUserID	int NULL
ModuleControls	LastModifiedOnDate	datetime NULL
ModuleDefinitions	ModuleDefID	int identity NOT NULL
ModuleDefinitions	FriendlyName	nvarchar(128) NOT NULL
ModuleDefinitions	DesktopModuleID	int NOT NULL
ModuleDefinitions	DefaultCacheTime	int NOT NULL = ((0))
ModuleDefinitions	CreatedByUserID	int NULL
ModuleDefinitions	CreatedOnDate	datetime NULL
ModuleDefinitions	LastModifiedByUserID	int NULL
ModuleDefinitions	LastModifiedOnDate	datetime NULL
ModulePermission	ModulePermissionID	int identity NOT NULL
ModulePermission	ModuleID	int NOT NULL
ModulePermission	PermissionID	int NOT NULL
ModulePermission	AllowAccess	bit NOT NULL
ModulePermission	RoleID	int NULL
ModulePermission	UserID	int NULL
ModulePermission	CreatedByUserID	int NULL
ModulePermission	CreatedOnDate	datetime NULL
ModulePermission	LastModifiedByUserID	int NULL
ModulePermission	LastModifiedOnDate	datetime NULL
Modules	ModuleID	int identity NOT NULL
Modules	ModuleDefID	int NOT NULL
Modules	AllTabs	bit NOT NULL = ((0))
Modules	IsDeleted	bit NOT NULL = ((0))
Modules	InheritViewPermissions	bit NULL
Modules	StartDate	datetime NULL
Modules	EndDate	datetime NULL
Modules	PortalID	int NULL
Modules	CreatedByUserID	int NULL
Modules	CreatedOnDate	datetime NULL
Modules	LastModifiedByUserID	int NULL
Modules	LastModifiedOnDate	datetime NULL
Modules	ContentItemID	int NULL
ModuleSettings	ModuleID	int NOT NULL
ModuleSettings	SettingName	nvarchar(50) NOT NULL
ModuleSettings	SettingValue	nvarchar(2000) NOT NULL
ModuleSettings	CreatedByUserID	int NULL
ModuleSettings	CreatedOnDate	datetime NULL
ModuleSettings	LastModifiedByUserID	int NULL
ModuleSettings	LastModifiedOnDate	datetime NULL
Packages	PackageID	int identity NOT NULL
Packages	PortalID	int NULL
Packages	Name	nvarchar(128) NOT NULL
Packages	FriendlyName	nvarchar(250) NOT NULL
Packages	Description	nvarchar(2000) NULL
Packages	PackageType	nvarchar(100) NOT NULL
Packages	Version	nvarchar(50) NOT NULL
Packages	License	ntext NULL
Packages	Manifest	ntext NULL
Packages	Owner	nvarchar(100) NULL
Packages	Organization	nvarchar(100) NULL
Packages	Url	nvarchar(250) NULL
Packages	Email	nvarchar(100) NULL
Packages	ReleaseNotes	ntext NULL
Packages	IsSystemPackage	bit NOT NULL = ((0))
Packages	CreatedByUserID	int NULL
Packages	CreatedOnDate	datetime NULL
Packages	LastModifiedByUserID	int NULL
Packages	LastModifiedOnDate	datetime NULL
PackageTypes	PackageType	nvarchar(100) NOT NULL
PackageTypes	Description	nvarchar(500) NOT NULL
PackageTypes	SecurityAccessLevel	int NOT NULL
PackageTypes	EditorControlSrc	nvarchar(250) NULL
Permission	PermissionID	int identity NOT NULL
Permission	PermissionCode	varchar(50) NOT NULL
Permission	ModuleDefID	int NOT NULL
Permission	PermissionKey	varchar(50) NOT NULL
Permission	PermissionName	varchar(50) NOT NULL
Permission	ViewOrder	int NOT NULL = ((9999))
Permission	CreatedByUserID	int NULL
Permission	CreatedOnDate	datetime NULL
Permission	LastModifiedByUserID	int NULL
Permission	LastModifiedOnDate	datetime NULL
PortalAlias	PortalAliasID	int identity NOT NULL
PortalAlias	PortalID	int NOT NULL
PortalAlias	HTTPAlias	nvarchar(200) NULL
PortalAlias	CreatedByUserID	int NULL
PortalAlias	CreatedOnDate	datetime NULL
PortalAlias	LastModifiedByUserID	int NULL
PortalAlias	LastModifiedOnDate	datetime NULL
PortalDesktopModules	PortalDesktopModuleID	int identity NOT NULL
PortalDesktopModules	PortalID	int NOT NULL
PortalDesktopModules	DesktopModuleID	int NOT NULL
PortalDesktopModules	CreatedByUserID	int NULL
PortalDesktopModules	CreatedOnDate	datetime NULL
PortalDesktopModules	LastModifiedByUserID	int NULL
PortalDesktopModules	LastModifiedOnDate	datetime NULL
PortalLanguages	PortalLanguageID	int identity NOT NULL
PortalLanguages	PortalID	int NOT NULL
PortalLanguages	LanguageID	int NOT NULL
PortalLanguages	CreatedByUserID	int NULL
PortalLanguages	CreatedOnDate	datetime NULL
PortalLanguages	LastModifiedByUserID	int NULL
PortalLanguages	LastModifiedOnDate	datetime NULL
PortalLanguages	IsPublished	bit NOT NULL = ((0))
PortalLocalization	PortalID	int NOT NULL
PortalLocalization	CultureCode	nvarchar(10) NOT NULL
PortalLocalization	PortalName	nvarchar(128) NOT NULL
PortalLocalization	LogoFile	nvarchar(50) NULL
PortalLocalization	FooterText	nvarchar(100) NULL
PortalLocalization	Description	nvarchar(500) NULL
PortalLocalization	KeyWords	nvarchar(500) NULL
PortalLocalization	BackgroundFile	nvarchar(50) NULL
PortalLocalization	HomeTabId	int NULL
PortalLocalization	LoginTabId	int NULL
PortalLocalization	UserTabId	int NULL
PortalLocalization	AdminTabId	int NULL
PortalLocalization	SplashTabId	int NULL
PortalLocalization	CreatedByUserID	int NULL
PortalLocalization	CreatedOnDate	datetime NULL
PortalLocalization	LastModifiedByUserID	int NULL
PortalLocalization	LastModifiedOnDate	datetime NULL
PortalLocalization	RegisterTabId	int NULL
PortalLocalization	SearchTabId	int NULL
Portals	PortalID	int identity NOT NULL
Portals	ExpiryDate	datetime NULL
Portals	UserRegistration	int NOT NULL = ((0))
Portals	BannerAdvertising	int NOT NULL = ((0))
Portals	AdministratorId	int NULL
Portals	Currency	char(3) NULL
Portals	HostFee	money NOT NULL = ((0))
Portals	HostSpace	int NOT NULL = ((0))
Portals	AdministratorRoleId	int NULL
Portals	RegisteredRoleId	int NULL
Portals	GUID	uniqueidentifier NOT NULL = (newid())
Portals	PaymentProcessor	nvarchar(50) NULL
Portals	ProcessorUserId	nvarchar(50) NULL
Portals	ProcessorPassword	nvarchar(50) NULL
Portals	SiteLogHistory	int NULL
Portals	DefaultLanguage	nvarchar(10) NOT NULL = ('en-US')
Portals	TimezoneOffset	int NOT NULL = ((-8))
Portals	HomeDirectory	varchar(100) NOT NULL = ('')
Portals	PageQuota	int NOT NULL = ((0))
Portals	UserQuota	int NOT NULL = ((0))
Portals	CreatedByUserID	int NULL
Portals	CreatedOnDate	datetime NULL
Portals	LastModifiedByUserID	int NULL
Portals	LastModifiedOnDate	datetime NULL
PortalSettings	PortalID	int NOT NULL
PortalSettings	SettingName	nvarchar(50) NOT NULL
PortalSettings	SettingValue	nvarchar(2000) NULL
PortalSettings	CreatedByUserID	int NULL
PortalSettings	CreatedOnDate	datetime NULL
PortalSettings	LastModifiedByUserID	int NULL
PortalSettings	LastModifiedOnDate	datetime NULL
PortalSettings	CultureCode	nvarchar(10) NOT NULL
Profile	ProfileId	int identity NOT NULL
Profile	UserId	int NOT NULL
Profile	PortalId	int NOT NULL
Profile	ProfileData	ntext NOT NULL
Profile	CreatedDate	datetime NOT NULL
ProfilePropertyDefinition	PropertyDefinitionID	int identity NOT NULL
ProfilePropertyDefinition	PortalID	int NULL
ProfilePropertyDefinition	ModuleDefID	int NULL
ProfilePropertyDefinition	Deleted	bit NOT NULL
ProfilePropertyDefinition	DataType	int NOT NULL
ProfilePropertyDefinition	DefaultValue	ntext NULL
ProfilePropertyDefinition	PropertyCategory	nvarchar(50) NOT NULL
ProfilePropertyDefinition	PropertyName	nvarchar(50) NOT NULL
ProfilePropertyDefinition	Length	int NOT NULL = ((0))
ProfilePropertyDefinition	Required	bit NOT NULL
ProfilePropertyDefinition	ValidationExpression	nvarchar(2000) NULL
ProfilePropertyDefinition	ViewOrder	int NOT NULL
ProfilePropertyDefinition	Visible	bit NOT NULL
ProfilePropertyDefinition	CreatedByUserID	int NULL
ProfilePropertyDefinition	CreatedOnDate	datetime NULL
ProfilePropertyDefinition	LastModifiedByUserID	int NULL
ProfilePropertyDefinition	LastModifiedOnDate	datetime NULL
ProfilePropertyDefinition	DefaultVisibility	int NULL
RoleGroups	RoleGroupID	int identity NOT NULL
RoleGroups	PortalID	int NOT NULL
RoleGroups	RoleGroupName	nvarchar(50) NOT NULL
RoleGroups	Description	nvarchar(1000) NULL
RoleGroups	CreatedByUserID	int NULL
RoleGroups	CreatedOnDate	datetime NULL
RoleGroups	LastModifiedByUserID	int NULL
RoleGroups	LastModifiedOnDate	datetime NULL
Roles	RoleID	int identity NOT NULL
Roles	PortalID	int NOT NULL
Roles	RoleName	nvarchar(50) NOT NULL
Roles	Description	nvarchar(1000) NULL
Roles	ServiceFee	money NULL = ((0))
Roles	BillingFrequency	char(1) NULL
Roles	TrialPeriod	int NULL
Roles	TrialFrequency	char(1) NULL
Roles	BillingPeriod	int NULL
Roles	TrialFee	money NULL
Roles	IsPublic	bit NOT NULL = ((0))
Roles	AutoAssignment	bit NOT NULL = ((0))
Roles	RoleGroupID	int NULL
Roles	RSVPCode	nvarchar(50) NULL
Roles	IconFile	nvarchar(100) NULL
Roles	CreatedByUserID	int NULL
Roles	CreatedOnDate	datetime NULL
Roles	LastModifiedByUserID	int NULL
Roles	LastModifiedOnDate	datetime NULL
Schedule	ScheduleID	int identity NOT NULL
Schedule	TypeFullName	varchar(200) NOT NULL
Schedule	TimeLapse	int NOT NULL
Schedule	TimeLapseMeasurement	varchar(2) NOT NULL
Schedule	RetryTimeLapse	int NOT NULL
Schedule	RetryTimeLapseMeasurement	varchar(2) NOT NULL
Schedule	RetainHistoryNum	int NOT NULL
Schedule	AttachToEvent	varchar(50) NOT NULL
Schedule	CatchUpEnabled	bit NOT NULL
Schedule	Enabled	bit NOT NULL
Schedule	ObjectDependencies	varchar(300) NOT NULL
Schedule	Servers	nvarchar(2000) NULL
Schedule	CreatedByUserID	int NULL
Schedule	CreatedOnDate	datetime NULL
Schedule	LastModifiedByUserID	int NULL
Schedule	LastModifiedOnDate	datetime NULL
Schedule	FriendlyName	nvarchar(200) NULL
ScheduleHistory	ScheduleHistoryID	int identity NOT NULL
ScheduleHistory	ScheduleID	int NOT NULL
ScheduleHistory	StartDate	datetime NOT NULL
ScheduleHistory	EndDate	datetime NULL
ScheduleHistory	Succeeded	bit NULL
ScheduleHistory	LogNotes	ntext NULL
ScheduleHistory	NextStart	datetime NULL
ScheduleHistory	Server	nvarchar(150) NULL
ScheduleItemSettings	ScheduleID	int NOT NULL
ScheduleItemSettings	SettingName	nvarchar(50) NOT NULL
ScheduleItemSettings	SettingValue	nvarchar(256) NOT NULL
SearchCommonWords	CommonWordID	int identity NOT NULL
SearchCommonWords	CommonWord	nvarchar(255) NOT NULL
SearchCommonWords	Locale	nvarchar(10) NULL
SearchIndexer	SearchIndexerID	int identity NOT NULL
SearchIndexer	SearchIndexerAssemblyQualifiedName	char(200) NOT NULL
SearchItem	SearchItemID	int identity NOT NULL
SearchItem	Title	nvarchar(200) NOT NULL
SearchItem	Description	nvarchar(2000) NOT NULL
SearchItem	Author	int NULL
SearchItem	PubDate	datetime NOT NULL
SearchItem	ModuleId	int NOT NULL
SearchItem	SearchKey	nvarchar(100) NOT NULL
SearchItem	Guid	varchar(200) NULL
SearchItem	HitCount	int NULL
SearchItem	ImageFileId	int NULL
SearchItemWord	SearchItemWordID	int identity NOT NULL
SearchItemWord	SearchItemID	int NOT NULL
SearchItemWord	SearchWordsID	int NOT NULL
SearchItemWord	Occurrences	int NOT NULL
SearchItemWordPosition	SearchItemWordPositionID	int identity NOT NULL
SearchItemWordPosition	SearchItemWordID	int NOT NULL
SearchItemWordPosition	ContentPosition	int NOT NULL
SearchWord	SearchWordsID	int identity NOT NULL
SearchWord	Word	nvarchar(100) NOT NULL
SearchWord	IsCommon	bit NULL
SearchWord	HitCount	int NOT NULL
SiteLog	SiteLogId	int identity NOT NULL
SiteLog	DateTime	smalldatetime NOT NULL
SiteLog	PortalId	int NOT NULL
SiteLog	UserId	int NULL
SiteLog	Referrer	nvarchar(255) NULL
SiteLog	Url	nvarchar(255) NULL
SiteLog	UserAgent	nvarchar(255) NULL
SiteLog	UserHostAddress	nvarchar(255) NULL
SiteLog	UserHostName	nvarchar(255) NULL
SiteLog	TabId	int NULL
SiteLog	AffiliateId	int NULL
SkinControls	SkinControlID	int identity NOT NULL
SkinControls	PackageID	int NOT NULL = ((-1))
SkinControls	ControlKey	nvarchar(50) NULL
SkinControls	ControlSrc	nvarchar(256) NULL
SkinControls	IconFile	nvarchar(100) NULL
SkinControls	HelpUrl	nvarchar(200) NULL
SkinControls	SupportsPartialRendering	bit NOT NULL = ((0))
SkinControls	CreatedByUserID	int NULL
SkinControls	CreatedOnDate	datetime NULL
SkinControls	LastModifiedByUserID	int NULL
SkinControls	LastModifiedOnDate	datetime NULL
SkinPackages	SkinPackageID	int identity NOT NULL
SkinPackages	PackageID	int NOT NULL
SkinPackages	PortalID	int NULL
SkinPackages	SkinName	nvarchar(50) NOT NULL
SkinPackages	SkinType	nvarchar(20) NOT NULL
SkinPackages	CreatedByUserID	int NULL
SkinPackages	CreatedOnDate	datetime NULL
SkinPackages	LastModifiedByUserID	int NULL
SkinPackages	LastModifiedOnDate	datetime NULL
Skins	SkinID	int identity NOT NULL
Skins	SkinPackageID	int NOT NULL
Skins	SkinSrc	nvarchar(250) NOT NULL
SystemMessages	MessageID	int identity NOT NULL
SystemMessages	PortalID	int NULL
SystemMessages	MessageName	nvarchar(50) NOT NULL
SystemMessages	MessageValue	ntext NOT NULL
TabModules	TabModuleID	int identity NOT NULL
TabModules	TabID	int NOT NULL
TabModules	ModuleID	int NOT NULL
TabModules	PaneName	nvarchar(50) NOT NULL
TabModules	ModuleOrder	int NOT NULL
TabModules	CacheTime	int NOT NULL
TabModules	Alignment	nvarchar(10) NULL
TabModules	Color	nvarchar(20) NULL
TabModules	Border	nvarchar(1) NULL
TabModules	IconFile	nvarchar(100) NULL
TabModules	Visibility	int NOT NULL
TabModules	ContainerSrc	nvarchar(200) NULL
TabModules	DisplayTitle	bit NOT NULL = ((1))
TabModules	DisplayPrint	bit NOT NULL = ((1))
TabModules	DisplaySyndicate	bit NOT NULL = ((1))
TabModules	IsWebSlice	bit NOT NULL = ((0))
TabModules	WebSliceTitle	nvarchar(256) NULL
TabModules	WebSliceExpiryDate	datetime NULL
TabModules	WebSliceTTL	int NULL
TabModules	CreatedByUserID	int NULL
TabModules	CreatedOnDate	datetime NULL
TabModules	LastModifiedByUserID	int NULL
TabModules	LastModifiedOnDate	datetime NULL
TabModules	IsDeleted	bit NOT NULL = ((0))
TabModules	CacheMethod	varchar(50) NULL
TabModules	ModuleTitle	nvarchar(256) NULL
TabModules	Header	ntext NULL
TabModules	Footer	ntext NULL
TabModules	CultureCode	nvarchar(10) NULL
TabModules	UniqueId	uniqueidentifier NOT NULL = (newid())
TabModules	VersionGuid	uniqueidentifier NOT NULL = (newid())
TabModules	DefaultLanguageGuid	uniqueidentifier NULL
TabModules	LocalizedVersionGuid	uniqueidentifier NOT NULL = (newid())
TabModuleSettings	TabModuleID	int NOT NULL
TabModuleSettings	SettingName	nvarchar(50) NOT NULL
TabModuleSettings	SettingValue	nvarchar(2000) NOT NULL
TabModuleSettings	CreatedByUserID	int NULL
TabModuleSettings	CreatedOnDate	datetime NULL
TabModuleSettings	LastModifiedByUserID	int NULL
TabModuleSettings	LastModifiedOnDate	datetime NULL
TabPermission	TabPermissionID	int identity NOT NULL
TabPermission	TabID	int NOT NULL
TabPermission	PermissionID	int NOT NULL
TabPermission	AllowAccess	bit NOT NULL
TabPermission	RoleID	int NULL
TabPermission	UserID	int NULL
TabPermission	CreatedByUserID	int NULL
TabPermission	CreatedOnDate	datetime NULL
TabPermission	LastModifiedByUserID	int NULL
TabPermission	LastModifiedOnDate	datetime NULL
Tabs	TabID	int identity NOT NULL
Tabs	TabOrder	int NOT NULL = ((0))
Tabs	PortalID	int NULL
Tabs	TabName	nvarchar(50) NOT NULL
Tabs	IsVisible	bit NOT NULL = ((1))
Tabs	ParentId	int NULL
Tabs	Level	int NOT NULL = ((0))
Tabs	IconFile	nvarchar(100) NULL
Tabs	DisableLink	bit NOT NULL = ((0))
Tabs	Title	nvarchar(200) NULL
Tabs	Description	nvarchar(500) NULL
Tabs	KeyWords	nvarchar(500) NULL
Tabs	IsDeleted	bit NOT NULL = ((0))
Tabs	Url	nvarchar(255) NULL
Tabs	SkinSrc	nvarchar(200) NULL
Tabs	ContainerSrc	nvarchar(200) NULL
Tabs	TabPath	nvarchar(255) NULL
Tabs	StartDate	datetime NULL
Tabs	EndDate	datetime NULL
Tabs	RefreshInterval	int NULL
Tabs	PageHeadText	nvarchar(500) NULL
Tabs	IsSecure	bit NOT NULL = ((0))
Tabs	PermanentRedirect	bit NOT NULL = ((0))
Tabs	SiteMapPriority	float NOT NULL = ((0.5))
Tabs	CreatedByUserID	int NULL
Tabs	CreatedOnDate	datetime NULL
Tabs	LastModifiedByUserID	int NULL
Tabs	LastModifiedOnDate	datetime NULL
Tabs	IconFileLarge	nvarchar(100) NULL
Tabs	CultureCode	nvarchar(10) NULL
Tabs	ContentItemID	int NULL
Tabs	UniqueId	uniqueidentifier NOT NULL = (newid())
Tabs	VersionGuid	uniqueidentifier NOT NULL = (newid())
Tabs	DefaultLanguageGuid	uniqueidentifier NULL
Tabs	LocalizedVersionGuid	uniqueidentifier NOT NULL = (newid())
TabSettings	TabID	int NOT NULL
TabSettings	SettingName	nvarchar(50) NOT NULL
TabSettings	SettingValue	nvarchar(2000) NOT NULL
TabSettings	CreatedByUserID	int NULL
TabSettings	CreatedOnDate	datetime NULL
TabSettings	LastModifiedByUserID	int NULL
TabSettings	LastModifiedOnDate	datetime NULL
Taxonomy_ScopeTypes	ScopeTypeID	int identity NOT NULL
Taxonomy_ScopeTypes	ScopeType	nvarchar(250) NULL
Taxonomy_Terms	TermID	int identity NOT NULL
Taxonomy_Terms	VocabularyID	int NOT NULL
Taxonomy_Terms	ParentTermID	int NULL
Taxonomy_Terms	Name	nvarchar(250) NOT NULL
Taxonomy_Terms	Description	nvarchar(2500) NULL
Taxonomy_Terms	Weight	int NOT NULL = ((0))
Taxonomy_Terms	TermLeft	int NOT NULL = ((0))
Taxonomy_Terms	TermRight	int NOT NULL = ((0))
Taxonomy_Terms	CreatedByUserID	int NULL
Taxonomy_Terms	CreatedOnDate	datetime NULL
Taxonomy_Terms	LastModifiedByUserID	int NULL
Taxonomy_Terms	LastModifiedOnDate	datetime NULL
Taxonomy_Vocabularies	VocabularyID	int identity NOT NULL
Taxonomy_Vocabularies	VocabularyTypeID	int NOT NULL
Taxonomy_Vocabularies	Name	nvarchar(250) NOT NULL
Taxonomy_Vocabularies	Description	nvarchar(2500) NULL
Taxonomy_Vocabularies	Weight	int NOT NULL = ((0))
Taxonomy_Vocabularies	ScopeID	int NULL
Taxonomy_Vocabularies	ScopeTypeID	int NOT NULL
Taxonomy_Vocabularies	CreatedByUserID	int NULL
Taxonomy_Vocabularies	CreatedOnDate	datetime NULL
Taxonomy_Vocabularies	LastModifiedByUserID	int NULL
Taxonomy_Vocabularies	LastModifiedOnDate	datetime NULL
Taxonomy_Vocabularies	IsSystem	bit NOT NULL = ((0))
Taxonomy_VocabularyTypes	VocabularyTypeID	int identity NOT NULL
Taxonomy_VocabularyTypes	VocabularyType	nvarchar(50) NOT NULL
UrlLog	UrlLogID	int identity NOT NULL
UrlLog	UrlTrackingID	int NOT NULL
UrlLog	ClickDate	datetime NOT NULL
UrlLog	UserID	int NULL
Urls	UrlID	int identity NOT NULL
Urls	PortalID	int NULL
Urls	Url	nvarchar(255) NOT NULL
UrlTracking	UrlTrackingID	int identity NOT NULL
UrlTracking	PortalID	int NULL
UrlTracking	Url	nvarchar(255) NOT NULL
UrlTracking	UrlType	char(1) NOT NULL
UrlTracking	Clicks	int NOT NULL
UrlTracking	LastClick	datetime NULL
UrlTracking	CreatedDate	datetime NOT NULL
UrlTracking	LogActivity	bit NOT NULL
UrlTracking	TrackClicks	bit NOT NULL = ((1))
UrlTracking	ModuleId	int NULL
UrlTracking	NewWindow	bit NOT NULL = ((0))
UserAuthentication	UserAuthenticationID	int identity NOT NULL
UserAuthentication	UserID	int NOT NULL
UserAuthentication	AuthenticationType	nvarchar(100) NOT NULL
UserAuthentication	AuthenticationToken	nvarchar(1000) NOT NULL
UserAuthentication	CreatedByUserID	int NULL
UserAuthentication	CreatedOnDate	datetime NULL
UserAuthentication	LastModifiedByUserID	int NULL
UserAuthentication	LastModifiedOnDate	datetime NULL
UserPortals	UserId	int NOT NULL
UserPortals	PortalId	int NOT NULL
UserPortals	UserPortalId	int identity NOT NULL
UserPortals	CreatedDate	datetime NOT NULL = (getdate())
UserPortals	Authorised	bit NOT NULL = ((1))
UserPortals	IsDeleted	bit NOT NULL = ((0))
UserPortals	RefreshRoles	bit NOT NULL = ((0))
UserProfile	ProfileID	int identity NOT NULL
UserProfile	UserID	int NOT NULL
UserProfile	PropertyDefinitionID	int NOT NULL
UserProfile	PropertyValue	nvarchar(3750) NULL
UserProfile	PropertyText	ntext NULL
UserProfile	Visibility	int NOT NULL = ((0))
UserProfile	LastUpdatedDate	datetime NOT NULL
UserRoles	UserRoleID	int identity NOT NULL
UserRoles	UserID	int NOT NULL
UserRoles	RoleID	int NOT NULL
UserRoles	ExpiryDate	datetime NULL
UserRoles	IsTrialUsed	bit NULL
UserRoles	EffectiveDate	datetime NULL
UserRoles	CreatedByUserID	int NULL
UserRoles	CreatedOnDate	datetime NULL
UserRoles	LastModifiedByUserID	int NULL
UserRoles	LastModifiedOnDate	datetime NULL
Users	UserID	int identity NOT NULL
Users	Username	nvarchar(100) NOT NULL
Users	FirstName	nvarchar(50) NOT NULL
Users	LastName	nvarchar(50) NOT NULL
Users	IsSuperUser	bit NOT NULL = ((0))
Users	AffiliateId	int NULL
Users	Email	nvarchar(256) NULL
Users	DisplayName	nvarchar(128) NOT NULL = ('')
Users	UpdatePassword	bit NOT NULL = ((0))
Users	LastIPAddress	nvarchar(50) NULL
Users	IsDeleted	bit NOT NULL = ((0))
Users	CreatedByUserID	int NULL
Users	CreatedOnDate	datetime NULL
Users	LastModifiedByUserID	int NULL
Users	LastModifiedOnDate	datetime NULL
UsersOnline	UserID	int NOT NULL
UsersOnline	PortalID	int NOT NULL
UsersOnline	TabID	int NOT NULL
UsersOnline	CreationDate	datetime NOT NULL = (getdate())
UsersOnline	LastActiveDate	datetime NOT NULL = (getdate())
VendorClassification	VendorClassificationId	int identity NOT NULL
VendorClassification	VendorId	int NOT NULL
VendorClassification	ClassificationId	int NOT NULL
Vendors	VendorId	int identity NOT NULL
Vendors	VendorName	nvarchar(50) NOT NULL
Vendors	Street	nvarchar(50) NULL
Vendors	City	nvarchar(50) NULL
Vendors	Region	nvarchar(50) NULL
Vendors	Country	nvarchar(50) NULL
Vendors	PostalCode	nvarchar(50) NULL
Vendors	Telephone	nvarchar(50) NULL
Vendors	PortalId	int NULL
Vendors	Fax	nvarchar(50) NULL
Vendors	Email	nvarchar(50) NULL
Vendors	Website	nvarchar(100) NULL
Vendors	ClickThroughs	int NOT NULL = ((0))
Vendors	Views	int NOT NULL = ((0))
Vendors	CreatedByUser	nvarchar(100) NULL
Vendors	CreatedDate	datetime NULL
Vendors	LogoFile	nvarchar(100) NULL
Vendors	KeyWords	ntext NULL
Vendors	Unit	nvarchar(50) NULL
Vendors	Authorized	bit NOT NULL = ((1))
Vendors	FirstName	nvarchar(50) NULL
Vendors	LastName	nvarchar(50) NULL
Vendors	Cell	varchar(50) NULL
Version	VersionId	int identity NOT NULL
Version	Major	int NOT NULL
Version	Minor	int NOT NULL
Version	Build	int NOT NULL
Version	Name	nvarchar(50) NULL
Version	CreatedDate	datetime NOT NULL
WebServers	ServerID	int identity NOT NULL
WebServers	ServerName	nvarchar(50) NOT NULL
WebServers	CreatedDate	datetime NOT NULL
WebServers	LastActivityDate	datetime NOT NULL
WebServers	URL	nvarchar(255) NULL
WebServers	IISAppName	nvarchar(200) NOT NULL = ('')
WebServers	Enabled	bit NOT NULL = ((1))
Workflow	WorkflowID	int identity NOT NULL
Workflow	PortalID	int NULL
Workflow	WorkflowName	nvarchar(50) NOT NULL
Workflow	Description	nvarchar(2000) NULL
Workflow	IsDeleted	bit NOT NULL
WorkflowStates	StateID	int identity NOT NULL
WorkflowStates	WorkflowID	int NOT NULL
WorkflowStates	StateName	nvarchar(50) NOT NULL
WorkflowStates	Order	int NOT NULL
WorkflowStates	IsActive	bit NOT NULL
WorkflowStates	Notify	bit NOT NULL
vw_aspnet_Applications	ApplicationName	nvarchar(256) NOT NULL
vw_aspnet_Applications	LoweredApplicationName	nvarchar(256) NOT NULL
vw_aspnet_Applications	ApplicationId	uniqueidentifier NOT NULL
vw_aspnet_Applications	Description	nvarchar(256) NULL
vw_aspnet_MembershipUsers	UserId	uniqueidentifier NOT NULL
vw_aspnet_MembershipUsers	PasswordFormat	int NOT NULL
vw_aspnet_MembershipUsers	MobilePIN	nvarchar(16) NULL
vw_aspnet_MembershipUsers	Email	nvarchar(256) NULL
vw_aspnet_MembershipUsers	LoweredEmail	nvarchar(256) NULL
vw_aspnet_MembershipUsers	PasswordQuestion	nvarchar(256) NULL
vw_aspnet_MembershipUsers	PasswordAnswer	nvarchar(128) NULL
vw_aspnet_MembershipUsers	IsApproved	bit NOT NULL
vw_aspnet_MembershipUsers	IsLockedOut	bit NOT NULL
vw_aspnet_MembershipUsers	CreateDate	datetime NOT NULL
vw_aspnet_MembershipUsers	LastLoginDate	datetime NOT NULL
vw_aspnet_MembershipUsers	LastPasswordChangedDate	datetime NOT NULL
vw_aspnet_MembershipUsers	LastLockoutDate	datetime NOT NULL
vw_aspnet_MembershipUsers	FailedPasswordAttemptCount	int NOT NULL
vw_aspnet_MembershipUsers	FailedPasswordAttemptWindowStart	datetime NOT NULL
vw_aspnet_MembershipUsers	FailedPasswordAnswerAttemptCount	int NOT NULL
vw_aspnet_MembershipUsers	FailedPasswordAnswerAttemptWindowStart	datetime NOT NULL
vw_aspnet_MembershipUsers	Comment	ntext NULL
vw_aspnet_MembershipUsers	ApplicationId	uniqueidentifier NOT NULL
vw_aspnet_MembershipUsers	UserName	nvarchar(256) NOT NULL
vw_aspnet_MembershipUsers	MobileAlias	nvarchar(16) NULL
vw_aspnet_MembershipUsers	IsAnonymous	bit NOT NULL
vw_aspnet_MembershipUsers	LastActivityDate	datetime NOT NULL
vw_aspnet_Profiles	UserId	uniqueidentifier NOT NULL
vw_aspnet_Profiles	LastUpdatedDate	datetime NOT NULL
vw_aspnet_Profiles	DataSize	int NULL
vw_aspnet_Roles	ApplicationId	uniqueidentifier NOT NULL
vw_aspnet_Roles	RoleId	uniqueidentifier NOT NULL
vw_aspnet_Roles	RoleName	nvarchar(256) NOT NULL
vw_aspnet_Roles	LoweredRoleName	nvarchar(256) NOT NULL
vw_aspnet_Roles	Description	nvarchar(256) NULL
vw_aspnet_Users	ApplicationId	uniqueidentifier NOT NULL
vw_aspnet_Users	UserId	uniqueidentifier NOT NULL
vw_aspnet_Users	UserName	nvarchar(256) NOT NULL
vw_aspnet_Users	LoweredUserName	nvarchar(256) NOT NULL
vw_aspnet_Users	MobileAlias	nvarchar(16) NULL
vw_aspnet_Users	IsAnonymous	bit NOT NULL
vw_aspnet_Users	LastActivityDate	datetime NOT NULL
vw_aspnet_UsersInRoles	UserId	uniqueidentifier NOT NULL
vw_aspnet_UsersInRoles	RoleId	uniqueidentifier NOT NULL
vw_DesktopModulePermissions	DesktopModulePermissionID	int NOT NULL
vw_DesktopModulePermissions	PortalDesktopModuleID	int NOT NULL
vw_DesktopModulePermissions	PermissionID	int NULL
vw_DesktopModulePermissions	RoleID	int NULL
vw_DesktopModulePermissions	RoleName	nvarchar(50) NULL
vw_DesktopModulePermissions	AllowAccess	bit NOT NULL
vw_DesktopModulePermissions	UserID	int NULL
vw_DesktopModulePermissions	Username	nvarchar(100) NULL
vw_DesktopModulePermissions	DisplayName	nvarchar(128) NULL
vw_DesktopModulePermissions	PermissionCode	varchar(50) NULL
vw_DesktopModulePermissions	ModuleDefID	int NULL
vw_DesktopModulePermissions	PermissionKey	varchar(50) NULL
vw_DesktopModulePermissions	PermissionName	varchar(50) NULL
vw_DesktopModulePermissions	CreatedByUserID	int NULL
vw_DesktopModulePermissions	CreatedOnDate	datetime NULL
vw_DesktopModulePermissions	LastModifiedByUserID	int NULL
vw_DesktopModulePermissions	LastModifiedOnDate	datetime NULL
vw_FolderPermissions	FolderPermissionID	int NOT NULL
vw_FolderPermissions	FolderID	int NULL
vw_FolderPermissions	FolderPath	varchar(300) NULL
vw_FolderPermissions	PermissionID	int NULL
vw_FolderPermissions	RoleID	int NULL
vw_FolderPermissions	RoleName	nvarchar(50) NULL
vw_FolderPermissions	AllowAccess	bit NOT NULL
vw_FolderPermissions	UserID	int NULL
vw_FolderPermissions	Username	nvarchar(100) NULL
vw_FolderPermissions	DisplayName	nvarchar(128) NULL
vw_FolderPermissions	PermissionCode	varchar(50) NULL
vw_FolderPermissions	ModuleDefID	int NULL
vw_FolderPermissions	PermissionKey	varchar(50) NULL
vw_FolderPermissions	PermissionName	varchar(50) NULL
vw_FolderPermissions	PortalID	int NULL
vw_FolderPermissions	CreatedByUserID	int NULL
vw_FolderPermissions	CreatedOnDate	datetime NULL
vw_FolderPermissions	LastModifiedByUserID	int NULL
vw_FolderPermissions	LastModifiedOnDate	datetime NULL
vw_Lists	EntryID	int identity NOT NULL
vw_Lists	ListName	nvarchar(50) NOT NULL
vw_Lists	Value	nvarchar(100) NOT NULL
vw_Lists	Text	nvarchar(150) NOT NULL
vw_Lists	Level	int NOT NULL
vw_Lists	SortOrder	int NOT NULL
vw_Lists	DefinitionID	int NOT NULL
vw_Lists	ParentID	int NOT NULL
vw_Lists	Description	nvarchar(500) NULL
vw_Lists	PortalID	int NOT NULL
vw_Lists	SystemList	bit NOT NULL
vw_Lists	ParentKey	nvarchar(2000) NULL
vw_Lists	Parent	nvarchar(2000) NULL
vw_Lists	ParentList	nvarchar(2000) NULL
vw_Lists	MaxSortOrder	int NULL
vw_Lists	EntryCount	int NULL
vw_Lists	HasChildren	int NULL
vw_Lists	CreatedByUserID	int NULL
vw_Lists	CreatedOnDate	datetime NULL
vw_Lists	LastModifiedByUserID	int NULL
vw_Lists	LastModifiedOnDate	datetime NULL
vw_ModulePermissions	ModulePermissionID	int NOT NULL
vw_ModulePermissions	ModuleID	int NOT NULL
vw_ModulePermissions	PermissionID	int NULL
vw_ModulePermissions	RoleID	int NULL
vw_ModulePermissions	RoleName	nvarchar(50) NULL
vw_ModulePermissions	AllowAccess	bit NOT NULL
vw_ModulePermissions	UserID	int NULL
vw_ModulePermissions	Username	nvarchar(100) NULL
vw_ModulePermissions	DisplayName	nvarchar(128) NULL
vw_ModulePermissions	PermissionCode	varchar(50) NULL
vw_ModulePermissions	ModuleDefID	int NULL
vw_ModulePermissions	PermissionKey	varchar(50) NULL
vw_ModulePermissions	PermissionName	varchar(50) NULL
vw_ModulePermissions	CreatedByUserID	int NULL
vw_ModulePermissions	CreatedOnDate	datetime NULL
vw_ModulePermissions	LastModifiedByUserID	int NULL
vw_ModulePermissions	LastModifiedOnDate	datetime NULL
vw_Modules	PortalID	int NULL
vw_Modules	TabID	int NULL
vw_Modules	TabModuleID	int NULL
vw_Modules	ModuleID	int NOT NULL
vw_Modules	ModuleDefID	int NOT NULL
vw_Modules	ModuleOrder	int NULL
vw_Modules	PaneName	nvarchar(50) NULL
vw_Modules	ModuleTitle	nvarchar(256) NULL
vw_Modules	CacheTime	int NULL
vw_Modules	CacheMethod	varchar(50) NULL
vw_Modules	Alignment	nvarchar(10) NULL
vw_Modules	Color	nvarchar(20) NULL
vw_Modules	Border	nvarchar(1) NULL
vw_Modules	IconFile	nvarchar(300) NULL
vw_Modules	AllTabs	bit NOT NULL
vw_Modules	Visibility	int NULL
vw_Modules	IsDeleted	bit NULL
vw_Modules	Header	ntext NULL
vw_Modules	Footer	ntext NULL
vw_Modules	StartDate	datetime NULL
vw_Modules	EndDate	datetime NULL
vw_Modules	ContainerSrc	nvarchar(200) NULL
vw_Modules	DisplayTitle	bit NULL
vw_Modules	DisplayPrint	bit NULL
vw_Modules	DisplaySyndicate	bit NULL
vw_Modules	IsWebSlice	bit NULL
vw_Modules	WebSliceTitle	nvarchar(256) NULL
vw_Modules	WebSliceExpiryDate	datetime NULL
vw_Modules	WebSliceTTL	int NULL
vw_Modules	InheritViewPermissions	bit NULL
vw_Modules	DesktopModuleID	int NOT NULL
vw_Modules	DefaultCacheTime	int NOT NULL
vw_Modules	ModuleControlID	int NOT NULL
vw_Modules	BusinessControllerClass	nvarchar(200) NULL
vw_Modules	IsAdmin	bit NOT NULL
vw_Modules	SupportedFeatures	int NOT NULL
vw_Modules	ContentItemID	int NULL
vw_Modules	Content	nvarchar(max) NULL
vw_Modules	ContentTypeID	int NULL
vw_Modules	ContentKey	nvarchar(250) NULL
vw_Modules	Indexed	bit NULL
vw_Modules	CreatedByUserID	int NULL
vw_Modules	CreatedOnDate	datetime NULL
vw_Modules	LastModifiedByUserID	int NULL
vw_Modules	LastModifiedOnDate	datetime NULL
vw_Modules	UniqueId	uniqueidentifier NULL
vw_Modules	VersionGuid	uniqueidentifier NULL
vw_Modules	DefaultLanguageGuid	uniqueidentifier NULL
vw_Modules	LocalizedVersionGuid	uniqueidentifier NULL
vw_Modules	CultureCode	nvarchar(10) NULL
vw_Portals	PortalID	int NOT NULL
vw_Portals	PortalName	nvarchar(128) NOT NULL
vw_Portals	LogoFile	nvarchar(300) NULL
vw_Portals	FooterText	nvarchar(100) NULL
vw_Portals	ExpiryDate	datetime NULL
vw_Portals	UserRegistration	int NOT NULL
vw_Portals	BannerAdvertising	int NOT NULL
vw_Portals	AdministratorId	int NULL
vw_Portals	Currency	char(3) NULL
vw_Portals	HostFee	money NOT NULL
vw_Portals	HostSpace	int NOT NULL
vw_Portals	PageQuota	int NOT NULL
vw_Portals	UserQuota	int NOT NULL
vw_Portals	AdministratorRoleId	int NULL
vw_Portals	RegisteredRoleId	int NULL
vw_Portals	Description	nvarchar(500) NULL
vw_Portals	KeyWords	nvarchar(500) NULL
vw_Portals	BackgroundFile	nvarchar(300) NULL
vw_Portals	GUID	uniqueidentifier NOT NULL
vw_Portals	PaymentProcessor	nvarchar(50) NULL
vw_Portals	ProcessorUserId	nvarchar(50) NULL
vw_Portals	ProcessorPassword	nvarchar(50) NULL
vw_Portals	SiteLogHistory	int NULL
vw_Portals	Email	nvarchar(256) NULL
vw_Portals	DefaultLanguage	nvarchar(10) NOT NULL
vw_Portals	TimezoneOffset	int NOT NULL
vw_Portals	AdminTabId	int NULL
vw_Portals	HomeDirectory	varchar(100) NOT NULL
vw_Portals	SplashTabId	int NULL
vw_Portals	HomeTabId	int NULL
vw_Portals	LoginTabId	int NULL
vw_Portals	RegisterTabId	int NULL
vw_Portals	UserTabId	int NULL
vw_Portals	SearchTabId	int NULL
vw_Portals	SuperTabId	int NULL
vw_Portals	CreatedByUserID	int NULL
vw_Portals	CreatedOnDate	datetime NULL
vw_Portals	LastModifiedByUserID	int NULL
vw_Portals	LastModifiedOnDate	datetime NULL
vw_Portals	CultureCode	nvarchar(10) NOT NULL
vw_PortalsDefaultLanguage	PortalID	int NOT NULL
vw_PortalsDefaultLanguage	PortalName	nvarchar(128) NOT NULL
vw_PortalsDefaultLanguage	LogoFile	nvarchar(300) NULL
vw_PortalsDefaultLanguage	FooterText	nvarchar(100) NULL
vw_PortalsDefaultLanguage	ExpiryDate	datetime NULL
vw_PortalsDefaultLanguage	UserRegistration	int NOT NULL
vw_PortalsDefaultLanguage	BannerAdvertising	int NOT NULL
vw_PortalsDefaultLanguage	AdministratorId	int NULL
vw_PortalsDefaultLanguage	Currency	char(3) NULL
vw_PortalsDefaultLanguage	HostFee	money NOT NULL
vw_PortalsDefaultLanguage	HostSpace	int NOT NULL
vw_PortalsDefaultLanguage	PageQuota	int NOT NULL
vw_PortalsDefaultLanguage	UserQuota	int NOT NULL
vw_PortalsDefaultLanguage	AdministratorRoleId	int NULL
vw_PortalsDefaultLanguage	RegisteredRoleId	int NULL
vw_PortalsDefaultLanguage	Description	nvarchar(500) NULL
vw_PortalsDefaultLanguage	KeyWords	nvarchar(500) NULL
vw_PortalsDefaultLanguage	BackgroundFile	nvarchar(300) NULL
vw_PortalsDefaultLanguage	GUID	uniqueidentifier NOT NULL
vw_PortalsDefaultLanguage	PaymentProcessor	nvarchar(50) NULL
vw_PortalsDefaultLanguage	ProcessorUserId	nvarchar(50) NULL
vw_PortalsDefaultLanguage	ProcessorPassword	nvarchar(50) NULL
vw_PortalsDefaultLanguage	SiteLogHistory	int NULL
vw_PortalsDefaultLanguage	Email	nvarchar(256) NULL
vw_PortalsDefaultLanguage	DefaultLanguage	nvarchar(10) NOT NULL
vw_PortalsDefaultLanguage	TimezoneOffset	int NOT NULL
vw_PortalsDefaultLanguage	AdminTabId	int NULL
vw_PortalsDefaultLanguage	HomeDirectory	varchar(100) NOT NULL
vw_PortalsDefaultLanguage	SplashTabId	int NULL
vw_PortalsDefaultLanguage	HomeTabId	int NULL
vw_PortalsDefaultLanguage	LoginTabId	int NULL
vw_PortalsDefaultLanguage	RegisterTabId	int NULL
vw_PortalsDefaultLanguage	UserTabId	int NULL
vw_PortalsDefaultLanguage	SearchTabId	int NULL
vw_PortalsDefaultLanguage	SuperTabId	int NULL
vw_PortalsDefaultLanguage	CreatedByUserID	int NULL
vw_PortalsDefaultLanguage	CreatedOnDate	datetime NULL
vw_PortalsDefaultLanguage	LastModifiedByUserID	int NULL
vw_PortalsDefaultLanguage	LastModifiedOnDate	datetime NULL
vw_PortalsDefaultLanguage	CultureCode	nvarchar(10) NOT NULL
vw_SearchItems	SearchItemID	int NOT NULL
vw_SearchItems	PortalID	int NULL
vw_SearchItems	TabID	int NOT NULL
vw_SearchItems	ModuleID	int NOT NULL
vw_SearchItems	Title	nvarchar(200) NOT NULL
vw_SearchItems	Description	nvarchar(2000) NOT NULL
vw_SearchItems	Author	int NULL
vw_SearchItems	PubDate	datetime NOT NULL
vw_SearchItems	SearchKey	nvarchar(100) NOT NULL
vw_SearchItems	Guid	varchar(200) NULL
vw_SearchItems	HitCount	int NULL
vw_SearchItems	ImageFileId	int NULL
vw_SearchItems	AuthorName	nvarchar(128) NULL
vw_TabModules	PortalID	int NULL
vw_TabModules	TabID	int NULL
vw_TabModules	TabModuleID	int NULL
vw_TabModules	ModuleID	int NOT NULL
vw_TabModules	ModuleDefID	int NOT NULL
vw_TabModules	ModuleOrder	int NULL
vw_TabModules	PaneName	nvarchar(50) NULL
vw_TabModules	ModuleTitle	nvarchar(256) NULL
vw_TabModules	CacheTime	int NULL
vw_TabModules	CacheMethod	varchar(50) NULL
vw_TabModules	Alignment	nvarchar(10) NULL
vw_TabModules	Color	nvarchar(20) NULL
vw_TabModules	Border	nvarchar(1) NULL
vw_TabModules	IconFile	nvarchar(300) NULL
vw_TabModules	AllTabs	bit NOT NULL
vw_TabModules	Visibility	int NULL
vw_TabModules	IsDeleted	bit NULL
vw_TabModules	Header	ntext NULL
vw_TabModules	Footer	ntext NULL
vw_TabModules	StartDate	datetime NULL
vw_TabModules	EndDate	datetime NULL
vw_TabModules	ContainerSrc	nvarchar(200) NULL
vw_TabModules	DisplayTitle	bit NULL
vw_TabModules	DisplayPrint	bit NULL
vw_TabModules	DisplaySyndicate	bit NULL
vw_TabModules	IsWebSlice	bit NULL
vw_TabModules	WebSliceTitle	nvarchar(256) NULL
vw_TabModules	WebSliceExpiryDate	datetime NULL
vw_TabModules	WebSliceTTL	int NULL
vw_TabModules	InheritViewPermissions	bit NULL
vw_TabModules	DesktopModuleID	int NOT NULL
vw_TabModules	DefaultCacheTime	int NOT NULL
vw_TabModules	ModuleControlID	int NOT NULL
vw_TabModules	BusinessControllerClass	nvarchar(200) NULL
vw_TabModules	IsAdmin	bit NOT NULL
vw_TabModules	SupportedFeatures	int NOT NULL
vw_TabModules	ContentItemID	int NULL
vw_TabModules	Content	nvarchar(max) NULL
vw_TabModules	ContentTypeID	int NULL
vw_TabModules	ContentKey	nvarchar(250) NULL
vw_TabModules	Indexed	bit NULL
vw_TabModules	CreatedByUserID	int NULL
vw_TabModules	CreatedOnDate	datetime NULL
vw_TabModules	LastModifiedByUserID	int NULL
vw_TabModules	LastModifiedOnDate	datetime NULL
vw_TabModules	UniqueId	uniqueidentifier NULL
vw_TabModules	VersionGuid	uniqueidentifier NULL
vw_TabModules	DefaultLanguageGuid	uniqueidentifier NULL
vw_TabModules	LocalizedVersionGuid	uniqueidentifier NULL
vw_TabModules	CultureCode	nvarchar(10) NULL
vw_TabPermissions	TabPermissionID	int NOT NULL
vw_TabPermissions	TabID	int NOT NULL
vw_TabPermissions	PermissionID	int NULL
vw_TabPermissions	RoleID	int NULL
vw_TabPermissions	RoleName	nvarchar(50) NULL
vw_TabPermissions	AllowAccess	bit NOT NULL
vw_TabPermissions	UserID	int NULL
vw_TabPermissions	Username	nvarchar(100) NULL
vw_TabPermissions	DisplayName	nvarchar(128) NULL
vw_TabPermissions	PermissionCode	varchar(50) NULL
vw_TabPermissions	ModuleDefID	int NULL
vw_TabPermissions	PermissionKey	varchar(50) NULL
vw_TabPermissions	PermissionName	varchar(50) NULL
vw_TabPermissions	PortalId	int NULL
vw_TabPermissions	CreatedByUserID	int NULL
vw_TabPermissions	CreatedOnDate	datetime NULL
vw_TabPermissions	LastModifiedByUserID	int NULL
vw_TabPermissions	LastModifiedOnDate	datetime NULL
vw_Tabs	TabID	int NOT NULL
vw_Tabs	UniqueId	uniqueidentifier NOT NULL
vw_Tabs	VersionGuid	uniqueidentifier NOT NULL
vw_Tabs	DefaultLanguageGuid	uniqueidentifier NULL
vw_Tabs	LocalizedVersionGuid	uniqueidentifier NOT NULL
vw_Tabs	TabOrder	int NOT NULL
vw_Tabs	PortalID	int NULL
vw_Tabs	TabName	nvarchar(50) NOT NULL
vw_Tabs	IsVisible	bit NOT NULL
vw_Tabs	ParentId	int NULL
vw_Tabs	Level	int NOT NULL
vw_Tabs	IconFile	nvarchar(300) NULL
vw_Tabs	IconFileLarge	nvarchar(300) NULL
vw_Tabs	DisableLink	bit NOT NULL
vw_Tabs	Title	nvarchar(200) NULL
vw_Tabs	Description	nvarchar(500) NULL
vw_Tabs	KeyWords	nvarchar(500) NULL
vw_Tabs	IsDeleted	bit NOT NULL
vw_Tabs	SkinSrc	nvarchar(200) NULL
vw_Tabs	ContainerSrc	nvarchar(200) NULL
vw_Tabs	TabPath	nvarchar(255) NULL
vw_Tabs	StartDate	datetime NULL
vw_Tabs	EndDate	datetime NULL
vw_Tabs	Url	nvarchar(255) NULL
vw_Tabs	HasChildren	varchar(5) NOT NULL
vw_Tabs	RefreshInterval	int NULL
vw_Tabs	PageHeadText	nvarchar(500) NULL
vw_Tabs	IsSecure	bit NOT NULL
vw_Tabs	PermanentRedirect	bit NOT NULL
vw_Tabs	SiteMapPriority	float NOT NULL
vw_Tabs	ContentItemID	int NULL
vw_Tabs	Content	nvarchar(max) NULL
vw_Tabs	ContentTypeID	int NULL
vw_Tabs	ModuleID	int NULL
vw_Tabs	ContentKey	nvarchar(250) NULL
vw_Tabs	Indexed	bit NULL
vw_Tabs	CultureCode	nvarchar(10) NULL
vw_Tabs	CreatedByUserID	int NULL
vw_Tabs	CreatedOnDate	datetime NULL
vw_Tabs	LastModifiedByUserID	int NULL
vw_Tabs	LastModifiedOnDate	datetime NULL
vw_UserRoles	UserRoleID	int NOT NULL
vw_UserRoles	RoleID	int NOT NULL
vw_UserRoles	UserID	int NOT NULL
vw_UserRoles	PortalID	int NOT NULL
vw_UserRoles	RoleName	nvarchar(50) NOT NULL
vw_UserRoles	Username	nvarchar(100) NOT NULL
vw_UserRoles	Description	nvarchar(1000) NULL
vw_UserRoles	DisplayName	nvarchar(128) NOT NULL
vw_UserRoles	Email	nvarchar(256) NULL
vw_UserRoles	ServiceFee	money NULL
vw_UserRoles	BillingFrequency	char(1) NULL
vw_UserRoles	TrialPeriod	int NULL
vw_UserRoles	TrialFrequency	char(1) NULL
vw_UserRoles	BillingPeriod	int NULL
vw_UserRoles	TrialFee	money NULL
vw_UserRoles	IsPublic	bit NOT NULL
vw_UserRoles	AutoAssignment	bit NOT NULL
vw_UserRoles	RoleGroupID	int NULL
vw_UserRoles	RSVPCode	nvarchar(50) NULL
vw_UserRoles	IconFile	nvarchar(100) NULL
vw_UserRoles	EffectiveDate	datetime NULL
vw_UserRoles	ExpiryDate	datetime NULL
vw_UserRoles	IsTrialUsed	bit NULL
vw_UserRoles	CreatedByUserID	int NULL
vw_UserRoles	CreatedOnDate	datetime NULL
vw_UserRoles	LastModifiedByUserID	int NULL
vw_UserRoles	LastModifiedOnDate	datetime NULL
vw_Users	UserID	int NOT NULL
vw_Users	PortalId	int NULL
vw_Users	Username	nvarchar(100) NOT NULL
vw_Users	FirstName	nvarchar(50) NOT NULL
vw_Users	LastName	nvarchar(50) NOT NULL
vw_Users	DisplayName	nvarchar(128) NOT NULL
vw_Users	IsSuperUser	bit NOT NULL
vw_Users	Email	nvarchar(256) NULL
vw_Users	AffiliateId	int NULL
vw_Users	UpdatePassword	bit NOT NULL
vw_Users	Authorised	bit NULL
vw_Users	IsDeleted	bit NULL
vw_Users	RefreshRoles	bit NULL
vw_Users	LastIPAddress	nvarchar(50) NULL
vw_Users	CreatedByUserID	int NULL
vw_Users	CreatedOnDate	datetime NULL
vw_Users	LastModifiedByUserID	int NULL
vw_Users	LastModifiedOnDate	datetime NULL