> ## Documentation Index > Fetch the complete documentation index at: https://help.dingtalk.io/llms.txt > Use this file to discover all available pages before exploring further. # Database Table Schema Dictionary > Configuration guide for the YiDA platform's dedicated database, including the detailed schema and field definitions of the odin_open_application_data table. This table stores form instance data and supports business growth and technical iteration. > 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: ```text theme={"theme":{"light":"github-light","dark":"github-dark"}} 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: ```text theme={"theme":{"light":"github-light","dark":"github-dark"}} 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: ```text theme={"theme":{"light":"github-light","dark":"github-dark"}} 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).