Difference between revisions of "Data Dictionary"
From IMSMA Wiki
| Line 19: | Line 19: | ||
{{Note | [''italic''] will highlight something technical such as {{IMSMANG}} database table name.}} | {{Note | [''italic''] will highlight something technical such as {{IMSMANG}} database table name.}} | ||
The data type used are | The data type used are | ||
| + | * Country structure | ||
* Date | * Date | ||
* Integer | * Integer | ||
* Multi-select (are stored in a separate table ''xx_has_imsmaenum''. and use the look-up table ''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 | ||
| + | * 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) | ||
Revision as of 19:41, 27 January 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)
