Difference between revisions of "Data Dictionary"

Revision as of 17:56, 27 January 2016

The Data Dictionary has two user groups:

and has the ambition to cover both user groups' needs.

The IMSMA^NG 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 IMSMA^NG database table name.

The data type used are

Date
Integer
Multi-select (are stored in a separate table xx_has_imsmaenum and 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)

@@ Line 5: / Line 5: @@
 * administrators
 and has the ambition to cover both user groups' needs.
-{{Note | [''italic''] will highlight something technical such as {{IMSMANG}} database table name.}}
 The {{IMSMANG}} database consists of three main groups of tables:
@@ Line 19: / Line 17: @@
 ** System tables
+{{Note | [''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 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)
 {{NavBox Data Dictionary}}
 [[Category:NAA]]