In a project application, the catalog.4Dcatalog is an XML file that stores the information of all tables and fields for the database structure. Each field node has an attribute called “type” that corresponds to the type of the field (Text, Date, etc.). The value of “type” does not explicitly state the name of the field type. Instead, the field type is indicated by a “number” (in quotes because the value is actually a string) in the XML. Below is a reference table that maps the “number” to actual field type:



This could be useful, for example, when manually reviewing catalog.4dCatalog during a git merge conflict. Note that Alpha and Text field types are both 10. The difference is that alpha fields have another attribute called “limiting_length” set to “255”.