Database Schema
This document provides a detailed description of the Database schema.
Table Descriptions
Table Name | Description | Purgeable | Deletion Script |
---|---|---|---|
ClientConfigurations | Stores configurations for clients used in the system. | FALSE | |
EngineConfigurations | Stores configurations for engines used in the system. | FALSE | |
Files | Stores floorplan job files. | FALSE | |
FloorPlanJobs | Stores floorplan jobs and job details. | FALSE | |
Users | Stores information about users and their credentials. | FALSE | |
WebhookConfiguration | Stores configurations for webhooks used in the system. | FALSE | |
WebhookLogs | Keeps records of webhooks triggered after specific operations. | FALSE | DELETE FROM WebhookLogs WHERE CreatedDate < @CutoffDate; |
__EFMigrationsHistory | Tracks the migration history of Entity Framework schema changes. | FALSE |