DB schema

Accounting

Table “acc”

This table is used by the ACC module to report on transactions - accounted calls. More information is available at: http://www.opensips.org/html/docs/modules/1.9.x/acc.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
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.
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.

Indexes

name	type	links	description
callid_idx	default	callid

Table “missed_calls”

This table is used by the ACC module for keeping track of missed calls. This table is similar to the ‘acc’ table. More information is available at: http://www.opensips.org/html/docs/modules/1.9.x/acc.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
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.

Indexes

name	type	links	description
callid_idx	default	callid

alias db

Table “dbaliases”

This table us used by the alias_db module as an alternative for user aliases via userloc. More information about the alias_db module can be found at: http://www.opensips.org/html/docs/modules/1.9.x/alias_db.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
alias_username	string	64	”	no	Alias username / phone number
alias_domain	string	64	”	no	Alias domain name
username	string	64	”	no	Username / phone number
domain	string	64	”	no	Domain name

Indexes

name	type	links	description
alias_idx	unique	alias_username, alias_domain
target_idx	default	username, domain

Subscriber

Table “subscriber”

This table is used to provide authentication information. More information about the auth_db module can be found at: http://www.opensips.org/html/docs/modules/1.9.x/auth_db.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	Unique ID	primary	autoincrement
username	string	64	”	no	Username / phone number
domain	string	64	”	no	Domain name
password	string	25	”	no	Password
email_address	string	64	”	no	Email address
ha1	string	64	”	no	md5(username:realm:password)
ha1b	string	64	”	no	md5(username@domain:realm:password)
rpid	string	64	NULL	yes	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.

Indexes

name	type	links	description
account_idx	unique	username, domain
username_idx	default	username

AVP Operations

Table “usr_preferences”

This table us used by the avpops module to implement Attribute Value Pairs (AVP’s). More information about the avpops module can be found at: http://www.opensips.org/html/docs/modules/1.9.x/avpops.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	Unique ID	primary	autoincrement
uuid	string	64	”	no	Unique user ID
username	string	128	0	no	Username / phone number
domain	string	64	”	no	Domain name
attribute	string	32	”	no	AVP attribute
type	int	11	0	no	AVP type
value	string	128	”	no	AVP value
last_modified	datetime	not specified	’1900-01-01 00:00:01’	no	Date and time when this record was last modified.

Indexes

name	type	links	description
ua_idx	default	uuid, attribute
uda_idx	default	username, domain, attribute
value_idx	default	value

B2BUA

Table “b2b_entities”

Table for the b2b_entities module. More information can be found at: http://www.opensips.org/html/docs/modules/1.9.x/b2b_entities.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	Unique ID	primary	autoincrement
type	int	2	default	no	Entity type: 0-server, 1-client
state	int	2	default	no	Dialog state
ruri	string	128	default	yes	RURI(stored only for server entities to correctly match CANCEL)
from_uri	string	128	default	no	From URI
to_uri	string	128	default	no	To URI
from_dname	string	64	default	yes	From display name
to_dname	string	64	default	yes	To display name
tag0	string	64	default	no	TO tag
tag1	string	64	default	yes	From tag
callid	string	64	default	no	Call ID
cseq0	int	11	default	no	Cseq0
cseq1	int	11	default	yes	Cseq1
contact0	string	128	default	no	Contact0
contact1	string	128	default	yes	Contact1
route0	text	not specified	default	yes	Record route 0
route1	text	not specified	default	yes	Record route 1
sockinfo_srv	string	64	default	yes	Socket Info
param	string	128	default	no	Logic parameter
lm	int	11	default	no	Last method
lrc	int	11	default	yes	Last reply code
lic	int	11	default	yes	Last invite cseq
leg_cseq	int	11	default	yes	Leg cseq
leg_route	text	not specified	default	yes	Leg route
leg_tag	string	64	default	yes	Leg tag
leg_contact	string	128	default	yes	Leg contact
leg_sockinfo	string	128	default	yes	Leg sockinfo

Indexes

name	type	links	description
b2b_entities_idx	unique	type, tag0, tag1, callid
b2b_entities_param	default	param

Table “b2b_logic”

Table for the b2b_logic module. More information can be found at: http://www.opensips.org/html/docs/modules/1.9.x/b2b_logic.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	Unique ID	primary	autoincrement
si_key	string	64	default	no	Scenario instantiation key
scenario	string	64	default	no	Scenario id
sstate	int	2	default	no	Scenario State
next_sstate	int	2	default	no	Next Scenario State
sparam0	string	64	default	yes	Scenario id
sparam1	string	64	default	yes	Scenario id
sparam2	string	64	default	yes	Scenario id
sparam3	string	64	default	yes	Scenario id
sparam4	string	64	default	yes	Scenario id
sdp	text	64	default	yes	Scenario id
lifetime	int	10	0	no	Lifetime
e1_type	int	2	default	no	E1 type
e1_sid	string	64	default	no	E1 Scenario ID
e1_from	string	128	default	no	E1 From URI
e1_to	string	128	default	no	E1 To URI
e1_key	string	64	default	no	E1 Key
e2_type	int	2	default	no	E2 type
e2_sid	string	64	default	no	E2 Scenario ID
e2_from	string	128	default	no	E2 From URI
e2_to	string	128	default	no	E2 To URI
e2_key	string	64	default	no	E2 Key
e3_type	int	2	default	yes	E3 type
e3_sid	string	64	default	yes	E3 Scenario ID
e3_from	string	128	default	yes	E3 From URI
e3_to	string	128	default	yes	E3 To URI
e3_key	string	64	default	yes	E3 Key

Indexes

name	type	links	description
b2b_logic_idx	unique	si_key

CacheDB_SQL

Table “cachedb”

DB implementation of the CacheDB interface: http://www.opensips.org/html/docs/modules/1.9.x/cachedb_sql.html

name	type	size	default	null	description	key	extra attributes
keyname	string	255	default	no	The Key
value	text	512	default	no	The value
counter	int	10	0	no	The value of the counter
expires	unsigned int	10	0	no	The unix timestamp when the key will expires

carrierroute

Table “carrierroute”

This table is used by the carrierroute module to provides routing, balancing and blacklisting capabilities. More information is available at: http://www.opensips.org/docs/modules/devel/carrierroute.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
carrier	unsigned int	10	0	no	This column contains the carrier id.
domain	string	64	”	no	This column contains the route domain. Additional domains could be used for example as fallback.
scan_prefix	string	64	”	no	This column contains the scan prefix, which define the matching portion of a phone number.
flags	unsigned int	11	0	no	This column contains the flags used for rule matching.
mask	unsigned int	11	0	no	This column contains the mask that is applied to the message flags before rule matching.
prob	float	not specified	0	no	Name of column containing the probability. The probability value is used to distribute the traffic between several gateways.
strip	unsigned int	11	0	no	Name of the column containing the number of digits to be stripped of the userpart of an URI before prepending rewrite_prefix.
rewrite_host	string	128	”	no	Name of column containing rewrite prefixes. Here you can define a rewrite prefix for the localpart of the SIP URI.
rewrite_prefix	string	64	”	no	Rewrite prefix for the localpart of the SIP URI.
rewrite_suffix	string	64	”	no	Rewrite suffix for the localpart of the SIP URI.
description	string	255	NULL	yes	A comment for the route entry, useful for larger routing tables.

Table “carrierfailureroute”

This table is used by the carrierroute module to provide failure routing capabilities. More information is available at: http://www.opensips.org/docs/modules/devel/carrierroute.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
carrier	unsigned int	10	0	no	This column contains the carrier id.
domain	string	64	”	no	This column contains the route domain. Additional domains could be used for example as fallback.
scan_prefix	string	64	”	no	This column contains the scan prefix, which define the matching portion of a phone number.
host_name	string	128	”	no	This column contains the routing destination used for rule matching.
reply_code	string	3	”	no	This column contains the reply code used for rule matching.
flags	unsigned int	11	0	no	This column contains the flags used for rule matching.
mask	unsigned int	11	0	no	This column contains the mask that is applied to the message flags before rule matching.
next_domain	string	64	”	no	This column contains the route domain that should be used for the next routing attempt.
description	string	255	NULL	yes	A comment for the route entry, useful for larger routing tables.

Table “route_tree”

This table is used by the carrierroute module to provides routing, balancing and blacklisting capabilities. More information is available at: http://www.opensips.org/html/docs/modules/1.9.x/carrierroute.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
carrier	string	64	NULL	yes	This column contains the carrier name.

Accounting

Table “closeddial”

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/1.9.x/closeddial.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
username	string	64	”	no	Username / phone number
domain	string	64	”	no	Domain name
cd_username	string	64	”	no	Closed dial username
cd_domain	string	64	”	no	Closed dial domain
group_id	string	64	”	no	Attribute use to group usernames
new_uri	string	128	”	no	New URI

Indexes

name	type	links	description
cd_idx1	unique	username, domain, cd_domain, cd_username, group_id
cd_idx2	default	group_id
cd_idx3	default	cd_username
cd_idx4	default	username

Call-processing language

Table “cpl”

Table for the call processing language “cpl” module. More information is available at: http://www.opensips.org/html/docs/modules/1.9.x/cpl-c.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	Unique ID	primary	autoincrement
username	string	64	default	no
domain	string	64	”	no
cpl_xml	text	not specified	default	yes
cpl_bin	text	not specified	default	yes

Indexes

name	type	links	description
account_idx	unique	username, domain

Dialog support

Table “dialog”

Persistent dialog information for the dialog module. More information can be found at: http://www.opensips.org/html/docs/modules/1.9.x/dialog.html

name	type	size	default	null	description	key	extra attributes
dlg_id	unsigned long	10	default	no	h_entry | h_id	primary
callid	string	255	default	no	Call-ID of the dialog
from_uri	string	128	default	no	The URI of the FROM header (as per INVITE)
from_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.
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.
vars	text	512	NULL	yes	Variables attached to this dialog.
profiles	text	512	NULL	yes	Profiles this dialog belongs to.
script_flags	unsigned int	10	0	no	Script flags for the dialog.
flags	unsigned int	10	0	no	Internal flags used by the module.

Matching and translation rules

Table “dialplan”

This table is used by the dialplan module for the translation rules. More information is available at: http://www.opensips.org/html/docs/modules/1.9.x/dialplan.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
dpid	int	11	default	no	Dialplan ID.
pr	int	11	default	no	Priority of rule.
match_op	int	11	default	no	Matching operator for rule (0-equal, 1-regexp).
match_exp	string	64	default	no	Matching expresion (regexp or string).
match_flags	int	11	default	no	Matching flags (0-case sensitive, 1-case insensitive).
subst_exp	string	64	default	no	Substitution expresion.
repl_exp	string	32	default	no	Replacement expresion (sed like).
disabled	int	11	0	no	Specifies if the command can be used, or is disabled.
attrs	string	32	default	no	General attributes string to be returned in case of rule matching.

Dispatcher

Table “dispatcher”

This table is used by the dispatcher module. It contains the sets of destinations used for load balancing and dispatching. More information about the dispatcher module can be found at: http://www.opensips.org/html/docs/modules/1.9.x/dispatcher.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
setid	int	not specified	0	no	Destination set id
destination	string	192	”	no	Destination SIP address
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.
flags	int	not specified	0	no	Flags of destination SIP address
weight	int	not specified	1	no	The weight of the destination
attrs	string	128	”	no	Attribute string - custom, opaque string that will be pushed into script when this destination will be selected
description	string	64	”	no	Description for this destination

Domain

Table “domain”

This table is used by the domain module to determine if a host part of a URI is “local” or not. More information about the domain module can be found at: http://www.opensips.org/html/docs/modules/1.9.x/domain.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
domain	string	64	”	no	Domain name
last_modified	datetime	not specified	’1900-01-01 00:00:01’	no	Date and time when this record was last modified.

Indexes

name	type	links	description
domain_idx	unique	domain

Domainpolicy

Table “domainpolicy”

Table for the domainpolicy module. More information at http://www.opensips.org/html/docs/modules/1.9.x/domainpolicy.html.

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
rule	string	255	default	no	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”
description	string	255	default	no	Comment about the rule

Indexes

name	type	links	description
rav_idx	unique	rule, att, val
rule_idx	default	rule

Dynamic Routing

Table “dr_gateways”

This table is used by the Dynamic Routing module to store information about the destinations/gateways where to route calls. More information can be found at: http://www.opensips.org/html/docs/modules/1.9.x/drouting.html.

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	Table primary key, not used by module	primary	autoincrement
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;
description	string	128	”	no	Text description of the GW/destination

Indexes

name	type	links	description
dr_gw_idx	unique	gwid

Table “dr_rules”

This table is used by the Dynamic Routing module to store information about the routing rules. More information can be found at: http://www.opensips.org/html/docs/modules/1.9.x/drouting.html.

name	type	size	default	null	description	key	extra attributes
ruleid	unsigned int	10	default	no	Rule unique ID	primary	autoincrement
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 “dr_carriers”

This table is used by the Dynamic Routing module to define carriers (a carrier is defined by a list of gateways and an ordering rule). More information can be found at: http://www.opensips.org/html/docs/modules/1.9.x/drouting.html.

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	Table key, not used by module	primary	autoincrement
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
attrs	string	255	”	yes	Attributes string for the carrier
description	string	128	”	no	Text description of the GW list

Indexes

name	type	links	description
dr_carrier_idx	unique	carrierid

Table “dr_groups”

This table is used by the Dynamic Routing module to store information about the routing groups (users mapped over groups). More information can be found at: http://www.opensips.org/html/docs/modules/1.9.x/drouting.html.

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	Unique ID	primary	autoincrement
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

Extensions

Group checking

Table “grp”

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/1.9.x/group.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
username	string	64	”	no	Username / phone number
domain	string	64	”	no	Domain name
grp	string	64	”	no	Group name
last_modified	datetime	not specified	’1900-01-01 00:00:01’	no	Date and time when this record was last modified.

Indexes

name	type	links	description
account_group_idx	unique	username, domain, grp

Table “re_grp”

This table is used by the group module to check membership based on regular expressions. More information about the group module can be found at: http://www.opensips.org/html/docs/modules/1.9.x/group.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
reg_exp	string	128	”	no	Regular expression
group_id	int	11	0	no	Group ID

Indexes

name	type	links	description
group_idx	default	group_id

Instant Message Conference

Table “imc_rooms”

Room table for the IMC module. More information at http://www.opensips.org/html/docs/modules/1.9.x/imc.html.

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
name	string	64	default	no	Name of the room
domain	string	64	default	no	Domain of the room
flag	int	11	default	no	Flags

Indexes

name	type	links	description
name_domain_idx	unique	name, domain

Table “imc_members”

Member table for the IMC module. More information at http://www.opensips.org/html/docs/modules/1.9.x/imc.html.

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
username	string	64	default	no	Username
domain	string	64	default	no	Domain
room	string	64	default	no
flag	int	11	default	no	Flags

Indexes

name	type	links	description
account_room_idx	unique	username, domain, room

Load Balancer

Table “load_balancer”

This table is used by the Load-Balancer module to store information about the destinations the balance the calls between. More information can be found at: http://www.opensips.org/html/docs/modules/1.9.x/load_balancer.html.

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID of the destination	primary	autoincrement
group_id	unsigned int	11	0	no	The group the destination belongs to
dst_uri	string	128	default	no	Destination address as a SIP URI
resources	string	255	default	no	String with the definition of the resource provided by the destination and the capacity of each resource
probe_mode	unsigned int	11	0	no	Probing mode (0-none, 1-if disabled, 2-all the time)
description	string	128	”	no	Text description of the destination

Indexes

name	type	links	description
dsturi_idx	default	dst_uri

Message Storage

Table “silo”

This table us used by the msilo module to provide offline message storage More information about the msilo module can be found at: http://www.opensips.org/html/docs/modules/1.9.x/msilo.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
src_addr	string	128	”	no	Source address - From URI
dst_addr	string	128	”	no	Destination address - To URI
username	string	64	”	no	SIP domain of target user
domain	string	64	”	no	Username / phone number of target user
inc_time	int	not specified	0	no	Incoming time
exp_time	int	not specified	0	no	Expiration time
snd_time	int	not specified	0	no	Reminder send time
ctype	string	32	’text/plain’	no	Content type
body	binary	not specified	”	no	Body of the message

Indexes

name	type	links	description
account_idx	default	username, domain

Prefix-Domain Translation

Table “pdt”

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/1.9.x/pdt.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	Unique ID	primary	autoincrement
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.

Indexes

name	type	links	description
sdomain_prefix_idx	unique	sdomain, prefix

Permissions

Table “address”

This table is used by the permissions module. More information is available at: http://www.opensips.org/html/docs/modules/1.9.x/permissions.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
grp	unsigned short	5	0	no	Group
ip	string	50	default	no	IP address
mask	char	not specified	32	no	Network mask
port	unsigned short	5	0	no	Port
proto	string	4	’any’	no	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”.
pattern	string	64	NULL	yes	Regular expression
context_info	string	32	NULL	yes	Extra context information

Presence

Table “presentity”

Table for the presence module. More information can be found at: http://www.opensips.org/html/docs/modules/1.9.x/presence.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	Unique ID	primary	autoincrement
username	string	64	default	no	User name
domain	string	64	default	no	Domain
event	string	64	default	no	Event
etag	string	64	default	no	User name
expires	int	11	default	no	Expires
received_time	int	11	default	no	Reveived time
body	binary	not specified	default	no
extra_hdrs	binary	not specified	”	no
sender	string	128	default	no	Sender contact

Indexes

name	type	links	description
presentity_idx	unique	username, domain, event, etag

Table “active_watchers”

Table for the presence module. More information can be found at: http://www.opensips.org/html/docs/modules/1.9.x/presence.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	Unique ID	primary	autoincrement
presentity_uri	string	128	default	no	Presence URI
watcher_username	string	64	default	no	From User
watcher_domain	string	64	default	no	From Domain
to_user	string	64	default	no	To User
to_domain	string	64	default	no	To Domain
event	string	64	’presence’	no	Event description
event_id	string	64	default	yes	Event ID
to_tag	string	64	default	no	TO tag
from_tag	string	64	default	no	From tag
callid	string	64	default	no	Call ID
local_cseq	int	11	default	no	Local cseq
remote_cseq	int	11	default	no	Remote cseq
contact	string	128	default	no	Contact
record_route	text	not specified	default	yes	Record route
expires	int	11	default	no	Expires
status	int	11	2	no	Status
reason	string	64	default	no	Reason
version	int	11	0	no	Version
socket_info	string	64	default	no	Socket info
local_contact	string	128	default	no	Local contact

Indexes

name	type	links	description
active_watchers_idx	unique	presentity_uri, callid, to_tag, from_tag

Table “watchers”

Table for the presence module. More information can be found at: http://www.opensips.org/html/docs/modules/1.9.x/presence.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	Unique ID	primary	autoincrement
presentity_uri	string	128	default	no	Presentity Uri
watcher_username	string	64	default	no	Watcher User
watcher_domain	string	64	default	no	Watcher Domain
event	string	64	’presence’	no	Event description
status	int	11	default	no	Status
reason	string	64	default	yes	Reason
inserted_time	int	11	default	no

Indexes

name	type	links	description
watcher_idx	unique	presentity_uri, watcher_username, watcher_domain, event

Table “xcap”

Table for the presence module. More information can be found at: http://www.opensips.org/html/docs/modules/1.9.x/presence.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	Unique ID	primary	autoincrement
username	string	64	default	no	User name
domain	string	64	default	no	Domain
doc	binary	not specified	default	no	doc
doc_type	int	11	default	no	Document type
etag	string	64	default	no	Document Etag
source	int	11	default	no	Entity inserting the record
doc_uri	string	128	default	no	Document uri
port	int	11	default	no	XCAP server port

Indexes

name	type	links	description
account_doc_type_idx	unique	username, domain, doc_type, doc_uri
source_idx	default	source

Table “pua”

Table for the presence related pua module. More information can be found at: http://www.opensips.org/html/docs/modules/1.9.x/pua.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	Unique ID	primary	autoincrement
pres_uri	string	128	default	no	URI
pres_id	string	255	default	no	ID
event	int	11	default	no	Event
expires	int	11	default	no	Expires
desired_expires	int	11	default	no	Desired Expires
flag	int	11	default	no	Flags
etag	string	64	default	yes	Etag
tuple_id	string	64	default	yes	Tuple ID
watcher_uri	string	128	default	yes	Watcher URI
to_uri	string	128	default	yes	URI
call_id	string	64	default	yes	Call ID
to_tag	string	64	default	yes	To tag
from_tag	string	64	default	yes	From tag
cseq	int	11	default	yes
record_route	text	not specified	default	yes	Record route
contact	string	128	default	yes	Contact
remote_contact	string	128	default	yes	Remote contact
version	int	11	default	yes
extra_headers	text	not specified	default	yes	Extra Headers

Registrant support

Table “registrant”

Registrant information for the uac_registrant module. More information can be found at: http://www.opensips.org/html/docs/modules/1.9.x/uac_registrant.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
registrar	string	128	”	no	URI pointing to the remote registrar.
proxy	string	128	NULL	yes	URI pointing to the outbond proxy.
aor	string	128	”	no	URI defining the address of record.
third_party_registrant	string	128	NULL	yes	URI defining the third party registrant.
username	string	64	NULL	yes	Username for authentication.
password	string	64	NULL	yes	Password for authentication.
binding_URI	string	128	”	no	Contact URI in REGISTER.
binding_params	string	64	NULL	yes	Contact params in REGISTER.
expiry	unsigned int	1	NULL	yes	Expiration time.
forced_socket	string	64	NULL	yes	socket for sending the REGISTER.

Indexes

name	type	links	description
aor_idx	unique	aor

Registrar

Table “aliases”

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/1.9.x/registrar.html. Most people uses the dbaliases table with the alias_db module now.

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
username	string	64	”	no	Alias Username / Phone Number
domain	string	64	NULL	yes	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	128	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	int	11	0	no	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

Indexes

name	type	links	description
alias_idx	unique	username, domain, contact, callid

RLS

Table “rls_presentity”

Table for the RLS module.

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	Unique ID	primary	autoincrement
rlsubs_did	string	255	default	no	Resource list subscribe dialog id
resource_uri	string	128	default	no	List Uri
content_type	string	255	default	no	Content type
presence_state	binary	not specified	default	no
expires	int	11	default	no	Expires
updated	int	11	default	no	Update flag
auth_state	int	11	default	no	Watcher authorization state
reason	string	64	default	no	reason for watcher authorization state

Indexes

name	type	links	description
rls_presentity_idx	unique	rlsubs_did, resource_uri
updated_idx	default	updated

Table “rls_watchers”

Table for RLS module used for storing resource lists subscribe information.

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	Unique ID	primary	autoincrement
presentity_uri	string	128	default	no	Presence URI
to_user	string	64	default	no	To user
to_domain	string	64	default	no	To domain
watcher_username	string	64	default	no	From user
watcher_domain	string	64	default	no	From domain
event	string	64	’presence’	no	Event description
event_id	string	64	default	yes	Event ID
to_tag	string	64	default	no	To tag
from_tag	string	64	default	no	From tag
callid	string	64	default	no	Call ID
local_cseq	int	11	default	no	Local cseq
remote_cseq	int	11	default	no	Remote cseq
contact	string	64	default	no	Contact
record_route	text	not specified	default	yes	Record route
expires	int	11	default	no	Expires
status	int	11	2	no	Status
reason	string	64	default	no	Reason
version	int	11	0	no	Version
socket_info	string	64	default	no	Socket info
local_contact	string	128	default	no	Local contact

Indexes

name	type	links	description
rls_watcher_idx	unique	presentity_uri, callid, to_tag, from_tag

RTPProxy

Table “rtpproxy_sockets”

This table is used by the NAT Helper module to store definitions of socket(s) used to connect to (a set) RTPProxy. More information can be found at: http://www.opensips.org/html/docs/modules/1.9.x/nathelper.html.

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	Unique ID	primary	autoincrement
rtpproxy_sock	text	not specified	default	no	A list of sockets use to connect to a set of RTPProxy. Example: “udp:localhost:12221 udp:localhost:12222”.
set_id	unsigned int	10	default	no	The ID of the RTPProxy set.

SIPtrace

Table “sip_trace”

This table is used to store incoming/outgoing SIP messages in database. More informations can be found in the siptrace module documentation at: http://www.opensips.org/html/docs/modules/1.9.x/siptrace.html.

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
time_stamp	datetime	not specified	’1900-01-01 00:00:01’	no	Recording date
callid	string	255	”	no	call ID from SIP message
traced_user	string	128	NULL	yes	SIP URI of the user being traced
msg	text	not specified	default	no	Full SIP message
method	string	32	”	no	SIP method name
status	string	128	NULL	yes	SIP reply status
fromip	string	50	”	no	Source IP address
toip	string	50	”	no	Destination IP address
fromtag	string	64	”	no	From tag
direction	string	4	”	no	Destination IP address

Indexes

name	type	links	description
traced_user_idx	default	traced_user
date_idx	default	time_stamp
fromip_idx	default	fromip
callid_idx	default	callid

Speed dial

Table “speed_dial”

This table is used by the speeddial module to provide on-server speed dial facilities. More information about the speeddial module can be found at: http://www.opensips.org/html/docs/modules/1.9.x/speeddial.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
username	string	64	”	no	Username / phone number
domain	string	64	”	no	Domain name
sd_username	string	64	”	no	Speed dial username
sd_domain	string	64	”	no	Speed dial domain
new_uri	string	128	”	no	New URI
fname	string	64	”	no	First name
lname	string	64	”	no	Last name
description	string	64	”	no	Description

Indexes

name	type	links	description
speed_dial_idx	unique	username, domain, sd_domain, sd_username

Version

Table “version”

name	type	size	default	null	description	key	extra attributes
table_name	string	32	default	no
table_version	unsigned int	not specified	0	no

Indexes

name	type	links	description
t_name_idx	unique	table_name

SIP URI checks

Table “uri”

This table is used by uri_db module to implement various SIP URI checks. More information about the uri_db module can be found at: http://www.opensips.org/html/docs/modules/1.9.x/uri_db.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no		primary	autoincrement
username	string	64	”	no	Username / phone number
domain	string	64	”	no	Domain name
uri_user	string	64	”	no	Username / phone number
last_modified	datetime	not specified	’1900-01-01 00:00:01’	no	Date and time when this record was last modified.

Indexes

name	type	links	description
account_idx	unique	username, domain, uri_user

User and global blacklists

Table “userblacklist”

This table is used by the userblacklist module for the user specific blacklists. More information is available at: http://www.opensips.org/html/docs/modules/1.9.x/userblacklist.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
username	string	64	”	no	The user that is used for the blacklist lookup.
domain	string	64	”	no	The domain that is used for the blacklist lookup.
prefix	string	64	”	no	The prefix that is matched for the blacklist.
whitelist	char	1	0	no	Specify if this a blacklist (0) or a whitelist (1) entry.

Indexes

name	type	links	description
userblacklist_idx	default	username, domain, prefix

Table “globalblacklist”

This table is used by the userblacklist module for the global blacklists. More information is available at: http://www.opensips.org/html/docs/modules/1.9.x/userblacklist.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
prefix	string	64	”	no	The prefix that is matched for the blacklist.
whitelist	char	1	0	no	Specify if this a blacklist (0) or a whitelist (1) entry.
description	string	255	NULL	yes	A comment for the entry.

Indexes

name	type	links	description
globalblacklist_idx	default	prefix

User location

Table “location”

Persistent user location information for the usrloc module. More information can be found at: http://www.opensips.org/html/docs/modules/1.9.x/usrloc.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
username	string	64	”	no	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	int	11	0	no	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

Indexes

name	type	links	description
account_contact_idx	unique	username, domain, contact, callid