Skip to content

Apps schema tables

The Apps schema is used to store information about the Sidra Client Apps 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
Name Name of the app varchar(80)
Description Brief description of the purpose of the app nvarchar(256)
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
TenantId Tenant identifier to access the resources where the app is deployed uniqueidentifier
SubscriptionId Azure subscription identifier where the app is deployed uniqueidentifier
SubscriptionName Azure subscription name where the app is deployed nvarchar(90)
ResourceGroupName Azure resource group name where the infrastructure of the app is deployed nvarchar(90)
IsRemoved Flag to identify that the app is not deployed or used bit
ExtendedProperties JSON structure intended for extensibility nvarchar(max)
LastUpdated Date of the last time that the app was updated datetime2(0)
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)

Sidra Ideas Portal

Last update: 2022-08-19
Back to top