The table `itgen_context_settings` holds: settings for a user.
Example: The user 'system' uses the english edition.
It keeps history. Its natural key code is `csg`.
## Columns
The table has these columns, besides the [[Invantive Studio/Repository/Concepts/Standard Columns|standard columns]]:
- `ale_id` (`number`, required): Application Language ID. Reference to an application language registered in ITGEN_APN_LANGUAGES.
- `consecutive_failed_logons` (`number`, required): Number of Consecutive Failed Logons. Number of consecutive failed logons.
- `date_first_logon` (`datetime`): Date First Logon. Date of first logon of this user.
- `date_last_failed_logon` (`datetime`): Date Last Failed Logon. Date of last failed logon of this user.
- `date_last_logon` (`datetime`): Date Last Logon. Date of last successfull logon of this user.
- `date_reporting` (`datetime`): Date Reporting. Date for which point-in-time views should return the results.
- `usr_id` (`number`, required): Context Setting. Reference to a user registered in ITGEN_USERS.
- `column1` to `column10` and `column_type`: free text columns to extend the data model with fields only available at one site.
## Referential Constraints
The table is related to other tables as follows:
- `ale_id` refers to Application Languages (`id`).
- `usr_id` refers to Users (`id`).
## Indexes
The table has these indexes:
- `itgen_csg_ale_fk` on `ale_id`.
- `itgen_csg_nk` (unique) on `usr_id`.
- `itgen_csg_pk` (unique) on `id`.
- `itgen_csg_uk_orig` (unique) on `orig_system_reference`.
See also [[Invantive Studio/Repository/Reference/Tables of the Repository|Tables of the Repository]].