Documentation

Public Tables

ADMINADGroup (Deprecated from Softadmin® 5.4.019)

Maps Active Directory groups against roles and functions. Used by advanced single-sign on.

The contents of this table are not deployed.

Add row: Allowed

Delete row: Allowed

Foreign key: Not allowed

Columns:

Name	Datatype	Read	Write	Primary key	Description
ADGroupID	int	Yes	No	Yes	Primary key.
ADGroup	varchar(500)	Yes	Yes	No	The name of the AD group to map. Must match the actual group's name. Case insensitive. The same group may occur multiple times if you need to assign both role and functions to its members.
RoleID	int	Yes	Yes	No	Role to give members of this group. If a user belongs to multiple groups he gets the one with the lowest sort order. A user must always be assigned at least one role to be able to log in, even if you also use functions.
FunctionID	int	Yes	Yes	No	Function to assign members of this group. Any previous function mappings are deleted each time a user logs in.
SortOrder	int	Yes	Yes	No	Sort order.

ADMINLoginLinkInstance (Deprecated from Softadmin® 5.4.019)

Instances of login links.

Administer the table with dbo.ADMIN_LoginLinkInstance_Insert and dbo.ADMIN_LoginLinkInstance_Delete.

Add row: Not allowed

Delete row: Not allowed

Foreign key: Not allowed

Columns:

Name	Datatype	Read	Write	Primary key	Description
LoginLinkInstanceId	int	Yes	No	Yes	Primary key.
LoginLinkId	int	Yes	No	No	Link id.
LinkKey	int	No	No	No	Private.
UserIdAutoLogin	int	No	No	No	Private.
InsertDatetimeUtc	datetime	Yes	No	No	When the link was instantiated.
ExpiresDatetimeUtc	datetime	Yes	No	No	When the link expires.

ADMINLoginLog (Deprecated from Softadmin® 5.4.019)

Log of login attempts, both successful and unsuccessful.

Add row: Not allowed

Delete row: Not allowed

Foreign key: Not allowed

Columns:

Name	Datatype	Read	Write	Primary key	Description
LoginLogId	int	No	No	Yes	Private.
LogDatetime	datetime	Yes	No	No	Time of the login attempt.
LoginResultId	tinyint	Yes	No	No	Result of the login attempt. See ADMINLoginResult.
UserId	int	Yes	No	No	ID of user that logged in. May contain ID values of users that since have been deleted from ADMINUser.
Username	varchar(300)	Yes	No	No	Name of the user. Either the name entered in the username field or the user's account in the domain. You should only use this column for debugging and never make any assumptions about its contents.
IpAddress	varchar(40)	Yes	No	No	The client's IP address. Can be on any format but will in practice either be IPv4 or IPv6.
UserAgent	varchar(1000)	Yes	No	No	User agent of client's browser.
Https	bit	Yes	No	No	If the client was using HTTPS.

ADMINLoginResult (Deprecated from Softadmin® 5.4.019)

Lookup table for login results.

Add row: Not allowed

Delete row: Not allowed

Foreign key: Not allowed

Columns:

Name	Datatype	Read	Write	Primary key	Description
LoginResultId	tinyint	Yes	No	Yes	Primary key.
LoginResult	varchar(300)	Yes	No	No	Description.
IsSuccessfulLogin	bit	Yes	No	No	Whether the result represents a successful login or not. A failed login is anything that prevents the user from logging in, from an invalid password to an internal error.

ADMINLogMenuItem (Deprecated from Softadmin® 5.4.019)

Logs user activity in system. Only logs when a user first loads a menuitem, not if he refreshes it in the browser.

Add row: Not allowed

Delete row: Not allowed

Foreign key: Not allowed

Columns:

Name	Datatype	Read	Write	Primary key	Description
LogMenuitemID	int	No	No	Yes	Primary key.
UserID	int	Yes	No	No	User ID.
MenuitemID	int	Yes	No	No	ID of the menu item the user viewed.
LogDatetime	datetime	Yes	No	No	When the user viewed the menu item.
IsNotified	bit	No	No	No	Private.

ADMINMaintenanceUserRights (Deprecated from Softadmin® 5.4.019)

Lookup table with possible user rights in the maintenance center. ADMINUser references this table.

Add row: Not allowed

Delete row: Not allowed

Foreign key: Not allowed

Columns:

Name	Datatype	Read	Write	Primary key	Description
MaintenanceUserRightsId	int	Yes	No	Yes	Primary key.
MaintenanceUserRights	varchar(300)	Yes	No	No	Name of rights. In English.
MaintenanceUserRights_p	int	Yes	No	No	PhraseId of language phrase with translated rights names.

ADMINSearch (Deprecated from Softadmin® 5.4.019)

Contains saved searches.

Add row: Not allowed

Delete row: Not allowed

Foreign key: Allowed

Columns:

Name	Datatype	Read	Write	Primary key	Description
SearchID	int	Yes	No	Yes	Primary key.
SearchGroupID	int	Yes	No	No	Search group.
MenuItemID	int	Yes	No	No	Menu item search was saved for.
SearchName	varchar(300)	Yes	No	No	Name user saved search with.
UserID	int	Yes	No	No	User who last updated the search.
CreatedDatetime	datetime	Yes	No	No	When the user first saved the search.
UpdatedDatetime	datetime	Yes	No	No	When the user last updated the search.

ADMINSearchGroup (Deprecated from Softadmin® 5.4.019)

Contains search groups for saved searches.

Add row: Not allowed

Delete row: Not allowed

Foreign key: Allowed

Columns:

Name	Datatype	Read	Write	Primary key	Description
SearchGroupID	int	Yes	No	Yes	Primary key.
SearchGroupName	varchar(300)	Yes	No	No	Name of search group.

ADMINUser (Deprecated from Softadmin® 5.4.019)

Stores properties about users in the system.

Add row: Not allowed

Delete row: Not allowed

Foreign key: Allowed

Columns:

Name	Datatype	Read	Write	Primary key	Description
UserID	int	Yes	No	Yes	Primary key for the user. You may create foreign keys referencing this column.
Username	varchar(50)	Yes	No	No	The username the user uses to login to the system
Password	varchar(50)	No	No	No	Password the user uses to login to the system. This column is only relevant when password hashing is turned off.
UsernameFirst	varchar(50)	Yes	No	No	Users first name
UsernameLast	varchar(50)	Yes	No	No	Users last name
UserEmail	varchar(100)	Yes	No	No	Users email address
LanguageID	int	Yes	No	No	Reference to the users default language in the ADMINLanguage table
RoleID	int	Yes	No	No	Reference to the users role in the AMDINRole table
Administrator	bit	Yes	No	No	Indicates that the user is a Softadmin® administrator.
Enabled	bit	Yes	No	No	Indicates whther the account is active, i.e. can be used to login to the system.
MaintenanceUserRightsID	int	Yes	No	No	Reference to the users maintenance rights in the ADMINMaintenanceUserIRights table.
HelpAdministrator	bit	No	No	No	Indicates that the user is a help administrator, i.e. is allowed to edit documentation pages for the system.
PasswordHash	binary	No	No	No	Hash of the users password. This column is only relevant when password hashing is enabled.
PasswordSalt	binary	Yes	No	No	Salt used to compute the password hash. This column is only relevant when password hashing is enabled.
PasswordHasExpired	bit	Yes	No	No	Indicates that the users password has expired and needs to be reset.
PasswordUpdateDatetime	datetime	Yes	No	No	Indicates that last time the users password was changed.
CreateDatetime	datetime	Yes	No	No	Indicates when the account was initially created.
LatestNewsViewingDatetime	datetime	No	No	No	Private. Indicates the last time the user viewed news from the news channel.
UsernameFull	varchar(101)	Yes	No	No	Concatenation of UsernameFirst and UsernameLast.

ADMINUserFunctionEditable (Deprecated from Softadmin® 5.4.019)

Contains connections between users and functions.

Add row: Allowed

Delete row: Allowed

Foreign key: Allowed

Columns:

Name	Datatype	Read	Write	Primary key	Description

ADMINWebServer

This table should be used whenever the system uses multiple sites (e.g. for load balancing or authentication/SSO purposes).
Clear Cache will clear the cache for all registered sites in addition to the site where the command was issued.

Neither used by Publish nor WebDAV.

Add row: Allowed

Delete row: Allowed

Foreign key: Not allowed

Columns:

Name	Datatype	Read	Write	Primary key	Description
WebserverId	int	Yes	No	Yes	Primary key.
Internalapplicationurl	varchar(500)	Yes	Yes	No	The URL to the application.
Internalclearcacheurl	varchar(500)	Yes	Yes	No	Leave blank to use the default clear cache URL. Otherwise provide an alternative URL to use when clearing cache.

SoftadminApi.AdGroup

Maps Active Directory groups against roles and functions. Used by advanced single-sign on.

The contents of this table are not deployed.

Add row: Allowed

Delete row: Allowed

Foreign key: Not allowed

Columns:

Name	Datatype	Read	Write	Primary key	Description
AdGroupId	int	Yes	No	Yes	Primary key.
AdGroup	varchar(500)	Yes	Yes	No	The name of the AD group to map. Must match the actual group's name. Case insensitive. Should not be prefixed with the domain name, that is, use GROUP, not DOMAIN\GROUP. You can use this command line to list all groups in a domain: net groups /domain The same group may occur multiple times if you need to assign both role and functions to its members.
RoleId	int	Yes	Yes	No	Role to give members of this group. If a user belongs to multiple groups the one with the lowest sort order is used. A user must always be assigned at least one role to be able to log in, even if you also use functions.
FunctionId	int	Yes	Yes	No	Function to assign members of this group. Any previous function mappings are deleted each time a user logs in.
SortOrder	int	Yes	Yes	No	Sort order.

SoftadminApi.AzureAdGroup

The security groups used to control access and permissions.

When a user logs in the rows with a non-null RoleId are sorted by SortOrder and the first is then assigned as the user's new role.

The contents of this table are not deployed.

Add row: Allowed

Delete row: Allowed

Foreign key: Allowed

Columns:

Name	Datatype	Read	Write	Primary key	Description
AzureAdGroupId	uniqueidentifier	Yes	Yes	Yes	The group's ID. This value is defined by Azure AD and can be found in the Object ID field under the group's properties in the management console.
GroupName	varchar(300)	Yes	Yes	No	The group's human-readable name.
Description	varchar(4000)	Yes	Yes	No	Additional comments.
RoleId	int	Yes	Yes	No	Used together with SortOrder to determine which role is assigned to users that log in.
SortOrder	int	Yes	Yes	No	Used together with RoleId.

SoftadminApi.AzureAdTenant

The tenants that should have access to the application.

The contents of this table are not deployed.

Add row: Allowed

Delete row: Allowed

Foreign key: Allowed

Columns:

Name	Datatype	Read	Write	Primary key	Description
AzureAdTenantId	uniqueidentifier	Yes	Yes	Yes	The tenant's ID. This value is defined by Azure AD and can be found under the tenant's properties in the management console.
TenantName	varchar(300)	Yes	Yes	No	The tenant's human-readable name.
Description	varchar(4000)	Yes	Yes	No	Additional comments.

SoftadminApi.AzureAppRole

The application roles (if any) that this system exports to Azure AD.

You can use the procedure SoftadminApi.AzureAppRole_Export to export the table.

The contents of this table are not deployed.

You should never delete roles that users are assigned to so use the IsEnabled column to disable obsolete roles instead!

Add row: Allowed

Delete row: Allowed

Foreign key: Allowed

Columns:

Name	Datatype	Read	Write	Primary key	Description
AzureAppRoleId	uniqueidentifier	Yes	Yes	Yes	The role's ID, as exported to Azure AD.
RoleName	int	Yes	Yes	No	The role's human-readable name.
Description	varchar(4000)	Yes	Yes	No	Additional comments. This field is exported to Azure so it should not contain internal documentation.
IsEnabled	bit	Yes	Yes	No	Whether the role is enabled or not. You should never delete roles that users are assigned to so use this column to disable obsolete roles instead!

SoftadminApi.BankgiroFileIncoming (View)

Stores files from Bankgirot, automatically fetched from the incoming FTP server. Only applicable when using the "FTP via Internet" and "Third party files via FTP" delivery methods.

Use the Bankgiro component in "Process files" mode to process the files.

Add row: Not allowed

Delete row: Not allowed

Foreign key: Not allowed

Columns:

Name	Datatype	Read	Write	Primary key	Description
BankgiroFileIncomingId	int	Yes	No	Yes	Primary key.
FileName	varchar(300)	Yes	No	No	Filename from Bankgirot.
Product	varchar(30)	Yes	No	No	Identified by the component, based on file contents. One of AG BGI BGI IMAGE LBUT UNKNOWN Only attempt to process files with a product supported by the component. Files of type "BGI IMAGE" will be deleted after a week to keep disk usage down. If they need to be kept longer than that, they have to be put in another table. If the file was found in a subdirectory, then the product is assumed to be the name of the subdirectory.
ReceivedDateTimeUtc	datetime2	Yes	No	No	When the file was retrieved from the local FTP server; not when Bankgirot put it there.
IsProcessed	bit	Yes	No	No	Use the procedure SoftadminApi.BankgiroFtp_SetAsProcessed to update the status after the file has been processed.
IsTestFile	bit	Yes	No	No	If the file is a test file.
IsThirdPartyFile	bit	Yes	No	No	Set to 1 if the file was found in a subdirectory on the FTP server.
File	varbinary	Yes	No	No	File data.

SoftadminApi.BankgiroFileOutgoing (View)

Files generated by the Bankgiro component in the "FTP via Internet" and "Third party files via FTP" modes will be placed here. The files will then automatically be uploaded to Bankgirot.

Add row: Not allowed

Delete row: Not allowed

Foreign key: Not allowed

Columns:

Name	Datatype	Read	Write	Primary key	Description
BankgiroFileOutgoingId	int	Yes	No	Yes	Primary key.
FileName	varchar(300)	Yes	No	No	Filename generated by the component.
Product	varchar(30)	Yes	No	No	The type of file. Currently only 'AG' can be generated.
Action	varchar(30)	Yes	No	No	One of 'AgBetUnd', 'AgBetMak', and 'AgMedgivReg', depending on the file.
CreatedDateTimeUtc	datetime2	Yes	No	No	When the file was inserted into the table.
SentDateTimeUtc	datetime2	Yes	No	No	Set when the file has been sent to Bankgirot's FTP server.
IsTestFile	bit	Yes	No	No	Set to 1 if the file is a test file.
IsThirdPartyFile	bit	Yes	No	No	Set to 1 if the "Third party files via FTP" mode was used to place the file in the queue.
File	varbinary	Yes	No	No	File data.

SoftadminApi.BankIdSignature

Stores BankID signatures.

Add row: Not allowed

Delete row: Not allowed

Foreign key: Allowed

Columns:

Name	Datatype	Read	Write	Primary key	Description
BankIdSignatureId	int	No	No	Yes

SoftadminApi.Job_History

Lists when the system's scheduled jobs run.

Add row: Not allowed

Delete row: Not allowed

Foreign key: Not allowed

Columns:

Name	Datatype	Read	Write	Primary key	Description
JobGuid	uniqueidentifier	Yes	No	No	The job's ID.
JobName	varchar(200)	Yes	No	No	The job's name.
RunDateTimeUtc	datetime	Yes	No	No	When the job started running, universal time.
CompletedDatetimeUtc	datetime	Yes	No	No	When the job completed running, universal time. If NULL then the job is either still running or the system suffered an outage severe enough to prevent it from logging job failure.
IsError	bit	Yes	No	No	Whether an error was raised during job execution.

SoftadminApi.Language

The system's languages.

Add row: Not allowed

Delete row: Not allowed

Foreign key: Not allowed

Columns:

Name	Datatype	Read	Write	Primary key	Description
LanguageId	int	Yes	No	Yes
Language	varchar(50)	No	No	No	The language's name.
CultureCode	varchar(20)	No	No	No	The language's culture code, compatible with the FORMAT function.
IsEnabled	bit	No	No	No

SoftadminApi.LoginLinkInstance

Instances of login links.

Administer the table with SoftadminApi.LoginLinkInstance_Insert and SoftadminApi.LoginLinkInstance_Delete.

Add row: Not allowed

Delete row: Not allowed

Foreign key: Not allowed

Columns:

Name	Datatype	Read	Write	Primary key	Description
LoginLinkInstanceId	int	Yes	No	Yes	Primary key.
LoginLinkId	int	Yes	No	No	Link id.
LinkKey	int	No	No	No	Private.
UserIdAutoLogin	int	No	No	No	Private.
InsertDatetimeUtc	datetime2	Yes	No	No	When the link was instantiated.
ExpiresDatetimeUtc	datetime2	Yes	No	No	When the link expires.

SoftadminApi.LoginLog (View)

Log of login attempts, both successful and unsuccessful.

Add row: Not allowed

Delete row: Not allowed

Foreign key: Not allowed

Columns:

Name	Datatype	Read	Write	Primary key	Description
LoginLogId	int	No	No	Yes	Primary key.
LogDatetime	datetime	Yes	No	No	Time of the login attempt.
LoginResultId	tinyint	Yes	No	No	Result of the login attempt.
LoginResult	int	Yes	No	No	Description of LoginResultId.
IsSuccessfulLogin	bit	No	No	No	Whether the result represents a successful login or not. A failed login is anything that prevents the user from logging in, from an invalid password to an internal error.
UserId	int	Yes	No	No	ID of user that logged in. May contain Id values of users that since have been deleted from SoftadminApi.User.
Username	varchar(300)	Yes	No	No	Name of the user. Either the name entered in the username field or the user's account in the domain. You should only use this column for debugging and never make any assumptions about its contents.
IpAddress	varchar(40)	Yes	No	No	The client's IP address. Can be on any format but will in practice either be IPv4 or IPv6.
UserAgent	varchar(1000)	Yes	No	No	User agent of client's browser.
Https	bit	Yes	No	No	If the client was using HTTPS.

SoftadminApi.LoginResult (View)

Lookup table for login results.

Add row: Not allowed

Delete row: Not allowed

Foreign key: Not allowed

Columns:

Name	Datatype	Read	Write	Primary key	Description
LoginResultId	tinyint	Yes	No	Yes	Primary key.
LoginResult	varchar(300)	Yes	No	No	Description.
IsSuccessfulLogin	bit	Yes	No	No	Whether the result represents a successful login or not. A failed login is anything that prevents the user from logging in, from an invalid password to an internal error.

SoftadminApi.LogMenuItem (View)

Logs user activity in system. Only logs when a user first loads a menuitem, not if he refreshes it in the browser.

Add row: Not allowed

Delete row: Not allowed

Foreign key: Not allowed

Columns:

Name	Datatype	Read	Write	Primary key	Description
LogMenuitemID	int	No	Yes	Yes	Primary key.
UserID	int	Yes	No	No	User ID.
MenuitemID	int	Yes	No	No	ID of the menu item the user viewed.
LogDatetime	datetime	Yes	No	No	When the user viewed the menu item.
IsNotified	bit	No	No	No	Private.

SoftadminApi.MailQueue

Shows the state of the mail queue.

The queue contains unsent and failed mail. Sent mail is immediately deleted from the queue. Emails that had errors are deleted after a week.

Add row: Not allowed

Delete row: Allowed

Foreign key: Not allowed

Columns:

Name	Datatype	Read	Write	Primary key	Description
EmailId	bigint	Yes	No	Yes	Primary key.
InsertDatetime	datetime	Yes	No	No	When the mail was enqueued.
ErrorCode	int	Yes	No	No	Error code, if the mail failed.
ErrorMessage	varchar(8000)	Yes	No	No	Error message, if the mail failed.

SoftadminApi.MenuItemPermission

Presents a view of the access permissions of the system's menu items.

You should mostly use this view to present an overview of the system's mapping of functions to menu items to the system owner so that he or she can verify that it is correct.

If you need to determine if a specific user has access to a menu item then use SoftadminApi.User_HasAccessToMenuItem instead.

Add row: Not allowed

Delete row: Not allowed

Foreign key: Not allowed

Columns:

Name	Datatype	Read	Write	Primary key	Description
MenuItemId	int	Yes	No	No	Id of the menu item.
MenuGroupId	int	Yes	No	No	Id of the menu group the menu item belongs to.
AllUsers	bit	Yes	No	No	If 1, all users have access to the menu item.
RoleId	int	Yes	No	No	Role that has access to the menu item.
FunctionId	int	Yes	No	No	Function that has access to the menu item.

SoftadminApi.PasswordResetRequestLog

Logs each time a user clicks I forgot my password on the login page and requests a password reset mail to be sent.

Add row: Not allowed

Delete row: Not allowed

Foreign key: Not allowed

Columns:

Name	Datatype	Read	Write	Primary key	Description
PasswordResetRequestLogId	int	Yes	No	Yes	Primary key
LogDatetime	datetime	Yes	No	No	Timestamp.
UserEmail	varchar(100)	Yes	No	No	The email address that the user requested that their password reset be sent to.
IpAddress	varchar(40)	Yes	No	No	IP address the request originated from.
EmailDidMatchExistingUser	bit	Yes	No	No	Whether an enabled account with the given email address existed at the time of the request.

SoftadminApi.SavedSearch

Contains saved searches.

Add row: Not allowed

Delete row: Not allowed

Foreign key: Allowed

Columns:

Name	Datatype	Read	Write	Primary key	Description
SavedSearchId	int	Yes	No	Yes	Primary key.
SavedSearchGroupId	int	Yes	No	No	Search group.
MenuItemId	int	Yes	No	No	Menu item search was saved for.
SearchName	varchar(300)	Yes	No	No	Name user saved search with.
UserId	int	Yes	No	No	User who last updated the search.
CreatedDatetime	datetime	Yes	No	No	When the user first saved the search.
UpdatedDatetime	datetime	Yes	No	No	When the user last updated the search.

SoftadminApi.SavedSearchGroup (View)

Contains search groups for saved searches.

Add row: Not allowed

Delete row: Not allowed

Foreign key: Not allowed

Columns:

Name	Datatype	Read	Write	Primary key	Description
SavedSearchGroupId	int	Yes	No	No	Primary key.
SavedSearchGroupName	varchar(300)	Yes	No	No	Name of search group.

SoftadminApi.Setting_Values

All settings (application variables).

Add row: Not allowed

Delete row: Not allowed

Foreign key: Not allowed

Columns:

Name	Datatype	Read	Write	Primary key	Description
SettingId	int	Yes	No	Yes
SettingName	varchar(100)	Yes	No	No
Value	varchar(1000)	Yes	No	No	The value of the application variable or NULL if it doesn't exist.

SoftadminApi.User

Stores properties about users in the system.

Add row: Not allowed

Delete row: Not allowed

Foreign key: Allowed

Columns:

Name	Datatype	Read	Write	Primary key	Description
UserId	int	Yes	No	Yes	Primary key for the user. You may create foreign keys referencing this column.
Username	varchar(50)	Yes	No	No	The username the user uses to login to the system
UsernameFirst	varchar(50)	Yes	No	No	Users first name
UsernameLast	varchar(50)	Yes	No	No	Users last name
UsernameFull	varchar(101)	Yes	No	No	Concatenation of UsernameFirst and UsernameLast.
UserEmail	varchar(100)	Yes	No	No	Users email address
RoleId	int	Yes	No	No	Reference to the users role in the AMDINRole table
IsAdministrator	bit	Yes	No	No	Indicates that the user is a Softadmin® administrator.
LanguageId	int	Yes	No	No	Reference to the users default language in the ADMINLanguage table
IsEnabled	bit	Yes	No	No	Indicates whther the account is active, i.e. can be used to login to the system.
CreateDatetimeUtc	datetime2	Yes	No	No	Indicates when the account was initially created.
PasswordHash	binary	No	No	No	Hash of the users password. This column is only relevant when password hashing is enabled.
PasswordSalt	binary	Yes	No	No	Salt used to compute the password hash. This column is only relevant when password hashing is enabled.
PasswordHasExpired	bit	Yes	No	No	Indicates that the users password has expired and needs to be reset.
PasswordUpdateDatetimeUtc	datetime2	Yes	No	No	Indicates that last time the users password was changed.
MaintenanceUserRightsId	int	No	No	No	Reference to the users maintenance rights in the ADMINMaintenanceUserIRights table.
CanUseVirtualMenuItems	bit	Yes	No	No	Indicates that the user sees Visual menu items.
IsHelpAdministrator	bit	No	No	No	Indicates that the user is a help administrator, i.e. is allowed to edit documentation pages for the system.
PersonalNumber	char	Yes	No	No	The personal number of the user, set with SoftadminApi.User_UpdatePersonalNumber. Can e.g. be used with the BankID component.
FirstNameLastName	varchar(101)	Yes	No	No	Concatenation of first and last name.
LastNameFirstName	varchar(101)	Yes	No	No	Concatenation of last and first name.

SoftadminApi.UserAppKey

Login keys that have been issued to the Softadmin® Go app.

You can delete rows from this table to destroy keys, for example when a user's mobile device has been stolen.

Add row: Not allowed

Delete row: Allowed

Foreign key: Not allowed

Columns:

Name	Datatype	Read	Write	Primary key	Description
UserId	int	Yes	No	Yes	User the key belongs to.
KeyId	uniqueidentifier	Yes	No	Yes	The key's id.
AppKey	int	No	No	No	The key. The format is opaque.
InsertDatetimeUtc	datetime	Yes	No	No	When the key was created.
LastUsedDatetimeUtc	datetime	Yes	No	No	Last time the key was used.
ExpiresDatetimeUtc	datetime	Yes	Yes	No	When the key will expire. This column is used to force key rotation: the user will be issued a new key if logging in with a key that will expire but that has not yet expired.

SoftadminApi.UserFavorite (View)

The user's favorites.

Requires a clear cache after DML.

Insert rows with caution, the menuitem should be reachable without passingfields.

May be used to remove menuitems/menugroups that have changed hide-status or received passingfields.

Add row: Allowed

Delete row: Allowed

Foreign key: Not allowed

Columns:

Name	Datatype	Read	Write	Primary key
UserId	int	Yes	Yes	No
MenuItemId	int	Yes	Yes	No
MenuGroupId	int	Yes	Yes	No
SortOrder	int	Yes	Yes	No

SoftadminApi.UserFunction (View)

Contains connections between users and functions.

Add row: Allowed

Delete row: Allowed

Foreign key: Not allowed

Columns:

Name	Datatype	Read	Write	Primary key	Description
UserId	int	Yes	Yes	No	User Id.
FunctionId	int	Yes	Yes	No	Function Id.

SoftadminApi.UserSecurityGroup

Modify this table to configure user's access to rows indexed by Enterprise Search.

Add row: Allowed

Delete row: Allowed

Foreign key: Not allowed

Columns:

Name	Datatype	Read	Write	Primary key	Description

SoftadminApi.WebServiceRequestLog (View)

Contains all webservice log data. Data is inserted depending on system settings "WebServiceLoggingEnabled" and "WebServiceRequestBodyLoggingEnabled".

Add row: Not allowed

Delete row: Allowed

Foreign key: Allowed

Columns:

Name	Datatype	Read	Write	Primary key	Description
RequestLogId	int	Yes	No	Yes
WebServiceId	int	Yes	No	No
Url	nvarchar	Yes	No	No
HttpMethod	varchar(30)	Yes	No	No
SoapAction	nvarchar	Yes	No	No
IpAddress	varchar(300)	Yes	No	No
Username	varchar(300)	Yes	No	No	Username when passowrd validation is used.
RequestMessage	nvarchar	Yes	No	No
ResponseMessage	nvarchar	Yes	No	No

SoftadminDev.Document

The table is only used as a support table for development purposes. To add a document use the Admin menugroup. Do not write procedures that rely on this table.

Add row: Not allowed

Delete row: Not allowed

Foreign key: Not allowed

Columns:

Name	Datatype	Read	Write	Primary key	Description
DocumentId	int	Yes	No	Yes	Primary Key
Document	varbinary	Yes	Yes	No	The document
DocumentContentSize	int	Yes	No	No	Size of the document.
DocumentContentType	varchar(300)	Yes	No	No	Type of document
DocumentFilename	varchar(300)	Yes	Yes	No	Name of the document
DocumentDescription	varchar(1000)	Yes	Yes	No	Description for the document