The table `itgen_ws_cache` holds: web services cache where requests and their answers are remembered. Example: The city corresponding to postal code 3849 is Hierden. Its natural key code is `wce`. ## Columns The table has these columns, besides the [[Invantive Studio/Repository/Concepts/Standard Columns|standard columns]]: - `answer` (`clob`): Answer. The result of the webservice call. - `checksum` (`varchar2(240)`, required): Checksum. MD5 checksum of the request for the webservice to allow faster determination whether an entry exists in the cache. - `checksum_answer` (`varchar2(240)`, required): Checksum of Answer. MD5 checksum of the answer for the webservice to allow faster determination whether the answer already exists in the cache. - `date_answer_valid_till` (`datetime`, required): Answer Valid till. Date until which the answer is considered valid. - `duration_cs` (`number`, required): Duration (cs). Time in centiseconds needed to retrieve the answer. - `encoding` (`varchar2(30)`, required): Encoding. Encoding algorithm by which the data was stored in the web cache. - `request` (`clob`, required): Request. The text of the request. - `request_url` (`varchar2(1000)`, required): Request URL. URL used to fetch the result of the webservice. - `response_code` (`number`, required): Response Code. HTTP response code. - `seq` (`number`, required): Sequence. It's numeric unique sequence number. - `size_decoded` (`number`, required): Size Decoded. Size after decoding. - `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_wce_n1` on `checksum`. - `itgen_wce_n2` on `request_url`. - `itgen_wce_nk` (unique) on `seq`. - `itgen_wce_pk` (unique) on `id`. - `itgen_wce_uk_orig` (unique) on `orig_system_reference`. See also [[Invantive Studio/Repository/Reference/Tables of the Repository|Tables of the Repository]].