# How to Model Customer Objects on a Low-Code Platform
Business model design is the foundation of information system design, involving the definition of database tables, field settings, and relationships between tables. In short, this step determines the data structure and storage method of the system.
Customers are one of the core objects managed by CRM systems. We will first create a customer object with the following attributes:
# Customer Model Definition in CRM System
# Model Name
| Model Description | Description |
|---|---|
| Customers | Customer information, including name, contact information, company name, position, etc. |
# Model Field List
| Field Name | Type | Nullable | Default Value | Options | Remarks |
|---|---|---|---|---|---|
| name | STRING | No | None | None | Customer business key |
| contactInfo | STRING | No | None | None | Contact information |
| companyName | STRING | Yes | None | None | Company name |
| position | STRING | Yes | None | None | Position |
| group | STRING | Yes | None | None | Customer group |
| birthday | LOCAL_DATE | Yes | None | None | Customer birthday |
TIP
The system will automatically create an auto-increment column named id of type
Long as the primary key.
# Creating Models in the Low-Code Platform
# Creating Customer Model and Fields
The operation video is shown below
# Setting Enumeration Values for the Group Field
The group field is used to identify customer group ings. We can set its enumeration values as follows:
| Model Name | Enumeration Field | Option Value | Explanation |
|---|---|---|---|
| Customer Form (Customers) | Group (Customer Group) | VIP | Very important customers |
| Regular Customer | General customers | ||
| Potential Customer | Potential customers who may become actual customers | ||
| Important Customer | Customers who are very important in business | ||
| Blacklist | Customers no longer cooperating with |
In the field definition, you can set optional values for the field. The specific operation is to edit the field and set its options property, as shown in the video below:
Next, we will create corresponding CRUD forms for the created customer model. Please click here to continue.
# Further Reading
Our platform is the LCDP.ai Infinite Code low-code platform, designed to help users quickly build information systems. To learn more about our platform, please visit LCDP.ai (opens new window).