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 |
Table Relationships
