The table `itgen_contents` holds: contents of the database in a searchable form. Example: The person has a name 'John Doe'. Its natural key code is `ctt`. ## Columns The table has these columns, besides the [[Invantive Studio/Repository/Concepts/Standard Columns|standard columns]]: - `payload` (`clob`, required): Payload. Searchable contents of the column/row combination. - `ref_key` (`number`, required): Referential Key. Reference to a row in the table. - `tcn_id` (`number`, required): Column ID. Reference to a table column registered in ITGEN_TABLE_COLUMNS. - `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: - `tcn_id` refers to Table Columns (`id`). ## Indexes The table has these indexes: - `itgen_ctt_nk` (unique) on `tcn_id`, `ref_key`. - `itgen_ctt_pk` (unique) on `id`. - `itgen_ctt_tcn_fk` on `tcn_id`. - `itgen_ctt_uk_orig` (unique) on `orig_system_reference`. See also [[Invantive Studio/Repository/Reference/Tables of the Repository|Tables of the Repository]].