==== PHP-file defined constants ====

=== color theme grid area / color theme admin pages ===
  * ''VEGA'' - blue
  * ''VULCAN'' - red/pink
  * ''SANDSTORM'' - yellow/brown
  * ''MOSS'' - green
  * ''SALVA'' - gray
\\
=== connection database type ===
  * ''DB_TYPE_OCI805'' - Oracle native interface
  * ''DB_TYPE_ODBC_MSSQL'' - Microsoft SQL Server via ODBC
  * ''DB_TYPE_MSSQL'' - Microsoft SQL Server native interface
  * ''DB_TYPE_ODBC_TERADATA'' - Teradata via ODBC
  * ''DB_TYPE_MYSQLI'' - MySQL server native interface
\\
=== connection type ===
  * ''CONN_TYPE_DATABASE'' - database
  * ''CONN_TYPE_WEBSERVICE'' - webservice
\\
=== default pagesize admin / default pagesige grid area ===
  * ''10'' - display 10 rows per page
  * ''20'' - ...
  * ''30'' - ...
  * ''50'' - ...
  * ''100'' - ...
  * ''-1'' - display all rows
\\
=== grid area language ===
  * ''en'' - english
  * ''de'' -- deutsch
\\
=== MS SQL server encoding ===
  * ''SQLSRV_ENC_CHAR'' - 
  Data is returned in 8-bit characters as specified in the code page of the Windows locale that is set on the system. Any multi-byte characters or characters that do not map into this code page are substituted with a single byte question mark (?) character. **This is the default encoding.**
\\  
==== application / database defined constants ====
=== special usergroups ===
  * ''*ALL_GROUP'' - every user in niota is member of this group
  * ''*ALL_ADMIN_GROUP'' - every user with admin option activated is member of this group
  * ''*ALL_NON_ADMIN_GROUP'' - every user without admin option is member of this group 
\\
=== callable object binding ===
  * ''0'' - table level binding
  * ''1'' - line level binding
\\
=== callable object prompt type ===
  * ''0'' - no target page/no prompt page
  * ''1'' - file upload prompt page is displayed
\\
=== callable object type ===
  * ''0'' - stored procedure
  * ''1'' - sql statement
  * ''2'' - batch command
  * ''3'' - web service call
\\
=== catalogobject configuration parameter ===
  * ''max_number_validation_err'' - overwrites system value ''MAXNUMBER_VALIDATIONERR'' on catalogobject level 
  * ''max_number_validation_msg'' - overwrites system value ''MAXNUMBER_VALIDATIONMSG'' on catalogobject level 
  * ''max_number_validation_row'' - overwrites system value ''MAXNUMBER_VALIDATIONROW'' on catalogobject level   
\\
See [[niota-docs:niota_system_config_defaults|default settings]] for further details.

=== column / constraint-operation data type ===
  * ''D'' - date
  * ''T'' - datetime
  * ''N'' - numeric
  * ''C'' - textual
\\
=== connection type ===
  * ''0'' - database connection
  * ''1'' - web service connection
\\
=== table link type ===
  * ''0'' - tables are linked in a master-detail relation
  * ''1'' - tables are linke as advanced filter relation
\\
=== operations for constraints/ master detail / advanced filter ===
  * ''0'' - no operation - used for advanced filter feature so set defaults from filter instance to filtered instance
  * ''1'' - equals
  * ''2'' - not equals
  * ''3'' - greater than
  * ''4'' - less than
  * ''5'' - greater than or equal to
  * ''6'' - less than or equal to
  * ''7'' - between
  * ''8'' - not between
  * ''9'' - like
  * ''10'' - not like
  * ''11'' - starts with
  * ''12'' - starts not with
  * ''13'' - ends with
  * ''14'' - ends not with
\\
=== transaction target page ===
  * ''niota.php'' - for table loading
  * ''execute_callable.php'' - to execute callable objects
\\
=== transaction parameters ===
  * ''popup_filter'' - define popup filter 
  * ''selected_instance'' - loads a catalog object instance
  * ''callable_object'' - runs a callable object
  * ''filter instance'' - popup filter catalog-object-instance
\\
=== usergroup types ===
  * ''1'' - self group - has only user as it's implicit member
  * ''2'' - custom group - may have more then on user as member
\\

=== color codes ===
System values, cannot be overwritten.
^vega		^sandstorm	^vulcan		^moss		^salva          ^									
|light		|#B8DDE1	|#F1E6B2	|#FCC89B	|#C2E189	|#d0d3d4
|mid		|#9BD3DD	|#DFD1A7	|#FDBE87	|#B7DD79	|#c1c6c8
|dark		|#77C5D5	|#D9C89C	|#FDAA63	|#A4D65E	|#a2aaad
|dark(rgb)	|119,197,213	|217,200,156	|253,170,99	|164,214,94	|162,170,173