Other data model best practices

The following are additional recommendations when extending the data model:

• Always add an informative description for all new entities, properties, typelists, and typecodes.
• Use the defined text data types (for example, shorttext, mediumtext, and longtext) instead of varchar. You may choose to use varchar if a fixed width is known from or required by an external system.