Page History

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 stores information about the table structure of the system. 

Fields

This table group stores 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 stores 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 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 notification 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

Forms

Layouts

Portals

Widgets

Dashboards

Interaction Layer

Logs

Emails

Attachments

Imports

API

Functional Tables

MasterData Layer

Tasks

Approvals

This table group 

Events

Timesheets

Costs

Record Storage Layer

CMDB

Assets

Knowledge Base

Contracts

Business Logic Layer

Request Templates

Data Lookup Definition

Indicators

Reports

State Models

Assignment Rules