Database Schema

This document provides a detailed description of the Database schema.

Table Descriptions

Table Name	Description	Purgeable	Deletion Script
ApplicationConfigurations	Holds configurations for system dashboards.	FALSE
Buildings	Contains data about buildings, including their properties.	FALSE
Clients	Contains details of clients using the system.	FALSE
ConfigurationDefaultValues	Defines default values for configuration settings.	FALSE
ExportDatas	Tracks data exports and their associated metadata.	FALSE
Features	Lists features available in the system and their properties.	FALSE
Levels	Holds information about levels	FALSE
PublishStatuses	Stores publish statuses	FALSE
RefreshTokens	Stores refresh tokens for user sessions.	FALSE
Roles	Defines roles within the system and their permissions.	FALSE
SdkConfigurations	Contains configuration data for the SDK.	FALSE
Sites	Stores information about sites and their associated data.	FALSE
Taxonomies	Stores taxonomies and their definitions.	FALSE
VersionDatas	Tracks version information of the system or its components.	FALSE
WebUserPasswordHistories	Logs password history for web users to enhance security.	FALSE
WebUserPermissions	Defines permissions granted to web users.	FALSE
WebUserRecoveries	Tracks password recovery attempts for web users.	FALSE
WebUsers	Stores information about web users and their credentials.	FALSE
WebhookConfigurations	Stores configurations for webhooks used in the system.	FALSE
WebhookLogs	Keeps records of webhooks triggered after specific operations.	TRUE	DELETE FROM WebhookLogs WHERE CreatedDate < @CutoffDate;
__EFMigrationsHistory	Tracks the migration history of Entity Framework schema changes.	FALSE

Table Relationships