Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 

Tables

This table contains tables keep information about other tables, either system or functional.the system structure (table relationship and dependencies)

Tables


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

Table of Contents
absoluteUrltrue
classfixedPosition