Skip to main content

Data Model Documentation

Introduction: Data Model Introduction

Staging Capabilities​

The data model has differences between staging environment and production environment. There is isolation.

After publishing the model, all model fields take effect in the production environment. The production environment has a certain cache duration. Note that system fields only take effect in the production environment.

Data Model Fields​

Text​

PropertyDescription
Basic Typestring
Stored Valueany string/null

Boolean​

PropertyDescription
Basic Typeboolean
Stored Valueany boolean/null

Numeric​

PropertyDescription
Basic Typenumber
Stored Valueany number/null

Array​

PropertyDescription
Basic Typearray

Child Element Type​

Other Elements

Object​

PropertyDescription
Basic Typeobject

Child Element Type​

Other Elements

Email​

PropertyDescription
Basic Typestring
Stored Valueany string/null

Phone​

PropertyDescription
Basic Typestring
Stored Valueany string/null

URL​

PropertyDescription
Basic Typestring
Stored Valueany string/null

Image​

PropertyDescription
Basic Typestring
Stored Valueany string/null

Rich Text​

PropertyDescription
Basic Typestring
Stored Valueany string/null

Date and Time​

PropertyDescription
Basic Typenumber
Stored Valueany number/null

Enum​

PropertyDescription
Basic Typestring
Stored Valueany string/null

Geolocation​

PropertyDescription
Basic Typeobject
Stored Valuecomplex object

File​

PropertyDescription
Basic Typestring
Stored Valueany string/null

Auto Numbering​

PropertyDescription
Basic Typestring
Stored Valueany string/null

Region​

PropertyDescription
Basic Typestring
Stored Valueany string/null

Calculation Formula​

PropertyDescription
Basic Typestring
Stored Valueany string/null

Primary and Sub-account Details​

PropertyDescription
Basic Typestring
Stored Valueany string/null

Relationship​

PropertyDescription
Basic Typestring
Stored Valueany string/null

Relationship Details​

In the context of master-detail relationships and associations, both are essentially many-to-one relationships, differing only in the strength of the binding.

Currently commonly referred to as old associations.

enter image description here

New Relationship​

For the Mysql environment, new many-to-one, one-to-many, and many-to-many relationships have been created, offering more complex association query capabilities.

enter image description here