Changes

Jump to: navigation, search

Data Dictionary

339 bytes removed, 21:21, 16 March 2016
no edit summary
{{Under construction Warning| There has been some progress The length of the fields may vary between migrated from Legacy databases and the Data Dictionary is about 50% donedatabases that were created with {{IMSMANG}} of version 5 or newer.}}{{Note | [''italic''] will highlight something technical such as {{IMSMANG}} database table name.}}
The Data Dictionary has two user groups:
* non-technical users
and has the ambition to cover both user groups' needs.
The {{IMSMANG}} database consists of three main groups of tables:
* Items
** Approved information a.k.a. Item / Summary / CV tables
** Data Entry Forms a.k.a. infoversion tables
** Tables that belongs to both groups
* Task and Auxiliary Data
* Miscellaneous tables
** Data Inventory Manager and templates tables
** Migration tables
** System tables
 
{{Note | [''italic''] will highlight something technical such as {{IMSMANG}} database table name.}}
The data type used are
<div style="column-count:2;-moz-column-count:2;-webkit-column-count:2">* Boolean* Double* ''Country structure''
* Date
* Integer
* Multi-select (are stored in a separate table ''xx_has_imsmaenum''. and use the look-up table ''imsmaenum'')
* Numeric (may have decimals)
* ''Organisation''* ''Place''
* Single-select (use the look-up table ''imsmaenum'')
* String (have maximum length)
* Text (no maximum length)
{{Warning| The length of the fields may vary between migrated from Legacy databases and databases that were created with {{IMSMANG}} of version 5 or newer.}} </div>
{{NavBox Data Dictionary}}
[[Category:NAA]]
6,632
edits

Navigation menu