The table `itgen_users` holds: the directory of users for Invantive Estate. The user 'system' is the user account with access to all application functionality. Example: The user 'system' is registered with it's password. Using this set of credentials, a physical user or a remote system can access the full application functionality. In this sense, it is comparable with the user 'root' on the UNIX platform and the user 'Administrator' on the Microsoft Windows platform. It keeps history. Its natural key code is `usr`. ## Columns The table has these columns, besides the [[Invantive Studio/Repository/Concepts/Standard Columns|standard columns]]: - `code` (`varchar2(240)`, required): Code. Unique alphanumeric code. - `date_password_l_change` (`datetime`, required): Password Last Changed on. Date at which the password was last changed. - `documentation` (`varchar2(4000)`): Documentation. Documentation on the user. - `logon_code` (`varchar2(240)`, required): User name. The name of the login account used by the user as defined in ITGEN_USERS. - `name` (`varchar2(240)`, required): Name. Full name. - `password` (`varchar2(240)`): Password. Password of the user. - `ldap_user` (`varchar2(240)`): LDAP User. LDAP user associated with this user. Used to authenticate users. - `email_address` (`varchar2(240)`): Email Address. Preferred email address. - `phone_number` (`varchar2(240)`): Phone Number. Preferred phone number. - `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: - Application Users refers to this table through `usr_id`. - Contexts refers to this table through `usr_id`. - Partition Users refers to this table through `usr_id`. - User Roles refers to this table through `usr_id`. ## Indexes The table has these indexes: - `itgen_usr_n1` on `name`. - `itgen_usr_nk` (unique) on `code`. - `itgen_usr_pk` (unique) on `id`. - `itgen_usr_uk_ldap_user` (unique) on `ldap_user`. - `itgen_usr_uk_logon_code` (unique) on `logon_code`. - `itgen_usr_uk_orig` (unique) on `orig_system_reference`. See also [[Invantive Studio/Repository/Reference/Tables of the Repository|Tables of the Repository]].