Module Design
1. KodeFlex Introduction
1.1 About KodeFlex
2. Installing KodeFlex
2.1 Windows One-Click Installer
2.2 Linux One-Click Installer
2.3 Installing ZAI Service
2.4 Installing from the Source Package (All Operating Systems)
3. Upgrading KodeFlex
4. Platform
4.1. Application Management
4.1.1 Create an Application
4.1.2 Maintenance Application
4.2. Module Design
4.2.1 About the Module
4.2.2 Main Table Design
4.2.3 Sub-table Design
4.2.4 Action Design
4.2.5 Label Design
4.2.6 More Settings
4.2.7 Release Deactivated Modules
4.3. AI Features
4.3.1 Intelligent Conversation
4.3.2 Agent
4.3.3 Skill
4.3.4 Model List
4.4. Application Instance Management
4.4.1 Maintenance Instance
4.4.2 Navigation Menu
4.4.3 Data Source
4.4.4 Validation Rules
4.4.5 Approval Process
4.5. User
4.5.1 Maintain Users
4.5.2 Maintenance Department
4.6. Permissions
4.6.1 Maintenance Permissions
4.7. System
4.7.1 Company
4.7.2 Backup
4.7.3 Authorization Information
4.7.4 Safety
4.7.5 Timing
4.7.6 Time zone
4.7.7 LDAP
5. Business Applications
5.1 Access Applications
5.2. Backend
5.2.1 Personnel Management
5.2.2 Access Management

Main Table Design

2026-06-23 15:02:18
liujinyuan
320
Last edited by haoyonghong on 2026-09-01 16:38:42
Share links

Main Table Design

When adding a new module, the system automatically creates the corresponding main database table for that process. The main table includes some built-in system fields by default, which cannot be deleted. 

Designers can add new fields according to business needs.


Set different colors for different field values:

When designing master tables and sub-tables, designers can assign different colors to different field values. 


For example, colors can be used to highlight important information such as status and category, helping users identify key business data more quickly and improving the efficiency of information browsing.

The common control types as follows:


  • Decimal, Integer: Used for entering numeric data.
  • Date, Time: Date controls are used to select year, month, and day; time controls support selecting hours, minutes, and seconds in addition to date.
  • Attachments: Fields used for uploading files.
  • Formulas: Used to automatically calculate values based on a set formula; fields involved in the calculation usually need to be numeric.
  • Single-choice dropdown, multi-choice dropdown, radio button, checkbox: Requires data source configuration. Data sources can be customized, public data sources, system users, system departments, custom SQL, pre-processes, category settings, etc.

Data source descriptions are as follows:

  • System Users, System Departments: Call existing user and department data from the system.
  • Custom: Key-value pairs maintained by the designer; for example, status can be set to "Pending Approval," "Approved," "Rejected," etc.
  • Previous Process: When the current process is used as a subsequent process, the preceding process can be used as the data source for the foreign key field.
  • Category Settings: Used to maintain categorized data, and can also add common category data sources in the common data source.

Field Default Values and Validation Rules:

Fields can also have default values and validation rules set. Validation rules can be selected from those configured in "Module - Validation Rules".

Note: Built-in system fields do not support editing or deletion.

Write a Comment
Comment will be posted after it is reviewed.