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) - this filed 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.1.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
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
primary
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.1.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.1.x/drouting.html.
Table 17-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 begining
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 17-2. Table "dr_gateways" indexes
name
type
links
description
dr_gw_idx
unique
gwid
Table 17-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 17-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 17-5. Table "dr_carriers" indexes
name
type
links
description
dr_carrier_idx
unique
carrierid
Table 17-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 17-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 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.1.x/group.html
Prefix-Domain Translation means to change the host and port in R-URI, based on the prefix found in R-URI and source domain (that is domain in From-URI). More information can be found at: http://www.opensips.org/html/docs/modules/2.1.x/pdt.html
Table 24-1. Table "pdt"
name
type
size
default
null
key
extra attributes
description
id
unsigned int
10
default
no
primary
autoincrement
Unique ID
sdomain
string
128
default
no
Source domain
prefix
string
32
default
no
Prefix found in the username part of R-URI.
domain
string
128
''
no
Domain corresponding to (sdomain, prefix) pair where the message must be sent.
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.1.x/registrar.html. Most people uses the dbaliases table with the alias_db module now.
Table 28-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
