characters in a database name. For example, you can name a temporary library as tmp_crm or a test library as test_crm. 4.11.2.1.3 Table naming convention • Use the same prefix for tables of the same business of the table for a better understanding. For example: • Temporary table: tmp_t_crm_relation_0425 • Backup table: bak_t_crm_relation_20170425 • Temporary table of business operations: tmp_st_{business code}_{creator code}_{creator �→ abbreviation}_{date} • Record table of accounts period: t_crm_ec_record_YYYY{MM}{dd} • Create separate databases for tables of different business modules and add annotations accordingly

characters in a database name. For example, you can name a temporary library as tmp_crm or a test library as test_crm. 4.11.2.1.3 Table naming convention • Use the same prefix for tables of the same business of the table for a better understanding. For example: • Temporary table: tmp_t_crm_relation_0425 • Backup table: bak_t_crm_relation_20170425 • Temporary table of business operations: tmp_st_{business code}_{creator code}_{creator �→ abbreviation}_{date} • Record table of accounts period: t_crm_ec_record_YYYY{MM}{dd} • Create separate databases for tables of different business modules and add annotations accordingly

个字符。如：临时库 (tmp_crm)、测试库 (test_crm) 。 4.11.2.1.3 表命名规范 • 同一业务或者模块的表尽可能使用相同的前缀，表名称尽可能表达含义。 • 多个单词以下划线分隔，不推荐超过 32 个字符。 • 建议对表的用途进行注释说明，以便于统一认识。如： – 临时表（tmp_t_crm_relation_0425） – 备份表（bak_t_crm_relation_20170425） 20170425） – 业务运营临时统计表（tmp_st_{business code}_{creator abbreviation}_{date}） – 账期归档表（t_crm_ec_record_YYYY{MM}{dd}） • 不同业务模块的表单独建立 DATABASE，并增加相应注释。 4.11.2.1.4 字段命名规范 • 字段命名需要表示其实际含义的英文单词或简写。 • 建议各表之间相同意义的字段应同名。

characters in a database name. For example, you can name a temporary library as tmp_crm or a test library as test_crm. 4.11.2.1.3 Table naming convention • Use the same prefix for tables of the same business of the table for a better understanding. For example: • Temporary table: tmp_t_crm_relation_0425 • Backup table: bak_t_crm_relation_20170425 • Temporary table of business operations: tmp_st_{business code}_{creator code}_{creator �→ abbreviation}_{date} • Record table of accounts period: t_crm_ec_record_YYYY{MM}{dd} • Create separate databases for tables of different business modules and add annotations accordingly

characters in a database name. For example, you can name a temporary library as tmp_crm or a test library as test_crm. 4.11.2.1.3 Table naming convention • Use the same prefix for tables of the same business of the table for a better understanding. For example: • Temporary table: tmp_t_crm_relation_0425 • Backup table: bak_t_crm_relation_20170425 • Temporary table of business operations: tmp_st_{business code}_{creator code}_{creator �→ abbreviation}_{date} • Record table of accounts period: t_crm_ec_record_YYYY{MM}{dd} • Create separate databases for tables of different business modules and add annotations accordingly

characters in a database name. For example, you can name a temporary library as tmp_crm or a test library as test_crm. 4.11.2.1.3 Table naming convention • Use the same prefix for tables of the same business of the table for a better understanding. For example: • Temporary table: tmp_t_crm_relation_0425 • Backup table: bak_t_crm_relation_20170425 • Temporary table of business operations: tmp_st_{business code}_{creator code}_{creator �→ abbreviation}_{date} • Record table of accounts period: t_crm_ec_record_YYYY{MM}{dd} • Create separate databases for tables of different business modules and add annotations accordingly

个字符。如：临时库 (tmp_crm)、测试库 (test_crm)。 4.11.2.1.3 表命名规范 • 同一业务或者模块的表尽可能使用相同的前缀，表名称尽可能表达含义。 • 多个单词以下划线分隔，不推荐超过 32 个字符。 • 建议对表的用途进行注释说明，以便于统一认识。如： – 临时表（tmp_t_crm_relation_0425） – 备份表（bak_t_crm_relation_20170425） 20170425） – 业务运营临时统计表（tmp_st_{business code}_{creator abbreviation}_{date}） – 账期归档表（t_crm_ec_record_YYYY{MM}{dd}） • 不同业务模块的表单独建立 DATABASE，并增加相应注释。 4.11.2.1.4 字段命名规范 • 字段命名需要表示其实际含义的英文单词或简写。 • 建议各表之间相同意义的字段应同名。

characters in a database name. For example, you can name a temporary library as tmp_crm or a test library as test_crm. 4.11.2.1.3 Table naming convention • Use the same prefix for tables of the same business of the table for a better understanding. For example: • Temporary table: tmp_t_crm_relation_0425 • Backup table: bak_t_crm_relation_20170425 • Temporary table of business operations: tmp_st_{business code}_{creator code}_{creator �→ abbreviation}_{date} • Record table of accounts period: t_crm_ec_record_YYYY{MM}{dd} • Create separate databases for tables of different business modules and add annotations accordingly

个字符。如：临时库 (tmp_crm)、测试库 (test_crm)。 4.11.2.1.3 表命名规范 • 同一业务或者模块的表尽可能使用相同的前缀，表名称尽可能表达含义。 • 多个单词以下划线分隔，不推荐超过 32 个字符。 • 建议对表的用途进行注释说明，以便于统一认识。如： – 临时表（tmp_t_crm_relation_0425） – 备份表（bak_t_crm_relation_20170425） 20170425） – 业务运营临时统计表（tmp_st_{business code}_{creator abbreviation}_{date}） – 账期归档表（t_crm_ec_record_YYYY{MM}{dd}） • 不同业务模块的表单独建立 DATABASE，并增加相应注释。 4.11.2.1.4 字段命名规范 • 字段命名需要表示其实际含义的英文单词或简写。 • 建议各表之间相同意义的字段应同名。

characters in a database name. For example, you can name a temporary library as tmp_crm or a test library as test_crm. 4.11.2.1.3 Table naming convention • Use the same prefix for tables of the same business of the table for a better understanding. For example: • Temporary table: tmp_t_crm_relation_0425 • Backup table: bak_t_crm_relation_20170425 • Temporary table of business operations: tmp_st_{business code}_{creator code}_{creator �→ abbreviation}_{date} • Record table of accounts period: t_crm_ec_record_YYYY{MM}{dd} • Create separate databases for tables of different business modules and add annotations accordingly