The table `itgen_interactions` holds: all interactions between the users and the application performed through the web frontend. Interactions through the business views are not recorded here. Please see also ITGEN_TRANSACTIONS. Example: The user 'system' executed a query 'select * from bubs_projecten_v' in the form 'Projects' yesterday morning. Its natural key code is `ian`. ## Columns The table has these columns, besides the [[Invantive Studio/Repository/Concepts/Standard Columns|standard columns]]: - `action` (`varchar2(60)`, required): Action. The executed SQL action (select, insert, update or delete). - `date_reported` (`datetime`): Date Reported. The reports will contain the status of the system as of this date. - `interaction_number` (`number`, required): Interaction Number. Unique numeric code, introduced to create an artificial natural unique index and it's value is identical to the value of the column ID. - `last_transaction_number` (`number`, required): Last Transaction Number. Number of the last completed transaction. This information can be used to reconstruct complex interactions and changes through time. - `logon_code` (`varchar2(128)`, required): User name. The name of the login account used by the user as defined in BUBS_USERS. - `machine` (`varchar2(128)`, required): Machine. Name of the workstation used to access the application. - `module` (`varchar2(128)`, required): Module. Name of the module installed. - `oracle_audit_sessionid` (`number`, required): Oracle Audit Session-ID. Auditing serial number of the Oracle session executing this action. - `oracle_session_serial` (`number`, required): Oracle Session Serial. Serial number of the Oracle session executing this action. - `oracle_sessionid` (`number`, required): Oracle Session-ID. ID of the Oracle session executing this action. - `query` (`varchar2(4000)`): Query. The query or data manipulation SQL-statement executed. - `request_url` (`varchar2(4000)`): Request URL. Absolute URL used. - `sessionid` (`varchar2(240)`, required): Session-ID. Unique ID of the session executing the interaction. - `time` (`datetime`, required): Time. Time of the RDBMS server at which the event occurred. - `time_cs` (`number`, required): Time (cs). The number of 100th's of a second from some arbitrary epoch. This time is typically used to determine the difference in time between two events. ## Indexes The table has these indexes: - `itgen_ian_nk` (unique) on `interaction_number`. - `itgen_ian_pk` (unique) on `id`. See also [[Invantive Studio/Repository/Reference/Tables of the Repository|Tables of the Repository]].