You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 14 Next »
Preface
On the low-level, SimpleOne is a big relational database that has an interface to manage this database.
The database consists of the tables and columns interconnected in many ways.
Tables are divided into two sets: system tables and functional tables.
The system tables are used for business logic implementation. They store the inner mechanisms placed there by administrators of the system.
Most of them are write-protected to prevent system disruption.
The purpose of functional tables is to store the data models used in the business logic implementation.
System Tables
System tables, in turn, are divided into several groups, called "layers". In these layers, tables are grouped functionally.
Structure layer
On this layer, the tables keep information about the system structure (tables relationships and dependencies, fields relationships, access rights allocation, and so on).
Tables
This table group contains information about the table structure of the system.
Fields
This table group contains information about the fields structure in the tables.
System Properties
This table group contains specific parameters reliable for the system behavior as a whole, or for the specified modules, for example, the system locale or the timezone,
ACL group
This table group contains information about access control lists (ACLs). Particularly, the structure of roles and groups is specified.
Applications
This is the dictionary of the applications implemented on the SimpleOne base and installed on the current instance. All the dependencies and components constituting the application are stored here.
Schedules group
This table group contains information about the system schedules needed for different tasks related to the
Business Logic Layer
Scripts
This table group contains information about the scripts, how they interact with the tables, and how it realizes the business logic.
Business Rules
This table group contains information about the business rules.
Clients Scripts
This table group contains information about the client-side scripts, and how they interact within the system.
Notifications
In there, all necessary information about notifications can be found.
UI Actions group
This table group contains information about UI actions.
Events group
This table group contains information about Events.
Workflows
This table group contains information about workflows and state models,
URL Actions group
This table group contains information about URL actions.
Interface and Navigation Layer
Navigator
This table group contains information about the Navigator, that is located on the left. Information about the categories and items is stored.
Forms
This table group contains information about the forms and lists, their configuration and position on the page.
Layouts
This table contains information about the form layouts.
Portals
This table contains information about the end-user and agent portals.
Widgets
This table group contains information about different widgets (for example, comments widget).
Dashboards
This table group contains information about the dashboards.
Interaction Layer
Logs
Emails
Attachments
Imports
API group
This big group contains the server-side, the client-side and the REST SimpleOne API.
Functional Tables
Functional tables are also divided into layers. In these layers, they are also grouped functionally.
MasterData Layer
Tasks
Approvals
This table group
Events group
Timesheets
Costs
Record Storage Layer
On this layer, the purpose of the table groups is to store records for further processing following the established business logic,
CMDB
CMDB is the Configuration Management Database, this is the ITIL term. So this table group contains configurations of IT-services.
Assets
This table group
Knowledge Base
Contracts
Business Logic Layer
Request Templates
Data Lookup Definition
Indicators
Reports
State Models
Assignment Rules
- No labels