unique ID

A method is the primary function that a request is meant to invoke on a server.

The tag parameter serves as a general mechanism to identify a dialog, which is the combination of the Call-ID along with two tags, one from participant in the dialog.

The tag parameter serves as a general mechanism to identify a dialog, which is the combination of the Call-ID along with two tags, one from participant in the dialog.

Call-ID header field uniquely identifies a particular invitation or all registrations of a particular client.

SIP reply code

SIP reply reason

Date and time when this record was written.

Call duration (from 200OK INVITE to BYE request) in seconds - this field is populated only if CDR support is enabled in ACC module (see cdr_flag parameter)

Call duration (from 200OK INVITE to BYE request) in milliseconds - this field is populated only if CDR support is enabled in ACC module (see cdr_flag parameter)

Call initialization duration - (from INVITE request to 200 OK INVITE) - this filed is populated only if CDR support is enabled in ACC module (see cdr_flag parameter)

The call creation date and time.

unique ID

A method is the primary function that a request is meant to invoke on a server.

The tag parameter serves as a general mechanism to identify a dialog, which is the combination of the Call-ID along with two tags, one from participant in the dialog.

The tag parameter serves as a general mechanism to identify a dialog, which is the combination of the Call-ID along with two tags, one from participant in the dialog.

Call-ID header field uniquely identifies a particular invitation or all registrations of a particular client.

SIP reply code

SIP reply reason

Date and time when this record was written.

Call initialization duration - (from INVITE request to reply) - this filed is populated only if CDR support is enabled in ACC module (see cdr_flag parameter)

The call creation date and time.

unique ID

Alias username / phone number

Alias domain name

Username / phone number

Domain name

Unique ID

Username / phone number

Domain name

Password

md5(username:realm:password)

sha256(username:realm:password)

sha512t256(username:realm:password)

Username / phone number

Domain name

Username / phone number

Date and time when this record was last modified.

Table key, not used by module

Unique ID of the JWT profile

The SIP username associated with the JWT profile

Table key, not used by module

JWT profile tag which this secret belongs to

The KEY used for signing the JWT

UNIX TS for the START period on which the JWT secret is valid

UNIX TS for the END period on which the JWT secret is valid

Unique ID

Entity type: 0-server, 1-client

Dialog state

RURI(stored only for server entities to correctly match CANCEL)

From URI

To URI

From display name

To display name

TO tag

From tag

Call ID

Cseq0

Cseq1

Contact0

Contact1

Record route 0

Record route 1

Socket Info

Logic parameter

OpenSIPS module that this entity belongs to

Generic binary data storage

Last method

Last reply code

Last invite cseq

Leg cseq

Leg route

Leg tag

Leg contact

Leg sockinfo

Unique ID

Scenario instantiation key

Scenario id

Scenario State

Lifetime

E1 type

E1 Scenario ID

E1 From URI

E1 To URI

E1 Key

E1 SDP

E2 type

E2 Scenario ID

E2 From URI

E2 To URI

E2 Key

E2 SDP

E3 type

E3 Scenario ID

E3 From URI

E3 To URI

E3 Key

unique ID

The shared line.

The URI list of watchers

The entity to keep.

The state of the appearance index.

The URI of the Call-Info header

The URI of the appearance in Call-Info header

The b2b_logic key.

The entity to keep.

The state of the appearance index.

The URI of the Call-Info header

The URI of the appearance in Call-Info header

The b2b_logic key.

The entity to keep.

The state of the appearance index.

The URI of the Call-Info header

The URI of the appearance in Call-Info header

The b2b_logic key.

The entity to keep.

The state of the appearance index.

The URI of the Call-Info header

The URI of the appearance in Call-Info header

The b2b_logic key.

The entity to keep.

The state of the appearance index.

The URI of the Call-Info header

The URI of the appearance in Call-Info header

The b2b_logic key.

The entity to keep.

The state of the appearance index.

The URI of the Call-Info header

The URI of the appearance in Call-Info header

The b2b_logic key.

The entity to keep.

The state of the appearance index.

The URI of the Call-Info header

The URI of the appearance in Call-Info header

The b2b_logic key.

The entity to keep.

The state of the appearance index.

The URI of the Call-Info header

The URI of the appearance in Call-Info header

The b2b_logic key.

The entity to keep.

The state of the appearance index.

The URI of the Call-Info header

The URI of the appearance in Call-Info header

The b2b_logic key.

The entity to keep.

The state of the appearance index.

The URI of the Call-Info header

The URI of the appearance in Call-Info header

The b2b_logic key.

Table primary key, not used by module

The Key

The value

The value of the counter

The unix timestamp when the key will expires

Flow unique ID in DB

The unique ID of the flow in the Call Center module - to be used to identify the flow/queue in the module and from outside the module; It is an alphanumerical string.

The priority of the flow (in relation to the other flows); 0 is maximum priority and calls for this flow will be processed first all the time.

The skill required from an agent in order to receive calls from this flow/queue.

Aphanumerical prefix to be added to the caller displayname when sending calls from this flow to agents (so agent - serving muliple flows - can see what was the flow the call was received on.

The maximum warpup time (in seconds) allowed for the call terminated via this flow. This value will limit the default or per-agent wrapup time. A 0 value means no limit/max defined.

If set to true (non zero value), the calls diverted to dissuading destination will be closed after the dissuading terminates (useful when using a playback for dissuading).

For how long (in seconds) a call will wait in the queue before getting a dissuading redirect.

The Estimated Waiting Time (in seconds) threshold that will redirect a new incoming call (not queued yet) to the dissuading destination.

The Size of the Queue (as already waiting calls in this flow) that will redirect a new incoming call (not queued yet) to the dissuading destination.

SIP URI point to a media server; this is used for playing the welcome message for this flow.

SIP URI point to a media server; this is used for playing the onhold message for this flow. IMPORTANT - this message must cycle and media server must never hung up on it.

SIP URI point to a media server; this is used for playing the dissuading message for this flow.

SIP URI point to a media server; this is used for playing the name of the flow id to the agent before delivering a call to him.

Agent unique ID in DB

The unique ID of the agent in the Call Center module - to be used to identify the agent in the module and from outside the module; It is an alphanumerical string.

SIP URI point to the agent location; All calls for this agents will be sent to this SIP address.

The call login state of the agent; 0 - not logged in; 1 - logged in ; Agent will start receiving calls only if logged in.

MSRP SIP URI point to the agent location; All chat sessions for this agents will be sent to this SIP address.

How many MSRP/chat sessions the agent can handle in the same time.

Comma separated list of skills offered by the agent; these skills must match the skills used in the queues/flows definition; In order to receive calls from a flow, the agent must have the skill required by that flow.

The timestamp when the last wrapup ends/ended for the agent. If different than 0, the agent will only receive calls after this timestamp.

The duration in seconds needed by the agent to wrap up the call he just completed. If set to 0, the global wraptup time will be used for this agent.

CDR unique ID in DB

The SIP URI identifing the caller.

When the call was received.

Time (in seconds) spent by the call in queue (onhold).

Time (in seconds) spent by the call in ringing to the agent.

The duration (in seconds) of the call.

The ID of the flow the call was received on.

The ID of the agent who picked this call (if any).

Type of call: -2 - call rejected by agent; -1 - call dropped because of internal error; 0 - call handled by agent; 1 - call dropped while in queue;

How many times the call was rejected by agents (agent not answering his phone).

Bitmask of the following binary flags: 0 - it is inbound call; 1 - call was distributed to agents; 2 - call was answered; 3 - call was abandoned.

Sequence number of the call.

Media type of the call: 1 - RTP/audio; 2 - MSRP/chat;

unique ID of the call.

The state of the call.

Indicates the media type of the call, (0) RTP/audio or (1) MSRP/chat.

Indicates if the call should be ignored.

Indicates whether the call can be rejected or not.

Stores the call setup time.

The estimated wait time for a call until it is answered by an agent.

Stores the timestamp when the last call has started.

Stores the timestamp when the call was received by the call center.

Caller Display Name.

Caller User Name.

The B2B id internally used by the B2B module to identify the call.

The flow/queue this call belongs to.

The agent that handles the call.

Parameter passed to the callcenter B2B logic scriptt.

unique ID

This column contains the carrier id.

This column contains the route domain. Additional domains could be used for example as fallback.

This column contains the scan prefix, which define the matching portion of a phone number.

This column contains the flags used for rule matching.

This column contains the mask that is applied to the message flags before rule matching.

Name of column containing the probability. The probability value is used to distribute the traffic between several gateways.

Name of the column containing the number of digits to be stripped of the userpart of an URI before prepending rewrite_prefix.

Name of column containing rewrite prefixes. Here you can define a rewrite prefix for the localpart of the SIP URI.

Rewrite prefix for the localpart of the SIP URI.

Rewrite suffix for the localpart of the SIP URI.

A comment for the route entry, useful for larger routing tables.

unique ID

This column contains the carrier id.

This column contains the route domain. Additional domains could be used for example as fallback.

This column contains the scan prefix, which define the matching portion of a phone number.

This column contains the routing destination used for rule matching.

This column contains the reply code used for rule matching.

This column contains the flags used for rule matching.

This column contains the mask that is applied to the message flags before rule matching.

This column contains the route domain that should be used for the next routing attempt.

A comment for the route entry, useful for larger routing tables.

unique ID

This column contains the carrier name.

unique ID

Username / phone number

Domain name

Closed dial username

Closed dial domain

Attribute use to group usernames

New URI

unique ID

unique identifier for a cluster

unique identifier for a node

network location of the machine, like protocol:ip:port

state of the machine 1 - Enabled, 0 - Disabled

maximum number of ping retries before the link with a node is considered down

priority to be chosen as next hop in case of same length(number of hops) paths

SIP address, currently not used by the module

Node flags: "seed" - node automatically considered to be synchronized

opaque text not used by the module

Unique ID

h_entry | h_id

Call-ID of the dialog

The URI of the FROM header (as per INVITE)

The tag parameter serves as a general mechanism to identify a dialog, which is the combination of the Call-ID along with two tags, one from participant in the dialog.

The URI of the TO header (as per INVITE)

The tag parameter serves as a general mechanism to identify a dialog, which is the combination of the Call-ID along with two tags, one from participant in the dialog.

The mangled from URI, in case uac_replace_from was called for this dialog.

The mangled to URI, in case uac_replace_to was called for this dialog

Last Cseq number on the caller side.

Last Cseq number on the callee side.

Last Cseq number of pings generated on caller side.

Last Cseq number of pings generated on callee side.

Route set on the caller side.

Route set on on the caller side.

Caller's contact uri.

Callee's contact uri.

Local socket used to communicate with caller

Local socket used to communicate with callee

The state of the dialog.

The timestamp (unix time) when the dialog was confirmed.

The timestamp (unix time) when the dialog will expire.

Variables attached to this dialog.

Profiles this dialog belongs to.

Script flags for the dialog.

Module flags for the dialog.

Internal flags used by the module.

The name of the script route to be executed upon call answering

The name of the script route to be executed upon call timeout (as duration)

The name of the script route to be executed upon call hangup

unique ID

Dialplan ID.

Priority of rule.

Matching operator for rule (0-equal, 1-regexp).

Matching expression (regexp or string).

Matching flags (0-case sensitive, 1-case insensitive).

Substitution expression.

Replacement expression (sed like).

Time recurrence used to match this rule.

Specifies if the command can be used, or is disabled.

General attributes string to be returned in case of rule matching.

unique ID

Destination set id

Destination SIP address

Local Socket to be used when sending requests (traffic and probes) to the destination - must be an listener configured in opensips.

The state of the destination (0 enabled, 1 disabled , 2 probing)

0-Probe only when in probing state; 1-Probe even in enable/active state;

The weight of the destination (integer or socket definition)

The priority of each destination (only useful with algorithm 8)

Attribute string - custom, opaque string that will be pushed into script when this destination will be selected

Description for this destination

unique ID

Domain name

Domain Attributes

Date and time when this record was last modified.

unique ID

Domain policy rule name which is equal to the URI as published in the domain policy NAPTRs.

Domain policy rule type. In the case of federation names, this is "fed". For standard referrals according to draft-lendl-speermint-technical-policy-00, this is "std". For direct domain lookups, this is "dom". Default value is "type".

It contains the AVP's name. If the rule stored in this row triggers, than dp_can_connect() will add an AVP with that name.

It contains the values for AVPs created by dp_can_connect(). Default value is "val"

Comment about the rule

Table primary key, not used by module

GW unique ID - used to link the GW from the routing rules

Type/class of the GW (user defined)

GW/destination address as name/IP[:port]

Number of digits to be striped out for the beginning of the username when using this GW/destination

String to prefix the username of RURI when using this GW/destination

Generic string describing GW attributes - this string is to be interpreted from the script

0- No probing; 1-Probe on disable only ; 2-Always probe;

State of the gateway: 0 - enabled; 1 - permanent disabled; 2 - temporary disabled (probing)

Local Socket to be used when sending requests (traffic and probes) to the destination - must be an listener configured in opensips.

Text description of the GW/destination

Rule unique ID

The ID(s) of the routing group(s) this rule is to be used for - comma separeted list of numerical Ids

Numerical prefix to match this rule

Time recurrence used for matching this rule.

Priority of this rule (among rules with same prefix and timerec).

Route block (from cfg script) to be called when rule matches.

A comma-separated list of GW unique IDs (e.g. GW-5) and/or hash-prefixed ("#") Carrier unique IDs (e.g. #CR-2).

The sorting algorithm to be employed for the rule's destinations when do_routing() is called. Possible values: 'N' (default; no sorting, preserve given order), 'W' (weight based sorting), 'Q' (quality-based sorting, provided by the qrouting module)

Whenever the 'Q' (quality-based routing) sorting algorithm is provided, this column must hold a profile id belonging to the "qr_profiles" table.

Generic string describing RULE attributes - this string is to be interpreted from the script

Text description of the rule

Table key, not used by module

Unique ID of the carrier

A comma-separated list of GW unique IDs (e.g. GW-5).

Flags of the carriers (for different purposes: use only first gw from cr (set the first bit of the flag); disable gateway (set the second bit of the flag);

The sorting algorithm to be employed for the carrier's destinations when do_routing() is called. Possible values: 'N' (default; no sorting, preserve given order), 'W' (weight based sorting), 'Q' (quality-based sorting, provided by the qrouting module)

The state of the carrier (on / off).

Attributes string for the carrier

Text description of the GW list

Unique ID

Username part of user

Domain part of user

The ID of the routing group the user belongs to.

Text description of the group/user

Partition unique ID

The name of the partition.

The url to the database containing the tables: dr_rules, dr_groups, dr_carriers and dr_gateways

The name of the dr_gateways table in the given database (for the given partition).

The name of the dr_rules table in the given database (for the given partition).

The name of the dr_groups table in the given database (for the given partition).

The name of the dr_carriers table in the given database (for the given partition).

The name of ruri_avp AVP.

The name of gw_id_avp AVP

The name of gw_priprefix_avp AVP.

The name of gw_sock_avp AVP.

The name of rule_id_avp AVP.

The name of rule_prefix_avp AVP.

The name of carrier_id_avp AVP.

Unique ID

The Common Language Location Indicator(CLLI) code associated with the Selective Router to which the emergency call is to be directed

The Emergency Services Number associated with a particular ESZ that respresents a unique combination of Police, Fire and EMS emergency responders.

The primary Numbering Plan Area (NPA) associated with the outgoing route to the Selective Router that is appropriate for caller's location.

Routing information used to direct the call to the ESGW.

Unique ID

header that uniquely identifies the call.

The Common Language Location Indicator(CLLI) code associated with the Selective Router to which the emergency call is to be directed

The Emergency Services Number associated with a particular ESZ that respresents a unique combination of Police, Fire and EMS emergency responders.

The primary Numbering Plan Area (NPA) associated with the outgoing route to the Selective Router that is appropriate for caller's location.

Routing information used to direct the call to the ESGW.

last routing option destination for the call.

company name or other label of the VPC that provided the routing information.

identifies the fully qualified domain name or IP address of the VPC that provided routing information.

Date Time Stamp indicating UTC date and time that the message was sent from VPC.

Code indicating the reason for success or failure to determine an ERT/ESGWRI and ESQK.

Describe how routing of call was done(e.g.,by ESGWRI or bye LRO)

Unique ID

provider company name's. This parameter is optional field in the NENA v2 interface (call server - VPC)

provider hostname's. This parameter is  mandatory if attribution is 0(source) or 2(VSP), otherwise it is optional.

the NENA administered company identifier (NENA Company ID) of provider. This parameter is optional field in the NENA v2 interface (call server - VPC).

telephone number by which the provider operator can be reached 24 hours a day, 7 days a week. This parameter is  mandatory if attribution is 0(source) or 2(VSP), otherwise it is optional.

provides a means of directly obtaining the VESA(Valid Emergency Services Authority) issued certificate for the provider. This parameter is optional field in the NENA v2 interface (call server - VPC).

IP address of the node that is being registered. This parameter is  mandatory.

It is a field of type int designating the function of the organization involved in the composition of architecture NENA being registered in this table. This parameter is  mandatory.  The values that this field can take are: 0 - the organization is a Source. Source is node directly requesting emergency call routing from the VPC. 1 - the organization is a VPC. VPC is the routing information provider to emengency call 2- the organization is a VSP. VSP is the caller's voice service provider

Rule unique ID

The ID of the profile the current rule is part of

Numerical prefix to match this rule

Start of the interval in which the rule should be matched.

End of the interval in which the rule should be matched.

List/interval of days in which the rule is available.

Warning threshold for calls per minute.

Crtical threshold for calls per minute.

Warning threshold for calls per minute.

Crtical threshold for call duration.

Warning threshold for total calls.

Crtical threshold for total calls.

Warning threshold for concurrent calls.

Crtical threshold for concurrent calls.

Warning threshold for sequential calls.

Crtical threshold for sequential calls.

unique ID

FreeSWITCH ESL authentication username

FreeSWITCH ESL authentication password (plain text)

FreeSWITCH ESL IP address

FreeSWITCH ESL port

Comma-separated, case-sensitive values holding the exact FreeSWITCH ESL events which OpenSIPS will attempt to subscribe to

unique ID

Username / phone number

Domain name

Group name

Date and time when this record was last modified.

unique ID

Regular expression

Group ID

unique ID

Name of the room

Domain of the room

Flags

unique ID

Username

Domain

Flags

unique ID of the destination

The group the destination belongs to

Destination address as a SIP URI