You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 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).

Tables

This table group store information about the table structure of the system.

Fields


System Properties

ACL

Applications

Schedules

Business Logic Layer

Scripts

Business Rules

Clients Scripts

Notifications

UI Actions

Events

Workflows

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

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

  • No labels