Core Tables

Design and implementation details for the core tables used by DAS-RSS

Table – ActiveSessions
Purpose Tracks which users currently have active sessions within the framework. Every time the user interacts with the framework, the...
Table – ConfigLists
Purpose Used to cache exploded configuration lists used by the Dynamic Page Builder. Configuration Lists are created within Functionality maintained...
Table – DeepXML
Purpose This table is used to cache exploded XML fragments for Instance records that are often used but rarely change....
Table – Dictionary
Purpose Used to maintain a list of words, or phrases, used by String Dictionary fields rendered by the Dynamic Page...
Table – EventLog
Purpose Used to track events raised during execution of the framework. The client devices will log events through the core...
Table – FailedLogins
Purpose Tracks failed attempts to sign in to Stand Alone authentication with an invalid combination of username and password Definition...
Table – InstanceAccess
Purpose To maintain row-level access control on records in the Instances table. Definition Column Definitions The InstanceGUID identifies the records...
Table – InstanceChanges
Purpose This table is used to queue updates to Instance records for bulk transport to other data stores. It implements...
Table – InstanceEvents
Purpose Tracks errors, or warnings, that occur as commands are executed on a specific instance record. This functionality is designed...
Table – InstanceHistory
Purpose Store all versions of all records maintained by the DAS-RSS database. This table is updated when new record versions...