The table `itgen_licenses` holds: license describing the allowed use of Invantive Producer. Example: At most 3 developers may concurrently access the repository. It keeps history. Its natural key code is `lce`. ## Columns The table has these columns, besides the [[Invantive Studio/Repository/Concepts/Standard Columns|standard columns]]: - `code_helpdesk` (`varchar2(240)`): Code Helpdesk. Support number for the Invantive helpdesk. - `code_license` (`varchar2(240)`, required): Code License. Contract code of the license. - `date_valid_from` (`datetime`, required): Date Valid From. Date from which the license is valid. - `date_valid_till` (`datetime`, required): Date Valid Till. Date till which the license is valid. - `db_cpu_max_number` (`number`): Database CPU Maximum Number. Maximum number of CPUs to which the database license entitles. - `db_helpdesk_number` (`varchar2(240)`): Database Helpdesk Number. Number of the support number for the database. - `db_license_description` (`varchar2(240)`): Database License Description. Description of the database license. - `db_purchase_order` (`varchar2(240)`): Database Purchase Order. Number of the purchase order for the database. - `db_users_conc_max_number` (`number`): Maximum Number of Concurrent Database Users. Maximum number of concurrent users to which the database license entitles. - `db_users_named_max_number` (`number`): Database Users Named Maximum Number. Maximum number of named users to which the database license entitles. - `documentation` (`varchar2(4000)`): Documentation. Notes on the license. - `key` (`varchar2(240)`, required): Key. Key for the license. - `location` (`varchar2(240)`, required): Location. Location of the installation. - `name_database` (`varchar2(240)`, required): Name Database. Name of the database of this installation. - `name_licensee` (`varchar2(240)`, required): Name of Licensee. Name of the legal entity to which the use license was granted. - `name_product` (`varchar2(240)`, required): Name Product. Name of the product. - `name_schema` (`varchar2(240)`, required): Name Schema. Name of the schema of this installation. - `name_system` (`varchar2(240)`, required): Name System. Name of the system of this installation. - `own_are_max_number` (`number`, required): Own Attribute Rules Maximum Number. Maximum number of own attribute rules that can be registered. - `own_mde_max_number` (`number`, required): Own Modules Maximum Number. Maximum number of own modules that can be registered. - `own_tbe_max_number` (`number`, required): Own Tables Maximum Number. Maximum number of own tables that can be registered. - `own_tcn_max_number` (`number`, required): Own Table Columns Maximum Number. Maximum number of own table columns that can be registered. - `own_viw_max_number` (`number`, required): Own Views Maximum Number. Maximum number of own views that can be registered. - `seq` (`number`, required): Sequence. It's numeric unique sequence number. - `users_comp_max_number` (`number`, required): Maximum Number of Composition Users. Maximum number of named users that can log on to Invantive Composition. - `users_eca_max_number` (`number`, required): Users {res:itgen_invantive_control} Maximum Number. Maximum number of named users that can log on to Invantive Control. - `users_max_number` (`number`, required): Users Maximum Number. Maximum number of named users that can log on to Invantive Producer. - `users_qt_max_number` (`number`, required): Users Query Tool Maximum Number. Maximum number of named users that can log on to Invantive Producer Query Tool. - `users_studio_max_number` (`number`, required): Users {res:itgen_invantive_studio} Maximum Number. Maximum number of named users that can log on to Invantive Producer Studio. - `column1` to `column10` and `column_type`: free text columns to extend the data model with fields only available at one site. ## Indexes The table has these indexes: - `itgen_lce_nk` (unique) on `seq`. - `itgen_lce_pk` (unique) on `id`. - `itgen_lce_uk_orig` (unique) on `orig_system_reference`. See also [[Invantive Studio/Repository/Reference/Tables of the Repository|Tables of the Repository]].