Data Dictionary

Revision as of 19:41, 27 January 2016 by Alnaucler (talk | contribs)
Ambox warning blue construction.png 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
Note.jpg [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)