Difference between revisions of "Data Dictionary"
From IMSMA Wiki
| Line 21: | Line 21: | ||
* Date | * Date | ||
* Integer | * Integer | ||
| − | * Multi-select (are stored in a separate table ''xx_has_imsmaenum'' and 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) | ||
* Single-select (use the look-up table ''imsmaenum'') | * Single-select (use the look-up table ''imsmaenum'') | ||
Revision as of 18:57, 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
- Date
- Integer
- Multi-select (are stored in a separate table xx_has_imsmaenum. and use the look-up table imsmaenum)
- Numeric (may have decimals)
- Single-select (use the look-up table imsmaenum)
- String (have maximum length)
- Text (no maximum length)
