niota

fascinating. logical.

User Tools

Site Tools


niota-docs:niota_metadb_conventions

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
niota-docs:niota_metadb_conventions [2024/09/13 10:17]
admin
niota-docs:niota_metadb_conventions [2025/07/17 14:11] (current)
Line 9: Line 9:
  
 === Columns === === Columns ===
-Column names in metadatabase tables are build by internal logic. The first part of the column name carries information about it's logical/​business meaning, the second part of the column name tells something about it's specific usage.+Column names in metadatabase tables are built by an internal logic. The first part of the column name carries information about it's logical/​business meaning, the second part of the column name tells something about it's specific usage.
  
 The "​business"​ meaning can for example be: The "​business"​ meaning can for example be:
Line 19: Line 19:
   * description of something   * description of something
   * username of something   * username of something
 +  * sortorder of something
  
  
 The specific usage is then fixed be the second part. The specific usage is then fixed be the second part.
  
-There a column that contains a connection name for logging is build by +Therefor ​a column that contains a connection name for logging is build by 
  
-conn_name ​..... the overall info that the content will by a name of a connection +**conn_name** ... the overall info that the content will by a name of a connection\\ 
-++\\ 
-logging ... for what this connection name will be used.+**logging** ... for what this connection name will be used (or log or logged).
  
-The type of the column must be the same as for the "​master domain"​ for connection name.+The type of the column must be the same as for the "​master domain"​ for connection name. The type can be found in the table et_**connection**.
  
 result: result:
niota-docs/niota_metadb_conventions.1726215428.txt.gz · Last modified: 2025/07/17 14:11 (external edit)