Database Table Schema Dictionary

V1.0 Update time 2024.11

When you configure a dedicated database for dedicated storage, the YiDA platform adds several required tables to it to store the data generated as you use YiDA. The schema of these tables is not fixed — it evolves with business growth and technical iteration, and new fields or tables may be added over time. In general, existing fields will remain unchanged to avoid disrupting your business operations, but the YiDA platform still recommends that you do not build strong dependencies on this data.

Table List

Odin_Open_Application_Data

Table name: odin_open_application_data Description: form instance data table (shared by form and report). Character set: UTF8

Column name	Type	Length	Precision	Scale	Nullable	Default value	Description
id	varchar	128			Y		Unique id; may be empty for historical data — uniqueness is still determined by pid
gmt_create	timestamp				N		Created time
gmt_modified	timestamp				N		Modified time
creator	varchar	64			Y		Created by
modifier	varchar	64			Y		Last modified by
is_deleted	bpchar	1			N	n	Whether deleted
corp_id	varchar	128			Y		Organization id where the instance is inserted
namespace_code	varchar	128			N		App appType
table_name	varchar	128			N		Form model id
pid	varchar	64			N		Instance id
parent_pid	varchar	64			Y		Used in cases such as sub-table association, where the sub-table data is linked to the parent table’s pid through this field
json_data	jsonb				Y		Specific component data, in json
data_version	int8				N	0	Data change version
data_order	int8				N	0	Data display order, typically used for sub-tables
Index name	Type	Included Fields
odin_open_application_data_gmt_modified_idx1	Normal	gmt_modified
odin_open_application_data_namespace_code_creator_idx1	Normal	namespace_code,creator
odin_open_application_data_namespace_code_table_name_gmt_c_idx1	Normal	namespace_code,table_name,gmt_create
odin_open_application_data_namespace_code_table_name_paren_idx1	Normal	namespace_code,table_name,parent_pid,is_deleted
odin_open_application_data_namespace_code_table_name_pid_idx1	Unique	namespace_code,table_name,pid
odin_open_application_data_pid_idx1	Normal	pid

Tianshu_Form_Data_Operation_Log

Table name: tianshu_form_data_operation_log Description: Form data activity log table. Character set: utf8mb4

Column name	Type	Length	Precision	Scale	Nullable	Default value	Description
id	bigint(20) unsigned		20	0	N	Generated via tianshu_form_data_operation_log_id_seq	Primary key
gmt_create	datetime				N		Created time
gmt_modified	datetime				N		Modified time
creator	varchar(64)	64			N		Created by
modifier	varchar(64)	64			N		Last modified by
is_deleted	char(1)	1			N		Whether logically deleted
system_type	varchar(64)	64			N		System type
app_type	varchar(64)	64			N		App key
form_inst_id	varchar(128)	128			N		form instance data id
operation_type	varchar(64)	64			N		Action type
operation_field	varchar(64)	64			N		Action field
pre_value	mediumtext	16777215			Y		Original content
value	mediumtext	16777215			Y		Modified content
shard_key	varchar(130)	130			N		Sharding key
pre_code	mediumtext	16777215			Y		Code corresponding to the original control value
code	mediumtext	16777215			Y		Code corresponding to the control
operation_id	varchar(64)	64			Y		Unique action ID
parent_operation_field	varchar(64)	64			N	ROOT	Parent action field
parent_operation_id	varchar(64)	64			N	ROOT	Parent action id
trigger_src	varchar(4000)	4000			Y		Trigger source description
trigger_type	varchar(4)	4			Y		Trigger source type
Index name	Type	Included Fields
idx_app_type	Normal	app_type
idx_inst_id_parent_operation_field_gmt_modified	Normal	form_inst_id,parent_operation_field,gmt_modified
idx_inst_id_parent_operation_field_parent_operation_id	Normal	form_inst_id,parent_operation_field,parent_operation_id
idx_operation_id	Normal	operation_id
idx_operation_id_is_deleted	Normal	operation_id,is_deleted
idx_opertaion_field_gmt_modified	Normal	operation_field,gmt_modified
idx_parentoperationid_parentoperationfield	Normal	parent_operation_id,parent_operation_field
PRIMARY	Primary	id
uk_inst_id_id	Unique	form_inst_id,id

Tianshu_Proc_Inst_Carbon

Table name: tianshu_proc_inst_carbon Description: workflow instance CC recipient table Character set: utf8mb4

Column name	Type	Length	Precision	Scale	Nullable	Default value	Description
id	bigint(20)		19	0	N	Generated via proc_inst_carbon_id_seq	Primary key
gmt_create	datetime				N		Created time
gmt_modified	datetime				N		Modified time
shard_key	varchar(130)	130			N		Sharding field
system_type	varchar(64)	64			N		System category
app_type	varchar(64)	64			N		App type
form_uuid	varchar(128)	128			N		Form UUID
is_deleted	char(1)	1			N		Delete flag
form_inst_id	varchar(128)	128			N		Instance ID
form_inst_title	varchar(1024)	1024			N		Instance title
carbon	varchar(64)	64			N		CC recipient
activity_id	varchar(128)	128			N		CC node ID
process_code	varchar(128)	128			N		Workflow code
inst_status	varchar(32)	32			N		Instance status
is_printed	char(1)	1			Y		Whether printed
inst_originator	varchar(64)	64			Y		Instance initiator
Index name	Type	Included Fields
idx_carbon	Normal	carbon
idx_carbon_app	Normal	carbon,shard_key,is_deleted
idx_form_inst_id	Normal	form_inst_id
idx_form_uuid_carbon	Normal	form_uuid40,carbon20,is_deleted
idx_inst_originator	Normal	inst_originator
idx_shard_key	Normal	shard_key
PRIMARY	Primary	id

Tianshu_Data_Form_Version

Table name: tianshu_data_form_version Description: Association table between instance data and form version Character set: utf8mb4

Column name	Type	Length	Precision	Scale	Nullable	Default value	Description
id	bigint(20) unsigned		20	0	N	Generated via data_form_version_id_seq	Primary key
gmt_create	datetime				N		Created time
gmt_modified	datetime				N		Modified time
creator	varchar(64)	64			N		Created by
modifier	varchar(64)	64			N		Last modified by
form_uuid	varchar(128)	128			N		Form id
model_uuid	varchar(128)	128			N		Model id
inst_id	varchar(128)	128			N		Instance id
version	bigint(20)		19	0	N		Form version
system_type	varchar(64)	64			N		System version
app_type	varchar(64)	64			N		App ID
shard_key	varchar(130)	130			N		Sharding key
Index name	Type	Included Fields
idx_form_uuid	Normal	form_uuid
idx_inst_id	Normal	inst_id
idx_model_uuid	Normal	model_uuid
idx_shard_key	Normal	shard_key
PRIMARY	Primary	id

Tianshu_Form_Data_Stash

Table name: tianshu_form_data_stash Description: Form cache table Character set: utf8mb4

Column name	Type	Length	Precision	Scale	Nullable	Default value	Description
id	bigint(20) unsigned		20	0	N	Generated via form_data_stash_id_seq	Primary key
gmt_create	datetime				N		Created time
gmt_modified	datetime				N		Modified time
shard_key	varchar(130)	130			N		Sharding key
is_deleted	char(1)	1			N		Delete flag
system_type	varchar(64)	64			N		System identifier
app_type	varchar(64)	64			N		App identifier
form_uuid	varchar(64)	64			N		Form UUID
inst_value	mediumtext	16777215			Y		Form content
creator	varchar(64)	64			N		Created by
modifier	varchar(64)	64			N		Last modified by
Index name	Type	Included Fields
idx_form_creator	Normal	shard_key90,form_uuid,creator
PRIMARY	Primary	id

Tianshu_Form_Remark

Table name: tianshu_form_remark Description: Comments feature Character set: utf8mb4

Column name	Type	Length	Precision	Scale	Nullable	Default value	Description
id	bigint(20) unsigned		20	0	N	Generated via form_remark_id_seq	Primary key
gmt_create	datetime				N		Created time
gmt_modified	datetime				N		Modified time
creator	varchar(64)	64			N		Created by
modifier	varchar(64)	64			N		Last modified by
form_inst_id	varchar(128)	128			N		Instance ID
reply_id	bigint(20) unsigned		20	0	Y		Association ID
content	text	65535			N		Content
files	varchar(3000)	3000			Y		Attachment
reply_user_id	varchar(64)	64			Y		Reply user ID
at_user_id	varchar(640)	640			Y		Mentioned user ID
is_deleted	char(1)	1			N	n	Delete flag
system_type	varchar(64)	64			N		System type
app_type	varchar(64)	64			N		App type
shard_key	varchar(130)	130			N		Sharding key
images	text	65535			Y		Image
Index name	Type	Included Fields
idx_form_inst_id	Normal	form_inst_id
PRIMARY	Primary	id

Alibpms_App_Cm_Operator_Record

Table name: alibpms_app_cm_operator_record Description: workflow instance approval record table Character set: utf8mb4 Notes: Does not include approval tasks that are currently in progress.

Column name	Type	Length	Precision	Scale	Nullable	Default value	Description
id	bigint(20)		19	0	N	Generated via pro_operator_record_id_seq	Primary key id
operator	varchar(64)	64			Y		Actual operator id
operate_time	datetime(3)				Y		Modified time
action	varchar(256)	256			Y		Action description
remark	text	65535			Y		Action alias
process_instance_id	varchar(64)	64			Y		workflow instance ID
activity_setting_id	varchar(64)	64			Y		Node definition ID
task_id	varchar(64)	64			Y		Task ID
step	varchar(256)	256			Y		Action step
visible	varchar(128)	128			Y		Whether visible (true = visible, false = hidden)
app_key	varchar(128)	128			Y		App key
activity_id	varchar(64)	64			Y		Node ID
original_operator	varchar(64)	64			Y		Original operator
agent_operator	varchar(64)	64			Y		Delegated operator
operate_type	varchar(32)	32			Y		Action type
group_id	bigint(20)		19	0	N	1	Integrator isolation
from_mobile	char(1)	1			N	n	Flag indicating whether submitted from mobile approval
files	longtext	4294967295			Y		Flag file field
user_job	varchar(70)	70			Y		User job title flag
is_deleted	char(1)	1			N	n	Delete flag
gmt_modified	datetime				Y		Modified time
modifier	varchar(64)	64			Y		Last modified by
step_en	varchar(256)	256			Y		Action step in English
notice	text	65535			Y		Approval responsibility in Chinese and English
reason	text	65535			Y		Approval reason in Chinese and English
digital_sign	varchar(512)	512			Y		Electronic signature image
target_users	text	65535			Y		Target users; separate multiple users with commas
Index name	Type	Included Fields
idx_activity_id	Normal	app_key,activity_id
idx_process_instance_id	Normal	app_key,process_instance_id,operate_time
idx_task_id	Normal	app_key,task_id
operator	Normal	app_key,operator
original_operator	Normal	app_key,original_operator
PRIMARY	Primary	id

Other Tables

tianshu_instance_relation: form instance relation table — used by the legacy YiDA dedicated storage. Deprecated. yida_entity_instance: form instance data table — used by the legacy YiDA dedicated storage. Deprecated. Many users still depend on it; data is asynchronously synchronized through the odin_open_application_data table. We recommend using the odin_open_application_data table as the source of truth. The following example shows how to add an index on timeout — replace the placeholder values while still using odin_open_application_data as the reference:

CREATE INDEX CONCURRENTLY idx_model_filed_textField_xxxxx ON odin_open_application_data (
        namespace_code,
        table_name,
        is_deleted,
        parent_pid,
        (json_data ->> 'textField_xxxxx')
    ) WHERE namespace_code = 'APP_xxxx' and table_name = 'xxxx';

Alternatively, use the productized interface. Manual index creation is preferred; if you are not sure how, create the index through the product instead. Indexes created through the product may occasionally fall short of optimal efficiency — contact R&D if needed.

For physical column scenarios — for example, when querying the phy_textfield_lmsj0bkf field below:

select count(*) from yida_app_data_form_xxxxx a WHERE ( a.is_deleted = 'n' AND ( a.phy_textfield_lmsj0bkf = 'xxx')) AND ( a.namespace_code = 'xxxx' AND  a.table_name = 'xxx' AND  a.parent_pid IS NULL)

Create a btree index on phy_textfield_lmsj0bkf

CREATE INDEX CONCURRENTLY idx_model_phy_textfield_lmsj0bkf ON yida_app_data_form_xxxxx (
        namespace_code,
        table_name,
        is_deleted,
        parent_pid,
        phy_textfield_lmsj0bkf
)

tianshu_form_data: Form data table — used by the legacy YiDA dedicated storage. Deprecated. ecds_xxxx: YiDA internal system tables — these are internal tables used for system operation. Do not operate on them, and do not manually create them when switching databases; they are generated automatically. yida_app_data_xxx: physical column table — has the same schema as odin_open_application_data, except that the json field is flattened. One table per form, and sub-tables are also independent tables. Details are as follows: The corresponding table name is the underline-lowercase form of the form page code above: yida_app_data_form_obd66r71q2asxubwc9p3g8yneplv2jcv43d6m3 Because database table name length limits must be observed, the sub-table name — which would originally be yida_app_data_form_obd66r71q2asxubwc9p3g8yneplv2jcv43d6m3_tableFieldXxx — is truncated with an md5 hash once it reaches 64 bytes. The final computation result is similar to the following:

String physicalTableName = tableName.substring(0, 63 - tableNameHashPostfix.length()) + tableNameHashPostfix;

tableName is yida_app_data_form_obd66r71q2asxubwc9p3g8yneplv2jcv43d6m3_tableFieldXxx, and tableNameHashPostfix is ”_” + tableNameMd5 (where tableNameMd5 is the md5-encrypted result 8af1899537e0ac902f784162207c0e54).

Getting Started

Quick Start

Form Management

Workflow Design

Report Design

Aggregate Table Design

Portal Design

Custom Pages

Integration & Automation

Cool App

App Management

Platform Management

Internationalization

YiDA Dedicated

Developer Features

Table List

Odin_Open_Application_Data

Tianshu_Form_Data_Operation_Log

Tianshu_Proc_Inst_Carbon

Tianshu_Data_Form_Version

Tianshu_Form_Data_Stash

Tianshu_Form_Remark

Alibpms_App_Cm_Operator_Record

Other Tables

​Table List

​Odin_Open_Application_Data

​Tianshu_Form_Data_Operation_Log

​Tianshu_Proc_Inst_Carbon

​Tianshu_Data_Form_Version

​Tianshu_Form_Data_Stash

​Tianshu_Form_Remark

​Alibpms_App_Cm_Operator_Record

​Other Tables

Table List

Odin_Open_Application_Data

Tianshu_Form_Data_Operation_Log

Tianshu_Proc_Inst_Carbon

Tianshu_Data_Form_Version

Tianshu_Form_Data_Stash

Tianshu_Form_Remark

Alibpms_App_Cm_Operator_Record

Other Tables