Difference between revisions of "Data Dictionary"
From IMSMA Wiki
| Line 1: | Line 1: | ||
| − | {{ | + | {{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.}} |
| − | + | {{Note | [''italic''] will highlight something technical such as {{IMSMANG}} database table name.}} | |
The Data Dictionary has two user groups: | The Data Dictionary has two user groups: | ||
* non-technical users | * non-technical users | ||
| Line 6: | Line 6: | ||
and has the ambition to cover both user groups' needs. | and has the ambition to cover both user groups' needs. | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
The data type used are | The data type used are | ||
| − | * Country structure | + | <div style="column-count:2;-moz-column-count:2;-webkit-column-count:2"> |
| + | * Boolean | ||
| + | * Double | ||
| + | * ''Country structure'' | ||
* Date | * Date | ||
* Integer | * Integer | ||
| − | * Multi-select (are stored in a separate table ''xx_has_imsmaenum'' | + | * Multi-select (are stored in a separate table ''xx_has_imsmaenum'' and use the look-up table ''imsmaenum'') |
* Numeric (may have decimals) | * Numeric (may have decimals) | ||
| − | * Organisation | + | * ''Organisation'' |
| − | * Place | + | * ''Place'' |
* Single-select (use the look-up table ''imsmaenum'') | * Single-select (use the look-up table ''imsmaenum'') | ||
* String (have maximum length) | * String (have maximum length) | ||
* Text (no maximum length) | * Text (no maximum length) | ||
| − | + | </div> | |
{{NavBox Data Dictionary}} | {{NavBox Data Dictionary}} | ||
[[Category:NAA]] | [[Category:NAA]] | ||
Revision as of 20:21, 16 March 2016
 |
The length of the fields may vary between migrated from Legacy databases and databases that were created with IMSMANG of version 5 or newer. |
 |
[italic] will highlight something technical such as IMSMANG database table name. |
The Data Dictionary has two user groups:
- non-technical users
- administrators
and has the ambition to cover both user groups' needs.
The data type used are
- 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)
