Data Dictionary
From IMSMA Wiki
 |
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)
