Add row:
Not allowed
Delete row:
Not allowed
Foreign key:
Not allowed
Columns
| Name | Datatype | Read | Write | Primary key | Description |
|---|---|---|---|---|---|
| CredentialsId | uniqueidentifier | Yes | No | Yes | Primary key. |
| InternalName | varchar(100) | Yes | No | No | The name components and settings use to refer to the credentials. |
| Description | nvarchar(1000) | Yes | No | No | User-friendly description of how the credentials are used. |
| CredentialType | varchar(50) | Yes | No | No | 'Account' or 'Secret'. Describes the type of credentials. |
| AccountName | nvarchar(300) | Yes | No | No | If the credentials are stored in the database, the account name. |
| AccountNameAppSetting | varchar(100) | Yes | No | No | If the credentials are stored in an app setting, the name of the app setting with the account name. |
| AccountPasswordAppSetting | varchar(100) | Yes | No | No | If the credentials are stored in an app setting, the name of the app setting with the account password. |
| AccountNameKeyVaultSecret | varchar(100) | Yes | No | No | If the credentials are stored in Azure Key Vault, the name of the secret with the account name. |
| AccountPasswordKeyVaultSecret | varchar(100) | Yes | No | No | If the credentials are stored in Azure Key Vault, the name of the secret with the account password. |
| UpdateDatetime | datetime | Yes | No | No | |
| UserGuidUpdate | uniqueidentifier | Yes | No | No | |
| UsernameUpdate | varchar(120) | Yes | No | No |