Changes

Jump to: navigation, search

Data Dictionary

45 bytes removed, 13:49, 16 April 2018
no edit summary
{{Under construction Warning | There has been some progress Depending on if a database is originally created with 5.x or 6.0 there are differences in Foreign keys' '''CASCADE on delete'''.}} {{Note | The length of the fields may vary between databases that are migrated from [[Table differences between migrated and non-migrated databases | Legacy databases and the databases]] 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 is about 50% donehas two different user groups:* non-technical users* administrators.}}
The There are fields that are shown in the DIM that are of the type calculated fields and they are therefore not included in the Data Dictionary has two user groups. Examples are:* non-technical usersCalculated area, * administratorsLast updated date and * Linked IDs. and has The structure is following the layout of the ambition to cover both user groupsData Inventory Manager. The {{IMSMANG}} version 6.0 database contains '''205''' needstables but not all of them are described here. Contact your [[Information Management Team | GICHD IM advisor]] if you have questions about tables.
The {{IMSMANG}} database consists of three main groups of tables:* Items** Approved information amaXML schema is described [[XML Documentation | here]].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
* 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.}}
{{NavBox Data Dictionary}}
[[Category:NAA]]
Alnaucler
NoPublic, bureaucrat, administrator
6,632
edits
Retrieved from "http://mwiki.gichd.org:8090/IM/Special:MobileDiff/21116...24005"

Navigation menu