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