A method is the primary function that a request is meant to invoke on a server.
from_tag
string
64
''
no
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.
to_tag
string
64
''
no
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.
callid
string
64
''
no
Call-ID header field uniquely identifies a particular invitation or all registrations of a particular client.
sip_code
string
3
''
no
SIP reply code
sip_reason
string
32
''
no
SIP reply reason
time
datetime
not specified
default
no
Date and time when this record was written.
duration
unsigned int
11
0
no
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)
ms_duration
unsigned int
11
0
no
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)
setuptime
unsigned int
11
0
no
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)
created
datetime
not specified
NULL
yes
The call creation date and time.
Table 1-2. Table "acc" indexes
name
type
links
description
callid_idx
default
callid
Table 1-3. Table "missed_calls"
name
type
size
default
null
key
extra attributes
description
id
unsigned int
10
default
no
primary
autoincrement
unique ID
method
string
16
''
no
A method is the primary function that a request is meant to invoke on a server.
from_tag
string
64
''
no
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.
to_tag
string
64
''
no
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.
callid
string
64
''
no
Call-ID header field uniquely identifies a particular invitation or all registrations of a particular client.
sip_code
string
3
''
no
SIP reply code
sip_reason
string
32
''
no
SIP reply reason
time
datetime
not specified
default
no
Date and time when this record was written.
setuptime
unsigned int
11
0
no
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 SIP Remote-Party-ID header identifies the calling party and includes user, party, screen and privacy headers that specify how a call is presented and screened.
This table is used by the Call Center module to store ongoing calls for restart persitancy.
It consists only of runtime data and should not be manually provisioned.
More information can be found at: http://www.opensips.org/html/docs/modules/2.2.x/call_center.html.
Table 8-1. Table "cc_flows"
name
type
size
default
null
key
extra attributes
description
id
unsigned int
10
default
no
primary
autoincrement
Flow unique ID in DB
flowid
string
64
default
no
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.
priority
unsigned int
11
256
no
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.
skill
string
64
default
no
The skill required from an agent in order
to receive calls from this flow/queue.
prependcid
string
32
default
no
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.
message_welcome
string
128
NULL
yes
SIP URI point to a media server; this is
used for playing the welcome message for this
flow.
message_queue
string
128
default
no
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.
Table 8-2. Table "cc_flows" indexes
name
type
links
description
unique_flowid
unique
flowid
Table 8-3. Table "cc_agents"
name
type
size
default
null
key
extra attributes
description
id
unsigned int
10
default
no
primary
autoincrement
Agent unique ID in DB
agentid
string
128
default
no
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.
location
string
128
default
no
SIP URI point to the agent location;
All calls for this agents will be sent to this
SIP address.
logstate
unsigned int
10
0
no
The login state of the agent;
0 - not logged in; 1 - logged in ; Agent will
start receiving calls only if logged in.
skills
string
255
default
no
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.
last_call_end
int
11
0
no
The timestamp of the last call of an agent.
If different than 0, the agent will only receive calls after
wrapup seconds pass after this timestamp.
Table 8-4. Table "cc_agents" indexes
name
type
links
description
unique_agentid
unique
agentid
Table 8-5. Table "cc_cdrs"
name
type
size
default
null
key
extra attributes
description
id
unsigned int
10
default
no
primary
autoincrement
CDR unique ID in DB
caller
string
64
default
no
The SIP URI identifing the caller.
received_timestamp
datetime
not specified
default
no
When the call was received.
wait_time
unsigned int
11
0
no
Time (in seconds) spent by the call
in queue (onhold).
pickup_time
unsigned int
11
0
no
Time (in seconds) spent by the call
in ringing to the agent.
talk_time
unsigned int
11
0
no
The duration (in seconds) of the call.
flow_id
string
128
default
no
The ID of the flow the call was
received on.
agent_id
string
128
NULL
yes
The ID of the agent who picked
this call (if any).
call_type
int
11
-1
no
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;
rejected
unsigned int
11
0
no
How many times the call was rejected by agents
(agent not answering his phone).
fstats
unsigned int
11
0
no
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.
cid
unsigned int
11
0
yes
Sequence number of the call.
Table 8-6. Table "cc_calls"
name
type
size
default
null
key
extra attributes
description
id
unsigned int
10
default
no
primary
autoincrement
unique ID of the call.
state
int
11
default
no
The state of the call.
ig_cback
int
11
default
no
Indicates if the call should be ignored.
no_rej
int
11
default
no
Indicates whether the call can be rejected or not.
setup_time
int
11
default
no
Stores the call setup time.
eta
int
11
default
no
The estimated wait time for a call until
it is answered by an agent.
last_start
int
11
default
no
Stores the timestamp when the last call has started.
recv_time
int
11
default
no
Stores the timestamp when the call was received by the
call center.
caller_dn
string
128
default
no
Caller Display Name.
caller_un
string
128
default
no
Caller User Name.
b2buaid
string
128
''
no
The B2B id internally used by the B2B module to identify
the call.
This table is used by the closeddial module to provide closed dial functionality for groups of usernames; This is a functionality similar to a Centrex. More information about the closeddial module can be found at: http://www.opensips.org/html/docs/modules/2.2.x/closeddial.html
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.
to_uri
string
128
default
no
The URI of the TO header (as per INVITE)
to_tag
string
64
default
no
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.
mangled_from_uri
string
64
NULL
yes
The mangled from URI, in case uac_replace_from
was called for this dialog.
mangled_to_uri
string
64
NULL
yes
The mangled to URI, in case uac_replace_to
was called for this dialog
caller_cseq
string
11
default
no
Last Cseq number on the caller side.
callee_cseq
string
11
default
no
Last Cseq number on the callee side.
caller_ping_cseq
unsigned int
11
default
no
Last Cseq number of pings generated on caller side.
callee_ping_cseq
unsigned int
11
default
no
Last Cseq number of pings generated on callee side.
caller_route_set
text
512
default
yes
Route set on the caller side.
callee_route_set
text
512
default
yes
Route set on on the caller side.
caller_contact
string
128
default
no
Caller's contact uri.
callee_contact
string
128
default
no
Callee's contact uri.
caller_sock
string
64
default
no
Local socket used to communicate with caller
callee_sock
string
64
default
no
Local socket used to communicate with callee
state
unsigned int
10
default
no
The state of the dialog.
start_time
unsigned int
10
default
no
The timestamp (unix time) when the dialog was confirmed.
timeout
unsigned int
10
default
no
The timestamp (unix time) when the dialog will expire.
Domain policy rule name which is equal to the URI as published in the domain policy NAPTRs.
type
string
255
default
no
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".
att
string
255
default
yes
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.
val
string
128
default
yes
It contains the values for AVPs created by dp_can_connect(). Default value is "val"
This table is used by the Dynamic Routing module to store
information about the partitions used in routing (url to database,
table names and AVP names for each partition).
More information can be found at: http://www.opensips.org/html/docs/modules/2.2.x/drouting.html.
Table 18-1. Table "dr_gateways"
name
type
size
default
null
key
extra attributes
description
id
unsigned int
10
default
no
primary
autoincrement
Table primary key, not used by module
gwid
string
64
default
no
GW unique ID - used to link the GW from
the routing rules
type
unsigned int
11
0
no
Type/class of the GW (user defined)
address
string
128
default
no
GW/destination address as name/IP[:port]
strip
unsigned int
11
0
no
Number of digits to be striped out for the beginning
of the username when using this GW/destination
pri_prefix
string
16
NULL
yes
String to prefix the username of RURI when using
this GW/destination
attrs
string
255
NULL
yes
Generic string describing GW attributes - this string is
to be interpreted from the script
probe_mode
unsigned int
11
0
no
0- No probing; 1-Probe on disable only ; 2-Always probe;
state
unsigned int
11
0
no
State of the gateway: 0 - enabled; 1 - permanent disabled;
2 - temporary disabled (probing)
socket
string
128
NULL
yes
Local Socket to be used when sending requests (traffic and probes)
to the destination - must be an listener configured in opensips.
description
string
128
''
no
Text description of the GW/destination
Table 18-2. Table "dr_gateways" indexes
name
type
links
description
dr_gw_idx
unique
gwid
Table 18-3. Table "dr_rules"
name
type
size
default
null
key
extra attributes
description
ruleid
unsigned int
10
default
no
primary
autoincrement
Rule unique ID
groupid
string
255
default
no
The ID(s) of the routing group(s) this rule is to be
used for - comma separeted list of numerical Ids
prefix
string
64
default
no
Numerical prefix to match this rule
timerec
string
255
default
no
Time recurrence used for matching this rule.
priority
int
11
0
no
Priority of this rule (among rules with same prefix
and timerec).
routeid
string
255
NULL
yes
Route block (from cfg script) to be called when rule
matches.
gwlist
string
255
default
no
Reference to the GWs/destinations to be used when
rule matches.
attrs
string
255
NULL
yes
Generic string describing RULE attributes - this string is
to be interpreted from the script
description
string
128
''
no
Text description of the rule
Table 18-4. Table "dr_carriers"
name
type
size
default
null
key
extra attributes
description
id
unsigned int
10
default
no
primary
autoincrement
Table key, not used by module
carrierid
string
64
default
no
Unique ID of the carrier
gwlist
string
255
default
no
Reference to the GWs/destinations from the list.
flags
unsigned int
11
0
no
Flags (for different purposes) of the carriers
state
unsigned int
11
0
no
The state of the carrier (on / off).
attrs
string
255
''
yes
Attributes string for the carrier
description
string
128
''
no
Text description of the GW list
Table 18-5. Table "dr_carriers" indexes
name
type
links
description
dr_carrier_idx
unique
carrierid
Table 18-6. Table "dr_groups"
name
type
size
default
null
key
extra attributes
description
id
unsigned int
10
default
no
primary
autoincrement
Unique ID
username
string
64
default
no
Username part of user
domain
string
128
''
no
Domain part of user
groupid
unsigned int
11
0
no
The ID of the routing group the user belongs to.
description
string
128
''
no
Text description of the group/user
Table 18-7. Table "dr_partitions"
name
type
size
default
null
key
extra attributes
description
id
unsigned int
10
default
no
primary
autoincrement
Partition unique ID
partition_name
string
255
default
no
The name of the partition.
db_url
string
255
default
no
The url to the database containing the tables: dr_rules, dr_groups,
dr_carriers and dr_gateways
drd_table
string
255
default
yes
The name of the dr_gateways table in the given database (for the given partition).
drr_table
string
255
default
yes
The name of the dr_rules table in the given database (for the given partition).
drg_table
string
255
default
yes
The name of the dr_groups table in the given database (for the given partition).
drc_table
string
255
default
yes
The name of the dr_carriers table in the given database (for the given partition).
This table is used by the Emergency module to store information of the organizations involved
in the routing of the emergency call, this information is necessary to send the request to the VPC,
according to the NENA standard.
This table isn't necessary if opensips role not send request to VPC, such as the opensips acting as call server in the scenarios II and III.
More information can be found at: http://www.opensips.org/html/docs/modules/2.2.x/emergency.html.
Table 19-1. Table "emergency_routing"
name
type
size
default
null
key
extra attributes
description
id
unsigned int
10
default
no
primary
autoincrement
Unique ID
selectiveRoutingID
string
11
default
no
The Common Language Location Indicator(CLLI) code associated
with the Selective Router to which the emergency call is to be directed
routingESN
unsigned int
5
0
no
The Emergency Services Number associated with a particular ESZ
that respresents a unique combination of Police, Fire and EMS emergency responders.
npa
unsigned int
3
0
no
The primary Numbering Plan Area (NPA) associated with
the outgoing route to the Selective Router that is appropriate for
caller's location.
esgwri
string
50
default
no
Routing information used to direct the call to the ESGW.
Table 19-2. Table "emergency_report"
name
type
size
default
null
key
extra attributes
description
id
unsigned int
10
default
no
primary
autoincrement
Unique ID
callid
string
25
default
no
header that uniquely identifies the call.
selectiveRoutingID
string
11
default
no
The Common Language Location Indicator(CLLI) code associated
with the Selective Router to which the emergency call is to be directed
routingESN
unsigned int
5
0
no
The Emergency Services Number associated with a particular ESZ
that respresents a unique combination of Police, Fire and EMS emergency responders.
npa
unsigned int
3
0
no
The primary Numbering Plan Area (NPA) associated with
the outgoing route to the Selective Router that is appropriate for
caller's location.
esgwri
string
50
default
no
Routing information used to direct the call to the ESGW.
lro
string
20
default
no
last routing option destination for the call.
VPC_organizationName
string
50
default
no
company name or other label of the VPC that provided the routing information.
VPC_hostname
string
50
default
no
identifies the fully qualified domain name or IP address
of the VPC that provided routing information.
VPC_timestamp
string
30
default
no
Date Time Stamp indicating UTC date and time that the message was sent from VPC.
result
string
4
default
no
Code indicating the reason for success or failure to determine an ERT/ESGWRI and ESQK.
disposition
string
10
default
no
Describe how routing of call was done(e.g.,by ESGWRI or bye LRO)
Table 19-3. Table "emergency_service_provider"
name
type
size
default
null
key
extra attributes
description
id
unsigned int
10
default
no
primary
autoincrement
Unique ID
organizationName
string
50
default
no
provider company name's. This parameter is optional
field in the NENA v2 interface (call server - VPC)
hostId
string
30
default
no
provider hostname's. This parameter is mandatory if
attribution is 0(source) or 2(VSP), otherwise it is optional.
nenaId
string
50
default
no
the NENA administered company identifier (NENA Company ID) of provider.
This parameter is optional field in the NENA v2 interface (call server - VPC).
contact
string
20
default
no
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.
certUri
string
50
default
no
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).
nodeIP
string
20
default
no
IP address of the node that is being registered. This parameter is mandatory.
attribution
unsigned int
2
default
no
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
This table us used by the group module as a means of group membership checking. Used primarily for Access Control Lists (ACL's). More information about the group module can be found at: http://www.opensips.org/html/docs/modules/2.2.x/group.html
Transport protocol is either "any" or equal to transport protocol of request. Possible values that can be stored are "any", "udp", "tcp", "tls", and "sctp".
This table for the registrar module is similar to the "location" table, (the aliases index makes lookup of missed calls much faster). Thus, the function lookup("alias") can be used to map aliases to AORs. More information is available at: http://www.opensips.org/html/docs/modules/2.2.x/registrar.html. Most people uses the dbaliases table with the alias_db module now.
Table 29-1. Table "aliases"
name
type
size
default
null
key
extra attributes
description
id
unsigned int
10
default
no
primary
autoincrement
unique ID
username
string
64
''
no
Alias Username / Phone Number
domain
string
64
''
no
Domain name
contact
string
255
''
no
Contact header field value provides a URI whoses meaning depends on the type of request or response it is in.
received
string
128
NULL
yes
Received IP:PORT in the format SIP:IP:PORT
path
string
255
NULL
yes
Path Header(s) per RFC 3327
expires
datetime
not specified
'2020-05-28 21:32:15'
no
Date and time when this entry expires.
q
float
10,2
1.0
no
Value used for preferential routing.
callid
string
255
'Default-Call-ID'
no
Call-ID header field uniquely identifies a particular invitation or all registrations of a particular client.
cseq
int
11
13
no
CSeq header field contains a single decimal sequence number and the request method.
last_modified
datetime
not specified
'1900-01-01 00:00:01'
no
Date and time when this entry was last modified.
flags
int
11
0
no
Flags
cflags
string
255
NULL
yes
CFlags
user_agent
string
255
''
no
User-Agent header field contains information about the UAC originating the request.
socket
string
64
NULL
yes
Socket used to connect to OpenSIPS. For example: UDP:IP:PORT
methods
int
11
NULL
yes
Flags that indicate the SIP Methods this contact will accept.
sip_instance
string
255
NULL
yes
SIP Instance for this particular contact
attr
string
255
NULL
yes
Optional information specific to each registration
