System Structure

Smart design of solution

The main benefit of this solution is its modern and smart design, which makes everything very simple, easy to use, and highly effective in real usage for solving problem. This solution is structured from several important parts that work together smoothly.

1. Main app pages
2. Components
3. Component items
4. Cell content
5. Frame content
6. Operator content

Each part of the solution has its own role and purpose and communicates with other parts to work as a whole database.

Main app pages

This solution consists of two main app pages that manage everything within the database app. They are very simple, efficient, and easy to learn, offering many useful options for quick and effective use.

1. Home page ( home hub )
2. Component page ( component loader )

The home page or home hub, is the main page of the entire application. This is where you manage your account options and all critical data, including components and other important parts of your database.

The Component page or component loader, is the page where you load and manage all data from your components. It displays all items, each containing specific content type and related data.

It's worth noting that member accounts won't have the same options as the main account.

Components

Components are the main subunits of the entire database solution. They contain items, which hold specific data and content. Therefore, components serve as the primary data points. Currently, there are three types of components in this solution.

1. Cell component ( For storing, editing, and managing data )
2. Frame component ( For analyzing and visualizing data )
3. Operator component ( For performing functions and operations on data )

Component items

An item is an integral part of a component, tasked with storing all essential data, associated functions, and other relevant elements within its own structure. While operating independently in terms of managing its contents, the item remains closely linked to its parent component, ensuring seamless interaction and consistent organization within the overall system.

Just like components, items also have types. Each item's type corresponds to the type of the component it belongs to.

To enhance control and security, we have added role-based access within each item, allowing better management of member permissions and ensuring that only authorized users can access or modify specific parts.

1. Viewer role ( Only allowed to view data within the item and is attached as viewer member )
2. Editor role ( Can perform basic editing actions inside the item and is attached as basic editor )
3. Master role ( Has extended control and is attached as master editor or it is main account )

Cell content

Cell content is specially designed to import, export, edit, and manage data, as well as perform various database-related operations efficiently. It acts as a core unit for handling data within the system. Currently, cells support two different data formats, allowing flexibility depending on the type of data you work with.

1. Table format ( Organized into columns and rows for structured data )
2. Document format ( Composed of modules and entries for flexible data )

This database is highly flexible and supports six different data types. These types are carefully designed to cover a wide range of data needs, allowing you to manage and organize your information effectively.

1. Text type ( Includes characters and letters )
2. Number type ( Includes positive, negative, decimal, and integer numbers )
3. Boolean type ( True/False logic values )
4. Date type ( Stores year, month, day, hours, and minutes )
5. Array type ( Contains multiple values of text, number, or boolean types )
6. Object type ( Contains multiple key-value pairs, where values can be number, boolean, or text )

Frame content

Frame content is a structured layout consisting of three main elements, designed for analyzing and reading data from linked cell item, while also allowing you to add elements to keep everything organized, simple, and efficient.

1. Label elements ( Used as text containers to describe content )
2. Widget elements ( Main data elements that operate in one of two modes: reader or analyzer )
3. Line elements ( Used to separate content, serving as decorative elements )

Widgets are smart and useful elements with many options for analyzing data, as well as several useful features in reader mode.

Operator content

Operator content is a special type of content designed to perform functions on various types of data. It is divided into two sub-operators to ensure compatibility with the two data formats used in this database solution.

Because the database solution supports two data formats, having two types of operators ensures that all operations are handled more easily and efficiently.

1. Table operator ( Performs functions on data in table format )
2. Document operator ( Performs functions on data in document format )