Skip to content

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

Pointr Cloud Database Relations