question: About how to use database data about apitable HOT 5 CLOSED

DatasheetRecordVo.java The data type is JSONObject, and the underlying implementation is Map<String,Object>

@Schema(description = "Data recorded in one row (corresponding to each field)")
private JSONObject data;

JsonHandler.java Write about the mapping processing of JSONObject

@MappedTypes(JSONObject.class)
@MappedJdbcTypes(JdbcType.VARCHAR)
public class JsonHandler extends BaseTypeHandler<JSONObject> 

DatasheetRecordMapper.xml There was a mention of data

<sql id="RecordVo_Column_List">
        record_id, `data` as data, revision_history, revision, field_updated_info as recordMeta
    </sql>

<select id="selectListByDstId" resultMap="datasheetRecordVo">
    select  <include refid="RecordVo_Column_List"/> from ${tablePrefix}datasheet_record
    where dst_id = #{dstId} and is_deleted = 0
</select>

datasheet-record-data.sql json is embodied in sql statements

INSERT INTO `datasheet_record` 
(`id`, `record_id`, `dst_id`, `data`,
`revision_history`, `revision`,
`field_updated_info`, `is_deleted`)
VALUES 
(0, 'rec5TDJ5dfewH', 'dst0ZDEBxQPJxoaQ1h', '{}', 
'13', 13,
'{\"createdAt\": 1595922741000}', 0);

from apitable.

Record data is stored in the database apitable_datasheet_record, and the data format is json.

from apitable.

what is recode? @Nonomi514

from apitable.

what is recode? @Nonomi514

Sorry,it should is record

from apitable.

Thanks to both of you, I know the answer to this question

from apitable.