Changes

Data Dictionary

339 bytes removed, 20: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]]

• ← Older edit
• Newer edit →

Alnaucler

NoPublic, bureaucrat, administrator

6,632

edits