Data Dictionary

From IMSMA Wiki
Revision as of 20:21, 16 March 2016 by Alnaucler (talk | contribs)
Jump to: navigation, search
Warning.jpg The length of the fields may vary between migrated from Legacy databases and databases that were created with IMSMANG of version 5 or newer.
Note.jpg [italic] will highlight something technical such as IMSMANG database table name.

The Data Dictionary has two user groups:

  • non-technical users
  • administrators

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

The data type used are

  • Boolean
  • Double
  • 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)