Apps schema tables¶
The Apps schema is used to store information about the Sidra Data Products which will use the information stored in the Data Lake.
App table¶
This table contains information about the Apps registered to access the Data Lake. It is used by the Sidra Manager UI to present the information about registered apps.
| Column | Description | Format | Required |
|---|---|---|---|
| Id | App identifier | int | Yes |
| Name | Name of the app | varchar(80) | Yes |
| Description | Brief description of the purpose of the app | nvarchar(256) | Yes |
| IsSystemApp | Flag to identify the apps created by Sidra platform respect to the custom apps created specifically for an installation | ||
| Owner | Person responsible for the app | bit | Yes |
| TenantId | Tenant identifier to access the resources where the app is deployed | uniqueidentifier | Yes |
| SubscriptionId | Azure subscription identifier where the app is deployed | uniqueidentifier | Yes |
| SubscriptionName | Azure subscription name where the app is deployed | nvarchar(90) | Yes |
| ResourceGroupName | Azure resource group name where the infrastructure of the app is deployed | nvarchar(90) | Yes |
| IsRemoved | Flag to identify that the app is not deployed or used | bit | Yes |
| ExtendedProperties | JSON structure intended for extensibility | nvarchar(max) | |
| LastUpdated | Date of the last time that the app was updated | datetime2(0) | Yes |
| LastDeployed | Data of the last time that the app was deployed | datetime2(0) | |
| ManagementDatabase | Name of the Sidra database in the app | varchar(128) | |
| ManagementDatabaseServer | Name of the Sidra database server in the app | varchar(128) | |
| Image | Image used for the app in the Sidra Manager UI | varbinary(max) | |
| ClientId | Identifier of client | nvarchar(450) | |
| ShortProductName | Abbreviated name of product | varchar(10) | |
| ShortProjectName | Abbreviated name of project | varchar(4) | |
| ApplicationDisplayName | Name displayed of the application | nvarchar(250) | |
| ResourceGroupLocation | Location of the Resource Group | nvarchar(25) | |
| Detail | Field for detailed info | nvarchar(700) |