Difference between revisions of "Data Dictionary"
From IMSMA Wiki
| Line 29: | Line 29: | ||
* String (have maximum length) | * String (have maximum length) | ||
* Text (no 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}} | {{NavBox Data Dictionary}} | ||
[[Category:NAA]] | [[Category:NAA]] | ||
Revision as of 13:50, 10 March 2016
 |
The Data Dictionary is quite an ambitious task and it will take time until more than 1000 fields and 200 tables will be documented |
The Data Dictionary has two user groups:
- non-technical users
- administrators
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
 |
[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)
 |
The length of the fields may vary between migrated from Legacy databases and databases that were created with IMSMANG of version 5 or newer. |
