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/2.2.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) 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.

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/2.2.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.
`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)
`created`	`datetime`	not specified	NULL	yes	The call creation date and time.

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/2.2.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/2.2.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/2.2.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`	64	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
`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/2.2.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`	255	default	yes	RURI(stored only for server entities to correctly match CANCEL)
`from_uri`	`string`	255	default	no	From URI
`to_uri`	`string`	255	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`	255	default	no	Contact0
`contact1`	`string`	255	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`	255	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`	255	default	yes	Leg contact
`leg_sockinfo`	`string`	255	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/2.2.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	yes	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	yes	E1 Scenario ID
`e1_from`	`string`	255	default	no	E1 From URI
`e1_to`	`string`	255	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	yes	E2 Scenario ID
`e2_from`	`string`	255	default	no	E2 From URI
`e2_to`	`string`	255	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`	255	default	yes	E3 From URI
`e3_to`	`string`	255	default	yes	E3 To URI
`e3_key`	`string`	64	default	yes	E3 Key

Indexes

name	type	links	description
`b2b_logic_idx`	unique	si_key

SCA support

Table “b2b_sca”

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

name	type	size	default	null	description	key	extra attributes
`id`	`unsigned int`	10	default	no	unique ID	primary	autoincrement
`shared_line`	`string`	64	default	no	The shared line.
`watchers`	`string`	255	default	no	The URI list of watchers
`app1_shared_entity`	`unsigned int`	1	NULL	yes	The entity to keep.
`app1_call_state`	`unsigned int`	1	NULL	yes	The state of the appearance index.
`app1_call_info_uri`	`string`	255	NULL	yes	The URI of the Call-Info header
`app1_call_info_appearance_uri`	`string`	255	NULL	yes	The URI of the appearance in Call-Info header
`app1_b2bl_key`	`string`	64	NULL	yes	The b2b_logic key.
`app2_shared_entity`	`unsigned int`	1	NULL	yes	The entity to keep.
`app2_call_state`	`unsigned int`	1	NULL	yes	The state of the appearance index.
`app2_call_info_uri`	`string`	255	NULL	yes	The URI of the Call-Info header
`app2_call_info_appearance_uri`	`string`	255	NULL	yes	The URI of the appearance in Call-Info header
`app2_b2bl_key`	`string`	64	NULL	yes	The b2b_logic key.
`app3_shared_entity`	`unsigned int`	1	NULL	yes	The entity to keep.
`app3_call_state`	`unsigned int`	1	NULL	yes	The state of the appearance index.
`app3_call_info_uri`	`string`	255	NULL	yes	The URI of the Call-Info header
`app3_call_info_appearance_uri`	`string`	255	NULL	yes	The URI of the appearance in Call-Info header
`app3_b2bl_key`	`string`	64	NULL	yes	The b2b_logic key.
`app4_shared_entity`	`unsigned int`	1	NULL	yes	The entity to keep.
`app4_call_state`	`unsigned int`	1	NULL	yes	The state of the appearance index.
`app4_call_info_uri`	`string`	255	NULL	yes	The URI of the Call-Info header
`app4_call_info_appearance_uri`	`string`	255	NULL	yes	The URI of the appearance in Call-Info header
`app4_b2bl_key`	`string`	64	NULL	yes	The b2b_logic key.
`app5_shared_entity`	`unsigned int`	1	NULL	yes	The entity to keep.
`app5_call_state`	`unsigned int`	1	NULL	yes	The state of the appearance index.
`app5_call_info_uri`	`string`	255	NULL	yes	The URI of the Call-Info header
`app5_call_info_appearance_uri`	`string`	255	NULL	yes	The URI of the appearance in Call-Info header
`app5_b2bl_key`	`string`	64	NULL	yes	The b2b_logic key.
`app6_shared_entity`	`unsigned int`	1	NULL	yes	The entity to keep.
`app6_call_state`	`unsigned int`	1	NULL	yes	The state of the appearance index.
`app6_call_info_uri`	`string`	255	NULL	yes	The URI of the Call-Info header
`app6_call_info_appearance_uri`	`string`	255	NULL	yes	The URI of the appearance in Call-Info header
`app6_b2bl_key`	`string`	64	NULL	yes	The b2b_logic key.
`app7_shared_entity`	`unsigned int`	1	NULL	yes	The entity to keep.
`app7_call_state`	`unsigned int`	1	NULL	yes	The state of the appearance index.
`app7_call_info_uri`	`string`	255	NULL	yes	The URI of the Call-Info header
`app7_call_info_appearance_uri`	`string`	255	NULL	yes	The URI of the appearance in Call-Info header
`app7_b2bl_key`	`string`	64	NULL	yes	The b2b_logic key.
`app8_shared_entity`	`unsigned int`	1	NULL	yes	The entity to keep.
`app8_call_state`	`unsigned int`	1	NULL	yes	The state of the appearance index.
`app8_call_info_uri`	`string`	255	NULL	yes	The URI of the Call-Info header
`app8_call_info_appearance_uri`	`string`	255	NULL	yes	The URI of the appearance in Call-Info header
`app8_b2bl_key`	`string`	64	NULL	yes	The b2b_logic key.
`app9_shared_entity`	`unsigned int`	1	NULL	yes	The entity to keep.
`app9_call_state`	`unsigned int`	1	NULL	yes	The state of the appearance index.
`app9_call_info_uri`	`string`	255	NULL	yes	The URI of the Call-Info header
`app9_call_info_appearance_uri`	`string`	255	NULL	yes	The URI of the appearance in Call-Info header
`app9_b2bl_key`	`string`	64	NULL	yes	The b2b_logic key.
`app10_shared_entity`	`unsigned int`	1	NULL	yes	The entity to keep.
`app10_call_state`	`unsigned int`	1	NULL	yes	The state of the appearance index.
`app10_call_info_uri`	`string`	255	NULL	yes	The URI of the Call-Info header
`app10_call_info_appearance_uri`	`string`	255	NULL	yes	The URI of the appearance in Call-Info header
`app10_b2bl_key`	`string`	64	NULL	yes	The b2b_logic key.

Indexes

name	type	links	description
`sca_idx`	unique	shared_line

CacheDB_SQL

Table “cachedb”

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

name	type	size	default	null	description	key
`keyname`	`string`	255	default	no	The Key	primary
`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

Call Center

Table “cc_flows”

This table is used by the Call Center module to store the definition of the call queues / flows. More information can be found at: http://www.opensips.org/html/docs/modules/2.2.x/call_center.html.

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

Indexes

name	type	links	description
`unique_flowid`	unique	flowid

Table “cc_agents”

This table is used by the Call Center module to store the definition of the agents serving the flows/queues. More information can be found at: http://www.opensips.org/html/docs/modules/2.2.x/call_center.html.

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

Indexes

name	type	links	description
`unique_agentid`	unique	agentid

Table “cc_cdrs”

This table is used by the Call Center module to store the Call Data Records (CDRs) for all the handled calls. More information can be found at: http://www.opensips.org/html/docs/modules/2.2.x/call_center.html.

name	type	size	default	null	description	key	extra attributes
`id`	`unsigned int`	10	default	no	CDR unique ID in DB	primary	autoincrement
`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 “cc_calls”

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.

name	type	size	default	null	description	key	extra attributes
`id`	`unsigned int`	10	default	no	unique ID of the call.	primary	autoincrement
`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.
`flow`	`string`	128	default	no	The flow/queue this call belongs to.
`agent`	`string`	128	default	no	The agent that handles the call.

Indexes

name	type	links	description
`unique_id`	unique	b2buaid
`b2buaid_idx`	default	b2buaid

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/html/docs/modules/2.2.x/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`	255	”	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/html/docs/modules/2.2.x/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`	255	”	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”

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/2.2.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`	255	”	no	New URI

Indexes

name	type	links
`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

Clusterer support

Table “clusterer”

This table is used for defining clusters of OpenSIPS instances.

name	type	size	default	null	description	key	extra attributes
`id`	`int`	10	default	no	unique ID	primary	autoincrement
`cluster_id`	`int`	10	default	no	unique identifier for a cluster
`machine_id`	`int`	10	default	no	unique identifier for a machine (a node in a cluster)
`url`	`string`	64	default	no	network location of the machine, like protocol:ip:port
`state`	`int`	1	1	no	state of the machine 0 - down/ 1 - up / 2 - temporary disable
`last_attempt`	`unsigned long`	64	0	no	last time(UNIX timestamp) when a failed attempt has occurred
`failed_attempts`	`int`	10	3	no	maximum number of failed attempts
`no_tries`	`int`	10	0	no	number of failed tries before auto-disabling
`duration`	`int`	10	30	no	tempory disabled state duration(seconds)
`description`	`string`	64	default	yes	opaque text not used by the module

Indexes

name	type	links	description
`clusterer_idx`	unique	cluster_id, machine_id

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/2.2.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/2.2.x/dialog.html

name	type	size	default	null	description	key
`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`	255	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`	255	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`	255	default	yes	Caller’s contact uri.
`callee_contact`	`string`	255	default	yes	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`	`binary`	4096	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.
`module_flags`	`unsigned int`	10	0	no	Module 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/2.2.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 expression (regexp or string).
`match_flags`	`int`	11	default	no	Matching flags (0-case sensitive, 1-case insensitive).
`subst_exp`	`string`	64	default	yes	Substitution expression.
`repl_exp`	`string`	32	default	yes	Replacement expression (sed like).
`timerec`	`string`	255	default	yes	Time recurrence used to match this rule.
`disabled`	`int`	11	0	no	Specifies if the command can be used, or is disabled.
`attrs`	`string`	32	default	yes	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/2.2.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.
`state`	`int`	not specified	0	no	The state of the destination (0 enabled, 1 disabled , 2 probing)
`weight`	`int`	not specified	1	no	The weight of the destination
`priority`	`int`	not specified	0	no	The priority of each destination (only useful with algorithm 8)
`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/2.2.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
`attrs`	`string`	255	NULL	yes	Domain Attributes
`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/2.2.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/2.2.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 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

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/2.2.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/2.2.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
`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

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/2.2.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

Table “dr_partitions”

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.

name	type	size	default	null	description	key	extra attributes
`id`	`unsigned int`	10	default	no	Partition unique ID	primary	autoincrement
`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).
`ruri_avp`	`string`	255	default	yes	The name of ruri_avp AVP.
`gw_id_avp`	`string`	255	default	yes	The name of gw_id_avp AVP
`gw_priprefix_avp`	`string`	255	default	yes	The name of gw_priprefix_avp AVP.
`gw_sock_avp`	`string`	255	default	yes	The name of gw_sock_avp AVP.
`rule_id_avp`	`string`	255	default	yes	The name of rule_id_avp AVP.
`rule_prefix_avp`	`string`	255	default	yes	The name of rule_prefix_avp AVP.
`carrier_id_avp`	`string`	255	default	yes	The name of carrier_id_avp AVP.

Emergency

Table “emergency_routing”

This table is used by the Emergency module to translate ERT informations in ESGWRI. More information can be found at: http://www.opensips.org/html/docs/modules/2.2.x/emergency.html.

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

This table is used by the Emergency module to save information associated with a emergency call, for trouble shooting purposes. More information can be found at: http://www.opensips.org/html/docs/modules/2.2.x/emergency.html.

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

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.

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

Extensions

Fraud Detection

Table “fraud_detection”

This table is used by the Fraud Detection module to store information about fraud-profiles. More information can be found at: http://www.opensips.org/html/docs/modules/2.2.x/fraud_detection.html.

name	type	size	default	null	description	key	extra attributes
`ruleid`	`unsigned int`	10	default	no	Rule unique ID	primary	autoincrement
`profileid`	`unsigned int`	not specified	default	no	The ID of the profile the current rule is part of
`prefix`	`string`	64	default	no	Numerical prefix to match this rule
`start_hour`	`string`	5	default	no	Start of the interval in which the rule should be matched.
`end_hour`	`string`	5	default	no	End of the interval in which the rule should be matched.
`daysoftheweek`	`string`	64	default	no	List/interval of days in which the rule is available.
`cpm_warning`	`unsigned int`	5	default	no	Warning threshold for calls per minute.
`cpm_critical`	`unsigned int`	5	default	no	Crtical threshold for calls per minute.
`call_duration_warning`	`unsigned int`	5	default	no	Warning threshold for calls per minute.
`call_duration_critical`	`unsigned int`	5	default	no	Crtical threshold for call duration.
`total_calls_warning`	`unsigned int`	5	default	no	Warning threshold for total calls.
`total_calls_critical`	`unsigned int`	5	default	no	Crtical threshold for total calls.
`concurrent_calls_warning`	`unsigned int`	5	default	no	Warning threshold for concurrent calls.
`concurrent_calls_critical`	`unsigned int`	5	default	no	Crtical threshold for concurrent calls.
`sequential_calls_warning`	`unsigned int`	5	default	no	Warning threshold for sequential calls.
`sequential_calls_critical`	`unsigned int`	5	default	no	Crtical threshold for sequential calls.

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/2.2.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/2.2.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/2.2.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/2.2.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/2.2.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/2.2.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`	255	”	no	Source address - From URI
`dst_addr`	`string`	255	”	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`	255	NULL	yes	Content type
`body`	`binary`	not specified	NULL	yes	Body of the message

Indexes

name	type	links	description
`account_idx`	default	username, domain

Permissions

Table “address”

This table is used by the permissions module. More information is available at: http://www.opensips.org/html/docs/modules/2.2.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	The group ID - each address may belong to a group/set
`ip`	`string`	50	default	no	IP address, IPv4 or IPv6 format
`mask`	`char`	not specified	32	no	Network mask, a number from 0 to 128; It should be up to 32 if the IP is v4 and up to 128 if the IP is v6
`port`	`unsigned short`	5	0	no	Port number, 0 value meaning ‘any’ (wildcard)
`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	A shell wildcard pattern to be used for matching string provided by the check address functions.
`context_info`	`string`	32	NULL	yes	Extra context information, not used by OpenSIPS, but simply exposed to the script level via scripting variables

Presence

Table “presentity”

Table for the presence module. More information can be found at: http://www.opensips.org/html/docs/modules/2.2.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	NULL	yes
`extra_hdrs`	`binary`	not specified	NULL	yes
`sender`	`string`	255	NULL	yes	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/2.2.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`	255	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`	255	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	yes	Reason
`version`	`int`	11	0	no	Version
`socket_info`	`string`	64	default	no	Socket info
`local_contact`	`string`	255	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/2.2.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`	255	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/2.2.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`	255	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/2.2.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`	255	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`	255	default	yes	Watcher URI
`to_uri`	`string`	255	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`	255	default	yes	Contact
`remote_contact`	`string`	255	default	yes	Remote contact
`version`	`int`	11	default	yes
`extra_headers`	`text`	not specified	default	yes	Extra Headers

Indexes

name	type	links
`del1_idx`	default	pres_uri, event
`del2_idx`	default	expires
`update_idx`	default	pres_uri, pres_id, flag, event

Registrant support

Table “registrant”

Registrant information for the uac_registrant module. More information can be found at: http://www.opensips.org/html/docs/modules/2.2.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`	255	”	no	URI pointing to the remote registrar.
`proxy`	`string`	255	NULL	yes	URI pointing to the outbond proxy.
`aor`	`string`	255	”	no	URI defining the address of record.
`third_party_registrant`	`string`	255	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`	255	”	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/2.2.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	”	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`	255	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

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`	255	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`	255	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`	255	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/2.2.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/2.2.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
`trace_attrs`	`string`	255	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`	255	NULL	yes	SIP reply status
`from_proto`	`string`	5	default	no	Source protocol
`from_ip`	`string`	50	”	no	Source IP address
`from_port`	`unsigned int`	5	default	no	Source port
`to_proto`	`string`	5	default	no	Destination protocol
`to_ip`	`string`	50	”	no	Destination IP address
`to_port`	`unsigned int`	5	default	no	Destination port
`fromtag`	`string`	64	”	no	From tag
`direction`	`string`	4	”	no	Destination IP address

Indexes

name	type	links
`trace_attrs_idx`	default	trace_attrs
`date_idx`	default	time_stamp
`fromip_idx`	default	from_ip
`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/2.2.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`	255	”	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

TLS_MGM support

Table “tls_mgm”

This table is used for defining domains.

name	type	size	default	null	description	key
`id`	`string`	64	default	no	unique ID	primary
`address`	`string`	64	default	no	network location, like: “ip:port” or “name”
`type`	`int`	1	default	no	specifies the type of a domain : client domain(0) or server domain (1)
`method`	`string`	16	default	yes	SSL method used by a certain domain
`verify_cert`	`int`	1	default	yes	verify certificate: 0 - no, 1 - yes
`require_cert`	`int`	1	default	yes	require certificate: 0 - no, 1 - yes
`certificate`	`string`	255	default	yes	certificate associated with a certain domain
`private_key`	`string`	255	default	yes	private_key
`crl_check_all`	`int`	1	default	yes	check all crl: 0 -no, 1 - yes
`crl_dir`	`string`	255	default	yes	crl directory
`ca_list`	`string`	255	default	yes	CA list
`ca_dir`	`string`	255	default	yes	ca directory
`cipher_list`	`string`	255	default	yes	the list of algorithms used for authentication and encryption allowed
`dh_params`	`string`	255	default	yes	specifies the Diffie-Hellmann parameters
`ec_curve`	`string`	255	default	yes	specifies an elliptic curve which should be used for ciphers which demand an elliptic curve

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/2.2.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/2.2.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/2.2.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/2.2.x/usrloc.html

name	type	size	default	null	description	key	extra attributes
`contact_id`	`unsigned long`	10	default	no	unique ID	primary	autoincrement
`username`	`string`	64	”	no	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`	255	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