Interactive Session Recorder Version 5.2 Database Schema ...

Interactive Session Recorder Version 5.2 Database Schema Definition and Description

The ISR database schema is provided for reference only. Access to the ISR database by components or services not provided as part of the Oracle Interactive Session Recorder is prohibited.

Prepared by: Risa Eldridge Last Updated: October 2017

ISR_5.2_DatabaseSchemaDefinition.docx

Page | 2

Table Name: account_raws_configuration

Field Name account_id delete_enabled cdr_max_attempts exclusive_lock_seconds

Field Type int(10) unsigned tinyint(1) int int

Null NOT NULL NOT NULL NOT NULL NOT NULL

Supported Value

0 = disabled 1 = enabled

Purpose: Configuration and setup of Remote Archival Web Service

Default

0 3 120

Description

accounts.account_id of account

Will recordings be deleted from ISR after successful remote archival

Number of attempts to try to remote archive before failing Number of seconds ra_clients. ra_client_id can lock a recording before it expires and is available for another client to access

Table Name: accounts

Field Name account_id account_name account_description account_misc percent_to_record recording_enabled call_meta_data_src announce_enabled default_announce_audio_file default_announce_audio_text default_opt_out_vxml_file opt_out_enabled recorder_state default_recording_type agent_id_editable_flag rating_editable_flag completed_editable_flag notes_editable_flag application play_beep_before_record terminate_on_dtmf

Purpose: Configuration and setup of accounts (tenants)

Field Type

Null

Supported Value

int(10) unsigned

NOT NULL

varchar(45)

NOT NULL Text

varchar(45)

NOT NULL Text

varchar(45)

NOT NULL Text

smallint(5) tinyint(3) tinyint(1) tinyint(1) varchar(100)

NOT NULL NOT NULL NOT NULL NOT NULL

1-100

0=recording disabled 1=recording enabled 0 = none 1 = TSAPI 0= announcement disabled 1=announcement enabled

Text

varchar(200)

Text

varchar(100)

Text

tinyint(1) smallint(5) unsigned tinyint(3) unsigned tinyint(3) unsigned tinyint(3) unsigned tinyint(3) unsigned tinyint(3) unsigned varchar(45) tinyint(3) unsigned

NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL

NOT NULL

0 = disabled 1 = enabled 0 = disabled 1 = enabled See the admin guide for the supported recording formats. 0 = not editable 1 = editable 0 = not editable 1 = editable 0 = not editable 1 = editable 0 = not editable 1 = editable passthru, conference, callparking, recordandsave, VAMTest 0 = do not play 1 = play

tinyint(3) unsigned

NOT NULL 0 = do not terminate on dtmf press

ISR_5.2_DatabaseSchemaDefinition.docx

Default auto increment

25 1 0 0

0 0 0 0 0 0 0 NULL 0 0

Description Primary key Name of the account Description of the account Miscellaneous field for account identification Default recording percentage for routes created under this account

Whether recording is enabled by default for routes created under this account

FOR FUTURE USE

DEPRECATED ? NO LONGER USED

DEPRECATED ? NO LONGER USED DEPRECATED ? NO LONGER USED DEPRECATED ? NO LONGER USED

DEPRECATED ? NO LONGER USED

Whether calls can currently be recorded for calls on routes under this account

The default recording format used for all routes under this account

Account default for signaling whether users on this account edit the data in the recordings.agent_id field Account default - Can users edit the data in the scoring rating? (rec_notes_and_scoring.user_rating) Account default - Can users edit the data in the complete transaction flag? (rec_notes_and_plete_status) Account default - Can users edit the scoring notes (rec_notes_and_scoring.notes)

DEPRECATED ? NO LONGER USED

DEPRECATED ? NO LONGER USED DEPRECATED ? NO LONGER USED

Page | 3

Field Name

terminate_on_eos recurring_beep_enabled recurring_beep_interval recurring_beep_file record_save_dtmf maximum_number_of_ports number_of_burst_ports acct_port_limit show_appliance_tab_in_route_view codec_profile_id force_rpdd

store_dtmf_setting

download_recording_permission playback_recording_permission

delete_recording_permission`

Field Type

tinyint(4) tinyint(3) unsigned int(10) unsigned varchar(45) varchar(1) int(10) unsigned int(10) unsigned int(11) tinyint(3) unsigned INT

INT

TINYINT

TINYINT(3) TINYINT(3) TINYINT(3)

Null

NOT NULL NOT NULL NOT NULL

NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL

Supported Value 1 = terminate on dtmf press 0 = do not terminate on eos 1 = terminate on eos 0=disabled 1=enabled

File Name 0-9, #, *

NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL

0 = Disabled 1 = Enabled -1 = None / Use System Default 0 = Disabled 1 = Enabled 0 = download disabled 1 = download enabled 0 = playback disabled 1 = playback enabled 0 = delete disabled 1 = delete enabled

Default

-1 0 30 beep.wav # 24 6 -1 0 1 0

-1

1 1 1

Description

DEPRECATED ? NO LONGER USED

DEPRECATED ? NO LONGER USED

DEPRECATED ? NO LONGER USED

DEPRECATED ? NO LONGER USED

single dtmf digit that will save a recording made on a Record & Save route Default maximum number of simultaneous sessions a route created on this account will be able to support. Default number of ports over maximum that the route will be able to use. These ports are reported separately. -1 for unlimited, The maximum number of sessions ALL routes on this account will be able to use. DEPRECATED ? NO LONGER USED

Default codec profile associated with this account

Write all recordings to .rpdd files to be converted after recording completion

Should ISR store and display RFC2833 and SIP INFO DTMF digits in the recording details view? Do users created under this account have the option of downloading recordings? Account level control over recording download. Do users created under this account have the option to playback recordings within the dashboard? Account level control over recording playback. Do users created under this account have the option to delete recordings within the dashboard? Account level control over recording deletion.

Table Name: accounts_realms

Field Name id account_id realm_id

Field Type bigint int(10) bigint

Nullable NOT NULL NOT NULL

Supported Values

Purpose: Account to realm correlation table

Default

Description auto increment accounts.account_id realms.realm_id

ISR_5.2_DatabaseSchemaDefinition.docx

Page | 4

Table Name: archivers

Field Name archiver_id archiver_ip site_id archiver_thread_number max_fail_count archiver_mode source_free_space_Kb dest_free_space_Kb delete_enabled archiver_state source_location dest_location dir_date_structure move_non_existing_record

conversion_mode

conversion_percentage convert_all_on_last_hop default_conversion_file_type xmlrpc_server_port

Purpose: Definition and configuration of archivers

Field Type int(10) varchar(45) int(10) smallint(5) unsigned smallint(5) unsigned varchar(10) bigint(30) unsigned bigint(30) unsigned smallint(2) unsigned smallint(2) unsigned bigint(20) bigint(20) tinyint(1) tinyint(1)

Nullable NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL

NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL

tinyint

NOT NULL

tinyint tinyint(1) tinyint int(10)

NOT NULL

Supported Values

ip addresses

Primary Failover

0 = disabled 1 = enabled 0 = paused 1 = active

0 = do not archive with date structure 1 = archive with date structure 0 = do not move non-existing files 1 = move non-existing files 0 ? disabled 1 ? enabled 2 - convert by percentage

0 ? disabled 1 ? enabled

Default auto increment `' 0 1 0 NULL 0 0 0 1 -1 -1 1 0

1

100 1 8 8886

Description

Primary key

Archiver's IP Address ? needs to match the RSS SIP IP Address

sites.site_id this archiver is associated with

Number of files to be moved simultaneously Number of times the archiver should attempt to move a file before permanently marking it failed Failover archiver deprecated after 2.2.All archivers are Primary.

Amount of free space remaining on the source_directory

Amount of free space remaining on the destination_directory Should the archiver delete files from the destination_directory after route_config.minimum_storage_days Is the archiver active?

locations.location_id of the source location for this archiver

locations.location_id of the destination location for this archiver

Should recordings be archived by date If recording is not found, should record be removed from recordings db and added to recordings missing table for tracking.

Configures Archival for requesting codec conversion for playback.

The percentage value of recorded files to request codec conversion for playback during Archival. If all or some of the archived recordings in their final destination need conversion for playback, archiver can request conversion for all of the remaining files. DEPRECATED ? NO LONGER USED

Port number to listen on for XMLRPC callbacks from converter.

ISR_5.2_DatabaseSchemaDefinition.docx

Page | 5

Table Name: audit

Field Name audit_id audit_time user_id user_email session_id requesting_ip action_type

object_name

prev_value new_value result_flag

Purpose: Log user activity within the Admin Dashboard

Field Type bigint(20) unsigned datetime int(10) unsigned varchar(100) varchar(50) varchar(16) varchar(16)

varchar(100)

varchar(128) varchar(128) tinyint(3) unsigned

Nullable NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL

NOT NULL

Supported Values

Default auto increment

VIEW_XXX Modify_XXX Create_XXX Delete_XXX where XXX=Account,Route,Site,User,Recording

0 = failed 1 = success

NULL

NULL NULL 0

Description Primary key Date entry added to table users.user_id performing the action users.email performing the action User's session ID IP address the request originated from Action the user performed

Object the action was performed on

Value of the field before the edit Value of the field after the edit Was the action successful

Table Name: authentication_service

Field Name authentication_service_id url name enabled src_type_id

Field Type int varchar(255) varchar(255) tinyint(1) int

Nullable NOT NULL

Supported Values

NOT NULL

0 = disabled 1 = enabled

Purpose: Defines 3rd party user authentication services

Default auto increment

0

Description Primary key location of authentication service name of auth service (descriptive) Can this auth service be used? Src_type.src_type_id

Table Name: call_stats

Field Name route_id call_date total_number_of_calls peak_number_of_calls

Field Type int(10) datetime int(10) unsigned int(10) unsigned

Nullable NOT NULL NOT NULL NOT NULL NOT NULL

Supported Values

ISR_5.2_DatabaseSchemaDefinition.docx

Purpose: Track various system statistics to be used for reports

Default 0 0000-00-00 00:00:00 0 0

Description route_config.route_id that is being tracked date of statistical information Total number of INVITEs received by the RSS Maximum number of simultaneous sessions for the call_date

Page | 6

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download