2.1 Overview
In the Informat platform, data tables are a fundamental feature primarily used to complete application model design through table construction. When a data table module is created, a real database table is created in the database, and a frontend display form is automatically generated. Creating or editing in the form directly updates the database information.
Model Design Logic
In Informat, you can design application models by creating data table modules within applications. First, you need to create a data table module and determine the data source type of the table during creation. After completing the table creation, you need to add fields to the table. You can implement one-to-one, one-to-many, and parent-child relationships between tables by adding fields. Finally, you can design the behavior and style of fields in the form as needed.
Naming Conventions for Data Tables and Fields
When creating data table modules and adding fields, you can define identifiers for tables and fields, which will be used for identification in expressions, automations, and scripts. To ensure development standardization, it is recommended to follow a unified naming convention for table and field identifiers. Below is our recommended field identifier naming convention.
English, single word with lowercase first letter, subsequent words with uppercase first letters. Identifiers cannot start with numbers. Examples: name, identityCard
For multi-select type fields, the storage structure will be a list, and you need to suffix the identifier with "List". Example: typeList
For Related Record type fields, suffix the identifier with "Rel". Example: productNameRel
For Related Record Field type fields, it is best to use the same identifier as the referenced field
For Related List type fields, suffix the identifier with "RelList". Example: technologyRelList
For Child Object type fields, suffix the identifier with "Children". Example: subtasksChildren
For Lookup List type fields, suffix the identifier with "Lookup". Example: orderListLookup
For Related List Summary and Lookup Summary type fields, suffix the identifier with "Stat". Example: orderAmountStat
Fields of the same type should use the same identifier
Common identifiers
| Identifier | Field Name | Field Type |
|---|---|---|
| createUser | Creator | User Selection |
| createTime | Creation Time | Date |
| updateUser | Updater | Last Modified By |
| updateTime | Update Time | Last Modified Time |
| enableStatus | Enable Status | Checkbox or Switch |
| remark | Remarks | Multi-line Text |
Common identifiers are a unified naming standard for fields that are used in multiple data tables within an application. They can be refined according to actual needs.